Catch-Up Bookkeeping Bank Statements: Where to Start

Catch-up bookkeeping for a client who skipped a year or more starts with the bank statements. Collect every statement for every account, from the month before the gap to the latest one, confirm each closing balance carries into the next, then reconcile oldest first. The statements give you fixed balances to rebuild the books against.

Why catch-up bookkeeping starts with bank statements

Catch-up bookkeeping starts with bank statements because they are the one record of the missing period that the client did not have to keep. The bank produced them, every month, with an opening balance, a closing balance and every transaction in between. Receipts, invoices and memory are incomplete; the statements are not.

Each statement is a checkpoint. If the books agree with the March closing balance and the April closing balance, everything between them has been accounted for, even if some transactions still need better descriptions. That makes a long backlog manageable: you are not rebuilding eighteen months at once, you are closing eighteen gaps between known balances.

Statements also support the figures that matter for the return. The IRS page on what kind of records to keep lists deposit information among the supporting documents for gross receipts, and lists account statements among the records for expenses. Bank deposits are where income is most likely to show up, and the card and bank lines are where most expenses appear.

Starting elsewhere costs time. A bookkeeper who begins with the client's shoebox of receipts can spend days entering expenses, then discover half of them were paid from a personal card and the other half are already on the bank statement under different names. Working from the statements first gives every receipt a place to land, or shows that it has none.

The bank feed is a weaker starting point than it looks. A feed connected partway through the gap may never have imported the early months. The post on bank feed vs bank statement reconciliation compares what each one proves. For catch-up work, use the statements as the source and treat any feed data as a convenience for entry.

Collecting every catch-up bank statement before entering anything

The complete set for catch-up work is every statement for every account the client used during the gap, plus the statement for the month before the gap begins. That earlier statement supplies the opening balance. Collect the whole set before entering a single transaction, because a missing month found halfway through forces you to redo work around it.

Make an account list first. Ask the client for every checking, savings, money market, credit card, loan and line of credit account used for the business during the period, including any that were closed. Then compare their list with what the statements reveal: a transfer out to an unknown account number, or a card payment to an issuer nobody mentioned, means the list is incomplete.

For each account, the set should run without breaks:

• The statement before the gap, for the opening balance.
• Every monthly statement through the latest closed month.
• The final statement for any account closed during the period.

Then check the run. Read each statement's period dates and confirm they follow on from the last; the post on reading statement period dates to find missing bank statements shows how. Then roll each closing balance into the next opening balance, as covered in the statement balance roll-forward line by line. A break in either check is a missing or wrong statement.

Ask for PDFs downloaded from online banking, not screenshots or exported transaction lists. A PDF statement carries the opening and closing balances; a CSV of transactions usually does not. Clients sending a year of statements tend to send them in batches, from phones and email and portals at once. Schema CPA gives each client one upload link, sorts every statement it receives by document type, issuer and period, and lists the months still missing, so you can see when the set is complete without opening every file.

How do you reconcile a year of bank statements in order?

Reconcile a year of bank statements oldest first, one month at a time, across every account before moving to the next month. Start from the statement before the gap, so the books open on a known balance. Finish each month in every account, matching transfers between them, before opening the following month's statements.

The order prevents rework, because transfers and card payments match while both sides are open in the same pass. Which account to take first each month is covered in which of the multiple bank accounts to reconcile first.

Accounting software offers shortcuts for long backlogs. Intuit's guide to reconciling an account for multiple months or years in QuickBooks Desktop describes reconciling one year at a time: you use the last statement of the year as the ending figures, total the service charges and interest from every statement in the year, and check off each statement's transactions in turn. Intuit also says to back up the company file first, and that adjustments entered in that reconciliation apply to the year the transactions occurred.

A year-at-a-time pass is faster, but it gives you one checkpoint instead of twelve. If the year does not reach zero, the error could be in any month. Entering and checking month by month adds those checkpoints back; you can then save the reconciliation at whichever interval the software and the engagement call for.

Within each month, the sequence is the same:

1. Enter or import the month's transactions for every account.
2. Reconcile the main checking account to its statement.
3. Reconcile savings, cards and loans, matching each transfer and payment to its checking side.
4. List outstanding items, such as checks that clear next month.
5. Note questions for the client rather than stopping to ask each one.

Batch the questions. Over eighteen months, a client may have dozens of unexplained deposits and payments. Asking them one at a time stalls the work; one list per quarter, with dates and amounts, gets answered faster.

End each calendar year with a full tie-out, since that is the balance the tax return relies on. The post on year-end bank reconciliation covers the December checks.

Should catch-up books be rebuilt or repaired?

Catch-up books should be repaired when the client's partial entries reconcile to the statements for at least some months, and rebuilt when they do not. Repairing keeps the existing work and fills gaps. Rebuilding means discarding the period's entries and recording everything again from the statements. The statements settle the choice, not how messy the file looks.

Test before deciding. Pick three months the client says are done and reconcile them to the statements. If they agree, or miss by a few items you can name, the entries are usable, and the job is to finish the months that were never touched. If they miss by amounts you cannot explain, the entries are not a reliable starting point.

Signs that point toward rebuilding:

• Beginning balances that do not agree with any statement, so there is no month to build forward from.
• Bank feed imports accepted without review, leaving duplicates and transfers coded as income or expenses.
• Entries posted to the wrong account, such as card charges recorded in checking.
• Prior reconciliations forced to zero with adjustments that hide the real differences.

Signs that point toward repairing:

• The early months reconcile and the problems start at a clear date.
• Most transactions are coded consistently, and errors cluster in a few accounts.
• The client or a former bookkeeper can explain the entries that look wrong.

A rebuild is not a judgment on the client. Partial books are often the work of someone who stopped when they got busy, and the entries before that point may be fine. Repair those months and rebuild from the date things went wrong.

Either way, keep the original file. Save a backup before changing anything, so the client's version is still there if a question comes up about what was recorded before you started.

Catch-up statements spanning a bank change or closed account

A bank change during the catch-up period means two runs of statements for what the client thinks of as one account. The old run ends with a final statement, the new run begins with an opening deposit, and the money moving between them has to match. Treat them as two accounts in the books, each reconciled to its own statements.

The final statement of the old account should show a closing balance of zero, or close to it. If it does not, the account is not actually closed, or there is a later statement the client has not sent. Ask for it. An account left open with a small balance can keep charging monthly fees after the client stopped using it.

Match the move. The transfer out of the old account should equal the deposit into the new one. When the client moved money in several pieces, or withdrew it and deposited it later, list each piece on both sides and confirm the totals agree.

Expect overlap. For a month or two, both accounts may be active: old checks still clearing, automatic payments not yet moved, deposits still landing in the old account. Reconcile both for those months. A payment that appears on neither statement may have bounced from the old account after it was emptied.

Check the start of the new account. Its first statement's opening balance is usually zero, with the initial deposit as the first transaction. If it opens with a balance, there may be an earlier statement, or the account may predate the switch.

Closed cards behave the same way. A card closed during the period should have a final statement showing a zero balance after its last payment. Refunds and late charges can post after closing, so ask for statements until the balance stays at zero.

Pricing and scoping catch-up bank statement work

Catch-up bank statement work is easiest to scope by counting statements. The number of accounts multiplied by the number of months gives the count, and each statement is one reconciliation. Transaction volume per statement, the condition of any existing entries, and how many statements are still missing then adjust the estimate.

Count before quoting. A client with one checking account and eighteen months of backlog has eighteen statements. A client with checking, a card and a loan has fifty-four, plus the opening-balance statement for each. The two jobs should not get the same quote, and the count makes the difference obvious to the client.

Then weigh the statements. A checking statement with twenty lines a month is a different job from one with four hundred. Look at a sample month from each account and note the volume. Accounts with heavy volume, many transfers or unexplained deposits take longer per statement.

A catch-up plan for an 18-month backlog

This example is fictional. Juniper Yoga Collective (example client) has not reconciled its books from April 2025 through September 2026. It has operating checking XXXX-2208 and a business card XXXX-6174.

Phase 2 is the longest because it closes a tax year. Each phase ends at a point where both accounts agree with the statements, so if the engagement pauses, the work done so far is complete and usable.

Quote in phases when the set is incomplete. If the client can produce 2025 statements now but is still requesting 2026 from the bank, scope and price the 2025 work first. That keeps the estimate tied to statements you have seen.

Missing statements are part of the scope. Every month the client cannot produce has to be requested from the bank, so ask whether older statements carry a fee. Note who will request them and how long that usually takes before committing to a finish date.

For turning a stack of PDF statements into rows you can work with, the bank statements to Excel category covers formats and conversion. If you want to estimate what manual entry costs your firm now, the hours calculator on the homepage works from clients, documents per client and minutes per document.