How do I catch up reconciliation for old or prior-period transactions that remain unreconciled, working through earlier periods to bring the reconciliation current?

How far back does the backlog actually go?

Size the backlog before you touch a single transaction. For every account that receives statements (checking, savings, credit cards, loans, lines of credit), write down three facts: the account, the date its unreconciled stretch begins, and the last statement period that was genuinely reconciled.

"Genuinely reconciled" is a higher bar than "marked reconciled." A period counts only when a reconciliation report exists for it, the ending balance on that report equals the ending balance printed on the bank statement for the same date, and nothing reconciled in or before that period has been changed since. The last condition is the one Intuit lists among the most common causes of a beginning-balance discrepancy. In QuickBooks Online, each reconciliation's beginning balance should match the ending balance of your last reconciliation, and a mismatch is commonly caused when a reconciled transaction was edited, deleted, voided, moved or unreconciled after the fact. QuickBooks Online's Reconcile Discrepancy Report lists what changed, how it affected the balance and how to fix each item, so run it before you trust any old reconciliation.

That test puts each account on one of three paths:

• A reliable completed period exists. The catch-up starts with the statement period immediately after it, and that period's ending balance is your proven starting position.
• Periods were marked reconciled but fail the test. Walk back to the latest period that passes. Everything after it is backlog, whatever the software shows. Undoing the unreliable reconciliations in the software is a separate question.
• No period passes, or none was ever reconciled. You have to fix and evidence a starting position yourself, as described below. If the account is new and has no history to work through, you are doing a first reconciliation, which is a different job.

Multiply the number of statement periods by the number of accounts. That count, not the number of transactions, is your unit of work and your progress measure.

What do you need in hand before reconciling anything?

Collect every statement for every backlog period before you reconcile the first one. Intuit's reconciliation guidance says to get all of your bank and credit card statements together before you start, and if you don't have them all, to get them from the bank's website or contact the bank directly. The statements are the reference, not the books: the bank and card statements are the source of truth, and the books should match them, not the other way around.

Older statements can be harder to get. For the national banks and federal savings associations it regulates, the Office of the Comptroller of the Currency says that for any deposit over $100, banks must keep records for at least five years. That floor covers deposit records at OCC-regulated banks only; it does not tell you how long card issuers, credit unions and state-chartered banks keep statements, so ask each issuer how far back statements go before you plan the earliest periods.

Gather the source records for each period alongside its statement: deposit slips, invoices, paid bills, receipts and canceled checks. The IRS explains that these documents matter because they support the entries in your books and on your tax return. File them by period, because each period's reconciliation will lean on them.

If a period's statement cannot be obtained at all, that period cannot be completed in the ordinary way. There is nothing printed to tie its ending balance to, and the proven chain of starting balances breaks there. The periods after the gap can still be worked, but only from a new starting position you prove at the next statement you do have, using the same method as for an account with no trustworthy history. The gap period itself becomes a reconstruction problem, covered in the last section.

Are the transactions recorded, or only unreconciled?

For each backlog period, find out which of two very different problems you have:

• Recorded but never cleared. The transactions are in the books; nobody matched them to the statement. This is a tie-out job.
• Never recorded. Deposits, payments or card charges on the statement are missing from the books entirely. This is a recording job, and it comes first.

Old backlogs are often a mixture: early periods thinly recorded, recent ones recorded through a bank feed but never matched. A quick screen per period is to compare the statement's total deposits and total withdrawals with the total of book entries dated in that period for that account. A gap much larger than a few timing items means recording is incomplete.

Finish recording every period up to the one you are about to reconcile before you start matching it. If you reconcile against an incomplete ledger, a transaction missing from the books looks exactly like one that simply has not cleared yet, and you end up chasing differences that no amount of matching can resolve. Catching up unorganized receipts and bookkeeping in general is a separate question; the point here is only the order: record, then reconcile.

Where does the catch-up start, and how do you prove that balance?

Do not accept the beginning balance your software offers for the first backlog period just because it is there. In QuickBooks Online, that figure is the ending balance of the last reconciliation, and when an account has never been reconciled, a mismatch is usually caused by the opening balance rather than a changed transaction. An incorrect opening balance entered when the account was created is one of the causes Intuit lists. A figure built on unreconciled history carries no assurance, and every later period inherits it.

Fix and evidence the starting position this way:

1. Choose an anchor date. Use a statement ending date: the end of the last reliable period if you have one, otherwise the end of the earliest statement period from which your records are complete.
2. Take the bank's figure. The ending balance printed on the statement for the anchor date is your primary evidence. Intuit's workflow guidance is to make sure the opening or beginning balance matches the balance on your account statement for that day.
3. List what had not cleared, and record what the books missed. Identify every item recorded in the books on or before the anchor date that the bank had not processed by then (checks written but not cashed, deposits made but not yet credited) and prove each one by finding it clearing on a later statement. Also record any bank charges on the statement on or before the anchor date that were never entered in the books; an unentered bank charge is a standard reason a statement balance and a book balance disagree.
4. Compare with the books. The book balance at the anchor date should equal the statement balance, less the uncleared checks, plus the uncleared deposits. If it does not, the difference arose on or before the anchor date. Correct it there, or document it as a known, attributed difference, before the first backlog period begins. Never carry it forward silently.

A worked example: the March 31 statement shows 18,420.00. Two checks totaling 1,150.00 (700.00 and 450.00) were written in March and clear in April; a 600.00 deposit made on March 31 is credited on April 2. The proven position is 18,420.00 − 1,150.00 + 600.00 = 17,870.00. If the books show 17,870.00 at March 31, the catch-up starts from a defensible figure. If they show 18,070.00, a 200.00 difference sits in the history before the anchor date and must be traced there.

Keep the anchor statement, the list of uncleared items with the later statement lines that prove them, and a one-paragraph note of how the figure was established.

Why work one period at a time instead of all at once?

Intuit's guidance is to always start with your oldest bank statement, or where you last left off reconciling, and then reconcile each month, one at a time, because an issue with an earlier reconciliation affects all reconciliations going forward.

The sequence does real work. A completed period leaves you with two proven things: an ending balance that agrees with the statement, and a short list of items still outstanding at that date. The next period starts from exactly those two things. Any difference you find in the next period therefore belongs to that period's transactions and nowhere else, which keeps the search small. Diagnosing a single period that will not balance is a separate question.

Two shortcuts break this, and both are tempting precisely because the backlog is large:

• Reconciling the whole backlog as one long period. Every error from every month is merged into one net figure that cannot be traced to a month or a transaction. Offsetting errors can even net to zero and hide entirely.
• Forcing a period to balance with an unexplained adjustment so you can move on. The adjustment becomes part of the ending balance, so it becomes part of every later period's beginning balance. One shortcut undermines everything after it.

Use the bank's statement periods as the unit. One reconciliation per statement means every period has a printed ending balance to tie to.

What will your software let you do with old statement periods?

This depends on the system, so check your own vendor's documentation before you plan the work. In QuickBooks Online, as Intuit documents it:

• The beginning balance of each reconciliation should match the ending balance of your last reconciliation. Intuit's list of causes shows the figure is built from the transactions currently marked reconciled — editing, deleting or manually reconciling one changes it — so it is not read from your statement.
• If it doesn't match, QuickBooks won't let you continue until you account for the difference.
• One listed cause of a mismatch is a transaction dated before your last reconciliation's ending date that was reconciled manually, so clearing old-dated items outside the sequence disturbs the chain.

For any system, establish three things before you start: whether it lets you reconcile a statement dated earlier than the last completed reconciliation, how it derives each period's beginning balance, and whether a period lock stops you from marking transactions cleared or correcting them in that period. If your system only reconciles forward from the last completed reconciliation, periods marked reconciled in error have to be dealt with before the catch-up can start from the right place.

What do you do with items that stay outstanding for several periods?

A sequenced catch-up surfaces these on its own. Each period ends with a list of outstanding items, and that list is carried into the next period. Add a column recording the period in which each item first appeared. Pick an ageing trigger for your list — for example, any item still outstanding after two statement periods — and flag every item that passes it for a decision rather than carrying it forward again.

Each flagged item needs one of these answers:

• It cleared later. It was timing only; note the statement where it cleared.
• It was recorded wrongly. Wrong amount, wrong account, wrong date, or a duplicate. It needs a correction, and where that correction is dated matters (next section).
• It never happened at the bank. A check that was voided but never voided in the books, or a deposit recorded but never made.
• It is genuinely still outstanding. For example, a check the payee has not cashed.

How each class is treated, such as what to do about a check that has been outstanding for a long time, is decided under the questions that cover that item class, not here. What matters for the catch-up is that no item is carried forward indefinitely without a decision, and none is deleted to shorten the list.

What changes when a correction lands in a locked or reported period?

Old periods are the ones most likely to be closed, so test every backlog period in two steps before you post anything into it. First ask whether the period falls in a year for which a tax return was filed, or for which figures were given to a lender or investor. If it does, take the closed-and-reported path below, whatever the lock setting says. Only then ask whether the period is open or locked.

Until that decision is made, later periods can be tied out on paper with the pending correction shown as a named reconciling item, but check what your software does with a period that ends with a known difference. If it will not let you finish reconciling such a period without an adjustment, hold the later periods in the software until the decision is made. Before then, do not let any adjustment, named or not, close the gap in a later period.

What should each finished period leave behind, and when is the account current?

Each completed period should leave a small, complete file:

• The bank or card statement for the period.
• The reconciliation report, with an ending balance equal to the statement's.
• The list of items outstanding at the period end, with the date each first appeared.
• A note for every correction made: what, why, the date it was posted and who approved it where the period was locked.
• A pointer to the supporting documents for the period's entries.

The account is current when all of these hold:

• Every account in scope is reconciled through its most recent statement period.
• Each period's beginning balance equals the prior period's ending balance, with no unexplained discrepancy.
• No period was forced to balance with an unexplained adjustment.
• Every item still outstanding is either recent or has a recorded decision.
• Every correction pending in a reported period has been decided.

From there, keep to the monthly cadence so the backlog does not rebuild.

When should you stop and reconstruct instead?

A period-by-period catch-up only works when each period can be evidenced. Stop and take the reconstruction route for the affected periods when any of these is true:

• A period's statement cannot be obtained from the bank or any other reliable source.
• A period's transactions were never recorded and the source documents needed to record them are gone.
• No anchor date exists at which the starting position can be proven.
• A period's difference cannot be attributed because the records needed to trace it no longer exist.

Rebuilding books from incomplete records is a separate question with its own method. Once the gap is walled off, you can often still reconcile normally from a later anchor date.

What does a workable catch-up plan look like?

Work the backlog as a sequence of stages you can stop and resume:

1. Scope. List accounts, find the last genuinely reconciled period for each, and count the statement periods ahead.
2. Statements. Obtain every statement for every period, oldest first, and file the source documents by period.
3. Recording. Confirm each period's transactions are in the books, and record anything missing before reconciling.
4. Starting position. Fix the anchor date, prove the balance against the statement, and file the evidence.
5. Periods in order. Reconcile one statement period at a time, oldest first; do not open the next period until the current one ties to its statement.
6. Outstanding items. Age the carried-forward list and decide each item that persists.
7. Locked and reported periods. Check period status before posting; flag corrections in reported periods for a separate decision.
8. Evidence. Complete each period's file before moving on.
9. Done. Confirm the account meets the current-state test above.

For a long backlog, break the work into blocks of a quarter per account and track them in a simple log: account, period, statement obtained, recording complete, reconciled, outstanding items, pending corrections. Decide early which blocks you will handle in-house and which to hand to an outside preparer, so a large backlog is not abandoned halfway.