Planning
Record-keeping for freelancers: a simple monthly system
A one-hour monthly routine for invoices, receipts, TDS and GST, so tax season becomes a short checklist instead of panic.
By Siddharth Joshi4 min read
Most freelance tax stress is really record-keeping stress. The rules are learnable; what hurts is trying to rebuild a year of invoices, bank credits and bills in a single July weekend. A small routine, run once a month, fixes almost all of it. You do not need accounting software to start. A spreadsheet and a sensible folder structure are enough for most people.
What you need to keep
For income tax and, if you are registered, GST, aim to have these on hand for every financial year:
- every invoice you raise, numbered in sequence
- bank statements for the account you use for work
- FIRA or FIRC for each foreign payment
- Form 16A from clients who deduct TDS
- Form 26AS and the Annual Information Statement (AIS) from the income-tax portal
- bills for expenses you plan to claim, from software to hardware
- contracts or emails that show what you were paid for
If you are not on a presumptive scheme and your income or turnover crosses certain limits, the law requires you to maintain regular books of account. Your CA can tell you whether that applies; either way, the habits below keep you ready.
Set up once
Create one folder per financial year, for example “FY 2026-27”, with sub-folders:
01-invoices02-bank03-tds(16A, 26AS, AIS downloads)04-expenses05-foreign(FIRAs and platform statements)06-gst(returns and challans, if registered)
Then build a spreadsheet with an income tab and an expense tab. The income tab should have: invoice number, date, client, gross amount, GST charged, TDS deducted, amount received, date received. That last pair is what makes reconciliation easy.
The monthly hour
Pick a fixed date, such as the 5th, and do these steps in order:
- Invoices. Make sure every invoice from last month is in the folder and in the sheet, at gross value.
- Bank. Download last month’s statement. Mark each work credit against its invoice. Anything unmatched is either a missing invoice or a payment you need to chase.
- TDS. Where the bank credit is lower than the invoice, note the difference as TDS receivable.
- Expenses. Move receipts from email and phone into the expenses folder and log them, with a note on the business purpose.
- Set aside tax. Move a fixed share of what you received into a separate savings account for tax.
If you are GST-registered, this is also when you prepare figures for GSTR-1 and GSTR-3B, or for the quarterly filing if you use the QRMP scheme.
A worked example
Here is Neha’s September for a copywriting practice:
| Amount | |
|---|---|
| Invoiced to two Indian clients | ₹1,80,000 |
| TDS at 10% under 194J | ₹18,000 |
| Expected in bank | ₹1,62,000 |
| Actually received | ₹1,62,000 |
The bank figure matches, so she records ₹18,000 as TDS receivable. Her income for the month is ₹1,80,000, not ₹1,62,000. When she checks Form 26AS at the end of the quarter, she expects to see ₹18,000 from these two clients. If one of them is missing, she emails that client the same week.
The quarterly layer
Every three months, add three checks:
- download Form 26AS and the AIS and tick off each client’s TDS against your sheet
- request Form 16A from clients who deducted
- check whether advance tax is due: if your tax for the year, after TDS, will be ₹10,000 or more, instalments fall due by 15 June, 15 September, 15 December and 15 March
The AIS also lists interest, dividends and securities trades reported by banks and brokers. If an entry is wrong, the portal lets you submit feedback on it, which is much better done in October than the night before filing.
Year-end becomes a checklist
By April you should already have twelve reconciled months. Year-end is just: totals from the sheet, a final 26AS and AIS check, any depreciation on equipment, and handing the folder to your CA or filing yourself. The return that once took a week now takes an afternoon.
Small habits that pay off
- Use one bank account for work, even if it is just a second savings account.
- Never delete invoice numbers; cancel them with a note instead.
- Photograph paper bills the day you get them.
- Write a one-line purpose next to every expense; it saves arguments later.
- Keep old years’ folders safe and backed up; tax questions can arrive years after the return.
General information, not tax advice. Rules change, so check the latest rules or speak to a CA before you act.