Audience: Builders
Read time: 10 mins
Article contents: Steps outlining how to produce a WIP report
Note: all figures on the WIP report are excluding tax
Where to find the WIP report
Click on the 'Jobs' menu.
In the sub menu, choose 'In Progress' or 'All' jobs.
Select 'More Actions'.
Choose to print or email the WIP report.
5. In the pop up, set the date range you would like to print or email.
6. Click 'OK'.
The following diagram shows the jobs that will be contained in your WIP report. Any jobs that start and finish outside of the date range entered, will not show on your report.
From the following pop up, select the file format you would like to use for your downloaded report.
Your file will appear and will include all jobs in progress for the date range you specified.
What determines if costs will be calculated?
Note: all figures on the WIP report are excluding tax
Contract Price
Contract Price is the estimate total amount plus markup, and any subsequent variations.
For variation costs to be calculated in here, they must be marked as 'Accepted' and have a variation acceptance earlier than the TO date.
Any Cost-Plus jobs will have a value of $0.00 in this field.
Invoiced To Date
Invoiced To Date is the amount invoiced to the client to date, including any eligible variations.
Your invoices will be calculated into this sum if they're at an applicable status (Invoiced, Part Received, Received) and the Invoice Date is before the TO date.
Invoiced Percentage (%)
Invoiced % is the % of the contract price invoiced to the client to date including any eligible variations.
It is calculated as (Invoiced to Date/Contract Price) x 100.
Estimated Costs
Estimated Costs is the budget amount including any subsequent eligible variations.
This comes directly from your estimate, including eligible variations, and any manually entered estimate costs in your job.
For variation costs to be calculated in here, they must be marked as 'Accepted' and have a variation acceptance date earlier than the TO date.
Actual Total
Actual Total is the total of the actuals column on the costings screen, it includes received purchase orders, completed work orders and any actual costs manually entered. This makes up expenditure and as expenses come as invoices it is sometimes referred to as such.
For any purchase orders to be calculated into this sum they must be an applicable status (Part Received or Received), for work orders they must also be an applicable status (Completed).
As well as the above status, the received/completed date must be earlier than the TO date.
Variance percentage (%)
Variance % is the difference between the estimated cost and the actual total as a percent of the estimated cost, essentially showing how far through the budget the spend is. It is calculated as (Actual Total/Estimated costs) X 100.
WIP
Depending on the job type, we use a different method of calculating the WIP.
For a detailed description of the WIP calculations, please see the link below: