Calculator Finance
Freelance Income & Expense Tracker (India)
Track income, expenses, GST input credit, and quarterly advance tax — all in one Excel sheet. ITR filing becomes copy-paste.
Download Excel Excel · .xlsx
What this is
A complete financial tracker built for Indian freelancers. Log every invoice and expense, auto-calculate GST input credit, estimate quarterly advance tax, and generate a year-end summary that maps directly to ITR-3/ITR-4 fields.
What is inside
Tab 1: Monthly Income
- Date, client, invoice number, amount, GST collected, TDS deducted, net received
- Monthly and YTD totals auto-calculated
- TDS tracking with section references (194J, 194C, etc.)
Tab 2: Expenses
- Date, vendor, category, amount, GST paid (input credit)
- Categories pre-set for Indian tax deductions: rent, internet, software, travel, professional development, depreciation
- Auto-categorised by Section 80C, 80D, business expense
Tab 3: GST Summary
- Output GST (collected from clients) vs Input GST (paid on expenses)
- Net GST payable per quarter
- GSTR-3B filing helper with values mapped to form fields
Tab 4: Advance Tax Calculator
- Estimated annual income based on YTD run rate
- Tax slab calculation (new regime vs old regime comparison)
- Quarterly advance tax due dates and amounts (15 Jun, 15 Sep, 15 Dec, 15 Mar)
- TDS already deducted — net advance tax payable
Tab 5: Year-End Summary
- Total income, total expenses, net profit
- Tax liability summary
- Maps to ITR-3 (business income) or ITR-4 (presumptive) fields
- Exportable for your CA
How to use it
- Log income weekly — every invoice paid goes in Tab 1
- Log expenses as they happen — receipts fade, memory doesn’t stick
- Check Tab 4 quarterly — before each advance tax deadline
- Send Tab 5 to your CA at year-end — saves them 2 hours and saves you ₹2,000
Version history
| Version | Date | Notes |
|---|---|---|
| 2.0 | June 2026 | Added new vs old regime comparison, GSTR-3B helper |
| 1.0 | March 2026 | Initial release |
