Mapping Bank Transactions to Tally Ledgers: A Practical Guide
When you import a bank statement into Tally, the machine can fill in the date, amount, and bank ledger — but the counter-ledgerneeds an accountant's judgement. Is this UPI credit a sale, or a loan received? This guide covers how to decide, and how to assign hundreds of entries at once instead of one by one.
The double entry, and where judgement lives
Every bank transaction is two ledger lines: the bank ledger (always known) and the counter-ledger (the “what was this for”). A receipt increases the bank and credits some income or liability; a payment decreases the bank and debits some expense or asset. The bank side is automatic — only the counter-ledger needs you.
Common counter-ledger patterns
- Cash deposits(“BY CASH”, “DEPOSIT BY”, CDM) → a Cash ledger. These are recognised automatically.
- Recurring UPI/NEFT credits from customers → your sales ledger. Usually the biggest bucket for a business account — and the ideal candidate for bulk assignment.
- Bank charges, fees, GST on charges → a Bank Charges expense ledger.
- Interest credited → an Interest Income ledger.
- Transfers between own accounts → a contra / inter-bank ledger, not income or expense.
- Loan / capital received, EMIs paid → the relevant loan or capital ledger — never revenue.
Use Suspense as a safety net, not a dumping ground
Anything you haven't explicitly mapped should land in a Suspense A/c — visible and easy to filter — rather than being silently guessed into the wrong ledger. Clear Suspense to zero before you finalise, and you know every rupee has been consciously classified.
Bulk-assign instead of one-by-one
The trick to speed is to group, then assign. In Taficon you can:
- Filter or search to a pattern — e.g. all UPI credits.
- Select every matching transaction across all pages at once.
- Set the ledger a single time (e.g. “Sales A/c”).
Hundreds of entries, one action. Then repeat for the next pattern (charges, interest, transfers). What you see in the Ledger Name column is exactly what the Tally export will carry — review once, import clean.
Then export and import
Once the ledgers look right, export the Tally voucher file (XML or Excel) and import it. Because the statement is reconciled to the paisa before export, you're importing a complete, balanced set — not a best guess.
Map ledgers in bulk, export to Tally
Upload a statement and try the bulk ledger workflow.