A freelancer in India juggles income tax, GST and TDS from the same bank statement. This kit puts them in one workbook: a ledger that calculates GST and TDS, a section 44ADA calculator that compares both regimes, a GST invoice that picks CGST, SGST or IGST, and a compliance calendar for October 2026 to March 2027.
What You Get
- Income and expense ledger. 200 rows with dropdowns, automatic GST, TDS and net amounts, and 12 sample rows to replace with your own.
- Monthly and quarterly totals. April to March receipts, GST collected and TDS by month and by quarter, using SUMIFS on the ledger.
- 44ADA presumptive calculator. Eligibility check against the Rs 50 lakh and Rs 75 lakh limits, 50% presumptive income and tax under the new and old regime with 87A rebate and cess.
- Advance tax schedule. Instalment dates and amounts, with the single 15 March payment for 44ADA filers and the four-instalment split for everyone else.
- GST invoice template. Fields for SAC, place of supply and reverse charge, CGST plus SGST or IGST chosen automatically, and a zero-rated export mode with LUT wording.
- TDS tracker and 26AS reconciliation. Compares your books with Form 26AS and AIS and labels each row MATCH, 26AS SHORT or MISSING IN 26AS with the action to take.
- ITR-4 checklist and calendar. Sixteen tick-off items, a printable checklist, 39 dated obligations and an .ics file with a one-day reminder on each.
- Three plain-language guides. Tax basics, GST for freelancers with a worked invoice, and records to keep, each with a disclaimer.
How to Use
- Open the workbook and fill Settings with your state code, financial year and regime.
- Replace the sample rows on Ledger with your receipts and expenses, entering amounts without GST.
- Read Monthly and 44ADA Tax to see your tax under both regimes.
- Pay advance tax by the dates on the Advance Tax sheet and import the .ics file for reminders.
- Issue each client invoice from GST Invoice and log the TDS on TDS Tracker.
- Reconcile with Form 26AS and AIS, then work through the ITR-4 checklist before filing.
Who This Is For
- Freelance designers, developers, writers and consultants in India on section 44ADA.
- Solo consultants crossing the Rs 20 lakh GST threshold who need clean invoices.
- Anyone exporting services who must issue invoices under an LUT.
- Founders who want a simple set of books before they hire an accountant.
General information only, not tax advice, so confirm figures on the official portals. Browse more in the freelancer templates collection, or try GST Invoice Generator.
Business
