Invoice & Cashflow Dashboard Spreadsheet

I’m consolidating several moving pieces—customer invoices, contractor costs, and cash-flow timing—into one well-structured file built in either Excel or Google Sheets. The core of the job is to design formulas, linked tables, and a clear visual dashboard that lets me:

• Enter or import each customer invoice (name, issue date, amount) and instantly see the running total outstanding.
• Record every contractor’s billing rate, actual pay rate, and any monthly expenses so I can compare gross margin at a glance.
• Display our bi-weekly payment schedule as an easy-to-read graph that highlights upcoming inflows and flags potential shortfalls.

From those inputs I want automated calculations that surface cash shortages, margins by customer and by contractor, and projected cash position after every two-week cycle. I already have raw data; what’s missing is a clean, resilient structure with pivot tables, conditional formatting, and a compact summary page that updates itself whenever new rows are added.

Deliver the finished spreadsheet ready for me to test with live numbers. Once I approve the results, a short hand-off call or concise documentation on how to maintain and extend the sheet will wrap things up.