Concept demo by Alex Mercer. Made-up builder and project; every name, invoice and dollar amount is example data.

Back to the portfolio
Download .xlsx

Project budget & payment tracker

Where every dollar on the build went.

Budget against paid for each trade, every payment with its receipt status, and the change orders that moved the numbers. Click a category to see its payments.

Project
Example new build
Site
00 Example Lane
Numbers as of
Nov 16, 2026
Example data

Remaining balance

$0

Revised budget

$0

Paid to date

$0

Pending change orders

$0

Missing receipts

0

Budget vs paid

By category

    Revised budget = original budget + approved change orders. Pending change orders are not counted until approved. Example data

    Payments log

    Every payment, with its receipt

    Receipt

    Payments log, example data
    DatePaid toCategoryMethodPaid fromAmountReceipt
    Total$0

    Change orders

    What changed, and who signed

      The spreadsheet

      Same numbers, in a real workbook.

      The dashboard reads from the same example data as the Excel file. In the workbook, you type the budget once and log payments as they go out. The rollups are plain formulas, so nothing breaks when a row is added.

      Download the .xlsx

      Tamarack-budget-tracker-DEMO.xlsx · 5 tabs · opens in Excel, Google Sheets or Numbers. Example data.

      1. Budget vs Paid

        Original budget, approved change orders, paid, remaining and % spent per category. Over-budget rows turn red; a status column says Watch at 90%.

        =SUMIFS(Payments!F:F, Payments!C:C, A5)
      2. Payments

        Date, vendor, category, draw, invoice, amount, method, source, receipt. Dropdowns on category, method, source and receipt. No receipt turns the row red and flags it.

        =IF(I5<>"Yes", "MISSING RECEIPT", "")
      3. Change Orders

        Approved, pending or declined, signed or not. Only approved ones change the budget; approved but unsigned ones get flagged.

        =SUMIFS(…Amount, …Category, A5, …Status, "Approved")
      4. Read Me + Lists

        How to start with your own numbers, and the dropdown choices in one place. Categories come straight from the budget tab.

        CategoryList → 'Budget vs Paid'!A5:A19
      The Budget vs Paid tab of the workbook: 15 categories with original budget, approved change orders, revised budget, paid to date, remaining, percent spent, missing receipts and status, then an At a glance block. Site Work and Utilities is highlighted red as over budget.
      The Budget vs Paid tab of the actual .xlsx, opened in a spreadsheet app. Every number comes from formulas over the example payments and change orders.