Budget on Variable Income Using Past Statements

To budget on variable income, total the deposits on twelve months of past bank statements, find your lowest month, and build a base budget that fits inside that low figure. Essentials and minimum payments go in the base. In better months, money above the base goes to a buffer, savings and goals in a fixed order you set in advance.

How many months of statements does a variable income budget need?

Twelve months of statements is the right amount for most variable income budgets. A full year captures seasonal swings: the slow January for a retail worker, the quiet summer for a tutor, the end-of-year rush for a contractor. Three or six months can miss the worst month entirely and leave you planning on a figure that is too high.

Why a full year matters depends on the work:

• Seasonal trades such as landscaping, tourism or tax preparation earn most of their income in a few months. Six months of statements may show only the good half.
• Gig and delivery work varies with the week more than the season. Twelve months smooth out the odd strong or weak week.
• Commission and bonus pay may arrive quarterly or yearly. A short window either includes the bonus, inflating the average, or misses it.

Two years of statements give a steadier picture if your work has not changed in that time. If it changed recently, for example after a new contract or a move from employment to freelancing, use only the months since the change, even if there are fewer than twelve, and treat the result as provisional.

Statements are the right source because they show money that arrived, after any taxes or fees were taken out. Invoices and pay stubs show what you were owed. The two can differ by weeks or by the amount a client never paid.

Finding your low month in past deposit rows

Your low month is the calendar month with the smallest total of real income deposits across the statements you gathered. Add up the income rows for each month separately, list the twelve totals, and take the smallest. That figure, not the average, is the anchor for the whole variable income budget.

The average is tempting because it is a bigger number. Planning on it means spending as if every month were typical, and about half of them are not. A month below the average leaves a gap, and the gap usually lands on a bill.

To get the totals in a spreadsheet:

1. Paste every statement's rows into one sheet, with date, description and amount columns.
2. Add a column that marks each deposit as income or not income. The last section covers what to exclude.
3. Add a month column with =TEXT(A2,"yyyy-mm").
4. Total income per month with SUMIFS, or with a pivot table using month as the row and amount as the value.

If the lowest month was a true one-off, such as a month off for surgery that will not recur, look at the second-lowest as well. Be honest about it, though. A slow month that "will not happen again" tends to happen again in a different form.

Setting a base budget on the low-month income figure

A base budget is the set of costs you must cover every month whatever you earn: housing, utilities, food, transport, insurance and minimum debt payments. It must fit inside your low-month income. If it does, a bad month is uncomfortable but survivable. If it does not, the gap is the first problem to solve.

Build the base from your statements too. Pull the same twelve months of spending, total each essential category, and divide by twelve. That catches bills that are not monthly, such as quarterly water or a yearly insurance premium.

Compare the base with the low month:

• Base below the low month. The difference is room for flexible spending even in a bad month. Keep it modest.
• Base roughly equal to the low month. Workable, but there is no slack. A buffer account, covered below, becomes essential.
• Base above the low month. Something must change: a cheaper essential, a second income source, or a buffer large enough to cover the shortfall in slow months.

Flexible spending sits outside the base. Eating out, hobbies, clothes beyond the basics and travel are paid only from money that has already arrived above the base. That separation is what makes the method hold up when income drops.

If you share costs with a partner, each person's income may vary differently. A budget for couples spreadsheet with joint and separate accounts shows how to split shared categories, and the same low-month idea applies to each income.

Worked example: twelve months of uneven deposits

This example uses made-up deposit totals for a freelance designer over twelve months. The figures are illustrations, chosen to show how far the low month can sit below the average. They also show how the base budget and the surplus fall out of the low figure once you have both totals.

The average is $3,733 a month. The low month is January, at $2,350, which is $1,383 below the average. Planning on the average would have left January short by that amount.

Suppose the designer's essential spending from the same statements averages $2,200 a month: $1,150 rent, $420 groceries, $180 utilities and phone, $210 transport, $240 health insurance. That base fits inside January with $150 to spare.

Next, the designer sets aside part of every deposit for income tax, since freelance pay arrives without tax withheld. The amount depends on their situation, so take advice for your own figure. Whatever it is, subtract it from each month's deposits before comparing with the base.

Across the year, after the base, there was $18,400 above it ($44,800 minus 12 × $2,200), before tax. That is the money the surplus plan in the next section divides up.

What do you do with income above the base budget in a good month?

Income above the base goes into a short, ordered list of jobs that you decide before the good month arrives. A typical order is: tax set-aside, refill the buffer, emergency savings, then goals and flexible spending. Each job takes money only after the one above it is full.

Deciding the order in advance matters because a good month feels like permission. A $5,400 November is easy to spend on things that would never pass in March. A written order turns the surplus into a rule rather than a mood.

A sample order, with example targets:

1. Tax set-aside, a fixed percentage of every deposit, moved to a separate account.
2. Buffer refill, until the holding account holds one month of base budget.
3. Emergency fund, until it reaches your target. Working that target out from your own essential spending is covered in how much emergency fund you need, based on your statements.
4. Known future bills, such as a laptop replacement or annual software.
5. Flexible spending and goals, split however you like.

Write the split as percentages in your sheet. For example, after tax and with the buffer full, 50% to the emergency fund, 20% to future bills and 30% to spending. A formula then shows each month exactly how much each job gets.

The holding account that smooths a variable income budget

A holding account, sometimes called a buffer, is a separate account that receives all your income. Once a month you pay yourself a fixed amount from it into checking, equal to your base budget plus a little flexible spending. Your checking account then behaves as if you had a steady salary, even when deposits do not.

The holding account absorbs the swings. A $5,400 month leaves money in it, and a $2,350 month draws money down. Over the year the balance moves up and down, but your monthly pay to yourself stays the same.

Setting it up from the example:

• Target balance: one or two months of base budget, here $2,200 to $4,400.
• Monthly transfer to checking: $2,350, the low-month figure. That covers the $2,200 base and a small flexible amount.
• Rule for raises: if the holding account stays above two months of base for a full quarter, raise the monthly transfer a little.

Building the first month of buffer takes time. Until it exists, run the plan month to month, spending only from money that has arrived, and send every dollar above the base into the holding account until the target is reached.

Your bank statements will show the transfers as round amounts on a fixed date, which makes later reviews simple: the holding account statement shows income in, the checking statement shows a single steady deposit.

Variable income edge case: deposits that are not income

Not every deposit row on a statement is income, and counting the wrong ones makes your low month look better than it was. Transfers from savings, refunds, money from friends, loan proceeds and client reimbursements for expenses you paid all appear as deposits. Leave them out of the income totals.

The usual suspects, and how to spot them:

• Transfers between your own accounts. Descriptions such as "TRANSFER FROM SAV" or "ONLINE TRANSFER" with your own name.
• Refunds and chargebacks. The merchant's name appears as a deposit, often matching an earlier purchase.
• Expense reimbursements. A client pays back $300 of materials. That cancels a cost; it is not earnings.
• Platform payouts that bundle tips, fees and refunds. Use the platform's own report to split them if the amounts are large.
• Loans, credit card cash advances and gifts. These are real money, but they are not income you can count on.

Mark each one in the income column of your sheet so the SUMIFS ignores it. Recheck the low month after you do, because removing a single large transfer can move it.

Gathering twelve months of statements is the slow part when your bank only offers PDFs. CheapBankConvert, in early access, converts each statement to rows for a one-time price, and the 2-page free preview lets you check one before paying. Payment methods for this kind of service are compared in paying for a PDF converter with PayPal or a card. Get started to hear when it opens.