Import into Tally, step by step

All Tally versions

Import Tally XML into TallyPrime or Tally ERP 9

XML is the most compatible format: it works in every release, and the file creates any missing ledgers itself.

1. 1Convert your statement and choose Tally XML. Download the .xml file.
2. 2Open your company in Tally.
3. 3Press Alt+O (Import) → Transactions. In Tally ERP 9: Gateway → Import Data → Vouchers.
4. 4Enter the path to the downloaded file and press Enter.
5. 5Open Day Book to see the imported Payment and Receipt vouchers.

TallyPrime 4.0+

Import Tally Excel (.xlsx / .xls) into TallyPrime

The Excel file follows TallyPrime’s own import template, so no mapping is needed. You can review or edit it in Excel first.

1. 1Convert and choose Tally Excel (.xlsx), or Excel 97–2003 (.xls) for older setups.
2. 2If the file has a Ledger sheet (ledgers to create), import it first: Alt+O → Masters → choose the file and the Ledger sheet.
3. 3Then Alt+O → Transactions → choose the file (the “Accounting Voucher” sheet).
4. 4Confirm the import. Vouchers appear in the Day Book.

Tally imports one worksheet at a time, which is why ledgers and vouchers are separate steps.

TallyPrime 7.0+

Import Tally JSON into TallyPrime

TallyPrime 7.0 added native JSON import. Earlier releases can’t read JSON; use XML instead.

1. 1Convert and choose Tally JSON.
2. 2In TallyPrime 7.0 or later, press Alt+O → Transactions.
3. 3Set the file format to JSON, choose the file and press Enter.

Setup

When your bank ledger doesn’t exist yet

Tally rejects vouchers that use a ledger it doesn’t have. Let the export create it for you.

1. 1In the details step, keep Create ledgers switched on.
2. 2Check the suggested group: Bank Accounts for savings/current, Bank OD A/c for OD/CC and cards, Secured Loans for loans.
3. 3The ledger is created with the account holder, account number, IFSC and branch from the statement. Existing ledgers are left untouched.

Troubleshooting

All vouchers landed on the 1st, 2nd or last day of the month

This is Tally’s Educational Mode, which only allows those dates. The dates in the file are correct.

1. 1Activate your Tally licence, or use a licensed installation.
2. 2Delete the wrongly dated vouchers and import the same file again.

Scanned PDFs

Getting the best results from scanned statements

Scanned pages are read with OCR on your device. A clear, straight, well-lit page gives the best results.

1. 1Prefer the bank’s original PDF download over a scan whenever you can.
2. 2If a text PDF comes out wrong, use Read as scanned (OCR) on the upload card to read every page with OCR.
3. 3Review the rows flagged on the result screen; they’re the ones that didn’t match the balance.