Billing Rates

Modified on Tue, 28 Jul at 12:29 PM

Model Summary

The QQube Billing Rates Lookup Data Model shows the configured and effective billing rate for each service item and the employee, vendor, or other name assigned to the work.

Model Type	Billing rate lookup
Lookup Table	Billing Rate Details
Primary Result	Configured and effective service-item billing rates by billing name
Power BI Measure	Billing Rate Effective Rate

Best Used For

Reviewing the effective billing rate for a service item.
Comparing billing-rate assignments for employees, vendors, and other names.
Validating configured billing rates before using them in time and job-cost analyses.
Reviewing billing rates across QuickBooks company files.

QuickBooks Source

Billing rates are maintained in QuickBooks and synchronized into QQube for use in the prepared lookup model.

Billing Rate List

QuickBooks Billing Rate list

Billing Rate Example

QuickBooks Billing Rate example

QuickBooks Billing Rate details

Billing Rate Details Lookup

The Billing Rate Details lookup table supplies the lookup context and calculated rate used by the model.

Measure	Billing Rate Effective Rate

Billing Rate Dimension

The Billing Rate Dimension describes the QuickBooks billing rate used by the lookup.

Display Order	Field Name
1	Billing Rate Active
2	Billing Rate Name
3	Billing Rate Type
4	Billing Rate Fixed Rate

Included Dimensions

The following five dimensions are included for filtering and analyzing the Billing Rate Details lookup.

Company	Employee
Other Name	Service Item
Vendor

Expected Result

Open the prepared Billing Rates Lookup example and select the company, service item, employee, vendor, or other name needed for the analysis.

The Billing Rate Effective Rate measure returns the effective rate for the selected lookup context. The lookup table, Billing Rate Dimension, and related dimensions are already included.