Bring household income, day-to-day spending, and cash balances into one structured monthly view so you can see where money is coming from, where it is going, and how each month changes your available cash.
This personal budgeting spreadsheet is designed for individuals and households that want a clearer record of actual finances across the year. Enter cash receipts and payments by category, along with opening cash, and use the workbook totals and dashboard to review monthly activity, year-to-date (YTD) results, net cash movement, and closing cash.
See the monthly cash picture
Compare cash received with cash paid and identify months in which spending absorbs more or less of the household cash coming in.
Understand spending by category
Separate multiple expense lines instead of relying on one total, making it easier to see which payment categories account for the largest share of outflows.
Track the cash balance
Follow opening cash, net cash movement, and closing cash so the budget review stays connected to the amount of cash carried from one month to the next.
What does the household budget help you analyze?
The workbook focuses on the basic cash questions behind personal budgeting: how much came in, how much went out, what drove those movements, and what remained after the month closed. Its monthly structure also lets you review activity across a full January-to-December layout rather than looking at isolated transactions.
Record several income streams as cash receipts and summarize them into monthly and annual totals.
Organize household spending across multiple cash-payment categories and compare those categories over time.
Calculate monthly net cash movement from total receipts and total payments.
Carry the cash position through opening and closing balances for each month.
Review a selected reporting month alongside YTD cash receipts, payments, net cash movement, and closing cash.
What is inside the workbook?
The verified workbook views show two complementary parts of the budgeting workflow. An actual-figures table provides the detailed monthly entry and summary layout, while the dashboard converts those figures into headline cash metrics and category charts. Together, they let you move from the underlying household numbers to a more visual review of cash performance.
Actual figures
A January-to-December table separates cash receipts from cash payments, with individual income and expense lines plus monthly and full-year totals.
Cash roll-forward
The cash section shows opening cash, net cash movement, and closing cash by month, keeping spending decisions tied to the resulting balance.
Dashboard outputs
A reporting-month dashboard presents cash receipts, cash payments, net cash movement, closing cash, YTD figures, and visual breakdowns of inflows and outflows.
The actual-figures view lays out income lines, expense lines, monthly totals, and the opening-to-closing cash roll-forward across the year.
Enter and review actual household figures
The detailed table is the working layer behind the summary. It separates cash receipts and cash payments into distinct rows, then shows totals for each month and for the year. The cash section below connects those totals to the household balance, making it possible to see how each month's net movement affects closing cash.
The dashboard summarizes the selected reporting month, YTD totals, receipt and payment category charts, and the month-by-month cash movement trend.
Read the monthly dashboard at a glance
The dashboard turns the underlying figures into a compact review. Headline cards show receipts, payments, net cash movement, and closing cash for the reporting month, with YTD figures where shown. Stacked charts break down income and expense categories by month, while the cash-movement chart places receipts and payments alongside the cash balance trend.
How do you use the template?
Set up your cash categories
Use the available income and expense lines to represent the household cash receipts and payments you want to monitor.
Enter monthly actual figures
Record receipts and payments in the corresponding month and include the opening cash balance used for the cash roll-forward.
Review totals and cash movement
Check monthly receipt and payment totals, net cash movement, and the resulting closing cash balance before moving to the dashboard view.
Use the dashboard for decisions
Select the relevant reporting month and review the headline figures and category charts to identify changes in income, spending, and available cash.
Who is this template for?
This template is suited to individuals, couples, and households that want a structured Excel-based record of actual income, expenses, and cash balances. It is particularly useful when several income sources or spending categories make a simple bank-balance check insufficient, or when you want to review household cash patterns month by month and across the year.
If your priority is explicitly comparing planned spending with actual spending by category, the Home Budget provides a budget-versus-actual household workflow. For a more detailed cash-flow variance process built around forecast and actual figures, consider the Budget vs Actual Cash Flow Analysis.
Choosing a selection results in a full page refresh.
