Tutorials › VEE Accounting and Finance › Reading Source Data for Cash Flow Preparation

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

Reading Source Data for Cash Flow Preparation

Learn to read financial statement balances alongside transaction details to identify cash activity, accruals, and noncash changes before preparing a cash flow statement.

Intermediate 12 min read

What You'll Learn

  • Identify the cash-flow clues provided by comparative balance sheets and income statements.
  • Distinguish balance changes from the cash transactions that may have caused them.
  • Recognize accruals, deferrals, and noncash transactions in supporting details.
  • Use account rollforwards to check whether reported changes are fully explained.
  • Identify when additional transaction information is needed before cash flows can be determined.

Why Cash-Flow Preparation Starts with Source Data

A statement of cash flows reports cash activity during a period, but its starting information is usually presented in forms that do not report cash activity directly. A comparative balance sheet shows account balances at two dates. An income statement reports revenues and expenses on an accrual basis. Neither statement, by itself, lists every cash receipt and payment. Transaction details, account records, and supporting schedules help explain how the balances and reported earnings relate to cash.

The key task at this stage is to read each source for what it actually establishes. A change in an asset balance is not automatically a cash payment; a revenue amount is not automatically a cash receipt; and an expense amount is not automatically a cash payment. Before an amount can be used as evidence of a cash flow, identify the transaction or accounting event behind it.

Definition: Cash-flow source data are the financial statement amounts and transaction details used to identify cash receipts and payments, distinguish them from accrual and noncash activity, and support the period’s cash-flow reconciliation. Comparative balance sheets show beginning and ending balances; the income statement reports period revenues and expenses; transaction details explain the events that connect them.

What Each Source Can Tell You

Each source provides a different kind of evidence. Reading them together is more reliable than treating any one statement as a complete record of cash movement.

SourceWhat it showsWhat it does not show by itself
Comparative balance sheetsBeginning and ending balances, and therefore the net change in each reported accountThe individual transactions that caused the change, or which of them involved cash
Income statementAccrual-basis revenues, expenses, and income for the periodWhen customers paid, when expenses were paid, or whether an expense involved cash
Transaction details and supporting recordsSpecific events, amounts, timing, and whether cash changed handsThey may not be complete enough to explain every balance or cash movement

A balance sheet is a snapshot, while an income statement summarizes activity over a period. Comparing them can reveal which account balances changed, but a net change can conceal several different events. For example, an accounts receivable balance might increase because of credit sales and decrease because of customer payments, write-offs, or other adjustments. Its ending balance alone does not identify the amount of cash collected.

Similarly, net income is not a cash total. It includes revenues and expenses recognized under accrual accounting, which may be recorded in periods different from the related cash transactions. It can also include noncash items. Transaction details help distinguish those possibilities rather than assuming that every income-statement amount was collected or paid in cash.

Read Balance Changes as Clues, Not Conclusions

A useful first step is to calculate each account’s net change: ending balance minus beginning balance. That change describes what happened to the reported balance, not necessarily what happened to cash. To interpret it, identify the account type and examine the transactions that affected the account.

$$ \text{Net change in an account} = \text{Ending balance} - \text{Beginning balance} $$

An account rollforward makes the limitation explicit. In general, an account balance changes through increases and decreases, some of which may be cash transactions and some of which may not.

$$ \text{Ending balance} = \text{Beginning balance} + \text{Increases} - \text{Decreases} $$

This identity follows from recording each increase and decrease in the account: add all increases to the starting balance, then subtract all decreases, and the result must equal the ending balance. It is an accounting reconciliation, not a cash-flow formula. The increases and decreases must still be identified before deciding which, if any, represent cash flows.

For example, an increase in equipment might reflect a cash purchase, an acquisition financed with a note, or both. A decrease in a liability might reflect a cash payment, forgiveness of the debt, or reclassification. Balance changes are useful because they indicate what needs explanation; transaction details establish the nature of the events.

Worked Example: Reading Changes in Operating Accounts

A hypothetical company reports accounts receivable of $72,000 at the beginning of the year and $91,000 at year-end. Inventory falls from $48,000 to $43,000, accounts payable falls from $35,000 to $29,000, and deferred revenue rises from $9,000 to $14,000. The income statement reports sales of $420,000 and cost of goods sold of $250,000. Transaction records identify a $3,000 receivable write-off and an $8,000 customer advance received in cash and recorded as deferred revenue. What can be identified from these sources?

Method. Calculate the account changes, then use the transaction detail to separate an identified cash event from an accrual or noncash change. Do not treat the net balance changes as cash totals.

Accounts receivable. The net change is $91,000 − $72,000 = an increase of $19,000. The $3,000 write-off is a noncash reduction of receivables, not a cash receipt. The balance comparison and write-off do not, by themselves, provide a complete account of all sales and collections.

Inventory and accounts payable. Inventory decreased by $48,000 − $43,000 = $5,000. Accounts payable decreased by $35,000 − $29,000 = $6,000. These are balance changes; without further transaction details, neither amount identifies the cash paid for inventory or suppliers.

Deferred revenue. The account increased by $14,000 − $9,000 = $5,000. The transaction records identify an $8,000 cash advance, which is a known cash receipt. Because the account’s net increase is only $5,000, other account activity must also have occurred. The net balance change does not replace the detailed record of the advance.

Income statement. Sales of $420,000 and cost of goods sold of $250,000 are accrual-basis amounts. They do not state, by themselves, how much cash customers paid or how much cash the company paid for inventory.

Check. The balance changes are receivables +$19,000, inventory −$5,000, accounts payable −$6,000, and deferred revenue +$5,000. The specifically identified $8,000 advance is cash; the $3,000 write-off is noncash. The remaining cash activity cannot be determined from the stated information alone. This avoids the common mistake of reading an account’s net change as the cash flow.

Use Transaction Details to Separate Cash and Noncash Events

A transaction detail is especially useful when it identifies both the account affected and whether cash changed hands. A purchase paid immediately is different from an asset acquisition financed with a note, even if both increase the same asset account. Likewise, a declared dividend and a paid dividend are separate events: declaration establishes an obligation, while payment reduces cash.

For each event, ask three questions: What account or accounts changed? Did cash change at the time of the event? If cash did not change, is the event an accrual, a deferral, a noncash transaction, or another balance-sheet adjustment? These questions help prevent an accounting entry from being mistaken for a cash receipt or payment.

Worked Example: Identifying Cash and Noncash Equipment Activity

A hypothetical manufacturer reports equipment at historical cost of $300,000 at the beginning of the year and $365,000 at year-end. During the year, it sold equipment with an original cost of $25,000. The accumulated depreciation balance began at $110,000 and ended at $137,000. The sold equipment had accumulated depreciation of $13,000; its sale proceeds were $16,000. Records also show that new equipment was acquired partly for cash and partly by issuing a note: $60,000 was paid in cash and $30,000 was financed. Depreciation expense for the year was $40,000. Identify the information relevant to cash-flow preparation.

Method. Reconcile the equipment cost and accumulated depreciation accounts, then use the transaction records to identify cash and noncash events.

Equipment cost rollforward. Let additions be the amount needed to reconcile the historical-cost account. Beginning cost plus additions minus the cost of equipment sold equals ending cost:

$$ \$300{,}000 + \text{Additions} - \$25{,}000 = \$365{,}000 $$

Therefore, additions were $365,000 − $300,000 + $25,000 = $90,000. The transaction detail confirms the composition: $60,000 cash plus $30,000 financed equals $90,000 of additions.

Accumulated depreciation check. Beginning accumulated depreciation plus depreciation expense minus accumulated depreciation removed with the sale gives the ending balance:

$$ \$110{,}000 + \$40{,}000 - \$13{,}000 = \$137{,}000 $$

The equation agrees with the reported ending balance. The sold equipment’s book value was $25,000 − $13,000 = $12,000. The proceeds were $16,000, so the sale produced a gain of $16,000 − $12,000 = $4,000.

Cash and noncash identification. The $60,000 purchase payment and $16,000 sale proceeds are identified cash transactions. The $30,000 note-financed acquisition is noncash at the time of acquisition. The $40,000 depreciation expense is an expense recorded without a contemporaneous cash payment. The $4,000 gain is an income-statement amount arising from the sale, not a separate cash receipt.

Check. Cash paid for additions plus note-financed additions equals the reconciled additions: $60,000 + $30,000 = $90,000. Accumulated depreciation also reconciles to $137,000. This avoids the mistake of treating all $90,000 of equipment additions as a cash payment.

Income Statement Amounts Need Timing and Transaction Context

An income statement is essential source data, but its amounts are not a list of cash movements. Revenue may be recognized before collection, and an expense may be recognized before payment or paid in a different period. Some expenses, such as depreciation, do not involve a cash payment when recorded. Gains and losses can also affect reported income without being equal to the cash proceeds from a transaction.

The related balance-sheet accounts and transaction records help clarify these differences. A receivable can indicate that revenue has been recognized before collection; a payable can indicate that an expense or purchase has been recorded before payment. Those balances are clues about timing. They do not settle the cash amount unless the relevant transactions and other account movements are known.

Worked Example: Separating Earnings, Dividends, and Financing Events

A hypothetical company reports net income of $84,000, including depreciation expense of $18,000 and a $5,000 gain on the sale of an investment. It declared dividends of $20,000. Dividends payable were $4,000 at the beginning of the year and $8,000 at year-end. Transaction records show that the company issued common shares for $30,000 cash, issued shares worth $12,000 in exchange for equipment, and issued bonds for $50,000 cash. Identify which amounts directly document cash activity and reconcile the dividend payment.

Method. Treat the income statement as accrual-basis information, distinguish each financing transaction by whether cash changed hands, and use the payable account to reconcile declared and paid dividends.

Dividends. Assuming the payable account had no other changes, beginning dividends payable plus dividends declared minus dividends paid equals ending dividends payable. Thus:

$$ \$4{,}000 + \$20{,}000 - \text{Dividends paid} = \$8{,}000 $$

Dividends paid were therefore $4,000 + $20,000 − $8,000 = $16,000. The $20,000 declaration is not itself the cash payment; the balance change shows that $4,000 remained payable at year-end.

Share and bond transactions. The $30,000 share issuance and $50,000 bond issuance are cash receipts because the records state that cash was received. Together, those identified financing receipts are $30,000 + $50,000 = $80,000. The $12,000 share issuance for equipment is a noncash exchange: shares were issued, but no cash changed hands in that transaction.

Income-statement items. Net income of $84,000 is not a cash total. The $18,000 depreciation expense is noncash when recorded, and the $5,000 gain is not the sale’s cash proceeds. The proceeds are not supplied here, so they cannot be inferred from the gain alone.

Check. The dividend calculation reconciles: $4,000 + $20,000 − $16,000 = $8,000. The identified cash financing receipts are $80,000, and the $12,000 equipment exchange is noncash. This avoids confusing income, declarations, or noncash exchanges with cash received or paid.

A Practical Review Before Preparing the Statement

A disciplined review keeps the preparation process grounded in evidence. The following sequence helps identify what is known and what still needs support.

1
Compare beginning and ending balances.
Calculate the net change for relevant accounts. Treat it as a balance movement, not a cash flow.
2
Read the income statement.
Identify revenues, expenses, gains, and losses, while remembering that reported income uses accrual accounting.
3
Inspect transaction details.
Identify the accounts affected, the timing, and whether cash changed hands. Separate cash transactions from accruals and noncash events.
4
Reconcile unexplained changes.
Use account rollforwards and supporting records to check whether the identified events explain the beginning-to-ending movement.
5
Mark what remains unknown.
If the supplied information does not establish a cash amount, do not infer one from an incomplete balance change or income-statement figure.

Common Mistakes and an Exam Trap

A frequent mistake is to assume that every increase in an asset is a cash outflow and every decrease is a cash inflow. That conclusion ignores events such as credit purchases, note-financed acquisitions, write-offs, depreciation, and asset disposals. A second mistake is to treat income-statement amounts as if they were cash amounts merely because they are reported for the period.

Wrong calculation: If inventory falls from $48,000 to $43,000, the balance-sheet comparison shows a $5,000 decrease. Calling that decrease a $5,000 cash receipt is incorrect: inventory is not cash, and the change alone does not establish a cash receipt. Likewise, if equipment additions total $90,000 but $30,000 was financed with a note, calling the entire $90,000 a cash purchase overstates the identified cash payment by $30,000.

Correction: State what the source establishes. The inventory balance fell by $5,000; additional transaction information is needed to identify the events behind that movement. The equipment records show $90,000 of additions, of which $60,000 was paid in cash and $30,000 was financed. This distinction is aligned with the SOA VEE Accounting and Finance syllabus.

Key takeaway: Comparative balance sheets show where balances began and ended; income statements show accrual-basis performance; transaction details explain the events in between. Cash-flow preparation depends on separating cash activity from accrual and noncash changes rather than treating reported changes or earnings as cash by default.

Check Your Understanding

For each problem, identify what the stated source data establish. Do not assume a balance change is a cash flow unless the transaction information supports that conclusion.

  1. Accounts receivable rises from $46,000 to $51,000. The records also identify a $2,000 write-off and a customer payment of $173,000. What is the net receivable change, and which of the two specified events is a cash transaction? (Answer: Receivables increased by $5,000; the $173,000 payment is cash, while the $2,000 write-off is noncash.)
  2. Equipment at cost rises from $140,000 to $166,000. Equipment with an original cost of $12,000 was sold, and transaction records show cash purchases of $30,000 plus an acquisition financed by an $8,000 note. What total additions are implied, and how much of those additions was paid in cash? (Answer: Additions were $38,000; $30,000 was paid in cash and $8,000 was noncash note financing.)
  3. A company declared dividends of $9,000. Dividends payable were $2,000 at the beginning of the period and $5,000 at the end, with no other changes in the payable account. How much cash was paid? (Answer: $6,000, since $2,000 + $9,000 − $5,000 = $6,000.)
  4. Net income is $42,000 and includes $7,000 of depreciation expense and a $3,000 gain on an asset sale. The company paid $20,000 cash for equipment, issued shares for $11,000 cash, and issued shares worth $6,000 in exchange for equipment. Which stated amounts directly identify cash transactions, and what is the total of the identified cash transactions? (Answer: The $20,000 equipment payment and $11,000 share issuance are cash transactions, totaling $31,000 of identified cash activity; the $6,000 exchange and the depreciation entry are noncash, and the gain does not specify sale proceeds.)
  5. A company reports sales of $260,000 and ending accounts receivable of $34,000, compared with beginning receivables of $27,000. Transaction records identify a $1,000 receivable write-off, but no details of collections or other receivable adjustments are available. Can total customer cash receipts be determined from these facts alone? Explain briefly. (Answer: No. The $7,000 net receivable increase and $1,000 noncash write-off do not fully establish the cash receipts without complete information about sales on credit, collections, and other receivable activity.)
Clinical Biostats