A Multi-Account Indirect Cash Flow Reconciliation

Why a Multi-Account Reconciliation Needs a Check

Net income measures performance using accrual accounting, while operating cash flow reports cash generated or used by operating activities. The indirect method starts with net income and adjusts for noncash items and for the timing differences recorded in operating asset and liability accounts. With several accounts, it is easy to apply one sign incorrectly or to use an account’s total balance change even when some of that change did not arise from operating activity.

A reliable reconciliation has two parts: calculate operating cash flow using the indirect method, then check the result against the cash receipts and payments implied by the underlying account movements. The examples assume a consistent classification policy, no income tax or interest items requiring separate treatment, and no unlisted operating adjustments. They are hypothetical and report amounts in thousands of dollars.

Definition: In an indirect-method reconciliation, begin with net income, add back expenses that reduced net income but did not use operating cash, subtract gains that increased net income but are not operating cash receipts, add losses that reduced net income but are not operating cash payments, and adjust for changes in operating current assets and liabilities. For an operating current asset, an increase is subtracted and a decrease is added. For an operating current liability, an increase is added and a decrease is subtracted.

Let $\Delta B$ mean the ending balance of an account minus its beginning balance. The working-capital adjustments use the change in the account’s operating balance, not necessarily the raw change shown by two balance sheets. The general reconciliation is:

\begin{aligned} \text{Operating cash flow} ={}&\text{Net income} +\text{noncash operating expenses} +\text{noncash losses}\\ &-\text{noncash gains} -\sum \Delta(\text{operating current assets}) +\sum \Delta(\text{operating current liabilities}). \end{aligned}

In the sums, a decrease is a negative change, so the formula automatically adds a decrease in an operating asset and subtracts a decrease in an operating liability. Each account included must be relevant to operating activity and must be adjusted for noncash changes or other movements that do not represent operating transactions.

Why the Adjustment Signs Work

Consider accounts receivable. If revenue is earned on credit, the revenue increases net income before the customer has paid. Under the assumption that there are no write-offs or other noncash changes, the increase in receivables is revenue recognized but not yet collected. Cash collected is therefore revenue less the increase in receivables. If receivables decrease, collections exceed revenue recognized during the period.

\Delta \text{Accounts receivable} =\text{Revenue}-\text{Cash collected}, \qquad \text{Cash collected} =\text{Revenue}-\Delta \text{Accounts receivable}.

The same logic explains the other working-capital signs. Inventory purchases exceed cost of goods sold when inventory increases, but a rise in accounts payable means some purchases have not yet been paid. For an operating expense connected to prepayments and accrued expenses, a prepaid-asset increase means cash paid exceeds the expense recognized; an accrued-liability increase means expense recognized exceeds cash paid.

\begin{aligned} \text{Cash paid to suppliers} &=\text{Cost of goods sold} +\Delta \text{Inventory} -\Delta \text{Accounts payable},\\ \text{Cash paid for other operating expenses} &=\text{Expense} +\Delta \text{Prepaid expenses} -\Delta \text{Accrued expenses}. \end{aligned}

Depreciation reduces net income without a current-period cash payment, so it is added back. A gain on disposal increases net income, but the gain itself is not an operating cash receipt; the cash proceeds from selling a long-lived asset are not included in operating cash flow. The gain is therefore subtracted. A loss is treated in reverse: it reduces net income without being an operating cash payment, so it is added back.

A Practical Reconciliation Sequence

Start with net income.
Use the income statement amount for the period. Keep the reconciliation within the stated reporting classification and assumptions.

Adjust noncash income-statement items.
Add back depreciation and losses; subtract gains, when those items are included in net income but their related cash flows are not operating cash flows.

Classify each operating account.
For each current asset or liability, identify its operating change. Check whether the balance movement includes a write-off, acquisition, reclassification, or other non-operating or noncash event.

Apply the working-capital signs.
Subtract increases in operating current assets and add decreases. Add increases in operating current liabilities and subtract decreases.

Verify from account movements.
Where the data permit, calculate customer cash receipts and operating cash payments independently. Their net should equal the indirect-method result.

Worked Reconciliations

Worked Example: Several Operating Accounts and an Asset Disposal Gain

A hypothetical business reports revenue of $400, cost of goods sold of $220, operating expenses excluding depreciation of $38, depreciation of $30, and a gain on disposal of equipment of $8. Assume these are the items determining net income, with no income tax or other adjustments. During the year, accounts receivable increases by $18, inventory increases by $12, prepaid expenses decrease by $3, accounts payable increases by $9, accrued operating expenses decrease by $4, and deferred revenue increases by $6. Find operating cash flow and check it from the account movements. All amounts are in thousands of dollars.

Method and net income. First calculate net income, including the gain and depreciation as income-statement items:

\text{Net income} =400-220-38-30+8=120.

Indirect reconciliation. Add back depreciation of $30, subtract the $8 gain, and apply the operating account changes. The inventory increase and accounts receivable increase are subtracted. The prepaid decrease and accounts payable increase are added. The accrued-expense decrease is subtracted, while the deferred-revenue increase is added.

\begin{aligned} \text{Operating cash flow} &=120+30-8-18-12+3+9-4+6\\ &=126. \end{aligned}

Check from customer receipts and operating payments. Customer cash receipts equal revenue less the receivables increase, plus the deferred-revenue increase:

$$ 400-18+6=388. $$

Purchases equal cost of goods sold plus the inventory increase, so purchases are $220+12=232$. Since accounts payable increased by $9, cash paid to suppliers is $232-9=223$.

The $38 of other operating expenses has a $3 decrease in prepaid expenses and a $4 decrease in accrued expenses. Cash paid for those expenses is expense plus the prepaid change minus the accrued-expense change:

$$ 38+(-3)-(-4)=39. $$

Net operating cash from these receipts and payments is $388-223-39=126$, matching the indirect reconciliation. The $8 gain has been removed from net income; any cash proceeds from the equipment sale are outside this operating cash calculation. Common mistake avoided: adding the gain because cash was received on the sale. The gain is not the proceeds, and it is subtracted from net income in this reconciliation.

Worked Example: Loss, Lower Receivables, and a Customer Advance

A hypothetical company has revenue of $250, cost of goods sold of $120, other operating expenses excluding depreciation of $45, depreciation of $16, and a $5 loss on disposal of equipment. Assume no income tax or other income-statement items. Accounts receivable decreases by $7, inventory increases by $20, prepaid expenses increase by $2, accounts payable decreases by $6, accrued expenses increase by $3, and deferred revenue decreases by $4. Calculate and check operating cash flow. All amounts are in thousands of dollars.

Method and net income. The loss reduces net income, while depreciation is an expense:

\text{Net income}=250-120-45-16-5=64.

Indirect reconciliation. Add back depreciation and the loss. The receivables decrease is added; inventory and prepaid increases are subtracted; the accounts-payable decrease is subtracted; the accrued-expense increase is added; and the deferred-revenue decrease is subtracted.

\begin{aligned} \text{Operating cash flow} &=64+16+5+7-20-2-6+3-4\\ &=63. \end{aligned}

Check from account movements. Customer receipts are $250-(-7)+(-4)=253$. The receivables decrease increases receipts relative to revenue, while the decrease in deferred revenue means some cash collected earlier is now recognized as revenue, reducing current receipts relative to revenue.

Purchases are $120+20=140$. With accounts payable down by $6, cash paid to suppliers is $140-(-6)=146$. Other operating expense cash payments are $45+2-3=44$: the prepaid increase raises cash paid relative to expense, while the accrued-expense increase lowers current cash paid relative to expense.

Net operating cash is $253-146-44=63$, which checks to the indirect result. Common mistake avoided: subtracting the loss in the reconciliation because it appears as a negative income-statement item. Since the loss lowered net income without being an operating cash payment, it is added back.

Worked Example: Checking a Reconciliation with a Disposal Gain

A hypothetical business reports revenue of $600, cost of goods sold of $310, operating expenses excluding depreciation of $52, depreciation of $45, and a $12 gain on disposal. Assume these are the income-statement items relevant to the problem, with no income tax or other adjustments. Accounts receivable increases by $25, inventory decreases by $8, prepaid expenses increase by $4, accounts payable increases by $14, accrued operating expenses decrease by $6, and deferred revenue decreases by $10. Calculate operating cash flow and verify it from customer receipts and operating payments. All amounts are in thousands of dollars.

Method and net income.

\text{Net income}=600-310-52-45+12=205.

Indirect reconciliation. Depreciation is added back and the gain is subtracted. The receivables and prepaid-expense increases are subtracted; the inventory decrease, accounts-payable increase, and accrued-expense decrease receive their respective asset or liability adjustments. The deferred-revenue decrease is subtracted.

\begin{aligned} \text{Operating cash flow} &=205+45-12-25+8-4+14-6-10\\ &=215. \end{aligned}

Check from account movements. Customer receipts are $600-25-10=565$. Purchases are $310-8=302$, because inventory decreased by $8. With accounts payable up by $14, supplier payments are $302-14=288$. Cash paid for other operating expenses is $52+4-(-6)=62$: the prepaid increase raises cash paid, and the accrued-expense decrease also raises cash paid relative to expense.

Thus net operating cash is $565-288-62=215$, matching the indirect reconciliation. Common mistake avoided: treating an inventory decrease as a negative adjustment. The decrease means cost of goods sold exceeded purchases, so it releases cash and is added.

Common Errors and the Importance of Account-Level Checks

A compact sign rule is useful, but it does not replace checking what caused a balance to change. If an account’s movement includes a noncash transaction, its raw beginning-to-ending change may not represent the operating timing difference required by the reconciliation. For example, a receivables balance can change because of a write-off, while an inventory or payable balance can change because of an acquisition or reclassification. The operating movement must be isolated before the adjustment is applied.

A frequent sign error is to add an increase in receivables because it is an asset increase. That calculation is wrong: if receivables increase by $10, cash collected is $10 less than revenue, so the adjustment is $-10$, not $+10$. The correction follows directly from the account relation:

\Delta \text{Accounts receivable} =\text{Revenue}-\text{Cash collected} \quad\Longrightarrow\quad \text{Cash collected} =\text{Revenue}-\Delta \text{Accounts receivable}.

Likewise, do not add a disposal gain merely because the sale generated cash. The gain is an accounting amount included in net income; sale proceeds are a separate cash amount and are not operating cash in this reconciliation. Finally, do not use a cash-flow adjustment twice: if a balance movement has already been separated into an operating portion and another event, use only the operating portion in the working-capital calculation.

Key takeaway: A sound multi-account reconciliation follows the same pattern every time: start with net income, reverse noncash expenses and gains or losses, apply the operating working-capital changes with the correct signs, and check the answer against the cash receipts and payments those account movements imply.

Check Your Understanding

For each problem, assume the listed balance changes are operating changes unless the problem says otherwise. Amounts are in thousands of dollars. Try each reconciliation before checking the answer.

A business reports net income of $90 and depreciation of $12. Accounts receivable increases by $9, inventory increases by $4, and accounts payable increases by $5. Find operating cash flow. (Answer: $94 thousand)
A company reports net income of $75, depreciation of $8, and a loss on disposal of $3. Accounts receivable decreases by $6, prepaid expenses increase by $2, accounts payable decreases by $4, and accrued expenses increase by $7. Find operating cash flow. (Answer: $93 thousand)
A firm has revenue of $360, cost of goods sold of $210, other operating expenses of $40, depreciation of $20, and a disposal gain of $5. Accounts receivable increases by $11, deferred revenue increases by $3, inventory decreases by $6, accounts payable increases by $8, prepaid expenses decrease by $2, and accrued expenses increase by $1. Calculate net income and operating cash flow. (Answer: Net income $95 thousand; operating cash flow $119 thousand)
Net income is $130, depreciation is $15, and a disposal gain is $4. Reported receivables increased by $10, but $4 of that increase came from an acquired business and was not an operating change. Inventory decreased by $3 and accounts payable decreased by $2. Using only the operating receivables change, find operating cash flow. (Answer: $136 thousand)
A company reports net income of $150, depreciation of $20, and a loss on disposal of $6. Accounts receivable increases by $12, inventory decreases by $8, prepaid expenses decrease by $3, accounts payable increases by $9, accrued expenses decrease by $5, and deferred revenue decreases by $4. Find operating cash flow. (Answer: $175 thousand)

What You'll Learn