How to import a bank statement PDF into Tally

Typing a month of bank entries into Tally by hand takes hours and invites errors. This guide turns the statement PDF into vouchers and imports them in a few minutes, with a check on every row before anything reaches your books.

What you need

• The bank statement as a PDF downloaded from net banking (text PDF, not a scan or photo).
• TallyPrime or Tally.ERP 9 with the company open.
• The exact name of the bank ledger in that company.

Step 1: Convert the PDF

1. Open the PaisaProof converter and drop the PDF on the page. If the file has a password, enter it when asked. The file is processed on your computer and is not uploaded.
2. Look at the green badge. “N of N rows verified” means every row satisfies previous balance ± amount = printed balance.
3. If some rows say review, compare them with the PDF. Use the ⇄ button to flip a debit to a credit if needed.

Step 2: Map ledgers

1. Click Tally XML… and type the bank ledger name exactly as it appears in Tally.
2. Add ledger rules. Example: narration contains AIRTEL → ledger Telephone Expenses. The first matching rule wins. Rows with no rule go to the default ledger (Suspense), which you can re-allocate in Tally later.
3. A rule that points to the ledger Cash produces a Contra voucher (cash withdrawal or deposit).
4. The Ledger column in the table shows where each row will be posted. Your rules are remembered on this device for next month.

Step 3: Download the XML

• Ledgers XML: creates the ledgers used by your rules (under the Suspense A/c group, to be moved to the right group in Tally) and the bank ledger under Bank Accounts. Skip it if the ledgers already exist.
• Vouchers XML: one Payment, Receipt or Contra voucher per statement row, with the bank narration.

Step 4: Import into Tally

TallyPrime:

1. Press Alt+O (Import) and choose Masters. Select the ledgers XML file and import. (Skip if not needed.)
2. Press Alt+O again and choose Transactions (Vouchers). Select the vouchers XML file and import.
3. Open the bank ledger or Day Book and compare the closing balance with the statement.

Tally.ERP 9: Gateway of Tally → Import Data → Masters (ledgers file), then Import Data → Vouchers (vouchers file). Type the full path of the XML file.

Test first. Take a backup, or import into a test company, before importing into live books. Menu names differ slightly between Tally releases. If your version rejects the file, tell us the version and the error text so we can fix it.

Common import errors

• “Ledger does not exist”: a ledger name in your rules does not match Tally exactly. Import the ledgers XML first or correct the spelling.
• Vouchers outside the financial year: the company’s period must cover the statement dates. Change the period with Alt+F2.
• Duplicate entries: importing the same file twice creates the vouchers twice. Keep one file per statement period.