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?
| Column | Heading | Formula or entry |
|---|---|---|
| A | Date received | Actual date the money arrived |
| B | Source | Client, platform or activity, for example Tuition or Resale |
| C | Description | Short note or invoice number |
| D | Amount received (₹) | What reached your account |
| E | Direct costs (₹) | Material, software, delivery, travel for this job |
| F | Net (₹) | =D2-E2 |
| G | Set aside for tax (₹) | =F2*TaxSetAsidePercent |
| H | Available (₹) | =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.
| Source | Received (₹) | Costs (₹) | Net (₹) |
|---|---|---|---|
| Design job | 15,000 | 1,200 | 13,800 |
| Online resale | 9,500 | 6,500 | 3,000 |
| Tuition | 8,000 | 0 | 8,000 |
| Total | 32,500 | 7,700 | 24,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.
How do I link it into the household Income tab?
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.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


