Finance Dashboard (Excel): P&L vs Budget, 13-Week Cash and Board Pack

Profit against budget, where the money went, who owes you, and a 13-week cash forecast, by business unit.

What is inside

• Statements & Outlook: profit and loss (month, year to date, last year, full-year outlook against budget), balance sheet with 6 ratios, cash flow; a scenario for the rest of the year (revenue, gross margin, operating expenses, capex, one-offs).
• Dashboard: headline, 6 KPI cards, P&L waterfall, budget vs actual by line, revenue and margins, cash bridge, receivables ageing, biggest costs, 13-week cash forecast, variances to explain.
• Board Pack: one A4 page for the board.
• KPI Scorecard: 39 KPIs with target, status and a 12-month trend line.
• Cash & Working Capital, Chart Library (16 charts), Advanced Analytics (11 methods: break-even, cost behaviour, profit bridge and more).
• Data tabs: Actuals, Budget, Invoices, Bills, Cash, Balances, Accounts, Settings.

Who it is for

• Finance managers, in-house accountants and owners who report to directors or investors.

Format

• One ZIP: the Excel workbook (.xlsx) + a PDF user guide.
• Needs Excel for Microsoft 365, Excel 2024 or Excel for the web (free at office.com). Excel 2019 / 2016 and Google Sheets cannot run its formulas.
• No macros, no add-ins. Windows and Mac.
• Comes with fictional sample data: replace it with yours in the data tabs.
• Instant download after payment.