The confusion around “deleting an imported bank statement” comes from Tally Prime having two separate imports. One stores bank data for reconciliation. The other creates vouchers in your books. They are deleted in completely different ways, and using the wrong method either does nothing or destroys the wrong data.
Which Import Did You Use?
| You used | What exists now | How to remove it |
|---|---|---|
| Alt+O → Bank Statement | Imported bank data, visible in Imported Bank Data and Bank Reconciliation | Reset Bank Statement Data |
| Alt+O → Transactions (XML) | Payment and Receipt vouchers in the Day Book | Alt+D, or bulk delete from Day Book |
| Bank Statement import with auto-create vouchers | Both imported bank data and vouchers | Reset the bank data, then delete the vouchers |
Method 1: Reset Imported Bank Data
Use this when the transactions were imported through the Bank Statement screen and you want the imported data gone — for example, you imported the wrong period or the wrong bank account.
- Open the company in Tally Prime.
- Press F1 (Help).
- Select Troubleshooting and press Enter.
- Select Reset Bank Statement Data.
- Choose the bank ledger and the period you want to reset.
- Confirm the reset.
The imported entries disappear from Imported Bank Data and from Bank Reconciliation. Vouchers that were already created from those entries are not removed by this reset — delete them separately using Method 2.
You cannot reset a single transaction. Tally resets by bank and period, so if only a few rows are wrong, reset the whole period and re-import a corrected file.
Method 2: Delete XML-Imported Vouchers
Delete one voucher
- Open the voucher from the Day Book or the bank ledger report.
- Press Alt+D.
- Confirm the deletion.
Delete a batch from the Day Book
- Press Alt+G (Go To), type Day Book, and press Enter. In Tally.ERP 9, use Gateway of Tally → Display More Reports → Day Book.
- Press Alt+F2 (Period) and set the exact statement date range.
- Filter or scan for vouchers against the bank ledger whose opposite leg is your Suspense/counter ledger.
- Delete each voucher with Alt+D. Some releases offer multi-select deletion from the report; if yours does, use it carefully.
For a 300-voucher statement, deleting one at a time is slow. In that case it is usually faster to restore the pre-import backup (if you took one) and re-import the corrected XML.
How to Identify Imported Vouchers
Before deleting, confirm which vouchers belong to the import:
- Date range — they fall inside the statement period.
- Counter ledger — the non-bank leg is the Suspense or opposite ledger you set in the converter.
- Narration — it matches the bank statement text, including UPI and NEFT references.
- Voucher type — Payment for withdrawals, Receipt for deposits.
- Voucher number — if the XML had no voucher numbers, Tally assigned its own sequence, which helps isolate the batch.
If Only the Ledger Is Wrong
You may not need to delete anything. If the amounts and dates are correct but the bank ledger is wrong, alter the voucher instead of deleting and re-importing:
- Open the voucher.
- Change the bank ledger to the correct one.
- Save with Ctrl+A.
For a handful of vouchers this is quicker. For hundreds, deleting and re-importing with the correct ledger is less error-prone.
Re-Import Without Duplicates
Once the old batch is gone, import the corrected XML:
- Set the correct bank ledger and opposite ledger in the converter preview.
- Download the XML again if the ledger names changed.
- In Tally, press Alt+O → Transactions, select the file, choose Add, and import.
- Check the imported and skipped counts, then verify the Day Book totals against the statement.
If the XML has no voucher IDs, Tally treats every import as new vouchers. Re-importing the same file without deleting the first batch creates duplicates. Import only the missing date range, or delete the previous batch first.
Import walkthrough: how to import PDF bank statement in Tally Prime.
Avoiding the Problem Next Time
- Import one week of the statement first, verify, then import the rest.
- Set ledger names in the converter before downloading, so nothing is skipped.
- Keep Show Preview enabled on the Bank Statement screen.
- Take a backup immediately before every import.
- Record the statement period in the narration or a note, so the batch is easy to find later.
- Import each statement once — keep a simple log of bank, period and filename.
Frequently Asked Questions
How do I delete an imported bank statement in Tally Prime?
If you used the Import Bank Statement screen, press F1 (Help) → Troubleshooting → Reset Bank Statement Data and choose the bank and period. If you imported vouchers from XML, delete them individually with Alt+D or in bulk from the Day Book after setting the period with Alt+F2.
Can I delete only a few transactions from imported bank data?
No. Tally does not allow deleting individual transactions from previously imported bank data. The reset works by bank and period. Vouchers created by an XML import can be deleted individually, however.
How do I undo a bank statement import in Tally Prime?
There is no single undo. Take a backup with Alt+Y first, then either reset the imported bank data or delete the vouchers the import created. Deleting vouchers is permanent, so confirm the date range and counter ledger before you start.
Why do imported vouchers show Suspense Account?
The converter posts the opposite leg to the ledger named in the Opposite/Suspense Ledger field. Reclassify that leg to the correct expense, income or party ledger after import, or set a real counter ledger before generating the XML.
Will re-importing the same XML create duplicates?
If the XML carries no voucher IDs, Tally treats each import as new vouchers, so re-importing creates duplicates. Delete the previous batch first, or import only the missing date range.
How do I find which vouchers came from an import?
Filter the Day Book by the statement period and look for vouchers against the bank ledger whose opposite leg is the Suspense or counter ledger you chose. Narrations also match the bank statement text.
How this guide was checked
Delete, reset and re-import behaviour was tested on a copy of a company with imported bank data, and checked against Tally's bank reconciliation and import error documentation. Read the editorial policy for how we handle corrections.
Last reviewed: 4 November 2026Sources
Import It Right the First Time
Set the exact bank and opposite ledger names in the preview, verify the balance, then download Tally XML.
Convert Bank Statement to Tally XML