Construction Job Tracker Spreadsheet | Daily Log, Cost, Payment, Compliance (Excel, Google Sheets)

Construction Daily Job Tracker Spreadsheet for Excel + Google Sheets

Stay organized on every job with a clean, practical construction tracking spreadsheet designed for small contractors, remodelers, handymen, construction business owners, and project managers.

This workbook helps you track daily job activity, subcontractor invoices, unpaid balances, job costs, change orders, compliance/document items, materials, supplies, and punch list issues in one organized file.

No macros. No VBA. No scripts. No add-ons.

WHAT’S INCLUDED

• START HERE / INSTRUCTIONS
Simple setup guide explaining how to use the workbook, where to enter data, and how the dashboard updates.

• DASHBOARD
High-level summary of active jobs, completed jobs, contract value, job costs, subcontractor balances, open change orders, missing compliance items, over-budget jobs, and open issues.

• JOBS
Master job list with customer/client details, job type, project manager, start dates, completion dates, status, contract amount, estimated cost, actual cost, profit, and margin.

• DAILY JOB LOG
Track daily site activity including date, job, weather, crew on site, hours worked, work completed, materials delivered, equipment used, subcontractors on site, delays, safety notes, customer notes, follow-up items, and completed by.

• SUBCONTRACTORS
Store subcontractor details including company name, contact, trade, phone, email, W-9 status, insurance/COI status, contract status, and payment terms.

• SUBCONTRACTOR PAYMENT TRACKER
Track invoices, due dates, invoice amounts, amount paid, balance due, payment status, payment date, payment method, and lien waiver status.

• JOB COST TRACKER
Track estimated/budget amounts and actual amounts by job, cost category, vendor/subcontractor, description, payment status, and receipt reference.

• CHANGE ORDER LOG
Track change order requests, descriptions, estimated amounts, approved amounts, status, approval date, billed status, and paid status.

• COMPLIANCE CHECKLIST
Track permits, insurance/COI, W-9s, contracts, lien waivers, safety checklist items, inspections, and other job documents.

• MATERIALS / SUPPLIES TRACKER
Track materials ordered, supplier, quantity, unit cost, total cost, ordered status, received status, and receipt/invoice reference.

• ISSUE / PUNCH LIST
Track open issues and punch list items by job, priority, assigned person, due date, status, and completion date.

• LISTS
Dropdown list values used throughout the workbook.

KEY FEATURES

• Excel and Google Sheets friendly
• No macros, VBA, scripts, or add-ons
• Dashboard with automatic summary formulas
• Job cost tracking by Job ID
• Subcontractor unpaid balance tracking
• Change order tracking
• Compliance/document checklist tracking
• Materials and supplies tracker
• Issue and punch list tracker
• Dropdown menus for cleaner data entry
• Light yellow input cells
• Formula/output cells are visually separated
• Sample data included so you can see how it works
• Sample rows are clearly labeled and can be deleted
• Clean, modern, contractor-friendly layout

WHO THIS IS FOR

This spreadsheet is ideal for:

• General contractors
• Remodelers
• Handymen
• Construction business owners
• Small construction teams
• Home renovation businesses
• Project managers
• Independent tradespeople
• Contractors who want a simple job tracking system without complicated software

IMPORTANT NOTES

This is a digital spreadsheet product. No physical item will be shipped.

This spreadsheet is a tracking tool only and does not provide legal, tax, accounting, safety, or compliance advice. Please consult the appropriate professional for your business needs.

You will need access to Microsoft Excel or Google Sheets to use this file.

WHAT YOU RECEIVE

• 1 Excel spreadsheet file
• Compatible with modern Excel and Google Sheets
• Instant digital download
• Editable spreadsheet template
• Sample data included for demonstration

HOW TO USE

1. Download the spreadsheet file.
2. Open it in Excel or upload it to Google Sheets.
3. Start on the START HERE / INSTRUCTIONS tab.
4. Add your jobs to the Jobs tab.
5. Add subcontractors to the Subcontractors tab.
6. Enter daily activity, costs, payments, change orders, materials, compliance items, and punch list items.
7. Review the Dashboard for summaries and open items.

Because this is a digital file, all sales are generally final, but please message me if you have trouble accessing your download.