How to Perform Bank Reconciliation in TallyPrime

Bank reconciliation in TallyPrime matches your bank statement against ledger entries to identify uncleared cheques, timing differences, and errors. Access it via Gateway of Tally > Display > Statements of Accounts > Bank Reconciliation. Regular reconciliation ensures accurate financial records and cash flow visibility.

What Is Bank Reconciliation and Why It Matters

Bank reconciliation is the process of comparing your TallyPrime bank ledger with your actual bank statement to identify and explain differences. Every business, whether sole proprietor or limited company, must reconcile monthly to ensure financial accuracy, detect fraud, and maintain audit-ready records.

Timing differences are the most common cause of mismatches. For example, a cheque you issued on 25 January may not clear your bank account until 5 February. Your TallyPrime ledger records it on 25 January, but the bank shows it on 5 February. Bank reconciliation bridges this gap and gives you a true picture of available cash.

Accurate bank reconciliation also strengthens your GST compliance. When you file GSTR-1 and GSTR-3B, the tax authorities expect your cash inflows and outflows to align with bank statements during audits. Discrepancies invite scrutiny and penalties.

Setting Up Bank Ledgers in TallyPrime

Before you can reconcile, you must create bank ledgers for each account. A bank ledger is a special ledger under the Bank Accounts group that records all deposits, withdrawals, and cheque transactions.

To create a bank ledger, follow this path: Gateway of Tally > Create > Ledger. Assign the ledger to the Bank Accounts group. Enter your bank account number and IFSC code in the ledger details. If you have multiple accounts (current, savings, overdraft), create a separate ledger for each.

For a detailed walkthrough on how to create ledgers in Tally and understand ledger groups, refer to our dedicated guides. Proper ledger setup is the foundation of reliable reconciliation.

Recording Bank Transactions in TallyPrime

All bank transactions must be recorded as vouchers in TallyPrime. Use Payment Vouchers for cheques issued and cash withdrawals, and Receipt Vouchers for deposits and cheques received.

When you issue a cheque, record it immediately with the cheque number and date. When you receive a cheque, record the cheque number and expected clearing date. This discipline ensures your TallyPrime bank ledger stays synchronized with your physical cheque book and bank passbook.

For step-by-step instructions, see our guides on payment vouchers in Tally and receipt vouchers in Tally. Consistent voucher entry is critical for accurate reconciliation.

Accessing the Bank Reconciliation Feature

TallyPrime offers a dedicated Bank Reconciliation tool that simplifies the matching process. To access it, follow this menu path:

Gateway of Tally > Display > Statements of Accounts > Bank Reconciliation

Alternatively, press Alt+G to open the Gateway, then navigate to Display, then Statements of Accounts, then Bank Reconciliation. The screen will prompt you to select the bank ledger and reconciliation period.

Step-by-Step Bank Reconciliation Process

Here is the standard workflow for reconciling your bank account in TallyPrime:

1. Gather your bank statement. Obtain the official statement from your bank for the month or period you wish to reconcile. Note the opening balance, closing balance, and all transactions.
2. Select the bank ledger. Open Bank Reconciliation and choose the correct bank account ledger.
3. Enter the statement date and balance. Input the bank statement closing date and the closing balance shown on the statement.
4. Match transactions. TallyPrime displays all unreconciled transactions from your ledger. Compare each with the bank statement and mark them as cleared or uncleared.
5. Identify uncleared items. Flag cheques issued but not yet cleared, deposits in transit, and bank charges not yet recorded.
6. Record missing items. If the bank statement shows charges, interest, or fees not in TallyPrime, record them as new vouchers before finalizing reconciliation.
7. Reconcile. Once all cleared items are matched, TallyPrime calculates the difference. If it is zero, reconciliation is complete. If not, investigate further.

Worked Example: Monthly Bank Reconciliation

Let us walk through a real example. Suppose you own a retail business in Purnea and use TallyPrime to manage accounts.

Item	Bank Statement (Feb 2025)	TallyPrime Ledger (Feb 2025)
Opening Balance	Rs 50,000	Rs 50,000
Deposits	Rs 1,20,000	Rs 1,20,000
Cheques Issued (Cleared)	Rs 80,000	Rs 80,000
Cheques Issued (Uncleared)	Not shown	Rs 15,000
Bank Charges	Rs 500	Not recorded
Interest Earned	Rs 200	Not recorded
Closing Balance (Statement)	Rs 89,700	Rs 74,700

Reconciliation Steps:

TallyPrime Ledger Balance: Rs 74,700

Add: Interest Earned (not yet recorded): + Rs 200

Less: Bank Charges (not yet recorded): - Rs 500

Adjusted TallyPrime Balance: Rs 74,400

Add: Uncleared Cheques (issued but not cleared by bank): + Rs 15,000

Reconciled Balance: Rs 89,400

Bank Statement Closing Balance: Rs 89,700

Difference: Rs 300 (investigate further for data entry error or missing transaction)

Once you identify the Rs 300 discrepancy (perhaps a deposit recorded as Rs 500 instead of Rs 800), correct it in TallyPrime and re-reconcile. When the difference reaches zero, your reconciliation is complete.

Handling Uncleared Cheques

Uncleared cheques are the most common reason for reconciliation differences. A cheque issued on 28 February may not clear until 10 March, creating a timing gap.

In TallyPrime, the uncleared cheque remains in your ledger but is flagged as uncleared during reconciliation. The Bank Reconciliation tool automatically adjusts for these items, so your reconciled balance reflects actual bank cash available.

Track uncleared cheques in a separate register or use TallyPrime's cheque printing and tracking features. When the cheque clears, update the status in your next reconciliation cycle.

Recording Bank Charges and Interest

Banks deduct charges for account maintenance, overdraft interest, or cheque processing. They also credit interest on savings accounts. These items appear on your bank statement but may not be in TallyPrime if you have not recorded them.

Before finalizing reconciliation, create a Receipt Voucher for interest earned and a Payment Voucher for bank charges. This ensures your ledger reflects all cash movements and reconciliation balances to zero.

Use a dedicated ledger for bank charges (e.g., "Bank Charges Expense") and interest (e.g., "Interest Income") to maintain clear financial records for tax and audit purposes.

Reconciliation Discrepancies and Troubleshooting

If your reconciliation does not balance, follow this checklist:

• Verify the bank statement balance. Ensure you are using the correct closing date and balance from the statement.
• Check for duplicate entries. Review your TallyPrime ledger for duplicate vouchers that inflate the balance.
• Look for reversed transactions. A payment recorded as a receipt or vice versa will create a large discrepancy.
• Confirm cheque numbers. Match every cheque number on the bank statement with your TallyPrime records.
• Review deposits in transit. Deposits recorded in TallyPrime but not yet cleared by the bank should be flagged as uncleared.
• Check for NSF cheques. If a cheque bounced, the bank will reverse it. Update TallyPrime to reflect this.
• Reconcile smaller periods. If a full month does not balance, try reconciling weekly or by transaction type to isolate the error.

Bank Reconciliation and GST Compliance

Accurate bank reconciliation supports your GST filing obligations. When you file GSTR-3B (monthly GST return due on the 20th of the next month), the tax authorities may cross-check your reported sales and purchases against bank deposits and payments.

TallyPrime integrates bank data with GST reports, so reconciled bank transactions flow into your GSTR-1 (outward supplies) and GSTR-2B (inward supplies) reconciliation. Discrepancies between bank and GST records can trigger notices.

Enable GST in TallyPrime under F11 (Features) and ensure all bank transactions are tagged with the correct GST treatment. For more details, see our TallyPrime accounting guide.

Monthly vs Quarterly Reconciliation

Most businesses reconcile monthly, aligning with bank statement cycles and GST filing deadlines. Monthly reconciliation also helps catch errors early, before they compound.

Some larger firms reconcile weekly or even daily, especially if they have high transaction volumes or multiple bank accounts. TallyPrime supports reconciliation at any frequency you choose.

Quarterly reconciliation is less common but acceptable for very small businesses with few transactions. However, monthly is the industry standard and strongly recommended for audit readiness.

Using TallyPrime Cloud for Remote Bank Reconciliation

If your team works remotely or across multiple locations, TallyPrime on Cloud allows secure access to bank reconciliation from any device. With bring-your-own-licence hosting from approximately Rs 175-290 per user per month, or with licence from Rs 899-1,299 per month, you can reconcile on Windows, Mac, Linux, Android, or iOS via secure RDP.

Cloud-based reconciliation ensures all team members work on the same, up-to-date data, reducing errors and improving collaboration. Daily automated backups protect your financial records.

Best Practices for Accurate Bank Reconciliation

Follow these practices to keep your bank reconciliation smooth and error-free:

• Reconcile promptly. Do not wait months to reconcile. Aim for within 5-10 days of the bank statement date.
• Record transactions immediately. Enter vouchers the same day you issue or receive cheques and deposits.
• Use consistent bank ledger names. Name your bank ledgers clearly (e.g., "HDFC Current Account" or "SBI Savings Account") to avoid confusion.
• Maintain a cheque register. Keep a physical or digital log of all cheques issued, including number, date, amount, and payee.
• Review bank statements carefully. Look for unexpected charges, reversals, or corrections that you must record in TallyPrime.
• Document discrepancies. If you find a mismatch, note the details and investigate thoroughly before finalizing reconciliation.
• Automate where possible. Use bank feeds or CSV imports if your bank offers them, to reduce manual entry errors.

Reconciliation Reports and Audit Trail

TallyPrime generates reconciliation reports that serve as audit evidence. Print or export the Bank Reconciliation statement after each cycle and file it with your monthly records. These reports show which transactions were cleared, which remain uncleared, and the reconciled balance.

For audit purposes, maintain a record of all reconciliation adjustments, including bank charges, interest, and corrections. This audit trail demonstrates financial controls and transparency to tax authorities and auditors.

If you need to create a new company in Tally or reset bank reconciliation for a fresh start, consult our setup guides or contact a certified Tally partner.

Contact a Tally Expert for Bank Reconciliation Support

Bank reconciliation is a critical monthly task that demands accuracy and attention to detail. If you are new to TallyPrime, struggle with reconciliation discrepancies, or want to streamline your cash flow management, Global IT Care is here to help.

As a Tally 3 Star Certified Partner in Purnea, Bihar since 2010, we have guided hundreds of businesses through bank reconciliation, GST compliance, and financial reporting. We offer hands-on training, troubleshooting, and ongoing support for TallyPrime users at all levels.

Whether you use TallyPrime Silver (single user, perpetual licence from Rs 22,500 + 18% GST) or Gold (unlimited users on LAN, from Rs 67,500 + 18% GST), we ensure your bank reconciliation process is smooth, accurate, and audit-ready. Reach out today at +91 75469 00951 via WhatsApp or visit us in Purnea to schedule a free consultation on bank reconciliation and financial management in TallyPrime.