A monthly budget is easiest to maintain when planning and tracking live on the same page. This simple personal budget template is built around a projected versus actual layout so each category can be planned early, updated as the month runs, and reviewed with real numbers at closeout. Instead of turning budgeting into a long worksheet process, it keeps the work focused on comparing expectations to outcomes and spotting the categories that need attention next month.
This budget template is designed to review income, spending, and month-level totals in a consistent way. The income and expense sections feed into a cash flow summary, and the chart mirrors those totals so changes stand out during quick check-ins.
How to Use This Simple Personal Budget Template
A good way to use this budget is to treat it like a monthly cycle. Start by setting realistic projections, update actuals as amounts become final, then review the differences at the end of the month to decide what should change next time. The template already separates planning from tracking, so the main job is keeping entries consistent.
Set the Month and Year
Update the “Month” and “Year” fields at the top so the sheet reflects the period you are budgeting for. If you want to keep a history, duplicate the tab and rename it with the month and year before entering new numbers.
Plan Monthly Income
In “Monthly Income,” enter expected income in the Projected column. Use the Actual column for what is received. The Difference column shows the gap between the plan and the result, line by line and for the total.
If income varies, keep the projected side conservative and only raise it when payments are genuinely expected. This keeps the variance meaningful instead of constantly chasing optimistic estimates.
Plan Monthly Expenses
In “Monthly Expense,” enter projected amounts for each category, then record actual spending as the month progresses. Fixed bills can stay steady, while variable categories can be adjusted during the month if priorities change.
Decide what “actual” means for your budget and keep it consistent. Some budgets record spending on the purchase date. Others record spending when an account is paid. Consistency matters more than the method.
Update Actuals Without Turning It Into a Daily Task
This template does not require daily entry. A simple rhythm is to update actuals weekly, then do a final update near month-end when most charges have posted. If a category has multiple transactions, it is fine to enter the running total in the Actual column rather than itemizing every purchase.
Review Cash Flow Totals and Differences
The “Cash Flow” summary compares projected and actual totals for Total Income, Total Expenses, and Total Cash. In this template, Total Cash reflects the combined volume of income and expenses for the month. This can be useful when reviewing overall money movement, even when net remaining is tracked elsewhere.
If you want a month-end net figure inside this sheet, add a new line in the cash flow area for Net Cash and calculate income minus expenses. That gives a clear surplus or deficit number without changing the rest of the layout.
Use the Chart for a Fast Monthly Read
The chart is tied to the cash flow totals, so it updates as you fill in projected and actual amounts. It is most useful during quick reviews when you want a visual comparison between what was planned and what happened.
Customize Categories and Add Rows
Category labels can be renamed to match your real life. If you need more lines, insert a row within the income or expense list, above the total row, then copy the Difference formula into the new row so projected versus actual stays consistent.
If you extend the list beyond the current range, confirm the total formulas include the new rows. A quick check is to compare the total with a manual sum of a few visible rows to confirm nothing is excluded.
Close Out the Month and Prepare the Next One
At the end of the month, review the biggest differences first. Decide whether the projection was unrealistic, whether spending changed unexpectedly, or whether the category name needs to be split into something more specific. Then duplicate the tab for the next month and update the projections using what the last month showed.
FAQs
This template is designed for monthly totals per category. If a category has multiple transactions, combine them into one running total in the Actual column. If you prefer transaction-level tracking, keep a separate log and use this sheet for the monthly roll-up.
Difference is calculated as projected minus actual. For expenses, a negative value means spending ended higher than planned. For income, a negative value means income ended higher than planned. Positive values mean the actual amount came in lower than projected.
Two common methods work well. Spread the annual cost across months by budgeting a smaller amount every month, or record the full amount in the month it is paid. Spreading is better for steady planning. Recording full cost is better for cash-timing accuracy.
Use a baseline projection that reflects income you can reasonably expect. Keep extra income separate, either by adding a dedicated income line or by updating projections only when work is confirmed. This makes the projected side a planning number rather than a hopeful one.
Yes. Add separate income lines for each earner, then agree on how shared spending will be recorded. Some households track totals only, while others add notes in category names to show who paid. The key is using one approach every month so comparisons stay meaningful.
