Blog · Finance metrics and formulas · Finance and FP&A teams
Convert accrued operating expenses into cash paid using prepayments, accruals and noncash charges. Follow a ledger-to-payment reconciliation with spreadsheet formulas and a worked example.
Cash payments for operating expenses are accrued operating expenses adjusted for noncash charges, prepaid expenses and unpaid operating liabilities. Start with the expense ledger, bridge the related balance movements, and prove the answer against cash-disbursement rows.
Decide which expenses the payment line covers. This example includes administrative payroll, professional services, insurance, utilities and administrative depreciation. It excludes inventory purchases, equipment purchases, borrowing principal, interest and income taxes; those belong in separate schedules for this reconciliation.
The SEC's guide to financial statements distinguishes operating expenses from costs of sales and explains why operating cash flow adjusts earnings for noncash items and operating balance movements. Your account mapping should preserve those distinctions. The OPEX versus CAPEX guide covers the classification boundary in more detail.
Export the expense ledger and opening and closing trial balances for the same entity and period. Keep account, journal ID, posting date, cost center, vendor, amount and the counteraccount. Also export the payment register with payment dates, payment IDs and cash-account postings. Use expense-positive signs throughout the working schedule.
Map each expense account to its related prepaid asset and payable or accrued liability. A company-wide accounts payable movement will not work when it includes inventory or equipment invoices outside your expense boundary.
For balances with no acquisitions, currency effects, reclassifications or other noncash movements:
Cash paid = Operating expenses − Noncash charges + Closing prepaids − Opening prepaids + Opening related liabilities − Closing related liabilities
Prepaids increase payments relative to expense when cash is paid for benefits not yet consumed. Liabilities reduce payments relative to expense when costs are recognized but remain unpaid. A falling liability has the opposite effect.
KPMG's statement of cash flows handbook illustrates both direct cash paid to suppliers and employees and the indirect adjustments for prepaids and accrued expenses. This bridge supports a selected direct-method payment line; the cash flow statement example shows where it fits into the broader statement.
A US distributor prepares its September expense-payment reconciliation. All amounts below are USD, without rounding. Each account group has only the movements described here.
| Expense group | Expense (USD) | Noncash (USD) | Opening prepaid (USD) | Closing prepaid (USD) | Opening liability (USD) | Closing liability (USD) | Cash paid (USD) |
|---|---|---|---|---|---|---|---|
| Administrative payroll | 240,000 | 0 | 0 | 0 | 40,000 | 52,000 | 228,000 |
| Professional services | 75,000 | 0 | 0 | 0 | 20,000 | 26,000 | 69,000 |
| Insurance | 30,000 | 0 | 18,000 | 30,000 | 0 | 0 | 42,000 |
| Utilities | 48,000 | 0 | 0 | 0 | 5,000 | 5,000 | 48,000 |
| Administrative depreciation | 27,000 | 27,000 | 0 | 0 | 0 | 0 | 0 |
| Total | 420,000 | 27,000 | 18,000 | 30,000 | 65,000 | 83,000 | 387,000 |
Put those columns in A:H, with the first expense group on row 2. The exact spreadsheet formula in H2 is:
=B2-C2+E2-D2+F2-G2
Fill it down through row 6. The total in H7 is:
=SUM(H2:H6)
Payroll cash is $240,000 + $40,000 − $52,000 = $228,000. Insurance cash is $30,000 + $30,000 − $18,000 = $42,000. The unchanged utilities accrual contributes no adjustment, although individual invoices were settled and replaced by new unpaid invoices.
The company calculation is $420,000 − $27,000 + $12,000 − $18,000 = $387,000. The prepaid increase is $30,000 − $18,000; the liability increase is $83,000 − $65,000.
Filter cash postings to the same mapped expense groups. Keep settlements of opening liabilities and advance payments in scope, even when no current-month expense accompanies the payment. Remove transfers between company bank accounts and trace reversals to their original payments.
| Classified payment-register group | Cash paid (USD) |
|---|---|
| Administrative payroll | 228,000 |
| Professional services | 69,000 |
| Insurance | 42,000 |
| Utilities | 48,000 |
| Total payment-register outflow | 387,000 |
The control is bridge total minus classified payment total:
=H7-SUM(Payments!B2:B5)
It must return zero. Do this by account group as well as in total: offsetting misclassifications can hide behind a company-level tie. Reconcile the full cash register to the cash ledger separately so omitted payment batches cannot disappear from both sides of this selected schedule.
For the drivers of the expense itself, use how to analyze operating expenses. Higher expense and higher cash payments can have different causes, so keep the two investigations connected but distinct.
Bring your expense ledger, related balance schedule and payment export. Covirage maps the columns, and its tools compute and check the expense-to-cash bridge; 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 how this work supports reporting for finance teams.
Expenses follow when services are consumed or obligations arise. Payments follow when cash leaves the company. An unpaid payroll accrual, an annual insurance payment and depreciation can therefore make the expense total differ from cash paid in the same month.
Subtract an increase when calculating cash paid from expense. Some expense remains unpaid at the period end. Add a decrease because the company paid down obligations from an earlier period, provided the movement represents cash settlement.
No. Depreciation is an expense allocation without a current cash payment, so remove it from the expense starting point. Cash paid to buy the underlying equipment belongs in its separately classified cash-flow category.