How to Prepare a Cash Flow Statement, Step by Step
By Newtown Analytics · · 8 min read
For finance, fp&a & accounting managers
How to prepare a cash flow statement: start with net income, adjust for non-cash items and changes in working capital to get operating cash flow, add investing and financing activities from the balance sheet changes, and confirm that the result ties to the change in cash. This guide shows the indirect method step by step with a complete example. The statement is a core tool in cash flow management, and once you have the pattern you can build one in under an hour.
What you need before you start
- The income statement for the period
- The balance sheets at the start and end of the period
- Notes on unusual transactions such as asset sales, new loans and owner contributions
The principle is that every change in a balance sheet account has a cash effect. By analyzing each change you reconstruct where cash came from and went.
The step-by-step method
Step 1: Set up the three sections
Create blocks for operating, investing and financing activities, followed by a reconciliation of cash at the beginning and end of the period.
Step 2: Start with net income
Take net income from the income statement. This is the first line of operating activities in the indirect method.
Step 3: Add back non-cash expenses
Depreciation and amortization reduce net income but do not use cash. Add them back. Also adjust for other non-cash items such as stock compensation and impairments.
Step 4: Adjust for changes in working capital
Compare each operating asset and liability from the beginning to the end of the period.
| Account type | If it increased | If it decreased |
|---|---|---|
| Operating assets (receivables, inventory, prepaid) | Subtract (cash used) | Add (cash released) |
| Operating liabilities (payables, accrued expenses) | Add (cash retained) | Subtract (cash paid) |
Step 5: Remove gains and losses from asset sales
A gain on selling equipment is in net income, but the sale proceeds belong in investing. Subtract gains, and add back losses, in the operating section.
Step 6: Analyze investing activities
Look at the long-term asset accounts. Purchases of equipment are outflows. Proceeds from sales are inflows. Calculate the purchase as the change in gross equipment plus the cost of anything disposed of.
Step 7: Analyze financing activities
Look at debt and equity. Increases in loans are inflows, and decreases are outflows. Owner contributions are inflows, and distributions and dividends are outflows.
Step 8: Reconcile the cash
Add the three sections to get the net change in cash. Add it to beginning cash. The result must equal the ending cash on the balance sheet. If it does not, there is an error to find.
A complete worked example
A hypothetical company has the following data, in thousands of dollars.
Income statement: net income $120, which includes depreciation of $30.
Balance sheets:
| Account | Beginning | Ending | Change |
|---|---|---|---|
| Cash | 89 | 50 | -39 |
| Accounts receivable | 80 | 110 | +30 |
| Inventory | 120 | 150 | +30 |
| Prepaid expenses | 10 | 12 | +2 |
| Equipment (gross) | 300 | 380 | +80 |
| Accumulated depreciation | 90 | 120 | +30 |
| Accounts payable | 60 | 75 | +15 |
| Accrued expenses | 20 | 18 | -2 |
| Loan payable | 150 | 130 | -20 |
| Common stock | 79 | 79 | 0 |
| Retained earnings | 200 | 280 | +80 |
Retained earnings rose by $80 even though net income was $120, which tells us owners took distributions of $40. No equipment was sold, so the gross equipment increase of $80 is the purchase.
Operating activities
| Line | Amount | Reason |
|---|---|---|
| Net income | 120 | Starting point |
| Depreciation | +30 | Non-cash expense |
| Increase in accounts receivable | -30 | Sales not yet collected |
| Increase in inventory | -30 | Stock purchased |
| Increase in prepaid expenses | -2 | Paid in advance |
| Increase in accounts payable | +15 | Bills not yet paid |
| Decrease in accrued expenses | -2 | Paid more than expensed |
| Net cash from operating activities | 101 |
Investing activities
| Line | Amount |
|---|---|
| Purchase of equipment | -80 |
| Net cash from investing activities | -80 |
Financing activities
| Line | Amount |
|---|---|
| Repayment of loan | -20 |
| Owner distributions | -40 |
| Net cash from financing activities | -60 |
Reconciliation
Net change in cash = 101 - 80 - 60 = -39. Beginning cash of 89 minus 39 equals ending cash of 50, which matches the balance sheet. The statement is complete and correct.
Handling a sale of equipment
Asset sales add a step because of the gain or loss. Suppose the company above had also sold an old machine with an original cost of $40 and accumulated depreciation of $30 (net book value $10) for $14 in cash. The gain is $4, and it is included in net income.
| Adjustment | Where | Amount |
|---|---|---|
| Subtract the gain | Operating activities | -4 |
| Proceeds from the sale | Investing activities | +14 |
The gain is removed from operating cash flow because it is not part of ordinary operations, and the full $14 of proceeds appears in investing. Without the adjustment the $4 would be counted twice, once inside net income and once inside the $14. Equipment purchases also change: if gross equipment rose by $80 after disposing of a $40 asset, you purchased $120 of equipment, because the closing balance equals the opening balance plus purchases minus disposals at cost.
Building the statement from a trial balance
Many small companies work from an adjusted trial balance rather than formal statements. The method is the same, and a spreadsheet helps:
- List every balance sheet account in rows, with beginning and ending balances in columns.
- Add a column for the change.
- Add a column that labels each account as operating, investing, financing or cash.
- Add a column for the cash effect, using the rule that asset increases are negative and liability or equity increases are positive.
- Sum each label to produce the three sections, and check the total against the change in cash.
The last step acts as an automatic proof. If the sum of the cash effects across all non-cash accounts, plus net income, does not equal the change in cash, an account is misclassified or missing.
Checking your work
A good statement passes several tests.
- Ending cash matches. This is the primary test.
- Net income matches the income statement.
- Every balance sheet change is accounted for. Go through each account and make sure its change appears somewhere.
- Signs make sense. Asset increases reduce cash, and liability increases raise cash.
- Investing and financing items are identified. Compare with the notes for loans, asset sales and capital contributions.
If you are out of balance by a small amount, look for a missed account, an arithmetic error, a gain or loss not reversed, or a non-cash transaction.
Common mistakes
- Reversing signs on working capital. Memorize: assets up means cash down; liabilities up means cash up.
- Treating depreciation as a cash flow. It is added back because no cash moved.
- Putting loan principal in operating activities. It belongs in financing.
- Forgetting to separate gains from asset sales. The proceeds go in investing.
- Using ending balances only. The statement is built from changes during the period.
- Ignoring non-cash transactions. If you bought equipment with seller financing, no cash moved. Disclose it in a note.
Direct method alternative
If you prefer to present the direct method, you convert accrual figures into cash figures: cash collected equals sales minus the increase in receivables, and cash paid to suppliers equals cost of goods sold plus the increase in inventory minus the increase in payables. The comparison and when to use each is in direct vs. indirect cash flow statements.
Tips for monthly preparation
- Close the books first, because a statement built on unreconciled accounts inherits their errors.
- Use a consistent template each month, so differences stand out, like the cash flow statement template.
- Review working capital movements with the people who control them. If inventory rose, ask purchasing and planning why. For product companies, aligning purchasing with realistic forecasts is a major driver, covered in demand planning and inventory optimization.
- Compare against the cash forecast, and investigate the biggest variances.
- Keep notes of unusual items so next period's reader understands them.
After you have prepared one, practice reading it with the routine in what cash flow is.
FAQs
What is the easiest way to prepare a cash flow statement?
Use the indirect method with an income statement and two balance sheets. Start with net income, adjust for non-cash items and working capital changes, then add investing and financing items from the balance sheet.
Can I prepare a cash flow statement without a balance sheet?
Not reliably in the indirect method. The balance sheet changes are what you need to reconcile profit to cash. If you track cash receipts and payments directly, you can prepare a direct statement from those records.
How often should I prepare it?
Monthly for most businesses, so that you can compare actual cash to the forecast and spot problems early. Quarterly and annual versions are needed for lenders and tax and reporting purposes.
What if my statement does not balance?
Check that every balance sheet account change is reflected, that the signs are right, and that net income and depreciation match the income statement. Missing a small account is the most common cause.
Do I need an accountant to prepare it?
Not necessarily for internal use. An accountant is helpful for formal statements, unusual transactions such as leases or acquisitions, and for ensuring the classification follows applicable standards.
Keep reading
- Complete guide: Cash Flow Management: The Complete Guide for Growing Businesses
- Cash Flow Statement Template for Excel and Google Sheets
- What Is Cash Flow? A Plain-English Guide for Business Owners
- Cash Flow vs. Profit: Why Profitable Companies Still Run Out of Cash
- Related topic: Demand Planning and Inventory Optimization: The Complete Guide
This article is for general information. It is not accounting, tax, legal or investment advice, and examples use illustrative numbers rather than client data. Confirm decisions that carry financial or legal consequences with a qualified professional.