Match your general ledger to your bank statement in minutes. Fill it in below or download a blank copy in Excel, Word, or PDF.
Fill in the fields below and watch the live preview update in real time. Download the completed statement when you are done.
Pick Excel, Word, or PDF. Each has the same two-sided layout ready to fill in.
Fill in your company name, bank, account number, and the period you are reconciling.
Enter the bank statement balance and book balance. Add deposits in transit, outstanding checks, fees, and interest.
If both adjusted balances match, the reconciliation is complete. Save a PDF copy for your records and audit trail.
Grab a blank template in the format that fits your workflow. Every version follows the same two-sided layout with fields pre-labeled.
Spreadsheet with formulas. Best for teams that reconcile in Excel.
Pre-formatted document with tables. Best for teams that need a sign-off copy.
Print-ready layout. Best for physical sign-off and audit binders.
Stop reconciling accounts manually. Let automation handle the volume so your team handles the exceptions.
Bank reconciliation follows the same five steps every time, whether you use a spreadsheet or software. The goal is always the same: both adjusted balances must match.
Pull the bank statement for the period and the corresponding general ledger or cash book from your accounting system.
Note the closing balance on the bank statement and the ending cash balance in the books. They almost never match right away.
List deposits in transit, outstanding checks, bank fees not yet recorded, interest earned, and any errors on either side.
Add or subtract each reconciling item on the correct side. The bank side gets deposits in transit and outstanding checks; the book side gets fees, interest, and errors.
The adjusted bank balance and the adjusted book balance must now be equal. If they are not, re-check each line item until the variance is zero.
Most reconciliation problems come from skipped months, small differences left uninvestigated, or adjustments made without supporting documents.
Bank reconciliation is the process of comparing your internal accounting records against your bank statement to verify that every transaction is accounted for and the two balances agree. It catches timing differences, missing entries, bank fees, and unauthorized charges before they compound into reporting errors.
Yes. There is no cost, no account creation, and no watermark on any format. The interactive tool runs entirely in your browser and the downloadable files are yours to keep and reuse.
Choose Excel if your team reconciles in spreadsheets and needs formulas. Choose Word if you need a formatted document with tables for sign-off and sharing. Choose PDF if you need a print-ready copy for physical sign-off or audit binders.
Monthly is the standard for most businesses. Cash-intensive operations benefit from weekly reconciliation, and enterprise teams with high transaction volumes often move to daily or continuous reconciliation using automation.
Bank reconciliation specifically compares your cash book to the bank statement. Account reconciliation is broader: it covers any balance sheet account (intercompany, receivables, payables, fixed assets) where the recorded balance must match a supporting source.
Yes. Download a separate copy for each account, or duplicate the worksheet tab in Excel. Each account reconciles independently against its own bank statement.
Templates work well when you reconcile a handful of accounts monthly. Once you are handling dozens of accounts, dealing with high transaction volumes, or spending more than a day each month on reconciliation, automation pays for itself in time saved and fewer errors.