What to check before assigning a bookkeeping clean-up project

Why the initial diagnostic matters

Bookkeeping clean-up projects vary enormously in their complexity, risk profile and duration. A business whose bookkeeper departed two months ago leaves behind an orderly system requiring routine catch-up. Conversely, an enterprise with two years of unreviewed bank feeds, co-mingled personal expenses, unapplied payments, and manual journal adjustments represents an entirely different undertaking.

For CPA partners and senior practice managers, committing to clean-up engagements on an open-ended basis routinely leads to fee write-downs, missed tax deadlines and partner frustration. Before accepting or outsourcing clean-up work, conducting a disciplined pre-assignment diagnostic is essential.

1. Establish the true boundary of historical reconciliations

Never rely on a client's verbal representation that "everything was reconciled through December." Open the software and inspect the actual reconciliation reports directly in QuickBooks or Xero:

• Last Reconciled Date: Verify the actual statement ending date for each active checking, savings, payroll, and line-of-credit account.
• Reconciliation Discrepancy Reports: Inspect whether previous reconciliation balances were forced into balance by arbitrary "reconciliation discrepancy" adjustments.
• Uncleared Transactions Register: Check for uncleared checks and deposits dating back months or years. An account showing a reconciled balance that carries \$80,000 in uncleared checks from eighteen months ago is fundamentally unreconciled.

2. Audit connected merchant gateways and automated feeds

Modern businesses rarely operate through a single bank account. Point-of-sale systems (Square, Clover), merchant processors (Stripe, PayPal, Shopify Payments), and payroll providers automatically push batches into the general ledger.

When automated feeds break or are misconfigured, transactions frequently duplicate or misroute into clearing accounts. Identify all connected third-party platforms and ascertain whether gross sales or net settlements were recorded. Resolving broken third-party feeds must occur before bank accounts can be balanced.

3. Inspect balance sheet account schedules

A quick review of the balance sheet reveals the true condition of the general ledger faster than reviewing the income statement:

• Negative Balances: Negative payroll liabilities, negative credit card accounts, or negative accounts payable indicate systemic mispostings.
• Undeposited Funds / Payments to Deposit: Ensure this clearing account does not hold years of duplicate customer payments that were recorded once on invoice receipt and a second time via bank feed.
• Intercompany & Owner Balances: Review owner draws, capital contributions, and shareholder loan balances to determine whether personal expenses were routinely absorbed by the business.

4. Define the written standard of "Clean"

One of the primary causes of scope creep is a divergence in expectations between the client, the CPA firm, and the delivery team. "Clean" must be defined in writing before commencing work:

"Does the engagement require reconciling operating bank accounts only, or does it mandate full balance sheet substantiation, depreciation updates, amortisation schedules, and tied-out partner workpapers?"

Ensure the written scope explicitly lists what is included, what constitutes out-of-scope work, and the specific deliverables required (e.g. adjusted trial balance, reconciliation sign-off reports, query resolution schedule).

5. Set realistic parameters on unresolvable legacy items

In historical clean-ups stretching over multiple tax years, perfect resolution of every legacy transaction is frequently impossible. Bank records from closed accounts may be unavailable, source receipts cannot be located, or vendors no longer exist.

Establish a clear protocol for unresolvable items at the outset: rather than posting undocumented balancing adjustments, unresolvable balances should be logged with supporting notes and presented for CPA review and tax determination.