Export Bank Statement — bank statement PDF to Excel
sync_altGuide

How to Remove an Imported Bank Statement in Tally

There is no undo button for an import. What there is, is a reliable way to find exactly what the import created and remove it in bulk.

upload_fileConvert a statement freeschedule3 min read · India
bolt

An import went in against the wrong ledger, or covered a period you had already entered, and now the books are wrong. There is no single undo for an import — but the vouchers it created are ordinary vouchers, and you can find and delete them systematically.

Work on a backup first. Gateway of Tally → Alt+Y → Backup, before you delete anything. This takes under a minute and is the difference between a mistake and a disaster.

Find what the import created

The reliable handle is the date range plus the bank ledger.

  1. Gateway of Tally → Display More Reports → Account Books → Ledger
  2. Select the bank ledger you imported against
  3. Set the period to the statement's date range — Alt+F2 changes the period

You are now looking at every voucher touching that ledger in that window. If you had existing entries in the same period, they are mixed in with the imported ones, which is the case that needs care.

Telling imported vouchers apart from your own: the narration. Every voucher our converter produces carries the original statement description as its narration, and the counter ledger defaults to Suspense. So imported-but-unallocated vouchers are the ones still sitting against Suspense — filter or sort on that and you have your list, cleanly separated from anything you entered by hand.

Delete them

One at a time: open the voucher and press Alt+D.

In bulk, work from the Day Book, which lists every voucher for a period in one place: Gateway of Tally → Display More Reports → Day Book, then Alt+F2 to set the statement's date range. Delete from there, checking each one belongs to the import before you do.

Some Tally releases offer a multi-voucher deletion option from this report and some do not — if yours does, it will be on the button bar. Either way the deletion is not reversible, which is why the backup comes first.

If the import went to the wrong ledger

You may not need to delete at all. If the transactions are right and only the bank ledger is wrong, altering the voucher is less destructive than deleting and re-importing. For a handful of vouchers that is quicker; for hundreds, delete and re-import with the correct ledger selected.

Avoiding the problem next time

Set Show Preview to Yes. On the bank statement import screen this shows you what Tally parsed before a single voucher is written. It is the cheapest safeguard available and it costs one keystroke.

Choose Add, never Overwrite, on voucher imports — unless you know exactly what Overwrite will match. Add leaves existing vouchers alone.

Import a short period first. A one-week statement tells you whether the ledger mapping and voucher types are right, and if it is wrong you are deleting ten vouchers rather than four hundred.

Reconcile before importing, not after. If the conversion itself dropped or duplicated a row, you want to know while it is still a file. Our converter checks that opening balance plus credits minus debits equals the closing balance the bank printed, and flags the statement before you download it — a mismatch caught there is a five-second fix, and the same mismatch caught after import is this page.

Re-importing after a delete

Once the old vouchers are gone, re-import normally. If you are re-importing the same XML, Add will not duplicate vouchers whose voucher numbers match ones already present — but after a full delete there is nothing to match, so everything comes in fresh.

The walkthrough is in how to import a bank statement in Tally Prime.

verified

Try it on your own statement

Clean Excel/CSV, with every transaction checked to balance.

upload_fileConvert free
Keep reading

More guides

account_balance

Bank Statement for a Loan Application (India) — Convert PDF to Excel

Banks and NBFCs read months of your bank statements before approving a loan. Here's how to convert them so your income and repayment record are clear.

Read guidearrow_forward
balance

Bank Statement for GST Return (India) — Convert PDF for Reconciliation

Reconciling GST means tying your bank receipts to sales and payments to purchases. Here's how to convert statements to a spreadsheet or Tally to make GSTR filing add up.

Read guidearrow_forward
payments

Bank Statement for Income Tax Return (India) — Convert PDF to Excel

Filing an ITR means reconciling a year of bank activity — interest, receipts, UPI payments. Here's how to convert password-protected statements into a usable spreadsheet.

Read guidearrow_forward
table_view

Bank Statement for Your Chartered Accountant (India) — Convert to Excel or Tally

Handing your CA a folder of password-protected PDFs slows everything down. Here's how to convert them to Excel or Tally so your books, return or audit move faster.

Read guidearrow_forward
sync_alt

Convert a Bank Statement to Tally (PDF to Excel/CSV Import)

Tally can't read a PDF — it imports Excel/CSV. Convert your statement to clean Excel first, then import and auto-reconcile in Tally Prime.

Read guidearrow_forward
sync_alt

How to Import a Bank Statement in Tally ERP 9

ERP 9 has no bank statement import feature — that arrived with Tally Prime. What ERP 9 does have is voucher import, and for a converted PDF that is the route you would want anyway.

Read guidearrow_forward
verifiedChecked to balance

Convert your bank statement — every transaction verified

Upload any PDF, get clean Excel or CSV ready for Xero & QuickBooks. Scanned statements too.

upload_fileConvert a statement free