ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Instructions for Using the Bank Reconciliation Template Workbook
2
3
Important Notice for Template Users
4
This Excel template is designed as a general framework to assist in structuring financial processes. However, every organization has unique policies, systems, and workflows that may require modifications to fit specific needs.
5
6
Customization & Verification Required:
7
8
✅ Modify fields, formulas, and categories to align with your company’s policies.
9
✅ Test all calculations to ensure accuracy before implementation.
10
✅ Verify outputs with your finance team or auditors for compliance.
11
✅ Regularly review and update the template as your processes evolve.
12
13
This template serves as a starting point—adjust as needed to maximize effectiveness.
14
15
16
Overview
17
18
This Bank Reconciliation Template is designed to help organizations efficiently reconcile their cash accounts by comparing bank statement balances with the general ledger (GL). It ensures that all transactions are accurately recorded and any discrepancies are promptly identified and addressed.
19
20
21
Steps to Complete the Bank Reconciliation
22
23
1. Compare Cash Balances:
24
• Ensure that the Cash balance in the GL matches the balance on the bank statement for the period under review.
25
• If they do not match, investigate discrepancies.
26
27
2. Identify Reconciliation Items:
28
• Compare transactions in the bank statement to those recorded in the GL.
29
• List all outstanding checks (issued but not cleared) and deposits in transit (recorded but not yet credited by the bank).
30
• Identify any bank fees, interest income, or other unrecorded transactions.
31
32
3. Prepare Adjustments:
33
• Record necessary journal entries for bank fees, interest income, or other unrecorded transactions to update the GL.
34
• Ensure that adjustments are properly documented and approved.
35
36
4. Recalculate Adjusted Balances:
37
• Subtract outstanding checks and add deposits in transit to the bank balance.
38
• Add or subtract any adjustments to arrive at the adjusted GL and bank balances.
39
40
5. Ensure Final Reconciliation:
41
• Confirm that the adjusted GL balance matches the adjusted bank balance.
42
• If they do not match, investigate and resolve remaining discrepancies.
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100