What Is a Reconciliation Report? Types, Process, and Retention

A reconciliation report is a document that proves an account balance in a company’s internal books matches an independent outside record for the same account on the same date. It lists the starting balance on each side, matches transactions line by line, identifies and explains every difference, records any corrections, and arrives at a single adjusted balance both sides agree on. That final number is what the company can safely put on its financial statements.

What the Report Is Proving

Two records that should agree almost never agree at first glance. On one side is the company’s general ledger. On the other is an external source: a bank statement, a credit card processor’s report, a vendor’s monthly statement, or a physical count of inventory. The reconciliation walks through every difference between those two records and shows that, once timing gaps are accounted for and any errors corrected, the balances match.

Accountants sometimes call this “proving the balance.” The point is to catch three things: errors like a wrong dollar amount or a duplicated entry, omissions where a transaction was recorded on one side but not the other, and fraud in the form of unauthorized transactions or deliberate manipulation. The reconciliation is the investigation. The report is the written evidence that the investigation happened and the numbers hold up.

Financial statements pull their numbers from the general ledger. If the ledger is wrong, the statements are wrong. A completed reconciliation confirms the ledger has been updated for items the company didn’t previously know about, like bank fees, returned checks, or interest earned, and that every recorded transaction has a real-world counterpart.

What Gets Reconciled

Reconciliation applies to virtually every account on the balance sheet, but a handful come up constantly.

Bank Reconciliation

The most familiar type. You compare the cash balance in the general ledger against the ending balance on the bank statement for the same date. The two rarely agree right away. Checks written and recorded may not have cleared yet. Deposits made near the cutoff may not appear on the statement. Neither side is wrong; the transactions are just at different stages. The reconciliation separates those harmless timing gaps from real problems like bank errors or unauthorized withdrawals.

Accounts Receivable Reconciliation

The subsidiary ledger tracks what each individual customer owes. The general ledger has a single control account showing total receivables. Those two numbers should match. When they don’t, it usually means a payment was posted to the wrong customer, an invoice was recorded in one place but not the other, or a credit memo slipped through without a proper entry.

Accounts Payable Reconciliation

The reverse. The AP subsidiary ledger lists what the company owes each vendor, and the total should equal the AP control account in the general ledger. Many companies add a second layer by comparing their internal AP balance against monthly statements from vendors, which catches invoices that were missed entirely.

Inventory Reconciliation

The perpetual system says there are 500 units on hand. A physical count finds 487. That gap needs an explanation: shrinkage, damage, recording errors, or theft. Inventory reconciliation compares recorded quantities against what actually exists, either through a full physical count or data from a warehouse management system.

Payroll Reconciliation

Payroll reconciliation compares the internal payroll register against tax filings. The IRS matches the amounts reported on the four quarterly Form 941 filings against the annual totals on Form W-3, checking that federal income tax withholding, Social Security wages, Social Security tips, and Medicare wages and tips all agree.1Internal Revenue Service. Instructions for Form 941 (03/2026) If those numbers don’t line up, the IRS or the Social Security Administration will likely follow up. Running the reconciliation before filing catches mismatches while they’re still easy to fix.

How the Report Is Built

The process follows the same basic pattern regardless of the account. Details change, logic doesn’t.

Start by gathering the two source documents: the internal ledger balance and the corresponding external record. Pin down a precise cutoff date. Everything through that date goes into the reconciliation; everything after it doesn’t. Getting the cutoff wrong is one of the most common causes of phantom discrepancies. A transaction recorded on June 30 internally but July 1 on the bank statement will look like an error if the boundary isn’t respected.

Next, match transactions line by line. Every entry on the internal side should correspond to an entry on the external side. Accounting software can automate much of this pairing for high-volume accounts by matching on amount, date, and reference number. The manual work concentrates on whatever the software can’t match.

Then flag and categorize the discrepancies. Unmatched items fall into two buckets. Timing differences are transactions that both sides will eventually record, like outstanding checks or deposits the bank hasn’t processed yet. These don’t require corrections, just documentation. Actual errors are different: wrong dollar amounts, duplicate entries, or transactions that shouldn’t exist at all. These need fixing.

Corrections go into the internal ledger, not the external statement. When the bank statement reveals a service fee, interest earned, or a bounced check the books don’t reflect, journal entries bring the ledger up to date. The reconciliation is complete when the adjusted book balance exactly equals the adjusted external balance. That final number goes on the balance sheet.

What the Finished Document Contains

The finished reconciliation report serves double duty. It proves the balance is correct right now, and it creates a paper trail for anyone who reviews the work later, whether that is internal management, external auditors, or regulators.

  • Header. Account name, reconciliation date, and spaces for both the preparer’s and reviewer’s signatures. The reviewer sign-off is evidence that someone independent checked the work.
  • Unadjusted starting balances. The raw numbers from the internal ledger and the external statement before any corrections. These are the starting point.
  • Adjustment schedule. A line-by-line listing of every reconciling item. Each entry labeled as an addition or subtraction, cross-referenced to supporting documentation, and categorized as a timing difference or a correction.
  • Reconciled balance. The single number both sides agree on after adjustments. This is what flows into the financial statements.
  • Supporting documentation. Copies of the external statement, journal entries recorded to adjust the books, and written explanations for material discrepancies. Auditing standards require documentation detailed enough for someone unfamiliar with the work to understand what was done and why.2Public Company Accounting Oversight Board. AS 1215 – Audit Documentation

How Often to Reconcile

Monthly reconciliation is the standard for bank accounts and most major balance sheet accounts. Waiting longer lets errors compound. A transaction recorded incorrectly in January is far harder to track down in April than it would have been in February. Monthly timing also aligns with the typical financial close cycle, so the reconciliation feeds directly into monthly reporting.

Some accounts warrant more attention. High-volume cash accounts at larger companies sometimes get daily or continuous reconciliation through automated software. On the other end, low-risk accounts with minimal activity, like a security deposit or a long-term note, can reasonably be reconciled quarterly. The right frequency depends on how many transactions flow through the account and how much damage a delayed error could cause.

Who Should Prepare and Review the Report

A reconciliation report is only as trustworthy as the independence behind it. The person who handles the underlying transactions, whether that means writing checks, receiving cash, or processing vendor payments, should not be the same person who reconciles the account. If one employee can both move money and verify the movement, the reconciliation loses its value as a control. The accounting function, the reconciliation function, and the custodial function should each belong to separate people.

A separate reviewer should sign off on every completed reconciliation. The reviewer’s job is to look for what the preparer might have missed or glossed over: adjustments without supporting documentation, balances that have been off for multiple consecutive months, transactions that don’t match normal business activity, or reconciling items carried forward indefinitely without resolution. Stale reconciling items are a common red flag. They often signal that someone is hoping a problem will resolve itself rather than digging into it.

Reconciliation is what accountants call a detective control. It catches problems after they’ve already happened rather than preventing them upfront. When employees know their work will be independently verified, they’re less likely to attempt manipulation, and when fraud does occur, a well-documented reconciliation trail narrows the exposure window and makes the irregularity easier to trace.

How Long to Keep Reconciliation Reports

Retention depends on who might need to see the records later. The IRS requires businesses to keep records long enough to support the income or deductions on a tax return. In most cases, that means at least three years from the date the return was filed. If income is underreported by more than 25 percent of gross income, the retention period stretches to six years. Employment tax records, including payroll reconciliations, must be kept for at least four years after the date the tax becomes due or is paid, whichever comes later.3Internal Revenue Service. How Long Should I Keep Records

Publicly traded companies face longer requirements. Under the Sarbanes-Oxley Act, audit documentation, which includes reconciliation workpapers reviewed during the audit, must be retained for at least seven years from the date the auditor’s report is released.4Public Company Accounting Oversight Board. AS 1215 – Audit Documentation – Appendix A Many companies, public and private alike, adopt a blanket seven-year retention policy to stay comfortably above both the IRS and SOX thresholds.

When Reconciliation Reports Are Legally Required

Private businesses reconcile because it’s good practice. Public companies reconcile because federal law demands it. Section 404 of the Sarbanes-Oxley Act requires management to establish and maintain adequate internal controls over financial reporting and to assess those controls’ effectiveness in the company’s annual report.5Office of the Law Revision Counsel. 15 U.S. Code 7262 – Management Assessment of Internal Controls Account reconciliation is one of the core control activities companies rely on to meet that obligation.

The SEC defines internal control over financial reporting as a process designed to provide reasonable assurance that records accurately reflect transactions, that financial statements comply with generally accepted accounting principles, and that unauthorized use of company assets would be caught before it could materially affect the financial statements.6eCFR. 17 CFR 240.13a-15 – Controls and Procedures Regular, documented reconciliations directly support each of those goals.

For large accelerated filers and accelerated filers, an independent external auditor must also attest to the effectiveness of the company’s internal controls. Smaller issuers that don’t qualify as accelerated filers are exempt from that external attestation requirement.5Office of the Law Revision Counsel. 15 U.S. Code 7262 – Management Assessment of Internal Controls The auditor will test whether reconciliations are performed on time, reviewed by someone independent of the preparer, and backed by adequate documentation. PCAOB auditing standards treat reconciliation as a testable control when evaluating internal controls over financial reporting.7Public Company Accounting Oversight Board. AS 2201 – An Audit of Internal Control Over Financial Reporting A reconciliation completed late, left unsigned, or missing its supporting documents can itself become an audit finding.