Tutorials › VEE Accounting and Finance › Preparing the Direct Method from Transaction Data

VEE Accounting and Finance · Cash Flow Statement Methods · Tutorial 172 of 996

Preparing the Direct Method from Transaction Data

Build the direct-method statement by deriving cash received from customers and cash paid for operating costs, then classifying and reconciling investing and financing flows.

Intermediate 12 min read

What You'll Learn

  • Derive customer cash receipts from sales, receivables, and deferred revenue changes.
  • Calculate supplier, employee, and other operating cash payments from expenses and related account movements.
  • Distinguish an accrued liability change from a prepaid asset change when deriving payments.
  • Classify transaction-based investing and financing cash flows under the stated accounting convention.
  • Assemble and check a complete direct-method cash flow statement.

From Accrual Transactions to Cash Flows

The direct method reports major operating cash receipts and payments as cash amounts, rather than beginning with net income. Preparing it from transaction data therefore requires more than copying revenue and expense figures: accrual accounting records some items before cash changes hands, and balance changes reveal part of that timing difference. Investing and financing sections then report cash flows from the relevant transactions.

This tutorial uses the U.S. GAAP classification convention: cash interest paid, interest received, dividends received, and income taxes paid are operating cash flows; dividends paid are financing cash flows. Classification can differ under other reporting frameworks, so the convention should be identified before preparing a statement. The examples assume there are no unreported write-offs, foreign-exchange effects, acquisitions, or other adjustments to the accounts used.

Definition: The direct method presents operating cash flow by reporting major classes of cash received and cash paid, such as cash collected from customers and cash paid to suppliers. The investing and financing sections report their respective cash receipts and payments. A change in an account balance is its ending balance minus its beginning balance, written \(\Delta\text{account}\).

Deriving Cash Receipts from Customers

Revenue is not necessarily collected in the period it is earned. If customers owe more at period-end than at the beginning, some recognized revenue remains uncollected. Conversely, an increase in deferred revenue means cash was received before all of the related revenue was earned.

Let sales revenue be \(R\), cash collected from customers be \(C\), accounts receivable be \(AR\), and deferred revenue be \(DR\). Under the assumptions stated above, the receivable roll-forward is \(\Delta AR=R-C\), so \(C=R-\Delta AR\). The deferred-revenue roll-forward is \(\Delta DR=\text{cash received in advance}-\text{revenue earned from advances}\). Combining the two timing effects gives:

$$ \text{Cash collected from customers} = R-\Delta AR+\Delta DR $$

The signs have a direct interpretation: an increase in receivables reduces collections relative to sales; an increase in deferred revenue raises collections relative to revenue recognized. A decrease in either balance has the opposite effect.

Worked Example: Customer Collections with Two Timing Adjustments

A service business reports sales revenue of $240,000. Accounts receivable was $30,000 at the beginning of the year and $42,000 at year-end. Deferred revenue was $10,000 at the beginning and $6,000 at year-end. Assume no receivable write-offs or other adjustments. Find cash collected from customers and verify the result.

Method. Use sales adjusted for the change in receivables and deferred revenue. First calculate the signed changes:

\(\Delta AR=\$42{,}000-\$30{,}000=\$12{,}000\).

\(\Delta DR=\$6{,}000-\$10{,}000=-\$4{,}000\).

Then substitute:

Cash collected \(=\$240{,}000-\$12{,}000+(-\$4{,}000)=\$224{,}000\).

Check. Revenue equals collections plus the increase in receivables minus the change in deferred revenue: \(\$224{,}000+\$12{,}000-(-\$4{,}000)=\$240{,}000\). The check recovers the reported sales.

Common mistake avoided. A $4,000 decrease in deferred revenue is a negative change, not a positive $4,000 adjustment to the formula as written. Substituting the signed change gives collections of $224,000.

Deriving Operating Cash Payments

For expenses tied to accrued liabilities and prepaid assets, the account roll-forwards determine the cash paid. An accrued liability increases when expense recognized exceeds cash paid; a prepaid asset increases when cash paid exceeds expense recognized. For an expense category with one related accrued liability and prepaid asset, the relationship is:

$$ \text{Cash paid} = \text{Expense} -\Delta\text{accrued liability} +\Delta\text{prepaid asset} $$

This formula assumes the balance changes arise only from the expense and related cash payments. It is important not to treat an accrued liability and a prepaid asset as interchangeable: their changes enter with opposite signs. For payments to suppliers, inventory and accounts payable also matter. Assuming inventory purchases are the only source of inventory changes, purchases equal cost of goods sold plus the increase in inventory; cash paid to suppliers is purchases minus the increase in accounts payable.

$$ \text{Cash paid to suppliers} = \text{Cost of goods sold} +\Delta\text{Inventory} -\Delta\text{Accounts payable} $$

Worked Example: Separating Accrued Expenses from Prepayments

A firm reports wage expense of $76,000. Accrued wages rise from $6,000 to $9,000. It also reports maintenance expense of $50,000; prepaid maintenance rises from $4,000 to $7,000. Separately, utility expense is $90,000, and accrued utilities rise from $6,000 to $8,000. Assume no other related account changes. Find the cash paid for each category.

Wages. The change in accrued wages is \(\$9{,}000-\$6{,}000=\$3{,}000\). An increase means some wage expense remains unpaid: \(\$76{,}000-\$3{,}000=\$73{,}000\) paid.

Maintenance. The prepaid asset change is \(\$7{,}000-\$4{,}000=\$3{,}000\). The increase means cash paid exceeded expense by that amount: \(\$50{,}000+\$3{,}000=\$53{,}000\) paid.

Utilities. The accrued utilities change is \(\$8{,}000-\$6{,}000=\$2{,}000\). Applying the accrued-liability sign gives: \(\$90{,}000-\$2{,}000=\$88{,}000\) paid.

Check. For wages and utilities, expense equals cash paid plus the increase in the accrued liability: $73,000 + $3,000 = $76,000, and $88,000 + $2,000 = $90,000. For maintenance, the $53,000 paid includes $3,000 that remains prepaid, leaving $50,000 of expense.

Common mistake avoided. Adding an increase in accrued wages or accrued utilities to expense reverses the relationship. The increase represents expense not yet paid, so it is subtracted. An increase in a prepaid asset, by contrast, is added.

Completing the Direct-Method Statement

Once operating receipts and payments have been derived, transaction data identify cash flows in the investing and financing sections. A purchase of equipment for cash is an investing outflow; cash proceeds from selling equipment are an investing inflow. Borrowing and debt repayment, share issuance, and dividends paid are financing transactions under the convention used here. A transaction that does not involve cash is not included as a cash receipt or payment in the statement.

The following example assembles all three sections. Its operating calculations use sales, expenses, and account changes; its investing and financing amounts are given as cash transactions. The final check compares the net change in cash with the change from beginning to ending cash.

Worked Example: Preparing and Checking a Complete Statement

A company reports sales of $500,000, cost of goods sold of $250,000, wage expense of $90,000, other operating expense of $40,000, interest expense of $12,000, and income tax expense of $18,000. During the year, accounts receivable increases by $20,000, deferred revenue increases by $5,000, inventory increases by $10,000, and accounts payable increases by $15,000. Accrued wages increase by $4,000; prepaid operating expenses increase by $3,000; interest payable increases by $2,000; and income taxes payable decrease by $3,000. The company buys equipment for $60,000 cash and receives $8,000 cash from an equipment sale. It borrows $30,000, repays $20,000 of debt, issues shares for $15,000 cash, and pays $12,000 in dividends. Beginning cash is $25,000. Prepare the statement and determine ending cash.

Operating receipts. Cash collected from customers is: \(\$500{,}000-\$20{,}000+\$5{,}000=\$485{,}000\).

Cash paid to suppliers. Inventory purchases are cost of goods sold plus the increase in inventory: \(\$250{,}000+\$10{,}000=\$260{,}000\). Because accounts payable increases by $15,000, cash paid is $15,000 less than purchases: \(\$260{,}000-\$15{,}000=\$245{,}000\). Equivalently, \(\$250{,}000+\$10{,}000-\$15{,}000=\$245{,}000\).

Other operating payments. Cash paid to employees is \(\$90{,}000-\$4{,}000=\$86{,}000\). Cash paid for other operating expenses is \(\$40{,}000+\$3{,}000=\$43{,}000\). Cash interest paid is \(\$12{,}000-\$2{,}000=\$10{,}000\). Cash income taxes paid are \(\$18{,}000-(-\$3{,}000)=\$21{,}000\), because taxes payable decreased.

Net operating cash flow. Subtract the operating payments from customer collections: \(\$485{,}000-\$245{,}000-\$86{,}000-\$43{,}000-\$10{,}000-\$21{,}000=\$80{,}000\).

Investing activities. Net investing cash flow is equipment-sale proceeds less the cash purchase: \(\$8{,}000-\$60{,}000=-\$52{,}000\).

Financing activities. Net financing cash flow is borrowing plus share proceeds, less debt repayment and dividends: \(\$30{,}000+\$15{,}000-\$20{,}000-\$12{,}000=\$13{,}000\).

Statement and check. The completed statement, in dollars, is:

Cash flow itemAmount
Cash collected from customers$485,000
Cash paid to suppliers($245,000)
Cash paid to employees($86,000)
Cash paid for other operating expenses($43,000)
Cash interest paid($10,000)
Cash income taxes paid($21,000)
Net cash provided by operating activities$80,000
Equipment purchase($60,000)
Equipment-sale proceeds$8,000
Net cash used in investing activities($52,000)
Borrowing proceeds$30,000
Debt repayment($20,000)
Share issuance proceeds$15,000
Dividends paid($12,000)
Net cash provided by financing activities$13,000
Net increase in cash$41,000
Beginning cash$25,000
Ending cash$66,000

The section totals give a net increase of \(\$80{,}000-\$52{,}000+\$13{,}000=\$41{,}000\). Adding beginning cash gives \(\$25{,}000+\$41{,}000=\$66{,}000\) ending cash. This verifies the statement’s cash reconciliation.

Common mistake avoided. A decrease in taxes payable means the company paid more cash tax than the expense recognized, which is why the payment is $21,000, not $15,000. The signed-change formula makes the direction explicit.

A Reliable Preparation Sequence

A disciplined sequence reduces sign errors and prevents a correct operating section from being paired with an incomplete cash reconciliation.

1
Identify the reporting convention.
Determine the treatment of items such as interest and dividends before classifying them. Apply one convention consistently.
2
Calculate signed account changes.
For each balance, subtract its beginning amount from its ending amount. Keep decreases negative rather than describing them only in words.
3
Derive operating cash amounts.
Adjust sales and expenses for the related receivable, deferred-revenue, inventory, payable, accrual, and prepaid changes. Use only accounts connected to the item being calculated.
4
Classify investing and financing transactions.
Use the cash transaction itself to identify the section, and exclude noncash transactions from cash totals.
5
Reconcile cash.
Add operating, investing, and financing cash flows to obtain the net change; then add beginning cash and compare with ending cash.

Common Traps and Why the Method Matters

The direct method makes the sources and uses of operating cash visible. A company can report revenue without collecting it immediately, or incur expenses without paying them immediately. Separating the cash amounts from the accrual amounts helps a reader assess the timing of collections and payments without mistaking accounting earnings for cash generated in the period.

  • Using the wrong direction for accrued liabilities. An increase in an accrued liability generally means less cash was paid than the expense; subtract the increase from expense.
  • Using the wrong direction for prepaid assets. An increase in a prepaid asset generally means more cash was paid than the expense; add the increase to expense.
  • Ignoring signed decreases. Substitute \(\Delta\text{account}=\text{ending}-\text{beginning}\) into the formula. Do not silently turn a decrease into a positive change.
  • Confusing purchases with cash paid. Inventory purchases and supplier payments differ when inventory or accounts payable changes.
  • Skipping the final cash check. The sum of the three section totals must equal ending cash minus beginning cash. If it does not, revisit both arithmetic and classification.
Key takeaway: Prepare the direct method by first deriving each operating cash receipt or payment from its related accrual and balance changes, then classifying cash investing and financing transactions. The net of all three sections must reconcile beginning cash to ending cash.

Check Your Understanding

For each problem, use signed ending-minus-beginning changes and the U.S. GAAP convention stated above.

  1. A company records sales of $360,000. Accounts receivable falls from $28,000 to $20,000, while deferred revenue rises from $7,000 to $10,000. Assuming no other adjustments, find cash collected from customers. (Answer: $371,000)
  2. Cost of goods sold is $120,000, inventory decreases by $9,000, and accounts payable decreases by $4,000. Assuming inventory purchases are the only inventory change, find cash paid to suppliers. (Answer: $115,000)
  3. Wage expense is $84,000, and accrued wages decrease from $11,000 to $6,000. Find cash paid to employees. (Answer: $89,000)
  4. An operating expense is $64,000. Its related accrued liability increases by $2,000, while its prepaid asset decreases by $6,000. Assuming these are the only related account changes, find cash paid. (Answer: $56,000)
  5. A company reports sales of $700,000, cost of goods sold of $330,000, wage expense of $120,000, other operating expense of $75,000, interest expense of $15,000, and tax expense of $20,000. Receivables increase $25,000, deferred revenue decreases $10,000, inventory decreases $12,000, accounts payable increases $8,000, accrued wages decrease $5,000, prepaid operating costs increase $4,000, interest payable is unchanged, and taxes payable increase $3,000. It buys equipment for $90,000 cash and sells equipment for $14,000 cash; it borrows $40,000, repays $18,000 of debt, issues shares for $0, and pays dividends of $9,000. Beginning cash is $32,000. Find net operating, investing, and financing cash flows and ending cash. (Answer: operating $119,000; investing ($76,000); financing $13,000; ending cash $88,000)
Clinical Biostats