Freelancers, seasonal workers, and anyone paid by commission know the problem: a great month followed by a thin one. A standard budget assumes the same paycheck every time, and that is exactly what you do not have. Here is a simple spreadsheet method, borrowed from a Portland, Oregon office administrator who builds budgets for friends with uneven pay.
Start from the lowest month
Look at the last six to twelve months of deposits and find the lowest monthly total. That number is your baseline. Build the core budget, the one covering rent, utilities, groceries, insurance, and minimum payments, so that it fits inside it. If even your lowest month cannot cover the essentials, that tells you something important about where to trim first.
Anything you earn above the baseline is surplus. It does not go to spending by default; it follows a set of rules written in advance.
The buffer jar
Open a separate savings pot, or keep a jar if you prefer cash, and call it the buffer. In a good month, the surplus goes into the buffer first, up to a limit equal to one month of essential costs. Once the buffer is full, split further surplus between savings goals and a small amount for wants.
In a thin month, draw from the buffer to bring your income up to the baseline, and write down how much you took. This is what smooths out the swings.
A weekly sheet with four columns
- Date: every deposit, with the source.
- Amount: what hit your account.
- Month total: a running sum using a SUM formula.
- Gap to baseline: month total minus baseline, which turns negative when you are behind.
Update the sheet once a week, on a fixed day, which takes about five minutes. The Gap column shows whether you are on pace, so you can adjust the variable spending before the month ends.
Do not forget taxes
If you are self-employed, taxes are not withheld automatically. Set aside a fixed percentage of every deposit in another pot as soon as it arrives. The percentage depends on your situation, so check with a tax professional, and look at the guidance for estimated payments published by the IRS at irs.gov and, for Oregon residents, by the Oregon Department of Revenue.
Next steps
Once the sheet is running, review it at the end of each quarter and raise the baseline if your lowest month has improved. For ideas on tracking sinking funds beside it, see the Bills and home section.







