A side income log is one sheet with a row for every payment you get outside your salary: date, source, mode of payment, amount, and where the proof lives. Even small and irregular earnings belong in it. The reward comes later, when you or your CA need to know what arrived, from whom, and how.
Which columns should the log have?
| Column | Heading | Example |
|---|---|---|
| A | Date | 12-10-2026 |
| B | Source | Tuition, Resale or Creator |
| C | Who paid | Student's parent, buyer, brand |
| D | Mode | UPI, cash, bank transfer |
| E | Amount received | ₹1,500 |
| F | Cost, if resale | What you paid for the item |
| G | Proof | Screenshot or file name |
| H | Notes | Anything unusual |
Keep the sheet separate from your salary records. Salary is shown on your payslip and is documented by your employer; side income is documented by you.
What does a month look like with weekend tuition and online resale?
Say you teach on four weekends in a month and each session pays ₹1,500, so tuition brings in 4 × ₹1,500 = ₹6,000. In the same month you sell three things you no longer use: ₹800, ₹1,200 and ₹450, which is ₹800 + ₹1,200 + ₹450 = ₹2,450. All numbers are invented.
The month's side income is ₹6,000 + ₹2,450 = ₹8,450. Record the item cost for resale in its own column. For things you bought to sell, the cost is separate from the sale price. For things you simply sold from your own use, the cost column may stay blank. How profit or loss is viewed is a question for your CA; the log only keeps the facts.
What proof should you keep, and where?
- Tuition by UPI: a screenshot of the payment, or the bank statement line.
- Tuition in cash: a short note in the log with the student's name, and a message from the parent confirming the month if they are happy to send one.
- Resale: the chat or listing screenshot, the buyer's payment, and the courier slip if the item was shipped.
- Creator pay: the payout statement and the brand's invoice or message.
Save each file with the date and source in the name, for example 2026-10-12 tuition upi 1500. A folder per month keeps it tidy.
Which formulas help?
These work in Excel and Google Sheets, assuming dates in column A, sources in B and amounts in E, down to row 300:
- Total for one source: =SUMIFS($E$2:$E$300, $B$2:$B$300, "Tuition")
- Total for a month, say November 2026: =SUMIFS($E$2:$E$300, $A$2:$A$300, ">="&DATE(2026,11,1), $A$2:$A$300, "<"&DATE(2026,12,1))
- Number of payments received: =COUNTA($E$2:$E$300)
- Total for the financial year starting April 2026: =SUMIFS($E$2:$E$300, $A$2:$A$300, ">="&DATE(2026,4,1), $A$2:$A$300, "<="&DATE(2027,3,31))
If you accept cash for tuition, a short message from the parent after each month, such as received ₹6,000 for October, gives you something written to save. It costs them a few seconds and puts the amount and the month on record in someone else's words as well as yours.
How do you keep up the habit?
- Add the row the day the money arrives, while you remember what it was for.
- Take the proof at the same time: screenshot, photo or note.
- Once a month, check the log against your bank statement and tick off each credit.
- Mark credits that are not side income, such as a friend paying you back, so they do not confuse the totals.
- Share the log with your CA once a year, along with the proof folder.
Where does the spending side go?
Costs linked to the side work, such as a printer cartridge or a courier charge, belong with your expenses. In SpendixAI you can add them by hand with receipts attached, or upload the bank statement, and give them a category of their own so they are easy to separate from household spending.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

