Tally Prime 7.0: Bank Statement to Tally Prime – Import & Reconcile Easily

Call CA Tally HelpDesk +91 9205471661, 8368262875

Managing bank transactions manually is time-consuming and error-prone. With Tally Prime 7.0, businesses and CAs can efficiently import bank statements into Tally Prime and speed up accounting and bank reconciliation.

This guide explains how to bring bank statements into Tally Prime 7.0, the supported formats, and best practices.

Why Import Bank Statement into Tally Prime 7.0?

Using the bank statement to Tally Prime process helps you:

• Save time on manual voucher entry
• Reduce posting errors
• Maintain accurate bank ledgers
• Speed up bank reconciliation
• Handle bulk transactions (UPI, NEFT, IMPS, RTGS)

Supported Bank Statement Formats in Tally Prime 7.0

You can work with bank statements in:

• Excel (.xlsx)
• CSV (.csv)
• XML (recommended for bulk import)

 PDF statements must be converted to Excel/CSV first.

Methods to Import Bank Statement into Tally Prime 7.0

Method 1: Bank Statement to Tally Prime via XML (Best for Bulk Data)

This is the most reliable method for importing large volumes of bank transactions.

Process:

1. Convert bank statement (Excel/CSV) to Tally-compatible XML
2. Open company in Tally Prime 7.0
3. Go to Gateway of Tally → Import
4. Select Vouchers
5. Choose the XML file and import

✔ Fast
✔ Accurate
✔ Ideal for CA firms & high-volume accounts

Method 2: Import via Excel / CSV

Tally Prime allows importing transactions using predefined Excel structures.

Use this when:

• Transaction volume is low
• Format is simple
• XML is not available

 Requires correct column mapping and formatting.

Required Data for Bank Statement Import

Before importing, ensure your data includes:

• Date
• Narration / Description
• Debit amount
• Credit amount
• Reference / UTR (optional but recommended)

Also ensure:

• Bank ledger exists in Tally
• Party / expense ledgers are created (or mapped to Suspense)

Voucher Types Used in Bank Statement Import

Bank Reconciliation in Tally Prime 7.0

After importing the bank statement:

1. Open Bank Ledger
2. Select Bank Reconciliation
3. Match imported entries with bank dates
4. Identify unreconciled or missing transactions

This ensures accurate books and compliance-ready data.

Common Errors & How to Avoid Them

Missing Ledgers
→ Create ledgers before import or use Suspense

Wrong Debit / Credit Posting
→ Verify bank column mapping

Duplicate Entries
→ Import month-wise and use unique references

Date Format Issues
→ Use consistent date format (DD-MM-YYYY)

Conclusion

Using bank statement to Tally Prime in Tally Prime 7.0 is the smartest way to automate accounting, reduce errors, and improve reconciliation. For bulk or professional use, XML-based import remains the most efficient and reliable approach.

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

Frequently Asked Questions