QuickBooks Cleanup in Tacoma: Warning Signs, Scope, and Next Steps

These are the ones that reliably mean something rather than the ones that just feel bad. Any single item is enough to treat current reports as provisional.

1. Reconciliations are stale. Check Reports, Reconciliation Reports in QuickBooks Online. It lists each account and the statement date of the last completed reconciliation. Beyond two months on an account you actually use, the recent picture has not been verified.
2. Reconciliations completed with adjusting entries. Open a recent reconciliation report and look at the bottom. An adjustment means the balance would not agree and the difference was absorbed rather than explained.
3. Opening Balance Equity is not zero. This account holds starting balances during setup and should empty out. A balance means setup was never finished.
4. Undeposited Funds only grows. Payments are being recorded but never grouped into deposits that match the bank, which makes revenue timing unreliable.
5. Receivables or payables are negative. Usually payments applied without matching invoices or bills, or applied to the wrong ones.
6. Prior-period reports change.Run last quarter's profit and loss twice a month apart. Different numbers mean closed periods are still being edited.
7. Your CPA said the books need work. The most direct signal there is. Ask which accounts and which periods — that answer is the cleanup scope.

Worth knowing: a file can look completely current and still fail every one of these tests, because bank feeds fill the register whether or not anyone verifies it. Why QuickBooks can look current while the books are not reconciled covers how that happens.

Cleanup is project work with a defined start, scope, and end. It generally includes:

• Historical categorization. Transactions in the periods in scope reviewed and assigned properly rather than left where an automated rule put them.
• Reconciliation against statements. Every bank, credit card, loan, and merchant account, period by period.
• Discrepancy resolution. Differences between books and bank identified and explained rather than absorbed.
• Chart of accounts cleanup. Duplicate, unused, and misleading accounts consolidated so reports read clearly.
• Prior-period corrections within the agreed scope.
• Documentation. A summary of what was found and fixed, in a form your CPA can work from.

What it does not include: tax preparation, amended returns, prior-year adjustments originally handled by someone else, attestation, or audit-readiness certification.

Because Washington taxes gross receipts rather than income, the receipts figure on your excise return comes straight out of the books, and there is nothing downstream to correct an error in it. The Washington excise records rhythm covers how those records should be kept. For a Tacoma cleanup it means checking three things: gross receipts are traceable by classification, sales tax collected sits in a liability account rather than in income, and payments to the DOR are recorded against the periods they were meant to cover.

Those three are where cleanup most often uncovers something. Sales tax absorbed into revenue is common and it overstates income while understating what the business owes. Where a cleanup surfaces a gap between the books and what was filed, that goes to your CPA, not to us. Our Washington sales tax guide covers how to structure these records going forward.

Anyone quoting a duration before looking at the file is guessing. What can be described is what moves the range: how many periods are behind, transaction volume per month, how many accounts need reconciling, whether source statements are on hand or must be requested, whether prior reconciliations were forced with adjusting entries, and how much personal activity has to be separated out.

A single behind quarter on a low-volume file is short work. Larger cleanups can run three months or longer. The variable that most often decides which end of the range a project lands on is response time on open questions, because some transactions can only be identified by the person who made them.

The catch-up scope and timeline guide covers this in more depth, including what changes when the file is more than two years behind.

Administrator access to the QuickBooks file, bank and credit card statements for every period and account in scope, loan statements and amortization schedules, merchant processor reports, payroll reports from your provider, filed Washington excise returns for the periods involved, and the last tax return your CPA prepared.

Add a short note on anything unusual during the period. An equipment purchase, an owner draw, a one-time settlement. Context you can supply in a sentence can otherwise turn into hours of reconstruction and still end up on a list of open questions.

The review generally points to one of three paths.

A short correction

Accounts reconcile, the balance sheet holds up, and the issue is a contained set of miscategorized transactions. This is a matter of days rather than a project.

A cleanup project

Reconciliations are stale, adjusting entries have accumulated, or the balance sheet carries unexplained balances. The history needs rebuilding to a reconciled baseline before anything built on it is worth reading. That is cleanup and catch-up bookkeeping.

A support problem rather than a file problem

Sometimes the file is fine and the real issue is that nobody owns the month, or that the arrangement fits a smaller version of the business. Signs you have outgrown your bookkeeper covers that pattern, and cleanup or monthly bookkeeping covers how to sequence the two when you need both.