EaseSheets

Construction Job Cost Analysis Tool

EaseSheets

Construction Job Cost Analysis

📊 Dashboard

⚙️ Project Inputs

💸 Cost Breakdown

🧾 Invoice

💰 Cash Flow

📅 Schedule

📒 Income & Expenses

🔧 Work Order

⏱ Timesheet

📝 Change Orders

🤝 Subcontract

📦 Material Takeoff

✅ Punch List

🗂 Projects

📖 Read Me

Project —

Client —

Phase —

Start Date —

End Date —

Contract Value

Total project revenue

Budgeted Cost

Estimated total spend

Actual Cost

Total to date

Net Profit

0.0%

Variance

On Budget

Profit Waterfall

Cost Distribution

Expense Detail

Category	Phase	Budgeted	Actual	Cost Intensity	Variance
Enter data in the Cost Breakdown tab to see results.

ℹ️ Fill in the fields below to configure your project. All input cells are highlighted in blue. Changes apply automatically when you click Recalculate.

🏗 Project Information

Project Name

Client Name

Project Phase

Start Date

Completion Date

Project Notes

💰 Financial Summary

Contract Value ($)

Contingency Budget ($)

Overhead Rate (%)

Target Profit Margin (%)

Change Orders (+$)

Retainage (%)

Project Manager

⚠️ Enter your budgeted and actual costs per line item. The dashboard updates when you click Recalculate.

Line Item Cost Entry

Category	Phase	Description	Budgeted ($)	Actual ($)	Del

📋 How to Use This Tool

Getting Started

This Construction Job Cost Analysis tool has four tabs. Work through them in order for best results:

Project Inputs — Enter your project name, client, dates, contract value, overhead rate, and target margin. All blue fields accept user input.
Cost Breakdown — Add each line-item cost with a budgeted and actual amount. Use the "+ Add Row" button to expand the table.
Dashboard — View your KPI summary, waterfall chart, cost distribution, and detailed variance table.
Click ↻ Recalculate (top right or at the bottom of each input tab) after making changes.

Metric Definitions

Contract Value

The total value agreed with the client, including any approved change orders.

Budgeted Cost

Sum of all estimated line-item costs plus overhead allocation.

Actual Cost

Sum of all actual spend entered in the Cost Breakdown tab.

Net Profit

Contract Value minus Actual Cost (including overhead). Positive = profitable.

Profit Margin %

Net Profit ÷ Contract Value × 100. Compare to your Target Margin in Inputs.

Variance

Budgeted Cost minus Actual Cost. Positive (green) = under budget. Negative (red) = over budget.

Overhead Rate

Applied as a % on top of direct costs to account for indirect expenses (admin, equipment, insurance).

Retainage

% of contract value held back by the client until project completion.

Color Guide

■ Green — Under budget / profitable
■ Red — Over budget / loss
■ Amber — Within 5% of budget (watch closely)
■ Blue — Informational / neutral
Blue cell — User input field

Tips

Use the Phase dropdown on each line item to group costs by project stage.
Include overhead as a separate line item or use the Overhead Rate in the Inputs tab — not both.
Use the Print Report button to generate a PDF of the dashboard for client or management review.
The tool runs entirely in your browser — no data is sent anywhere. Save your work by using File → Save As in your browser, or keep this HTML file on your desktop.

⚙️ Support & Branding

This tool was built to accompany the Construction Job Cost Analysis System Design specification. To customize it for your company, open the HTML file in a text editor and update the logo text and color palette at the top of the file.

🏗 Company Info

Company Name

Address

Phone

📋 Invoice Details

Invoice #

Date

Payment Due Date

👤 Client Information

Client Name

Address

Contact No.

Start Date

End Date

🔢 Line Items

Service / Item	Qty/Hrs	Rate ($)	Total

💰 Totals & Signatories

Discount ($)

Prepared By (Name)

Title

Authorized By (Name)

Title

Footer Note

Live Preview

EaseSheets Construction

456 Imperial Lane, Irvine, CA 92606
(949) 555-0100 | info@easesheets.com

BILLING INVOICE

Invoice No: INV-2025-001
Date: —
Payment Due: —

Client Information

NameJohn Smith

Emailinfo@easesheets.com

Address456 Imperial Lane, Irvine, CA 92606

Contact(949) 555-0100

Project Period

Start Date—

End Date—

Invoice #INV-2025-001

Service / Item	Hour / Qty	Rate	Total

Subtotal$0.00

Discount−$0.00

TOTAL DUE$0.00

John Smith

Architect

John Smith

Project Manager

Company Name Prepared By

Fiscal Year Fiscal Year Start

Notes

Total Inflows

Tax refunds + injections

Total Outflows

Operations + invest + finance

Closing Balance

Year-end cash position

Net Annual Change

Increase / decrease

Monthly Cash Flow Overview

Inflows

Outflows

Net Closing Balance

	Category	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC	YEARLY TOTAL

Project Name Company

Project Start Date Days to Show

Today's Date Day Width (px)

Total Tasks

excluding milestones

Milestones

key dates

Project Duration

first to last task

Peak Daily Load

max workers/day

🏗 Company & Project

Company Name

Company Address

Phone

Project Name

👤 Client & Financials

Client Name

Client Address

Client Phone

Client Email

Project Estimate ($)

Operation Start

Operation End

Opening Balance ($)

Project Estimate

contract value

Total Income

all received payments

Total Expenses

all payments made

Current Balance

income − expenses

Receivables

estimate − income

Running Balance

— —

Expenses by Payee

#	Date	Mode of Payment	Paid To / Received By	Description	Income ($)	Expense ($)	Subtotal ($)

Prepared By

Name

Title

John Smith

Project Secretary

Approved By

Name

Title

John Smith

Corporate CEO

🏗 Company

Company Name

Address

Phone

📋 Work Order Details

W.O. Number

Customer ID

Date

Status

Tax Rate (%)

Notes / Special Instructions

👤 Customer

Name

Company

Address

Contact #

🔧 Labor / Services

Service / Description	Hours / Qty	Rate ($)	Total

✍ Approval

Approved By

Title

Live Preview

EaseSheets Construction

456 Imperial Lane, Irvine, CA 92606
(949) 555-0100 | info@easesheets.com

WORK ORDER

W.O. #: 78678
Customer ID: ANF98346
Date: —
Status: ● Approved

NameJohn Smith

CompanyJohn Smith

Address456 Imperial Lane, Irvine, CA 92606

Contact(949) 555-0100

Emailinfo@easesheets.com

Labor / Service	Hours / Qty	Rate	Total

Subtotal$0.00

Tax (5%)$0.00

TOTAL$0.00

Notes / Special Instructions

All work to be completed in accordance with applicable building codes and safety regulations.

Approved By

John Smith

President, John Smith

👷 Employee Info

Employee Name

Employee ID

Department

Position / Role

🏗 Company

Company Name

Address

Phone

💵 Pay Settings

Regular Rate ($/hr)

OT Multiplier

Regular Hrs/Day

Pay Period Start

📊 Pay Summary

Regular Hours 0h

Overtime Hours 0h

Regular Pay $0.00

Overtime Pay $0.00

Total Pay $0.00

Total Hours

this pay period

Regular Hours

standard time

Overtime Hours

extra hours worked

Gross Pay

reg + overtime

Daily Hours Breakdown

Hours Split

overtime

Regular: 0h

Overtime: 0h

#	Day	Date	Time In	Time Out	OT Hrs	Total Hrs	Status

EaseSheets Construction

456 Imperial Lane, Irvine, CA 92606
(949) 555-0100 | info@easesheets.com

STAFF TIMESHEET

Pay Period: —
Generated: —

EmployeeJohn Smith

Employee IDID-0001

DepartmentSite Operations

PositionSite Supervisor

Hourly Rate$27.16

OT Rate$40.74 (×1.5)

Day	Date	Time In	Time Out	OT Hrs	Total Hrs	Status

Regular Hours0h

Overtime Hours0h

Regular Pay$0.00

Overtime Pay$0.00

TOTAL HOURS0h

GROSS PAY$0.00

John Smith

Employee's Signature over Printed Name

🏗 Company

Company Name

Address

Phone

📋 Change Order Details

C.O. Number

Date Issued

Status

Original Contract ($)

Schedule Impact (days)

👤 Client / Owner

Client Name

Project Name

Project Address

📝 Scope & Reason

Scope of Change

Reason / Justification

🔢 Cost Items

Description	Qty	Unit ($)	Total

✍ Signatures

Contractor Name

Title

Owner / Client Name

Title

Original Contract

base contract value

This Change Order

additions − deductions

Revised Contract

original + all changes

Schedule Impact

calendar day change

Contract Value Impact

Original

Original: $0 This C.O.: $0 Revised: $0

C.O. #	Date	Project	Scope Summary	Amount	Schedule	Status

EaseSheets Construction

456 Imperial Lane, Irvine, CA 92606
(949) 555-0100 | info@easesheets.com

CHANGE ORDER

CO-001

Date: —
Status:

Project Information

Project—

Site Address—

Contractor—

Client / Owner

Owner—

C.O. NumberCO-001

Date—

Scope of Change

—

Description of Work	Qty	Unit Cost	Total

Original Contract Value

$0.00

This Change Order

$0.00

Revised Contract Value

$0.00

Schedule Adjustment

0 Days

Reason for Change

—

Contractor Signature

John Smith

Project Manager

Owner / Client Signature

John Smith

Owner Representative

📄 Document Type

Type

Doc Number

Date

🏗 General Contractor

Company Name

Address

Phone

License #

👷 Subcontractor

Company / Name

Address

Trade / Scope

License #

💰 Contract & Payment

Project Name

Contract Amount ($)

Payment Received ($)

Start Date

End Date

Scope of Work

✍ Signatures

GC Signatory

Title

Sub Signatory

Title

Agreement

Conditional Lien Waiver

Final Lien Waiver

EaseSheets Construction

456 Imperial Lane, Irvine, CA 92606

SUBCONTRACTOR AGREEMENT

Doc #: SUB-001
Date: —

General Contractor

CompanyEaseSheets Construction

Address—

License—

Subcontractor

Company—

Address—

Trade—

License—

Project & Financial Summary

Project

—

Contract Amount

$0.00

Amount Paid

$0.00

Scope of Work

—

Payment Terms

Payment shall be made within 30 days of satisfactory completion of the work described above, subject to inspection and approval by the General Contractor. Progress payments may be made based on percentage of work completed.

Insurance Requirements

Subcontractor shall maintain General Liability Insurance of not less than $1,000,000 per occurrence and Workers' Compensation Insurance as required by law. Certificates of insurance shall be provided before work commences.

Compliance & Safety

Subcontractor shall comply with all applicable federal, state, and local laws, codes, and regulations including OSHA safety standards. Subcontractor is responsible for the safety of its employees and for maintaining a safe work environment.

Warranty

Subcontractor warrants all work for a period of one (1) year from the date of substantial completion. Defective work shall be corrected at no additional cost to the General Contractor or Owner.

General Contractor

John Smith

Project Manager

Subcontractor

John Smith

Owner

— This document is legally binding when signed by both parties.

Total Materials

line items

Material Cost

before markup

Markup Amount

15% applied

Total Estimate

cost + markup

Cost by Category

#	Category	Material / Description	Qty	Unit	Unit Cost ($)	Total Cost	w/ Markup

Total Items

on punch list

Completed

items signed off

Remaining

before final payment

Completion Progress 0%

Final Sign-Off

Contractor Name

Date

Owner / Client Name

Date

John Smith

Contractor Signature

John Smith

Owner / Client Signature

Project Manager

ℹ️ Save your current project data here, then switch between projects. Each save captures all inputs, expenses, cash flow, and invoice data. Your data is saved in this browser only — use Ctrl+S to also save the HTML file itself.

Getting Started

Metric Definitions

Color Guide

Tips

Add Task

Non-Work Days

Add Punch List Item

Export Data to CSV