To track multiple income sources, keep one log with a row for every credit, tagged by source: salary, freelance, interest and so on. A second sheet then adds the log up month by month for the April to March year. One log, one summary, and any month or the whole year is a single formula away.
What does one filled month look like?
Take invented numbers for November. Your salary of ₹62,000 reaches the account on the last working day. Two freelance clients pay ₹12,000 and ₹8,500 on different dates, and the bank credits ₹143 in interest.
| Date | Source | From | Received | Proof |
|---|---|---|---|---|
| 30 Nov | Salary | Employer | ₹62,000 | Payslip and statement |
| 9 Nov | Freelance | Client A | ₹12,000 | Invoice and statement |
| 21 Nov | Freelance | Client B | ₹8,500 | Invoice and statement |
| 30 Nov | Interest | Bank | ₹143 | Statement line |
The month's total is ₹62,000 + ₹12,000 + ₹8,500 + ₹143 = ₹82,643. Whenever you total a month like this, check the sum against the credits in the bank statement.
How should the log sheet be set up?
Name the first sheet Log. Columns: A for the date received, B for the source, C for who paid, D for the amount as shown on the paper (payslip or invoice), E for anything held back at source, F for the amount received, and G for proof. Keep dates as real dates, not text, or the summary formulas will not work. If you want the payslip's gross and net, record the salary as it reaches the bank in F, and note the payslip figure in D.
What was held back, and how any of it is treated, is for your CA. The log records the numbers as shown.
How do you roll twelve months into an April-to-March total?
Name the second sheet Summary. In A2 put the date 1-Apr-2026, and in A3 the formula =EDATE(A2,1), filled down to A13 for March 2027. Then in B1, C1 and D1 write Salary, Freelance and Interest. In B2 enter:
- =SUMIFS(Log!$F$2:$F$500, Log!$B$2:$B$500, B$1, Log!$A$2:$A$500, ">="&$A2, Log!$A$2:$A$500, "<"&EDATE($A2,1))
- Fill that formula across to D and down to row 13.
- In E2 write =SUM(B2:D2) for the month's total, and fill down.
- In E14 write =SUM(E2:E13) for the year.
This works in Excel and Google Sheets. The source names in row 1 must match the Source column in the log exactly, since SUMIFS compares text. A stray space or a different spelling will produce a zero.
What might a year add up to?
Suppose, again with made-up numbers, salary of ₹62,000 for twelve months, freelance payments across the year of ₹1,26,500, and interest credits of ₹1,716. Salary comes to 12 × ₹62,000 = ₹7,44,000. The year's total is ₹7,44,000 + ₹1,26,500 + ₹1,716 = ₹8,72,216. A freelance share that moves a lot from month to month is normal, and the Summary sheet shows the pattern.
How do you keep the log accurate?
- Add each credit within a day or two, with the source and the proof.
- Once a month, tick every credit on your bank statement against a row in the log.
- Mark credits that are not income, such as a refund or a friend repaying you, in a notes column so they stay out of the totals.
- Keep interest rows too, however small; the bank statement shows each credit.
- At year end, check that the Summary total equals the sum of the Log amounts.
What about the money going out?
The log covers money in. Your spending sits on the other side. If you upload your bank statements to SpendixAI, you can review each row before saving, categorise your spending and see where it goes each month, while this sheet holds the income.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

