Income and work

Find your slow months: a seasonality view of freelance income

Chart a full year of freelance income by month, spot your slow months and pre-fund them with a steady monthly set-aside. Worked example with figures.

Editorial illustration for Find your slow months: a seasonality view of freelance income

To find your slow months, list twelve months of income received, April to March, chart it as columns, and mark the months that fall well below your monthly floor. Then work out how much the slow months fall short in total and divide that across your stronger months as a monthly set-aside. One chart and one division are enough.

How do I build the view?

  1. Make two columns: month in A, income received in B, starting with April and ending with March to match the financial year.
  2. Include only money that reached your account, dated by when it arrived and not by when you invoiced.
  3. Select both columns and insert a column chart. Excel and Google Sheets both do this from the Insert menu.
  4. Add a horizontal line for your floor, the amount you need each month, as a second series.
  5. Add a column for each month's share of the year: =B2/SUM($B$2:$B$13), formatted as a percentage.

What does a year look like?

Hypothetical income in thousands of rupees, April to March: 48, 40, 36, 30, 34, 52, 60, 58, 44, 56, 62, 70. The yearly total is ₹5,90,000, so the monthly average is about ₹49,167. Say your floor is ₹42,000.

MonthIncome (₹)Against ₹42,000 floor (₹)
April48,0006,000 above
May40,0002,000 short
June36,0006,000 short
July30,00012,000 short
August34,0008,000 short
September52,00010,000 above
October60,00018,000 above
November58,00016,000 above
December44,0002,000 above
January56,00014,000 above
February62,00020,000 above
March70,00028,000 above

How much should I set aside each month?

The four short months, May to August, miss the floor by 2,000 plus 6,000 plus 12,000 plus 8,000, which is ₹28,000. The other eight months exceed it by far more, ₹1,14,000 in total. To cover the slow patch, set aside 28,000 divided by 8, or ₹3,500, from each month that clears the floor. That money sits in a separate account labelled slow months.

The cushion grows gradually. After four good months at ₹3,500 each it holds ₹14,000, so in your first year a slow month that arrives early may only be half covered. Start the set-aside as soon as you have the chart, not when the slow season nears.

Use a separate account for it, so the money is not spent by accident on a good month. It does not need to earn anything special. It only needs to be somewhere you will not dip into casually.

This is deliberately modest. If you would prefer a margin of safety, aim for one and a half times the shortfall, which is ₹42,000 in this case.

Is one year of data enough?

It is a start, not proof. One late payment can move a month's income into the next. If you have two or three years of statements, line the same month up across years. A month that is low every year is a season. A month that is low once may be a client.

What can I do about slow months besides saving?

  • Move a large annual expense, such as an insurance premium, out of the slow months where possible.
  • Schedule your own marketing, outreach and skill-building for those weeks, so quiet time is used well.
  • Ask regular clients whether any planned work can start earlier or later.
  • Keep two or three small, quick services you can sell in a hurry.

If you are not tracking yet, SpendixAI can import your statements and group credits by month, so the chart is a few minutes of work instead of an evening.

Before you close the sheet

  1. Twelve months entered, April to March.
  2. Floor line added to the chart.
  3. Slow months marked and the shortfall totalled.
  4. Monthly set-aside decided and a separate account chosen.
SPENDIXAI JOURNAL

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

Explore your reports