How to Post Zerodha Purchase and Sales Entries in TallyPrime
How to Post Zerodha Purchase and Sales Entries in TallyPrime
Step-by-step accounting guide to recording Zerodha equity transactions, contract notes, F&O business turnover, and banking payouts in Tally Prime.
Who is this for: Investment Accounting
Zerodha is India's leading discount broker, used by millions of retail and corporate investors. However, recording Zerodha trades in your accounting books can be incredibly complex.
A single day of active trading generates multiple contract notes, combining purchase costs, sell proceeds, brokerage fees, exchange transaction taxes, SEBI charges, stamp duties, GST, and Securities Transaction Tax (STT). To ensure tax compliance, you must separate capital gains from speculative or business trading activities.
Tally Ledgers Hierarchy for Zerodha Accounts
Before posting vouchers, ensure the following ledger accounts are created in TallyPrime:
- Zerodha Wallet Ledger: Create a ledger named
Zerodha Broking Ledgerunder Sundry Debtors or Current Assets to represent the fund balance in your trading account. - Investment Ledgers: Create asset accounts under Investments for long-term shares (e.g.,
Infosys Shares A/c). - Trading Ledgers (For F&O/Intraday): If F&O or intraday is treated as business trading, create a
Stock Trading Purchase A/cunder Purchase Accounts. - Regulatory Taxes & Fees:
Zerodha Brokerage Fees(Indirect Expenses)Exchange Transaction Charges & SEBI Fees(Indirect Expenses)Securities Transaction Tax (STT)(Indirect Expenses / Capitalized directly to cost of investment)
Posting Stock Purchases (Journal Voucher - F7)
To maintain accurate tax records, the cost of acquisition must include stamp duties and purchase STT. Debit the investments and expenses, and credit the broker ledger:
Debit: Investment - Infosys Shares -- [Buy Value + Stamp Duty + STT]
Debit: Brokerage Charges (Indirect Expenses) -- [Brokerage Fee]
Debit: CGST & SGST / IGST -- [GST on Brokerage]
Credit: Zerodha Broking Ledger -- [Net Cash Deducted from Wallet]
Posting Stock Sales & Capital Gains
When you sell shares, record the receipt of funds in the broker wallet and book the profit or loss under the correct statutory categories (Short-Term Capital Gains u/s 111A or Long-Term Capital Gains u/s 112A).
Debit: Zerodha Broking Ledger -- [Sale Consideration Received]
Debit: Brokerage & Exchange Charges -- [Charges Withheld]
Credit: Investment - Infosys Shares -- [Original Buying Cost]
Credit: Short-Term Capital Gains u/s 111A -- [Profit Amount]
Special Case: Accounting for F&O Trading in Tally
Unlike equity delivery, F&O transactions are treated as non-speculative business income under Section 43(5) of the Income Tax Act. F&O gains and losses should be booked directly to the P&L account rather than as capital assets.
| F&O Trade Outcome | Account Debited | Account Credited |
|---|---|---|
| F&O Realized Profit | Zerodha Broking Ledger | F&O Trading Income (Direct Income) |
| F&O Realized Loss | F&O Trading Loss (Direct Expense) | Zerodha Broking Ledger |
Annual Zerodha Tax P&L Report: Download & Reconciliation
Zerodha provides an official Tax P&L Report through its back-office platform, Zerodha Console. This report is the single most important document for correctly filing your ITR when you have stock trading activity.
To download the report, log in to console.zerodha.com, navigate to Portfolio → P&L, select the relevant financial year (April 1 to March 31), and click Download Tax P&L. The report is available in both PDF and PDF formats and breaks down your gains into short-term capital gains (STCG), long-term capital gains (LTCG), speculative intraday income, and F&O business turnover — all pre-segregated per the Income Tax Act.
For ITR filing purposes, F&O losses from this report are eligible to be carried forward for up to 8 assessment years under Section 72 of the Income Tax Act, and can be set off against future non-speculative business income. Ensure these carry-forward losses are claimed in Schedule BFLA and Schedule CFL of your ITR-3. Once you have reconciled the Tax P&L figures with your Tally books, verify that the net capital gain and F&O income totals in your Tally Trial Balance match the corresponding figures in the Zerodha report before submitting your return.
Automating Payout Reconciliations
Because Zerodha wallet transfers occur frequently, you must record Bank-to-Wallet and Wallet-to-Bank receipts. Doing this entry line-by-line is slow and prone to errors.
You can streamline your bookkeeping with TrulyInvoice. TrulyInvoice extracts deposit and withdrawal rows from your bank statement PDFs (HDFC, SBI, ICICI, etc.) and routes them to your Tally Prime contra and receipt ledgers. TrulyInvoice processes unlimited transactions on a flat subscription of plans starting at ₹399/month, ensuring your bank books are perfectly reconciled.
Chartered Accountant & Accounting Automation Specialist