It is March, your CA asks for your business expenses, and you are scrolling through six months of bank SMS alerts trying to remember what "UPI-4821" was. Most freelancers either track nothing or keep a half-filled sheet with a column called "Misc". A freelance expense tracker in India does not need software. It needs the right columns, categories that match the income tax return, and a habit you can keep in 20 minutes a month.
This post builds that tracker step by step. It covers the columns, the ITR-3 categories, the record-keeping rules, the cash payment rule that can wipe out a deduction, and GST invoices if you are registered. It is general information, not tax or legal advice, so confirm anything specific to you with a CA.
Do you need an expense tracker if you file under 44ADA?
Yes, though for different reasons. Under Section 44ADA your taxable profit is deemed to be 50 percent of your receipts, with no line-by-line expense claim, so no expense changes your income. You still need a tracker to know your real margin, to price work, and to have records ready if you ever leave the presumptive scheme.
The limit is ₹75 lakh if cash receipts are at most 5 percent of the total, otherwise ₹50 lakh, as the income tax department's page on presumptive taxation explains. If you file ITR-3 and claim actual expenses, the tracker is not optional: every rupee you cannot show is a rupee of tax you pay. The guide to ITR-3 versus ITR-4 for freelancers helps you decide which route fits, and the one on which freelance work qualifies for 44ADA covers eligibility.
One note on numbering. The Income-tax Act 2025 applies from 1 April 2026, and presumptive taxation, formerly Section 44ADA, now sits in section 58 of the new Act. Returns for AY 2026-27 still use the 1961-Act numbering, so this post names the old section first.
The columns your spreadsheet needs
Eight columns are enough: date, vendor, amount, category, payment mode, project or client, receipt link, and a GST column if you are registered. Each one answers a question you will be asked later. The date and amount tie to your bank statement, the category feeds your return, and the payment mode protects the deduction.
The "project or client" column is the one most people skip, and it is the one that tells you which work actually made money. Without it you only see totals, never margins. The receipt column should hold a link to the saved file, not the file itself, so the sheet stays light. The older guide on a freelance expense tracking system covers the logging habit in more depth.
Categories that match the ITR-3 profit and loss
Use categories that map to the expense heads in the ITR-3 profit and loss schedule, not your own invented labels. That way your yearly total drops straight into the return, and your CA does not have to re-sort a year of rows. Practical heads for a freelancer are software and subscriptions, rent, internet and phone, travel, professional fees, equipment and depreciation items, marketing, bank charges, and payments to subcontractors.
Keep big equipment purchases in a separate category. A laptop or camera is not a one-year expense, because depreciation spreads it over time, and the guide to depreciation on a laptop or camera in ITR-3 covers how that works. For the wider question of what counts as a business cost, see the post on deductible expenses scattered across bank statements and WhatsApp.
The general deduction for business expenses was Section 37 of the 1961 Act and is section 34 of the 2025 Act. Depreciation moved from Section 32 to section 33. If a cost is part personal, such as a phone plan, ask your CA what share is reasonable to claim and write that share down in your sheet.
How long to keep receipts and what books Section 44AA asks for
Plan on keeping receipts and books for six years from the end of the relevant assessment year, which is the period usually stated under Rule 6F, but confirm it with your CA. Section 44AA decides whether you must keep formal books at all, and it applies to certain notified professions above a gross receipts threshold. In the 2025 Act the equivalent is section 62. Whether a designer, developer or writer falls inside the listed professions is not something to guess, so ask your CA.
Rule 6F, which sets out the books for those professions, names a cash book, a ledger, and copies of bills issued, plus a journal where the mercantile system is used. Retention is usually stated as six years from the end of the relevant assessment year, but confirm that with a CA before you rely on it. If your turnover or profits cross the audit limits, the books also feed a tax audit, which the guide to tax audit and books of account for freelancers explains.
A simple rule that costs nothing: save every receipt as a PDF or photo the day you pay, name it with the date and vendor, and store it in one folder per financial year. The link in your sheet then points to a file you can find in seconds.
Pay by bank or UPI: the ₹10,000 cash rule
If you pay one person more than ₹10,000 in cash in a single day for a business expense, the whole expense can be disallowed, not just the excess. This is Section 40A(3) of the 1961 Act, and the payment must instead go by account-payee cheque, account-payee draft or a prescribed electronic bank mode. For transport of goods the limit is ₹35,000. It affects ITR-3 filers who claim actual expenses. It does not change income for 44ADA filers.
The test is per person per day: what counts is the total you pay one person in a single day. Splitting a bill across two days is a different situation from one payment, so ask your CA before relying on it. Rule 6DD lists exceptions, and the income tax department's Rule 6DD page is the place to check whether yours qualifies. In the 2025 Act the cash rule moved to section 36.
The practical habit: pay vendors from your bank or UPI, and write the mode in the "Paid by" column. The guide to payment modes and limits for freelancers covers the other cash limits worth knowing.
GST invoices and input tax credit
If you are GST-registered, ask vendors for a tax invoice with your GSTIN on it. Input tax credit needs a valid tax invoice, receipt of the service, the supplier having paid the tax, and the return being filed, which are the four conditions in Section 16(2) of the CGST Act. GSTR-2B is where you check that the supplier's tax shows up.
Only registered freelancers claim ITC. Under 44ADA, GST on business costs is a GST matter and not a profit and loss deduction. Time limits and reversal rules have conditions of their own, so check them with your CA. The guide to input tax credit for GST-registered freelancers goes through the claim, and the pillar on tools for running a freelance business in India shows where a tracker sits among the rest of your setup.
A 20-minute monthly routine
Set a fixed day, such as the 5th, and do four things in about 20 minutes: match your sheet to last month's bank statement, add anything missing, attach every receipt, and check that no cash payment crossed ₹10,000 to one person in a day. Then read the category totals and ask which one grew.
Here is an illustration with made-up numbers. If your sheet shows ₹6,000 of software and ₹6,000 of rent against ₹90,000 of receipts, overheads are ₹12,000, or about 13 percent of receipts. Next month, if software jumps to ₹10,000, the category total shows it and you can spot the subscription you forgot to cancel. The check takes minutes because you logged rows weekly instead of rebuilding them from memory in March.
Where Rinto fits
If you outgrow the spreadsheet, Rinto's expense tracking lets you log each expense with a receipt attached, a category and a project or client tag, set a recurring frequency, and see monthly and yearly totals for tax time. Expense tracking is on the Pro and Agency plans, not the free plan. The categories and claims are still a conversation with your CA.
Frequently Asked Questions
Do I need to keep expense bills if I file under 44ADA?
Under Section 44ADA your profit is deemed to be 50 percent of receipts, so you do not claim expenses line by line and no bill changes your taxable income. You still gain from keeping them. They show your real margin for pricing, they support a GST input tax credit claim if you are registered, and they protect you if you ever move to ITR-3 and claim actual expenses. Opting out of the presumptive scheme can bring books and audit consequences, so keep records going and ask a CA before you switch. A simple monthly log costs far less than rebuilding a year later.
Can I claim an expense I paid in cash above ₹10,000?
If you file ITR-3 and pay one person more than ₹10,000 in cash in a single day, Section 40A(3) of the 1961 Act can disallow the whole expense, not only the excess. The limit is ₹35,000 for payments for goods carriage. Payment by account-payee cheque, account-payee draft or a prescribed electronic bank mode avoids the rule. Rule 6DD lists exceptions, so check the income tax department's page or ask a CA before assuming yours qualifies. Under 44ADA the rule does not change your income, because there is no expense claim. The 2025 Act carries the rule in section 36.
How long should a freelancer keep expense receipts in India?
Rule 6F is usually described as asking professionals covered by Section 44AA to keep books for six years from the end of the relevant assessment year. Confirm that with a CA, since it depends on whether your profession is covered and on your turnover. A practical approach is to keep receipts for at least that long anyway. Save each one as a PDF or photo on the day you pay, name it with the date and vendor, and keep one folder per financial year. Tax authorities can ask for records long after you file, and a receipt you cannot find is the same as one you never had.
Which expense categories go in the ITR-3 profit and loss?
The ITR-3 profit and loss schedule groups costs under heads, so build your sheet categories to match them. For a freelancer the usual ones are software and subscriptions, rent, internet and phone, travel, professional fees, marketing, bank charges, payments to subcontractors, and depreciation on equipment. Keep equipment in its own category, since depreciation spreads the cost over years instead of deducting it at once. Where a cost is part personal, such as a phone plan, ask your CA what share to claim. Matching the heads means your yearly total drops into the return without re-sorting.
Can a freelancer claim GST input tax credit on laptop or software invoices?
Only a GST-registered freelancer can claim input tax credit. The invoice must be a valid tax invoice with your GSTIN on it, you must have received the service or goods, the supplier must have paid the tax, and the return must be filed under Section 16(2) of the CGST Act. GSTR-2B is where you check that the supplier's tax appears. If you are unregistered, or you file under 44ADA, GST on business costs is not a profit and loss deduction. Time limits and special cases have conditions of their own, so ask your CA before claiming credit on a large purchase.