Nº 01SpreadsheetConcept demo

Tamarack Build Co.: a project budget and payment tracker

A budget and payment tracker for a home builder, as a live dashboard and a real Excel file. Budget vs paid by category, a filterable payments log, change orders and missing-receipt flags, all done with formulas.

Tamarack Build Co. tracker dashboard: remaining balance, revised budget, paid to date and missing receipts
Fig. 1 · Budget trackerConcept demo

A closer look

What's in it

  1. Dashboard: remaining balance, revised budget, paid to date, pending change orders, missing receipts
  2. Category rollups (budget, approved change orders, paid, remaining, percent spent, status)
  3. Payments log with search and filters; rows without a receipt are flagged
  4. Change-order log (only approved rows hit the revised budget)
  5. Matching .xlsx with five tabs: Read Me, Budget vs Paid (SUMIFS rollups), Payments (dropdowns and a missing-receipt flag), Change Orders, Lists
  6. Yellow cells in the workbook are inputs; everything else is a formula

Want something like this?

alexmercer.projects@gmail.com

Email me the job. You get a free sample first, and most jobs are done within 24 hours once the brief and files are ready.

Email Alex