Cash Flow Forecast Spreadsheet, Business KPI Dashboard, 12 Month Plan, Small Business Cash Flow, Financial Dashboard, Excel Google Sheets

Cash Flow Forecast Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. See your next 12 months of cash, get warned before your balance drops too low, and track the KPIs that matter. Perfect for small business owners and shop owners.

🎥 WATCH THE FULL WALKTHROUGH VIDEO before you buy, every tab explained: https://youtu.be/WNlyegLgND8

✨ NOW INCLUDES 4 FILES: a SAMPLE version (filled in so you can see exactly how it works) and a BLANK version (cleared and ready for your own info), each in an Excel edition and a Google Sheets edition.

★ WHAT'S INCLUDED ★
• Clickable Start Here cover page with quick-start steps and a color key
• Cash Flow & KPI Dashboard: pick any month for 12 KPI tiles (cash balance, net cash flow, runway, low-cash months ahead, revenue, gross margin, net margin, cash conversion cycle, lowest cash in the next 13 weeks, open receivables, bills due in the next 30 days, year-end cash for your chosen scenario), 8 automatic health checks, a cash-by-month table, a monthly KPI table and 7 charts
• 12-Month Cash Flow Forecast: 8 cash-in and 14 cash-out lines (all renameable), closing balance, low-cash and overdrawn alerts, months of costs covered, cumulative cash flow, average per month and share of total, with 2 charts
• 13-Week Cash Flow: a week-by-week plan that pulls customer payments from Receivables and supplier bills from Payables automatically, plus your own weekly lines (payroll, rent, taxes, owner draw and more), lowest balance and low-cash weeks flagged, with 2 charts
• Actuals: the same layout for what really happened each month, with 2 charts
• Actual vs Forecast: pick a month for variance and year-to-date variance on every line (green = better than plan, red = worse), a monthly forecast accuracy table and 2 charts
• Receivables: 300-row invoice log with customer and payment-terms drop-downs, automatic due date, balance, days late, paid / due soon / part paid / overdue status, aging bucket and expected cash date
• Payables: 300-row bill log with vendor, category and terms drop-downs, planned pay date, due date, balance, scheduled / overdue status, aging bucket and cash-out date
• AR & AP Aging: receivables and payables by age (current to 90+ days), largest open invoices, money in vs. out for the next 8 weeks, totals by customer and by vendor, and 3 charts
• KPI Data: type 10 monthly numbers and get 18 KPIs: revenue growth, gross profit and margin, net profit and margin, break-even revenue, cash balance, cash burn, runway, DSO, DPO, DIO, cash conversion cycle, CAC, revenue per customer, operating expense ratio, marketing % of revenue and revenue per employee, with 2 charts
• KPI Scorecard: every KPI for the month you pick vs. last month, the 3-month average and your target, with on target / close / off target flags, progress bars and a chart of any KPI you choose
• Scenarios: worst, base and best case side by side (sales up or down, customers paying late, variable and fixed cost changes, a one-off cost, new funding) with ending cash, lowest cash, months below minimum, a verdict and 3 charts
• Runway Calculator: runway today and with cost cuts, growth, new funding or a new hire, zero-sales runway, cash needed to reach your target runway, a 7 x 7 runway stress test and a 24-month cash chart
• Quarterly Summary: Q1-Q4 forecast vs. actual cash, quarterly profit from KPI Data and actual cash by line, with 2 charts
• Setup: company name, first forecast month, opening cash, minimum cash, 9 KPI targets, cash line names and types, customers, vendors and payment terms (all renameable)
• Guide & FAQ with step-by-step instructions and plain-English explanations of DSO, DPO, DIO, runway and the cash conversion cycle
• 2 versions of each file: one with sample data to show how it works and one blank, ready to use

★ PERFECT FOR ★
✓ Small business owners and shop owners
✓ Ecommerce and wholesale businesses
✓ Bookkeepers preparing monthly reviews
✓ Anyone who wants to stop guessing about cash

★ COMPATIBILITY ★
• Microsoft Excel (desktop, Mac, web)
• Google Sheets (upload to Google Drive and open with Google Sheets)
• Not designed for Apple Numbers

★ HOW IT WORKS ★
1. Enter your start month, opening bank balance and minimum cash on Setup
2. Type your expected cash in and out for 12 months
3. Each month, add your actuals and KPI numbers
4. Review the Dashboard and Actual vs Forecast

Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol.

★ PLEASE NOTE ★
• This is a digital download. Nothing will be shipped.
• This is a planning tool, not financial, tax or accounting advice.
• Because it's a digital file, returns aren't accepted, but if you have any trouble with the file, message me and I'll fix it or help you right away.