Billing Line Item Report

This report produces data regarding billing line items. For more information about billing and billing items, see Billing Process Overview.

This report produces the following columns:
  • Rate Application Type
  • Status
  • Status Reason
  • Operational Unit
  • Manager
  • Manager Email
  • Supplier
  • Worker
  • Requisition #
  • Parent Project #
  • Req Start Date
  • Req Est. End Date
  • Dept Number
  • Dept Name
  • Invoice Option
  • Country
  • State/Province
  • City
  • Currency
  • Pay Rate
  • Bill Rate
  • Earnings E/D
  • Days - Only displays if Rate Application Type='Per Day' or 'Prorated Per Day'.
  • Regular Hours - Does not display if Rate Application Type='Per Day' or 'Prorated Per Day'.
  • Total Bill
  • Job Title
  • GUID
  • Requisition Type
  • OT Hours - Does not display if Rate Application Type='Per Day' or 'Prorated Per Day'.
  • DT Hours - Does not display if Rate Application Type='Per Day' or 'Prorated Per Day'.
  • Holiday Hours - Does not display if Rate Application Type='Per Day' or 'Prorated Per Day'.
  • Milestones
  • Materials
  • Position
  • Expenses
  • MSP VAT
  • Supplier VAT
  • Sales Tax
  • Service Tax
  • CAN Tax Type
  • CAN Tax $
  • GST Amount
  • HST Amount
  • QST Amount
  • RST Amount
  • PST Amount
  • MSP GST Amount
  • MSP HST Amount
  • MSP QST Amount
  • MSP RST Amount
  • MSP PST Amount
  • Adjustment
  • MSP Up %
  • MSP Up Amt
  • MSP Down %
  • MSP Down Amt
  • Raw Bill
  • Summary Total
  • Grand Total
  • Date
  • Hours
  • Non Billable Hours - Only displays Work Schedule='Professional Week'.
  • Days - Only displays if Rate Application Type='Per Day' or 'Prorated Per Day'.
  • Detail Bill Amount - Client bill amount.
  • Type of Day Off - Only applicable for Daily and Period timecards.
  • Start Time
  • End Time
  • Lunch
  • Time Notes
  • Time Cost Allocation
  • Time Status
  • Time Status Reason
  • Time Date and Time Approved
  • Time Approved By
  • Expense Entry Category
  • Expense Description
  • Expense Purpose
  • Expense Destination
  • Date Expense
  • Expense Quantity
  • Expense Amount
  • Expense Paid Amount
  • Trip Expense
  • Expense Note
  • Expense Receipt Received
  • Expense Approved
  • Expense Cost Allocation
  • Expense Status
  • Expense Status Reason
  • Expense Date and Time Approved
  • Expense Approved By
  • Adj.
  • Adj. Classification
  • Adj. Reason
  • Adj. Justification
  • Adj. Shift
  • Adj. Date
  • Adj. Day
  • Adj. Regular Hour
  • Adj. OT Hour
  • Adj. DT Hour
  • Adj. Holiday Hour
  • Adj. MSP VAT Amount
  • Adj. Duplicate Reason
  • Adj. Cost Allocation
  • Adj. Credit Cost Allocation
  • Adj. Rebill Cost Allocation
  • Adj. Type
  • Adj. Reference Detail Item
  • Adj. Note
  • Adj. Status
  • Adj. Status Reason
  • Adj. Date and Time Approved
  • Adj. Approved By
  • Milestone
  • Milestone Date
  • Milestone Due Date
  • Milestone Comment
  • Milestone Amt
  • Milestone Rejected Notes
  • Milestone Cost Allocation
  • Milestone Status
  • Milestone Status Reason
  • Milestone Date and Time Approved
  • Milestone Approved By
  • Material
  • Material Date Purchased
  • Material Quantity
  • Material Comment
  • Material Amt
  • Material Rejected Notes
  • Material Cost Allocation
  • Material Status
  • Material Status Reason
  • Material Date and Time Approved
  • Material Approved By
  • Position
  • Position Hrs Worked
  • Position Comment
  • Position Amt
  • Position Rejected Notes
  • Position Cost Allocation
  • Position Status
  • Position Status Reason
  • Position Date and Time Approved
  • Position Approved By
  • Benefit Category Name
  • Benefit Quantity
  • Benefit Amount
  • Benefit Note
  • Benefit Status
  • Benefit Status Reason
  • Benefit Date and Time Approved
  • Benefit Approved By
  • Transfer Queue
  • Transferred
  • Errored
  • Pending Transfer Confirmation
  • Payment Queue
  • Errored Reason
  • Filter Billing
  • Include Volume Discount
  • Include in Billing Transfer
  • Calculate Taxes
  • Requisition Custom Fields - One column for every Requisition type custom field. Column header format is <custom_field_name>(<operational_unit_name>).
  • Worker Custom Fields - One column for every Worker type custom field. Column header format is <custom_field_name>(<operational_unit_name>).
  • VMS Billing Line#
Field Description
Operational UnitFilter the report output for billing items submitted for a specific operational unit (OpUnit). This field is set to 'All' by default.
Company/subdivision Filter the report output by a configured company (client organization name assigned to the MSP). This field is set to 'All' by default.
<department> Filter the report output by department.
Undo Withdraw Filter the report output by workers that have had the 'Do Withdraw' action applied.
ManagerSelect the client manager name associated with the engagement. This field is set to 'All' by default.
Requisition TypeSelect the engagement type. This field is set to 'All' by default.
City Filter the report output by a configured city (location). This field is set to 'All' by default.
State/Province Filter the report output by a configured state or province (location). This field is set to 'All' by default.
Country Filter the report output by a configured country (location). This field is set to 'All' by default.
Invoice OptionSelect the invoice option for the engagement. This field is set to 'All' by default. See Invoicing.
StatusFilter the report output by the status assigned to the billing item. This field is set to 'All' by default.
Status ReasonFilter the report output by the status reason assigned to the billing item. This field is set to 'All' by default.
Billing Type Select the billing item type to filter by. This field is set to 'All' by default.
Operational UnitFilter the report output for billing items submitted for a specific operational unit (OpUnit). This field is set to 'All' by default.
WorkerEnter the name of the worker(s) whose data is included in the report. This field is set to 'All' by default.
ManagerSelect the client manager name associated with the engagement. This field is set to 'All' by default.
Date Type From the drop down, select the date type. You can select from the following:
  • None - Do not filter by a date
  • Earnings E/D - Filter by earnings end date

This setting is used in conjunction with From date and To date fields. You specify a date range based on the end date type.
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.

From dateEnter the beginning date for the date range. You can also click the calendar icon to open a calendar pop up that allows you to select the date.
To dateEnter the end date for the date range. You can also click the calendar icon to open a calendar pop up that allows you to select the date.
Supplier Filter the report output by supplier/vendor for the request or engagement. This field is set to 'All' by default.
Invoice OptionSelect the invoice option for the engagement. This field is set to 'All' by default. See Invoicing.
Invoice Status Filter the report output by an invoice's status. This field is set to 'All' by default.
Invoice Status Reason Filter the report output by an invoice's status reason. This field is set to 'All' by default.
Summarize byFrom the drop down, select how to summarize the output columns in the report.
Include Time Detail Information Select the check box to include information (Detail field) from a time entry.
Include Expense Detail Information Select the check box to include information (Detail field) from an expense entry.
Include Adjustment Detail Information Select the check box to include information (Detail field) from an adjustment entry.
Include Milestone Detail Information Select the check box to include information (Detail field) from a milestone entry.
Include Material Detail Information Select the check box to include information (Detail field) from a materials entry.
Include Position Detail Information Select the check box to include information (Detail field) from a position entry.
Include Benefit Detail Information Select the check box to include information (Detail field) from a benefit entry.
Include Billing Transfer Information Select the check box to include the billing transfer information (BCF).
Include Operation Parameters Information Select the check box to include operational parameter information (Operational Parameters section) from billing item.
Include Work Order/ SOW Detail Information Select the check box to include work order or SOW information from a project billing entry.
Include Requisition Custom Fields Select the check box to include custom fields from the request/engagement for the billing item.
Include Worker Custom Fields Select the check box to include custom fields from the worker record for the submitted billing item.
Include VMS Billing Fields Select the check box to include VMS specific billing fields.
Include Shift Details Select the check box to include information (Detail field) from a shift entry.
Include Multiple and Piece Rate Information Select the check box to include multiple and piece rate information.
Include Credit /Rebill Fields Select the check box to include information (Detail field) from a time entry.