Plan a monthly household budget, record what actually happened, and see where income or spending moved away from the amounts you expected.
This Excel budgeting workbook is designed for individuals and households that want one structured place for monthly income, expense categories, budget amounts, actual amounts, and the resulting differences. It brings those entries into a summary of total income, total expenses, and net amount, then presents the spending mix and income-versus-expense relationship in a dashboard view.
Compare budget with actual
Review actual and budgeted amounts side by side and use the calculated delta to identify where the month differed from plan.
See spending by category
Organize household costs across practical groups such as daily living, home, transportation, health, insurance, education, pets, subscriptions, and other expenses.
Check the monthly net position
Use the summary totals and dashboard to see whether recorded income exceeds expenses and how the budgeted net compares with the actual result.
What does the template help you analyze?
The workbook focuses on a practical monthly question: what did you expect to earn and spend, what did you actually earn and spend, and which categories explain the difference? Its input layout keeps the planned and recorded figures together so the variance is visible at both line-item and summary level.
Track common income sources, including wages and tips, interest income, profits, endowments received, discounts or reimbursements, transfers from savings, and additional user-entered lines.
Enter actual and budget amounts for household expense categories and review the delta between the two figures.
Monitor category totals for areas such as daily living, transportation, health, insurance, home, children, education, gifts, pets, savings, subscriptions, obligations, business-related costs, and other expenses.
Compare total actual income and expenses with their budgeted counterparts and review the resulting net amount.
Use dashboard charts to understand the overall income-versus-expense relationship and the relative size of expense categories for the month.
What is inside the workbook?
The visible workbook structure separates editable data entry from calculated summaries and visual outputs. The input page uses columns for Actual, Budget, and Delta, while the dashboard consolidates totals and category-level spending into a faster review format.
Monthly data inputs
Enter actual and budget figures for income and detailed expense lines. The workbook provides predefined household categories plus additional lines marked for other items.
Budget-versus-actual calculations
Delta columns show the difference between planned and recorded values, while summary rows aggregate total income, total expenses, and net amounts.
Dashboard outputs
Review total income, total expenses, net amount, an income-versus-expenses chart, and a category breakdown of expenses in one visual summary.
The data-input view places actual and budget amounts next to each other for income and household expense lines, with delta and summary calculations alongside them.
Enter the plan and the month’s actuals in one layout
The input worksheet shows income and expense blocks with dedicated Actual and Budget columns. This makes the workflow straightforward: enter the amount you planned, update the corresponding actual amount as the month progresses, and use the Delta column to see where the difference emerged. Category totals help keep detailed entries connected to the household-level summary.
The dashboard summarizes total income, total expenses, net amount, expense categories, and an income-versus-expenses chart for the recorded month.
Review the monthly result without scanning every input line
The dashboard brings the recorded figures into a compact review view. Total Income, Total Expenses, and Net Amount provide the high-level result, while the category table highlights where money was spent. The income-versus-expenses chart gives a quick visual comparison of inflows and outflows, helping you decide which categories deserve a closer look before planning the next month.
How do you use the template?
Set your monthly budget
Enter expected income and planned spending in the Budget column for the categories that apply to your household.
Record actual amounts
Update the Actual column with income received and expenses incurred so the workbook reflects the month as it develops.
Review the deltas
Check the calculated differences by line item and category, then compare total actual income, expenses, and net amount with budget.
Use the dashboard for the next decision
Review the income-versus-expenses and expense-category views to identify the areas that may need a different allocation in the next monthly plan.
Who is this template for?
This workbook fits individuals, couples, and households that prefer a category-based monthly budgeting process in Excel. It is especially useful when you want to plan recurring household commitments, record variable spending, compare actual results with a monthly budget, and review the net cash position without building a spreadsheet from scratch. It can also support a regular month-end budgeting routine for users who want to refine future allocations based on the differences they observe.
If you want a broader household-planning format, explore the Household Budget Templates for Excel. For a more general budgeting workbook that can be applied beyond household spending, the Budget Template Excel provides another structured option.
Choosing a selection results in a full page refresh.
