How to Catch Up on Months (Or Years) of Bookkeeping

Being behind on the books is more common than owners admit. The usual story is a busy season, a bookkeeper who left, or a QuickBooks file that got confusing enough to abandon. The question is not whether you can catch up (you can) but what order to do it in, so you do not spend three weekends producing numbers that still cannot be filed. Here is the sequence we use, with a worked 14-month example and the deadlines that decide the pace.

Anchor the books, then gather everything

Start from a point you can trust

Every catch-up needs a starting balance sheet that is known to be right. The best anchor is the last filed tax return (the balance sheet on Schedule L of an 1120-S or 1065) or, for a Schedule C filer, the last month in which every bank and card account was reconciled. Everything before that date is locked; everything after it is the project. If no such month exists, you do not have a repair job, you have a rebuild, covered below.

Collect every record first

Categorizing one bank account while the credit card statements are still missing is the biggest time-waster in catch-up work, because transfers look like income or expenses until both sides are in the file.

Import, categorize, reconcile

Get the transactions in, then set rules

When you first connect a bank account, QuickBooks Online brings in 90 days of transactions. Anything older is uploaded from a CSV, QBO, QFX or OFX file. Upload the oldest month first, and do not let the file overlap the 90 days the feed already covered, or you will create duplicates that never reconcile.

Once transactions are in, build bank rules for recurring vendors: rent, software, insurance, the payroll provider, fuel, the phone bill. On a typical service business, rules handle more than half the volume. Review their work rather than trusting auto-add; a rule that codes every Amazon purchase to office supplies will also code the laptop that should be a fixed asset. Park anything uncertain in a holding account instead of guessing, and clear it before you close each month.

What to do about missing receipts

A bank or card statement proves that a payment happened, when, and for how much. What it does not prove is business purpose, which is what the IRS asks about. Pull what you can from vendor portals and email: Amazon, Home Depot, airlines and software companies all keep order history, and an inbox search for the vendor name recovers most of the rest. For recurring vendors, one contract or sample invoice is enough.

Two categories deserve extra care. Travel, vehicle and gift expenses must be supported with the amount, time, place and business purpose, and IRS Publication 463 says you should have documentary evidence for lodging and any other expense of $75 or more. And cash withdrawals with no trail are owner draws, not expenses, until you can show otherwise; an ATM withdrawal deducted as supplies is the kind of entry that turns an IRS letter into an examination.

Reconcile every account, every month, in order

Reconciliation is the step that turns a pile of categorized transactions into books. Start with the oldest month and work forward, one account at a time, until the QuickBooks ending balance matches the statement to the penny. A difference is a missing, duplicated or mis-dated transaction; find it. Do not post a discrepancy entry to force the number, and do not delete transactions to make it work.

Credit cards and loans get reconciled too. Card payments are transfers; the expenses are the individual charges. Loan payments split between principal, which reduces the liability, and interest, the only part that hits the P&L, and the loan balance in QuickBooks should match the lender's statement at year-end. Then clean up receivables and payables: apply payments sitting in Undeposited Funds to their invoices, write off invoices that will never be collected, and close bills that were actually paid.

Rebuild or repair?

Repair when the last reconciled month ties to the last filed return, the gap is under about a year, and the chart of accounts is usable. Rebuild when the balance sheet does not tie to any return, several years were never reconciled, income was recorded twice through invoices plus deposits, bank or loan accounts show negative balances, or the chart of accounts has hundreds of near-duplicate categories. A rebuild means a fresh file, or a fresh start date in the existing one, with opening balances from the last filed return and every account reconciled from there forward. It is usually faster and far more defensible. The signs your QuickBooks file needs professional help are the same signs that point to a rebuild.

The deadlines that set the timeline

Catch-up work rarely chooses its own pace, because the returns that depend on it have fixed due dates. For calendar-year businesses, here is what is ahead, with the weekend rule from IRS Publication 509 applied.

An extension gives you time to file, not time to pay, and an S corporation return filed late costs $255 per shareholder per month, up to 12 months, on returns required to be filed in 2026. Working backward from these dates sets the order: finish the year that is due first, file it, then keep going into the current year.

The IRS record retention periods decide how far back a rebuild must go: generally three years from filing, six if a return left out more than 25% of gross income, four for employment tax records, and no limit for a year that was never filed, which stays open until its books exist and it is filed. See our guide to which tax records to keep and for how long.

A worked example: 14 months behind

Picture a single-owner residential remodeling contractor in Brandon, Florida, taxed as a sole proprietor, doing about $1.1 million a year. His bookkeeper left in August 2025; the last reconciled month is July 2025. He extended his 2025 return, and it is now mid-September 2026 with October 15 four weeks out. That is 14 months of catch-up across two bank accounts, three credit cards, a truck loan, a line of credit and a Square account: roughly 3,900 transactions.

Week one is collecting statements and files for all eight accounts and confirming that July 2025 ties to the 2024 return. Week two is uploading, building rules, and categorizing August through December 2025 first, because that is the year that is due; rules and bank matching handle about two-thirds of the volume. Week three is reconciling those five months across all eight accounts (40 reconciliations), then payroll, sales tax, loan and fixed asset entries. What surfaces in the 2025 books: $18,400 of income recorded twice (Square deposits entered as sales on top of the invoices they paid), $31,000 of loan principal coded as expense, $9,600 of personal charges on a business card reclassified to owner draw, and six subcontractors who never received 2025 1099-NEC forms. Corrected 2025 net profit lands at $142,000, about $22,000 above his rough guess.

With 2025 closed and handed to tax preparation at the end of week three, January through September 2026 takes another two to three weeks at a calmer pace, and the file moves onto a regular monthly close. Total elapsed time: about six weeks, most of it waiting on documents.

A realistic view of time and cost

The cost of a catch-up project is driven by four things: accounts multiplied by months, transaction volume, the condition of the records (clean statements versus a shoebox), and whether it is a repair or a rebuild. Unfiled payroll or sales tax returns add their own work. Firms price this as a one-time project separate from the monthly fee, and a good one scopes it after looking at the file rather than quoting blind. What it should not cost is the same amount again next year; finishing means moving onto a monthly close.

What usually goes wrong

The failures we see most: categorizing one account before the others are in and coding transfers as income; accepting every rule and auto-add suggestion without review; typing opening balances by hand instead of taking them from the last return; forcing reconciliations with adjustment entries; treating credit card payments as expenses and loan proceeds as income; and letting the holding account grow to hundreds of items nobody resolves. The last failure is stopping when the return is filed; if the current year is not brought current too, the next catch-up starts in about three months.

When to get help

If the gap is a few months, one bank account and one card, you can do this yourself over a couple of weekends with the sequence above. If it is more than a year, involves unfiled payroll or sales tax returns, includes a year that was never filed, or has to be finished for a lender or a buyer, hand it to someone who does catch-up work every week. Our QuickBooks cleanup and catch-up service starts with a review of the file and a fixed scope, and ends with reconciled, tax-ready books and a plan for the months after.

The fastest way to find out which situation you are in is a 20-minute fit call. Bring the last filed return and a QuickBooks login, and we will tell you whether it is a repair or a rebuild, what has to be finished first, and roughly how long it will take.

Jenny Gao, CPA, EA

Founder of Balance Partners. Florida-licensed CPA and IRS Enrolled Agent with more than a decade of accounting and tax experience. Jenny writes and reviews every guide on this site. About Jenny

This article is general educational information for U.S. business owners and is not accounting, tax, legal, payroll or financial advice for your situation. Rules change and vary by entity, state and facts. Balance Partners, LLC does not provide audit, review or other attest services. Last reviewed September 14, 2026.