Import a converted statement into TallyPrime

Use the Tally XML download when the statement belongs in a TallyPrime company. Check the balance badge first. A red result means the rows do not yet agree with the printed statement, so fix the flagged row before creating accounting vouchers.

What the XML contains

Every non-zero transaction becomes one accounting voucher:

• Money into the account becomes a Receipt voucher. The bank ledger is debited and the clearing ledger is credited.
• Money out becomes a Payment voucher. The clearing ledger is debited and the bank ledger is credited.

The two ledger amounts in every voucher add to zero. The narration is the statement description. Each row also has a stable remote ID and voucher number so Tally can identify a repeated import during review.

Suggested categories are not posted as ledgers. A category such as Travel or Professional Services may not match your company's chart of accounts or tax treatment. Instead, every other side goes to one ledger named Statement Import Clearing, ready for you to reclassify while reconciling.

Before importing

The bank ledger name is inferred from the bank name and the last four account digits printed on the statement. For example, HDFC Bank account 4821 becomes HDFC Bank 4821. Tally matches ledger names exactly.

Create that bank ledger and Statement Import Clearing before importing, or rename your existing ledgers to match. Vouchers that name a ledger Tally cannot find are held as exceptions rather than posted. The clearing ledger can sit under the Suspense A/c group. If you use the API, the bankLedger and offsetLedger parameters put your own names straight into the file.

Importing

Open the correct company in TallyPrime and make sure the company period covers the statement dates (Alt+F2); vouchers outside the period are rejected. Press Alt+O, choose Import, then Transactions, and select the downloaded file. Review the import summary and resolve any missing-ledger or duplicate exceptions before accepting the vouchers.

For several statements, choose All Tally XML files on the batch page. The ZIP contains one XML per statement or account. Import them in period order, then open the bank ledger and reclassify the clearing entries during reconciliation.

There is a shorter walkthrough at Bank statement to Tally XML.