A budget spreadsheet with rollover carries an unspent category balance into the next month. In Excel for Microsoft 365, calculate each month’s ending balance as the amount available minus actual spending, then use that ending balance as the next month’s starting carryover.
What rollover means in a budget
Rollover is a way to let a budget category keep its unused balance instead of resetting to zero at the start of every month. If you set aside $300 for clothing and spend $220, a full-rollover budget starts the next month with $80 already available. If you then add another $300 for the new month, the category has $380 available.
This is different from carrying cash in a bank account: a spreadsheet records a plan, not money held in a separate account. Your actual bank balance may be higher or lower because of other income, bills, transfers, or timing. The spreadsheet is useful for tracking how much of your planned category allowance remains, but it does not move funds for you.
Rollover can also apply to a negative balance. If you spend $40 more than the category had available, carrying the full balance forward means next month begins $40 behind. The next month’s new allowance first offsets that overspend. Whether to carry positive balances, negative balances, or both is a budgeting rule to choose deliberately.
Set up a simple monthly layout
A practical worksheet uses one row per category and a group of columns for each month. For example, put category names in column A and the monthly planned amount in column B. For January, use columns C through F for actual spending, opening carryover, total available, and ending balance. For February, use G through J for actual spending, opening carryover, total available, and ending balance.
Make the headings explicit, such as “January spent” and “January ending.” This reduces the chance of confusing the amount budgeted with the amount actually spent. Enter zero as the first month’s opening carryover unless you are intentionally bringing in a balance from an earlier period. Keep planned amounts, carryovers, and spending in separate cells so each figure can be checked.
Categories should be specific enough to guide decisions but not so detailed that every purchase needs a new row. A household might use groceries, transport, utilities, clothing, dining out, and savings. For categories with very different purposes, such as rent and entertainment, separate rows make it easier to see which plan needs adjustment.
Calculate available money and ending balances
Assume the example layout above has the monthly planned amount in B2, January spending in C2, January opening carryover in D2, January total available in E2, and January ending balance in F2. With a $300 plan and a $0 opening carryover, calculate January’s available amount using =B2+D2. The result is $300.
With January spending in C2 and the available amount in E2, calculate the ending balance in F2 using =E2-C2. If C2 is $220, the result is $80. A positive number means money remains in the category under the plan; a negative number means spending exceeded the amount available.
For February, assume G2 is February spending, H2 is February opening carryover, I2 is February total available, and J2 is February ending balance. In H2, link the opening carryover to the previous month’s ending balance using =F2. With F2 at $80, February starts with $80 carried forward. If the planned amount in B2 remains $300, calculate February available in I2 with =B2+H2; the result is $380. If February spending in G2 is $350, calculate the ending balance in J2 with =I2-G2; the result is $30.
Copy the same pattern across later months: each new month’s opening carryover refers to the previous month’s ending balance. If the planned amount changes from month to month, use a separate planned-amount cell for each month rather than reusing B2. Check that the formulas point to the intended row and prior-month column when you copy them.
Bring spending in from a transaction list
Typing each monthly total by hand is simple, but it can be hard to audit. A transaction list makes it possible to record individual purchases and calculate a category’s monthly spending. Use columns A through C for transaction date, category, and expense amount, and put category names in a monthly summary starting at A2. Put the first day of the month, such as January 1, 2026, in B1.
With transaction dates in A2:A500, transaction categories in B2:B500, positive expense amounts in C2:C500, the category name in A2, and the month’s start date in B1, calculate the total for that category and month using =SUMIFS($C$2:$C$500,$B$2:$B$500,$A2,$A$2:$A$500,">="&B$1,$A$2:$A$500,"<"&EDATE(B$1,1)). If the matching transactions total $425 during January, the formula returns $425. The start-date condition includes January 1 and later; the next-month condition excludes February 1, so the formula works for months of different lengths.
Enter expenses consistently as positive amounts if the formula is summing spending. Use the same category spelling in the transaction list and summary, or create a category dropdown to reduce typing differences. Excel’s Data Validation tools can make a list dropdown; on Windows, find them under Data > Data Validation. A carefully maintained transaction list makes the totals easier to trace when a month looks unexpectedly high.
Choose a rollover rule that fits the category
Full rollover is often useful for irregular expenses. A car repair fund, clothing budget, annual subscription, or holiday category may need several months of contributions before the expense arrives. Carrying the balance forward shows the category’s accumulated amount rather than treating each month as an isolated allowance.
Not every category needs the same rule. You might carry positive balances forward for travel or home maintenance, while treating a monthly dining-out allowance as a fresh limit. Some people also choose not to roll a positive balance in a category where the monthly plan is meant to be spent regularly. The spreadsheet should reflect the rule you actually intend to follow, not assume every category behaves alike.
If overspending should not reduce next month’s allowance, a positive-only carryover can be used. With the prior month’s ending balance in F2, set the next month’s opening carryover in H2 to =MAX(0,F2). If F2 is $80, the formula returns $80; if F2 is -$40, it returns $0. This intentionally drops the overspend from the carryover calculation, so it can make a category look more comfortable than your actual spending pattern. Record or address the overspend separately if you use this rule.
Another option is to carry over only a chosen amount, such as a category cap. That requires defining what happens to any excess; it could be assigned to savings or another category in your plan. Be consistent from month to month and label any cap clearly so it is not mistaken for a formula error.
Review the budget at month-end
A useful month-end routine is to reconcile the transactions first, then review the category balances. Check that each purchase is included once, refunds are treated consistently, and the month’s dates are correct. A purchase made on the final day of a month can land in a different period if its date is entered incorrectly, which changes both that month’s ending balance and the next month’s carryover.
- Enter or import the month’s transactions and correct category labels.
- Compare spreadsheet totals with the records you use to track actual spending.
- Review categories with unusually large positive or negative balances.
- Decide whether the next month’s planned amounts or rollover rules need a deliberate change.
- Keep a dated copy or save a version before changing the structure or formulas.
Do not change a past ending balance merely to make the current month appear balanced. If you find an error, correct the transaction or explain an adjustment in a notes column. An unexplained manual override makes future balances harder to verify.
Common spreadsheet problems
A frequent mistake is treating the carryover as new income. It is not additional income; it is the previous period’s unspent planned amount. The amount available can include both the new monthly plan and the carried balance, but a separate income summary should not count that carryover again.
Another problem is mixing transaction amounts and budget balances in one column. Keep expenses and balances distinguishable, and use headings that state whether an amount is planned, spent, or remaining. For a quick visual check, use Home > Conditional Formatting > Highlight Cells Rules to flag negative balances. Formatting highlights a value but does not correct an incorrect formula or transaction.
Watch for blank cells that behave differently from zeros in a worksheet, especially when formulas are copied across months. Also inspect formulas after inserting or deleting rows. Excel normally adjusts references in many cases, but a copied formula can still point to the wrong month if the layout changes. Excel for the web has many familiar worksheet features, though menus and some editing details may differ from the Windows desktop app; the formulas shown here work in current Excel versions that support SUMIFS and EDATE.
Spreadsheet versus a reset-each-month budget
A rollover spreadsheet is most valuable when timing matters: saving gradually for a known irregular expense or seeing the effect of a surplus from one month to the next. A reset-each-month budget is simpler when every period’s allowance is meant to stand alone. It avoids carrying old surpluses or overspending into a new month, but gives less visibility into how a category accumulates over time.
Some budget apps also offer category rollover, but their rules and labels vary. Before switching, check whether the app carries negative balances, allows category-specific rules, and treats refunds or transfers as spending. A spreadsheet gives you direct control over formulas and layout, while requiring you to maintain the transaction data and check the calculations yourself.
For clarity, keep a copy of the original workbook before making major changes. You can format a selected range as an Excel table with Insert > Table, which can help organize transaction records and add filters. A table is useful for managing data, but it does not decide your rollover policy; that logic still needs to be represented in your formulas and headings.
Frequently Asked Questions
Should unused budget roll over to the next month?
It depends on the category and the purpose of the plan. Rollover is useful for irregular expenses and savings goals; resetting may suit categories intended to have a fixed monthly limit. Choose a rule you can apply consistently.
Can I carry a negative balance forward?
Yes. A full rollover formula carries a negative ending balance forward, reducing the next month’s available amount. If you do not want that, use a positive-only rule, but track overspending elsewhere so it does not disappear from view.
Is rollover the same as saving money?
No. Rollover is a budgeting calculation. It does not transfer cash into a separate account or guarantee that the money is still available in your bank account.
Why is my carried balance wrong?
Check that the new month’s opening carryover links to the previous month’s ending balance, and confirm that spending is counted in the correct month and category. Also check for duplicate transactions, category spelling differences, and manually overwritten formulas.
Can I roll over only some budget categories?
Yes. Apply rollover formulas to the categories that need them and use a reset rule for others. Label the rules clearly, since a workbook with different category policies is easier to understand when the policy is visible beside the category.
Related
- How to Open a TXT File in Excel Without Losing Data
- How to Open a Query in Excel and Edit It in Power Query
- How to Add Animation to PowerPoint Text Step by Step
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Box Plot With Data Points: How to Show Every ValueYes. In Excel for Microsoft 365 on Windows, select the box-and-whisker chart, open Format Data Series, and under…
- How to Zoom an Excel Sheet Using Keyboard ShortcutsIn Excel for Microsoft 365 on Windows, press Alt+W, then Q to open the Zoom dialog. Choose a…
- Auto Forwarding in Outlook: Setup and Key OptionsTo set up auto forwarding in Outlook, open Settings, choose Mail > Forwarding, turn on forwarding, enter the…
- Schedule an Email in Outlook on the Web: A Quick GuideTo schedule an email in Outlook in a browser, compose your message, open the arrow next to Send,…
- How to Alphabetize Names in Google Sheets Step by StepTo alphabetize names in Google Sheets, select the full data range you want to keep together, then choose…
- How to Insert a Row in Excel Between Existing DataTo insert a row between existing data in Excel, select the row heading immediately below where you want…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.