Understanding WIP methods in project management

As a project progresses, materials, resources, and other expenses are consumed and must be posted to the project. Work in Process (WIP) is a feature that enables you to estimate the financial value of projects in the general ledger while the projects are ongoing. In many cases, you might post expenses for a project before invoicing a project. When only expenses are posted, your financial statement is inaccurate.

To track the value in the general ledger, you can calculate WIP and post the value to the general ledger. For more information, see Monitor Project Progress and Performance.

Out of the box, Business Central supports the following methods of calculating and recording the value of work in process.

WIP MethodDescriptionRecognized CostsRecognized Sales
Cost ValueRecognizes cost when the customer is invoiced. Recognizes sales based on the invoiced sales.Cost ValueContract (Invoice Price)
Cost of SalesRecognizes cost when the customer is invoiced. Recognizes sales based on the invoiced sales.Cost of SalesContract (Invoiced Price)
Sales ValueRecognizes costs as they're reported. Recognizes sales proportionally to the reported costs.Usage (Total Cost)Sales Value
Percentage of CompletionRecognizes costs as they're reported. Recognizes sales proportionally to the reported costs.Usage (Total Cost)Percentage of Completion
Completed ContractNo sales or costs are part of the WIP calculation. Completed contract doesn't recognize revenue and costs until the project is complete. For example, this option is useful when there's high uncertainty around the estimates of costs and revenue for the project.At CompletionAt Completion

Exact formulas and general ledger transactions are defined by the selection in the Recognized Cost and Recognized Sales fields.

Create a project WIP method

Create a project WIP method that meets the needs of your organization and set it as the default.

Note

After you use a method to create WIP entries, you can't modify or delete the method.

  1. Select Search (Alt+Q) in the upper-right corner, enter Project WIP Methods, and then choose the related link.
  2. Choose the New action, select the appropriate values for the Recognized Costs and Recognized Sales fields, and then fill in the other fields as necessary. Hover over a field to read a short description.
  3. Close the page.
  4. To make this method the default, select Search (Alt+Q) in the upper-right corner, enter projects setup, and then choose the related link.
  5. In the Default WIP Method field, choose the method from the list.

Recognized cost

Recognized CostRecognized Cost Calculation FormulaGeneral Ledger Entries
At Completion0 (Zero)Dt Recognized Costs Account Cr WIP Costs Account
Amount: RecognizedCost

Dt WIP Costs Account Cr Project Costs Applied Account
Amount: MAX[RecognizedCost; Actual (Total Cost)]
Cost of SalesActual (Total Cost) - Budget (Total Costs) * Invoiced%, where:

Invoiced% = Invoiced (Total Price) / Billable (Total Price)

Note: This calculation requires that the Billable (Total Price) and Budget (Total Costs) are correctly entered for the whole project.
Dt Recognized Costs Account Cr WIP Costs Account
Amount: RecognizedCost

Dt WIP Costs Account Cr Project Costs Applied Account
Amount: MAX[RecognizedCost; Actual (Total Cost)]

Dt Project Costs Adjustment Account Cr WIP Accrued Costs Account
Amount: RecognizedCost – Actual (Total Cost), If RecognizedCost > Actual (Total Cost)
Cost ValueActual (Total Cost) – [Completion% – Invoiced%] * Billable (Total Price) * BudgetCostPriceRatio, where:

BudgetCostPriceRatio = Budget(Total Cost) / Budget (Total Price)
Invoiced% = Invoiced (Total Price) / Billable (Total Price)
Completion% = Actual (Total Cost)/Budget (Total Cost)

Note: This calculation requires that the Billable (Total Price), Budget ( Total Price), and Budget (Total Costs) be correctly entered for the whole project.
Dt Recognized Costs Account Cr WIP Costs Account
Amount: RecognizedCost

Dt WIP Costs Account Cr Project Costs Applied Account
Amount: MAX[RecognizedCost; Actual (Total Cost)]

Dt Project Costs Adjustment Account Cr WIP Accrued Costs Account
Amount: RecognizedCost – Actual (Total Cost), If RecognizedCost > Actual (Total Cost)
Contract (Invoiced Cost)Invoiced (Total Cost)Dt Recognized Costs Account Cr WIP Costs Account
Amount: RecognizedCost

Dt WIP Costs Account Cr Project Costs Applied Account
Amount: MAX[RecognizedCost; Actual (Total Cost)]

Dt Project Costs Adjustment Account Cr WIP Accrued Costs Account
Amount: RecognizedCost – Actual (Total Cost), If RecognizedCost > Actual (Total Cost)
Usage (Total Cost)Actual (Total Cost)Dt Recognized Costs Account Cr WIP Costs Account
Amount: RecognizedCost

Dt WIP Costs Account Cr Project Costs Applied Account
Amount: MAX[RecognizedCost; Actual (Total Cost)]

When project status is changed to Completed, the Calculate WIP task reverts the WIP transaction and posts instead.

Dt Recognized Cost Account Cr Project Cost Applied Account , Amount: Actual (Total Cost)

Note

Depending on the selection in the WIP Posting Method Used field, the Item Cost Applied Account, Resource Cost Applied Account, or G/L Cost Applied Account could be used instead of Project Cost Applied Account. For more information, see Project posting groups.

Recognized sales

Recognized SalesRecognized Sales Calculation FormulaGeneral Ledger Entries
At Completion0 (Zero)Dt WIP Invoiced Sales Account Cr Recognized Sales Account
Amount: RecognizedSales

Dt Project Sales Applied Account Cr WIP Invoiced Sales Account
Amount: Invoiced (Total Price)
Contract (Invoiced Price)Invoiced (Total Price)Dt WIP Invoiced Sales Account Cr Recognized Sales Account
Amount: RecognizedSales

Dt Project Sales Applied Account Cr WIP Invoiced Sales Account
Amount: Invoiced (Total Price)
Usage (Total Cost)Actual (Total Cost)Dt WIP Invoiced Sales Account Cr Recognized Sales Account
Amount: RecognizedSales

Dt Project Sales Applied Account Cr WIP Invoiced Sales Account
Amount: Invoiced (Total Price)
Percentage of CompletionMIN[Billable (Total Price) * Completion%; Billable (Total Price)], where:

Completion% = Actual (Total Cost)/Budget (Total Cost)

Note: This calculation requires that the Billable (Total Price) and Budget (Total Costs) are correctly entered for the whole project.
Dt WIP Accrued Sales Account Cr Recognized Sales Account
Amount: RecognizedSales

Dt Project Sales Applied Account Cr WIP Invoiced Sales Account
Amount: Invoiced (Total Price)
Usage (Total Price)Actual (Total Price)Dt WIP Invoiced Sales Account Cr Recognized Sales Account
Amount: RecognizedSales

Dt Project Sales Applied Account Cr WIP Invoiced Sales Account
Amount: MAX[RecognizedSales; Invoiced (Total Price)]

Dt WIP Accrued Sales Account Cr Project Sales Adjustment Account
Amount: MAX[RecognizedSales; Invoiced (Total Price)] - Invoiced (Total Price)
Sales ValueActual (Total Price) * Billable (Total Price)/Budget (Total Price)

Note: This calculation requires that the Billable (Total Price) and Budget (Total Price) are correctly entered for the whole project.
Dt WIP Invoiced Sales Account Cr Recognized Sales Account
Amount: RecognizedSales

Dt Project Sales Applied Account Cr WIP Invoiced Sales Account
Amount: MAX[RecognizedSales; Invoiced (Total Price)]

Dt WIP Accrued Sales Account Cr Project Sales Adjustment Account
Amount: MAX[RecognizedSales; Invoiced (Total Price)] - Invoiced (Total Price)

When the project status is changed to Completed, the Calculate WIP task reverts the WIP transaction and posts instead.

Dt Project Sales Applied Account Cr Recognized Sales Account , Amount: Invoiced (Total Price)

Project Management
Finance
Purchasing
Sales
Work with Business Central

Find free e-learning modules for Business Central here