The WIP (Work in Progress) report helps you track job profitability by comparing budgets, costs, billings, earned revenue, and gross profit across active jobs.
Use the WIP report to review project progress, identify over billing or under billing, update WIP calculation settings, and export current WIP data.
1. Accessing the WIP Report
To view the WIP report:
Click Work in progress in the left navigation.
The WIP report tab opens by default.
The WIP page may also include these tabs:
WIP report: View WIP values by job.
Custom report: View or manage a custom WIP report template, when available.
Comments: Review WIP-related comments.
Settings: Set the default WIP calculation type.
Note: Access to the WIP report depends on your permissions. Editing budgets requires Manage jobs permission.
2. Understanding WIP Report Columns
The WIP report includes columns for job progress, budget, billing, and profitability. Common columns include:
Job: The job name.
Notes: Job-specific WIP comments.
Over billing: Amount billed above earned revenue.
Under billing: Earned revenue not yet billed.
Revenue earned: Revenue earned based on the job’s WIP calculation type.
Cost budget (original): Original budgeted cost.
Changes (costs): Cost changes added to the job.
Cost budget (current): Current cost budget after changes.
Revenue budget (original): Original revenue budget.
Changes (revenue): Revenue changes added to the job.
Revenue budget (current): Current revenue budget after changes.
Costs to date: Approved costs from project start through the selected As of date.
Billings to date: Total billings from project start through the selected As of date.
Cost to complete: Cost budget minus costs to date.
% complete: Costs to date divided by cost budget.
Earned gross profit: Revenue earned minus costs to date.
Billed gross profit: Billings to date minus costs to date.
Projected gross profit: Expected total gross profit based on current progress.
Billings remaining: Revenue budget minus billings to date.
Gross profit remaining: Expected remaining gross profit.
Job borrow: Amount overbilled beyond remaining gross profit.
Cash flow remaining: Revenue budget minus billings to date minus cost to complete.
You can show, hide, and reorder columns using the table configuration controls. Column totals appear at the bottom for summable columns.
Note: Some revenue budget columns may be hidden if your role does not include permission to view revenue budgets.
3. Revenue Calculation Types
Each job uses a WIP calculation type to determine revenue earned.
Available calculation types include:
Percentage of completion: Calculates revenue earned from percent complete and the current revenue budget.
Costs plus markup: Calculates revenue earned from costs plus markup from budget lines and draws.
Sold price: Calculates revenue earned from the sold price when the job is marked sold.
None: Excludes the job from WIP earned-revenue calculations.
To see how Revenue earned is calculated for a job, click the calculator icon in the Revenue earned column.
4. Editing Budgets and Calculation Types
To edit WIP settings for jobs:
Open the WIP report tab.
Click Edit budgets.
Update the job’s calculation type, budget values, markup, completion status, or notes.
Click Save.
In edit mode, you can update:
Revenue calculation type
Cost budget (current)
Revenue budget (current)
Job complete
Notes
When multiple jobs are selected, use the bulk action bar to:
Mark jobs as complete or incomplete.
Set a calculation type.
Save or cancel changes.
Important: Jobs with detailed line-item budgets may need to be edited from the job budget instead of directly in the WIP table.
5. Setting the Default WIP Calculation Type
To set the default calculation type:
Open Work in progress.
Click the Settings tab.
Select a value for Default WIP calculation type.
The default type applies to new jobs and to existing jobs that do not already have a WIP calculation type.
6. Using Lump Sum Budgets
Lump sum budgets are used when a job does not have a detailed line-item budget in Adaptive.
To enable a lump sum budget from the WIP report:
Open Work in progress.
Click Edit budgets.
Find the job you want to update.
Enter values in Cost budget (current) and/or Revenue budget (current).
Click Save.
When lump sum budgets are enabled for a job, the WIP report uses the job’s lump sum Cost budget (current) and Revenue budget (current) values.
Note: If a job already has a full detailed budget, Adaptive links you to the job budget instead of allowing the lump sum budget to be edited directly in the WIP table.
7. Viewing Historical WIP Data
Use the As of date filter to view WIP values through a specific date.
When an As of date is selected, the report limits costs, billings, and related WIP calculations to activity through that date.
This is useful for reviewing WIP as of month-end, quarter-end, or year-end.
8. Filtering and Searching
Use the search and filter controls to narrow the WIP report.
You can filter by:
Search: Job name.
As of: Date used for WIP calculations.
Revenue calculation type
Budget type
Has transaction in
Job status
Job included
Job excluded
Accounts
Cost codes
Classes
People on job
Cost budget
Default filters include jobs with budget activity and recent transactions. Use Clear filters or Reset to default filters to adjust the view.
9. Reviewing Costs and Billings
Click values in Costs to date or Billings to date to review the transactions behind the number.
Costs to date may include approved:
Bills
Receipts
Vendor credits
Time sheets
Journal entries, if enabled
Billings to date includes invoices and, when enabled, journal entries.
Note: Journal entries are controlled in company settings. When enabled, journal entries can be included in WIP costs and billings from a selected starting date.
10. Exporting WIP Data
To export the WIP report:
Configure the filters, date, and visible columns you want.
Click Download.
Adaptive exports the WIP report as an XLSX file.
The export uses the current filters, As of date, and visible column order.
Note: The standard WIP export downloads all rows in the current report view. It does not export only selected rows.
12. Removing Jobs from WIP Calculations
To remove a job from WIP earned-revenue calculations:
Open the job.
Go to Settings.
Under WIP calculation, select None.
Click Save.
Jobs set to None remain visible when included by your filters, but earned-revenue and related WIP calculations are excluded.
If you have any questions or want to share feedback, feel free to reach out at [email protected].