FIFO gains calculated automatically - hand the totals straight to your CA.

A clean FIFO crypto tax ledger with example data loaded so the method is obvious.

What you get:
- Transactions tab: one row per buy, sell, swap or income - 8 example rows loaded covering purchases, a sale, a crypto-to-crypto swap and staking income - FIFO Gains tab: gain per disposal calculated automatically, oldest lot first, with a running total - Rules tab: FIFO basics plus India VDA notes (30% + 1% TDS, no loss set-off) and US short/long-term notes

Works in Excel and Google Sheets. This ledger tracks; it does not file. Not tax advice - verify your jurisdiction's current rules.

Files & format: one XLSX workbook (crypto-tax-ledger-fifo.xlsx) + README.md. Opens in Excel, Google Sheets or LibreOffice - no macros, no add-ins. Example transactions, FIFO gain formulas and the totals row are all preloaded and editable; replace the examples with your own rows.