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. ✨ 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 Cal