How to analyze operating expenses

How to analyze operating expenses: reconcile actual expense to budget first, then explain the difference through accounts, cost centers, vendors and business activity. The useful output is a dollar explanation that adds back to the P&L variance and gives each material cause an owner.

Start with a comparable expense boundary

Use the general-ledger export for the closed reporting period, the approved budget version and a consistent account mapping. Keep posting date, service period, account, cost center, vendor, journal ID, invoice ID and signed expense amount. Retain reversals and credits so the export represents net recorded expense.

The SEC's financial statement guide distinguishes operating expenses from costs of sales and describes their position in the income statement. Apply your company's approved mapping before investigating changes. The OPEX versus CAPEX guide covers that boundary; the cost of goods sold guide covers production and merchandise costs.

Use the same entity, currency, period and expense population in actual and budget. Reconcile actual to the closed P&L and budget to the approved workbook. Document mapping changes before interpreting variances.

Calculate the variance from the export

For expense-positive amounts:

Expense variance = Actual expense − Budget expense

Variance percentage = Expense variance / Budget expense

A positive variance means actual expense exceeds budget. It does not establish whether the spending was justified.

Suppose the Ledger worksheet has posting date in A, account in B, cost center in C, vendor in D and expense in E. On the Analysis worksheet, A2 holds the account, B2 the cost center, and J1 and K1 hold the period's starting and ending dates. Aggregate matching rows with:

=SUMIFS(Ledger!$E:$E,Ledger!$B:$B,$A2,Ledger!$C:$C,$B2,Ledger!$A:$A,">="&$J$1,Ledger!$A:$A,"<"&($K$1+1))

The SUMIFS reference documents its sum range and multiple criteria pairs. Covirage is not affiliated with Microsoft. Use matching-sized ranges, real dates and standardized account identifiers. Put budget in C and actual in D; calculate dollar and percentage variances in E and F:

=D2-C2
=IF(C2=0,"n/a",E2/C2)

Keep the budget at its natural level. If it contains an account-and-cost-center total without vendors, compare at that level first. Allocating it across vendors without an approved allocation rule creates apparent vendor variances that the budget never defined.

Work a monthly operating expense example

A US distribution company compares September actual expense with its approved September budget. These five rows are its complete selected operating expense population. Dollars are exact; percentages in the table are rounded to one decimal place.

The total percentage is $40,000 / $200,000 = 20.0%. Calculate it from the totals, never by averaging row percentages. The P&L example provides the wider statement context around this expense investigation.

Operations is the largest dollar increase; finance has the largest percentage increase. Investigate both, ranking work by dollar impact and recurrence.

Separate activity, rate and timing

For contractors, the approved timesheet and rate schedule provide the explanation:

This convention values extra activity at the budget rate and the rate change at actual activity. State the convention so another analyst reproduces the same split. If the inputs occupy B2:B5 in the order budget hours, budget rate, actual hours, actual rate:

=(B4-B2)*B3
=B4*(B5-B3)

The finance owner confirms that audit work budgeted for the following month was performed in September. That supports a timing explanation for the $12,000 variance, without moving a correctly recorded expense out of September.

The adjusted comparison is $240,000 − $212,000 = $28,000, or 13.2% of $212,000, rounded to one decimal place. Keep the original $40,000 reported variance visible. Timing alignment explains it; it does not silently replace the approved budget.

Turn the reconciliation into decisions

The contractor rate change goes to procurement and the operations owner; additional hours go to the manager who approved the work. IT should reconcile subscription quantities and rates before proposing cuts. Finance should update the audit timing assumption in the outlook, while administration checks the payroll movement against approved staffing.

Require evidence and an owner for each explanation. The final causes must sum to the variance, with any unresolved amount shown explicitly. For the separate question of when money left the business, use cash payments for operating expenses.

Where it goes wrong

• Cash payments substitute for expense. Advance payments and accrual settlements make a payment export a different population.
• Service periods are ignored. A posting spike may reflect timing, corrections or catch-up accruals rather than a new recurring cost.
• Vendor and cost-center explanations are added together. They are views of the same rows; adding both counts the variance twice.
• A timing claim has no offset. Confirm which later period's planned work moved, then check that the outlook reflects it.

Analyze your own operating expenses in Covirage

Bring your ledger detail, budget export and supporting activity schedule. Covirage maps the columns, and its tools compute and check the comparisons; the external AI model explains the changes 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.