The WIP (Work in Progress) report provides financial insights for active jobs with budgets, including revenue earned, costs, percentage complete, and gross profit calculations.
1. Accessing the WIP Report
To view the WIP report:
Click Jobs
The WIP tab displays by default
Note: Only active jobs with budgets appear in the WIP report.
2. Understanding WIP Report Columns
The WIP report displays the following data columns:
Over/under: Amount over or under-billed for the job (Revenue earned - revenue to date)
Revenue Earned: Revenue earned on job
Cost Budget: Total cost budget
Revenue Budget: Total revenue budget
Costs to Date: Costs incurred through date on filter
Revenue to Date: Revenue collected to date through date on filter
Percentage Complete: Costs to date / cost budget
Earned Gross Profit: Earned gross profit (revenue earned - costs to date)
Revenue Calculation Type: The WIP calculation type used for this job
All column totals are summed at the bottom of the report.
3. Revenue Calculation Types
Three calculation types are available:
Percentage of Completion (default): Calculates earned revenue based on project completion percentage
Cost Plus Markup: Uses budget and markup fees included in draws
Sold Price: Commonly used for spec projects
4. Changing Calculation Types
Bulk Editing
To change calculation types for multiple jobs:
Select the desired jobs using checkboxes
Use the bulk action options at the bottom to set calculation types
Edit Mode
To modify individual jobs:
Click Edit Mode at the top of the page
Change the calculation type for each job
Set cost budget and revenue budget as needed
Individual Job Settings
To change settings for a single job:
Click into the specific job
Navigate to Settings
Select the WIP calculation type
5. Setting Lump Sum Budgets
For jobs without complete budgets in Adaptive:
Enable Edit Mode
Set a lump sum budget for jobs that don't have a cost budget
Important: Lump sum budgets cannot be set for jobs with change orders. Setting a lump sum budget on jobs with existing budgets will wipe existing budget values.
6. Viewing Historical Data
To view the WIP report as of a specific date:
Use the date selector
Choose the desired date (e.g., June 30th)
The report will display data as of that date
7. Filtering and Searching
Filter the WIP report by:
Job name (using the search function)
Class
Revenue calculation type
8. Exporting WIP Data
Two export options are available:
Download All: Exports all data displayed on the page
Download Selection: Export only selected rows (select specific jobs first)
9. Setting Default Calculation Type
To set a default WIP calculation type for all jobs:
Go to Settings
Navigate to General
Set the default WIP calculation type
This will apply to all jobs moving forward
10. Removing Jobs from WIP Report
To exclude a job from the WIP report:
Set the job's calculation type to None
The job will no longer be included in WIP calculations
Note: By default, only jobs with budgets appear in the WIP report.