Book · Julian R. Sterling

The Statement of Cash Flows Handbook

ASC 230 for Preparers: The Indirect and Direct Methods, Restricted Cash, the ASU 2016-15 Classification Issues, Foreign Currency, Acquisitions and Review Controls, with IAS 7 Comparisons

About the book

Cover of The Statement of Cash Flows Handbook

The statement of cash flows is prepared last and read first. For one fictional manufacturer, the indirect method rebuilt from two balance sheets and the direct method summed from tagged cash entries both give net cash provided by operating activities of $22,977,275 for 2026, after an acquisition, a refinancing, a receivables sale, an earn-out and a subsidiary in euros have each been sent to the right class, once.

The Statement of Cash Flows Handbook is a practitioner's guide to preparing the statement under ASC 230, with IAS 7 compared side by side: cash, cash equivalents and restricted cash, the three classes and the order of the rules, the indirect worksheet line by line, the direct method and its proofs, working capital bridges, interest and income taxes paid with the ASU 2023-09 disaggregation, investing and financing sections, the eight ASU 2016-15 issues, noncash disclosures, supplier finance and receivables programs, foreign currency, business combinations, consolidation, the traps a reviewer looks for, and the monthly routine that keeps the statement running. One company is followed through 2025 and 2026, and every figure comes from one model.

What you will be able to do:

Eighteen chapters and four appendices: a guide to the companion workbook with ten exercises, the preparer's toolkit, twenty-four practice questions with answers, and a glossary.

Written for controllers, senior accountants, financial reporting managers, auditors and lenders' analysts who prepare, review or rely on a statement of cash flows. The case, its companies, its people and its places are fictional, and its figures are teaching assumptions; the standards are paraphrased as read in November 2026. This book is for education only. It is not accounting, legal, tax or investment advice. Part of The Private Markets Career Guides.

How this book was made: written with the help of artificial intelligence tools, under the author's direction; every figure was computed by a model and every rule was checked against its source.

Read next: How do you prepare a cash flow statement with the indirect method?

Read next: How is restricted cash shown in the statement of cash flows?

Read next: How do acquired balances affect working capital changes in the cash flow statement?

Free: the indirect method cash flow statement template in Excel

From two balance sheets and an income statement to the indirect statement of cash flows: working capital bridges, noncash items, a cash roll and a control that must read zero. Live formulas, no macros, nothing locked.

Get the free template →

Companion files

The workbook that rebuilds every figure of the book, free, no sign-up. It builds Halverick's statement of cash flows twice, from the tagged cash entries and from the balance sheets, bridges every working capital line, splits the ASU 2016-15 payments, translates the euro subsidiary, lists the noncash activities and the disclosures, and ends with a Checks tab that must read ALL PASS.

Three numbers to reproduce first

Operating, two ways$22,977,275 from the cash entries tagged operating, and the same $22,977,275 rebuilt from net income of $11,042,775 through the noncash items and the working capital lines
Receivables bridgea balance sheet change of $592,000, less $3,200,000 acquired with Pellham, less translation of ($253,000), leaves a decrease of $2,355,000, an inflow of $2,355,000 in the 2026 statement
Acquisition line$22,000,000 - $1,400,000 + $300,000 = $20,900,000: cash at closing, less cash acquired, plus the true-up paid soon after, in investing

The statement in four lines

Section20252026
Net cash provided by operating activities$12,709,338$22,977,275
Investing activities($7,708,000)($25,215,000)
Financing activities($2,760,000)$11,586,800
Effect of exchange rate changes on cash$192,250($238,875)
Total cash, cash equivalents and restricted cash at year end$10,181,588$19,291,788

What is inside

Also by Julian R. Sterling

Related titles. The full list is on the author page.

The workbook is provided as it is, without warranty of any kind. Halverick Flow Systems, Inc. and its people are fictional; exchange rates, interest rates, tax amounts and terms are the book’s teaching assumptions, not market data. Not accounting, legal, tax or investment advice.