Catch-Up Bookkeeping: How to Fix Months of Neglected Books

Most owners fall behind for ordinary reasons: a busy season, a staff change, or a bookkeeper who left. The longer the gap, the more tempting it is to avoid it. The work itself is not mysterious, though. It follows a sequence, and the sequence is what keeps it from turning into a second mess.

Start by listing every account

Make a complete list of every bank account, credit card, loan, payment processor and payroll provider the business used during the gap. Missing accounts are the most common reason catch-up work does not tie out. Include accounts that were closed or replaced, and any personal card used for business purchases.

Gather the statements, not just the bank feed

A connected bank feed can be incomplete, duplicated or limited in how far back it goes. Monthly statements are the source of truth because they show the opening and closing balance you are trying to match. Download one for every account and every month in the gap.

Reconcile month by month, oldest first

Start with the oldest unreconciled month. For each account, match the transactions in your accounting file to the statement until the ending balance agrees. Working oldest first matters because every month starts from the previous month's closing balance. If you skip ahead, errors compound. Our guide to what a bookkeeper does each month shows what each reconciled month should include.

What usually needs fixing

• Uncategorized transactions. Items parked in a holding account need a real category, or a question for the owner.
• Duplicates. The same transaction imported from a feed and entered by hand.
• Missing transactions. Deposits or payments that appear on a statement but not in the books.
• Personal spending mixed in. These should be moved out of business expenses, usually to owner draws or distributions.
• Old unpaid invoices and bills. Items that look open but were paid long ago, or never will be.

Decide what to do with the unknowns

Some transactions cannot be identified from the statement alone. Keep a short list of questions for the owner rather than guessing. A transaction categorized wrongly because it was convenient is harder to find later than one that sat on an open-questions list.

Lock the months once they agree

When a month reconciles and the reports look reasonable, close it. In QuickBooks Online and Xero you can set a closing or lock date so that earlier periods are not changed by accident. Your CPA will want stable numbers for any tax filing or amended return, and a lock date protects them.

Taxes and deadlines

If the gap spans a tax deadline, tell your CPA before you finish. Whether a late filing or amended return is needed depends on your situation and is a question for a tax professional, not for the bookkeeping. Our small business tax deadlines guide covers the calendar.

Staying current afterward

The point of catching up is not to catch up again. A monthly routine of reconciling each account, reviewing uncategorized items and closing the month keeps the books current. If you would rather not do it yourself, see how catch-up bookkeeping and monthly bookkeeping work together at Mispar, check pricing or talk to a bookkeeper.

Frequently asked questions

Keep reading

Monthly Bookkeeping

What Does a Bookkeeper Do Each Month? A Small Business Owner's Guide

Each month, a bookkeeper records transactions, reconciles accounts, checks invoices and payroll, and prepares your reports. Here is exactly what should happen every month — and what you should receive.

Bookkeeping Basics

A Small Business Owner’s Guide to Monthly Bookkeeping

What monthly bookkeeping really involves, why it matters, and how to make it painless — even if you’d rather do literally anything else with your time.

Tax & Compliance

Small Business Tax Deadlines to Know (Monthly and Quarterly Checklist)

Miss a tax deadline and the penalties add up fast. This checklist covers the monthly and quarterly deadlines every small business owner should have on the calendar.