The work in progress report allows you to quickly view all of your billable projects by transaction (timesheets) with their status. Not only will you see the tracking of amounts in real time, but you will be able to see the percentage of hours completed.
This will allow you to manage your business well. It requires the use of several ERP (enterprise resource planning) functions of the Collabox.
Preliminary checks
To get the “real” numbers for your company, first make sure you have made the following entries for each project in Collabox:
- Service offerings
- Invoices
- Disbursed
- Time sheets
Also, make sure that the updates on the projects have been made and that the “billable by transaction” box is checked in the project form.

Produce the work in progress report
First, select the “Reports” menu.

Then click on the “Work in Progress Report” tab in the left grey menu.

There are several filter options available to you for creating the report. Check the desired items and select options from the drop-down menus, if applicable. Transactions refer to the timesheet entries of your employees.

The basic table generated by the Collabox looks like this.

Field description
The table produced in the report is divided by column. Each column is associated with a particular field. The first fields refer to the context of the project. First, see the client’s name, project number and name.

The second portion of the table refers to the financial aspect of the project. It shows the expected amount of money from the service offering. The amount already invoiced to the customer is shown, as well as the amount still to be invoiced.
Progress refers to the percentage of completion handwritten by the employee in the project sheet. In turn, the calculated progress refers to the percentage of the planned money (fees, equipment, product, subcontracting, etc.) that is actually spent based on the information in the service offering.
Then comes the actual profitability of the project. The “Work in Progress” column refers to the amount of money worked but not yet invoiced. Be sure to update the percentage of progress on your projects to get a real time number. Finally, a quick glance at the “hours worked” field allows you to see the progress in hours of the project and to anticipate cost overruns before they occur!

Watch several videos on our Youtube channel and visit our Tips and Tricks section in the Blog to continue your Collabox configuration!
If you have any questions, please contact us and we will be happy to answer you.
info@collabox.com (418) 907-9274