Import ICICI Bank Statement to Tally Prime: Step-by-Step Guide

ICICI Bank is one of India's leading private banking entities, popular among businesses and startups due to its connected banking features and corporate account portal (Corporate Internet Banking). For accountants, managing client entries from ICICI statements means processing dozens of UPI transfers, salary checks, vendor bills, and bank charges every month.

Instead of manually keying in every payment and receipt voucher, importing these statement lines in bulk saves time and avoids transaction logging discrepancies. In this article, we cover how to download ICICI statements, map common transaction prefixes, and leverage automated review tools to sync ledger accounts directly to TallyPrime.

1. Downloading Statements from ICICI Corporate Banking

To obtain statements for your accounting books, follow these steps:

1. Log in to the ICICI Corporate Internet Banking (CIB) portal.
2. Go to Accounts > Account Statement on the top dashboard.
3. Choose your account details and specify the desired date range.
4. Select the file format. Choose PDF for official files or CSV/Excel for spreadsheet conversions.
5. Click Download to save the file.

2. Decoding ICICI Transaction Code Formats

ICICI statements include unique abbreviation prefixes that indicate how the money was moved. Knowing these simplifies accounting entries:

3. Creating a Tally-Compatible Excel Map

If you want to convert the file manually:

1. Open the ICICI Excel statement. Clear top header rows and balance details so that only the raw transaction grid remains.
2. Map columns to Date, Narration/Particulars, Withdrawal (Debit), and Deposit (Credit).
3. Standardize date columns to `DD-MM-YYYY` formats.
4. In TallyPrime, use the **Alt+O (Import)** command, select Bank Statement, select the HDFC/ICICI bank ledger, and select the file path.

4. Honesty Check: How TrulyInvoice Automates ICICI Bank Data Entry

TrulyInvoice is designed to eliminate manual spreadsheet formatting, Excel column mappings, and date errors. It provides a secure, review-first desktop sync tool.

To maintain transparency, here is exactly how the tool handles bank statements:

• No Live Bank Connection: TrulyInvoice does **not** log into your ICICI bank accounts or access netbanking online feeds. It does not ask for or store login credentials. You must download the statement PDF manually from ICICI and upload it to the tool.
• AI Column Parsing: TrulyInvoice parses the PDF statement and extracts columns (Date, Narration, Withdrawal, Deposit). It automatically merges multi-line descriptions.
• Ledger Suggestion System: Based on the narration, TrulyInvoice suggests accounting groups and ledger names (e.g. suggesting Bank Charges for monthly maintenance fees).
• Self-Serve Review: Review and adjust mappings in a grid. Correct ledger categories or batch-edit group parameters.
• Direct Sync: Sync the reviewed entries directly to TallyPrime via a local gateway port, creating voucher logs in seconds.
• Fast-Track Reconciliation: TrulyInvoice creates the voucher records, which means you do not have to type them. However, it does not replace Tally's built-in reconciliation checks. You must still run Tally's bank reconciliation tool to match voucher dates with actual clearing dates.

5. Summary

Whether you map columns manually in Excel or use TrulyInvoice's review-first engine to suggest ledgers and auto-sync transactions, standardizing HDFC and ICICI statements is crucial to clean book audits. Reconcile entries inside TallyPrime to complete the reconciliation flow.