ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Bank Reconciliation Statement (BRS) Format in Excel
2
3
Business NameABC Traders
4
Bank AccountCurrent Account
5
Reconciliation Date30 September 2026
6
7
ParticularsAmount (₹)
8
Balance as per bank statement47,500
9
Add: Deposit in transit5,000
10
Less: Outstanding cheque3,000
11
Adjusted bank balance49,500
12
Balance as per cash book50,000
13
Less: Bank charges not recorded in cash book500
14
Add: Interest credited by bank not recorded in cash book-
15
Adjusted cash book balance49,500
16
Difference after reconciliation-
17
Reconciliation statusReconciled
18
19
How to use: type only in the yellow cells (blue text). All other cells are formulas and update automatically.
20
Adjusted bank balance = B8 + B9 - B10. Adjusted cash book balance = B12 - B13 + B14. Difference = B11 - B15.
21
Sample figures (ABC Traders) come from the example in the blog post. Row 14 (interest) is set to 0 in the sample.
22
A bank debit not yet in the books reduces the cash book balance; an unrecorded bank credit increases it.
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
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