The short answer: A balance sheet cleanup reconciles every account balance to independent evidence, then corrects the ledger with dated journal entries rather than direct edits to closed periods. Across the modelled file below, five accounts carry $304,848 of unsupported balance against $6.8M of annual revenue.
- A negative cash balance is a recording failure, not a banking event, and the reconciliation isolates which side created it.
- Receivables carry two separate write-off standards: a GAAP allowance for expected credit losses, and a tax deduction limited to debts documented as worthless.
- Payables aged beyond a year split three ways: duplicates to reverse, obligations still owed, and forgiven amounts that become taxable income for an accrual-basis filer.
- Uncashed vendor checks belong to the state after the statutory dormancy period, so removing them from the ledger does not extinguish the obligation.
- Retained earnings diverges from prior-year financials whenever an entry lands in a closed period, and the reconciliation must name every entry.
Last updated September 2026.
Most cleanup projects begin with the income statement, because that is where owners notice the distortion. The balance sheet is where the distortion originates. An account balance nobody can explain has been accumulating error for years, and every monthly report inherits it.
The account-by-account method below follows a modelled Tampa specialty distributor generating $6.8M in annual revenue on the accrual basis. Its books close August 31, 2026. Each figure is illustrative, and the arithmetic appears in full so every correction remains traceable.
What does a balance sheet cleanup actually fix?
A balance sheet cleanup proves each balance against a source outside the accounting system, then corrects what the evidence contradicts. Cash reconciles to a bank statement. Receivables reconcile to invoices a customer acknowledges. Every other account follows the same discipline.
Sequence matters. Cash anchors the file, because a receipt misposted to cash distorts revenue, receivables, and the suspense account simultaneously. Work down the balance sheet in liquidity order.
| Account | Modelled balance | Evidence it must agree with | Typical cause of the variance |
|---|---|---|---|
| Operating cash | ($18,440) | Bank statement plus outstanding items | Bank feed matched a payment twice |
| Undeposited funds | $41,275 | Deposit slips cleared by the bank | Receipts recorded twice, once as a deposit |
| Accounts receivable | $1,284,600 | Customer-confirmed open invoices | Payments applied to the wrong invoice |
| Accounts payable | $612,400 | Vendor statements | Bills paid outside the payables module |
| Suspense | $73,900 | Receipts and contracts per transaction | Unclassified activity never revisited |
| Retained earnings | $1,942,700 | Prior-year financials or tax return | Entries posted into a closed year |
Those six accounts explain most cleanup findings. The sections below work through the arithmetic behind each one.
How do you fix a negative bank balance in QuickBooks?
Reconcile the account first, then correct the specific transactions the reconciliation identifies. A negative ledger balance almost never reflects an overdrawn bank account. It reflects payments the ledger recorded and receipts it did not.
The modelled company’s operating cash shows ($18,440) while the August bank statement reports $63,720. The reconciliation distributes that $82,160 variance across two populations:
- Duplicate expense entries totaling $54,300, created when bank feed transactions were accepted alongside manually entered checks.
- Customer deposits totaling $27,860 that cleared the bank but were never recorded in the ledger.
The proof runs in one line: ($18,440) plus $54,300 plus $27,860 equals $63,720, the statement balance. Our worked bank reconciliation example demonstrates the same mechanics on a clean file.
Delete the duplicates rather than offsetting them. An offsetting entry preserves both the phantom expense and its correction, and every subsequent analyst must reconstruct why.
What should you do with old uncollected accounts receivable?
Estimate an allowance for the whole portfolio under GAAP, and charge off individually documented debts for tax. The two calculations produce different numbers, and both belong in the cleanup.
FASB Accounting Standards Update 2016-13 replaced the incurred loss methodology “with a methodology that reflects expected credit losses,” and its amendments reach trade receivables directly. Loss rates therefore apply to current invoices, not only to delinquent ones.
| Aging bucket | Balance | Expected loss rate | Allowance |
|---|---|---|---|
| Current | $912,500 | 0.4% | $3,650 |
| 31–60 days | $186,500 | 1.8% | $3,357 |
| 61–90 days | $64,800 | 6.5% | $4,212 |
| 91–365 days | $24,700 | 22.0% | $5,434 |
| Over 365 days | $96,100 | 85.0% | $81,685 |
| Total | $1,284,600 | — | $98,338 |
How much of a receivable write-off is actually deductible?
Only the portion documented as worthless, invoice by invoice. The allowance is an estimate, and an estimate is not deductible. IRS Publication 334 instructs that “Generally, you must use the specific charge-off method.”
Of the $96,100 aged beyond a year, collection files document $71,850 as worthless. The remaining $24,250 stays open, because a disputed invoice is a collection problem rather than a worthless debt.
Three conditions govern the deduction. The receivable must already have been included in gross income, which an accrual-basis filer satisfies at invoicing and a cash-basis filer never does.
The debt must also have become worthless in the year claimed. IRS Topic no. 453 sets that standard by evidence rather than by age: a debt becomes worthless “when the surrounding facts and circumstances indicate there’s no reasonable expectation that the debt will be repaid.” Collection correspondence, a returned demand letter, or a dissolved debtor entity all serve as proof.
The third condition applies to partial write-offs. Where a debt is only partly worthless, the deduction is “limited to the amount you charged off on your books during the year.” The book entry must therefore precede the return.
Book and tax consequently diverge by $26,488. That difference belongs in the deferred tax workpaper rather than in a revised allowance.
What should you do with accounts payable that is years old?
Confirm each balance against a vendor statement before touching it. Stale payables look identical on an aging report and carry three different outcomes. The modelled file holds $37,900 across 14 bills aged beyond a year.
- $19,400 across 6 bills was already paid by ACH and recorded against a different bill. Reversing the duplicate liability produces no income and no deduction.
- $12,180 across 5 bills remains genuinely owed. Of that, $8,940 sits in vendor checks issued during 2020 and 2021 that were never cashed.
- $6,320 across 3 bills was forgiven in writing by a vendor that closed its account.
The forgiven $6,320 is taxable. Publication 334 treats a canceled trade payable as income for an accrual-method taxpayer, “because the expense was deductible when you incurred the debt.” At a 21% federal corporate rate, clearing that balance costs $1,327 in tax.
The uncashed checks raise a different obligation. Under Florida Statutes section 717.102, “the dormancy period is 5 years from the date the property becomes payable or distributable,” after which the funds are presumed abandoned and belong to the state.
Section 717.117 then governs the handoff. It requires written notice to the payee between 90 and 180 days before filing, a second certified notice for any item above $1,000, and a report filed before May 1 covering the preceding calendar year. Three of the nine checks, totaling $7,215, trigger the certified notice. Late reporting costs $10 per day to a $500 maximum.
What is a suspense account, and why is money stuck in it?
A suspense account holds transactions the bookkeeper could not classify, pending a decision someone else has to make. It functions as a queue. Left unworked, it becomes a permanent asset balance nobody owns.
The modelled file carries $73,900 across 214 transactions. Reviewing the underlying receipts redistributes the balance:
- $48,200 of operating expenses, deductible in the year incurred.
- $17,600 of owner distributions, which belong in equity and were never deductible.
- $6,300 of equipment purchases requiring capitalization and depreciation.
- $1,800 still unidentified, held pending documentation.
Reclassifying the $48,200 reduces reported pretax income by 0.71% of revenue. Owners frequently read that as a new problem. It is the correction of an old one, and the prior margin was overstated by the same amount.
Undeposited funds behaves as a second suspense account. Of the $41,275 sitting there, $38,910 duplicates deposits already booked straight to income, which overstated revenue by 0.57%. The cleanup sequence in our step-by-step QuickBooks cleanup guide clears both queues before any report is issued.
Why doesn’t retained earnings match last year’s financials?
Retained earnings diverges whenever an entry posts into a period the financials already reported. The account is the cumulative result of every prior year, so a single backdated entry rewrites history.
The modelled file opens fiscal 2026 with retained earnings of $1,942,700. The prior-year financial statements report $1,930,150. The $12,550 difference resolves into four journal entries dated into the closed year after those statements were issued: $9,400 of accrued bonuses, $2,200 of depreciation, $1,750 of a vendor accrual, and an $800 credit reversing a duplicate entry.
Name each entry in a reconciliation schedule, then decide whether it was correct. A correct entry means the prior-year statements require revision. An incorrect entry gets reversed in the current period. Closing the books and restricting the date is what prevents the next occurrence.
How do you keep a balance sheet clean after the cleanup?
Convert each cleanup finding into a recurring monthly reconciliation. Cash, receivables, payables, and the suspense account all earn a tie-out with a named preparer and a completion date. Aaron Ressel reviews every balance sheet reconciliation before the close packet leaves the firm, which is the control the Continuous Close Method™ formalizes.
A file that reconciles monthly rarely needs a second cleanup. The month-end close checklist lists the tie-outs in the order they hold.
Frequently asked questions
How long does a balance sheet cleanup take?
Scope drives the timeline. A single year with reconciled cash typically resolves in 2 to 4 weeks. Multiple years with an unreconciled bank account, a large suspense balance, and unconfirmed receivables usually run 6 to 10 weeks, because vendor and customer confirmations depend on third-party response times.
Should you delete old transactions or write them off?
Write them off. Deleting a transaction removes it from every prior period that reported it, which changes financials already delivered to a lender or a tax preparer. A dated write-off entry in the current period preserves the audit trail and lands the adjustment in a period nobody has closed.
Does a balance sheet cleanup require amending prior tax returns?
Sometimes. An adjustment that changes prior-year taxable income, such as expenses discovered in a suspense account, may support an amended return. An adjustment that only corrects classification within the balance sheet generally does not. The decision belongs to the tax preparer, and the cleanup workpapers supply the evidence.
What is the difference between a balance sheet cleanup and catch-up bookkeeping?
Catch-up bookkeeping records transactions that were never entered. A balance sheet cleanup corrects balances that were entered incorrectly. Books that are years behind usually need both, in that order, because balances cannot be proven until the underlying activity exists in the ledger.
Who should perform the write-off entries?
A controller-level reviewer, working from documentation rather than from an aging report. Write-offs touch taxable income, equity, and prior-period reporting at once. The preparer assembles the evidence, and the reviewer approves each entry against it.
