Bank Statement vs Ledger: Compare Line by Line and Reconcile

Bank Statement vs Ledger: Compare Every Line and Find the Gaps

A bank statement and a ledger describe the same account from two sides, so every line on one should appear on the other. In practice they drift apart. Your books record a cheque the day you write it, the bank records it the day it clears, and fees reach the statement before anyone posts them. This page shows how to compare the two documents line by line, and how the tool does it for you.

Quick answer: Export your ledger for the same dates as the statement, upload both files above, then work through the entries that exist on only one side and the mismatches. Matched pairs need no action.

Bank Statement vs Ledger: What Is the Difference?

The two documents record the same cash, but they differ in who keeps them, when they record and which direction they use.

Why the Debit and Credit Directions Look Reversed

A bank describes your account from its own point of view. Your deposit is money the bank owes you, so the bank records a credit. In your books, the same deposit increases an asset, so you record a debit. Both entries are correct, and the tool detects which convention your ledger uses before it matches anything.

Ledger, Bank Book and Cash Book: Which Do You Have?

Different businesses use different names for the same record.

• General ledger bank account. The bank account's transaction list in your accounting software.
• Bank book. A separate book that records only bank transactions.
• Cash book. A book with a cash column and a bank column. Compare only the bank column with the statement.

How to Compare a Bank Statement With a Ledger

The tool replaces the slow part of the job: ticking off hundreds of lines by hand.

1. Export the ledger. From QuickBooks, Xero, Tally, Zoho Books, Sage, NetSuite or a spreadsheet, export the bank account's transactions for the statement's exact date range.
2. Upload both documents. The statement can be a PDF, a scan or photo, a CSV or an Excel file. The ledger works best as Excel or CSV.
3. Set your date tolerance. The default is 2 days. Widen it if cheques in your business clear slowly.
4. Review the comparison. Read the matched pairs, then the gaps on each side, then the mismatches.
5. Post your adjustments and download. Record the entries your books need, then save the report as your working paper.

What the Comparison Looks For

The tool reduces each entry to a date, an amount, a direction (money in or out), a reference and description keywords. Then it sorts every entry into one of these groups.

• Matched. The entries have the same amount and direction, with dates inside your tolerance. A matching reference or similar description raises the confidence.
• Amount mismatch. The entries share a reference, or have a similar description with amounts within 20% of each other, inside the date tolerance. The report shows the difference.
• Direction mismatch. The entries have the same amount but opposite directions, and a reference or description links them.
• Unmatched. The entry has no partner. The report gives the reason, for example that the nearest entry with the same amount is six days away, outside a two-day tolerance.
• Duplicate. The same entry appears twice in one document. The tool flags duplicates but never removes them.

Bank Statement vs Ledger Example

This example shows how the report classifies six entries for September.

What Each Result Tells You

• The matched entries need no action.
• The 90.00 amount mismatch points to a keying error. Someone entered 540 as 450. Correct the ledger.
• The direction mismatch means you recorded the transfer as money out, but the bank shows money in. Check which account the transfer went to, then correct the entry.
• The interest exists only on the statement. Post an entry in your books.
• The unmatched cheque is likely a timing difference. It was written on 29 September and should clear in October.

How to Fix Each Type of Difference

Use the table below to decide what to do with each group.

Timing Differences vs Real Errors

A timing difference clears on its own and needs no entry. A real error stays in place until someone corrects it. Check the date: an entry in the last few days of the period is probably timing. An entry that has stayed unmatched for weeks is probably a real error.

Confirm That the Balances Agree

A line-by-line comparison finds the differences. A balance check proves you found all of them.

The tool verifies opening, closing and running balances for both the statement and the ledger. It then compares the change between the two balances with the net effect of every unmatched item and mismatch. When the unexplained difference is zero, the listed items fully explain why the two balances disagree. A non-zero figure usually means the tool missed or misread a transaction, so check the warnings first.

If you only need to work out the adjusted balances, use the bank reconciliation calculator.

Which Ledger Files Does the Tool Read?

The tool reads these files:

• Excel (.xlsx) and CSV. The tool reads these directly without OCR, so they give the most reliable result.
• PDF, scans and photos. The tool uses OCR, which works well on clear, flat documents.

For spreadsheets, the file needs a header row within its first 30 rows, with a date column and at least one amount column. The tool recognises headers such as Date, Narration, Particulars, Debit, Credit, Withdrawal and Deposit, or a single signed Amount column. A row that starts with Opening Balance or Balance B/F sets the opening balance. It also recognises common German, French, Spanish, Portuguese and Dutch headers and comma-decimal numbers like 1.234,56.

Bank Ledger Reconciliation: Monthly Checklist

Use this checklist when you reconcile each month.

• Export the ledger for the exact statement dates.
• Confirm that both opening balances match last month's reconciliation.
• Run the comparison and clear the matched pairs.
• Separate timing items from real errors.
• Post entries for bank-only items.
• Correct amount and direction mismatches at the source.
• Check that the unexplained difference is zero.
• Sign, date and file the working paper.

For a full walkthrough with a worked example, see the bank reconciliation tool. To understand how individual transactions are paired, read the bank statement matching tool.