Cash Flow Calculation Schedule

The Problem

"Why doesn't my cash flow tie?" is the single most-asked question on the desk of a working accountant. You remember the indirect-method format - start with net income, add back depreciation, adjust for working capital changes - and you can recite it. But the walk you typed out comes up off by some amount, and now you are hunting for the missing piece without a method.

Was it deferred taxes? A reclass between current and long-term debt? A goodwill impairment buried in operating expenses? A net capex figure that already absorbed depreciation? The format you memorized does not survive contact with a real company, because the format is what the statement looks like — not how it was built.

The build is: every change in every balance sheet account has to be explained by exactly one line in your cash flow statement, and the sum of those lines has to equal the change in cash. If a balance sheet movement has no home in your walk, you have your bug. The Check row is the diagnostic.

The Build

The workbook implements one rule. Take the prior-year and current-year balance sheet. Compute the change in every account. Now line up your cash flow walk so that every line you write sits in the same column as the BS account it derives from. When you have placed every cash flow line, sum each BS column. That sum must equal the change in that BS account. If it does, every column in the Check row reads zero. If a column shows a nonzero number, you have a balance sheet movement that has not been explained.

The mechanical rules drop out of one identity: assets up = cash out, assets down = cash in, liabilities and equity up = cash in, liabilities and equity down = cash out. The signs are not memorized; they are forced by the BS column they live in.

Gross balances + contra accounts (the 10-K convention)

The workbook splits the three asset balances that have meaningful contra accounts:

• A/R Gross + Allowance for Bad Debt. Net A/R = Gross + Allowance (allowance is stored as a negative). Change in Gross A/R drives the working-capital line; change in Allowance IS bad debt expense for the period (a non-cash add-back).
• Fixed Assets Gross + Accumulated Depreciation. Capex = -(Change in Gross FA). Depreciation = -(Change in Accumulated Depreciation). Both are clean, direct calculations from the balance sheet - no "back into capex by adding D&A to the net change" workaround.
• Identifiable Intangibles Gross + Accumulated Amortization. Same split. Purchases of intangibles becomes its own investing line; amortization falls out of the contra change.

Goodwill stays as a single line because most companies do not carry an accumulated-impairment contra - any writedown reduces gross goodwill directly, and the cash flow walk treats the negative change as a non-cash impairment add-back. The Check row at the bottom of the cash flow walk reads zero across every column when the walk is internally consistent with the balance sheet. That is what tying out means.

What's in the Workbook

The layout convention is the pedagogical core. Column B is the single-column "Amount ($)" - read it top-to-bottom and you have your indirect-method statement. Columns C onward hold the BS tie-out - read across to see which balance sheet account each cash flow line explains. Both views are the same numbers, arranged so the build is visible.

What this workbook actually does

Most cash flow material shows the statement format. This shows you how to build the statement from the balance sheet, line by line, with the BS-to-CF tie-out proven by the Check row across every column. Read column B top-to-bottom and you have your indirect-method statement. Read column C onward across each line and you see exactly which balance sheet account that cash flow line explains. Both views are the same numbers, arranged so the build is visible.

The Example tab is the proof — pre-populated teaching numbers, full walk, Check row all zeros. The Your Company tab is the working file — yellow input cells for your PY/CY balance sheet plus four non-cash items (NI, D&A, amortization, impairment), and everything else, including the single-column Amount answer, calculates. Nothing about the tool is novel pedagogy. It is the approach a working controller would walk through at a whiteboard with a new staff accountant, captured in a file you can actually open and use on a live company.

Most of the people who download this aren't credentialed. They're the bookkeeper at a 12-person business who's been told to produce a cash flow statement and has no idea where to start. The office manager whose boss wants to know why cash is going down when sales are up. The founder doing his own books because his accountant is too expensive to call every month. The family-business successor learning the books her uncle ran for thirty years. They don't have an accounting degree, they will never sit for the CPA, and the textbook format never quite told them how to actually build the thing. This workbook is for them. It is also for the working controller, the fractional CFO, the search-fund operator in his first 90 days, the finance lead at a startup, and the junior accountant who keeps getting the cash flow to not quite tie. Built for the actual close, not for a test.

Who it's for

Most working accountants for small business don't have a CPA or even an accounting degree. They are the bookkeeper, the office manager, the founder doing his own books. This workbook is written first for them — and also for the credentialed seats that hand it down.

Cross-references