Creating Vouchers Directly from Bank Statements in Tally Prime – A Complete Step-by-Step Guide

Call CA Tally HelpDesk +91 9205471661, 7428779101

Introduction

For accountants and business owners, reconciling and entering bank transactions manually can be one of the most time-consuming parts of accounting. Thankfully, Tally Prime simplifies this process through its Bank Statement Import and Voucher Auto-Creation feature.
With this function, you can directly import your bank statement (in Excel or CSV format), let Tally identify transaction details, and automatically generate Payment, Receipt, Contra, and Journal Vouchers — all with minimal manual effort.

This article explains how to create vouchers directly from bank statements in Tally Prime and how this feature improves accuracy and saves valuable time.

1. Why Use the Bank Statement Import Feature

Manual entry of banking transactions is prone to data errors, duplicate entries, and reconciliation mismatches. Tally Prime’s import feature automates this process by:

• Reading bank statement data from Excel/CSV formats.
• Mapping transaction details such as Date, Narration, Amount, and Type (Debit/Credit).
• Automatically suggesting the correct voucher type and ledger.
• Creating vouchers instantly — ready for review and approval.

This feature is especially useful for businesses with high daily transaction volumes or accountants handling multiple clients.

2. Pre-Requisites

Before starting, ensure you have:

1. The latest version of Tally Prime (Release 3.0 or later).
2. Bank statement file in either Excel (.XLS/.XLSX) or CSV format (downloaded from your bank portal).
3. Bank ledger already created in your company books (e.g., HDFC Bank, SBI Bank).
4. Correct bank account number and IFSC set in Tally for easier mapping.

3. Step-by-Step: How to Create Vouchers from Bank Statement in Tally Prime

Step 1: Open the Bank Ledger

• Go to:
  Gateway of Tally → Banking → Bank Reconciliation.
• Choose the bank ledger (for example, HDFC Bank).

Step 2: Import the Bank Statement

• Press Alt + I (Import Statement) or click Import Bank Statement.
• Select the file format — Excel, CSV, or MT940 (for certain banks).
• Browse to your downloaded statement file.

Step 3: Map Columns

Tally will display the statement preview and ask you to map fields:

Once mapped, press Enter to import.

Step 4: View Auto-Matched Entries

Tally automatically checks existing vouchers for matching dates and amounts.

• Matched transactions appear as Reconciled (R).
• Unmatched transactions can be converted into vouchers directly.

Step 5: Create Vouchers Automatically

For unrecorded transactions:

• Highlight the transaction → Press Alt + J (Create Voucher).
• Tally suggests a voucher type based on narration keywords:
  • “ATM Withdrawal” → Payment Voucher
  • “NEFT from Client” → Receipt Voucher
  • “Transfer to Own Account” → Contra Voucher
• Select the correct Party Ledger or Expense Head.
• Confirm to create the voucher.

Once confirmed, Tally generates the entry in your books with narration, bank details, and auto-reconciliation.

4. Example Workflow

Let’s say your bank statement shows:

Tally Prime will suggest:

• NEFT from ABC Traders → Receipt Voucher under “ABC Traders”.
• Rent Payment → Payment Voucher under “Rent Expense”.
• Cash Deposit → Contra Voucher between Cash and Bank.

You can verify or modify details and post all vouchers instantly.

5. Reviewing and Reconciling

After creating vouchers:

• Press F12 → Configure → Show Unreconciled Transactions (Yes).
• Tally will display reconciled and pending entries.
• Cross-check closing balances with the bank’s statement to ensure accuracy.

The software automatically marks matched transactions as reconciled, reducing end-of-month workload.

6. Benefits of Using Bank Statement Voucher Creation

✅ Saves time: Imports and creates multiple vouchers within minutes.
✅ Error reduction: Avoids manual typing mistakes.
✅ Smart categorization: Suggests correct voucher type using narration logic.
✅ Auto reconciliation: Instantly matches existing entries with bank records.
✅ Audit-ready: Maintains complete traceability of imported data.

7. Tips for Best Results

• Always download bank statements in Excel or CSV format rather than PDF.
• Clean up extra columns (like remarks or charges) before importing.
• Keep your ledger names consistent (e.g., “Rent Expense”, “Electricity Expense”).
• Use Backup before bulk voucher import for safety.

Conclusion

Tally Prime’s Bank Statement Voucher Creation feature revolutionizes how accountants handle daily transactions. Instead of entering each record manually, you can now import a single file and generate all necessary vouchers in just a few clicks.

For MSMEs and accounting professionals, this functionality not only improves accuracy but also saves significant time, enabling faster bank reconciliation, cleaner books, and better financial control.
By leveraging this feature effectively, businesses can simplify cash-flow management and make Tally Prime their central hub for accurate, automated banking records.

Powered by Binarysoft Technologies
Authorized Tally Partner
Location : 1626/33, 1st Floor, Naiwala, Karol Bagh, New Delhi – 110005, INDIA
Contact us : +91 7428779101, 9205471661
Email us :  tally@binarysoft.com (10:00 AM – 6:00 PM, Mon–Fri)