A TDS tracker for freelancers is a sheet with one row per client per quarter: what you were paid, what deduction the client showed, whether you have the certificate, and the date you asked for it. Keep it up to date as payments arrive and the missing certificates become visible long before anyone asks for them.
What columns does the tracker need?
| Column | Heading | Purpose |
|---|---|---|
| A | Client | Who deducted |
| B | Quarter | Q1 April to June, Q2 July to September, Q3 October to December, Q4 January to March |
| C | Gross paid | Total the client billed or paid for the quarter |
| D | Deduction shown | Tax deducted, as per the client's payment advice |
| E | Net received | What reached your bank |
| F | Certificate received | Yes or No |
| G | Date requested | When you last asked |
| H | Date received | When it arrived |
| I | File name | Where the PDF is saved |
The quarters follow the April to March financial year. Leave out rates and sections: your sheet records what the client showed, and your CA decides what is right.
What does a filled sample look like?
The numbers below are invented. A freelancer has two clients in the July to September quarter. For Client One, gross ₹60,000, deduction shown ₹6,000, net ₹54,000, certificate not yet received. For Client Two, gross ₹30,000, nothing deducted, net ₹30,000.
| Client | Quarter | Gross paid | Deduction shown | Net received | Certificate |
|---|---|---|---|---|---|
| Client One | Q2 | ₹60,000 | ₹6,000 | ₹54,000 | No |
| Client Two | Q2 | ₹30,000 | ₹0 | ₹30,000 | Not applicable |
| Client One | Q3 | ₹45,000 | ₹4,500 | ₹40,500 | No |
For the first row, ₹60,000 minus ₹6,000 gives ₹54,000, which should match your bank credits for that quarter. If it does not, something is wrong, and the sheet has just caught it.
Which formulas make the sheet useful?
These work in Excel and Google Sheets, with ranges set to row 300 for convenience:
- Total deduction shown by one client: =SUMIFS($D$2:$D$300, $A$2:$A$300, "Client One")
- Certificates still pending: =COUNTIFS($F$2:$F$300, "No")
- Pending for one quarter: =COUNTIFS($B$2:$B$300, "Q2", $F$2:$F$300, "No")
- Net check for a row: =C2-D2-E2, which should be zero
- Total deduction shown across the year: =SUM($D$2:$D$300)
How do you chase a missing certificate politely?
Wait until the client has had a reasonable chance to issue it, and ask the client when to expect one for each quarter, so you know how long a polite wait should be. Then send a short message. Something like this:
Write the date in column G. If nothing comes within a couple of weeks, follow up once more, copying the person who handles accounts. Then keep asking at a sensible interval instead of dropping it.
What should you compare the sheet against?
Your sheet lists what clients told you. The official portal's tax credit statement lists what has actually been reported against your tax ID. Your CA can tell you which statement to use and when it is complete enough to compare. If a deduction appears in the sheet but not in the official statement, ask the client to look into it, and tell your CA.
Rules, rates and due dates change, so confirm the current position with your CA or the official source.
A quarterly routine
- Add a row for each client when the quarter ends, using payment advices and bank credits.
- Check gross minus deduction against the net received.
- Request certificates and note the date.
- Save each certificate as a PDF named with client, quarter and year.
- Compare the sheet with the official statement, and send any gaps to your CA.
Your business expenses are a separate list; SpendixAI can import card and bank statements for that side, and keep receipts with each transaction, while this tracker stays as your income-side record.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
