| Account Name | Category / Sub | Opening | Debit | Credit | Balance |
|---|
Select an account.
Upload an XLSX that follows the template columns below. Sheet name = financial year (e.g. 2025-26). Multiple year sheets are supported.
| COA | Bank entries | Journal / Opening | Investments | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Code | Account Name | Category | Sub Category | Date | BV Code | Account Name | Bank | Debit | Credit | Narration | Date | JV Code | Account Name | Debit | Credit | Narration | Asset Type | Asset Name | Debit Account | Credit Account | Pur Date | Pur Qty | Pur Rate | Pur Amount | Debit Account2 | Credit Account2 | Sale Date | Sale Qty | Sale Rate | Sale Amount | CMP |
| 101 | Capital | Liability | Capital | 01/04/25 | BV-001 | … | HDFC… | 31/03/2025 | Opening | Capital | amt | Shares | Reliance | Opening / Inv | Zerodha | date | qty | rate | amt | Zerodha | Investment - Shares | date | qty | rate | amt | cmp | |||||
COA: Code, Account Name, Category (Asset/Liability/Income/Expense), Sub Category.
Bank: Date, BV Code, counterparty Account, Bank name, Debit/Credit, Narration.
JV: Use JV Code Opening (or date before FY start) for opening balances.
Investments: Debit/Credit Account = purchase; Debit/Credit Account2 = sale (proceeds / cost). Opening lots: Debit Account = Opening.