Union Bank of India statement PDF to Excel & Tally XML

Convert Union Bank of India (Union Bank) bank statement PDFs with Jemsky’s dedicated parser — not a renamed homepage and not generic OCR. This page documents the layouts we actually ship, the quirks that break other converters, and examples CAs see in the wild.

Union Bank of India ships at least three layouts Jemsky cares about: a compact retail/current ‘details of statement’ table, a Finacle term-loan ledger, and a standard retail statement. Mixing those in one parser produces phantom loan interest rows in a cash book.

The Mano plugin keys off details of statement, MICR, and period headers. The loan plugin is a separate strategy for Finacle term-loan PDFs with signed running balances. Standard retail is the third path.

CAs should look at the PDF title. If it is a loan statement, export Excel for the loan register; Tally XML Payment/Receipt mapping is designed for operating accounts. You can still convert loan PDFs for reconciliation, then decide posting manually.

All three paths discard the PDF after export.

Statement formats the Union Bank parser recognizes

• Compact ‘details of statement’ retail/current (union_bank_mano_v1): SI, Date, Particulars, Chq Num, Withdrawal, Deposit, Balance
• Finacle term-loan statement with Dr/Cr running-balance signs (union_bank_loan_v1)
• Standard retail layout (union_bank_standard_v1)

Parser quirks specific to Union Bank

• Loan statements are not savings statements — Dr/Cr on the balance means outstanding, not cash-book OD by default.
• Compact Mano-style files print Cr/Dr on the balance column of savings/current too.
• MICR / period headers (STATEMENT OF ACCOUNT FOR THE PERIOD FROM …) are metadata, not rows.
• Password-protected current-account files unlock in RAM.

Example narrations and how they export

• Finacle Term Loan PDF — Routes to loan plugin; do not treat every Dr as a Payment voucher blindly.
• Compact SI | Date | Particulars — Retail/current Mano layout with 100% audit on sampled files.

CA workflow on Union Bank files

Never Auto-Detect a Union Bank loan PDF and dump XML into the client’s cash Day Book without review. Use Excel first on loan files. Operating-account compact statements are the usual Tally XML path.

Exports and privacy

Every successful convert can download Excel (.xlsx), CSV, and TallyPrime / Tally.ERP 9 Payment and Receipt XML. Customer statement bytes never land in Jemsky’s database. Optional Tally Party Ledger Masters store ledger names you import — not this bank’s PDF.

1. Open the converter and upload the Union Bank PDF.
2. Leave Auto Detect on unless you know the exact layout name.
3. Confirm the financial audit equation matches the printed closing balance.
4. Export Excel for the working paper and/or Tally XML.

Frequently asked questions

How do I convert a Union Bank of India statement PDF to Excel?

Upload the Union Bank e-statement on jemsky.com/app. Auto Detect should pick the Union Bank plugin. Review Opening + Deposits − Withdrawals = Closing, then download Excel, CSV, or Tally XML. The PDF is parsed in RAM and discarded.

Can I import Union Bank of India statements into TallyPrime?

Yes. Export Tally XML and use Import → Transactions. Optional: import Master.json/xml and enable ledger suggest so Union Bank UPI/NEFT rows map to party ledgers instead of Suspense A/c.

Does Jemsky store Union Bank of India statement data?

No. Union Bank of India PDFs are not archived. Passwords unlock in memory only.

What is unique about the Union Bank parser versus other banks?

Loan statements are not savings statements — Dr/Cr on the balance means outstanding, not cash-book OD by default. Never Auto-Detect a Union Bank loan PDF and dump XML into the client’s cash Day Book without review. Use Excel first on loan files. Operating-account compact statements are the usual Tally XML path.

Related: All banks · User Guide · Security · Free Excel · Tally