To compare income quarter on quarter, put the two quarters side by side by source, work out the percentage change for each, then remove one-off credits and see what is left. A quarter that looks like growth can turn out to be a decline once a single lump sum is taken out, so the adjusted figure is the one to trust.
How do I set up the comparison?
Make three columns: the earlier quarter, the later quarter and the change. Do it for each source separately and also for the total. The percentage change is the later figure minus the earlier figure, divided by the earlier figure. In a sheet, if the earlier total is in B2 and the later in C2, that is =(C2-B2)/B2, formatted as a percentage.
Always compare the same kind of number. Do not put money received in one quarter against money invoiced in the other.
What does a worked example show?
Say a household had these incomes. The figures are invented.
| Source | Earlier quarter | Later quarter | Change |
|---|---|---|---|
| Salary | ₹1,50,000 | ₹1,50,000 | 0% |
| Freelance | ₹60,000 | ₹90,000 | +50% |
| Tuition | ₹36,000 | ₹30,000 | -16.7% |
| Total | ₹2,46,000 | ₹2,70,000 | +9.8% |
On the face of it, income is up by ₹24,000, which is about 9.8 percent. Now suppose ₹35,000 of the freelance figure was a one-time payment for an annual project that will not repeat. Remove it, and the later quarter is ₹2,35,000. Compared with ₹2,46,000, that is a fall of ₹11,000, about 4.5 percent. The freelance line is then ₹55,000 against ₹60,000, down by about 8 percent.
Which credits are one-offs?
- A lump sum for work that is done once a year or once ever.
- Arrears or a bonus that is not part of normal pay.
- A refund, a transfer between your own accounts, or a gift.
- Money from selling something you own.
- Two months of a client's payment arriving in the same quarter because one was late.
The last one is easy to miss. If a client paid late, the earlier quarter looks weak and the later one looks strong, even though the client's rhythm did not change. Combine the two quarters for that client to see what is really going on.
How do seasons affect the comparison?
Many incomes in India follow the calendar. A tutor may be busy before exams and quiet in the summer break. A seller may see more orders around the festival months than after them. Someone doing work for businesses may see a rush around the end of the financial year in March. If you can, compare a quarter with the same quarter a year ago as well as with the previous one. The previous quarter tells you momentum; the same quarter last year tells you whether the season is behaving normally.
What might a flat quarter mean?
It can mean steady, which is good if your costs are also steady. It can mean stuck, if you expected growth and did nothing different. And it can hide movement underneath: one stream rising while another falls by the same amount. Always look at the sources, not just the total.
Where does a tracker help?
Since the work is mostly sorting credits by source and period, SpendixAI can help once statements are imported and reviewed. Its Report builder can filter and group, and you can download a CSV to run the percentage change in a sheet. Credits still need to be labelled correctly first, otherwise a gift or a refund will inflate a quarter.
Does the length of the quarter matter?
Quarters are about equal, but months are not. A quarter with a five-week month and five Saturdays can look different for a tutor or a stall owner. If your income depends on the number of working days or weekends, count those days and divide, so you compare income per working day as well as the total.
Questions to finish with
- Which source changed the most, in rupees and in percent?
- What would the comparison look like without the one-offs?
- Is the season normal for this quarter?
- Is the change a trend, or just one quarter?
- What will I check next quarter?
Useful ideas start with a clearer picture of your own spending.
Explore your reports


