Find the last reconciliation that can be supported
Collect prior reconciliation reports and the corresponding external statements. Confirm that the closing balance was supported and that later edits have not changed the ledger behind it. A status marked reconciled is a starting point for review, not sufficient evidence by itself when the history is uncertain.
Intuit's beginning-balance guidance identifies changes to previously reconciled transactions as a source of later discrepancies. If the opening position no longer agrees, investigate that change before working through hundreds of new lines. Otherwise, each later month may inherit the same unexplained difference.
References: Intuit: Beginning-balance reconciliation issues
Build an account-by-period evidence map
List every bank account, currency and required statement month, including dormant or closed accounts. Mark the availability of full statements, transaction exports and prior reports. Identify gaps and request them early, since an unavailable historical statement can determine the pace of the whole project.
Add links between accounts that transfer money to each other or share a sweep arrangement. Note which processor, payroll or loan records are needed to explain bank totals. This map helps the accountant sequence work around actual dependencies instead of choosing accounts solely by the smallest transaction count.
Keep a separate list of records that cannot yet be obtained and the person responsible for each request. Avoid presenting a period as complete when its source evidence remains missing. Management should be able to see the difference between unfinished matching and an unresolved records gap. Note any bank retrieval fee or lead time before agreeing the project schedule.
Work forward with a controlled boundary for each period
Begin from the verified opening balance and reconcile one defined period at a time. Confirm statement completeness before classifying transactions. Xero's bank-balance guidance recommends locating where statement and recorded balances first diverge, which can help narrow a missing or duplicated import to a smaller interval.
Match transfers across linked accounts and preserve timing differences. If only one side is ready, keep the other side on a specific open-item schedule. Do not record a transfer as income in one account and an expense in another simply to complete both reconciliations independently.
Save the completed report and supporting adjustments before advancing. Record remaining items with their original dates, amounts and owners. This creates a stable checkpoint, while leaving unresolved facts visible for the accountant's review. A project should not depend on one giant spreadsheet that changes without a period history.
References: Xero: Comparing statement and actual bank balances
Escalate old uncertainty without burying it in new activity
Group exceptions by the decision required: missing source evidence, unknown business purpose, duplicate accounting entry or a bank dispute. Send targeted questions to the person who can answer them. A list of hundreds of uncategorized descriptions is harder to resolve than a smaller set of specific requests with source references.
Ask the accountant to review proposed write-offs, prior-period changes and corrections affecting tax or financial reports. Age alone does not establish the correct treatment of a receipt, payment or outstanding check. Preserve the investigation and approval supporting any final resolution.
Continue current-period controls while the backlog is cleared, with an explicit boundary between old and new work. Report progress as completed account-periods, remaining source gaps and unresolved amounts. At handoff, retain the last verified closing balance for each account and the open-item history, so routine monthly work begins from evidence rather than a fresh balancing assumption.
Sources
Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.
Related reading
Need help with this work?
General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.