Bank statement to Tally XML.
Reconciled before you import.
Convert a PDF bank statement into TallyPrime Receipt and Payment vouchers. Every transaction is balanced between the bank ledger and one clearing ledger, with stable voucher IDs and a reconciliation check against the printed statement before you import.
Drop your bank statements here
One file or a whole year. PDF, scanned image, CSV, QIF or OFX. Up to 12 files at a time; long PDFs are split for you.
Not ready to upload your own? See a sample result
5 pages free, no account. The Tally XML download appears on the results page.
Step by step: PDF statement to TallyPrime
- Drop the statement on the home page and make sure the balance check is green.
- Click Tally XML. Money in becomes a Receipt voucher and money out becomes a Payment voucher. Each voucher has two ledger entries whose amounts add to zero.
- The XML names the bank ledger after the bank and the last four account digits (HDFC Bank 4821, for example). Its other side is a ledger named Statement Import Clearing. Both must exist in the company before you import: create them, or rename your existing ledgers to match.
- Set the company period to cover the statement dates (Alt+F2), then press Alt+O, choose Import, then Transactions, and select the downloaded file.
- Review the import summary and any exceptions. Open Statement Import Clearing afterwards and reclassify each transaction to the correct expense, income, customer or supplier ledger while reconciling the bank account.
What usually goes wrong, and how this avoids it
- Tally matches ledgers by exact name. A voucher whose ledger does not exist is listed as an exception instead of being posted, so check the two names before importing. Through the API you can pass your own ledger names.
- Voucher dates must fall inside the company period, and amounts are imported as plain numbers in the company's base currency. Widen the period first, and treat a foreign-currency statement as a job for a multi-currency ledger.
- Turning guessed categories directly into accounting ledgers can post transactions to the wrong chart-of-accounts group. The export uses one clearing ledger instead, leaving classification under your control.
- Importing the same statement twice can duplicate vouchers if duplicate handling is disabled. The XML gives every row a stable remote ID and voucher number so Tally can identify the repeat during review.
TallyPrime questions
Does the Tally XML create my ledgers?
No. It refers to a bank ledger named after the bank and account, and to Statement Import Clearing. Create both before importing; vouchers that name a ledger Tally cannot find are held as exceptions. Not creating ledgers for you avoids a chart of accounts you did not choose.
How are debits and credits posted?
Money received is a Receipt voucher: the bank ledger is debited and the clearing ledger is credited. Money paid is a Payment voucher: the clearing ledger is debited and the bank ledger is credited. The two amounts in every voucher add to zero.
Can I convert several statements for Tally at once?
Yes. Upload up to 12 files and choose All Tally XML files from the batch page. The ZIP contains one XML file per statement or account, each with stable voucher IDs.