Blog · Finance metrics and formulas · Finance and FP&A teams
An increase in prepaid operating expenses reduces operating cash flow under the indirect method. Reconcile opening and closing balances to cash payments and expense recognition with a worked workbook example.
For prepaid expenses, the cash flow statement indirect method subtracts an increase and adds a decrease in ordinary operating prepaids. The adjustment corrects the gap between the expense already included in net income and the cash actually paid for those benefits.
Paying for future insurance or a service subscription usually creates a prepaid asset. As the company consumes the benefit, it records expense and reduces that asset. The payment and the expense can therefore fall in different reporting periods.
The SEC's financial statement guide explains that operating cash flow reconciles net income for noncash items and changes in operating assets and liabilities. KPMG's cash-flow handbook illustrates an increase in prepaid expenses as a negative adjustment in that reconciliation.
Prepaid operating cash-flow adjustment = Opening prepaid balance − Closing prepaid balance
That shortcut assumes the change comes only from operating cash payments and expense recognition. If the balance includes acquired assets, transfers, currency effects or write-offs, reconcile those movements separately first.
The cash flow statement example covers the full indirect statement. This schedule establishes the sign and supporting evidence for its prepaid-expense line.
Bring the opening and closing balance sheets, prepaid subledger, expense ledger and cash-disbursement register. For each contract, retain vendor, prepaid account, payment ID, service dates, payment amount, expense recognized and closing unconsumed amount.
Start from the same reporting entity and currency on both balance sheets. Reconcile the prepaid subledger to the general-ledger control account at each date. Then identify additions paid in cash, releases to expense and any other entries. A closing balance alone cannot prove what caused its movement.
The broader accrual versus cash accounting comparison explains the reporting bases. Here, the company keeps its accrual books and prepares a reconciliation rather than switching its accounting basis.
A US distributor has two ordinary operating prepaid groups during September. No invoices remain unpaid, and there are no refunds, acquisitions, foreign-currency movements, impairments or transfers. All dollar amounts are exact.
| Prepaid group | Opening balance (USD) | Cash payments (USD) | Expense recognized (USD) | Closing balance (USD) | Indirect adjustment (USD) |
|---|---|---|---|---|---|
| Insurance | 18,000 | 30,000 | 6,000 | 42,000 | -24,000 |
| Service subscriptions | 12,000 | 16,000 | 4,000 | 24,000 | -12,000 |
| Total | 30,000 | 46,000 | 10,000 | 66,000 | -36,000 |
The insurance balance is $18,000 + $30,000 − $6,000 = $42,000. Its adjustment is $18,000 − $42,000 = −$24,000. The subscription balance is $12,000 + $16,000 − $4,000 = $24,000, producing a −$12,000 adjustment.
Put the table in A:F, with insurance on row 2. Calculate the closing balance in E2 and the indirect adjustment in F2:
=B2+C2-D2
=B2-E2
Fill down to the subscription row, then sum each numeric column. The total indirect adjustment is −$36,000 because closing prepaids of $66,000 exceed opening prepaids of $30,000 by $36,000. No percentage or rounding convention is needed for this dollar reconciliation.
The distributor has the following complete income and operating-cash inputs for this simplified period. Customer receipts equal revenue, and the other operating costs are fully paid in the same period.
| Income statement input | Amount (USD) |
|---|---|
| Revenue | 200,000 |
| Other operating expense | -100,000 |
| Depreciation expense | -10,000 |
| Prepaid expense recognized | -10,000 |
| Net income | 80,000 |
Net income is $200,000 − $100,000 − $10,000 − $10,000 = $80,000. There are no additional income-statement items or operating working-capital movements in this example.
| Indirect operating reconciliation | Amount (USD) |
|---|---|
| Net income | 80,000 |
| Add depreciation | 10,000 |
| Subtract increase in prepaids | -36,000 |
| Operating cash flow | 54,000 |
Now prove the same result directly: customer receipts of $200,000 less other operating payments of $100,000 less prepaid payments of $46,000 equal $54,000. The indirect and direct answers agree.
The prepaid expense of $10,000 plus the $36,000 increase explains the $46,000 cash paid. Do not subtract the full payment again after recording the balance-change adjustment: that would count the same outflow twice.
For related liabilities, interest payable under the indirect method addresses a separate adjustment with a different sign pattern. Keep each supporting schedule tied to its own account population.
Bring your opening and closing balance sheets, prepaid roll-forward and payment export. Covirage maps the columns, and its tools compute and check the balance movements and cash reconciliation; 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 FP&A reporting for the supporting reporting work.
An increase means cash paid for future operating benefits exceeds the related expense recognized, assuming no other balance movements. Net income has not yet absorbed that unused benefit, so subtract the increase to reach cash from operations.
No. The release records insurance expense and reduces the prepaid asset. The cash left when the premium was paid. The indirect reconciliation adjusts the prepaid balance movement so expense recognition does not create a second cash outflow.
Only after reviewing its components. That caption may include deposits, tax receivables and other items with different underlying transactions. Use the prepaid operating expense accounts and separately analyze movements that do not belong in the same cash-flow adjustment.