When your books are months behind, catch up in the right order

To catch up on books that are months behind, reconcile every bank and card account first, clear stale bills and invoices, then close each month in order.

How to rebuild the books you can file taxes from, then keep them current. The short answer: If your books are months behind, start by reconciling every bank and card account to its statements, because cash is the one number you can prove. Then clear the bills and invoices that are still showing open after they were paid, and close each month in order, so you end up with books you can file taxes from and keep current.

Most owners don't put the books off on purpose. A busy stretch turns into a missed month, then another. The moment it finally can't wait is usually a tax deadline, a lender asking for statements, or an IRS payment plan that needs last year's numbers done. The usual approach is to wait until that deadline and recode everything at once, which usually means doing the work twice. A better order is to rebuild from the bank statements month by month, then keep closing so the backlog never builds again.

I. CHAPTER ONE

Why do books fall behind in the first place?

Books fall behind when nobody owns the close. The owner is running the business, the bookkeeper is waiting on answers, and the accountant only looks once a year, so the gaps sit until someone is forced to look. We also see it when a prior bookkeeper left midstream, when a bank feed dropped months of transactions, or when basic policies were never settled. On recent calls, one prospect was almost two years behind and needed last year finished to set up tax payments.

II. CHAPTER TWO

Where should you start when your books are months behind?

Start with cash, because it is the one number you can prove against a statement. Pull every bank and card statement for the open months, and reconcile each account until the books match the statement. Before you code anything else, check that the feed has no gaps, especially if you switched banks or a reconnect dropped activity. Once cash ties, categories and open bills can wait, because fixing them against a wrong cash balance just creates a second cleanup later.

III. CHAPTER THREE

How do you clean up bills and invoices that still show as unpaid?

After cash is solid, open the lists of bills and invoices that still show as unpaid and clear the ones that were already paid. A restaurant we spoke with had dozens of paid bills still sitting open, which made payables look far worse than they were. The same thing happens when a deposit covers several invoices and nobody matches it, so the next reminder goes to someone who already paid, which we wrote about in how to get paid on time. Watch for lump-sum vendor payments and for bills paid from a personal account or sister company and never tied back.

IV. CHAPTER FOUR

What do you do about mistakes from a previous bookkeeper?

You do not have to redo every entry they made. Clear what they already booked when it is wrong, and leave what is correct alone. If a month was closed with mistakes, reopen it with a written reason, fix what does not tie, and close it again. When you bring an old QuickBooks file over, confirm the import is complete before coding new months, since a partial import looks like a clean starting point and is not.

V. CHAPTER FIVE

How do you know the catch-up is actually done?

A catch-up is done when each caught-up month is reconciled, payables and receivables tie to the open lists, and the month-to-month swings make sense. If payables do not tie, the month is not ready to close. Owners who run several companies also need each entity to stand on its own before anything is combined, the same order we use for consolidated financials across multiple LLCs.

VI. CHAPTER SIX

How do you keep the books from falling behind again?

Catch-up without a monthly close is how the same pile comes back next year. Put a close on the calendar every month: reconcile every bank and card account, clear open bills and invoices, review the swings, and lock the month when it ties. If you do not have time to own that close yourself, use our guide to fractional CFO vs controller vs bookkeeper to decide which role you need. You can also start with a free financial health audit or browse our FAQ.

That monthly close is what our team takes on at Porter. We rebuild from the bank statements month by month, clear the stale bills and invoices, and keep closing so the backlog does not return. We work alongside your CPA, so they get books they can file from instead of a year-end cleanup. If a deadline is forcing the issue, we would be happy to talk. Talk to Porter

VII. CHAPTER SEVEN

FAQ

How long does it take to catch up?

It depends on how many months and accounts are open. Once we have access to the books and every bank and card statement, we can give you a timeline for your specific catch-up, and the months close in order from the oldest forward.

Do I need my old QuickBooks file?

It helps, because the history and open bills live there, although we can also rebuild from bank and card statements if the file is missing or unusable.

Can I file taxes before the catch-up is finished?

Usually no, because your CPA needs books that tie to the bank and clear open items before they can file with confidence.

Should I clean up one year at a time?

Yes when more than one year is open. Finish and close the oldest year first, then move forward month by month.

More from The CFO Playbook.