Small Business Cash Flow Statement | Free Excel & Google Sheets Template [2026]

A profitable business can still run out of money. Your profit and loss statement records revenue when you earn it; your bank account moves only when cash actually arrives. A client paying in 45 days while rent is due on the first is the gap that closes small companies.

If you have rebuilt a cash forecast by hand every month, you need a fixed structure instead of a fresh guess. The Small Business Cash Flow Statement template from SheetMaster Hub gives you a 12-month grid built the way an accountant would build it: an Opening Cash Balance input, three activity sections — Operating, Investing, and Financing — calculated subtotals, a Net Change in Cash line, a chained Closing Cash Balance, and a Dashboard that charts net change and closing balance by month.

This guide builds that template from a blank workbook: the subtotal formulas, the net change calculation, and the closing-balance chain that holds the model together. Download the file and follow along in your own copy.

[Insert Real Screenshot Here: The ‘Cash Flow Statement’ sheet showing Jan–Dec headers across row 4, the Opening Cash Balance input cell, and the three labeled activity sections in column B]

📥 Download the Small Business Cash Flow Statement Template Stop building from scratch. The complete 12-month cash flow grid — Operating, Investing, and Financing sections, calculated subtotals, a chained closing balance, and a charted dashboard — is ready to use in Excel or Google Sheets. Download Free Template (.xlsx)

Tested by our data analysts at Healora Studio. Every formula in this template was built and verified in Excel 365 and Google Sheets before release.

Why Cash Flow Differs from Profit

Profit is an accounting estimate. Cash is a fact. Three timing issues create the gap:

• Accounts receivable. You invoice in March, the client pays in May. The P&L counts March; your bank account waits.
• Inventory and prepayments. Stock is not an expense until it sells, but the cash left the day you paid the supplier.
• Loan principal and owner draws. Repaying principal is not deductible, yet it reduces cash; owner draws shrink the account without touching net profit.

A cash flow statement records only money that actually moved, which is why lenders ask for it alongside your P&L.

Step 1: Lay Out the 12-Month Grid

• Column A — narrow spacer (width ~3).
• Column B — section labels and line item names.
• Columns C–N — Jan through Dec in row 4.
• Column O — Year Total.

Type Jan in C4 and drag the fill handle right to N4; Excel and Google Sheets both continue the month series automatically. Freeze the panes at C5 using View > Freeze Panes > Freeze Panes.

Step 2: Enter the Opening Cash Balance

Give Opening Cash Balance its own labeled row above the Operating Activities block — label in column B, value in column C.

Pro Tip from Healora Studio Analysts: Use your bank balance as of the first day of the year, not the last day of the prior month. A late-clearing check or pending deposit shifts the entire chain by thousands if you anchor on the wrong date. Reconcile against your bank statement first.

This is the only manually entered balance in the model. Every other balance is calculated, which is what makes the forecast trustworthy.

Step 3: Build the Operating Activities Section

Operating activities are the day-to-day money movements of the business. The template lists six lines:

• Cash received from customers
• Other operating receipts
• Payments to suppliers and vendors
• Payroll and contractor payments
• Rent and utilities
• Other operating expenses

Enter inflows as positive numbers and outflows as negative numbers. One sign convention across the sheet prevents the most common cash flow error: adding an expense when you meant to subtract it.

Step 4: Write the Section Subtotal Formula

Beneath the six operating lines, add a bold row labeled Net Cash from Operating Activities:

=SUM(C10:C15)

Copy it across to column O. Because outflows are stored as negatives, the sum is automatically net operating cash for the month.

Step 5: Add the Investing and Financing Sections

Investing Activities track long-term purchases: purchase of equipment, and software and asset purchases.

Financing Activities track funding and owner payment: owner contributions, loan proceeds, loan repayments, and owner draws and distributions.

Give each section its own Net Cash from Investing Activities and Net Cash from Financing Activities row using the same =SUM(...) pattern. Loan proceeds and owner contributions are positive; repayments and draws are negative.

Step 6: Calculate the Net Change in Cash

Add a bold NET CHANGE IN CASH row that adds the three section subtotals:

=C16+C22+C28

Click each subtotal cell rather than typing references by hand. This line answers the only question that matters: did the business generate cash or burn cash this month?

Step 7: Chain the Closing Cash Balance

January’s CLOSING CASH BALANCE is the opening balance plus net change:

C30: =C6+C17

Every month after that references the previous month’s closing cell:

D30: =C30+D17 E30: =D30+E17

Copy that pattern rightward through December. The chain is what makes this a model: change one supplier payment in March and every closing balance from March to December updates instantly.

Pro Tip from Healora Studio Analysts: Never hard-code a monthly opening balance — always reference the previous closing cell. Typed numbers break the chain silently and your dashboard shows a trend that never existed. Press Ctrl + ` to display formulas and confirm each month references its neighbor.

Sanity check: December’s closing balance must equal the Opening Cash Balance plus the Year Total in the Net Change row. If the two figures disagree, a link is broken in columns C through N.

Step 8: Build the Dashboard

Create a sheet named Dashboard and pull figures across with direct references — ='Cash Flow Statement'!C17 for January’s net change, ='Cash Flow Statement'!C30 for the closing balance. Lay the months down column A with a two-row table beneath.

Then select the table and insert both charts from Insert > Charts:

• Bar chart — net change per month. A run of negative bars is your earliest warning sign.
• Line chart — closing balance per month. A falling line while the bars trend positive usually means loan repayments or owner draws are draining the account.

Template Features

• ✅ Three sheets: Instructions, Cash Flow Statement, Dashboard
• ✅ 12-month grid (Jan–Dec) plus a Year Total column
• ✅ Dedicated Opening Cash Balance input cell
• ✅ Full OPERATING ACTIVITIES section: cash received from customers, other operating receipts, payments to suppliers and vendors, payroll and contractor payments, rent and utilities, other operating expenses
• ✅ Full INVESTING ACTIVITIES section: purchase of equipment, software and asset purchases
• ✅ Full FINANCING ACTIVITIES section: owner contributions, loan proceeds, loan repayments, owner draws and distributions
• ✅ Calculated Net Cash subtotals for all three sections
• ✅ NET CHANGE IN CASH row and chained CLOSING CASH BALANCE row
• ✅ Dashboard with per-month net change and closing balance, plus a bar chart and a line chart
• ✅ Works in Excel and imports cleanly into Google Sheets

When to Upgrade from Excel

Excel handles a 12-month cash flow model well. It stops being the right tool when you need bank feeds, automated invoicing, or multi-user access with an audit trail.

QuickBooks Online — connects to your bank, auto-categorizes transactions, and produces a live cash flow statement. Plans start around $30/month for Simple Start. [Affiliate Link: QuickBooks Online cash flow reporting]

Xero — stronger multi-currency handling and unlimited users on every tier. Entry pricing runs roughly $20–$40/month depending on region and plan. [Affiliate Link: Xero small business accounting]

Float — a cash forecasting layer that projects 13 weeks to 12 months ahead from real invoice and bill dates. Budget roughly $59–$149/month depending on company size. [Affiliate Link: Float cash flow forecasting]

Use the spreadsheet for planning and modelling; move to software when recording transactions becomes the bottleneck.

FAQ

Can I use this template if my income is irregular? Yes. The grid assumes nothing about level monthly revenue. Enter what you actually received and the closing-balance chain shows how lumpy cash movement affects your runway.

How is this different from a profit and loss statement? A P&L measures earned revenue against incurred expenses for a period. A cash flow statement measures money entering and leaving your bank account. Loan principal and owner draws appear here but not on the P&L.

Should owner draws sit under Financing Activities? Yes. Distributions to owners are a financing decision, not an operating expense. Listing them under Operating would distort your operating performance.

Does it work in Google Sheets? Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas, freeze panes, and both charts carry over.

Get the Template

Download the free Small Business Cash Flow Statement template (.xlsx) and enter your own opening balance. Confirm December’s closing balance reconciles against the Year Total, and you have a forecast you can rely on all year.

This tutorial and template are part of SheetMaster Hub by Healora Studio. For more data efficiency tools, visit healorastudio.com.