Bank Reconciliation in TallyPrime: Step-by-Step Guide (2026)

Bank reconciliation is one of the most important periodic tasks for any business. It ensures that your company's books of account match the bank's records, helping you catch errors, unauthorized transactions, and timing differences before they snowball into bigger problems. TallyPrime offers multiple ways to perform bank reconciliation -- from manual matching to fully automated Connected Banking. This guide walks you through every method available.

What is Bank Reconciliation (BRS)?

A Bank Reconciliation Statement (BRS) is the process of comparing your company's bank ledger entries with the actual bank statement to identify and resolve differences. These differences typically arise from:

• Timing differences: Cheques issued but not yet cleared, or deposits in transit that the bank has not yet processed.
• Bank charges: Interest charges, service fees, or penalties debited by the bank that you have not yet recorded in your books.
• Errors: Wrong amounts, duplicate entries, or transactions recorded in the wrong account.
• Unauthorized transactions: Debits you did not initiate, which could indicate fraud or bank errors.

Regular reconciliation -- ideally monthly or weekly -- keeps your cash position accurate and your books audit-ready. With TallyPrime, this process has become significantly faster thanks to auto-reconciliation and Connected Banking features.

Setting Up BRS in TallyPrime

Before you can reconcile, you need a properly configured bank ledger. Here is how to set it up:

1. Go to Gateway of Tally > Create > Ledger.
2. Enter your bank name (e.g., "HDFC Bank - Current Account").
3. Under Group, select Bank Accounts.
4. Set "Set/Alter banking details" to Yes.
5. Enter the bank details:
   • Account Number: Your bank account number
   • IFSC Code: The branch IFSC code
   • Bank Name: The bank's official name
   • Branch Name: The branch where your account is held
6. Press Ctrl+A to save.

These banking details are essential for Connected Banking and auto-reconciliation. If you have existing bank ledgers without these details, you can update them by altering the ledger (Gateway > Alter > Ledger).

Manual Reconciliation

Manual reconciliation is the traditional method and works well for businesses with a manageable number of monthly transactions. Here is the step-by-step process:

1. Go to Gateway of Tally > Banking > Bank Reconciliation.
2. Select the bank ledger you want to reconcile.
3. TallyPrime displays all unreconciled transactions with columns for Date, Particulars, Amount, and Bank Date.
4. Compare each entry with your bank statement. For matched transactions, enter the Bank Date (the date the transaction cleared in the bank).
5. After matching all transactions, press Ctrl+A to save.

The BRS report will then show you the reconciled balance alongside the book balance, highlighting any remaining differences.

Auto-Reconciliation (Release 6.0+)

Starting with TallyPrime Release 6.0, auto-reconciliation dramatically speeds up the process by automatically matching book entries with bank statement entries. Here is how it works:

1. Import your bank statement: Go to Banking > Bank Reconciliation > select bank > press the Import button. TallyPrime accepts CSV, Excel, and PDF formats.
2. Column mapping: TallyPrime auto-detects common formats. If your bank uses a non-standard format, you can manually map columns (Date, Description, Debit, Credit, Balance) to TallyPrime fields.
3. Automatic matching: TallyPrime matches transactions where the amount and approximate date match exactly. These are marked as "Matched" automatically.
4. Potential matches: For transactions that are close but not exact matches (e.g., slight date differences), TallyPrime shows them as "Potential Matches" for your review.
5. Review and confirm: Accept the automatic matches, review potential matches, and manually handle any remaining unmatched entries.

Auto-reconciliation can cut your monthly reconciliation time from hours to minutes. For businesses processing hundreds of bank transactions monthly, this is a significant productivity gain.

Connected Banking for Automatic BRS

Connected Banking takes automation further by eliminating the need to manually download and import bank statements. Introduced in TallyPrime Release 6.0 and enhanced in subsequent releases, this feature connects TallyPrime directly to your bank account through Tally.NET.

Key capabilities of Connected Banking:

• Supports 145+ Indian banks: Including SBI, HDFC, ICICI, Axis, Kotak, and most regional banks.
• Real-time balance check: View your live bank balance directly within TallyPrime.
• Automatic statement retrieval: Bank statements are fetched directly without manual download.
• Seamless reconciliation: Combined with auto-reconciliation rules, most transactions are matched automatically.

To set up Connected Banking:

1. Ensure you have an active Tally.NET account (included with TSS subscription).
2. Go to Gateway of Tally > Banking > Connected Banking.
3. Select the bank account and follow the on-screen prompts to link it via your bank's authentication process.
4. Once linked, TallyPrime will automatically fetch statements and begin matching.

Want Mark IT's team to handle the Connected Banking setup? Our support specialists configure this for businesses across Mumbai every day.

Custom Matching Rules

Every business has unique transaction patterns. TallyPrime lets you create custom matching rules to handle your specific scenarios:

• Match by amount and date: The default rule. Transactions with the same amount and date (within a configurable tolerance) are matched.
• Match by reference number: If you record cheque numbers or transaction references in TallyPrime, the system can match using these identifiers for higher accuracy.
• Multi-transaction matching: A single bank entry (e.g., a consolidated deposit) can be matched against multiple book entries. This is common when you deposit multiple cheques together.
• Date tolerance: Set how many days of difference to allow between your book date and the bank clearing date. A 3-5 day tolerance works for most businesses.

Common Issues and Troubleshooting

Even with auto-reconciliation, some transactions need manual attention. Here are the most common issues and how to resolve them:

• Duplicate entries: If the same transaction appears twice in your books, reconciliation will fail for one of them. Delete the duplicate voucher and re-reconcile.
• Timing differences: Cheques issued near month-end may not clear until the next month. These will appear as unreconciled entries. Leave them and they will be matched when the next statement arrives.
• Bank charges not recorded: Banks debit service charges, SMS fees, and interest. Create journal entries or payment vouchers for these charges, then reconcile them.
• Amount mismatches: If a payment or receipt amount in your books differs from the bank statement (e.g., partial payment), you may need to split or correct the voucher.
• Foreign currency transactions: Exchange rate differences between the booking date and clearing date can cause mismatches. Use the payment integration features to handle multi-currency reconciliation.
• Statement format not recognized: If TallyPrime cannot parse your bank statement file, try saving it as CSV with UTF-8 encoding. Remove any header rows above the column names and ensure the date column uses DD-MM-YYYY or DD/MM/YYYY format.

Auto vs Manual Reconciliation: Which Should You Use?

Many TallyPrime users wonder whether to stick with manual reconciliation or switch to auto-reconciliation. Here is a quick comparison to help you decide:

Our recommendation: If you are running TallyPrime Release 6.0 or above and process more than 50 bank transactions monthly, switch to auto-reconciliation. The time savings alone justify the initial setup effort. For businesses with Connected Banking enabled, the process becomes almost hands-free.

Monthly Bank Reconciliation Routine: Best Practices

Following a consistent monthly routine ensures your books stay clean and audit-ready. Here is the process we recommend to our clients at Mark IT Solutions:

1. Download or fetch the bank statement on the 1st of each month for the previous month. If you use Connected Banking, TallyPrime fetches it automatically.
2. Run auto-reconciliation first to clear the easy matches. This typically handles 80-90% of transactions instantly.
3. Review potential matches carefully -- these are entries where the date or amount is close but not exact. Often these are cheques that cleared a day or two later than expected.
4. Investigate unmatched entries on both sides:
   • In your books but not in bank: These are cheques not yet presented or deposits in transit. Check if they clear in the next month.
   • In bank but not in your books: These are usually bank charges, interest credits, or direct debits you have not recorded. Create the appropriate vouchers in TallyPrime.
5. Record missing entries using Payment, Receipt, or Journal vouchers as appropriate.
6. Verify the closing balance matches between TallyPrime and the bank statement.
7. Print and save the BRS report for your records. This serves as an audit trail for statutory compliance.

Pro Tip: Do not let reconciliation pile up. Businesses that reconcile weekly spend far less time than those who do it quarterly. Weekly reconciliation also catches errors and unauthorized debits faster, reducing financial risk.

Useful Keyboard Shortcuts for BRS in TallyPrime

Speed up your reconciliation work with these TallyPrime keyboard shortcuts:

• F5: Toggle between reconciled and unreconciled transaction views
• F12 (Configure): Change display settings -- show narration, instrument number, or bank reference
• Ctrl+A: Save reconciliation work and accept all changes
• Ctrl+Q: Quit without saving (useful when you want to discard changes)
• Alt+F5: Change the period for which transactions are displayed
• Alt+F12: Filter transactions using advanced conditions (amount range, date range, etc.)
• Ctrl+Enter: Toggle the reconciliation status of a selected transaction

Bank Reconciliation in TallyPrime 5.x vs 6.x vs 7.x

Bank reconciliation capabilities have evolved significantly across TallyPrime versions. Here is what changed:

• TallyPrime 5.x (and earlier): Only manual reconciliation was available. You had to compare entries one by one with the physical or downloaded bank statement and enter bank dates manually. No import feature for bank statements.
• TallyPrime 6.0: Introduced auto-reconciliation with bank statement import (CSV, Excel, PDF). Also launched Connected Banking for automatic statement retrieval from 145+ Indian banks.
• TallyPrime 6.1: Improved matching algorithms, better handling of multi-transaction matching, and enhanced bank statement column detection.
• TallyPrime 7.0: Further enhancements to Connected Banking, improved reconciliation dashboard, and better support for handling bank charges automatically.

If you are still on TallyPrime 5.x or earlier, upgrading to 6.0+ is strongly recommended for the auto-reconciliation feature alone. Need help upgrading? See our TallyPrime upgrade options.

How to Prepare a Bank Reconciliation Statement (BRS Format)

A Bank Reconciliation Statement follows a standard format that bridges the gap between your book balance and bank balance. Here is the typical BRS format used in TallyPrime:

1. Start with the balance as per your books (the closing balance shown in your TallyPrime bank ledger)
2. Add: Cheques issued but not yet cleared (these reduce your book balance but the bank has not debited them yet)
3. Add: Direct credits by the bank not recorded in books (interest earned, refunds received directly)
4. Subtract: Cheques deposited but not yet credited by the bank (deposits in transit)
5. Subtract: Bank charges, fees, or direct debits not yet recorded in your books
6. Result: Balance as per bank statement

TallyPrime's BRS report automatically calculates this for you. The report shows amounts that have cleared on the bank side, amounts still pending, and any discrepancies. You can generate and export this report in PDF format for your auditor.

7 Common BRS Errors in TallyPrime and How to Fix Them

Based on our experience supporting hundreds of businesses in Mumbai, these are the most frequent bank reconciliation errors we encounter:

1. Opening balance mismatch: Your TallyPrime opening bank balance does not match the bank's opening balance. Fix: Check the previous year's closing reconciliation and ensure all entries were carried forward correctly during data migration or import.
2. Duplicate voucher entries: The same payment or receipt is entered twice. Fix: Use the Edit Log feature to trace when the duplicate was created, then delete the extra voucher.
3. Wrong ledger selection: A bank transaction is posted to the wrong bank account ledger (e.g., HDFC instead of ICICI). Fix: Alter the voucher and change the ledger. The transaction will then appear in the correct bank's reconciliation.
4. Cheque number not entered: Without the instrument number, auto-reconciliation cannot match by reference. Fix: Always enter the cheque/reference number in the Instrument No. field when recording bank payments.
5. Bank statement date format mismatch: TallyPrime cannot parse dates in your imported statement. Fix: Ensure dates are in DD-MM-YYYY or DD/MM/YYYY format. Avoid text-formatted dates like "1st Jan 2026".
6. Partial payments not split: A single bank debit matches multiple book entries (e.g., vendor paid one cheque for two invoices). Fix: Use multi-transaction matching or create a single voucher for the total amount.
7. Interest and TDS not recorded: Banks deduct TDS on interest paid. Both the interest credit and TDS debit need separate entries. Fix: Create a Receipt voucher for interest and a Journal voucher for TDS.