Get a free bank reconciliation Excel template that auto-populates from your bank statement PDF. Convert your PDF to structured Excel data in seconds, paste into the template, and reconcile faster.
📊 Get Bank Data in Excel →Free · No signup · Paste data into your reconciliation template instantly
Choose PDF FileA standard bank reconciliation Excel template compares your cash book against the bank statement. Here is what the populated template looks like.
| Date | Description | Cash Book Dr | Cash Book Cr | Bank Stmt Dr | Bank Stmt Cr | Matched | Difference |
|---|---|---|---|---|---|---|---|
| 2026-07-01 | UPI — Received from Aman | 12,000 | 12,000 | ✓ Yes | 0 | ||
| 2026-07-03 | ATM Cash Withdrawal | 10,000 | 10,000 | ✓ Yes | 0 | ||
| 2026-07-08 | Cheque #001234 — Rent | 35,000 | ✗ No | −35,000 | |||
| 2026-07-10 | Bank Charges — Statement Fee | 500 | ✗ No | +500 | |||
| 2026-07-15 | NEFT — Salary July 2026 | 55,000 | 55,000 | ✓ Yes | 0 |
Unmatched rows (cheque not yet presented, bank charges not in cash book) are the items that need to be listed in the BRS to explain the difference between book balance and bank balance.
The Bank Reconciliation Statement format used by Indian businesses, accountants, and CAs.
Upload your bank statement PDF. Download the structured Excel file with Date, Description, Debit, Credit, Balance columns.
Copy the bank statement rows from the converted Excel into your reconciliation template's "Bank Statement" columns.
Copy your cash book or ledger entries into the "Cash Book" columns for the same period.
Use VLOOKUP or Excel's conditional formatting to auto-match entries. Unmatched items form your reconciling items.