Sheets
4
Separate the reconciliation flow
Finance Excel template
Download the Bank Reconciliation Log Template for free. Manage bank statements, journal entries, differences, and reconciliation notes in one workbook.
A free Excel template that makes bank statements, journal entries, differences, and reconciliation notes easier to keep in one workbook. The same page also shows the matching web-screen flow.
Free download
Bank statements
Journal entries
Differences
Workflow
Traceable
Make unmatched items visible
Input
Shareable
Easy to share with accounting
Input example
Start by aligning the bank reconciliation assumptions
If statement number, account name, owner, and reconciliation status are aligned first, monthly close stays stable.
Reconciliation no.
BR-2401
Reconciliation date
2026-04-13
Owner
Daniel Lee
Bank branch
Tokyo Main Branch
Free download
See what is inside the Excel version first
A free Excel template that makes bank statements, journal entries, differences, and reconciliation notes easier to keep in view. After downloading, start by organizing the reconciliation rules and difference handling.
File
finance_bank_reconciliation_log_template_en.xlsx
Sheets
4 sheets
Purpose
Statements, differences, reconciliation
Keeping statement numbers, account names, dates, and owners aligned helps reduce missed checks.
Statements and ledger items stay in one workbook, so unmatched items are easier to spot.
The reconciliation history can stay in the same flow, which also helps with month-end close.
Start by organizing the statement and reconciliation assumptions.
How Excel is used
How to run bank reconciliation in Excel
Keeping statement import, reconciliation checks, difference sorting, and month-end close in one flow reduces missed items.
Step 1
Import statements
First define the statement number and account name, then align the monthly review checkpoints.
Step 2
Update reconciliation
Organize the statement-to-ledger matching results so unmatched items can be found early.
Step 3
Check differences
Log the difference reasons and follow-up status so the next action is always clear.
Step 4
Month-end close
Bundle the month-end results and remaining differences into a format you can reuse next month.
Excel to screen mapping
Which Excel column becomes which screen
Mapping the bank reconciliation data structure directly to the screen design makes the statement-to-ledger matching flow easier to understand.
Excel element
System element
Notes
Excel element
Statement list
System element
Statement table
Notes
Track statement number, deposit, withdrawal, and account name.
Excel element
Reconciliation list
System element
Reconciliation board
Notes
Keep unmatched items and review status visible.
Excel element
Difference history
System element
Activity timeline
Notes
Record difference reasons and follow-up dates as history.
Excel element
Account notes
System element
Notes board
Notes
Keep account-specific rules and exception notes together.