UCO Bank statement PDF to Excel & Tally

From PDF to TallyPrime in four steps

1. 1

   Download the statement PDF

   Download your UCO Bank account statement as a PDF for the period you need. Don't print to PDF or scan it.

   [IMAGE: UCO Bank statement page, redacted · 1200×800 · 3:2]bank-uco-bank-statement
2. 2

   The statement password

   Most banks lock statement PDFs. You type the password on the Convert page; it's used on your PC only and never sent anywhere. The email that came with your statement is always the final word.

   Usual password for UCO Bank

   The UCO Bank account statement PDF we tested opens without a password. Statements that UCO Bank emails use the password described in that email.

3. 3

   Convert, review and fix

   Drop the PDF on the Convert page. Every row is checked against the running balance and the figures printed on the statement; anything that doesn't match is shown in red so you can fix it in place.

   UPI/OFFICE SUPPLIES2,240.00 !

   UPI/OFFICE SUPPLIES1,240.00

   Example rows, not from a real statement.

4. 4

   Import into TallyPrime

   Export Tally XML. If you exported a ledgers file, import it first so the vouchers find their ledgers.

   1 · Masters

   Gateway of Tally→Import→Mastersif exported

   2 · Vouchers

   Gateway of Tally→Import→Transactions

   Rows without a ledger go to Suspense; reclassify them in Tally afterwards.

   [IMAGE: TallyPrime import screen · 1200×750 · 16:10]tally-import-screen