Bank Reconciliation in Excel — Step by Step

BRS kya hai

Bank balance (statement) vs cash book balance (tumhare records) ka match — differences: cheques in clearing, un-cleared deposits, bank charges jo tumne book nahi kiye, direct credits (interest, refunds).

Excel method (converter ke saath)

1. Bank statement PDF → Excel (Balance column verified — 100% check matlab data pakka sahi)
2. Apni cash book Excel me side-by-side rakho
3. Common key = Date + Amount + Ref (converter Ref column deta hai — cheque/UPI/NEFT numbers)
4. =COUNTIFS() se matched rows mark karo; un-matched = pending items
5. Adjusted balance = statement balance + un-credits − un-debits

Monthly tips

• Bank charges (auto-categorized) turant book karo — warna har month BRS me atakta hai
• Duplicate rows (yellow-marked) reconcile me skip karo — converter ne already flag kiya hai