Bank Reconciliation In Tally Prime: A Step-By-Step Guide

Key Takeaways

Bank Reconciliation In Tally Prime, Defined. Bank reconciliation in Tally Prime is the process of matching every entry in your Tally bank ledger against the corresponding line on your bank statement, then tagging each matched pair with a bank date. Unmatched items — cheques in transit, bank charges not yet booked, NEFT credits pending — surface as the reconciling difference. ICAI's Guidance Note on Audit of Cash and Bank Balances (Revised 2018) requires the auditor to obtain and verify this reconciliation statement as part of cash and bank balance verification.
The Most Common Misconception: Monthly Is Enough. Most SME teams run BRS once at month-end and then scramble when auditors ask for weekly working papers. Neither the Companies Act, 2013 nor MCA prescribes a rigid weekly frequency, but ICAI SA 330 (The Auditor's Responses to Assessed Risks) expects the auditor to test whether reconciliations are performed "periodically" as an operating control. A monthly cadence that is always three weeks stale does not demonstrate an operating control, a weekly cadence does.
Date Mismatches Are A System Feature, Not An Error. NEFT operates 24x7 in 30-minute batch cycles; RTGS and IMPS settle in real time (RBI notification dated 14 December 2020 for RTGS 24x7). Despite this, individual banks may post credits on the next business day's statement due to internal end-of-day cut-offs. Under CTS (Cheque Truncation System), local cheques clear in T+1 working days. These lags are expected reconciling items, not mistakes in your Tally entries.
Unbooked Bank Charges Are A Hidden GST Cash Risk. Bank charges, interest debits, and bounce fees that appear on your bank statement but are missing from your books inflate your apparent cash balance. If your GSTR-3B payment is based on that inflated figure, you may underpay tax. Interest under Section 50(1) of the CGST Act accrues from the due date of payment at 18% per annum on the net shortfall.
Auto-Reconcile Clears 80% In One Pass With The Right Setup. Tally Prime's Alt+R auto-reconcile matches transactions by amount and instrument number first, then by date. The prerequisite is a correctly configured bank ledger — with bank account number, IFSC code, and bank name filled in under Gateway of Tally > Create > Ledger > Bank Accounts. Imported bank statements in CSV or Excel format give the matching engine clean data to work with, versus manual narration entries that produce false non-matches.

Bank Reconciliation In Tally Prime: The Short Answer

Every unreconciled bank line at month-end is a potential misstatement in your cash balance, and a delayed GST payment triggered by that misstatement attracts interest at 18% per annum under Section 50 of the CGST Act, 2017.

Bank reconciliation in Tally Prime compares every transaction in your Tally bank ledger to the corresponding entry on your imported bank statement, flags unmatched items, and lets you tag each matched pair with a confirmed bank date to close the reconciling difference.

Tip: Configure the bank ledger first, import second. Most auto-match failures trace back to an incomplete ledger master.

How Bank Reconciliation In Tally Prime Works, In One Section

Configure Your Bank Ledger. Go to Gateway of Tally > Create > Ledger. Set Group to Bank Accounts. Enter the bank account number, IFSC code, bank name, and branch. Set Set/Alter Banking Configuration to Yes. Without this, Tally cannot link imported statement lines to the correct ledger.
Open The Bank Reconciliation Screen. Go to Gateway of Tally > Banking > Bank Reconciliation. Select your bank ledger. The screen shows all unreconciled vouchers in your books alongside the current bank ledger balance.
Import The Bank Statement. Press Alt+O (Import) from the Bank Reconciliation screen. Select Bank Statement. Choose your file — Tally Prime accepts CSV, XLS/XLSX, MT940, JSON, and XML formats. Map the columns (date, amount, narration, instrument number) to Tally's fields.
Run Auto-Reconcile. Press Alt+R. Tally matches lines by amount and instrument number. Matched pairs are tagged automatically with the bank date from the statement.
Review Unmatched Items. Scroll through remaining unmatched lines. Post missing entries, for example bank charges, interest, bounced cheque reversals, as vouchers. Then re-run Alt+R or manually assign bank dates.
Export The BRS Report. Press Alt+E to export the Bank Reconciliation Statement to Excel or PDF for filing.

The rule most teams get wrong: they import the statement but skip ledger configuration, so Tally cannot auto-match anything. Fix the ledger master first, import second.

What Does Bank Reconciliation In Tally Prime Actually Solve For Your Close?

An unreconciled bank ledger can overstate or understate cash, delay accurate GST payment calculations, and weaken audit control evidence. Running BRS weekly, not monthly, closes these risks before they compound.

Why Cash Accuracy Matters Before The 20th Of Each Month

Your GSTR-3B payment is due by the 20th of the succeeding month. If unbooked bank charges or a bounced cheque receipt has inflated your Tally bank balance by ₹50,000, you may authorise a tax payment the actual bank account cannot fund. Section 50(1) of the CGST Act, 2017, charges 18% per annum interest from the due date on any shortfall. A ₹50,000 shortfall held for 30 days costs roughly ₹740 in interest — avoidable with a reconciled balance before the payment date.

What Audit Standards Expect From Your BRS

ICAI SA 505 (External Confirmations) explains that external confirmations of bank balances provide reliable evidence on existence. Your BRS is the internal document that must agree to that confirmation. SA 330 names reconciliation to supporting records as a key period-end control. If your BRS is a one-off month-end exercise with no working papers, auditors treat the control as not operating.

How NEFT, RTGS, IMPS, And CTS Create Expected Date Gaps

NEFT settles in 30-minute batch cycles 24x7, RTGS and IMPS settle in real time. Yet banks may post a late-night credit on the following business day due to internal cut-offs. Under CTS, local cheques typically clear in T+1 working days. These are expected reconciling items, not errors in your Tally entries.

Your Weekly BRS Checklist

Import the latest bank statement on a fixed day each week.
Run Alt+R auto-reconcile immediately after import.
Post any new bank charges or interest debits as vouchers before closing.
Export the BRS report (Alt+E) and save it in your working-paper folder.
Confirm the BRS closing balance matches the bank statement closing balance.

How often should I run bank reconciliation in Tally Prime for a ₹10 crore turnover business?

Weekly is the practical standard. While guidance uses the word “periodically,” SA 330 expects evidence that controls operate. A weekly reconciliation with saved exports creates that audit trail, while monthly leaves long windows for undetected errors.

Does Tally Prime automatically update when bank transactions happen?

No. Tally Prime is not bank-connected in real time by default. You must import a bank statement file manually or through an integration. Tally reconciles what is in your ledger against what you import.

How To Set Up Your Bank Ledger And Import The Bank Statement In Tally Prime

A correctly configured bank ledger lets the auto-match engine do the heavy lifting. A bare ledger with no account number leaves everything unmatched.

Configuring The Bank Ledger Master

Go to Gateway of Tally > Create > Ledger. Under Group, select Bank Accounts. Fill in:

Bank Name — the full name as it appears on your statement.
Account Number — your current account number exactly as the bank has it.
IFSC Code — useful for matching NEFT/RTGS credits by reference.
Branch — optional, helpful for multi-branch accounts.

Set Set/Alter Banking Configuration to Yes. This unlocks additional fields and enables banking features, including statement import.

Supported Import Formats And The Import Path

Tally Prime accepts bank statements in CSV, XLS/XLSX, MT940, JSON, and XML. Most Indian banks offer CSV or Excel from net banking. Download the period you want to reconcile. Do not open and re-save the file in Excel before importing, reformatting can corrupt date fields.

From Gateway of Tally > Banking > Bank Reconciliation, select your bank ledger, press Alt+O (Import) and choose Bank Statement. Map columns:

Date column → Transaction Date
Debit/Credit columns → Amount
Narration/Description → Narration
Cheque/Reference Number → Instrument Number

Save the mapping. Tally Prime remembers it for future imports in the same format.

How AiA Removes The Download-And-Map Step

If your bank only gives PDFs, mapping raw text to Tally’s format is manual. AiA ingests PDF and CSV statements, structures transactions with AI-predicted ledger classifications, and pushes clean entries into Tally Prime, turning mapping into a one-time configuration.

What is the bank statement entry in Tally Prime if my bank only gives PDF statements?

Tally’s native import works best with CSV or Excel. If the bank provides only PDF, either convert the PDF to CSV and import, or use an integrated platform like AiA that handles PDF ingestion and pushes structured entries into Tally. Manual entry is possible but defeats automation.

Can I import multiple months of bank statements at once in Tally Prime?

Yes. You can import multi-month files. Tally will match across the covered date range. Maintain an import log to avoid duplicates if you later import overlapping periods.

What is the correct bank entry in Tally Prime for a direct debit by the bank?

Create a Payment voucher: debit the appropriate expense ledger (for example, Bank Charges), credit the bank ledger, dated to the bank statement date. Then match it in the BRS.

How To Run The Bank Reconciliation Statement In Tally Prime And Clear 80% In One Pass

What Alt+R Auto-Reconcile Actually Does

Press Alt+R from the Bank Reconciliation screen. Tally compares statement lines to unreconciled vouchers in this order:

Amount (exact) — values must match precisely.
Instrument/Cheque Number — exact match confirms despite minor date differences.
Date — differences show in the Bank Date column and can be manually confirmed.

There is no tolerance slider. Amount and instrument must match exactly; date differences are visible for review.

Reviewing The Bank Reconciliation Statement In Tally Prime

Date — voucher date in your Tally books
Instrument No. — cheque or reference number
Instrument Date — date on the cheque or payment instrument
Particulars — ledger account in the voucher
Transaction Type — Payment, Receipt, or Contra
Amount — transaction value
Bank Date — date the transaction appears on the bank statement
Unreconciled Debit/Credit — amount not yet matched to a bank statement line

Lines where Bank Date is blank are unreconciled. Either the bank has not processed the transaction yet, or your books are missing an entry such as a bank charge or interest debit.

Printing And Exporting The BRS Report

Print: Press Alt+P for the standard BRS with opening balance, reconciling items, and closing balance per bank.
Export: Press Alt+E, choose Excel or PDF, and save as BRS_[BankName]_[YYYYMMDD].xlsx for audit documentation.

ICAI SA 230 (Audit Documentation) requires adequate working papers to evidence procedures performed and results obtained. Retain BRS exports accordingly.

How do I view the bank reconciliation statement in Tally Prime for a specific date range?

Open Gateway of Tally > Banking > Bank Reconciliation, select the bank ledger, press F2 to set the period. The report shows vouchers and statement entries within that range with opening unreconciled carried forward.

What does “unreconciled” mean in the Tally Prime BRS report?

It is a voucher in your bank ledger not matched to any statement line. Common reasons include cheque in transit, incomplete statement period, or an incorrect amount/instrument number in the voucher blocking the match.

How To Handle Exceptions: Charges, Interest, Bounced Cheques, And UPI Credits

Bank Charges And Service Fees

Rule: Create a Payment voucher dated to the bank statement debit date. Debit Bank Charges Account, credit the bank ledger, then re-run Alt+R or assign the bank date.

Example: Statement shows ₹600 debit on 3 June for maintenance charges. Post: Dr Bank Charges ₹600 / Cr Bank ₹600 dated 3 June, then match.

Note: RBI waived its own NEFT/RTGS charges and directed banks to pass on the benefit. If you see unusual NEFT fees, verify against the bank’s tariff or the circular DPSS.CO.PD.No.146/02.14.008/2018-19.

Interest Income And Overdraft Interest

Interest income: Create a Receipt voucher, credit Interest Income, debit bank, dated to the credit date.

Overdraft interest: Create a Payment voucher, debit Interest on Overdraft or Finance Charges, credit bank, dated to the debit date.

Example: OD interest ₹3,200 on 30 June: Dr Interest on Overdraft ₹3,200 / Cr Bank OD ₹3,200, then match.

Bounced Cheques And Reversals

Rule: For an outward cheque bounce, reverse the Payment. For an inward bounce, reverse the Receipt, re-open the customer balance, and post bank return charges separately as Bank Charges.

Example: Customer cheque ₹25,000 received on 5 June bounces on 8 June with ₹350 fee. Post on 8 June: Dr Customer ₹25,000 / Cr Bank ₹25,000 (reversal), and Dr Bank Charges ₹350 / Cr Bank ₹350 (fee). Match both lines.

UPI And IMPS Credits: When Date Differences Appear

UPI and IMPS are real-time, but failed transactions can auto-reverse on T+1 as per RBI DPSS.CO.CHD.No.2012/03.01.03/2017-18. You may see a credit on Day 1 and a debit on Day 2. Post both to keep ledgers aligned.

How AiA helps: AiA auto-classifies recurring charges and interest, flags likely duplicates, and reduces exception review to a quick pass.

How do I record a bank charge in Tally Prime that appears on the statement but was not booked?

Create a Payment voucher dated to the statement debit. Debit Bank Charges or Interest on Overdraft as applicable, credit the bank ledger, save, then match in the BRS screen.

What is the correct entry in Tally Prime when a customer's cheque bounces?

Reverse the original receipt (Dr Customer / Cr Bank) and book the bank’s return fee (Dr Bank Charges / Cr Bank), both dated to the bank’s processing date. This re-opens the debtor balance for follow-up.

How To Lock Down Your Month-End: Cadence, Controls, And Pre-Close Review

The Weekly Rhythm That Makes Month-End A Confirmation

Download the prior week’s statement from net banking.
Import into Tally Prime using Alt+O from the Bank Reconciliation screen.
Run Alt+R to clear auto-matches.
Post exceptions as vouchers and re-match.
Export the BRS (Alt+E > Excel) and file as BRS_[BankName]_[YYYYMMDD].xlsx.

Pre-Close Controls Before The 20th

Match Tally bank ledger balance to the bank statement closing balance.
Confirm all bank charges and interest are posted.
Reverse bounced cheques and re-open debtor ledgers.
Book UPI/IMPS dispute reversals, if any, on T+1 dates.
Ensure the BRS shows zero unreconciled items, or only known cheques in transit with instrument numbers and dates.

A ₹1,00,000 overstatement that delays your GSTR-3B by a month costs about ₹1,480 in interest at 18% per annum. A clean BRS eliminates this expense.

What ICAI SA 230 Requires You To Retain

Imported bank statement copy.
Exported BRS report showing matched and unmatched items.
Exception vouchers posted during the period.
Evidence of review, for example a date-stamped sign-off.

When The Bank Statement And Tally Still Do Not Agree At Month-End

Duplicate import: verify the same file was not imported twice.
Date range mismatch: align statement period with the reconciliation period.
Altered vouchers: check Gateway of Tally > Audit & Compliance > Audit Trail for post-reconciliation changes.
Contra entries: ensure bank-to-bank or cash-to-bank transfers are mapped correctly.

What audit evidence does the bank reconciliation statement in Tally Prime provide?

The BRS export is corroborating internal evidence. Pair it with external bank confirmations per SA 505. Differences between the two are audit findings.

How does Schedule III of the Companies Act, 2013, relate to bank reconciliation?

Cash and Cash Equivalents must be accurate and reconciled. Unreconciled differences in your Tally bank ledger can misstate this line item, triggering audit adjustments.

References

Frequently Asked Questions

How do I do bank reconciliation in Tally Prime if I have multiple bank accounts?

Create separate bank ledgers for each account under the Bank Accounts group. Reconcile one ledger at a time from Gateway of Tally > Banking > Bank Reconciliation: import the corresponding statement, run Alt+R, clear exceptions, export the BRS, then move to the next ledger.

Can I reconcile a credit card statement in Tally Prime the same way I reconcile a bank account?

Bank Reconciliation is designed for bank accounts. For credit cards, set up a separate ledger, often under Bank Accounts or Current Liabilities, and match statement lines manually on the reconciliation screen for that ledger, or use a platform that ingests card statements and pushes entries into Tally.

What happens if I import the same bank statement twice in Tally Prime?

Tally does not auto-detect duplicate imports. You will see duplicate statement lines. Remove the duplicate import and re-run auto-reconcile. Maintain a log of imports with file names and periods to prevent this.

What if my bank statement shows a transaction that I cannot find in my Tally ledger at all?

It is a missing entry. Identify the type from the bank narration, then create the correct voucher in Tally: Payment for bank debits, Receipt for credits, dated to the statement date. Return to the BRS and match it.

Does bank reconciliation in Tally Prime work for GST-related bank transactions like TDS or advance tax payments?

Yes. Post these as Payment vouchers against appropriate ledgers (Advance Tax, TDS Payable, GST Payable). They will appear in the BRS and match by amount and date like other transactions. Include BSR/challan numbers in narration for reference.

How do I handle a transaction that is in Tally but will only appear on next month's bank statement?

Leave it unreconciled as a cheque in transit or pending clearance. When the next statement arrives and the line appears, import and re-run Alt+R to clear it. Do not change the voucher date to force a match.

What is the interest rate for delayed GST payment, and how does an unreconciled bank balance contribute to that risk?

Section 50(1) of the CGST Act sets 18% per annum from the due date, typically the 20th of the next month for GSTR-3B. An overstated bank balance can cause an underfunded or delayed payment, incurring interest until the shortfall is cleared.

Can Tally Prime auto-reconcile UPI and IMPS transactions by UTR number?

Yes, if the UTR appears in both places. Enter the UTR in the Instrument No. field when posting the voucher, and map the statement’s UTR column to Instrument Number during import. Alt+R will then match exactly on UTR and amount.

Written By

Rohan Sinha

Rohan Sinha is a fintech and growth leader building aiaccountant.com, focused on simplifying accounting and compliance for Indian businesses through automation. An IIT BHU alumnus, he brings hands-on experience across 0 to 1 product building, growth, and strategy in B2B SaaS and fintech.