Tax and GST

Year-end totals for gig workers: add up work costs by category

A step-by-step way to total a financial year's work-related spending as a gig worker, with a SUMIFS formula, a worked table and a list for your CA.

Editorial illustration for Year-end totals for gig workers: add up work costs by category

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.

CategoryWork?Year total
FuelYes₹36,000
Bike servicing and repairsYes₹9,500
Phone rechargeYes₹3,588
Parking and tollsYes₹2,400
GroceriesNo₹54,000
RentNo₹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

  1. Export the flagged rows with date, category, amount and notes.
  2. Attach platform payout statements for the same dates.
  3. List the mixed-use items and the percentage you applied.
  4. Ask which items they would treat differently.
  5. Keep the originals for as long as your CA advises.
SPENDIXAI JOURNAL

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

Explore your reports