Incremental budgeting: method, formula and example

Incremental budgeting builds next year's spending plan by adjusting an existing cost base for explicit changes. The useful version starts with a cleaned baseline, then separates price increases, activity changes and new commitments so every movement can be explained.

Start with costs you can reconcile

Export the general ledger for a complete fiscal year, with posting date, cost center, account, vendor, document reference and amount. Add the existing budget and the latest expected full-year actuals if the year is still open. Keep approved budgets and estimated actuals in separate columns.

An incremental approach changes an inherited base rather than requiring every existing activity to be justified again. The Georgia Municipal Association's budget guide describes incremental adjustments to line-item budgets and notes that longstanding programs do not have to be rejustified. That makes baseline quality a central control.

Before applying any rate, map reorganized cost centers into the new structure. Reconcile the exported total to the ledger, remove duplicate lines and identify missing accruals. A missing invoice is a completeness issue, not an efficiency saving.

Use zero-based budgeting when the decision is whether the underlying activities deserve funding. This method addresses a narrower job: documenting how a continuing cost base changes.

Clean the baseline before calculating an uplift

Keep a separate adjustment register with a reason, supporting document and owner for each entry. Distinguish three kinds of movement:

• A one-time cost removed was incurred last year but will not recur.
• An annualization adjustment brings an existing recurring commitment to a full-year basis.
• A new budget change alters next year's price, activity or scope.

An invented US distributor has four operating-cost lines. Its support retainer increased from $6,000 a month to $10,000 on July 1. The prior year therefore contains six months at each rate: $96,000. A full year at the continuing rate is $120,000, requiring a $24,000 annualization adjustment.

Put these columns in A:E, with headers in row 1. In E2, then fill down:

=B2-C2+D2

The $30,000 professional-services item was a completed office relocation. Keep its invoice reference in the adjustment register. Do not delete the ledger row: the original actuals must still reconcile.

Keep asset purchases and operating costs in their appropriate schedules; capital budget vs operating budget explains that boundary.

Build the proposal line by line

Next budget = Clean baseline + Rate change + Activity change + New one-time spending

Rate change = Clean baseline × Applicable rate

The following percentages are illustrative contract assumptions, not inflation benchmarks. Activity changes are already valued at next year's applicable prices, so no further rate adjustment is applied to them.

On a separate sheet with this table in A:G, enter this in D2:

=B2*C2

In G2, enter:

=SUM(B2,D2:F2)

Fill down through row 5. Record the $18,000 consumables reduction against an approved usage change, the $6,000 license addition against the planned user count and the $12,000 project against its authorization. A claim such as "general efficiency" is insufficient evidence for a reduction.

Prove the bridge, then compare actual spending

The full bridge must close:

420,000 − 30,000 + 24,000 + 17,520 − 12,000 + 12,000 = 431,520

The proposal increases by $11,520 from reported actuals, or 2.74%, rounded to two decimal places. That percentage describes the result; it is not the assumption used to generate the lines.

After approval, phase the budget by the dates costs will occur. Do not spread a project evenly when the contract places the expense in one month. Preserve the approved version; budget vs forecast explains why a revised expectation should remain separate.

The completed year's comparison might read:

Positive cost variance means spending above budget. Investigate whether the consumables usage reduction occurred before attributing its variance to supplier prices.

For a transaction-level worksheet called Actuals, put cost center in A, account in B, fiscal year in C and amount in D. If the comparison sheet holds those matching keys in A2:C2:

=SUMIFS(Actuals!$D$2:$D$10000,Actuals!$A$2:$A$10000,A2,Actuals!$B$2:$B$10000,B2,Actuals!$C$2:$C$10000,C2)

Microsoft documents SUMIFS as summing values that satisfy multiple criteria. Use equal-sized ranges and include every exported row. Covirage is not affiliated with Microsoft.

Where incremental budgeting goes wrong

• Uplifting exceptional costs. Remove the completed relocation before applying a continuing rate.
• Confusing annualization with growth. The support adjustment recognizes an existing commitment; it is not a new service request.
• Applying price changes twice. State whether activity adjustments use old or new prices.
• Treating vacancies or late invoices as permanent savings. Check the underlying commitment and service requirement.
• Hiding transfers as reductions. A cost moved to another department still belongs in the company total.

Check your budget on your own file in Covirage

Bring the prior-year ledger, adjustment register, approved budget and actual-cost export in a file. Covirage maps the columns, and its tools compute and check the baseline bridge and spending variances; the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See cost variance analysis for the supporting workflow.