Home
Our Products
For Investors For CA / Broking Firms RIA
Features
All Features User Manual Download Software
Reports
Broker Formats Import Templates
Integrations
System Configuration Channel Partners
Pricing
About
About Us Career Our Vision Our Mission
Contact
iRecord Helpdesk Email Call Us Start Free Trial →
Import Templates

Download
Import Templates
for iRecord

Ready-to-use Excel and CSV templates for every asset class. Download, fill in your trades, and import directly into iRecord — no reformatting required.

Equity & Stocks F&O Mutual Funds Commodities Bank Statements Journal / Ledger
24+ Pre-built Templates
Excel & CSV · Free Downloads
All major Indian brokers covered
Pre-formatted columns & headers
Direct one-click import into iRecord
Generic CSV for any custom data
How It Works

3 Steps to Import Your Data

Download the right template, fill in your trade data, and import into iRecord — no reformatting, no errors.

1

Download Template

Click the Download button next to the template that matches your broker or asset type — Excel or CSV.

2

Fill in Your Data

Open the template and enter your trade details in the pre-formatted columns — all field names are clearly labelled.

3

Import into iRecord

Use the Import function in iRecord, select your filled template, and your data loads instantly — verified and ready.

Browse Templates

Templates by Asset Class

All templates are free to download and work with iRecord's direct import function.

Equity / Stocks

Import buy/sell equity trades from all major Indian brokers. Supports BSE and NSE transactions.

6 Templates

Zerodha Equity Import

Fields: Date, Symbol, Exchange, Buy/Sell, Qty, Price, Brokerage

XLSX

Angel One Equity Import

Fields: Trade Date, Symbol, Buy/Sell, Quantity, Rate, Net Amount

XLSX

ICICI Direct Equity Import

Fields: Date, Stock, Exchange, Transaction, Qty, Price, STT, Charges

XLSX

HDFC Securities Equity Import

Fields: Date, Scrip, Buy/Sell, Qty, Rate, Brokerage, Net Amount

XLSX

Upstox Equity Import

Fields: Trade Date, Instrument, Buy/Sell, Quantity, Price, Net Amount

XLSX

Generic Equity CSV Template

Fields: Date, Symbol, Exchange, B/S, Qty, Price, Brokerage, Net Amount

CSV
F&O (Futures & Options)

Import futures and options contract trades with premium, lot size and expiry details.

4 Templates

Zerodha F&O Import

Fields: Date, Instrument, Strike, Expiry, Buy/Sell, Lots, Price, Premium

XLSX

Angel One F&O Import

Fields: Trade Date, Instrument, Strike Price, Expiry Date, B/S, Qty, Rate

XLSX

ICICI Direct F&O Import

Fields: Date, Contract, Strike, Expiry, Transaction, Lots, Price

XLSX

Generic F&O CSV Template

Fields: Date, Instrument, Strike, Expiry, B/S, Lots, Lot Size, Price, Brokerage

CSV
Mutual Funds

Import SIP transactions, lump sum investments, redemptions and switches.

4 Templates

CAMS CAS Statement Import

Fields: Date, Fund Name, Folio, Transaction Type, Units, NAV, Amount

XLSX

KFintech CAS Statement Import

Fields: Date, Scheme, Folio No, Transaction, Units, NAV, Amount

XLSX

BSE Star MF Import

Fields: Date, Scheme Name, Order Type, Units, NAV, Amount, Status

XLSX

Generic MF CSV Template

Fields: Date, Fund Name, Transaction Type, Units, NAV, Amount

CSV
Commodities (MCX)

Import MCX and NCDEX commodity trades — Gold, Silver, Crude Oil and more.

3 Templates

Zerodha MCX Import

Fields: Date, Commodity, Expiry, Buy/Sell, Lots, Price, Brokerage

XLSX

Angel One MCX Import

Fields: Trade Date, Commodity, Contract, B/S, Qty, Rate, Charges

XLSX

Generic MCX CSV Template

Fields: Date, Commodity, Expiry, B/S, Lots, Lot Size, Price, CTT, Net Amount

CSV
Bank Statements

Import bank account transactions to track cash flows and reconcile your portfolio.

4 Templates

HDFC Bank Statement Import

Fields: Date, Narration, Chq/Ref No, Value Date, Debit, Credit, Balance

XLSX

ICICI Bank Statement Import

Fields: Transaction Date, Particulars, Debit, Credit, Balance

XLSX

SBI Bank Statement Import

Fields: Date, Description, Ref No, Debit, Credit, Balance

XLSX

Generic Bank CSV Template

Fields: Date, Description, Debit, Credit, Closing Balance

CSV
Journal / Ledger

Import journal entries, trial balance data, and ledger transactions.

3 Templates

Journal Entry Template

Fields: Date, Voucher No, Account, Narration, Debit, Credit

XLSX

Ledger Import Template

Fields: Date, Account Name, Debit, Credit, Narration

XLSX

Generic Journal CSV

Fields: Date, Account, Narration, Debit Amount, Credit Amount

CSV

Auto-Import from 2,800+ Brokers

Why fill templates manually? iRecord auto-imports directly from your broker's contract notes.

Download Free Trial → ✓ 7-day trial · ✓ No credit card · ✓ Windows