Expense forecasting by cost center and driver

Expense forecasting projects recognized costs from fixed commitments and the activities that cause spending. Build it by cost center, expense account and month, then compare the saved forecast with actual expenses using the same rows and accounting scope.

Start with the expense period and the right exports

Use the most recent closed general ledger as the starting point. Keep posting month, cost center, account, amount, journal reference and vendor or employee reference where available. Add schedules for open commitments, staffing and operating activity, with an owner and an effective date for each assumption.

An expense forecast and a payment forecast answer different questions. A service can be recognized before its invoice is paid, and a prepaid contract can be expensed after cash leaves. The SEC's guide to financial statements explains the distinction between profit and cash flows. Forecast the recognition period here; use payment terms separately when projecting cash.

Choose the accounts in scope before adding anything. An operating expense review should not silently include inventory purchases or capital additions. Keep the boundary with cost of goods sold consistent with the ledger. Bring depreciation in from an asset-based depreciation forecast, rather than treating equipment purchases as immediate expense.

Classify each cost before projecting it

Give each account a forecast method:

• Fixed commitment: monthly rent, contracted retainers or an approved subscription schedule.
• Activity driver: orders, trips, staffed hours or employee equivalents multiplied by a rate.
• Specific event: a scheduled project, recruitment fee or planned repair with a named month.

Use the contract or approved staffing plan for known changes. Historical averages help when a cost is recurring and no better evidence exists, but they should not override a signed renewal or an approved hiring date. Record whether the rate includes taxes, benefits, freight or other charges, so another reviewer can reproduce it.

Monthly expense forecast = Fixed commitments + Forecast activity × Forecast cost per unit + Separately identified events

A commitment already included in a unit rate is not another expense. For example, adding an outsourcing purchase order to a per-order fulfillment projection can count the same service twice. Reconcile the commitment register to the driver schedule before summing them.

Build a monthly forecast in Excel

A US distributor prepares its July forecast after the June close. These four rows are the complete illustrative scope, with no separate event expenses. Payroll uses full-month employee equivalents and includes salary, benefits and payroll taxes; all amounts are USD.

Put cost center in A, expense in B, fixed cost in C, forecast activity in D, rate in E and forecast expense in F. Enter this in F2 and fill down:

=C2+D2*E2

Store numeric quantities in the activity cells and keep unit labels in a separate column or cell format. Payroll is 20 × $6,500 = $130,000; adding facilities, fulfillment and travel produces $188,000. These inputs yield whole-dollar results, so no rounding adjustment is needed.

When preparing the full forecast, use one row per cost center, account and month. Save its version date. A forecast can change as evidence changes, while the approved budget stays available as a separate comparison; budget versus forecast explains that reporting distinction.

Compare the forecast with ledger actuals

After July closes, append actual fixed cost in G, actual activity in H and actual rate in I on the original worksheet. Calculate actual expense in J2 and actual minus forecast in K2, then fill down:

=G2+H2*I2
=J2-F2

The actual driver quantities and rates are:

For ledger aggregation, suppose the Actuals sheet contains posting month in A, cost center in B, account in C and expense amount in D. Selector cells P1, P2 and P3 on the forecast worksheet hold the selected month, cost center and account. Use an identical month key, such as July 1, 2026, in both sheets:

=SUMIFS(Actuals!$D$2:$D$10000,Actuals!$A$2:$A$10000,$P$1,Actuals!$B$2:$B$10000,$P$2,Actuals!$C$2:$C$10000,$P$3)

Microsoft documents SUMIFS as summing values that meet multiple criteria. Verify the range includes the complete export. Covirage is not affiliated with Microsoft.

The $198,250 total must tie to the selected ledger accounts before explaining the variance. Investigate missing cost centers, duplicate journals and unmapped accounts instead of burying them in an adjustment row.

Prove the variance through its drivers

Put volume effect in L, rate effect in M and fixed effect in N. Enter these formulas in L2, M2 and N2 respectively, then fill down:

=(H2-D2)*E2
=H2*(I2-E2)
=G2-C2

Using actual activity for the rate effect assigns the interaction between quantity and rate to that effect. The row check =K2-L2-M2-N2 must return zero.

The check is $5,600 + $4,150 + $500 = $198,250 - $188,000 = $10,250. Payroll is the largest increase, but travel's apparent saving comes from fewer trips despite a higher rate. Ask each owner whether the activity change will persist before updating the remaining months.

Where expense forecasting goes wrong

• Double-counted commitments. Remove recognized amounts from open orders and identify contracts already covered by driver rates.
• Closing headcount used for a full month. Start dates, departures and unpaid time can make closing employees differ from paid employee equivalents.
• Missing accruals treated as savings. Reconcile services received but not yet invoiced before calling a favorable variance permanent.
• Different account mappings between versions. Keep a consistent reporting map, or restate both versions and show the reclassification.
• Cost cuts confused with lower output. Separate activity from rate before judging an expense owner on the total variance.

Review your expense forecast in Covirage

Bring a sample of your own expense forecast, ledger export and driver schedule. Covirage maps the columns, and its tools compute and check the forecast-versus-actual differences; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, then set up your business and bring those files.

See cost variance analysis for the supporting expense review.