To find your year-end total of work-related spending as a gig worker, list every payment between 1 April and 31 March, give each a category, mark the categories that relate to your work, and add up the flagged ones. The total is a figure to hand your CA, who decides which parts count for tax.
Why gig workers reach March with no idea of the total
Your income comes from several platforms and clients, and the costs come from several wallets and cash. Nobody gives you a summary, so the year-end total depends on whether you recorded things all year.
Step by step: the spreadsheet route
Put one payment on each row. Column A holds the category, column B the date, column C the amount, and column D marks work as Yes or No. Then, in a summary cell, add up the work rows for one category with a formula. This works in Excel and Google Sheets.
- Total of work rows for fuel: =SUMIFS($C$2:$C$500, $A$2:$A$500, "Fuel", $D$2:$D$500, "Yes")
- Total of all work rows: =SUMIFS($C$2:$C$500, $D$2:$D$500, "Yes")
- Count of work rows with no amount: =COUNTIFS($D$2:$D$500, "Yes", $C$2:$C$500, "")
SUMIFS takes the range to add first, then pairs of a range and its condition. Double-check the order, or you will add the wrong column.
A worked example for a delivery partner
Say these are hypothetical yearly totals.
| Category | Work? | Year total |
|---|---|---|
| Fuel | Yes | ₹36,000 |
| Bike servicing and repairs | Yes | ₹9,500 |
| Phone recharge | Yes | ₹3,588 |
| Parking and tolls | Yes | ₹2,400 |
| Groceries | No | ₹54,000 |
| Rent | No | ₹96,000 |
Work-flagged total: 36,000 + 9,500 + 3,588 + 2,400 = ₹51,488. Everything flagged No, which is 54,000 + 96,000 = ₹1,50,000, stays out. A phone recharge of ₹299 for twelve months is 299 × 12 = ₹3,588, which is why monthly small amounts matter.
What if some costs are mixed?
Split mixed costs into two rows rather than flagging the whole amount. If a ₹12,000 yearly phone bill is used 70 percent for work, enter ₹8,400 as work and ₹3,600 as personal: 12,000 × 0.70 = 8,400, and 12,000 − 8,400 = 3,600. Keep the reason in the notes.
What if I use a tracker instead?
When a sheet stops being enough, for example once statements from two banks and a wallet arrive monthly, SpendixAI can import them, categorise them, and the tax summary totals the categories you have marked tax-deductible for the period. The marker is a label for your own list, and the app does not compute tax.
A sanity check before you hand it over
Divide the flagged total by twelve to see the monthly average, then scan the months for any that look too low. Using the earlier example, 51,488 ÷ 12 is about ₹4,291 a month. If one month shows only ₹800, you probably forgot to record that month rather than spent less. Fix the gap from statements before you send the file, because your CA will notice it too.
Keep the date column in a real date format, not as text, so you can filter between 1 April and 31 March without surprises. If you paste a statement from a bank and the dates do not sort properly, they are probably text; re-enter one and copy the format down. Also keep a spare sheet for payments you are unsure about, with a column asking: ask CA. At the end of the year, the unsure list is a short, focused conversation instead of a shoebox.
Handing it to your CA
- Export the flagged rows with date, category, amount and notes.
- Attach platform payout statements for the same dates.
- List the mixed-use items and the percentage you applied.
- Ask which items they would treat differently.
- Keep the originals for as long as your CA advises.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


