WIP: how much of the contract have you really earned?
Compare what you have spent with what you expect to spend in total, and the project tells you how far along it is. From that, earned revenue, over-billing and under-billing, and the profit you can expect.
Now onboarding companies in Dhaka.
Project Accounting / WIP
PRJ-AUTOMATION · Line Automation Upgrade
Percentage-of-completion (cost-to-cost): % complete = cost to date ÷ estimated total cost (EAC); earned revenue = % × revised contract value. Over-billing = billed in excess of earned; under-billing = earned in excess of billed. This is the WIP balance-sheet adjustment.
Contract value (revised)
BDT 53,20,000
Estimated total cost (EAC)
BDT 45,80,000
Estimated gross profit
BDT 7,40,000
Margin 13.9%
% Complete (cost-to-cost)
39.3%
Cost to date ÷ EAC
Revenue recognition
- Earned revenue (recognized)
- BDT 20,90,830
- Billed to date
- BDT 15,00,000
- Over-billing (billed > earned)
- BDT 0
- Under-billing (earned > billed)
- BDT 5,90,830
Cost to complete
- Cost to date (actual)
- BDT 18,00,000
- Estimated cost to complete (ETC)
- BDT 27,80,000
- Estimated total cost (EAC)
- BDT 45,80,000
How WIP is worked out, in three steps
The cost-to-cost method needs only three numbers: what you have spent, what you expect to spend in total, and the contract value.
- % complete
Spent over expected
Cost to date divided by the estimated total cost gives the percent complete.
- Earned
Percent of the contract
Earned revenue is the percent complete times the revised contract value.
- Over or under
Against what you billed
Billed more than earned is over-billing. Earned more than billed is under-billing.
What the page shows
- Four headline figures
- Revised contract value, estimated total cost, estimated gross profit and percent complete.
- Revenue recognition
- Earned revenue, billed to date, and the over or under-billing.
- Cost to complete
- Cost to date, the estimate to finish, and the estimated total.
- Margin
- Estimated gross profit as a share of the contract.
- A balance-sheet adjustment
- Over and under-billing are the WIP adjustment at period end.
WIP draws on cost, contract and billing
It is the point where the money spent, the contract and the billing are set side by side.
What feeds it
- Job Cost
Cost to date and the estimate.
- Change Orders
The revised contract value.
- Progress Billing
Billed to date.
What follows it
- Journal Entries
The WIP adjustment entry.
- Financial Reports
WIP in the balance sheet.
WIP for companies that bill in stages
A long project is billed in stages, not as it is earned. At the end of each period, someone has to say how much is really earned, and WIP does that.
One period end, from cost to WIP
A sample month end, the way it usually runs.
Cost to date is 18,00,000 taka against an estimate of 45,80,000.
Percent complete comes to 39.3%.
Earned revenue is 20,90,830 taka.
Billed to date is 15,00,000, so 5,90,830 is under-billed.
The adjustment is posted for the period.
An honest percent complete
Based on cost, not on opinion.
Over-billing flagged
Billing ahead of the work is a liability, and the page says so.
Under-billing flagged
Work done but not yet billed is an asset to claim.
Profit visible early
Estimated gross profit shows before the project ends.
Questions we get about WIP
What is WIP?
Work in progress: the revenue earned on a project that has not been fully billed or finished.
How is percent complete worked out?
Cost to date divided by the estimated total cost.
What is over-billing?
Billing more than you have earned, which is a liability.
What is under-billing?
Earning more than you have billed, which is an asset.
What does the revised contract value use?
The original contract plus approved change orders.
Where is Adon ERP available?
We are currently onboarding companies in Dhaka. Book a demo and we will walk through a sample project with you.
How different trades use WIP
- Retail
Fit-out contracts billed in stages.
- Food & Hospitality
Event and build-out contracts.
- Real Estate
Construction, the classic case for WIP.
- Consulting
Fixed-fee engagements billed by milestone.
- Manufacturing
Plant and line projects billed in stages.
- Health & Fitness
Fit-out contracts for clinics.
- Trades
Larger jobs billed in stages.
- Others
Grant-funded work billed in tranches.
Bring a project in progress. We will work out its WIP in the demo.
A live demo in English or Bangla, using sample books close to your own trade, with time for your accountant’s questions.