Revamp Purchase Order Spreadsheet

The workbook I’m using does the minimum, yet it feels clunky. I need a cleaner Excel structure that still keeps a separate record of every vendor’s purchase orders—past and present—but ties everything together with a properly working dashboard.

Here’s what I’m after:

• A renewed “front” sheet that shows numerical summaries only: total committed, total invoiced, and funds remaining for each vendor and for all vendors combined. No charts needed—just clear, dynamic numbers.
• Each purchase order must retain its original value, display its running balance as invoices are logged, and carry an issue date. Every vendor can have multiple historical purchase orders.
• When I enter a new invoice on any vendor sheet (or whatever layout you suggest), the remaining balance for that PO and the overall vendor total should update automatically on the dashboard.
• I’m open to either keeping one sheet per vendor or migrating to a smarter table-driven model if it will streamline maintenance, but the end result has to be intuitive for anyone in the team to extend.
• All formulas, named ranges, or pivot tables need to be transparent and editable—no hidden VBA unless it’s clearly documented.

Hand‐off deliverables:

1. A fully functional .xlsx file reflecting the goals above.
2. Brief inline comments or a separate note explaining how to add new vendors, purchase orders, and invoices without breaking anything.

If this sounds within your wheelhouse, let’s make the data finally work for us instead of the other way around.