Free Budget Template for Freelancers with Irregular Income (Excel)
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)
Shaded cells are for you to fill in; the totals work themselves out.
| Freelance Budget for Irregular Income | ||||||||
| Your name or business | Year | 2026 | ||||||
| Fill in the shaded cells. Totals, the tax set-aside and your buffer target work themselves out. | ||||||||
| Share of income to set aside for tax | 25% | |||||||
| Buffer target, in months of expenses | 3 | |||||||
| Buffer you have now | ||||||||
| Category | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug |
| Income | ||||||||
| Client payments | ||||||||
| Platform payouts | ||||||||
| Other income | ||||||||
| Total income | auto | auto | auto | auto | auto | auto | auto | auto |
| Set aside for tax | auto | auto | auto | auto | auto | auto | auto | auto |
| Income after the tax set-aside | auto | auto | auto | auto | auto | auto | auto | auto |
How to use the budget template
- 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.
- 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.
- Move the "Set aside for tax" amount to a separate account when the money arrives.
- Read the "Left over" row. A positive month can go toward your buffer. A negative month is what the buffer is for.
- 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
- Free income and expense spreadsheet: record each transaction, then see the totals.
- Freelance Hourly Rate Calculator: the rate you need to reach your take-home goal.
- Quarterly Estimated Tax Calculator: what to pay the IRS each quarter.