Tutorials › VEE Accounting and Finance › Reconciling Beginning and Ending Cash

VEE Accounting and Finance · Statement Linkages and Interpretation · Tutorial 193 of 996

Reconciling Beginning and Ending Cash

Build and check a complete cash roll-forward, including the sign and scope checks needed to reconcile the cash flow statement with balance-sheet cash.

Intermediate 12 min read

What You'll Learn

  • Set up the beginning-to-ending cash reconciliation using operating, investing, and financing cash flows.
  • Include a separately reported foreign-exchange effect when the statement requires one.
  • Reconcile the cash flow statement’s ending cash and cash equivalents to the balance sheet.
  • Calculate operating cash flow from supplied indirect-method adjustments without confusing working-capital signs.
  • Detect arithmetic and scope mismatches between cash flow statement subtotals and balance-sheet amounts.

Why Cash Must Reconcile

The cash flow statement explains how an entity moved from its cash position at the start of a reporting period to its cash position at the end. It organizes cash flows into operating, investing, and financing activities. The ending amount is not an independent estimate: it must reconcile to the relevant cash and cash-equivalent amount reported for the same date on the balance sheet.

A reconciliation is useful because it checks both classification and arithmetic. For example, a positive financing cash flow does not automatically mean cash increased overall: operating or investing outflows may be larger. Likewise, a correctly computed net change does not establish that the ending balance is right unless the beginning balance and the statement’s definition of cash match the balance sheet amounts.

Definition: Let \(C_0\) be cash and cash equivalents at the beginning of the period and \(C_1\) be cash and cash equivalents at the end. Let \(\mathrm{CFO}\), \(\mathrm{CFI}\), and \(\mathrm{CFF}\) be net cash flows from operating, investing, and financing activities, respectively. If a separate foreign-exchange effect on cash and cash equivalents, \(\mathrm{FX}\), is reported, then the reconciliation is
$$ C_1=C_0+\mathrm{CFO}+\mathrm{CFI}+\mathrm{CFF}+\mathrm{FX}. $$
If there is no separately reported foreign-exchange effect, use \(\mathrm{FX}=0\). Each net cash flow is inflows minus outflows; an outflow therefore has a negative sign.

Here, “cash and cash equivalents” means the amount defined for the cash flow statement and used consistently in the reconciliation. Cash equivalents are short-term, highly liquid investments that meet the applicable accounting definition; they are not every investment that could eventually be sold for cash. The balance-sheet presentation may show cash and cash equivalents on one line or in more than one line. In either case, compare the same total at the same reporting date. Do not reconcile a cash-flow-statement total that includes cash equivalents to a balance-sheet figure that includes only cash on hand or at banks.

The operating, investing, and financing subtotals are net amounts for the period, not ending account balances. They are flows measured over an interval; \(C_0\) and \(C_1\) are balances measured at particular dates. This is why the reconciliation adds the three activity totals to the beginning balance rather than comparing one of those totals directly with balance-sheet cash.

Deriving the Cash Roll-Forward

The formula follows from the meaning of a cash flow. A cash inflow increases the cash balance, and a cash outflow decreases it. If all cash-affecting activity is grouped into the three activity categories and any separately presented exchange-rate effect, the total change in cash is the sum of those signed amounts.

1
Define the period change.
The change in the cash balance is the ending balance minus the beginning balance: \(\Delta C=C_1-C_0\).
2
Partition the change.
By the cash flow statement’s categories, the same change is \(\Delta C=\mathrm{CFO}+\mathrm{CFI}+\mathrm{CFF}+\mathrm{FX}\), including \(\mathrm{FX}\) only when applicable.
3
Solve for ending cash.
Add \(C_0\) to both sides of \(C_1-C_0=\mathrm{CFO}+\mathrm{CFI}+\mathrm{CFF}+\mathrm{FX}\). The result is \(C_1=C_0+\mathrm{CFO}+\mathrm{CFI}+\mathrm{CFF}+\mathrm{FX}\).

This is an accounting reconciliation, not a forecast or valuation model. It assumes the amounts cover the same reporting period and use the same cash definition. Each cash flow must be included once, with its correct sign and category; the exchange-rate effect is included separately only when reported as a separate reconciling item. The calculation does not use noncash income or expenses as if they were cash movements. Under the indirect method, adjustments are used to calculate operating cash flow, but the resulting operating subtotal—not net income alone—is the amount included in this roll-forward.

Worked Example: Reconcile Three Activity Totals and an Exchange Effect

A hypothetical firm begins the year with cash and cash equivalents of $84,500. Its statement reports operating cash flow of $36,200, investing cash flow of negative $17,500, financing cash flow of positive $1,000, and a foreign-exchange effect of negative $600. Calculate the net change and ending cash, then state the balance-sheet amount that should agree.

Method. Use the roll-forward, preserving the sign of each reported subtotal. The negative investing amount and negative exchange effect reduce cash.

Step 1: Add operating and investing cash flows. \(36{,}200+(-17{,}500)=18{,}700\).

Step 2: Add financing cash flow. \(18{,}700+1{,}000=19{,}700\).

Step 3: Include the exchange effect. \(19{,}700+(-600)=19{,}100\). The net increase in cash and cash equivalents is $19,100.

Step 4: Add the increase to beginning cash. \(84{,}500+19{,}100=103{,}600\). The ending cash and cash-equivalent balance is $103,600.

Check. Subtract the beginning balance from the calculated ending balance: \(103{,}600-84{,}500=19{,}100\), matching the net increase. The balance sheet at year-end should report cash and cash equivalents totaling $103,600.

Common mistake avoided. Omitting the separately reported negative $600 exchange effect would produce a net increase of $19,700 and ending cash of $104,200. That calculation does not include every stated reconciling item, so it cannot reconcile to the correct cash flow statement total.

From Operating Cash Flow to Ending Cash

Sometimes the activity subtotals are supplied directly. In other problems, operating cash flow must first be calculated from information such as net income, depreciation, and working-capital changes. The indirect-method adjustments explain why operating cash flow can differ from net income; once \(\mathrm{CFO}\) has been calculated, it enters the cash roll-forward as one signed subtotal.

For working-capital adjustments under the indirect method, an increase in an operating asset such as receivables generally uses cash relative to recognized income, while an increase in an operating liability such as payables generally preserves cash relative to recognized expense. The signs depend on the account change and the operating cash-flow reconciliation being used. Check the supplied adjustments before adding them to net income.

Worked Example: Calculate Operating Cash Flow, Then Reconcile

A hypothetical equipment service firm reports beginning cash of $250,000. For the year, it has net income of $48,000 and depreciation expense of $12,000. Accounts receivable increased by $9,000, inventory decreased by $4,000, accounts payable increased by $6,000, and income taxes payable decreased by $2,000. The firm paid $31,000 for equipment and received $3,000 from an asset sale. It borrowed $20,000, repaid $15,000 of debt, paid $10,000 in dividends, and issued shares for $5,000. There is no separate foreign-exchange effect. Calculate operating cash flow and ending cash.

Method. First build the indirect-method operating subtotal using the stated adjustments. Then calculate the investing and financing subtotals and apply the cash roll-forward.

Step 1: Begin with net income and add depreciation. Depreciation reduced accounting income but is not a cash payment in this period, so the supplied indirect-method adjustment is positive: \(48{,}000+12{,}000=60{,}000\).

Step 2: Apply the operating asset and liability changes. The receivables increase is negative $9,000; the inventory decrease is positive $4,000; the payables increase is positive $6,000; and the taxes-payable decrease is negative $2,000. Therefore, \(60{,}000-9{,}000+4{,}000+6{,}000-2{,}000=59{,}000\). Operating cash flow is $59,000.

Step 3: Calculate investing cash flow. The equipment purchase is a $31,000 outflow and the asset-sale proceeds are a $3,000 inflow: \(\mathrm{CFI}=-31{,}000+3{,}000=-28{,}000\).

Step 4: Calculate financing cash flow. Borrowing and share issuance are inflows; debt repayment and dividends are outflows: \(\mathrm{CFF}=20{,}000-15{,}000-10{,}000+5{,}000=0\).

Step 5: Reconcile ending cash. \(250{,}000+59{,}000-28{,}000+0+0=281{,}000\). Ending cash is $281,000, and the net increase is \(281{,}000-250{,}000=$31{,}000\).

Check. The activity totals also give \(59{,}000-28{,}000+0=$31{,}000\). Adding this change to the $250,000 beginning balance returns $281,000.

Common mistake avoided. Adding the $9,000 receivables increase or subtracting the $6,000 payables increase would reverse the supplied working-capital adjustments. For example, reversing only those two signs would overstate operating cash flow by \(18{,}000-12{,}000=$6{,}000\), producing $65,000 rather than $59,000. The decrease in taxes payable must also remain a negative adjustment.

Reconcile the Statement to the Balance Sheet

A complete check has two parts. First, verify that the reported ending amount equals beginning cash plus the signed cash-flow components. Second, verify that the ending amount agrees with cash and cash equivalents on the balance sheet for the same date and on the same measurement basis. The first check tests the arithmetic of the cash flow statement; the second tests consistency between statements.

If those checks disagree, do not force the numbers to match by changing a sign without evidence. Re-add each component, confirm the reporting period, check whether the foreign-exchange effect is included, and make sure the cash amount is defined consistently. A difference is a reconciliation issue to investigate, not a reason to treat the balance sheet as automatically wrong or the cash flow statement as automatically right.

Worked Example: Locate an Inconsistent Ending Amount

A hypothetical company reports beginning cash and cash equivalents of $91,600. Its cash flow statement lists operating cash flow of negative $6,400, investing cash flow of negative $18,500, financing cash flow of positive $27,000, and a positive exchange effect of $300. The statement also reports a net increase of $1,900 and ending cash of $93,500. The year-end balance sheet reports cash and cash equivalents of $94,000. Determine whether the reported amounts reconcile and identify the inconsistency.

Method. Independently add the signed components, then use that result to calculate the ending balance. Compare both results with the reported statement and balance sheet figures.

Step 1: Sum operating and investing flows. \(-6{,}400-18{,}500=-24{,}900\).

Step 2: Add financing cash flow and the exchange effect. \(-24{,}900+27{,}000=2{,}100\), and \(2{,}100+300=2{,}400\). The components imply a net increase of $2,400, not $1,900.

Step 3: Calculate ending cash from the components. \(91{,}600+2{,}400=94{,}000\). The implied ending amount agrees with the balance sheet.

Step 4: Test the statement’s own reported net increase. \(91{,}600+1{,}900=93{,}500\), so the statement’s reported net increase and reported ending amount agree with each other. However, the listed components do not produce that net increase. They exceed it by \(2{,}400-1{,}900=$500\).

Conclusion and check. The listed components imply $94,000 of ending cash, matching the balance sheet. The inconsistency is within the cash flow statement’s reported net increase and ending amount: each is $500 below what its listed components and the beginning balance imply. This calculation identifies the discrepancy; it does not establish which reported line should be changed without further evidence.

Common mistake avoided. Accepting the reported $1,900 net increase without summing the listed components would miss the $500 inconsistency. Also, adding positive amounts while dropping the negative signs would not be a valid reconciliation.

Common Reconciliation Traps

  • Reversing the roll-forward. The net increase is \(C_1-C_0\), so ending cash equals beginning cash plus the net increase—not the reverse.
  • Treating outflows as positive. Net activity cash flows are inflows minus outflows. A negative CFI or CFF amount must reduce the running total.
  • Mixing net change with ending cash. The activity totals produce the change during the period; add that change to beginning cash to obtain the ending balance.
  • Leaving out an exchange effect. Include a separately presented foreign-exchange effect in the reconciliation. Do not add it again if it is already included in a supplied total.
  • Comparing different cash definitions. Reconcile the cash-flow-statement amount to the balance-sheet amount on the same cash-and-cash-equivalent basis and at the same date.
  • Using net income as operating cash flow. Net income is not interchangeable with \(\mathrm{CFO}\). Calculate the operating subtotal using the information provided before using it in the cash roll-forward.
Key takeaway: Check the full identity \(C_1=C_0+\mathrm{CFO}+\mathrm{CFI}+\mathrm{CFF}+\mathrm{FX}\), using signed amounts and consistent cash definitions. Then confirm that the calculated \(C_1\) agrees with balance-sheet cash and cash equivalents at the period end.

Check Your Understanding

For each problem, use signed cash flows and compare the calculated ending amount with any reported balance-sheet figure.

  1. A hypothetical business begins with cash and cash equivalents of $18,200. Its operating, investing, and financing cash flows are $4,600, negative $7,100, and $2,000, respectively, with no separate exchange effect. What is ending cash? (Answer: $17,700.)
  2. A hypothetical firm begins with $120,000. It reports operating cash flow of $17,500, investing cash flow of negative $22,800, financing cash flow of $9,000, and a positive exchange effect of $300. Calculate the net change and ending cash. (Answer: Net increase $4,000; ending cash $124,000.)
  3. A hypothetical company starts with cash of $50,000. Net income is $32,000; depreciation is $8,000; receivables increase by $5,000; inventory decreases by $2,000; and accounts payable increase by $3,000. Investing cash flow is negative $16,000. Financing cash flows are a $4,000 dividend, $10,000 of borrowing, and $6,000 of debt repayment. There is no exchange effect. Calculate operating cash flow and ending cash. (Answer: Operating cash flow $40,000; ending cash $74,000.)
  4. A hypothetical entity begins with $70,000. Its operating, investing, and financing cash flows are $11,000, negative $6,500, and negative $2,000, and its exchange effect is positive $100. The statement reports ending cash of $72,000. Calculate the ending cash implied by the components and the discrepancy. (Answer: Implied ending cash $72,600; the reported amount is $600 too low.)
  5. A hypothetical company reports beginning cash of $12,000 and beginning cash equivalents of $38,000 on its balance sheet. At period end, the corresponding balances are $17,000 and $41,000. Its cash flow statement reports operating cash flow of $9,000, investing cash flow of negative $15,000, financing cash flow of $8,000, and an exchange effect of negative $1,000. Does the ending balance reconcile? (Answer: The components imply ending cash and cash equivalents of $51,000; the balance sheet total is $58,000, so it does not reconcile, with a $7,000 difference.)
Clinical Biostats