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.
A closer look
What's in it
- Dashboard: remaining balance, revised budget, paid to date, pending change orders, missing receipts
- Category rollups (budget, approved change orders, paid, remaining, percent spent, status)
- Payments log with search and filters; rows without a receipt are flagged
- Change-order log (only approved rows hit the revised budget)
- Matching
.xlsxwith five tabs: Read Me, Budget vs Paid (SUMIFS rollups), Payments (dropdowns and a missing-receipt flag), Change Orders, Lists - Yellow cells in the workbook are inputs; everything else is a formula



