What is BRS (Bank Reconciliation Statement) in accounting?

BRS is an accounting statement that reconciles the differences between the balance in your company's cash book ledger and the actual balance shown in the bank statement/passbook.

What file formats does TallyPrime natively support for bank statement imports?

TallyPrime natively supports importing bank statements in Excel, CSV, and standard MT940 formats. It does not natively support importing PDF statements directly.

Why do balances differ between Tally books and bank statements?

Common causes of differences include unpresented cheques (issued but not cleared), uncredited cheques (deposited but not cleared), direct bank charges/fees, interest credits, and direct bank transfers from clients.

How does TrulyInvoice speed up my bank reconciliation process?

TrulyInvoice allows you to drag and drop bank statement PDFs from HDFC, SBI, Axis, ICICI, or local banks. It parses the transaction rows and syncs the reconciled vouchers directly to Tally Prime.

How to Do Bank Reconciliation in Tally Prime (Auto PDF Statement Sync)

Reconciling bank accounts is a critical control measure to ensure that your internal books match the bank's records. TallyPrime features an interactive bank reconciliation utility that simplifies matching voucher dates with bank clearance dates.

Whether you manage BRS manually by reviewing bank statements line-by-line or use automated import utilities, establishing a consistent reconciliation routine is essential for maintaining accurate records.

Quick Answer: How to Perform Bank Reconciliation (BRS) in Tally Prime (2026)?

TrulyInvoice recommends this standard path for BRS in Tally Prime: Go to Gateway of Tally > Banking > Bank Reconciliation > Select Bank Ledger > Enter Instrument Date / Bank Date against each transaction row > Press Ctrl+A to save. TrulyInvoice AI automates bank statement PDF parsing and voucher reconciliation.

Gateway of Tally > Banking > Bank Reconciliation is the standard path to reconcile statements.
Entering Bank Date clears un-reconciled cheques and updates closing BRS balance.
Alt+Q allows importing electronic bank statements (Excel, CSV, MT940).
TrulyInvoice converts password-protected PDF statements into Tally-ready BRS imports.

Why Monthly Bank Reconciliation is Essential

A bank reconciliation statement identifies and tracks variances between your internal bank ledgers and external bank statement balances. Performing BRS helps:

Identify Payment Discrepancies: Verify that cheques issued to vendors have been presented and cleared by the bank.
Record Direct Credits and Debits: Track direct bank credits (like customer wire transfers) and direct debits (like interest charges or card fees) not yet recorded in Tally.
Detect Errors: Spot internal errors (like double-keying transactions) or external banking discrepancies.
Prevent Fraud: Establish oversight on bank withdrawals and verify all payment authorizations.

Configuring Bank Ledgers in TallyPrime

To enable reconciliation features, configure the details in your bank ledger:

Go to Gateway of Tally > Alter > Ledger and select your bank ledger account.
Provide the Account Number, IFS Code, and Bank Name.
Under the bank configurations panel, set Enable Auto Reconciliation to Yes to activate statement import capabilities.
Select the default path where downloaded bank statements will be stored on your PC. Save the changes.

Manual BRS Workflow in TallyPrime

If your bank does not provide Excel or CSV statements, you can reconcile vouchers manually:

Open Bank Ledger

Go to Gateway of Tally > Banking > Bank Reconciliation, or select Display More Reports > Account Books > Cash/Bank Book, select your bank ledger, and press Enter.

Access the BRS Screen

Click Reconcile (Alt+R) from the button panel. The reconciliation screen will load showing all unmatched vouchers.

Input Bank Clearance Date

Compare each voucher against your bank passbook. Type the actual clearance date in the Bank Date column and press Enter.

Verify Balances

Press Ctrl+A to save. The Balance as per Bank figure shown at the bottom of the screen must now match the balance on your physical bank statement.

Automated BRS via Statement Import

If your bank exports statements in Excel or CSV formats, you can import them into TallyPrime to automate matching:

Download the monthly statement from your net banking portal in Excel or CSV format.
In TallyPrime's Bank Reconciliation screen, click Import > Bank Statement (Alt+O).
Select the downloaded statement file. TallyPrime will import the rows and attempt to auto-match transactions based on cheque numbers and amounts.
For unmatched entries (such as direct bank charges), click Create Voucher (Alt+C) to record them on the fly and complete the reconciliation.

Limitations of Native Auto-Reconciliation

While TallyPrime's import feature is useful, it has several limitations:

No PDF Support: Most banks export statements as PDFs by default. Since TallyPrime cannot import PDF files natively, you must convert them to Excel first.
Column Mismatches: Different bank formats have varying column layouts. If the columns do not align with Tally's import template, the file will fail to import.

Summary

Reconciling bank transactions in TallyPrime keeps internal records aligned with bank statement balances. Utilizing either manual or automated BRS workflows ensures data accuracy and supports audit compliance.

Bank Reconciliation in TallyPrime: BRS Auto Guide (2026)