Year-end bank reconciliation in TallyPrime before the audit deadline

For businesses above the tax-audit threshold, the Form 3CD deadline is 30 September — unless the CBDT extends it, which it often does and which you should never plan on. The auditor's first substantive question, before depreciation or GST or TDS, is the one that decides how the rest of the audit goes: does the bank reconcile? A books balance that agrees to the bank's closing balance, with every difference explained, tells the auditor the ledger can be trusted. One that doesn't tells them to look harder at everything.

Here's the year-end bank reconciliation routine in TallyPrime, account by account, in the order that wastes the least time.

1. Get the full year of statements, as data

Reconciliation needs the bank's version of every transaction from 1 April to 31 March. Download the year's statements from net banking as PDFs — most banks' portals hold at least the current and previous year — and don't start by typing them.

Convert them instead. NoRekey turns each statement into Excel or CSV and verifies the conversion against the statement's own opening and closing balances, so the transaction list is provably complete before it goes anywhere near Tally. It reads the Dr/Cr columns Indian statements use and normalises them to signed amounts, and it handles the password-protected e-statements HDFC, ICICI, SBI, Axis and Kotak send. The bank-specific routes are in the help centre — importing into Tally is the general guide.

2. Import and auto-reconcile

TallyPrime's bank reconciliation screen (Gateway of Tally → Banking → Bank Reconciliation, or Alt+G and search for it) accepts an imported bank statement and matches its lines against the bank ledger's vouchers by amount, instrument number and date. Import the converted file for the year — or quarter by quarter if the account is busy — and let it match what it can.

What's left is the reconciliation: the vouchers the bank hasn't seen and the bank entries the books haven't recorded.

3. Clear the unreconciled vouchers

Work the amounts not reflected in bank list from oldest to newest. Each entry is one of:

• Timing. A cheque issued in March that cleared in April. Set its bank date to the clearing date and it reconciles into the new year. Legitimate, and the bulk of the list.
• Stale. A cheque issued more than three months ago that never cleared. It's no longer valid; reverse the voucher and reinstate the liability to the payee.
• Wrong. A voucher for an amount the bank never saw, a duplicate entry, a payment booked to the wrong bank ledger. Correct it.
• Cash that was never banked. A receipt voucher against the bank for cash that's still in the drawer. Move it to cash.

An unreconciled entry from eighteen months ago is not "old"; it's an error with a long fuse. Year-end is when it's cheapest to find.

4. Book what the bank did on its own

The other side of the list — bank entries with no voucher — is shorter and more predictable:

• Bank charges and GST on them. One voucher per statement line, or a monthly summary if your auditor is happy with that.
• Interest credited on current or deposit accounts — and check it against the interest reported in your AIS/Form 26AS, because TDS on that interest is a credit you don't want to leave behind.
• TDS deducted by customers showing as short receipts: the customer paid ₹98,000 against a ₹1,00,000 invoice. The ₹2,000 is a TDS receivable, not a bad debt.
• EMI and loan interest split between principal and interest per the lender's schedule.
• Direct credits from customers who didn't tell you. Match to open invoices; anything you can't match sits in a suspense ledger with a note, and the auditor will ask about it — better that than an inflated sales figure.

TallyPrime can create vouchers for unmatched bank lines straight from the reconciliation screen, which is faster than keying them and avoids the transposition errors that create next year's reconciling items.

5. Agree the closing balance

When the lists are empty, the bank ledger's balance as at 31 March, adjusted for the timing items, equals the bank's closing balance. Print the reconciliation statement from Tally for that date and put it with the bank's balance confirmation (or the March statement's closing figure) — that pair is the audit evidence, and the auditor will want one for every account, including the ones that barely moved.

Do the same for each bank, the cash credit or overdraft account, and any fixed deposits that matured or renewed during the year.

6. The two cross-checks that save audit queries

GST. Customer receipts and supplier payments in the bank should reconcile to the invoices in GSTR-1 and the credits in GSTR-2B over the year. The bank won't tie exactly — timing, TDS, part-payments — but a large unexplained gap between bank receipts and reported turnover is the question an auditor asks next.

Cash. The tax-audit threshold itself depends on the share of receipts and payments in cash. The bank reconciliation gives you the non-cash figure directly; it's worth knowing which side of the line the business sits on before the auditor works it out.

Next year, monthly

Everything above is harder in September than it would have been in May, and harder in May than it would have been at the end of each month. Import and reconcile each month's statement as it arrives — the monthly routine is a few minutes per account — and the year-end reconciliation becomes a printout rather than a project. The auditor will notice. So will your September.