This report gives you a detailed overview of the financial status of a project, where you get detail level insights in the budgeted amount and the invoiced amount per project.
You can filter on project and project manager and when you expand the filter screen, you can additionally filter on the following fields:
Customer
Account manager
Customer category
Customer is active
Project category
Project is active
Cost center
Project is divided in an overview screen and a detail screen. In the overview screen you find a summary of the financial project information, i.e. the budgeted amount, the amount yet to be invoiced, the amount already invoiced and the fixed price amount, if any.
The detail screen is divided in agreed expenses, agreed hours, invoice proposals and invoiced amounts.
The screen has been divided in the following columns:
|
Project |
Project description |
|
Employee |
Employee |
|
Item |
Item |
|
Description |
Description of the performed task or of the expenses incurred |
|
Currency |
Currency code |
|
Quantity |
The number of hours or the number of expense units (for example kilometers) |
|
(AVG) Price |
Average price of the invoiced item. If, for example, you work with employee rates in your project, it may happen that different rates are entered in the project. This column then displays the average hourly rate |
|
Amount |
The amount to be invoiced, or invoiced |
Example
In the following example €5000 has been budgeted for the project. Five days of eight hours were entered into it, four of which have been approved. No invoice proposals have been created yet. The overview screen will then show that €5000 has been budgeted and that an amount of €4160 must be invoiced. The hours that have been posted, but not approved, will not be included in this overview. Here we only see the agreed hours.
The detail screen now only contains the 'Entered' category (Category: Booked). This category is divided into expenses and hours. Expenses show 75 kilometers travel expenses for an amount of €14.25. Hours show 32 hours for an amount of €4160. The 'Booked'category will show everything that has not yet been processed into invoice proposals.
Then an invoice proposal is drawn up for the first three days worked, i.e. the first 24 hours.
The ‘Booked’ category now only shows 1 day, i.e. 8 hours and 20 kilometers of travel expenses. The three days that have been included in the invoice proposal, have now been moved to the ‘In proposal’ category. When you expand the ‘In proposal’ category, you see the invoice lines included in the proposal.
Then the invoice proposal will be approved and processed. The 3 days and the travel expenses from the ‘In proposal’ category have now been moved to the ‘Invoiced’ category and have been allocated to an invoice number. When you expand the invoice, you see the invoice lines in the invoice.
The report totals are calculated on category and the ‘Booked’ category is subtotaled on ‘Expenses’ and ‘Hours’. Note: For the ‘Booked’ category, totals are calculated in hours and expenses, i.e. that different units are added up. In the following example 20 kilometers of travel expenses are added to 16 hours worked, and a quantity of 36 is shown on the report. This also affects the view of the average price on the bottom line of the ‘Booked’ category, for this will divide the total invoiced amount by the number of units on this bottom line, so in this case the average price will be lowered by the travel expenses per kilometer.
Comments