Project Accounting WIP

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.

See how WIP is worked out

Now onboarding companies in Dhaka.

AdonERP
Nodi Polymer Industries

Project Accounting / WIP

PRJ-AUTOMATION · Line Automation Upgrade

active

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
A partial preview of WIP in Adon ERP Project Accounting. Company, project and figures are sample data.

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.

  1. % complete

    Spent over expected

    Cost to date divided by the estimated total cost gives the percent complete.

  2. Earned

    Percent of the contract

    Earned revenue is the percent complete times the revised contract value.

  3. 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

What follows it

Where it shows up

  • P&L

    Earned revenue and profit.

  • Schedule

    Physical progress beside cost progress.

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.

  1. Cost to date is 18,00,000 taka against an estimate of 45,80,000.

  2. Percent complete comes to 39.3%.

  3. Earned revenue is 20,90,830 taka.

  4. Billed to date is 15,00,000, so 5,90,830 is under-billed.

  5. The adjustment is posted for the period.

  1. An honest percent complete

    Based on cost, not on opinion.

  2. Over-billing flagged

    Billing ahead of the work is a liability, and the page says so.

  3. Under-billing flagged

    Work done but not yet billed is an asset to claim.

  4. 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

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.

Explore Project Accounting