Customizable Billing Report

This report produces comprehensive billing data related to all billing items and status 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#
    • Bill Rate
    • Rule Description
    • OT Multiplier
    • DT Multiplier
    • 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.
    • Unpaid Time
    • Milestones
    • Materials
    • Position
    • Exp
    • Adj - Only viewable to suppliers where the billing filter is set to viewable by supplier.
    • Sales Tax - Value is rounded to two decimal places.
    • 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
    • QST Amount
    • VDisc %
    • VDisc $
    • PPay %
    • PPay $
    • Contractor Manager
    • 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
    • Research
  • Time Detail section
    • Date Worked
    • Days
    • Start Time
    • End Time
    • Hours
    • Regular 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
  • 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
Field Description
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 DelegateIf the report is being run by the client manager delegate, then the delegate can select additional client manager delegate assigned by the delegating client manager.
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 OptionSelect the invoice option for the engagement. This field is set to 'All' by default. See c_invoicing.html.
Invoice Select the generated invoice to narrow the data set. This field is set to 'All' by default.
Supplier Invoice Select the generated supplier invoice to narrow the data set. This field is set to 'All' by default.
Earnings E/DFrom 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/DFrom 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 ApprovedFrom 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.
Customized Expense Categories Select the expense category to filter by. This field is set to 'All' by default.
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.