Remote Inventory Data Entry Dashboard

I need a self-contained Excel dashboard that lets me track my business income, expenses, and overall profit at a glance. The core view should break results down by category so I can instantly spot where money is coming from and where it is going.

Once the figures are in, I want to see dynamic charts, clear profit summaries, and category-level pivots that refresh with one click—no external connections, no macros if they can be avoided.

Acceptance criteria

1. Changing any entry instantly updates all visuals without breaking formulas.
2. Dashboard loads in under five seconds on a standard laptop.
3. File passes an audit check: sums in the dashboard equal sums in the raw data when sampled.

If you have sample layouts built with PivotTables, Power Query (optional), or creative conditional formatting, feel free to link them—visual clarity is key.