Customizable Billing Report

This report produces comprehensive billing data related to invoiced timecards in the system.

Note: The application automatically suggests values for some report filter fields.

Begin typing, for example, the last name of the person (worker, manager, and so on). If you enter the first name of the person, the system does not automatically suggest a name.

The Billing Rate Type Detail Report supports BYOK encryption. See Bring Your Own Key Encryption.

This report produces the following columns:

Note: When only default output is selected/configured, then information is output as one line per billing line item.

Default output columns:
- Invoice Option
- Status
- Billing Status Reason - If timecard status is 'Saved' or 'Processed', this field is empty.
- Line #
- Worker
- Job Title
- Country
- City
- State/Province
- Worker #
- Engagement#
- Pay Rate
- Mark Up
- Bill Rate
- Rule Description
- OT Multiplier
- OT Rate
- DT Multiplier
- DT Rate
- Holiday Multiplier
- Holiday Rate
- Supplier
- MSP Cli %
- MSP Sup %
- Operational Unit
- Manager
- Time&Expense Approver
- Dept Lvl 1
- Dept Lvl 2 - Displays if sub-departments are configured for a parent department.
- Dept #
- Currency
- Rate Application Type
- Earnings E/D
- Start Date
- Period Billed
- Days worked in Period
- Days
- Reg Hrs
- OT Hrs
- DT Hrs
- Leave Hrs
- Billable Leave Hours - PTO hours if client organization has leave tracking enabled.
  For more information about enabling leave tracking, see Client Location Leave Tracking.
- Unpaid Time
- Sick Time - Number of sick hours for Hourly timecards, or number of sick days for Daily, Period, or Mixed timecards.
- Milestones
- Materials
- Position
- Exp
- Adj - Only viewable to suppliers where the billing filter is set to viewable by supplier.
- Filter Billing
- Sales Tax - Value is rounded to two decimal places.
- MSP VAT
- Supplier VAT
- MSP Cli $
- MSP Sup $
- Total Pay Supplier
- Total Bill - Value is rounded to two decimal places.
- Invoice #
- Inv Date
- Invoice E/D
- Job Category
- Units Worked
  - Concatenated as <piece_type_name>|<units_worked>.
  - Sum of units for each piece type or multiple rate for a work week period.
- Piece Bill Rate - Concatenated as <piece_type_name>|<piece_type_bill_rate>.
- Piece Pay Rate - Concatenated as <piece_type_name>|<piece_type_pay rate>.
- Multiple Rate
  - Concatenated as <multiple_rate_name>|<bill_rate>|<number_of_hours>|<rate_type> or <multiple_rate_name>|<bill_rate>|<number_of_days>|<rate_type>.
  - Daily rate displays in number of days.
  - Hourly rate displays in number of hours.
  - Rate type is the sum total amount for each rate type.
- Client Building Code
- Client Address
- Client Postal Code
- Work Address
- Work City/Town
- Work State/Province
- Work Postal Code
- Work Country
- Work Building Code
- Offsite Address
- Offsite City/Town
- Offsite State/Province
- Offsite Country
- General Comment
- Credited By Bill
- Rebilled By Bill
- Date Credited
- Credit For Bill
- Rebill For Bill
- VMS Billing Line
Miscellaneous section
- GST Amount
- CGST Amount
- SGST Amount
- IGST Amount
- HST Amount
- QST Amount
- RST Amount
- PST Amount
- MSP Sales Tax Down Amount
- MSP Sales Tax Up Amount
- MSP VAT Down Amount
- MSP VAT Up Amount
- MSP GST Amount
- MSP GST Down Amount
- MSP CGST Amount
- MSP CGST Down Amount
- MSP CGST Up Amount
- MSP SGST Amount
- MSP SGST Down Amount
- MSP SGST Up Amount
- MSP IGST Amount
- MSP IGST Down Amount
- MSP IGST Up Amount
- MSP HST Amount
- MSP HST Down Amount
- MSP HST Up Amount
- MSP QST Amount
- MSP QST Down Amount
- MSP QST Up Amount
- MSP RST Amount
- MSP RST Down Amount
- MSP RST Up Amount
- MSP PST Amount
- MSP PST Down Amount
- MSP PST Up Amount
- Consumption Tax
- MSP Consumption Tax Down Amount
- MSP Consumption Tax Up Amount
- Service Tax
- MSP Service Tax Down Amount
- MSP Service Tax Up Amount
- MSP Service Tax
- Swachh Bharat Cess
- MSP Swachh Bharat CESS
- Krishi Kalyan Cess
- MSP Krishi Kalyan Cess
- Pay GST Amount
- Pay CGST Amount
- Pay SGST Amount
- Pay IGST Amount
- Pay HST Amount
- Pay QST Amount
- Pay RST Amount
- Pay PST Amount
- Pay Sale Tax
- Pay VAT
- Pay Consumption Tax
- Pay Service Fee
- Pay Swachh Bharat Cess
- Pay Krishi Kalyan Cess
- VDisc %
- VDisc $
- PPay %
- PPay $
- Contractor Manager
- Raw Bill
- AP Inv#
- Sup Inv#
- Client Inv #
- PO #
- Internal Supplier Reference
- T&E Approver GUID
- T&E Approver External Id
- T&E Approver Email
- Up Fee Inv #
- Down Fee Inv #
- GUID
- Engagement Start Date
- Engagement Estimated End Date
- Engagement Actual End Date
- Did Not Work
- Manager Email
- Time Entry Interface
- Billing Item Type
- Master Budget ID
- Budget ID
- Budget Amount
- Remaining
- Total Spent
- Funds Tracking Type
- Check #
- Release Date
- Payment Type
- WO/SOW #
- WO/SOW Title
- Research
- Made Non Billable by
- Supplier Bill Rate
Time Detail section
- Date Worked
- Days
- Start Time
- End Time
- Hours
- Regular Hours
- Non Billable Hours
- OT Hours
- DT Hours
- Client Bill Amount - Detail amount per day.
- Multiple Rate
  - Concatenated as <multiple_rate_name>|<bill_rate>|<number_of_hours>|<rate_type> or <multiple_rate_name>|<bill_rate>|<number_of_days>|<rate_type>.
  - Daily rate displays in number of days.
  - Hourly rate displays in number of hours.
  - Displays as total hours per day worked, with each day line displaying the multi rate value.
  - All rates for an operational unit display, but only rates with time entered have value.
- Piece Bill Rate
  - Concatenated as <piece_type_name>|<piece_type_bill_rate>|<units_worked>.
  - For multiple piece types logged for a single day, displays concatenated values, separated by a comma.
  - All rates for an operational unit display, but only rates with time entered have value.
- Start Lunch
- End Lunch
- Lunch
- Notes
- Time Status
- Time Status Reason
- Time Date and Time Approved
- Time Created By
- Time Approved By
- Time Cost Allocation
- Time Billing Auxiliary Field (1-5) - One column per configured field.
- Work Performed in the US?
- Did Not Work
Milestone Detail section
- Milestone
- Milestone Date
- Milestone Due Date
- Milestone Comment
- Milestone Amt
- Milestone Status
- Milestone Status Reason
- Milestone Date and Time Approved
- Milestone Created By
- Milestone Approved By
- Milestone Approved By GUID
- Milestone Cost Allocation
- Milestone Billing Auxiliary Field (1-5) - One column per configured field.
Material section
- Material
- Material Date Purchased
- Material Quantity
- Material Comment
- Material Amt
- Material Status
- Material Status Reason
- Material Date and Time Approved
- Material Created By
- Material Approved By
- Material Approved By GUID
- Material Cost Allocation
- Material Billing Auxiliary Field (1-5) - One column per configured field.
Position section
- Position
- Position Earnings E/D
- Position Hrs Worked
- Position Comment
- Position Amt
- Position Notes
- Position Status
- Position Status Reason
- Position Date and Time Approved
- Position Created By
- Position Approved By
- Position Approved By GUID
- Position Cost Allocation
- Position Billing Auxiliary Fields (1-5) - One column per configured field.
Expense section
- Category
- Description - Concatenated as <mileage>, <from>, <destination>, <second_destination>.
- Purpose
- Amount
- Expense Date
- Create Date
- Receipts Received
- Notes
- Expense Status
- Expense Status Reason
- Expense Date and Time Approved
- Expense Created By
- Expense Approved By
- Expense Approved By GUID
- Expense Canst Allocation
- Expense Billing Auxiliary Fields (1-5) - One column per configured field.
- Auto Type - Expense category
- Auto Name - Expense category
- Auto Mileage From - Expense category
- Auto Mileage Destination - Expense category
- Communication Type - Expense category
- Communication Frequency - Expense category
- Entertainment Who - Expense category
- Entertainment Where - Expense category
- Entertainment What - Expense category
- Entertainment Why - Expense category
- Lodging Name - Expense category
- Lodging City - Expense category
- Lodging State - Expense category
- Meal Type - Expense category
- Meal Where - Expense category
- Travel Type - Expense category
- Travel From - Expense category
- Travel Destination - Expense category
- Travel Duration - Expense category
Adjustment Detail section - Section only viewable to suppliers where the billing filter is set to viewable by supplier.
- Adj. Classification
- Adj. Reason
- Adj. Justification
- Adj. Shift
- Date Adj.
- Day Adj.
- Adj. Reg. Hour
- Adj. OT Hour
- Adj. DT Hour
- Adj. Hol. Hour
- Adj. Amount
- Duplicate Reason
- Adj. Type
- Ref Detail Itemid
- Adj. Note
- Adj. Status
- Adj. Status Reason
- Adj. Date and Time Approved
- Adj. Created By
- Adj. Approved By
- Adj. Approved By GUID
- Adj. Cost Allocation
- Adj. Billing Auxiliary Fields (1-5) - One column per configured field.
Dates of Interest section
- Date/Time Created
- Date Escalated
- Date/Time Exported
- Date Invoiced
- Date Client Posted
- Date Client Paid
- Date Status Pending
- Date Sent to PeopleSoft
- Date Posted to Client GL
- Date Made Non Billable
Shift Differential section
- Shift Type
- Value
- Shift Reg Rate
- Shift OT Rate
- Shift DT Rate
- Total Shift Hours
Daily Tier section
- Daily Tier Value
- Tier Rate
Purchase Order section
- Primary PO#
- Primary PO Depleted Amount
- Secondary PO#
- Secondary PO Depleted Amount
Taxes section
- Tax Calculation Method
- Apply Tax To
- Tax Type
- Tax Amount
- Percent Calculated
- Regular Tax
- MSP Up Fee Tax
- MSP Down Fee Tax
- Tax Updated Date
- Tax Source
- Tax Category
- Affects Bill Client
- Affects Pay Supplier
Requisition Custom Fields
- Encrypted custom fields display asterisks (*****).
- Fields are included based on the Billing Earning End Date in relation to the Effective Date for the custom field.
- Column names display as <operational_unit_name>.<custom_field_name>
Worker Custom Fields
- Encrypted custom fields display asterisks (*****).
- Fields are included based on the Billing Earning End Date in relation to the Effective Date for the custom field.
- Column names display as <operational_unit_name>.<custom_field_name>
Supplier Custom Fields
- Encrypted custom fields display asterisks (*****).
- Fields are included based on the Billing Earning End Date in relation to the Effective Date for the custom field.
- Column names display as <operational_unit_name>.<custom_field_name>
Manager Custom Fields
- Encrypted custom fields display asterisks (*****).
- Fields are included based on the Billing Earning End Date in relation to the Effective Date for the custom field.
- Column names display as <operational_unit_name>.<custom_field_name>
Department Custom Fields
- Encrypted custom fields display asterisks (*****).
- Fields are included based on the Billing Earning End Date in relation to the Effective Date for the custom field.
- Column names display as <operational_unit_name>.<custom_field_name>


Field	Description
Operational Unit	From the drop down, select the operational unit to filter by. Only OpUnits configured for the client organization display in this field.
Layout	Select the report layout.
<department>	Select the name of the department to filter by. This field is set to 'All' by default. If a client organization has sub-departments configured, another field appears that allows you to select sub-departments of the parent department.
Worker Name	Select the name of the worker to filter by. The default value for this field is 'All' by default.
Manager	Select the client manager name associated with the engagement. This field is set to 'All' by default.
Time&Expense Approver	Select the time & expense approver to filter by. This field is set to 'All' by default.
Supplier	Select the name of the supplier/vendor to filter by. This field is set to 'All' by default.
Billing Item Status	Click a status value to filter results by. You can select multiple statuses, or select 'All'.
Billing Item Status Reason	Click a reason value to filter results by. You can select multiple statuses, or select 'All'.
Invoice Option	Select the invoice option for the engagement. This field is set to 'All' by default. See Invoicing.
Invoice	Select the generated invoice to narrow the data set. This field is set to 'All' by default. For more information about generating invoices, see Create a Standard Invoice.
Supplier Invoice	Select the generated supplier invoice to narrow the data set. This field is set to 'All' by default.
Earnings E/D	From the drop down, select the earnings end date to filter by. You can configure a date range. Select Date Range From-To, and then use the From and To fields to configure dates. You can also click the calendar icon to open a calendar pop up that allows you to select the date.
Invoice E/D	From the drop down, select the invoice end date to filter by. You can configure a date range. Select Date Range From-To, and then use the From and To fields to configure dates. You can also click the calendar icon to open a calendar pop up that allows you to select the date.
Date Approved	From the drop down, select the date that the billing was approved to filter by. You can configure a date range. Select Date Range From-To, and then use the From and To fields to configure dates. You can also click the calendar icon to open a calendar pop up that allows you to select the date.
PO Number	Select the purchase order number to filter by. This field is set to 'All' by default.
Billing Item Type	Select the billing item type to filter by. This field is set to 'All' by default. If you select 'Expense', the Description field in the report output concatenates values as 'Mileage \| From \| Destination \| 2nd Destination'.
Did Not Work Billing Items	From the drop down, select to filter by billable items, or by items marked 'Did not Work', or both. This field is set to 'Billable Only' by default. Billing items on a time card can be marked to reflect that a worker did not work for either that day, or the entire time period. You can mark a billing entry as 'Did not Work' to create a billing entry with no billable hours. For more information about adding this setting for a work period, see Add a Work Period.
Customized Expense Categories	Select the expense category to filter by. This field is set to 'All' by default. Expense categories are custom category fields configured for the client organization. For more information about these fields, see Expense Category.
Multi-Engagement Billing	This setting filters the report as follows: All - All billing items (no filtering). Show only lines for workers billing across multiple engagements - Only displays billing items for workers that are assigned to multiple engagements, and bill for those engagements.
DirectSource PRO Billings	This setting filters the report as follows: All - All billing items (no filtering). DirectSource PRO Billings - Only displays billings for engagements filled using the DirectSource PRO tool.