Short answer: Agni Folio Premium has two reports for Indian taxpayers. The Capital Gains report works out short-term (STCG) and long-term (LTCG) gains on Indian shares for each financial year, applies the ₹1.25 lakh long-term exemption, estimates the tax including cess, and exports to Excel. The Schedule FA report fills the foreign-assets tables of your ITR from the foreign bank accounts, shares, funds, property and crypto you already track, converted at SBI rates. Both are built from your own transaction history, and both are estimates for planning that you or your CA check before filing.
This guide explains what each report covers, how the numbers are worked out, and where the limits are, so you know exactly what to expect.
Who these reports are for
- Investors who file an Indian income tax return and hold Indian shares across one or more brokers.
- Resident Indians with foreign assets: US shares bought under LRS, RSUs or ESOPs from an employer abroad, a foreign bank account, property or crypto held overseas. Residents must list these in Schedule FA.
- Families who track several people's money in one login. Each report is worked out for one person at a time, because each person files their own return.
Both reports appear under Insights when your default country in Settings is India. They are part of Premium.
The Capital Gains report
What it covers
- Indian shares: holdings recorded as stocks, priced in rupees or listed on NSE (
.NS) or BSE (.BO). - Every financial year from FY 2018-19, April to March. You switch years from a dropdown.
- Sales in the year (realised gains) and what you still hold (the gain you would make if you sold today).
- One person at a time. It opens on your own (Self) accounts, and a "Whose gains" picker switches to any other account, such as your spouse's. Each person gets their own ₹1.25 lakh allowance.
How the numbers are worked out
- Oldest shares sell first (FIFO), the same order the tax rules use.
- Long term means held more than 12 months. Exactly 12 months is still short term.
- Rates follow the sale date. Before 23 July 2024: 15% short-term and 10% long-term. On or after 23 July 2024: 20% short-term and 12.5% long-term.
- Long-term exemption: ₹1 lakh a year, rising to ₹1.25 lakh from FY 2024-25.
- Losses offset gains: short-term losses against short-term gains first, then long-term; long-term losses only against long-term gains.
- 4% cess is added to the estimated tax.
- Bonus shares come in at zero cost, and splits change the number of shares, not what you paid.
- Same-day buy and sell (intraday) trades are listed separately, because they are business income, not capital gains.
The Still holding table shows when each holding turns long-term, for example "long-term in 42 days", which helps you time a sale.
Nothing is silently left out
Anything the report cannot work out safely goes into a Needs attention list instead of the totals: sales without a matching purchase, shares that arrived by transfer or statement import with no purchase date, intraday trades, and ETFs (which are taxed differently depending on the fund type, so they are shown but not counted). Each item links to the holding so you can fix it.
Excel export
One click downloads a workbook with Summary, Realized, Unrealized and Needs attention sheets for your CA.
Limits to know
- Mutual funds are not in the report yet. Nor are foreign shares or crypto.
- Grandfathering is not applied. Shares bought before 1 February 2018 are tagged "Pre-2018" so you know the estimate may be too high for them.
- Surcharge, carry-forward losses from earlier years, other income and rebates are not included.
- If your display currency is not rupees, gains are shown in your currency at today's rate, while the tax, exemption and cess stay in rupees, as filed in India.
The Schedule FA report
Schedule FA is the part of the ITR where a resident lists foreign assets held at any time during the calendar year (January to December). It asks for the peak and closing value of each asset in rupees, which is tedious to work out by hand, especially for shares bought in many lots.
What it fills in
| Table | What goes in it |
|---|---|
| A1 Bank accounts | Foreign bank (depository) accounts |
| A2 Broker accounts | Foreign custodial accounts: your holdings at each broker, added up day by day |
| A3 Shares and funds | One row per purchase lot. Lots sold during the year show a closing value of 0 and the sale proceeds |
| C Property | Foreign immovable property, at cost |
| D Other assets | Other foreign capital assets such as crypto, at cost |
| Not filled | Foreign holdings the report could not place, listed so you can enter them by hand |
How values are converted
- Values use the SBI telegraphic transfer (TT) buying rate on the date of each value, or the last earlier published rate. Every figure shows the amount, the rate and the date it came from.
- Income and sale proceeds use the rate for the last day of the previous month, as Rule 115 requires.
- Share prices are the actual traded prices on each day, not prices adjusted for later splits.
A Whose return picker shows one person at a time, and the whole report exports to Excel.
How to get accurate reports
- Record buys and sells, not just today's value. Both reports are built from transactions. Import broker statements or contract notes on the AI Import page and confirm the rows.
- Put each person's holdings in their own account (Self, Spouse, Parents), so each report matches one taxpayer.
- Fill in the country on foreign holdings, so Schedule FA can place them.
- Clear the Needs attention list before you send the export to your CA.
For mutual funds, bring your holdings in from your registrar statement: see how to import your CAMS / KFintech CAS.
Frequently Asked Questions
Does Agni Folio calculate LTCG and STCG for Indian shares?
Yes. The Premium Capital Gains report works out short-term and long-term gains on Indian shares for each financial year from FY 2018-19, using FIFO, the 12-month rule, the rates in force on each sale date, and the ₹1.25 lakh long-term exemption, with an estimated tax including 4% cess and an Excel export.
Does it cover mutual funds?
Not yet. Mutual funds, foreign shares and crypto are not part of the Capital Gains report today. ETFs are listed but not added to the totals, because their tax treatment depends on the fund type.
Can Agni Folio prepare Schedule FA?
Yes. The Premium Schedule FA report fills tables A1, A2, A3, C and D from the foreign assets you track, converted at SBI TT buying rates for the calendar year, and exports to Excel. Anything it cannot place is listed under Not filled.
Can I see capital gains for my spouse separately?
Yes. The report is worked out per account. It opens on your own accounts, and you can switch to your spouse's account, which gets its own exemption.
Is this tax advice?
No. Both reports are estimates for planning and record-keeping. Check them, or have your CA check them, before you file.
Are these reports free?
They are part of Premium. Tracking, statement import, XIRR, FIRE planning and legacy planning with one nominee are on the free plan.
