Broadly, this report provides insight at four levels:
Project expenditure
How many hours and costs have been spent? And how does that compare to the budget?
Result
How does the invoiced revenue relate to the costs incurred from hours and purchases?
Revenue + expected revenue
The total value of the invoiced revenue and the revenue that is still expected.
Value of work in progress (WIP)
The value of the WIP provides insight into the hours/costs spent in relation to the invoiced revenue. Positive WIP means: more hours/costs have been spent than revenue has been invoiced. This is one of the most important columns to keep an eye on!
Determine your selection
By default, only active projects where invoicing is set to 'Yes' are shown. Internal projects are therefore never shown here.
The filter at the top of the page gives you extensive options to determine your selection.
A brief explanation of these filtering options:
Work in progress
Only shows projects with a positive or negative WIP balance. A positive WIP balance means: more hours/costs have been spent than invoiced.
My companies
Only available if multiple company profiles are active.
Team
Only shows projects where the selected team has been added to the project.
Project manager
Only shows the projects of the selected project leader.
Invoice method
Only retrieves the value of services with the selected invoice method.
The date in the top right determines the reference date of the selection. In other words: retrieve all totals up to and including the selected date. Important: if a date is chosen in the top right that falls outside the start and end date of the project, the project will not be shown in the report.
Example: Project start date: 01-01-2021 & project end date: 31-12-2021. If you select a reference date of 31-12-2020 here, the project will not be shown, regardless of whether the project is active or not.
Good to know: within Simplicate, we do not have a 'Date from' because projects can start at any time (even over several years).
An explanation of all columns
The report focuses on the WIP and the revenue that is still expected. Therefore, the page always opens on the right, and you can scroll left for more insight.
The Project Result report consists of several parts, which you can identify by the color of the line at the top of the column title:
Green: Hours
Orange: Costs
Purple: Result
Blue: Revenue
Below, the value per column is explained for each section.
HOURS
Hours | budget
This is the total amount of all budgeted hours.
Hours | spent
This is the total amount of all hours booked up to today. This means: number of hours x sales rate.
Hours | planned
This is the total amount of all hours booked after today. This means: number of hours x sales rate.
Hours | corrections
This is the total amount of all corrections made to hours.
Hours | remaining budget
This column shows the remaining amount of all budgeted hours. Hours spent on a service without a budget in euros are not included here.
The formula is: total budget of hours in euros - hours spent/planned/corrected in euros on a budgeted service.
COSTS
The first three columns of costs relate to the budget.
Purchases | budget
This is the total amount of what has been budgeted for purchases on all services.
Purchases | margin
This is the total amount of margin that has been set on all budgeted purchases. This is often a percentage as a markup on the purchase price.
Purchases | sales budget
The budgeted sales value of all purchases.
The formula is: total budget of all costs + total of the margin.
The following columns relate to the expenditure of costs and how this relates to the budget.
Purchases | spent
This is the total amount of all costs that have been booked on projects.
Purchases | realized margin
This is the total amount of the margin applied to the purchase booking. Please note: this realized margin only applies to services based on post-calculation. For a fixed price/subscription, the margin has already been settled in the price of the service.
Good to know: the margin could deviate from the budgeted margin because it can be influenced during booking.
Purchases | remaining budget
This column shows the remaining amount of all budgeted purchase costs.
The formula is: total of the purchase budget - the spent purchases.
Purchases | realized sales price
This column shows the total of the charged purchases.
Please note: this realized sales price only applies when the purchase could be charged based on post-calculation. For a fixed price/subscription, the purchase has already been settled in the price of the service.
RESULT
Current result | Gross margin
This column shows the total of the invoiced revenue, reduced by the purchases that have been spent.
Current result | Employee cost price
This column shows the costs of all hours spent by employees. The cost price is the price per hour recorded in the employee's schedule.
Current result | Project result
One of the most important columns that provides insight into the health of your projects. It shows the total of the invoiced revenue, reduced by the costs of purchases and hours.
The formula for this is: Invoiced revenue - Spent purchases - Employee cost price.
REVENUE and WIP
Revenue expected
This column shows the total of the invoiced revenue + the still expected revenue. The value shown depends on the invoicing method. Below is an explanation of what value you can expect per invoicing method:
Post-calculation
Shows the total value of all spent hours, or (if the hour budget is higher than the expenditure) the value of the budgeted hours is shown. It is therefore always the highest value of spent hours / budgeted hours.
Fixed price
Shows the total value of all fixed prices, both invoiced and still expected revenue.
Subscription
The invoiced + expected revenue of a subscription is only shown when the end date of a subscription is filled. Without an end date, it is not possible to determine how much revenue is expected.
The value therefore does not show what is still expected in terms of revenue, but mainly the value of the service.
Revenue invoiced
This column shows the total of the invoiced revenue up to and including the set reference date.
WIP
The WIP column indicates what revenue you can still expect.
The main formula for the WIP value is: all spent hours and corrections + the spent purchases - the invoiced revenue.
Important: this applies in any case to all services based on post-calculation. When the service is invoiced based on a fixed price/subscription, the value of the WIP may differ:
Fixed price
The WIP of a fixed price is never greater than the agreed price. After all: the more hours spent cannot be invoiced and are at your own expense.
When the fixed price has been fully invoiced and the total value of the recorded hours is greater than or equal to the fixed price, the WIP is by definition: 0 euro.
When no hours and/or costs can be registered on a service, for example a 'Discount' service, the invoiced revenue never generates WIP. After all: there is no work to be done, so there is no WIP.
Subscription
When the expected revenue is known (only possible if the subscription has an end date), the value of the WIP will never be greater than the agreed subscription price. After all: the more hours spent cannot be invoiced and are at your own expense.
When the expected revenue is not known (the subscription has no end date), the normal WIP formula as mentioned above applies.
Not loading the project result report
If the project result report does not load, an error message will appear indicating that the report cannot be loaded. In that case, you have the option to export this report.
A file is ready for export when the cache is fully loaded. This can be recognized by the date in a filled orange block, an example of which is shown below:
If the cache has been built up, you can export the file. If the block is not yet fully filled, the cache is still being built up. You will then have to wait until it is fully loaded, as indicated by 'cache built'.
Once the cache has been built up, you can export the file. You can export by clicking 'Export'.
The data will then be converted into an external file that can be opened. As soon as the export is completed, you will receive a notification and you can download the file.