Compliance information verified against official state sources

Project cost records

Construction Expense Tracker and Free Spreadsheet

Keep vendor costs, receipt references and payment status connected to the right construction project. Start with an original spreadsheet and a filled example you can check line by line.

Short answer: a construction expense tracker records the date, project ID, vendor, category, receipt or reference, amount and payment status for each cost. Summarize recorded costs by project and category, then check them against the supporting documents. Keep customer payments in a separate record.

Download the free construction expense tracker

No signup or email is required. Your entries stay in your own file. Both XLSX files include an Expenses log with 100 prepared rows and a Summary with up to 10 project IDs and six expense categories. All amounts are in USD.

Blank expense spreadsheet

Start your own contractor expense tracker with editable amber inputs and calculated totals.

Download blank expense tracker (XLSX)

Filled example spreadsheet

Follow three fictional expenses across two projects, including paid and unpaid costs.

Download filled expense example (XLSX)

Filled example: two projects, three expenses

These fictional records demonstrate the worksheet. They are not supplier quotes or benchmarks for construction prices. Receipt references identify vendor documents; they are not receipts issued to customers.

Illustrative vendor costs in USD
Date / projectVendorCategory / referenceAmountStatus
Nov 1, 2026 / JOB-AExample Supply Co.Materials / MAT-001$120.00Paid
Nov 2, 2026 / JOB-AExample Rental Co.Equipment / EQ-002$80.00Paid
Nov 3, 2026 / JOB-BExample Supply Co.Supplies / SUP-003$50.00Unpaid
JOB-A: $120 + $80
$200.00
JOB-B
$50.00
All recorded expenses
$250.00
Paid vendor expenses
$200.00
Unpaid vendor expenses
$50.00

The category totals are Materials $120, Equipment $80 and Supplies $50; Labor, Travel and Other are $0. Paid plus unpaid equals $250. Listing JOB-A and JOB-B on Summary leaves $0 unlisted project expenses. Marking a vendor expense Paid changes its status breakdown, not the total cost recorded.

Fill in and check your expense log

  1. Save your own copy. On Expenses, enter a real spreadsheet date, project ID, vendor and receipt/reference in the next empty amber row. Leave unused rows entirely blank.
  2. Choose Materials, Equipment, Supplies, Labor, Travel or Other. Enter the document amount, including any cost you intend to record, and choose Paid or Unpaid. Use 0 for an actual zero amount; a missing amount triggers a warning.
  3. Use one row per vendor document. Resolve missing inputs, invalid dates, negative costs, unsupported categories/statuses and duplicate vendor/reference pairs before relying on totals. Separate split documents, credits and partial payments for review.
  4. On Summary, enter up to 10 distinct project IDs. Check the project and category totals against the source documents. Unlisted project expenses should be $0 after all projects are listed; the paid/unpaid and category checks should also be $0.
  5. Add records in the prepared rows 11–110 without overwriting formulas H:I or inserting rows. Beyond 100 records, extend every formula, validation and summary range and verify the results. Keep supporting documents with your saved file.

Each complete row rounds its amount to cents before summing. Blank totals remain blank until you enter records; a real $0 is preserved. If any used row needs attention, totals show “Review expense rows” rather than a partial total that could understate costs.

This is a simple recorded-cost log. It does not decide tax treatment, calculate project profit or reconcile a bank account. Keep private payment credentials out of shared copies.

Connect costs to estimates and invoices

Gather the project scope with the contractor estimate request checklist, then prepare and agree pricing separately. Record vendor costs here as work progresses. Use the construction invoice template and example to record agreed amounts billed to your customer.

A customer payment reduces the balance on an invoice; it is not a vendor expense. Compare documents using the same project ID while keeping the cost log and customer payment record separate.

When ongoing bookkeeping needs more than a spreadsheet

The free tracker works on its own for a small expense log. If you need to manage expenses alongside estimates and invoices over time, review whether dedicated bookkeeping software fits your workflow.

Review the official Zoho Books overview for current features. The optional affiliate offer is for Zoho Books; Zoho Invoice is a separate product.

Related contractor tools

Browse contractor forms and checklists for the rest of the project workflow.

FAQ

Is this construction expense tracker free to download?

Yes. The blank XLSX and fictional filled example download directly without an account or email address. Edit your own copy in a compatible spreadsheet app. The optional Zoho Books offer is separate from the free files.

Can I use it as a contractor expense tracker for multiple projects?

Yes. Enter the project ID on each expense row, then list up to 10 distinct project IDs on Summary. The workbook has 100 prepared expense rows and totals costs by project, category and Paid or Unpaid status. Unlisted project expenses show costs not covered by your summary project list.

How are missing inputs and duplicate receipts handled?

Used rows need a date, project ID, vendor, category, receipt or reference, amount and payment status. A repeated vendor and receipt/reference pair is flagged for review on both rows. Totals show Review expense rows until the issues are resolved; the workbook does not silently delete duplicates. Review split documents separately.

Does the spreadsheet calculate project profit or track customer payments?

No. It adds recorded vendor expenses in USD, rounded per row to cents. Paid or Unpaid describes the vendor expense, not a customer invoice. Keep customer payments separately. The workbook does not calculate profit, tax deductions, partial payments, credits or bank reconciliation.

How do I add more expenses?

Use the next empty amber row on Expenses, through row 110: 100 expense records in total. Keep the formulas in columns H and I. Do not insert rows into the prepared range. Beyond 100 records, extend all formulas, validations and summary ranges and recheck the totals before relying on the workbook.