SmallBizHandbookSmallBizHandbook

Free Cash Flow Statement Template

Last updated: 2026-10-03

A small business cash flow statement using the indirect method: start from net income, adjust for non-cash items and working capital, then add investing and financing activities. It checks that ending cash matches your balance sheet. Have a balance sheet and P&L saved? Let the template build the whole statement for you.

Line item
FY 2025
ended Dec 31
Cash flows from operating activities
$
$
$
$
$
$
$
$
$
Net cash provided by (used in) operating activities–
Cash flows from investing activities
$
$
$
Net cash provided by (used in) investing activities–
Cash flows from financing activities
$
$
$
$
$
Net cash provided by (used in) financing activities–
Net increase (decrease) in cash–
Cash at beginning of period
$
Cash at end of period–
Cash per balance sheet / bank, end of period (optional)
$
Check: calculated − actual ending cash (should be 0)✓ 0

Saved automatically in this browser only. Nothing is uploaded. Click next to a line to see what belongs there.

Automatic checks

  • Enter your figures, pull them from your saved statements, or load the example to run the checks.

Key ratios (per column)

Operating cash flow

—

Net cash from operating activities

Free cash flow

—

Operating cash flow − purchases of property and equipment

Cash conversion of profit

—

Operating cash flow ÷ net income

Cash runway

—

Ending cash ÷ average monthly negative free cash flow

How to prepare a cash flow statement (indirect method), step by step

  1. Gather three things: your P&L for the period, and balance sheets at the start and end of the period. (The fastest route: fill in the balance sheet with both dates and the P&L, then click Build from my balance sheet + P&L here.)
  2. Start with net income from the bottom of the P&L, and add back depreciation and amortization.
  3. Adjust for working capital. For each current asset and current liability, take the change between the two balance sheets and apply the signs in the cheat sheet below.
  4. Investing: cash paid for equipment, vehicles or property (outflow) and cash received from selling them (inflow).
  5. Financing: new loans (inflow), principal repaid (outflow), owner contributions (inflow) and owner draws or distributions (outflow).
  6. Reconcile. Enter beginning cash and the actual ending cash from your balance sheet. The template flags any difference so you can find the missing or misclassified item.

Cheat sheet: plus or minus?

Between the two balance sheets…Enter asWhy
Accounts receivable went upNegativeYou booked sales you haven't collected yet
Accounts receivable went downPositiveYou collected old invoices
Inventory went upNegativeCash turned into stock on the shelf
Prepaid expenses went upNegativeYou paid ahead for future months
Accounts payable went upPositiveYou received goods but haven't paid yet
Accrued wages / taxes went upPositiveExpenses recorded but not yet paid
Customer deposits went upPositiveCash received before the revenue was earned
Depreciation and amortizationPositive (add back)An expense that used no cash this period

Equipment purchases, loan repayments and owner draws are entered as positive amounts on their “outflow” lines. The template subtracts them.

Worked example: profitable, but cash went down

The same fictional Maple Street Bakery LLC from the P&L and balance sheet templates. Every figure below can be calculated from those two statements.

Maple Street Bakery LLC
Statement of Cash Flows
For the year ended December 31, 2025
(In U.S. dollars)
FY 2025
ended Dec 31
Cash flows from operating activities
Net income (loss)48,000
Depreciation and amortization18,000
(Increase) decrease in accounts receivable(3,200)
(Increase) decrease in inventory(1,500)
(Increase) decrease in prepaid expenses and other current assets300
Increase (decrease) in accounts payable2,600
Increase (decrease) in accrued expenses and other current liabilities1,000
Increase (decrease) in customer deposits and unearned revenue1,100
Net cash provided by (used in) operating activities66,300
Cash flows from investing activities
Purchases of property and equipment(26,000)
Net cash provided by (used in) investing activities(26,000)
Cash flows from financing activities
Repayments of loan principal(14,000)
Owner draws, distributions and dividends paid(30,000)
Net cash provided by (used in) financing activities(44,000)
Net increase (decrease) in cash(3,700)
Cash at beginning of period38,400
Cash at end of period34,700

Fictional company for illustration. Click “Load example” in the template above to explore these figures, then open the other two templates to see the same company's statements.

What it says: operations generated $66,300, more than net income of $48,000, mainly because $18,000 of depreciation is added back. Higher payables, accruals and customer deposits roughly offset the cash tied up in higher receivables and inventory. Free cash flow (operating cash flow minus $26,000 of equipment) was $40,300. Financing used $44,000: loan principal plus $30,000 of distributions. The net result was a $3,700 decrease in cash, and ending cash of $34,700 matches the balance sheet.

Common cash flow statement mistakes

  • Getting the working-capital signs backwards. An increase in receivables or inventory reduces cash. See the cheat sheet.
  • Forgetting to add back depreciation, or adding it back twice when it's already in a working-capital line.
  • Putting loan principal in operating activities. Principal is financing. Only interest is part of net income.
  • Counting financed equipment as a cash outflow when the lender paid the seller directly. That's a non-cash transaction. Disclose it in a note instead.
  • Beginning cash that doesn't match last period's ending cash. In monthly and quarterly views the template links them automatically.
  • Skipping the reconciliation. If calculated ending cash doesn't equal the balance sheet, something is missing.

How the balance sheet, P&L and cash flow statement connect

The three statements describe the same business from different angles. The profit and loss statement covers a period: did you make money? The balance sheet is a snapshot at the end of the period: what do you own and owe? The cash flow statement explains why cash changed between two balance sheets. Here's how the example bakery's 2025 figures flow between them:

FigureShows up inExample
P&L: net incomeCash flow: first line of operating activities$48,000
P&L: net incomeBalance sheet: equity (current-period net income)$48,000
P&L: depreciationCash flow: added back (non-cash). Balance sheet: accumulated depreciation rises by the same amount$18,000
Cash flow: ending cashBalance sheet: cash and cash equivalents$34,700
Cash flow: loan principal repaidBalance sheet: total loan balances fall$91,500 → $77,500
Cash flow: owner distributionsBalance sheet: subtracted in equity (never an expense on the P&L)$30,000

The bakery earned $48,000 in 2025, yet its cash fell from $38,400 to $34,700. Operations brought in $66,300, but it spent $26,000 on kitchen equipment and a delivery van, repaid loan principal and paid its owners $30,000. Profit and cash are different things, and you need all three statements to see both.

Shortcut: save your balance sheet (with a prior-date column) and your P&L, then click Build from my balance sheet + P&L on the cash flow template. It calculates every operating, investing and financing line for you.

What banks and SBA lenders ask for

  • Three years of history plus a current interim statement. SBA's lending rules for 7(a) loans base repayment analysis, for existing businesses, on “the three most recent years of historical financial information (tax returns or balance sheet with debt schedule and income statement) plus an interim financial statement.” Interim financial statements “must be dated within 120 days of submission to SBA.” (SBA SOP 50 10 8.1, effective Oct. 1, 2026)
  • Balance sheet and P&L dated the same day. SBA's 7(a) submission checklist asks for a “Current Income Statement and Balance Sheet – (both must be dated as of the same date within 120 days of submission to SBA).” Set the balance sheet date and the P&L period end to the same date. (SBA 7(a) Loan Submission Checklist, May 2024)
  • Ratios lenders calculate. The SOP lists current ratio, debt to tangible net worth and debt service coverage among the benchmark ratios. Debt service coverage is EBITDA divided by required principal and interest payments on all business debt. Standard 7(a) loans need at least 1.15:1 and 7(a) Small Loans at least 1.10:1. The balance sheet and P&L templates calculate all three.
  • Projections for new businesses. The checklist asks for “Cash Flow Projections with supporting assumptions which reflect positive cash flow within two years” for all new businesses. SBA's business-plan guidance says that if a business is already established, the plan should include “income statements, balance sheets, and cash flow statements for the last three to five years.” (SBA: Plan your business)
  • A personal financial statement from owners. For 7(a) loans, SBA Form 413 is completed by each proprietor, general partner, LLC managing member, owner of 20% or more, and guarantor. That form is separate from the business statements on this page. (SBA Form 413)

Your lender decides the exact document list. SBA's 7(a) page notes the contents of a loan application “vary depending on the size of the loan and the lender's processing method.” Statements you prepare yourself are normally labeled unaudited. Use the footnote field to say so.

Frequently asked questions

What is a cash flow statement?
It explains how a business's cash balance changed during a period. The SEC's beginners' guide describes three parts: operating activities (day-to-day business), investing activities (buying or selling long-term assets such as equipment) and financing activities (loans, owner contributions and distributions). Beginning cash plus the net change equals ending cash, which should match the cash on your balance sheet.
What's the difference between the direct and indirect method?
Both show the same operating cash total. The direct method lists cash received from customers and cash paid to suppliers and employees. The indirect method, used by this template, starts with net income and adjusts it for non-cash expenses such as depreciation and for changes in receivables, inventory and payables. The SEC guide notes that for most companies the operating section "reconciles the net income … to the actual cash the company received from or used in its operating activities." U.S. GAAP (ASC 230) encourages the direct method, but many entities use the indirect method, and IFRS (IAS 7) allows either.
Why did my cash go down even though I made a profit?
Profit and cash differ whenever money is tied up or spent outside the P&L: customers paying more slowly (higher receivables), buying more inventory, paying down vendors, buying equipment, repaying loan principal or paying owner draws. The cash flow statement shows exactly which of these happened. In the example on this page, the bakery earned a profit but cash fell, because it bought equipment, repaid loan principal and paid distributions.
How do I calculate the changes in working capital?
Compare each balance on this period's balance sheet with the previous one. For current assets (receivables, inventory, prepaid expenses), an increase is a negative number and a decrease is positive. For current liabilities (accounts payable, accrued expenses, customer deposits), an increase is positive and a decrease is negative. Loans aren't working capital. Principal changes go in financing.
Can I create a cash flow statement from a balance sheet and income statement?
Yes, that's how the indirect method works. Save your balance sheet with a prior-date column on the balance sheet template and your P&L on the P&L template, then click "Build from my balance sheet + P&L" here. The template maps every balance sheet change to an operating, investing or financing line, so the result reconciles to your actual change in cash. It also lists what it had to estimate, such as net borrowing versus separate proceeds and repayments.
Is this a cash flow statement or a cash flow projection?
A cash flow statement reports what already happened. A projection forecasts the coming months. SBA's 7(a) checklist asks new businesses for "Cash Flow Projections with supporting assumptions which reflect positive cash flow within two years." You can use the monthly view with planned figures as a simple projection, but many lenders expect a projection built from expected receipts and payments.
Where do interest, owner draws and loan payments go?
Interest you pay is already deducted in net income, so with the indirect method it stays within operating activities. Loan principal repayments and new loan proceeds go in financing. Owner draws, distributions and dividends paid are financing outflows. They are not expenses.
What is free cash flow?
Operating cash flow minus purchases of property and equipment. It's the cash left to repay debt, build reserves or distribute to owners. The template calculates it along with cash conversion (operating cash flow ÷ net income) and, if you're burning cash, a runway estimate in months.
Is there a free cash flow statement template in Excel?
Yes. "Download Excel (.xlsx)" gives you a workbook with live formulas for every section total, the net change in cash, ending cash, the reconciliation check and the ratios. Yellow cells are inputs. It works in annual, quarterly or 12-month layouts. In monthly and quarterly layouts, each period's beginning cash is linked to the prior period's ending cash. "Blank Excel template" has the same layout with no amounts. No signup.
Is my data stored or shared?
No. Figures are saved only in your browser so they're there when you come back, and so the cash flow page can read the balance sheet and P&L you saved on this device. Nothing is uploaded.

Official Sources

Figures checked against these sources on 2026-10-03