Cost control report: budget, commitments and actuals

A cost control report compares the approved budget with actual costs, remaining commitments and work still to buy. It shows the expected finishing cost and the amount above or below budget. Adding actual expenses to the original value of every purchase order overstates costs because part of those orders may already be in actuals.

Start with one scope and reporting date

Choose the project, department or program, its complete reporting horizon, and an as-of date. A full-program budget needs cumulative actuals and remaining costs for that same program. A monthly budget needs costs within that month; it cannot sensibly be compared with all future contract commitments.

Bring three exports and an owner-reviewed estimate:

Use USD consistently and retain credit amounts. Check whether the purchase-order export already gives a remaining balance; if it does, reconcile that balance rather than subtracting invoices from it again.

Microsoft's budget-control guidance treats actual expenditures and purchase-order reservations as distinct balances in funds-available calculations. The same distinction matters in a spreadsheet report, even when the source files use different names for commitments.

Calculate remaining commitments before the forecast

Remaining commitment = Original authorized PO value + Approved increases − Cancellations − Costs already recognized against the PO

Forecast cost = Actual costs + Remaining commitments + Uncommitted estimate to complete

Forecast headroom = Approved budget − Forecast cost

Here, positive headroom means an expected underspend; negative headroom means an expected overrun. The report uses cost recognition, not payment timing. Include recognized accruals in the matched-cost deduction when the same work remains on the PO balance, or you will count that work twice.

For an illustrative US distributor's fall marketing program, the cutoff is October 31, 2026, and the scope runs through December 31, 2026. There are no PO increases. All costs recognized so far relate to the listed orders.

The commitment check is $250,000 less $5,000 less $155,000 equals $90,000. Research has $15,000 left before cancellation; the approved $5,000 cancellation reduces the remaining obligation to $10,000. A requested cancellation stays in commitments until procurement confirms it is effective.

Build the report in a spreadsheet

Place the following report in columns A:G, with the first cost code in row 2. Column E contains only necessary costs that are neither actuals nor covered by remaining orders.

In an Actuals sheet, suppose A is cost code, B is posting date and C is recognized amount. H1 contains the program start date and H2 the cutoff date. The Excel formula for C2 is:

=SUMIFS(Actuals!$C$2:$C$9999,Actuals!$A$2:$A$9999,$A2,Actuals!$B$2:$B$9999,">="&$H$1,Actuals!$B$2:$B$9999,"<"&($H$2+1))

This includes the cutoff day even when posting dates contain times. Use SUMIFS with matching criteria ranges, extend the ranges to include the full export, and fill down for each cost code. Covirage is not affiliated with Microsoft.

If Orders has cost code in A and checked remaining commitments in B, D2 is:

=SUMIFS(Orders!$B$2:$B$9999,Orders!$A$2:$A$9999,$A2)

Forecast and headroom are:

=SUM(C2:E2)
=B2-F2

The total forecast is $155,000 plus $90,000 plus $30,000, or $275,000. Budget of $300,000 therefore leaves $25,000 of expected headroom. Every dollar shown is exact; no rounding is required.

Read the overrun before netting it away

Events is expected to exceed its budget by $10,000 despite the program's overall headroom. Ask the owner whether the $25,000 uncommitted estimate covers necessary scope, a price change or additional work. Do not assume savings in Creative can fund Events without the required approval.

Change just one input: Events' uncommitted estimate rises from $25,000 to $55,000. Its forecast becomes $45,000 plus $30,000 plus $55,000, or $130,000. The program forecast rises by $30,000 to $305,000, turning headroom into a $5,000 overrun. Nothing has been invoiced yet, but the decision has changed.

Use a cost change control process for proposed scope and budget changes. Pre-contract cost control covers the earlier decision before the obligation is signed.

Check the totals and common failure points

Tie actuals to the relevant ledger expense accounts and the approved budget to its authorized version. Reconcile the remaining PO total with procurement's open-order report, documenting any recognized accruals not reflected there. Ask each cost owner to confirm that the uncommitted estimate covers the unfinished scope once.

• Original PO values added to actuals. Events would show $145,000 instead of $100,000 if its $45,000 recognized portion were counted again.
• Requisitions added to the orders they became. Keep requests separate or replace them when the purchase order is issued.
• Accruals and invoices both recognized. Check reversals and matching references before accepting the actual expense total.
• Budget changes treated as savings. Show approved baseline changes separately from reductions in expected cost.

For the broader operating review, see project cost control.

Run your cost control report in Covirage

Upload your budget, expense and purchase-order files or a Google Sheet with consistent cost codes. Covirage maps the columns, and its tools compute and check the comparisons; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.

See cost variance analysis for the supporting finance workflow.