How to Budget with Irregular Income in Google Sheets

Quick answer. Standard monthly budgets break for freelancers and seasonal earners because the income side is the wrong shape. The baseline method fixes that: you pay your household a steady monthly amount based on a trailing average of net income, use a separate buffer account to absorb the peaks and dips, and pull a tax cut off every deposit before counting any of it as income. The math fits in a Google Sheet with four tabs.

A monthly budget that assumes a steady paycheck collapses the first time the paycheck stops being steady. For a freelance designer who earns $4,250 one month and $8,000 the next, “spend less than you earn” is not a sentence that means anything in isolation. Earn less than what? This month? The trailing three months? The annual average that doesn’t exist yet?

The CFPB’s Making Ends Meet survey found that small business owners are roughly 30 percentage points more likely than employees to report volatile income, with 16 percent reporting that income “varies a lot” month to month (source). The baseline method is built for that shape.

Why standard monthly budgets fail with irregular income

A standard budget assumes income is roughly the same every month and treats expenses as the variable side. For salaried workers, that maps to reality. For everyone else, the assumption is reversed: expenses are fairly stable (rent, groceries, insurance), and income is the volatile side.

When the model and the reality don’t match, three failure patterns show up:

• Feast-and-famine spending. High-income months feel like found money. Low-income months feel like emergencies. The household oscillates between overspending and panic.
• Tax surprises. Quarterly estimates arrive uncovered because the cash already went somewhere else.
• No savings rhythm. Saving “what’s left” produces $0 most months and a vague guilt the rest of the time.

The baseline method addresses all three by inverting the model: income is treated as fixed (a chosen baseline), and the variability is absorbed by a buffer account that lives outside the household budget.

The baseline method: paying yourself a fixed amount

The mechanic is simple.

1. All freelance or variable income lands in a holding account (often a business checking account).
2. A fixed monthly “salary” transfers from the holding account to the household checking account on the same date every month.
3. The household budgets against that fixed salary like any salaried household.
4. Surplus in the holding account accumulates as buffer. Shortfall draws from the buffer.

The household sees a paycheck. The volatility lives upstream, in a place the household budget doesn’t touch.

Picking the baseline

The baseline is the monthly transfer amount. Common starting points:

The trade-off is comfort versus margin. A baseline at 100 percent of the trailing median feels generous but leaves no cushion. A baseline at 80 percent feels tight but accumulates buffer faster.

For the worked example below, we use the trailing average minus a 15 percent safety margin.

A worked example: six months for a freelance designer

Freelance designer, working from her business checking account. Net income (after tax set-aside, see below) over six months. We’re using a 6-month window here for clarity; the real method uses a 12-month trailing window once you have that history.

Six-month average: $6,290.

Baseline at 85 percent of average: $5,350.

The designer pays herself $5,350 on the 1st of each month, regardless of what came in.

What happens to the holding account over those six months, assuming a starting buffer of $4,200:

Cumulative over six months: net income $37,740, total salary $32,100, buffer change +$5,640.

The household saw $5,350 every month. The actual cash flow looked nothing like that. The buffer absorbed the difference, dipping to $3,100 in March before climbing toward $9,840 by August.

The buffer account: where it lives and how big

The buffer is the engine of the whole method. Without it, the baseline is just a wish.

Where it lives. A separate account, usually a high-yield savings account linked to the business checking. Keeping it in the same account as operating cash defeats the visibility purpose; you cannot tell at a glance whether you are dipping into reserves.

How big it should be. Common sizing ranges from one month to four months of baseline salary, depending on income variability. Highly seasonal earners (tax preparers, summer-camp operators) often hold larger buffers because the trough can last a full quarter or two.

How it fills. Whenever a high-income month puts the holding account above the baseline plus expected near-term expenses, the excess sweeps to the buffer. When the buffer is at its target size, the excess can take a different path - a quarterly distribution, an extra retirement contribution, or accelerated debt payoff.

The tax set-aside

Before any deposit reaches the “net income” column in the spreadsheet, a percent moves to a separate tax savings account. Taxes get paid first, off the top.

Common ranges sit between 25 and 35 percent of each deposit. The right percent depends on the filer’s federal bracket, state tax, self-employment tax, and any deductions or credits. A first-year freelancer with state income tax often lands at the higher end of that range; a low-income year with significant business deductions lands at the lower end. The exact number is a tax-planning question, not a budgeting one. For a worked example of how the federal estimate math runs, see the Quarterly Estimated Tax Spreadsheet.

The mechanic is automation. On every deposit:

1. The chosen percent moves into the tax account.
2. The remainder is what counts as “net income” everywhere downstream in the spreadsheet.

Doing this on every deposit instead of quarterly keeps the money from sitting in the operating account long enough to feel spendable.

The spreadsheet structure

Four tabs cover the whole method in Google Sheets.

Tab 1: Income log

One row per deposit.

Sum the Net column by month to get the monthly net income that feeds the baseline calculation.

Tab 2: Tax savings

One row per tax-savings transfer (matching the Tax set-aside column above) and one row per quarterly estimated payment going out.

Running balance shows whether the set-aside rate is producing enough to cover the estimates.

Tab 3: Buffer

Tracks the holding account against baseline.

Tab 4: Household budget

Operates on the baseline salary as if it were a paycheck. Categories: housing, food, transportation, insurance, savings, discretionary. The household budget doesn’t need to know about the income volatility upstream. That’s the design.

Quarterly review: adjusting the baseline

The trailing window moves. Each quarter (or every month if income is changing fast), recalculate the trailing 12-month average and decide whether the baseline still fits.

Three patterns to look for:

• Buffer growing past target. The baseline may be too low for current income. Options include raising it, or treating the excess as a quarterly distribution.
• Buffer drawing down toward zero. The baseline is too high relative to current income. Lowering it before the buffer runs out is the move most people prefer to making it after.
• Buffer oscillating around target with no drift. The baseline is well-calibrated.

Updating the baseline before a crisis forces it tends to feel easier than waiting until the buffer hits empty.

Off-cycle expenses: annual insurance, quarterly tax, software renewals

The household budget covers monthly expenses. Annual or quarterly expenses (business insurance, software annual renewals, quarterly tax payments, professional dues) don’t fit cleanly in either the household budget or the buffer. Two options:

1. Sinking-fund line in the household budget. Divide the annual cost by 12 and budget that amount monthly. When the bill arrives, the money is already saved.
2. Separate “obligations” account, funded from the holding account. Treat large recurring obligations as upstream of the household salary entirely. This keeps the household budget cleaner but adds an account.

Either works. The mistake is having neither, in which case the annual bill becomes a quarterly buffer drain.

For the freelancer-side cash flow tracking that pairs with this method, see Freelancer Cash Flow Spreadsheet: Monthly Reconciliation in 15 Minutes.

When the baseline method breaks

Three scenarios where this structure struggles:

Extreme front-loading or back-loading. A consultant who earns 80 percent of annual income in two months of the year needs a different rhythm - the buffer would need to be enormous, or the baseline very low. A 6-month or annual smoothing window often works better than 12-month.

A truly new freelancer with under 6 months of history. There’s no trailing window to average. A reasonable starting move is to base the early baseline on a conservative estimate of guaranteed work, treating any overage as buffer until 6 to 12 months of history exist.

A genuine permanent income drop. If income has shifted down structurally (lost largest client, industry contraction), the trailing 12-month window will lag the new reality. Recalculating against the last 3 to 6 months, and rerunning the household budget against the new baseline, brings the model back in line with what’s actually happening.

Templates that fit

• “I want to plan against a steady monthly number with category targets” - The Monthly Budget Template is what you point at the household-budget tab once the baseline is set. Categories, planned versus actual, savings rate.
• “I want to see income, payments, and the buffer in one place” - The Cash Flow Forecast template handles the upstream side: invoiced revenue, payments received, the holding account, and a 12-month projection.

Both templates use the same category structure, so the household side and the business side talk to each other.

Related

• Freelancer Cash Flow Spreadsheet: Monthly Reconciliation in 15 Minutes
• Quarterly Estimated Tax Spreadsheet: Safe Harbor Rule Explained