How Do I Know If My Books Are Behind?

Your books are behind if (1) your last reconciled month is more than 45 days ago, (2) you have bank transactions that aren't matched to anything in QuickBooks or Xero, or (3) you can't pull a P&L for last month in under two minutes. Any one of those means the books aren't current. All three means you probably need a cleanup, not just more discipline.

The three signals

Signal one: the last reconciled month. Open your accounting platform and look at the last date your bank account was reconciled. If it's more than 45 days ago, you're behind. The rule most bookkeepers use internally is that the prior month should be reconciled by the 15th of the current month. If it's already May 1st and March hasn't been reconciled, that's a warning light.

Signal two: unmatched transactions. Pull up the bank feed in QuickBooks or Xero. You should see transactions flowing in and either being matched to an invoice, bill, or expense, or categorized directly. If there's a long list of transactions sitting unreviewed in the "for review" or "to review" queue, that's where the backlog lives. A healthy bank feed has fewer than 20 unreviewed items. A backlogged one has 200.

Signal three: the two-minute test. Can you pull a P&L for last month right now? Not a P&L you trust — just any P&L. If you can't open the report, export it, or know which of three versions is the real one, your books aren't in a working state, regardless of what the dashboard says.

How far behind is "behind"?

A month behind is normal and fixable with one focused session. Most businesses drift a few weeks at some point — busy season, a system change, a vacation — and catch up within a couple of weeks.

Two to three months behind is the grey zone. You can still catch up without professional help, but it usually takes more time than you expect because you've forgotten context on specific transactions (was that $2,400 Amazon charge for a vendor expense or a prepaid inventory order?).

Four months or more behind is a cleanup job. At that point the compounding problem isn't just volume, it's memory. Transactions from 4+ months ago often can't be accurately categorized without going back through emails, receipts, and vendor portals. This is the point where most people call for help.

Twelve months or more behind means your year-end is going to be painful regardless. A cleanup at this stage takes 4-8 weeks typically and costs $2,500 to $8,000 depending on transaction volume, number of platforms, and how messy the starting state is.

What to do about it

If you're 1-2 months behind: block 4-6 hours on your calendar this week. Reconcile the most recent month first (easier because context is fresh), then work backwards. Get your bank feed down to fewer than 20 unreviewed items before you close the laptop.

If you're 3+ months behind: get a quote for a cleanup. Most outsourced accounting providers, including PixelCrest, can give you a fixed-price cleanup quote in 48 hours after you share read-only access to your accounting platform. Fixed-price is important — you do not want an hourly invoice for this work.

Once caught up, put the rhythm in place so it doesn't happen again. The standard monthly cadence is: reconcile by the 10th, review by the 12th, close by the 15th. That cadence is what every outsourced accounting team builds their schedule around, and it's copyable if you're DIY.