Report of work in progress

By 14 November, 2022 November 15th, 2022 Digital transformation, Progression, Reports

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:

  1. Service offerings
  2. Invoices
  3. Disbursed
  4. 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.

Reports tab in the Collabox main menu.

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

Image showing where to find the access to the work in progress report 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.

Work in progress report creation page with the different possible search filters.

The basic table generated by the Collabox looks like this.

Fictitious example of a table generated by the work in progress report.

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.

Excerpt from the first three columns, or first three fields, of the work in progress report. They contextualize the project with 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!

Excerpt from the first line of the work in progress report table that mentions the names of the fields related to the monetary portion of the projects.

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. (418) 907-9274