Bank Statement to Tally Converter (PDF to XML)

TallyPrime can import bank statements itself from the Bank Reconciliation screen (TallyPrime 6.0 or later) when you download an Excel, CSV or MT940 file from a supported bank's net banking. Its imported rows go to Bank Reconciliation, where you still create the vouchers. Tally's help lists Excel, CSV and MT940 for that route, not PDF, and the file has to be in a layout Tally recognises for that bank, so a spreadsheet you build by hand from a PDF may not import cleanly.

This converter is for the other cases: you only have the PDF, the statement is password-protected or scanned, the bank is not on Tally's supported list, or you want vouchers created in one import instead of one by one.

Who it is for

• CA firms and bookkeepers posting client bank statements into Tally.
• Small businesses on TallyPrime whose bank is outside its supported bank-import list.
• Anyone bringing past months up to date from saved PDF statements.

1. 1

   Upload the PDF

   Choose the statement PDF, a scan or a photo, up to 20 MB and 50 pages. Passwords are entered in your browser and never uploaded.

2. 2

   Check the balances

   Each row's running balance is checked against the previous balance plus the transaction. Rows that do not reconcile are highlighted.

3. 3

   Set your ledgers

   Enter your bank ledger name exactly as it is in Tally, a default ledger for the other side, and optional rules such as "OLA CABS = Conveyance"; add the company name if you keep several companies. Then download the XML.

4. 4

   Import in TallyPrime

   Open the company, press Alt+O (Import) → Transactions, choose XML as the file format, select the file and press Enter. Check the import summary for the number of vouchers created.

The date is the transaction date, the narration is the full description plus any cheque or reference number, and voucher numbers are left to Tally's automatic numbering. Rows without a date or amount are left out, and the tool tells you how many.

Matching narrations to ledgers

Rules are checked from top to bottom; the first rule whose text appears in the description decides the ledger. Matching ignores upper and lower case.

Cash withdrawals and transfers between your own bank accounts are Contra entries in Tally; leave them in Suspense and change the voucher type in Tally.

Entries left in Suspense are easy to find later: open the Suspense ledger in TallyPrime and alter each voucher to the right ledger.

Sample: a fictional Indian savings account statement

This 2-page sample has 30 transactions from 02 Sept 2026 to 30 Sept 2026: 24 payments and 6 receipts. The first voucher looks like this:

<VOUCHER VCHTYPE="Payment" ACTION="Create" OBJVIEW="Accounting Voucher View">
  <DATE>20260902</DATE>
  <VOUCHERTYPENAME>Payment</VOUCHERTYPENAME>
  <NARRATION>UPI/DR/605455888032/SRI VENKATESWARA TIFFINS/HDFC/paytmqr281005050101@paytm/UPI Ref 4680203072</NARRATION>
  <PERSISTEDVIEW>Accounting Voucher View</PERSISTEDVIEW>
  <ALLLEDGERENTRIES.LIST>
    <LEDGERNAME>Staff Welfare</LEDGERNAME>
    <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
    <AMOUNT>-1111.64</AMOUNT>
  </ALLLEDGERENTRIES.LIST>
  <ALLLEDGERENTRIES.LIST>
    <LEDGERNAME>Godavari Bank</LEDGERNAME>
    <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
    <AMOUNT>1111.64</AMOUNT>
  </ALLLEDGERENTRIES.LIST>
</VOUCHER>

Download sample PDF (120.1 KB) · Download sample Tally XML (26.6 KB)

Tally writes details of each import to its import log (Tally.imp in the TallyPrime folder). Import a small statement into a test company first if you are setting this up for the first time.

Tally XML is for posting vouchers. To review and edit the rows in a workbook before deciding what to post, open the bank statement PDF to Excel converter for Excel and CSV downloads. If the client keeps their books in GnuCash, Xero or Moneydance, choose the PDF to OFX converter for their accounting software. For QuickBooks, the PDF to QBO converter creates a Web Connect file. For larger Tally workloads, compare page allowances and batch options on the pricing page.