Bank to Tally v2

Turn bank statements into TallyPrime / Tally ERP 9 entries. Upload, pick ledgers, import.

Loading... Account
Work session

1Settings and ledgers

Company settings

The ledger list, which bank ledger goes with which account, past ledger choices and the entries already sent to Tally are saved to your account automatically, and shared with everyone who works on this company. They are kept for as long as your subscription is active.

Tally company name (optional)

Exactly as in Tally. Leave blank to import into whichever company is open.

Voucher type names (only if this company uses its own, e.g. "Bank Payment")

Type them exactly as in Tally. Leave blank to use Payment, Receipt and Contra.


Ledgers from Tally 0 ledgers

Best: in TallyPrime go to Display More Reports > List of Accounts (ERP 9: Display > List of Accounts), press Alt+E to export, choose XML format and upload that file here. Or paste names below, one per line (optionally Name, Group).

Existing names are kept; groups are updated if given.

2Add bank statementsExcel, CSV or PDF. Several banks at once is fine.

Drop statement files here or click to choose
Excel or CSV downloads from net banking are the most reliable. Digital PDFs work for most banks; scanned PDFs do not.

3Pick a ledger for each entryWithdrawals become Payment, deposits become Receipt, bank-to-bank or cash becomes Contra

Past choices are only suggestions; nothing is filled in until you click.
DateBankNarrationRef / Chq WithdrawalDeposit LedgerVoucherStatus
Add a statement to see its entries here.
New ledgers These are not in Tally yet. Choose a group for each; they go into a separate file that is imported first.

4Export for Tally

Files will download to your Downloads folder.
All entries with their ledgers, plus totals by ledger, to check or send to the client before importing.
How to import into TallyPrime
  1. Open the company. If there is a New Ledgers file, import it first: Gateway of Tally > Import > Masters (or press Alt+O > Import > Masters), choose the file, set Behaviour of import if master already exists to Ignore Duplicates, press Enter.
  2. Then the entries: Import > Transactions, choose the Bank Entries file, press Enter.
  3. TallyPrime shows how many vouchers were created. If there are errors, open tally.imp in the Tally folder; it names the ledger or entry that failed.
How to import into Tally ERP 9
  1. Open the company in Tally. If there is a New Ledgers file, import it first: Gateway of Tally > Import of Data > Masters, give the file path, set Behaviour of import if master already exists to Ignore Duplicates, press Enter.
  2. Then the entries: Gateway of Tally > Import of Data > Vouchers, give the path of the Bank Entries file, press Enter.
  3. Tally shows how many vouchers were created. If it shows errors, open tally.imp in the Tally folder; it names the ledger or entry that failed.
  4. Tip: to get a file path in Windows, hold Shift, right-click the file and choose Copy as path, then paste it in Tally without the quote marks.

5Saved files for this companyDeleted automatically after 14 days

Exported files and statement data are deleted automatically 14 days after they are created. Download and keep your own copy. Ledgers, bank mappings and past choices are not deleted.