Import an Excel bank statement → auto-group by narration → assign heads → export summary, JSON & Tally XML.
Click to choose or drag & drop one or more bank statements
Drop several at once → they combine into one summary. HDFC, ICICI (corporate & retail), Kotak, Bandhan & IDFC FIRST (+ most banks) · .xls · .xlsx · .csv
Pick a statement tab below — each bank is reviewed & assigned separately (its parsing & rules are its own). Set the Head (e.g. Sumit Ahuja & Associates, Bank Charges); groups with the same Head merge in that statement's summary. Tick Contra for inter-account transfers, Ignore to drop noise. Map a Tally Ledger if needed. Assignments are remembered per statement.
| Party (narration group) | Type | # | Deposit | Withdrawal | Head | Tally Ledger | Contra | Ignore |
|---|
Save your full working state (all loaded statements, headers, head / ledger / contra / ignore assignments) to a .json file, and load it back later.
Save the current party → head, head → ledger, contra & ignore assignments as a named rule set. Next time you import the same party's statement, apply it to assign heads automatically. Export rules to back up or move to another machine.
Groups ticked Contra in step 2 export as Contra vouchers (between this bank's ledger and the Tally ledger you mapped). With multiple banks loaded, each statement's Tally bank ledger (set on the Upload tab) is used.
Import a Tally Day Book XML export to pull existing ledger names — they'll appear as suggestions when you assign ledgers.
Generates Receipt vouchers (deposits) & Payment vouchers (withdrawals) ready to import in Tally via Gateway → Import → Vouchers.