Billing Line Item Report
This report () produces data regarding billing line items.
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
- 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
- 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 |
|---|---|
| Client | From the drop down, select the client organization to filter results by. |
| Undo Withdraw | Filter the report output by workers that have had the 'Do Withdraw' action applied. |
| Manager | Select the client manager name associated with the engagement. 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. |
| Worker | Enter the name of the worker(s) whose data is included in the report. This field is set to 'All' by default. |
| Date Type | From the drop down, select the date type. You can select from the
following:
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/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. |
| Client | From the drop down, select the client organization to filter results by. |
| From date | Enter 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 date | Enter 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. |
| Summarize by | From 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 Work Order/ SOW Detail Information | Select the check box to include work order or SOW information from a project billing entry. |
| 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. |