September 30, 2026 · Mitt Patel · 6 min read
It's the third Sunday in a row you've opened QuickBooks meaning to catch up, closed three browser tabs of bank statements instead, and gone back to actual paying work. You know roughly what you made this year. You don't know it in a way you could hand to anyone and defend.
Why the books fall behind
Bookkeeping rarely falls apart in one dramatic month. It slips a week at a time. You're busy with a job, a slow month makes it feel less urgent, then a new bank account or a card gets added and nobody sits down to enter three months of it at once. By the time you notice, "a few weeks behind" has become "since spring."
The cost isn't just the awkwardness of not knowing your numbers. It shows up in decisions you make on bad information. You might think you had a strong quarter because the bank balance looks healthy, when a chunk of that is a customer deposit you haven't finished the job for yet. You might turn down a loan you'd have qualified for, or take one you didn't need, because nobody could produce a clean profit and loss. You might pay a supplier twice, or miss that a customer never paid at all, because the transaction is sitting unreviewed in a feed with four hundred others.
The longer it sits, the harder it gets to reconstruct. Memory fades on what a $412 charge was for. Receipts get lost. A cleanup done at three months behind is a different job than one done at fourteen months behind, mostly because of how much guessing has to be replaced with actual documentation.
What a cleanup actually involves
A cleanup is not "redo everything." It's a systematic pass through every period you're missing, transaction by transaction, until the books match reality and reconcile to your bank and card statements.
Concretely, it means:
- Reconciling every account for every missing month — checking accounts, savings, credit cards, and any loan or line of credit — so the ending balance in the books matches the ending balance on the statement.
- Categorizing every transaction that's sitting uncoded or miscoded, so income and expenses land in the right accounts instead of a catch-all like "uncategorized expense."
- Matching deposits to actual income, separating real revenue from transfers between your own accounts, loan proceeds, or owner contributions that aren't income at all.
- Recording bills and payments correctly, including anything paid outside the normal flow, like a check written from a personal account for a business expense.
- Fixing duplicate or missing entries, which happen often when a bank feed double-imports a transaction or a manual entry was made and then the same transaction was imported again.
- Reviewing loans and large purchases to make sure they're recorded as what they are, such as a liability or a fixed asset, not as ordinary expenses.
- Producing clean reports at the end — profit and loss and balance sheet for the full catch-up period, so you can finally see the year as it actually happened.
A worked example
Say you're 11 months behind, from January through November. You have two bank accounts, one credit card, and a bank feed in QuickBooks Online that's been quietly importing transactions the whole time without anyone reviewing them.
A bookkeeper starts with January and works forward one month at a time. For January, the checking account shows an ending balance of $18,400 on the bank statement. In QuickBooks, the same account shows $19,150, a $750 difference in the wrong direction (books higher than the bank). Digging in, two things turn up: a $500 transfer from savings that got entered twice, and a $250 client payment that was recorded in QuickBooks but never actually deposited, because the check was lost and the client had to reissue it in February.
Once those two items are fixed and the $750 difference is cleared, January reconciles. The bookkeeper moves to February, where the same process turns up a $300 charge coded to "office supplies" that was actually a personal purchase made on the business card. That gets reclassified so it doesn't overstate expenses.
By November, all eleven months reconcile, every transaction has a category, and you have a profit and loss statement that shows what you actually made and spent each month, not just a bank balance you were guessing about.
How to set it up
- Gather access, not paperwork. Bank and credit card statements for every missing month, login access to QuickBooks Online (or whatever software you're using), and access to the bank and card accounts themselves if the feed isn't already connected.
- List every account that touches the business, including ones that don't feel like "the business account" — a personal card used for a few purchases, a savings account you moved money through, a loan you took out.
- Flag anything unusual you remember, even vaguely: a large deposit, an equipment purchase, a loan, a refund. This saves guessing later and prevents a real transaction from getting miscategorized.
- Let the bookkeeper work oldest month to newest. Reconciling out of order makes later months harder, because opening balances depend on the month before being right.
- Review the reports at the end, month by month, and flag anything that doesn't match what you remember about that period. You know your business; the bookkeeper knows the software, and the review step is where those two things meet.
The mistakes that undo it
- Doing it out of order. Skipping around by month, or trying to fix the most recent month first, makes opening balances wrong for everything after it.
- Guessing instead of asking. Coding an unfamiliar transaction to "miscellaneous" and moving on buries the problem instead of solving it. It's better to flag it and come back once you've checked.
- Ignoring the credit card. Business owners often reconcile the bank account and forget the card, which is usually where the messiest, most personal-looking charges end up.
- Not separating owner money from business money. Transfers to and from your own pocket aren't income or expenses, and mixing them in inflates or deflates what the business actually made.
- Treating the cleanup as one-and-done. A cleanup fixes the past. Without a routine going forward, the same gap opens up again in a few months.
Monthly checklist once you're caught up
- Reconcile every bank and credit card account against the statement.
- Review the bank feed for uncategorized or duplicate transactions.
- Confirm large deposits are actually income, not transfers or loan proceeds.
- Check that bills paid outside the normal flow got recorded.
- Look at the profit and loss statement and ask whether it matches what the month actually felt like.
Common questions
How far back can a cleanup go?
There's no fixed limit, but the further back you go, the more the work depends on what records still exist. Bank and card statements are usually available online for a few years; anything older may need to come from paper files or a request to the bank.
What will I need to provide?
Mainly access: statements for every account, and login access to your bookkeeping software and bank feeds. Beyond that, just your memory of anything unusual, like a large purchase or a loan, so it gets coded correctly instead of guessed at.
Is a cleanup scoped differently from ongoing bookkeeping?
Usually, yes. Ongoing monthly bookkeeping is a steady, repeatable job. A cleanup is scoped around how many months are behind, how many accounts are involved, and how messy the existing entries are, since a year with a hundred stray transactions takes longer to untangle than a year with ten.
Do I need to stop and clean up before I can use my books for anything?
Not necessarily. You can start ongoing bookkeeping going forward while a cleanup works backward through the missing months. What you shouldn't do is make decisions off the current, un-reconciled numbers in the meantime.
North Hudson Bookkeeping sets up cleanups like this for clients who are behind by a few months or a full year, and keeps things current once you're caught up. The first call is free.
