Facility Management Reports: Cost and Service

Facility management reports compare maintenance cost, completed work, and outstanding service needs by building. A useful monthly package reconciles work-order movements, checks spending against the ledger, and names the exceptions that need a decision. Read service and cost together before calling a lower bill an improvement.

Define the report before comparing buildings

Use one reporting month and one cutoff for backlog. This example covers maintenance at commercial buildings operated by a US company. It excludes rent, utilities, cleaning, security, depreciation, and capital projects; those can appear elsewhere in the facilities package under separate headings.

The facilities manager owns work-order classifications and completion evidence. Finance owns the expense boundary and budget version. Building managers explain service impact and validate whether work remains outstanding.

The facility dashboard covers a recurring overview of occupancy, backlog, and operating costs. This periodic report adds a movement reconciliation, documented exceptions, and a management decision. Put its agreed findings into the broader management reporting package.

Export the records that prove the totals

Bring work-order ID, building ID, asset or location, work type, priority, opened date, due date, completed date, status, and owner. Export the opening backlog snapshot as well as the month's movements; a current open-order list cannot explain work completed earlier in the month.

Bring expense transaction ID, building ID, account, posting date, work-order reference, labor amount, materials amount, contractor amount, and total cost. Use the approved monthly budget for the same buildings and cost categories.

Preserve work type. Pacific Northwest National Laboratory's maintenance guidance distinguishes reactive work, time-based preventive work, and condition-based predictive work. A routine inspection and an emergency repair should remain identifiable when explaining spending or workload.

Summarize costs separately from order counts. Several invoices can belong to one order, and one contractor invoice can cover several orders. Repeating either total across every matching row can distort the report.

Build the monthly work-order bridge

An illustrative US business reviews September 2026 across three commercial buildings. Orders in this example are only opened or completed. There are no cancellations, reopenings, transfers, or duplicate requests.

With building in A and the other columns in B:F, calculate expected closing backlog in G2:

=B2+C2-D2

Compare it with the exported snapshot in E2:

=G2-E2

Every difference must be zero. Here, 45 + 70 - 70 = 45, and the building sum is 15 + 20 + 10 = 45. Overdue work is part of closing backlog; adding it again would count those orders twice.

To rebuild movement counts from order history, put September 1, 2026, in J1 and October 1, 2026, in J2. On the Orders sheet, let B contain building, C opened date, and D completed date. With the building name in A2, use:

=COUNTIFS(Orders!$B$2:$B$1000,$A2,Orders!$C$2:$C$1000,">="&$J$1,Orders!$C$2:$C$1000,"<"&$J$2)
=COUNTIFS(Orders!$B$2:$B$1000,$A2,Orders!$D$2:$D$1000,">="&$J$1,Orders!$D$2:$D$1000,"<"&$J$2)

The first formula counts new orders and the second completed orders. Microsoft documents COUNTIFS as counting rows where all specified criteria are met. Use one row per order and extend the ranges to include the full export.

State what the completion rate measures

For this report, workload completion rate means completed orders divided by opening backlog plus new orders. It measures how much of the available order population was completed during the month, not whether due dates were met.

=IF(B2+C2=0,"No workload",D2/(B2+C2))

Calculate the total as 70 / 115, retaining unrounded values and displaying two decimals. The business completed as many orders as it received, but still ended with the opening backlog count. That does not mean the same orders remained open; inspect IDs and age to establish that.

Order counts also hide job size. Use the separate asset maintenance KPI guide if the decision requires remaining labor hours or equipment reliability rather than this building-level package.

Add the maintenance cost comparison

Use the same approved scope at each building. The amounts below come from selected maintenance expense accounts, including recorded accruals.

With budget in B and actual in C, the formulas are:

=C2-B2
=IF(B2=0,"No budget",(C2-B2)/B2)

The dollar check is 11,000 + 7,500 + 6,500 = $25,000. The variance check is 1,000 - 500 + 500 = $1,000, equal to 25,000 - 24,000. The company percentage is 1,000 / 24,000 = 4.17%, rounded to two decimals.

West's lower spending sits beside the largest closing backlog and overdue count. Review deferred jobs and missing invoices before describing the underspend as savings. The accrual versus cash guide explains why invoice payment dates cannot establish the month's expense.

For a manufacturing location, keep any resulting output constraint in the production report for management; this facilities package supplies the building-service evidence.

Where it goes wrong

• Cancellations called completions. Show canceled, transferred, or reopened work as separate bridge movements when present.
• Unknown due dates treated as on time. Report missing dates separately from overdue and current work.
• A small job equals a major repair. Counts describe order flow; they do not measure effort or business impact.
• Capital work mixed into maintenance. Keep the cost boundary consistent and reconcile excluded project charges separately.

Covirage is not affiliated with Microsoft.

Compare your building exports in Covirage

Bring your work-order history, backlog snapshots, maintenance expense detail, and approved budget. 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 in Covirage for the spending comparison.