Freelance Income & Expense Tracker (India)

What this is

A financial tracker for Indian freelancers. You log every invoice and expense, and the sheet calculates your GST input credit, estimates quarterly advance tax, and builds 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)
• Net advance tax payable after TDS already deducted

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

1. Log income weekly. Every paid invoice goes in Tab 1.
2. Log expenses as they happen. Receipts fade, and you won’t remember the details months later.
3. Check Tab 4 every quarter, before each advance tax deadline.
4. Send Tab 5 to your CA at year-end. It 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