The short answer: A monthly bookkeeping routine of seven recurring tasks keeps a cleaned-up file clean, and on the illustrative file below it takes 12.75 hours a month. Deferring categorization to year-end multiplies that labor by 2.4.
- Categorize weekly and reconcile every bank and card account monthly, so a discrepancy surfaces while its source document is still findable.
- Suspense and undeposited funds should read $0.00 at every close, because a balance in either means a decision is still pending.
- Lock each closed period. An entry dated into a closed year is the mechanism that rewrites retained earnings.
- Vendor forms and records run on their own clocks: the Form 1099-NEC reporting threshold is $2,000 for tax years beginning after 2025, and the general record retention period is 3 years.
Last updated September 2026.
A QuickBooks cleanup corrects the historical record. It leaves the habits that produced the errors untouched. A file cleaned once and then abandoned rebuilds the same backlog, because the underlying causes recur: transactions accepted without review, deposits never matched to invoices, and vendors paid without tax documentation on file.
The routine below follows a modelled Tampa professional-services firm with $8.4M in annual revenue and 1,150 bank and card transactions a month across five accounts. Every figure is illustrative, and the arithmetic appears in full so the schedule scales to another file.
Why do books get messy again after a cleanup?
Books get messy again because the same inputs keep arriving after the cleanup ends: unreviewed transactions, unmatched deposits, and entries dated into closed periods. A cleanup removes accumulated errors. It installs no control that stops new ones.
- Feed acceptance without review. Bank feeds import transactions faster than anyone reviews them, and an accepted miscategorization is indistinguishable from a correct entry on the next report.
- Deposits that never match. Receipts parked in undeposited funds accumulate until someone clears the account, and each unmatched one overstates either cash or revenue.
- Payments recorded outside the payables workflow. A bill paid by ACH and never linked leaves a liability open on the aging report.
- Edits to closed periods. One late entry dated into last year changes retained earnings, and the financials already delivered no longer agree with the ledger.
Our balance sheet cleanup guide traces each of these to the account where it lands. The routine below intercepts them before they get there.
How much does waiting until year-end actually cost?
Deferring categorization to year-end multiplies the labor by 2.4 for the illustrative firm. Each deferred item takes longer to resolve than the same item reviewed in its own month, because the receipt and the context are gone.
Assume 12% of the 1,150 monthly transactions need human judgment: a new vendor, a split payment, or a missing receipt. That is 138 items a month. Reviewed weekly, an item takes an assumed 2.5 minutes. Reconstructed a year later, the same item takes an assumed 6 minutes.
- Monthly review: 138 items × 2.5 minutes = 345 minutes, or 5.75 hours. Across 12 months, 69 hours.
- Year-end reconstruction: 138 × 12 = 1,656 items × 6 minutes = 9,936 minutes, or 165.6 hours.
- Ratio: 165.6 ÷ 69 = 2.4 times the labor.
- At an assumed $85 an hour, the routine costs $5,865 a year and reconstruction costs $14,076, a gap of $8,211.
The handling times are modelling assumptions and carry no benchmark claim, yet the conclusion survives any reasonable values, because lost documentation slows every deferred item. Reconstruction also degrades the resulting file, since unresolved items migrate into suspense.
What does a monthly bookkeeping routine include?
Seven recurring tasks keep a cleaned file clean, and each closes with a tie-out that proves a balance against evidence outside the ledger. Together they consume 12.75 hours a month at the illustrative firm.
| Task | Cadence | Tie-out that proves it | Modelled hours per month |
|---|---|---|---|
| Review and categorize the bank and card feed | Weekly | Zero uncategorized items; every flagged item has a source document | 5.75 |
| Reconcile all five bank and card accounts | Monthly | Statement ending balance equals ledger balance; difference $0.00 | 2.50 |
| Clear undeposited funds and suspense | Monthly | Both accounts at $0.00, or every remaining item itemized with an owner | 1.00 |
| Review receivables aging | Monthly | Every invoice past 60 days carries a collection note | 1.50 |
| Match payables to vendor statements | Monthly | Top 10 vendors by spend agree to their statements | 1.50 |
| Collect Form W-9 from new vendors | At onboarding | Taxpayer ID on file before the first payment | 0.25 |
| Lock the closed period | Monthly | Closing date set; opening retained earnings unchanged | 0.25 |
| Total | — | — | 12.75 |
How often should transactions be categorized and reconciled?
Categorize weekly and reconcile monthly. Weekly categorization keeps each transaction within days of its source document, and monthly reconciliation proves the ledger against a bank statement that is final.
A weekly pass at this firm covers about 265 transactions (1,150 ÷ 4.33 weeks), and with 12% requiring judgment the reviewer faces roughly 32 items, or about 80 minutes of work at 2.5 minutes apiece.
Reconciliation belongs at month-end, because a statement is final only after the period closes. Timing differences and outstanding items get their full treatment in our guide to how often to reconcile bank and account balances.
What should the month-end review catch before the period locks?
The review confirms six conditions, each a pass or fail with no judgment involved. Any failure keeps the period open until the cause is corrected.
- Zero uncategorized transactions in any account.
- A $0.00 difference on every bank and card reconciliation.
- Suspense and undeposited funds at $0.00, or every remaining item itemized.
- No negative balance in any asset account.
- Opening retained earnings equal to the prior-year closed figure.
- Accounts payable in agreement with the top 10 vendor statements.
Locking follows the review. Set the accounting system’s closing date to the last day of the reviewed month, so that any subsequent edit requires a deliberate administrative override. The lock protects retained earnings; without it, a single entry dated into a closed year rewrites the opening balance.
The month-end close checklist sequences these checks with the surrounding close tasks.
How long should bookkeeping records be kept?
The IRS sets the general retention period for business records at 3 years, with longer periods for specific situations. The routine should tag each month’s supporting documents with the longest period that could apply to them.
The IRS recordkeeping guidance sets the general period at 3 years. It extends the period to 6 years when omitted income exceeds 25% of the gross income shown on the return, and it requires employment tax records for at least 4 years after the tax is due or paid, whichever is later.
“Keep records for 7 years if you file a claim for a loss from worthless securities or bad debt deduction.” — IRS, How long should I keep records?
That period applies directly to the receivable write-offs a cleanup produces. The documentation behind a bad debt deduction outlasts the ordinary 3-year window.
Which vendor forms does the monthly routine need to collect?
A Form W-9 from every new vendor, collected before the first payment, keeps the year-end Form 1099-NEC list complete. The reporting threshold sets which payees the form covers.
The IRS instructions for Forms 1099-MISC and 1099-NEC direct a payer to file Form 1099-NEC for each person “to whom you have paid at least $2,000” for services performed by someone who is not an employee, and they state that the reporting threshold rose to $2,000 for tax years beginning after 2025 and may be adjusted for inflation beginning in calendar year 2027.
Collecting a Form W-9 before the first payment takes about 5 minutes per vendor. At this firm, 3 new vendors a month add 0.25 hours. Collecting the same forms the following January means chasing vendors who have moved on.
Should a small business use a bookkeeper all year round?
Yes, once the monthly workload exceeds what the owner can finish before each close. At this firm that workload is 12.75 hours a month, or 153 hours a year, which is nearly 4 full 40-hour work weeks.
Reconciliation and period-lock steps generate no visible output, which explains why an owner-run schedule abandons them first; assigning every tie-out to a named preparer with a completion date closes that accountability gap.
The Continuous Close Method™ turns the seven tasks above into a standing schedule instead of a project. Aaron Ressel reviews every close packet before it ships, so a failed tie-out surfaces before the period locks. The one-time recovery work sits in our QuickBooks cleanup guide and the catch-up bookkeeping sequence.
Frequently asked questions
What happens right after a QuickBooks cleanup?
The file requires a deliberate handoff to a recurring routine. The cleanup leaves reconciled balances, a zero suspense account, and a closing date on the last cleaned period. Run the full seven-task cycle once in the first month, with the preparer documenting every tie-out, so the standard is proven before anyone relies on it.
How long does the monthly routine take?
For the illustrative firm, with 1,150 transactions a month across five accounts, the routine takes 12.75 hours. Categorization review drives 5.75 of those hours, and it scales with the number of items needing judgment rather than with revenue. A file with half the volume cuts that block to about 2.9 hours.
What is the first sign the books are drifting again?
A suspense or undeposited funds balance that does not return to $0.00 at close. Both accounts are queues, so a carried balance means a decision was deferred. A reconciliation difference above $0.00 is the second early sign, and it indicates a transaction recorded on one side only.
Can an owner run the routine without a bookkeeper?
Yes, for a low-volume file. The routine is a schedule of tie-outs, and none requires a professional credential. The binding constraint is time: 12.75 hours a month for the illustrative firm. A workable division keeps the categorization pass with the owner and delegates reconciliation and the period lock to a controller-level reviewer.
Does the routine depend on QuickBooks Online?
No. The tie-outs compare ledger balances to bank statements, vendor statements, and prior-year financials, and every general ledger produces those balances. The process works identically in QuickBooks Online or NetSuite, though the location of the closing-date control differs by system.
