Dynamic Cashflow Dashboard Spreadsheet

I need a single Excel workbook that lets me drop in each day’s figures and immediately see how my business is travelling. The heart of the file is a clean data-entry sheet where I can paste or type daily numbers; everything else—the calculations, summaries, and formatting—should update automatically.

On the dashboard I want an “at-a-glance” view of:
• Revenue versus expenses
• Cash inflow versus outflow
• Net profit or loss

Please build that view with clear charts, sparklines, and colour-coded KPIs so I can scan it in seconds. Behind the scenes, link the raw data to pivot tables or Power Query (whichever keeps things fast and lightweight) and organise the formulas so nothing breaks when I add rows for new days.

Key points I’m counting on:
• 100 % Excel-native, no macros unless really necessary
• Daily data entry should require no more than copy-paste into one sheet
• Dashboard updates instantly—no manual refreshing
• Layout and colours that still look good if I print to A4

I already have all historical numbers ready; once the structure is in place I’ll supply them for testing. When you hand over the file, a brief walkthrough or Loom video will help me understand where everything lives and how to tweak it in future.