When you analyze your billing indicators, you may observe discrepancies between the amounts displayed in your widgets and those in your invoice lists. These differences are normal and are explained by distinct calculation logics between these two tools.
This article presents the main cases where these differences appear, to help you correctly interpret your data.
Case 1: Filtering by Business Unit
What's happening?
When you filter your data by Business Unit, the widgets and the invoice lists do not display the same amounts as they apply different logics.
How do the widgets filtered by BU work?
Widgets such as "Invoiced Gross Margin by BU" or "Invoiced MB for the period" calculate only the billing amounts distributed on the selected Business Unit.
Concrete example:
• Invoice Y linked to a project: €10,000 Revenue
• Project distribution: 60% BU A / 40% BU B
• Project MB: €5,000
• Invoice represents 50% of the project
Result in the widgets:
• Widget "Invoiced MB" filtered on BU A → €1,500 (60% of €2,500 Invoiced MB)
• Widget "Invoiced MB" filtered on BU B → €1,000 (40% of €2,500 Invoiced MB)
The widgets calculate the invoiced gross margin proportionally to the distribution on each BU.
How do the invoice lists filtered by BU work?
The invoice lists display all invoices linked to projects that contain at least one distribution on the selected Business Unit, with the total invoice amount.
Concrete example (same invoice):
• Invoice Y: €5,000 (50% of the €10,000 project)
• Project distribution: 60% BU A / 40% BU B
Result in the lists:
• List filtered on BU A → displays invoice Y with €5,000
• List filtered on BU B → displays invoice Y with €5,000
How to analyze invoices by BU?
To analyse in detail the distribution of your invoices by Business Unit, use the accounting export:
Finance > Accounting Exports > Invoice Tab > Export invoices (with project detail)
This export contains dedicated columns:
• Invoice Revenue BU: Revenue invoiced on the BU(s) associated with this invoice
• Invoice MB BU: Invoiced gross margin on the BU(s) associated with this invoice
⚠️ Note:
BU analysis depends on the distribution of rate card lines configured on your projects. Check that the CHECK MB indicator shows MB ok in your project lists to ensure this distribution is correct and obtain reliable data.
To go further
Key points
The differences between widgets and invoice lists are explained by distinct calculation logics: widgets filter by billing amounts distributed on each BU (proportionally to project distributions), while lists display total invoice amounts. Check the MB Ok indicator to ensure the reliability of your BU analyses.
