Income and work

A monthly income view for three or more sources: what to show

How to lay out a monthly income view for three or more sources: stacked totals, dependable versus uncertain income and one line of notes for each month.

Editorial illustration for A monthly income view for three or more sources: what to show

A good monthly income view shows one column per month, with each income source stacked inside it, dependable sources at the bottom and uncertain ones on top. Add one line of notes under each month saying what was unusual. With three or more sources, this lets you see at a glance how much of the month was solid and how much was a bonus.

What goes into the view?

  • Months across the top, for example April to March.
  • Each source as its own row: salary, rent, freelance, interest and so on.
  • A Dependable subtotal for sources that arrive every month in a similar amount.
  • An Uncertain subtotal for the rest.
  • A Total row and a Notes row.

Decide which source is dependable by looking at the last six months. A source that arrived in all six, in similar amounts, goes in Dependable. Anything else goes in Uncertain, even if it was large.

What does a three-month view look like?

The figures are made up.

SourceJanuaryFebruaryMarch
Salary₹58,000₹58,000₹58,000
Rent received₹14,000₹14,000₹14,000
Dependable subtotal₹72,000₹72,000₹72,000
Freelance₹12,000₹0₹21,000
Total₹84,000₹72,000₹93,000
NoteAdvance for a projectClient delayed paymentTwo projects paid together

January is ₹72,000 plus ₹12,000, which is ₹84,000. February is ₹72,000 plus nothing. March is ₹72,000 plus ₹21,000, which is ₹93,000. The totals jump around, but the dependable line stays flat at ₹72,000, and that is the number your fixed bills should be matched against.

How much of each month was uncertain?

Divide uncertain income by the month's total. January: ₹12,000 divided by ₹84,000 is about 14 percent. February: zero. March: ₹21,000 divided by ₹93,000 is about 23 percent. In a sheet that is =B6/B7 formatted as a percentage, if the uncertain row is 6 and the total row is 7.

A rising share of uncertain income is not bad by itself. It is a signal to check that your savings behave sensibly in the months it disappears.

How should I draw it?

Use a stacked column chart, one column per month. Put the dependable sources at the bottom in a calm colour and uncertain ones above in a different colour. A flat base with a bumpy top tells the story straight away. Avoid a pie chart for this, because it does not show change over time.

If you have many tiny sources, group them under Other and keep the label count to five or six, so the chart stays readable.

What is the one-line note for?

Numbers alone do not tell you why a month was low. A short note such as "client paid in April instead" or "tenant moved out, two weeks vacant" is what you will want to read next year. Write it while you remember the reason.

Where does SpendixAI fit?

If your credits arrive in a bank account, SpendixAI can import the statement, with rows reviewed before saving, and its Report builder can filter and group transactions, with a CSV download for the totals. The Dependable and Uncertain split, and the notes, are decisions you make, so keep them in your own view next to it.

What if a source stops?

Leave its row in the view, with zeros, for at least the rest of the financial year. It shows how long the gap has lasted, and a returning client or tenant slots straight back in. When you remove a row, write the date and reason in the notes, so next year's version of you knows what happened. A view that hides ended sources makes the past look steadier than it was.

Set it up in an evening

  1. List all your sources and the last six months of amounts.
  2. Mark each Dependable or Uncertain.
  3. Fill the month columns, with subtotals and total.
  4. Add the stacked chart and the notes row.
  5. Update it on a fixed day each month, say the 5th.
SPENDIXAI JOURNAL

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

Explore your reports