Freelancer budget spreadsheet for 2027: irregular income

Open your income from the last 6 to 12 months. Leave out one time drops, like a month you were sick or on leave. Your planning number is the lowest normal month that is left.

• If you earned 3,000, 4,200, 3,300, 4,900 and 3,100, your planning number is 3,000.
• If you are new, use the income you can count on from clients who already said yes.
• If you have a retainer, that amount is the floor of your planning number.

Your fixed bills must fit inside this number. Rent, utilities, internet, phone, insurance, loan payments, family support. If they do not fit, that is the first problem to solve, before any spreadsheet.

Every time money lands, move three things before you spend anything:

1. Tax. A fixed percent of every payment, into a separate account. The right percent depends on your country, so check with a local accountant.
2. Savings. A small percent, every payment, even when it feels tiny.
3. Fees. If clients pay through PayPal, Wise, Payoneer or a platform, log what actually arrived, not what the invoice said.

What is left is real money you can plan with.

This is a zero based budget. You take your planning number and split it across your budget lines until nothing is left unassigned. Keep the lines short and plain:

• Bills: rent, utilities, internet, phone, insurance
• Spending: groceries, transport, eating out, personal care
• Work: software, equipment, courses
• Sinking funds: yearly costs saved a little each month
• Debt payments
• Fun

When a line goes over, take the difference from fun first. Never from tax or savings.

Here is the part that makes irregular income feel regular. Any month you earn more than your planning number, the extra goes to a buffer account first.

In a slow month, the buffer tops you back up to your planning number. You pay yourself the same amount every month, even when clients do not pay the same amount.

A good first goal is one month of fixed bills in the buffer. After that, aim for three. Once the buffer is full, extra money from good months can go to goals, debt or investing.

Freelancers get hit by costs that show up once or twice a year: a laptop repair, software renewals, holiday gifts, a yearly insurance bill, a tax payment. These break a monthly budget because they are invisible until they arrive.

List each one with a target amount and a due date. Divide by the months left. That is what you set aside each month. These are called sinking funds, and they turn a surprise into a normal line in your budget.

You can build this in any spreadsheet. A simple layout looks like this:

• Income tab. Date, client, amount, currency, fees, amount received. One row per payment.
• Plan tab. Your planning number, your buffer goal, and what the buffer holds now.
• Budget tab. Your budget lines with plan, spent and left.
• Spending tab. Date, amount, budget line. One row per spend.
• Bills tab. Each monthly bill with a tick box for paid.
• Sinking funds tab. Each yearly cost, its target, due date and monthly amount.
• Year tab. Twelve months side by side, so you can see the slow months coming.

If you are paid in more than one currency, add a column for the rate you actually got and convert to your home currency in the sheet. Budget in what you received, not the rate you saw online.

Pick one day a week. Open the sheet and answer three questions:

1. What came in this week, after fees?
2. What went out, and which lines are close to the limit?
3. What is safe to spend until the next payment?

Then once a month, look at the year tab. If your lowest month is rising, you can raise your planning number. If a client pays late again and again, you know who to follow up with or replace.

• Budgeting on your best month because it felt normal.
• Spending the tax money and hoping a big invoice covers it later.
• Keeping the buffer in the same account you spend from.
• Making 40 categories and quitting in week two.
• Logging the invoice amount instead of what landed after fees.

If you would rather not build it yourself, the Plainsort Budget Tracker is a Google Sheets template made for this exact method. It has an Income Plan tab that plans on your lowest month and fills a buffer from good months, a zero based Budget tab, Bills you tick when paid, Sinking Funds, Goals and a Debts tab with snowball or avalanche payoff. It works in any currency and opens in the Google Sheets app on your phone.

Start with the method above either way. A budget that plans on your slow month is the one that still works in March.

Plan on your lowest normal month and give every dollar of that amount a job. Extra income from good months goes to a buffer first, then to goals. This is a zero based budget built on a safe number instead of a hopeful one.

Start with one month of fixed bills. Once that is full, grow it toward three months. A full buffer lets you pay yourself the same amount even when clients pay late.

It depends on your country and how you are registered. Pick a fixed percent of every payment, keep it in a separate account, and ask a local accountant to confirm the number.

Yes. The Google Sheets app works on iPhone and Android. Setup is easier on a laptop, and daily logging is easy on your phone.