Rollover Budget Calculator

Next month roll for overspent categories.

Category budget ($)

Actual spent ($)

Existing rollover balance ($)

Months to recover

Tab to move between fields

This month's variance ($)

-$120.00

New rollover balance ($)-$170.00

Monthly adjustment ($)$56.67

Next month's adjusted budget ($)$556.67

Spending vs budget (%)124%

Months to clear balance3

How to Use This Calculator

Enter Category budget ($), Actual spent ($), and Existing rollover balance ($).
Set Months to recover.
Review the This month ($) result.
Use New rollover balance ($) ($) and Monthly adjustment ($) ($) to inform your decision.

How the result changes with Actual spent ($)

Category budget ($): The planned budget for this category this month.
Actual spent ($): How much was actually spent in this category this month.
Existing rollover balance ($): Accumulated surplus (positive) or deficit (negative) from prior months.
Months to recover: Number of future months over which to spread the recovery adjustment.

This month's variance ($): Budget minus actual. Negative = overspent, positive = underspent.
New rollover balance ($): Accumulated rollover including this month. Negative = debt to repay.
Monthly adjustment ($): Amount to add (or subtract) from future months to clear the rollover.
Next month's adjusted budget ($): Recommended budget for next month after applying the recovery adjustment.
Spending vs budget (%): Actual spending as a percentage of budgeted. Over 100% = overspent.
Months to clear balance: Estimated months until the rollover balance returns to zero.

Identify Input Parameters
4 parameters
Category budget ($) = 500, Actual spent ($) = 620, Existing rollover balance ($) = -50, Months to recover = 3 = 4 input(s) provided
Calculate This month's variance
This month's variance = categoryBudget - actualSpent
-120 = $-120
Calculate New rollover balance
New rollover balance = carryoverBalance + monthVariance
-170 = $-170
Calculate Monthly adjustment
Monthly adjustment = monthsToRecover > 0
56.67 = $56.67