12-Month Cash Flow Statement (Excel)

Profit is an opinion; cash is a fact. This 12-month cash flow statement shows whether your business actually generates cash — and exactly when your bank balance will feel it.

n

What’s Inside

n

• Cash In and Cash Out (operating) sections with editable line items
• Investing & financing section for equipment, loans and owner draws
• Net cash flow per month, highlighted
• Opening and closing cash balances that chain across the year automatically
• Year-total column for annual reporting

n

How to Use It

n

Start with your current bank balance in the Opening Cash cell, then fill each month’s blue cells — January carries example values to show the format. Watch the closing balance row: if any month dips near zero, you’ve found your crunch point months in advance. Pair it with the Break-Even Calculator to know the sales level that keeps the line positive.