Construction Management System | Excel & Google Sheets Template | Spreadsheet | Project Tracker, Job Costing, Invoices, Timesheets

📝 DESCRIPTION
🏗️ Introducing the ELDON-Digital Construction Management System — the most complete, professional-grade construction business spreadsheet available anywhere. Built for contractors, project managers, general contractors, and construction business owners who are serious about running a tight, profitable operation.
Stop juggling 10 different spreadsheets. Stop losing track of change orders, unpaid invoices, and equipment. This is the one system that runs your entire construction business — all in one file. 🔥
________________________________________
📦 WHAT'S INCLUDED
✅ Microsoft Excel (.xlsx) — fully formatted, formula-driven workbook ✅ Google Sheets Script (.gs) — builds the entire system natively in Google Sheets in one click ✅ Both files are instant digital downloads — ready to use in minutes
________________________________________
🗂️ 15 FULLY BUILT MODULES
🏠 Dashboard — live KPI summary cards, project status overview & one-click navigation to all 15 modules
📁 Projects — complete project register with contract value, schedule dates, % complete, budget vs actual cost, variance & margin auto-calculated
💰 Job Costing — track labor, materials, equipment, subcontract & overhead per project. Total cost, variance & margin % all auto-calculated
📐 Estimating & Bidding — log every bid with direct cost, markup %, gross margin & win/loss tracking. Auto-calculates win rate & total awarded revenue
🔄 Change Orders — never lose a CO again. Track requested amount, approved amount, status & schedule impact days
👷 Resources — weekly crew scheduling with color-coded hours (🟩 green = 8h, 🟨 yellow = partial, 🟥 red = 0h). Overtime auto-calculated
🚜 Equipment — full fleet register with status, daily rates, MTD costs & maintenance date tracking
🤝 Subcontractors — contract values, billings, payments, 10% retention (auto-calculated), balance due & insurance expiry alerts
⏱️ Timesheets — weekly hours by employee with regular/OT auto-split and labor cost auto-calculated per person
📦 Procurement — purchase order register tracking vendors, deliveries, invoiced vs paid status
📋 Site Reports — daily superintendent logs with weather, crew count, work completed, issues & next-day plans
⛑️ Safety — OSHA-ready incident log with severity tracking, corrective actions, lost days & safety meeting records
🧾 Invoices — full A/R ledger with auto-calculated tax (8.5%), total due, balance outstanding & aging summary
⚙️ Settings — configure company info, labor rates, markup %, tax rate, retention & all system defaults
📖 Instructions — complete step-by-step user guide built right inside the file
________________________________________
⚡ KEY FEATURES
🔢 286 pre-built formulas — everything auto-calculates. No manual math ever 🎨 15 unique color-coded sheet themes — professional, clean & instantly recognizable 📊 15 embedded charts — visual breakdowns for projects, costs, bids, invoices & more 🔽 Dropdown menus on all status, type & weather fields — no typos, no errors 🔗 Full navigation system — Dashboard buttons + back-to-dashboard on every sheet 🛡️ Error-proof formulas — all divisions wrapped in IFERROR to prevent any #DIV/0! errors 📱 Works on Excel & Google Sheets — use wherever you work
________________________________________
🎯 PERFECT FOR
🏗️ General Contractors 🔨 Specialty & Trade Contractors (electrical, plumbing, HVAC, concrete, steel) 👷 Construction Project Managers & Superintendents 🏢 Construction Company Owners & Office Managers 📐 Estimators & Bidding Teams 🏛️ Small to Mid-Size Construction Businesses
________________________________________
🚀 HOW IT WORKS
1️⃣ Purchase & instantly download both files 2️⃣ Open the .xlsx in Excel — it's ready to use immediately 3️⃣ For Google Sheets: open a new spreadsheet → Extensions → Apps Script → paste the .gs file → Run → done in 90 seconds 4️⃣ Go to the Settings sheet and enter your company info & rates 5️⃣ Start entering your projects, costs, crew, bids & invoices 6️⃣ Watch your entire business come together in one dashboard 🎉
________________________________________
✨ WHY ELDON-Digital?
💼 Built by construction industry professionals who know exactly what you need 🎨 Professional design that looks great on screen and in print ⚡ Instant download — no waiting, no shipping 🔄 Works for unlimited projects — just keep adding rows 📞 Responsive support — questions? We reply fast
________________________________________
📌 IMPORTANT NOTES
📁 This is a digital download — no physical item will be shipped 💻 Requires Microsoft Excel 2016+ or Google Sheets (free) 🔒 For personal & business use. Redistribution or resale is not permitted 🌍 Works in any country — all currency & rate fields are fully customizable
________________________________________
⭐ If this system saves you time and money, we'd love a 5-star review — it means everything to our small business! Thank you for supporting ELDON-Digital. ⭐
________________________________________