To track tax deducted at source and tax you paid yourself together, keep one list with a row for every credit of tax, whether a client deducted it or you paid it, and a running total beside it. This article shows the list for a part-year freelancer. No tax is computed here; the list's job is to show your CA what has been paid so far and how.
Why keep both in one list?
Tax paid through deduction and tax paid directly come from different places. Deductions appear in the client's certificates and the statement your CA can access; direct payments appear on your own challans and bank debits. When they sit in two separate notes, it is easy to forget one when you total what has been paid. One list, one running total, one source column.
What columns does the tally need?
- Date of the entry.
- Type: deducted at source or self-paid.
- Who deducted it or which instalment it was.
- Amount of tax, in rupees.
- Running total, which is the previous total plus this amount.
- Proof: certificate file name or challan file name.
- Checked against: the bank debit for self-paid items, or the invoice for deducted ones.
A worked example with hypothetical numbers
Say a freelancer started in June. Two clients deducted tax from their payments, and the freelancer paid two amounts directly.
| Date | Type | Detail | Tax (₹) | Running total (₹) |
|---|---|---|---|---|
| 20 Jul | Deducted | Client A, invoice 3 | 4,000 | 4,000 |
| 18 Aug | Deducted | Client B, invoice 5 | 6,500 | 10,500 |
| 15 Sep | Self-paid | Advance instalment 1 | 15,000 | 25,500 |
| 22 Oct | Deducted | Client A, invoice 7 | 5,000 | 30,500 |
| 15 Dec | Self-paid | Advance instalment 2 | 20,000 | 50,500 |
Check the arithmetic: 4,000 + 6,500 = 10,500; plus 15,000 = 25,500; plus 5,000 = 30,500; plus 20,000 = 50,500. Of that ₹50,500, deductions are 4,000 + 6,500 + 5,000 = ₹15,500 and self-paid is 15,000 + 20,000 = ₹35,000. The two parts add to 15,500 + 35,000 = ₹50,500, matching the running total.
How do you reconcile it?
Each type has its own check. For deducted entries, compare your invoices: the credit in your bank should be the billed amount minus the deduction. For self-paid entries, tick the challan against a debit on the statement. Where the client sends a certificate or statement of deducted tax, put its file name in the proof column.
What should your CA see?
Hand over the list as it stands, with the proof column filled in and a note on anything you could not verify. Your CA will compare it against the figures they can see on the official site. Do not adjust the list to match; if it differs from theirs, write the difference down and ask why. It may mean a deduction was reported late or under another name.
Where can SpendixAI help?
If you add bank statements from the account clients pay into, the credits appear in one list you can filter, which makes it easier to see the post-deduction amount received. The tally above remains your own record of the tax side; the app does not compute tax.
A small tip on proof: when a client deducts tax, file the certificate or statement with the invoice and mention the file name in the tally. Some clients send these only after a period has ended, so add a reminder to ask for them, and mark the row as not yet received in the meantime. A deduction without a document is easy to forget and hard to chase.
Keeping the tally current
- Add a row the day a client credit arrives with a deduction.
- Add a row the day you make a self-payment.
- Update the running total with a formula, such as =E2+D3 in cell E3, copied down.
- Every month, compare your total against what your CA tells you they can see.
- Before the year closes, send the list and all proof files together.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

