WIP report

Instead of making decisions based on gut feeling or clever hindsight, use Scoro’s Work in progress report, or WIP report in short, to check if your projects are profitable while they’re still in process. This report helps you manage your project budgets effectively by providing a clear overview of billable time and project-related costs, including pending charges. 

To get the most out of the WIP report, use quotes for your projects to review the budgeted details versus actual results.

You’ll find the WIP report under Reports > Financial > WIP report.

This article shows how to enable, read, and export data from the WIP report.

1. Plan availability

The WIP report is available for the following Scoro plans:

• Current plans: Performance (as a paid add-on), Enterprise
• Legacy plans: Ultimate

For more information on Scoro's subscription plans, see our Plans & Pricing page.

2. How to enable the WIP report

Users need permission to view the WIP report. To manage which users on your site can access the WIP report, modify the necessary permission sets:

1. Go to Settings > Administration > Permission sets.
2. Click on Modules and actions for the relevant permission set.
   
3. Tick the View WIP report checkbox and save the changes.
   

Once enabled, you can access the WIP report under Reports > Financial > WIP report.

3. How to customize the WIP report view

3.1. Filters

You can filter the WIP report to customize it as needed. Use the primary user and date range filters, or click the Filter button to access even more filters, such as:

• Projects
• Project type
• Project status
• Project tags
• Creation date
• Start date
• Deadline
• Clients
• Contact tags
• Contact category

3.2. Data columns

The WIP report includes a wide range of revenue and cost-based data columns, providing a comprehensive financial picture of your business. You can choose which data columns to display, removing unnecessary ones to focus only on the specific insights you need.

To customize the data columns in your WIP report view:

1. Click the View button and select Data columns.
2. Tick the columns you want to display and untick the ones you don’t need. You can drag and drop them to change the order in which they’re shown in the report.
3. Click Display.

Here's more context on how various data columns are calculated:

• Chargeable sum – this is the sum you can charge your client for based on the proportion of the project completed.
  • Formula: Income budget * % of project completed
  • How % of the project completed: Actual project cost / budgeted cost
  • Example: We have a project with a budgeted cost of $1000. We have actually spent $500, so the % of the project completed is 500/1000=50%. Since we have spent half of the project cost, we should charge the customer half of the project income – if we sold the project for $2000, the calculation would be 2000*50%=$1000.
• Forecasted cost – the total cost at project completion.
• Forecasted revenue – displays the following depending on the project's revenue model:
  • Fixed fee: The locked, flat-fee contract budget
  • Time & Material capped: Total of done and planned work, with the total automatically capped at the budget ceiling if your team has planned more hours than the contract allows
  • Time & Material uncapped: Total done and planned work, uncapped
• Forecasted profit – calculated by subtracting forecasted cost from the forecasted revenue. Here's how it's adjusted based on the project's revenue model:
  •  Fixed fee and Time & Material capped: If your team logs or plans for excess hours, your costs will rise while your forecasted revenue remains capped, resulting in a drop in your forecasted profit.
  • Time & Material uncapped: Since every planned or logged hour increases both your costs and your billable revenue, your forecasted profit scales dynamically while preserving healthy margins.
• Income to date – the same value as the Earned column under the Budget tab > Profit sub-tab of the project view.

3.3. Summary bar

You can also enable a summary bar in the WIP report to show a selection of metrics that you want to track right above the data columns:

1. Click View and choose Summary bar.
2. Select the metrics you want to display in the summary bar. Drag and drop them as needed to change their order, tick the Round numbers checkbox if you prefer round numbers in your summary bar, and click Display.

4. Exporting data

The data from the WIP report can be exported as a CSV or XLS file for further analysis outside Scoro:

1. Tick all rows or the specific rows you’d like to export.
2. Click the Export button.
3. Select the file type you want to download.
4. Click Export.