Free Budget Template for Freelancers with Irregular Income (Excel)

By the JAJPO team · How we build our tools

A free budget template for freelancers whose income changes from month to month. Enter what comes in and what goes out; the sheet works out how much to set aside for tax, what's left over each month, and how big a buffer you need to cover the lean months.

Free template

Free Freelance Budget Template (Excel)

Excel file (.xlsx) · opens in Excel, Google Sheets, Apple Numbers and LibreOffice · 2 sheets · formulas included

Shaded cells are for you to fill in; the totals work themselves out.

Preview: the Budget sheet
Preview of the Budget sheet
Freelance Budget for Irregular Income
Your name or businessYear2026
Fill in the shaded cells. Totals, the tax set-aside and your buffer target work themselves out.
Share of income to set aside for tax25%
Buffer target, in months of expenses3
Buffer you have now
CategoryJanFebMarAprMayJunJulAug
Income
Client payments
Platform payouts
Other income
Total incomeautoautoautoautoautoautoautoauto
Set aside for taxautoautoautoautoautoautoautoauto
Income after the tax set-asideautoautoautoautoautoautoautoauto

How to use the budget template

  1. Download it and set three numbers at the top: the share of income you set aside for tax, how many months of expenses you want as a buffer, and the buffer you have now.
  2. Each month, enter your income and expenses in the shaded cells. Use real figures for months that have passed and your best estimate for the months ahead.
  3. Move the "Set aside for tax" amount to a separate account when the money arrives.
  4. Read the "Left over" row. A positive month can go toward your buffer. A negative month is what the buffer is for.
  5. Check the buffer section for your average month, your target and how much you still need to save.

Budgeting when your income isn't steady

A normal budget assumes the same paycheck every month. Freelance income doesn't work that way: a strong month can be followed by a slow one, and tax hasn't been taken out of any of it. Three habits make it manageable:

  • Take the tax out first. Treat the set-aside as money that was never yours to spend.
  • Plan from an average or a low month, not from your best one.
  • Build a buffer of a few months of expenses, and refill it in good months.

What's in the template

  • Three income lines, five business expense lines and eight personal expense lines, with twelve monthly columns and a total for the year.
  • A tax set-aside row that takes your chosen share of each month's income.
  • A "Left over" row for each month, after tax, business costs and personal costs.
  • A buffer section: average monthly income and expenses for the months you've filled in, your buffer target and what's still to save.
  • Frozen headings, so the categories and months stay in view.

What share should you set aside for tax?

The sheet starts at 25%, which is only a placeholder. The right share depends on your profit, your filing status, your other income and your state. Work out your own with the free 1099 Tax Calculator, then type it into the shaded cell. If you also have a job, the W-4 Side Income Calculator may be a better fit.

Frequently asked questions

Does it work in Google Sheets?

The template is an Excel file with ordinary formulas, which Google Sheets and other spreadsheet programs can open.

Is this a tax calculation?

No. The tax row applies the share you choose to your income. It's a planning figure to help you keep money back, not an estimate of what you'll owe.

How big should my buffer be?

That's a personal choice. The sheet starts at three months of expenses and lets you change it. The more your income swings, the more months you may want.

Is the template really free?

Yes. We ask for your email so we can send you tax-deadline reminders and new templates; you can unsubscribe at any time.

Related