- UPI, NEFT, RTGS, IMPS and cheques are just ways of moving money. They don't decide the ledger. The counterparty and the purpose do.
- NACH or ECS debits are standing instructions: EMIs, SIPs, insurance premiums, subscriptions. Each mandate maps to one ledger, every month.
- Keep a ledger map per client: names as they appear on the statement, the ledger, and the voucher type. It turns next month into a review.
- Anything you can't place goes to Suspense with a note, and Suspense is cleared before the month closes.
Classifying bank lines is where month-end bookkeeping time goes. Converting the statement takes minutes; deciding the ledger for 300 lines takes hours, unless you've done it before for the same client. The payment method is the first clue, and it's where most mistakes start.
What the transaction types mean
| Type | What it is | Usually seen for |
|---|---|---|
| UPI | Instant payment through a UPI app, any amount within the app's limits | Small customer receipts, petty payments, payments to individuals |
| NEFT | Batch bank transfer, available round the clock | Supplier payments, salaries, customer receipts |
| RTGS | Real-time transfer for large amounts, minimum ₹2 lakh | Large supplier payments, property, loans |
| IMPS | Instant bank transfer by account number or mobile | Urgent transfers, refunds |
| NACH / ECS | Standing instruction: the payee pulls money on a schedule you authorised | EMIs, SIPs, insurance, subscriptions |
| Cheque / clearing | Paper instrument cleared through the bank | Supplier payments, rent, government dues |
| Cash | Over-the-counter or ATM | Withdrawals for expenses, deposits of collections |
| Charges / interest | Posted by the bank itself | Fees, GST on fees, interest credited or debited |
A starting map from transaction to ledger
| Transaction | Usual ledger | Voucher |
|---|---|---|
| Credit from a customer you invoice | That customer, under Sundry Debtors | Receipt |
| Many small credits from walk-in customers | A cash or retail sales ledger, matched to the sales register | Receipt |
| Marketplace or payment gateway payout | The marketplace or gateway party ledger | Receipt |
| Debit to a regular supplier | That supplier, under Sundry Creditors | Payment |
| Rent, utilities, internet, software | The matching expense ledger | Payment |
| Salary transfers | Salaries, or Salary Payable if salaries were provided | Payment |
| NACH debit from a lender | Loan account (principal) + Interest on Loan | Payment |
| NACH debit for a SIP or insurance | Investments, or Insurance (business or owner's drawings) | Payment |
| GST, TDS, advance tax challans | The matching Duties & Taxes ledger, or Drawings for the owner's personal tax | Payment |
| Cash withdrawal / deposit | Cash | Contra |
| Transfer to the client's other bank | That bank's ledger | Contra |
| Bank charges and GST on them | Bank Charges + input GST if claimable | Payment |
| Interest credited | Interest Received | Receipt |
| Money from or to the owner | Capital, or Drawings | Receipt / Payment |
The voucher column follows the rule in Payment, Receipt, Contra or Journal.
Build a ledger map for each client
Most of a client's bank lines repeat every month: the same customers, suppliers, landlord, lender and staff. A short map saves you deciding them again.
- After the first month's entries, list every counterparty the way its name appears in the narrations, with the ledger and voucher type you chose.
- Add the recurring items: rent, EMIs and the lender's name, insurance, subscriptions, salary payees.
- Note the exceptions, for example a customer who also supplies, or an owner's family member who pays both business and personal bills.
- Next month, apply the map first and only think about the lines that didn't match.
- Review the map every quarter and when the client tells you about a new customer, supplier or loan. It slots into the month-end checklist.
Suspense: useful, if you empty it
Lines you can't place yet, such as an unexplained credit or a transfer to an unknown name, go to a Suspense ledger with a narration that says what you need to ask. Send the client one list of open questions, not ten messages, and clear Suspense before the month is closed and reconciled. A Suspense balance carried for months usually turns into a guess at year end.
Where mapping goes wrong
- Mapping by payment method alone, so every UPI credit becomes sales, including refunds, loans from friends and the owner's own transfers.
- Posting marketplace payouts as sales; the payout is net of commission, TCS and TDS. See marketplace payout entries in Tally.
- Treating every NACH debit as an expense, when most are loan repayments or investments.
- Owner's personal payments on the business account posted as business expenses instead of Drawings.
- Names that change slightly between months and create duplicate ledgers. Match to the existing ledger instead.
How FileKey helps
When you convert a statement in FileKey, every row gets a suggested ledger and voucher type from its narration: rent, salaries, taxes, bank charges, interest, cash and more. You review the suggestions in a table, change the ones that are wrong, and export Tally XML with your ledgers already on each entry. It's free to try on statements from 730+ banks. See the bank statement to Tally converter.
Frequently asked questions
Which ledger does a UPI receipt go to in Tally?
The ledger of whoever paid: the customer under Sundry Debtors if you invoice them, a sales ledger for walk-in retail receipts, or Capital or a loan if the money came from the owner or a lender. UPI only tells you how the money moved.
What is a NACH debit on a bank statement?
A payment the payee collected under a mandate the account holder signed, typically an EMI, SIP, insurance premium or subscription. Map each mandate to its ledger once and it repeats every month.
Where do I post an unknown credit in the bank statement?
To a Suspense ledger with a note, then ask the client and move it to the right ledger before you close and reconcile the month.
Should the owner's personal payments from the business account go to expenses?
No. Post them to Drawings (or the owner's capital account). Business expenses should only carry business costs.
Sources and further reading
Rules change by notification and advisory. Check the GST portal before you file.
Written by the FileKey Team
FileKey builds the tools CA firms use for e-commerce GSTR-1 and bank statement conversion. We write these guides from the questions accountants and sellers ask us every filing month. Spotted something out of date? Write to [email protected] and we will fix it. More about FileKey.