Diwali Sale: 25% off everythingEnds in 4d 12h
Draftstack
Bank Reconciliation Statement (BRS) Maker (Excel) – Excel template preview
Excel & SheetsNew

Bank Reconciliation Statement (BRS) Maker (Excel)

Reconcile your books with the bank statement every month: mark what cleared, add bank charges and direct credits, and see the reconciled balance and any difference at once.

₹84₹399Save ₹315 (79%)
Inclusive of all taxes · One-time payment · Instant download
See a free sample (PDF)
Diwali Sale: 25% off, ends 08 Nov, 11:59 PM
Instant downloadOn screen + email
Secure paymentUPI · Cards · Net Banking
7-day helpFix or refund if faulty
Perfect for
Accountants and accounts assistantsSmall businesses, schools and societiesCommerce students
What you get2 × .xlsx (blank + sample)
Works withMicrosoft Excel · Google Sheets · WPS Office
DeliveryInstant download
LicencePersonal & own-business use
Business & Work Mega Bundle: Excel, Canva & Office Tools for Shops, Sellers and Companies – bundle preview Get the whole Mega BundleBusiness & Work Mega Bundle: Excel, Canva & Office Tools for Shops, Sellers and Companies · ₹2,949 · you save ₹13,654See →

Frequently bought together

Bank Reconciliation Statement (BRS) Maker (Excel) – Excel template previewThis item: Bank Reconciliation Statement (BRS) Maker (Excel)₹84Project Report for Bank Loan: Mudra & PMEGP (Excel) – Excel template previewProject Report for Bank Loan: Mudra & PMEGP (Excel)₹262Cash Book, Day Book & Petty Cash Register (Excel) – Excel template previewCash Book, Day Book & Petty Cash Register (Excel)₹112
All three: ₹458Sale prices

The bank balance in your books and on the statement almost never match on the last day of the month. Cheques take days to clear, the bank adds charges you have not entered, and customers pay by NEFT without telling you. A bank reconciliation explains every rupee of the gap.

What it does

  • Books: the month's bank entries from your cash book, with Cleared Yes or No and the bank date
  • Days pending for uncleared items, so old cheques stand out
  • Bank Only: charges, interest, ECS debits and direct credits that are on the statement but not in your books
  • BRS: from the book balance, adds unpresented cheques, subtracts uncleared deposits, adjusts bank-only items and shows the balance as per bank
  • Difference and status: Reconciled or Find the difference

Who it suits

Accountants, small businesses, societies, schools and commerce students learning BRS with a real format.

What's inside

Everything you get

01

Books

Bank entries with cleared status and days pending

02

Bank Only

Charges, interest, ECS, direct credits

03

BRS

Reconciliation with difference check

04

Blank + sample

Sample September reconciliation

Files in your download

  • XLSXBank_Reconciliation_Statement.xlsx20 KB
  • XLSXBank_Reconciliation_Statement_SAMPLE.xlsx21 KB
How to use

Start in 5 simple steps

A step-by-step guide is also included inside your download.

  1. 1

    Enter balances

    Books and statement

  2. 2

    List bank entries

    From the cash book

  3. 3

    Tick what cleared

    With the bank date

  4. 4

    Add bank-only items

    From the statement

  5. 5

    Get to zero

    Fix any difference

FAQ

Questions about this product

What is a BRS?

A statement that explains why the bank balance in your books differs from the bank statement on the same date, item by item.

Which balance do I start from?

The sample starts from the balance as per books. Every item then adds or subtracts until it reaches the bank balance.

How often should I do it?

Every month, as soon as the statement arrives. Monthly BRS catches errors and fraud early.

Does it work for several bank accounts?

Use one copy of the file per bank account.

Is it good for commerce students?

Yes. The sample is a complete worked example with the common items: unpresented cheques, uncleared deposits, charges, interest and direct credits.

How do I get the files after payment?

A download button appears on screen right after payment, and the link is emailed to you. You can also download again any time from My account.

Can I use it on my phone?

Yes. It works with Microsoft Excel, Google Sheets, WPS Office. Free mobile apps are enough.

What if something does not work?

Write to us within 7 days with your order number. We will fix it, send a working file, or refund you.

Our promiseEvery file is tested before launch. If something doesn't work, we fix it or refund you within 7 days. Refund policy
Complete the set

Goes well with this

See all
₹84₹399