Contractor WIP Schedule Builder

Build a work-in-progress schedule from your job list using percentage of completion (cost-to-cost). See earned revenue, gross profit, over and under billings, backlog and the jobs that need attention. Runs entirely in your browser; nothing is uploaded.

Jobs (CSV with columns Job, Contract Amount, Approved Change Orders, Estimated Total Cost, Cost to Date, Billed to Date, and optional Prior Year Earned Revenue, Prior Cost, Bid Margin)

Open a CSV file

Flag margin fade over (points)

Flag underbilling over (% of contract)

Not accounting advice. This is a simplified cost-to-cost input method (the approach ASC 606 allows for measuring progress on most construction contracts). It does not handle uninstalled materials, unapproved or pending change orders, claims, retainage, contract combining or segmenting, or variable consideration. Bonding companies, lenders and CPAs often ask for a WIP schedule; have your CPA review yours before you rely on it.