Contract value
Each project keeps the uploaded contract amount as the starting point.
Construction WIP
Construction finance teams, controllers, and accountants can upload a WIP workbook and check whether percent complete, earned revenue, and over/under billing are internally consistent.
WIP schedules mix contract value, estimates, actual cost, billings, and percent complete. A formula that slips on one project hides overbilling or margin fade. The check is: do the uploaded figures hold together?
Sample preview
Fictional project. Figures illustrate the review, not a live job.
Uploaded
Uploaded
Uploaded
From mapped method
Checked from inputs
Uploaded
Billings minus earned
How it works
Step 1
Project rows with contract, cost, billing, and complete fields.
Step 2
Contract value, estimated cost, actual cost, billings, and percent complete.
Step 3
Recheck derived figures from the mapped inputs using the construction engine.
Step 4
Overbilling, underbilling, estimate changes, and margin fade.
Step 5
Share project-level findings with the controller.
What this workflow is designed to do with uploaded files.
Each project keeps the uploaded contract amount as the starting point.
Estimate versus actual is available for review when both columns are mapped.
Completion can be checked against the cost or method columns you mapped.
Earned amounts derived from the file can be compared with billed amounts.
Billed-to-date sits next to earned so over/under billing is visible.
Billings above or below earned revenue are listed per project.
Estimate changes that reduce expected margin are review points.
When a prior file is provided, estimate movement can be compared.
Project P-18 has contract 2,400,000, estimated cost 2,000,000, actual cost 1,100,000, percent complete 55%, earned 1,320,000, billings 1,500,000. Overbilling is 180,000. That is a review figure, not a journal AuditExport posts.
WIP is easier to trust when each project’s over/under billing is listed from the same mapped columns. The page is for finance review, not for running the job site.
Continue with the workflows that usually sit next to this one.
No. It validates WIP calculations from uploaded spreadsheets.
You have billed more than the earned revenue implied by percent complete and contract value.
The expected profit on a project declines because estimated cost rose or contract value fell.
Upload the schedule. Review overbilling, underbilling, and estimate movement.