We are your reliable technology Partner.
Have any questions? Call Now: +971 4 325 8361 / +971 55 347 5870
Have any questions? Call Now: +971 43 258 361
Bank Reconciliation Statement (BRS) & Payment Entries in Tally Prime and ERP 9
📌 Executive Summary & Core Takeaways
- Discrepancies Are Normal: Gaps between Tally book balances and online banking portals are usually timing differences (unpresented cheques, uncleared deposits) or unrecorded bank deductions.
- Two Categories of Gaps: Timing items resolve automatically once cleared. Real transactions (bank fees, auto-debits, interest) require instant voucher entries.
- Automation in Tally Prime: Tally Prime supports electronic bank statement imports (OFX, XML, CSV, Excel) with intelligent auto-matching, dramatically cutting reconciliation hours.
- Monthly Discipline: Reconciling monthly prevents year-end audit panics, catches unauthorized debits early, and reflects your real working capital cash position.
Quick Navigation • Banking Playbook
If you manage accounting for a UAE business, you have likely encountered this scenario: you check your bank ledger balance in Tally, log into your corporate net banking portal (Emirates NBD, ADCB, FAB, or Mashreq), and discover the two numbers differ by thousands of Dirhams.
Your immediate instinct might be to suspect an error in your books. In most cases, however, you have made no mistake at all. The discrepancy is simply down to timing differences and unrecorded bank activities. A cheque issued to a supplier has not yet been presented, a customer remittance is clearing, or the bank quietly deducted account fees. A Bank Reconciliation Statement (BRS) is the systematic process of identifying, explaining, and reconciling that gap.
What Exactly Is a Bank Reconciliation Statement (BRS)?
A BRS is essentially a side-by-side verification mechanism:
- On one side is the Cash Book bank balance recorded inside your Tally books.
- On the other side is the Pass Book / Bank Statement balance issued by your financial institution.
The objective of a BRS is not to artificially force both figures to match. Rather, it is to isolate the exact reasons why they differ, ensure internal control over company liquidity, and record any genuine transactions that occurred on the bank statement without your prior knowledge.
Why Your Books and the Bank Never Quite Agree
In routine UAE corporate banking, discrepancies arise from a few frequent causes:
1. Cheques Issued but Not Yet Presented
You hand a supplier a post-dated or current cheque on the 28th of the month and enter it into Tally immediately. If the vendor deposits the cheque on the 3rd of the following month, your books show the cash disbursed while the bank still carries the balance.
2. Cheques Deposited but Not Yet Cleared
Customer cheques deposited before a weekend or public holiday require inter-bank clearing cycles (UAE ICCS). Tally debits the bank immediately, but the funds appear on your bank statement 1–2 working days later.
3. Automated Bank Deductions (Charges, Fees & VAT)
Account maintenance charges, inward/outward SWIFT transfer charges, POS rental charges, and VAT on banking services are debited without prior notifications.
4. Direct Credits & Standing Auto-Debits
Customers transferring funds directly via wire/IBAN, interest credits, or auto-debit standing instructions (utility bills, lease payments) remain unrecorded in Tally until the statement is audited.
Worked BRS Calculation Example (UAE Dirhams)
Consider an end-of-month reconciliation scenario for a Dubai commercial entity:
- Cash Book Bank Balance in Tally: AED 85,000
- Cheque issued to vendor unpresented: AED 15,000
- Cheque deposited from customer uncleared: AED 8,000
- Bank maintenance charges unrecorded: AED 500
- Credit interest received unrecorded: AED 1,200
| Particulars | Amount (AED) | Classification & Action |
|---|---|---|
| Balance as per Cash Book (Tally) | 85,000.00 | Starting point |
| Add: Cheques issued but not yet presented | +15,000.00 | Timing difference (Self-correcting) |
| Less: Cheques deposited but not yet cleared | -8,000.00 | Timing difference (Self-correcting) |
| Less: Bank service charges not entered in books | -500.00 | Real transaction (Enter F5 Payment) |
| Add: Interest credited by bank not entered in books | +1,200.00 | Real transaction (Enter F6 Receipt) |
| Balance as per Bank Statement (Pass Book) | 92,700.00 | Target Statement Balance |
Doing Bank Reconciliation in Tally ERP 9
In Tally ERP 9, reconciliation follows a straightforward manual date-stamping routine:
- From Gateway of Tally, navigate to Banking > Bank Reconciliation (or open your Bank ledger through Display > Account Books > Cash/Bank Book and press Alt + R).
- Select the designated Bank Account ledger.
- Tally displays all recorded transactions with voucher dates, particulars, instrument numbers, and voucher types.
- With your physical or PDF bank statement open, examine each cleared line and enter the corresponding Bank Date (the date the transaction cleared your bank account).
- If an instrument has not yet cleared on the statement, leave the Bank Date column completely blank.
- Examine the bottom summary pane:
- Balance as per Company Books: Current balance according to Tally vouchers.
- Amounts not reflected in Bank: Total of uncleared deposits and unpresented cheques.
- Amount not reflected in Company Books: Direct statement lines not yet posted in Tally.
- Balance as per Bank: Calculated figure. When this matches your closing bank statement, your reconciliation is complete.
Doing Bank Reconciliation in Tally Prime (Auto-Import)
Tally Prime transforms bank reconciliation into an automated process through e-Banking statement imports:
Download Electronic Bank Statement
Export your monthly statement from your UAE corporate banking portal in supported formats (Excel, CSV, XML, or MT940).
Open Bank Reconciliation in Tally Prime
From Gateway of Tally, go to Banking > Bank Reconciliation and choose your primary operational bank ledger.
Import Electronic Statement
Click Import > Bank Statement (Alt + O) from the top navigation and select the downloaded file from your directory.
Automated Rule-Based Matching
Tally Prime instantly matches statement records with recorded vouchers using cheque numbers and amounts, stamping bank dates automatically.
Review Unmatched Exceptions
Only unmatched entries remain highlighted. Create quick payment vouchers (Alt + J) for unrecorded bank charges directly from this view.
Recording Payment Entries (F5) & Bank Charges
Whenever company liquidity leaves your cash or bank accounts, you record a Payment Voucher (F5).
1. Standard Office Rent or Operating Expenses
| Ledger | Debit (AED) | Credit (AED) |
|---|---|---|
| Rent Expense A/c | 10,000.00 | — |
| Bank A/c | — | 10,000.00 |
2. Unrecorded Bank Charges Entry
Bank charges represent deductible business expenses. To maintain clean audit trails:
| Ledger | Debit (AED) | Credit (AED) |
|---|---|---|
| Bank Charges A/c (Indirect Expenses) | 500.00 | — |
| Bank A/c | — | 500.00 |
Advances and Unpresented Cheques
Supplier Advance Payments
When issuing funds prior to receipt of supplier goods or tax invoices, the payment is an asset rather than an immediate expense. Tally Prime offers two robust methods:
- Dedicated Ledger: Debit
Supplier Advance A/cunder Loans & Advances (Asset), credit the Bank account, and reclassify via Journal once the tax invoice arrives. - Bill-Wise Details (Recommended): Enable Maintain balances bill-by-bill on the supplier master. Select reference type Advance upon payment (F5). When the final purchase voucher (F9) is entered later, choose Against Reference to settle the advance cleanly.
Unpresented Cheques Audit
An unpresented cheque is an active corporate liability. In Tally, leaving the Bank Date blank retains the transaction under unpresented items. However, finance teams must audit this register monthly. Under UAE commercial law, commercial cheques carry legal validity windows. If a cheque remains unpresented past 6 months, verify with the vendor to cancel and reissue.
Tally ERP 9 vs Tally Prime: BRS Comparison
| Feature / Workflow | Tally.ERP 9 | Tally Prime |
|---|---|---|
| Manual BRS Entry | Supported (Alt + R) | Supported with simplified table view |
| E-Banking Statement Import | Basic support, requires format mapping | Native multi-format auto import (Excel, XML, CSV) |
| Auto-Matching Engine | Requires manual initiation | Instant automated matching by instrument & amount |
| Unreconciled Exception Handling | Multi-step menu navigation | Direct on-screen voucher creation (Alt + J) |
| User Interface | Traditional menu-driven screen | Modern, responsive, mouse & keyboard friendly |
4 Common Reconciliation Traps to Avoid
1. Ignoring Bank Charges Until Financial Year-End
Accumulating twelve months of unrecorded bank fees creates an exhausting year-end reconciliation backlog and distorts monthly P&L reporting.
2. Typographical Errors in Cheque Numbers
Mistyping even a single digit in the instrument number field breaks Tally Prime’s automated matching engine, forcing tedious manual tracking.
3. Double-Entering Payment Vouchers
Recording a payment once when approving a supplier bill, and a second time when importing the bank statement, artificially doubles your reported expenses.
4. Overlooking Stale Unpresented Cheques
Allowing issued cheques to linger in reconciliation reports for over six months understates actual cash availability and distorts vendor balances.
Frequently Asked Questions (FAQ)
What is Bank Reconciliation in Tally Prime and Tally ERP 9?
Bank reconciliation is the process of matching internal bank ledger transactions in Tally with your official bank account statement. In Tally ERP 9, it is done by entering Bank Dates for cleared entries. In Tally Prime, it can be automated via electronic bank statement import.
How do I record unrecorded bank charges in Tally?
Press F5 for a Payment voucher, debit the Bank Charges account (under Indirect Expenses), and credit the respective Bank account using the exact debit date from the bank statement.
What does an unpresented cheque mean in BRS?
An unpresented cheque is a payment cheque you have issued and recorded in Tally, but the payee has not yet deposited or cleared through the banking clearing system. In Tally, you leave its Bank Date blank during BRS.
Can Tally Prime reconcile bank statements automatically?
Yes. Tally Prime supports e-banking statement imports (Excel, CSV, XML formats). The software automatically matches statement lines with recorded vouchers using cheque numbers and transaction amounts.
How should advance payments to suppliers be recorded in Tally?
Use a Payment voucher (F5) with bill-wise details enabled. Debit the supplier’s ledger and set the reference type to ‘Advance’. When the supplier’s final purchase invoice arrives, adjust it against this advance reference.
📚 Recommended Related Guides
Explore more step-by-step Tally Prime accounting and operations playbooks
Chaturvedi Software House (CSH) established in 2006 has been a trusted name in software solutions across the GCC region. Team CSH specializes in offering industry-specific software solutions that solve actual problems you are facing. Over the years, with a huge track record of our prestigious clients we have built a solid presence.
Quick Links
Contact Us
- Address: 513 Al Khaleej Centre, Bur Dubai Dubai U.A.E
- Call Us: +971 4 325 8361/ +971 55 347 5870
- Email Us: inquiry@ca-eim.com
- Copyright © 2024 Chaturvedi Software House LLC
- All Rights Reserved.