Cash Flow Statement Direct Method Worked Example: From Trial Balance to Operating Cash Flow

ACCOUNTING & FINANCE🌐 Global Accounting

Cash Flow Statement Direct Method Worked Example: From Trial Balance to Operating Cash Flow

A full numeric walkthrough of the direct-method adjustments, from customer and supplier cash flows through to a fully reconciled cash balance.

  • Companion guide: a full numeric walkthrough applying the direct-method adjustments explained in “Cash Flow Statement Direct Method Guide” to a complete set of financial statements, from individual line items through to a reconciled cash balance.
  • Every direct-method figure follows the same two-step logic: start with the accrual-basis amount from the P&L, then adjust it for the movement in the matching Balance Sheet account over the period.
  • Purchases must be derived before cash paid to suppliers: Cost of Goods Sold has to be converted to Purchases using the movement in inventory, before the Accounts Payable adjustment can be applied.
  • The statement only checks out when it reconciles: the net increase or decrease in cash calculated from operating, investing, and financing activities must equal the actual movement in the cash balance on the Balance Sheet.
Illustration of converting accrual-basis figures to cash flow using a direct-method cash flow statement

Worked Example 1: Cash Received from Customers and Cash Paid to Suppliers

A trading company reports net revenue of $850,000 and cost of goods sold of $510,000 for the year. Accounts Receivable stood at $95,000 at the start of the year and $120,000 at year end. Inventory moved from $140,000 to $155,000, and trade Accounts Payable moved from $60,000 to $72,000 over the same period.

  • Step 1 — Cash received from customers: Revenue + Opening Accounts Receivable − Closing Accounts Receivable = $850,000 + $95,000 − $120,000 = $825,000. Receivables grew by $25,000 over the year, so $25,000 of billed revenue was not yet collected in cash.
  • Step 2 — Convert Cost of Goods Sold to Purchases: COGS + Closing Inventory − Opening Inventory = $510,000 + $155,000 − $140,000 = $525,000 of inventory purchased during the year. This conversion step is easy to skip, but it is required before the supplier-payment adjustment can be applied correctly.
  • Step 3 — Cash paid to suppliers: Purchases + Opening Accounts Payable − Closing Accounts Payable = $525,000 + $60,000 − $72,000 = $513,000. Payables grew by $12,000, so $12,000 of purchases were still unpaid at year end.
Diagram of cash received from customers and cash paid to suppliers feeding into operating cash flow

Worked Example 2: Completing the Operating Activities Section

The same company reports operating expenses (excluding depreciation) of $180,000, interest expense of $12,000, and tax expense of $45,000. Prepaid expenses moved from $8,000 to $11,000, accrued expenses moved from $15,000 to $9,000, interest payable moved from $2,000 to $3,000, and tax payable moved from $10,000 to $7,000.

  • Step 1 — Cash paid for operating expenses: Operating expense + increase in prepaid expenses − decrease in accrued expenses = $180,000 + ($11,000 − $8,000) + ($15,000 − $9,000) = $189,000. More cash was paid than expensed, both because prepayments grew and because accrued liabilities were paid down.
  • Step 2 — Cash paid for interest: Interest expense − increase in interest payable = $12,000 − ($3,000 − $2,000) = $11,000. Part of the interest charge remains unpaid at year end, so less cash went out than was expensed.
  • Step 3 — Cash paid for tax: Tax expense + decrease in tax payable = $45,000 + ($10,000 − $7,000) = $48,000. Tax payable fell, meaning the company paid down prior-year tax obligations on top of the current year’s charge.
  • Step 4 — Net cash from operating activities: $825,000 (customers) − $513,000 (suppliers) − $189,000 (operating expenses) − $11,000 (interest) − $48,000 (tax) = $64,000.
Operating, investing, and financing cash flows reconciling into a single confirmed cash balance

Worked Example 3: Investing, Financing, and the Final Reconciliation

During the year the company purchased new equipment for $40,000 and sold old equipment for $9,000 cash. It also drew a new bank loan of $50,000, repaid $20,000 of an existing long-term loan, and paid $15,000 in dividends. The cash balance on the Balance Sheet moved from $72,000 at the start of the year to $120,000 at year end.

  • Step 1 — Net cash used in investing activities: −$40,000 (equipment purchased) + $9,000 (proceeds from sale) = −$31,000.
  • Step 2 — Net cash from financing activities: $50,000 (new loan) − $20,000 (loan repayment) − $15,000 (dividends paid) = $15,000.
  • Step 3 — Net increase in cash for the year: $64,000 (operating) − $31,000 (investing) + $15,000 (financing) = $48,000.
  • Step 4 — Reconcile to the Balance Sheet: Opening cash $72,000 + net increase $48,000 = $120,000, matching the closing cash balance exactly. If the two figures do not match, the error lies in one of the earlier adjustment steps, not in the reconciliation itself.
💡 Key Concept

Every direct-method figure in this walkthrough follows the identical pattern: take the accrual-basis amount from the Profit & Loss, then adjust it for the movement in the matching Balance Sheet account over the period. Master that one relationship — and remember to convert Cost of Goods Sold to Purchases before applying it to Accounts Payable — and every line of the statement becomes a mechanical, checkable calculation rather than a guess.

Common Worked-Example Mistakes

  • Using P&L figures directly as cash flows without adjusting for the related Balance Sheet account’s movement — this is the single most common direct-method error.
  • Skipping the Purchases conversion step and applying the Accounts Payable adjustment directly to Cost of Goods Sold instead of to Purchases.
  • Mixing up the direction of an adjustment — an increase in a receivable or prepayment reduces operating cash, while an increase in a payable or accrual increases it; getting the sign backwards silently reverses the result.
  • Including depreciation or other non-cash items in a direct-method cash-paid figure — non-cash items simply do not appear anywhere in a direct-method statement.
  • Skipping the final reconciliation to the Balance Sheet’s actual cash movement — this check is what catches sign errors and mis-derived figures before the statement is finalized.

Need Help Preparing an Accurate Cash Flow Statement?

Ensure your cash flow statement reconciles correctly and reflects your actual operating, investing, and financing activity. Contact our Financial Advisory team today.

Contact Our Financial Advisory Team