A personal budget spreadsheet is a simple file that compares the money you plan to spend with the money you actually spend, category by category, month by month. Here is what to include, a worked example, and a free template that already has it all set up.
By Abdallah Elsied, creator of the Irregular Income Budget Bundle · Last updated October 2026 · Screenshots are from the real spreadsheets · How we write
Income: every source, by date. Net (after tax) is easiest to budget with.
Fixed costs: rent or mortgage, insurance, phone, subscriptions, minimum debt payments.
Variable costs: groceries, fuel, dining out, shopping.
Savings: emergency fund, retirement, sinking funds for big future costs.
Debt payoff: what you pay on each debt.
Left over: income minus spending, by month and for the year.
Here is January from the template's demo file, rounded to whole dollars:
Rent: planned 1,450, spent 1,450
Groceries: planned 520, spent 455
Transportation: planned 180, spent 142
Dining out: planned 150, spent 122
Savings (sinking funds + emergency + retirement): planned 600, spent 600
Reading it takes ten seconds: essentials are on plan, food and transport came in under, savings happened. The spreadsheet does the adding; you just look.
Keep categories under 25. More than that and you stop logging.
Log weekly at minimum. Receipts pile up fast.
Budget savings like a bill. Put them near the top of the plan, not "whatever is left".
Review once a month and change the plan to match reality.
Share your Google Sheets copy with your partner as an editor. You both log into the same file, and the dashboard shows the household picture. Agree on categories first; that is where most arguments start.
Want this ready-made? the Free Monthly Budget Template does all of this for you in Google Sheets or Excel. It is free (type 0 in the price box), and you can preview it in Google Sheets first.
Budget plan: 21 ready categories in four groups (Essential, Lifestyle, Savings, Debt). Rename or add your own.
Expense tracker: date, category dropdown, description, amount and payment method.
Income log: one row per payment, from any source.
Monthly summary: income, spending, plan vs. actual and money left over for all 12 months.
Dashboard: income and spending this year, money left over, what is left to spend this month, two charts and quick checks.
Two files: a blank template and a demo file filled with a year of sample data.
Download the free budget template →
Free template: a complete monthly budget. Best if your paycheck is the same every month. Get it free.
Irregular Income Budget Bundle ($9): everything in the free template plus steady salary, buffer, taxes, pending invoices, bills, sinking funds and debt payoff. Best for freelancers and anyone with changing income. See the full bundle.
Your rows copy straight across, so you can start free and upgrade later without retyping anything.
Next: Expense Tracker Google Sheets and Budget vs Actual Spreadsheet.
Income, fixed costs, variable costs, savings, debt payments and what is left over, by month.
A spreadsheet is free, private and fully yours to change. Apps are faster at importing bank data. Many people prefer a spreadsheet because logging by hand makes them notice spending.
Log every few days and review once a week. Do a full review at month end.
Yes. Type 0 in the price box.
Download the free budget template (Google Sheets + Excel) →
Get the Irregular Income Budget Bundle ($9) →
About this page: written by Abdallah Elsied, who makes the Free Monthly Budget Template (free) and the Irregular Income Budget Bundle ($9), both linked on this page. Last updated October 2026. This is general budgeting information, not financial, tax or legal advice.