Tax and GST

A TDS tracker sheet by client and quarter for freelancers

A TDS tracker for freelancers: a sheet by client and quarter showing gross paid, deduction shown, certificate received and how to chase a missing one.

Editorial illustration for A TDS tracker sheet by client and quarter for freelancers

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?

ColumnHeadingPurpose
AClientWho deducted
BQuarterQ1 April to June, Q2 July to September, Q3 October to December, Q4 January to March
CGross paidTotal the client billed or paid for the quarter
DDeduction shownTax deducted, as per the client's payment advice
ENet receivedWhat reached your bank
FCertificate receivedYes or No
GDate requestedWhen you last asked
HDate receivedWhen it arrived
IFile nameWhere 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.

ClientQuarterGross paidDeduction shownNet receivedCertificate
Client OneQ2₹60,000₹6,000₹54,000No
Client TwoQ2₹30,000₹0₹30,000Not applicable
Client OneQ3₹45,000₹4,500₹40,500No

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

  1. Add a row for each client when the quarter ends, using payment advices and bank credits.
  2. Check gross minus deduction against the net received.
  3. Request certificates and note the date.
  4. Save each certificate as a PDF named with client, quarter and year.
  5. 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.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports