Size your buffer from your own history: find the three leanest income months of the last twelve, work out how far each fell short of your essential spending, add the shortfalls, then add one more month of essentials for a late-paying client. That gives a number tied to how your income really behaves, which a rule of thumb cannot do.
What do I need before I start?
- Twelve months of money received, month by month, from your freelance account or invoices.
- Your essential monthly spending: rent, food, utilities, EMIs, insurance, transport, and anything you cannot skip.
- A notion of which months were genuinely lean, not months when a client simply paid late.
If you have fewer than twelve months of history, use what you have and lean towards a larger buffer.
A worked example with made-up months
Say essentials are ₹38,000 a month, and your last twelve months brought in these amounts (in rupees).
| Month | Income | Month | Income |
|---|---|---|---|
| April | ₹62,000 | October | ₹40,000 |
| May | ₹48,000 | November | ₹20,000 |
| June | ₹30,000 | December | ₹65,000 |
| July | ₹15,000 | January | ₹52,000 |
| August | ₹55,000 | February | ₹18,000 |
| September | ₹70,000 | March | ₹58,000 |
The three leanest are July (₹15,000), February (₹18,000) and November (₹20,000). Compare each with the ₹38,000 of essentials.
- July: 38,000 minus 15,000 is a shortfall of ₹23,000.
- February: 38,000 minus 18,000 is ₹20,000.
- November: 38,000 minus 20,000 is ₹18,000.
- Total shortfall: ₹61,000.
How do I turn that into a buffer size?
Add a cushion for the month a client pays late. Say that is one month of essentials, ₹38,000. The buffer target is ₹61,000 plus ₹38,000, which is ₹99,000. That is about 2.6 months of essentials (99,000 divided by 38,000). Rounding up to ₹1,00,000 gives you a clean target.
In a sheet, put the twelve incomes in B2:B13 and essentials in E1. The sum of your three smallest months is =SUMPRODUCT(SMALL(B2:B13,{1,2,3})), which is ₹53,000 here. The shortfall is =3*E1-SUMPRODUCT(SMALL(B2:B13,{1,2,3})), which gives ₹61,000. Add E1 for the cushion. This works in Excel and Google Sheets.
Why not just use a rule of thumb?
Rules such as a fixed number of months are easy to remember but ignore your pattern. A freelancer with smooth income and two big clients needs a different buffer from one with seasonal swings. Your own lean months show your actual exposure. If your leanest month is still above essentials, the formula gives a small number, and that is a good sign, not a mistake.
How do I build it and keep it honest?
- Open a separate account and name it clearly, so you do not see it daily.
- Fill it from every client payment until it reaches the target, instead of waiting for a good month.
- Draw from it only for the gap between income and essentials, and log each draw with the month it covers.
- Rework the number each April, using the new twelve months.
When typing twelve monthly totals into a sheet becomes a chore, SpendixAI can import your statements and give monthly category totals, which you can download as CSV for the same exercise.
Does it matter if I have dependants?
It does, in the essentials figure. Count the household costs you would still have to pay in a poor month, including family support, school fees paid termly and insurance premiums that fall due once a year. Spread annual premiums across twelve months in the essentials list, otherwise the lean-month shortfall looks smaller than it will feel when the premium arrives.
A closing checklist
- List essentials and total them.
- Find the three leanest of the last twelve months.
- Add each shortfall, then one cushion month.
- Round the target and open the account.
- Recalculate every April.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


