Spreadsheets

Add a side hustle income tab to a salaried household budget sheet

Add a side income tab to your household budget sheet: log each payment, subtract direct costs, set money aside separately and feed the net into Income.

Editorial illustration for Add a side hustle income tab to a salaried household budget sheet

A side income tab is a small log next to your household budget: one row per payment received, the direct cost of earning it, a net figure, and a separate column for money you are setting aside for tax. A single monthly SUMIFS then sends the net into the Income tab, so your salary and side earnings sit in one picture without mixing up gross and take-home.

What columns does the Side Income tab need?

ColumnHeadingFormula or entry
ADate receivedActual date the money arrived
BSourceClient, platform or activity, for example Tuition or Resale
CDescriptionShort note or invoice number
DAmount received (₹)What reached your account
EDirect costs (₹)Material, software, delivery, travel for this job
FNet (₹)=D2-E2
GSet aside for tax (₹)=F2*TaxSetAsidePercent
HAvailable (₹)=F2-G2

Put TaxSetAsidePercent on a Settings tab as a placeholder such as 10 percent and name the cell. The right figure depends on your own situation, so ask your CA what to put there and change it when the position changes. If a client deducts tax before paying, add a column for the amount deducted, as shown on their payment advice.

What does a month of entries look like?

These numbers are made up. In one month you receive ₹15,000 for a design job, with ₹1,200 of software cost. You also sell goods online for ₹9,500 that cost you ₹6,200, with ₹300 for shipping. And you take tuition for ₹8,000 with no direct cost.

SourceReceived (₹)Costs (₹)Net (₹)
Design job15,0001,20013,800
Online resale9,5006,5003,000
Tuition8,00008,000
Total32,5007,70024,800

With a 10 percent placeholder, the set-aside is ₹2,480, which leaves ₹22,320 available. The line to feed into your household sheet is the ₹24,800 net, or the ₹22,320 if you prefer to count only what you can spend.

Name the data range SideIncome, or use plain ranges. On the Income tab, with the first day of each month in row 1 (B1, C1 and so on), enter this in B3 and copy right:

=SUMIFS('Side Income'!$H$2:$H$500, 'Side Income'!$A$2:$A$500, ">="&B$1, 'Side Income'!$A$2:$A$500, "<"&EDATE(B$1,1))

The quotes around Side Income are needed because the sheet name has a space. Add a source breakdown with SUMIFS on column B so you can see which activity earns most.

What should I record to keep my records clean?

  • The date money arrived and the exact amount credited to your account.
  • Which bank account or UPI handle received it.
  • A reference such as an invoice number, so a payment can be matched later.
  • Every direct cost, with a receipt photo saved in a folder named by month.
  • Anything deducted before payment, as shown by the payer.

Take ten minutes at month end to match the Side Income tab to your bank statement: every row should have a credit with the same date and amount, and every credit that is not salary should have a row.

Should side income lower my budget discipline?

Irregular income is best treated as a bonus on top of a budget that salary alone can pay for. Budget from the salary, and let side income fund savings, a sinking fund or a goal. That way a slow month does not break the household.

Before you rely on the sheet

Rules on how side income is taxed, and on registrations for business activity, differ by situation and change, so confirm the current position with your CA or the official source and keep your sheet as the supporting record. If your receipts arrive in a bank account you already import into SpendixAI, you can keep each payment's receipt attached to the transaction, and use the Export centre or CSV download when your CA asks for figures.

SPENDIXAI JOURNAL

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

Explore your reports