Margin Billed

This metric represents the margin calculated in FBO at the time financial transactions are generated, typically when a timesheet or VMS is processed. It reflects the gross profitability of a transaction before any commission logic is applied.
The margin is calculated using the following formula:
Margin Billed =
Bill Amount (before Sales Tax)
– Client Discount Amount
– Accrued Rebate Amount (not actual rebate)
– Consultant Pay Amount (before Sales Tax, includes Vacation Pay)
– Employer Burden Amount (CPP, QPP, QPIP, Health Tax, EI, etc.)
– Stat Holiday Accrued Amount (estimated)
– Vacation Pay Accrued Amount
– Accrued CPP / EI Over-Cap Amount (after burden max is reached)
Exclusion: Margin Billed does not include Management Fee Transactions such as Background check, etc.

Currency Handling:

• All amounts are converted to the internal company currency (e.g., CDN$ for PCGL, US$ for PCUS) using the same exchange service as NetSuite.
• BI does not perform any additional currency conversion.

Date Context:

• The Transaction Date is used for reporting. This is the date the transaction was processed in FBO, not the date the work was performed.
• If a financial month has rolled over, the transaction may be logged in the next month.
• The Transaction Date is not the same as the Invoice Date. The invoice date gets created when an invoice is released. For Consolidated Invoices, this invoice date is often very different than the Transaction Date.

Rules & Criteria:

• Data Source: All data is sourced from FBO only.
• Accuracy: Margin Billed must match FBO’s margin calculation exactly, to the penny.
• Not for Commission Use: This is a gross margin and should not be used for commission calculations. This number is calculated in Forma and is based on Margin Billed, which is then modified to consider the various factors described in the Incentive Compensation Plan. This could include things like extraordinary expenses or income (Such as Rebate finalizations, etc.).
• Not Comparable to NetSuite: NetSuite uses a different margin logic for profitability. Contact Finance for NetSuite margin details.
• Do Not Compare this metric with Margin Worked! Margin Worked is based on when work was performed, but Margin Billed is based on when the transaction was processed. Over a complete workorder period, Margin Billed and Margin Worked will match.
• For Transaction HeaderId 2335862, the current Work Order Version Id is 269322. The Work Order Version Id 266465 is also linked to the transaction header, but since it’s not active, BI excludes it from reporting.
• If a Job Owner is linked to a Work Order Version flagged as deleted in the WorkOrder Commission table, BI leaves them out of the reporting.

Recognition:

• Sales: Any person listed as Job Owner or Additional Job Owner on the Work Order in FBO.
• Recruiter: Any person with a recruiter role tied to the Work Order in FBO.

Additional Notes:

• If the same person is both Sales and Recruiter, they receive both recognitions, but the margin is not double-counted.
• If multiple Sales or Recruiters are associated, each receives 100% recognition, but the total margin is still counted only once.