Income and work

Share of income by stream: spotting dependence on one source

Work out each income stream's share of your year's income from a tracker and read what a big share means for risk. Includes a made-up April to March example.

Editorial illustration for Share of income by stream: spotting dependence on one source

A stream's share of income is its total for the year divided by your total income from all streams, shown as a percentage. If one stream is most of the total, your household depends on it, and losing it would hurt much more than losing a small one. There is no magic percentage, but the number makes the risk visible.

How do I calculate each share?

  1. Pick a period. The April to March financial year works well, as does the last twelve months.
  2. Total each stream's income for that period.
  3. Add the stream totals to get total income.
  4. Divide each stream by the total and multiply by 100.

Be consistent about gross or net. Either use money received before costs for every stream, or money after costs for every stream. If you mix them, the shares will look wrong.

What does it look like with numbers?

Say a household's year in one tracker looks like this. These are made-up figures.

StreamYear totalShare
Salary₹6,60,00068.75%
Freelance work₹1,80,00018.75%
Rent from a flat₹96,00010%
Interest₹24,0002.5%
Total₹9,60,000100%

The total is ₹6,60,000 plus ₹1,80,000 plus ₹96,000 plus ₹24,000, which is ₹9,60,000. Salary is ₹6,60,000 divided by ₹9,60,000, which is 0.6875, or 68.75 percent. The others follow the same way, and the shares add to 100.

Which formulas do this in a sheet?

Say each credit is a row, with the stream name in column B, the amount in column C and the date in column A. In a summary, with the stream name in A2:

  • Year total, in B2: =SUMIFS($C$2:$C$2000,$B$2:$B$2000,$A2)
  • Total income, in B7: =SUM(B2:B5)
  • Share, in C2: =B2/$B$7, then format as a percentage
  • Largest share: =MAX(C2:C5)

If you want only one financial year, add date conditions to SUMIFS: =SUMIFS($C$2:$C$2000,$B$2:$B$2000,$A2,$A$2:$A$2000,">="&DATE(2025,4,1),$A$2:$A$2000,"<="&DATE(2026,3,31)). Change the years to the ones you need.

What does a big share mean?

In the example, salary is almost 69 percent. That is normal for a salaried household, and it is also the biggest single point of risk. If the employer changed or cut pay, most of the household income would be affected at once. The side streams are smaller, so they matter more as a cushion than as a replacement.

Look at the same idea inside a stream. If the freelance ₹1,80,000 came from two clients and one of them gave ₹1,40,000, then that client is about 14.6 percent of total income, but 78 percent of the freelance work. Do the share calculation again within a stream when it is a big one.

A high share is not a reason to panic or to leave a good job. It is a reason to know your position. A household with a 90 percent salary share and six months of essential spending saved is in a different place from one with the same share and no savings. The share tells you where to look; the buffer tells you how long you could cope.

Also compare year with year. If freelance work was 10 percent last year and 18.75 percent this year, the dependence on salary is falling, which is useful to know even if the rupee amounts feel small.

Where can SpendixAI help?

When credits come from bank statements, SpendixAI lets you upload them, review rows before saving and categorise each credit. Its Report builder can filter and group, and you can download the result as a CSV to divide in a sheet. Check that each credit is in the right stream before trusting the shares.

What to do with the answer

  • Note your largest share and write the year beside it.
  • Check whether that share rose or fell compared with last year.
  • Ask what would happen to your fixed bills if the largest stream stopped for three months.
  • For tax questions on any stream, confirm the current position with your CA.
SPENDIXAI JOURNAL

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

Explore your reports