Federal Bank statement PDF to Excel & Tally

From PDF to TallyPrime in four steps

1. 1

   Download the statement PDF

   Log in to Federal Bank net banking and download the account statement for the period you need as a PDF. Don't print to PDF or scan it.

   [IMAGE: Federal Bank statement page, redacted · 1200×800 · 3:2]bank-federal-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 Federal Bank

   Federal Bank statements usually open with the first four letters of your name in capitals followed by your date of birth as DDMM.

   Source: CreditMantri
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