Import Canara Bank Excel statement directly to Tally Prime or ERP 9 using Synergy Automation. Step-by-step guide for Indian accountants.
How to Download Canara Bank Statement as Excel
Where to find it: Canara ai1 / Net Banking - Account Statement - select date range - Download Excel
File format: Canara Bank net banking exports .xls/.xlsx. Columns: Txn Date, Value Date, Description, Cheque No, Debit, Credit, Balance.
Step-by-Step: Canara Bank Statement to Tally
- Download your Canara Bank statement
Go to Canara ai1 / Net Banking - Account Statement - select date range - Download Excel. Select your date range and download as Excel (.xlsx or .xls). - Open Synergy Automation
Make sure Tally is open with the correct company. Make sure the Synergy Connector is running on the same PC. - Upload the Excel file
Drag and drop your Canara Bank Excel file into Synergy Automation. The system auto-detects the format. You will see all transactions parsed and listed. - Review every entry
Check narrations, amounts, dates. Assign Tally ledger accounts. Skip any entries you do not want in Tally. - Post to Tally
Click Post. Entries appear instantly in your open Tally company as bank payment and receipt vouchers. No XML, no file, no import dialog.
Canara Bank-Specific Notes
- Canara statements often include 3-4 header rows above the actual table - Synergy skips these automatically
- Older Canara exports come as .xls (not .xlsx) - both are supported
- Narrations abbreviate heavily (e.g. "BY TRANSFER-NEFT") - review before assigning ledgers
- Branch-issued statements arrive as PDF - download the Excel version from net banking instead
Common Ledger Assignments for Canara Bank Transactions
| Narration Contains | Suggested Tally Ledger |
|---|---|
BY TRANSFER | Party ledger named in the narration |
NEFT/RTGS | Assign to the party in the narration |
INT CR | Bank Interest Received |
SERVICE CHARGE | Bank Charges |
ATM | Cash Account |
Use these as a reference when assigning ledgers in the review table before posting to Tally.
Frequently Asked Questions
Q: Does Synergy Automation work with Canara Bank statement format?
Yes. Synergy Automation automatically detects the Canara Bank Excel statement format and parses columns correctly. No manual column mapping needed.
Q: Do I need to convert Canara Bank statement to XML before importing to Tally?
No. Synergy Automation posts entries directly from Excel to Tally — no XML file is created or needed. This is faster and simpler than traditional XML import methods.
Q: Is this free for Canara Bank statements?
Yes. Synergy Automation is free to use. No limits on banks, entries, or companies.