Bank Statement Import Utility

What This Utility Does

The Bank Statement Import Utility enables you to import bank transaction records directly from Excel spreadsheets into Tally ERP 9 and Tally Prime. It automatically maps debits, credits, cheq/ref numbers, narration, and party ledgers, turning hours of tedious manual entry into seconds.

Problem It Solves

Monthly bank reconciliation is one of the most time-consuming accounting tasks. Manually typing hundreds of bank statement lines leads to data-entry mistakes, missed entries, and reconciliation discrepancies. This utility automates the entire conversion into Tally-compliant XML vouchers.

Who Should Use This

Accountants managing high volumes of banking transactions
Businesses with multiple current, overdraft, or savings accounts
Auditors verifying bank ledger reconciliations
Tally professionals looking for faster month-end closing

Key Features

Automated Voucher Creation: Payment, Receipt, and Contra entries
Smart Narration & Ref: Transfers transaction narration and cheque/UTR numbers
Multi-Bank Compatible: Works with statements from any Indian bank
Duplicate Check: Helps avoid duplicate transaction imports
Easy Mapping: Pre-formatted Excel template with macro-based XML generation

How to Use

Extract the ZIP file (`bank import.zip`) to a folder on your computer.
Open the Excel workbook and enable macros when prompted.
Paste or enter your bank statement data according to the template columns.
Click the "Generate XML" button.
In Tally, go to Import Data > Transactions and select the generated XML file.

Pro Tip: Ensure bank ledger and party ledger names in Excel match exactly with those in Tally before importing.