Clean up

Books months behind: what to do and how long the clean-up takes

Delaying does not only make the work worse. It makes the information worse, and old information decides nothing.

Books behind get fixed backwards, not all at once. The path is to reconcile the most recent period first, so you recover useful information in the very first month, and only then work back as far as needed. Starting from the oldest month is the mistake that stalls most projects, because you work for months before having anything that helps you decide anything.

If you are looking for someone to do this work, see our catch-up bookkeeping service. If QuickBooks is in use but full of errors, the case is a QuickBooks cleanup.

What really happens when books fall behind

The consequence everyone mentions is taxes, and it is real. But it is not the most expensive one. The most expensive is that the company spends months deciding in the dark.

  • You do not know if you are making money. A bank balance is not profit. It can be client money paid in advance, tax not yet remitted or an invoice you still have to pay.
  • You do not know which client or service is profitable. Without separated cost, all revenue looks equally good, and the client who consumes more than they pay keeps getting great service.
  • Your pricing freezes. Without real cost, adjusting price becomes a bet, and most people choose not to touch it.
  • The accountant's cost spikes. They bill by the hour, and rebuilding twelve months in February is CPA time doing bookkeeper work.
  • You lose access to credit. An American bank asks for statements. Without a consistent P&L and Balance Sheet, the conversation does not even start.

Where to start, in the right order

Step 1. Size the problem

Before anything else, answer three questions with a number, not an estimate.

  • Since when there has been no verified close, month and year.
  • How many bank accounts, cards and payment systems the company uses today and used during the period.
  • How many transactions per month on average, adding everything up.

Those three numbers define the size of the project. Without them, any timeline or quote is a guess.

Step 2. Gather the source material

  • Bank and card statements for the whole period, in PDF or CSV.
  • Access to QuickBooks, if it exists, even if the information in it is wrong.
  • Reports from the industry system: Toast, Buildertrend, MyCase, whichever applies.
  • Payroll reports.
  • Tax returns already filed for the period, which serve as anchor points.

Step 3. Start with the most recent

Here is the difference between a project that moves and one that stalls. Intuition says start from the oldest month and go in chronological order. In practice that means working for weeks to produce information about a period that changes nothing anymore.

Start with the last closed month. In a few weeks you already have a current picture of the business, useful for deciding on pricing, hiring and cash right now. Then work back month by month as far as obligation and usefulness justify.

Step 4. Tie out the balance, not the transaction

Real reconciliation is not checking transaction by transaction, it is closing the balance. If the bank balance on the last day of the month matches the system balance, everything in between is right. If it does not match, the difference points exactly where to look.

Step 5. Only then install the routine

Catching up without changing the routine guarantees you will be in the same place a year from now. The routine that prevents a repeat is simple: reconciliation at month end, categorization while memory is fresh, and someone responsible for it who is not you.

How far back you need to go

It depends on two factors, and they do not always point to the same place.

ReasonHow far back
Tax obligationAny period with a pending return or one that may need correction. Your accountant defines this.
Management usefulnessThree to six months usually suffices to see trend, seasonality and real margin per client or job.
Credit applicationUsually two full fiscal years, depending on what the bank requires.

In most cases, three to six months rebuilt rigorously are worth more than two years rebuilt loosely. Half a year you can trust beats two years nobody dares to use.

Clean-up timeline, by company size

The question everyone asks in the first conversation is how long this takes. The honest answer depends on two variables you can measure today: how many months are open and how many transactions come in per month, across every company account and card.

SituationMonthly volumeReference timeline
Up to 3 months openUp to 150 transactions2 to 3 weeks
6 months open150 to 300 transactions4 to 6 weeks
A full tax year300 to 600 transactions6 to 10 weeks
Two years or moreAny volumeIn phases, most recent tax year first

These timelines assume the material arrives complete at the start. That is not optimism: it is the scenario where nobody has to stop and ask for a missing statement. In parallel, the current month enters the routine from week one, so the gap does not grow while the past is rebuilt.

What to prepare so the clean-up starts fast

Half of a clean-up timeline is decided before a single transaction is touched. Gathering this list before starting usually cuts one to two weeks off the schedule:

  • Statements for every open month. Every account and every card, including the personal card that sometimes pays company expenses.
  • QuickBooks access, if it already exists. With admin permission, so the history is visible and not just the current balance.
  • The last filed return. It closes the opening balance for the period and keeps the rebuild from starting on a made up number.
  • List of active loans and financing. Payments that mix interest and principal are the number one source of wrong balances.
  • Your accountant's name. They define how far back you need to go and what needs correcting. Aligning that at the start avoids redoing work.

What usually blows the timeline

In almost every clean-up that runs long, the reason is on this short list. None of them is a blocker, but each one costs time: an account nobody remembered that shows up mid-process, mixed personal expenses that have to be separated one by one, a period with no documents where only the statement survived, and transfers between your own accounts booked as revenue, which inflates income and has to be undone month by month.

How long it takes

It depends on volume, but an honest reference is possible. A company with around 150 transactions a month and two accounts usually has the last six months reconciled in about four to six weeks, with the current month's routine running in parallel from the start.

What stretches the timeline is almost always the same: a missing statement, an account nobody remembered existed, and personal expenses mixed with business ones that have to be separated one by one.

Frequently asked

Questions on this topic

Will I have a problem with the IRS because of the delay?

Being behind on bookkeeping is not an offense in itself, what creates consequences is a return filed late or with incorrect information. Your accountant or CPA evaluates your specific situation and what needs correcting. What organizing the books does is give them the correct basis for that evaluation.

Can I do this myself in QuickBooks?

With few transactions and a single account, it is possible. What usually stalls is not the tool, it is deciding the category for an old transaction you no longer remember, and reconciling the balance when bank and system disagree. Those two things consume the time.

Do I need everything up to date before starting the monthly routine?

No, and it is not recommended. The two run in parallel: the current month's routine starts immediately, so the problem stops growing, and rebuilding the past runs alongside.

Is it worth rebuilding two years back?

Only if a tax obligation or a credit application requires it. For business decisions, three to six months done well deliver nearly all the useful information, at a much lower cost.

Keep reading

Related

First step

Start with the first conversation

Twenty minutes, no commitment, to understand where your company is and point the way.