Reconciliation Discrepancy Report: What It Is and How to Build One

What is a reconciliation discrepancy report?

A reconciliation discrepancy report is a list of everything that did not line up when you compared two sets of records, usually a bank statement against your accounting ledger. It turns "the totals are off" into a specific list of items you can investigate and fix.

A good one answers three questions: what is different, by how much, and which side it came from.

What belongs in the report

Summary totals. Bank balance, ledger balance, and the difference between them.
Unmatched items, by side. Transactions on the statement with no ledger entry, and ledger entries with no statement line.
Variances. The same transaction recorded with a different amount or a different date.
Sign mismatches. The same amount recorded as a positive on one side and a negative on the other.
Possible duplicates. The same entry posted twice in one file.
Notes and status. Who looked at each item and whether it is explained, such as a timing difference, or still open.

How to build one by hand

In Excel, put the bank transactions and ledger transactions in two sheets, sort both by date, and add a helper column that checks whether each row has a counterpart with the same amount. Anything without one goes on a third sheet, the report. Then work through that list and label each line with a cause.

That works for a few dozen rows. With hundreds of rows, near-matches (a day apart, a few cents off) and duplicates, it becomes slow and easy to get wrong. If your statement is a PDF, convert it to a spreadsheet first.

Generate one with Sheet Audit

Upload your two files, tell Sheet Audit which column is the date, amount and description, and it compares every row on both sides. The free scan shows how many items matched, how many need review, and the total gap. The full report lists each match, variance and mismatch row by row. If you already know you are off by a specific amount, Find My Discrepancy searches the unmatched items for the one or two that explain it.

Example

Bank total: $48,210.55
Ledger total: $47,985.55
Difference: $225.00

Unmatched on bank side: Mar 12 · Wire fee · $25.00
Unmatched on ledger side: Mar 14 · Check 1042 · $200.00 (outstanding)
Check 1042 is a timing difference. The wire fee was never booked. Both explain the gap.

The numbers above are an illustration, not real client data.

Need a discrepancy report for your files?

Upload your bank statement and ledger. The free scan shows how many items matched and the total gap.

Go to Reconciliation →

Frequently Asked Questions

What is the difference between a discrepancy report and a bank reconciliation?

A bank reconciliation is the whole process of agreeing the bank balance to the books. The discrepancy report is the list of items that did not agree along the way, with the reasons.

Do I need a discrepancy report if my totals already match?

Not always. Matching totals can hide offsetting errors, such as one missing item and one duplicate of the same size, so some firms keep the item-level list anyway.

Does Sheet Audit work with Excel and CSV files?

Yes. It accepts .xlsx and .csv files. For PDF statements, convert them to a spreadsheet first.

Is the full report free?

The scan, which shows the counts and total gap, is free. The full row-by-row report is $7.99 for a 24-hour pass while the beta lasts.