Billing Report

This report produces data regarding billing information from invoiced timecards.

This report produces the following columns:
  • Line #
  • Status
  • Status Reason
  • Supplier
  • Manager
  • Worker
  • Requisition #
  • Operational Unit
  • Dept Lvl 1
  • Dept Lvl 2
  • Dept Lvl 3
  • Dept #
  • Country
  • State/Province
  • City
  • PO #
  • Bill Rate
  • Earning E/D
  • Currency
  • Milestones
  • Materials
  • Position
  • Rate Type Application
  • Days
  • Reg Hrs
  • OT Hrs
  • DT Hrs
  • Hdy Hrs
  • Exp
  • MSP VAT
  • Supplier VAT
  • Sales Tax
  • GST Amount
  • CGST Amount
  • IGST Amount
  • MSP CGST Amount
  • MSP SGST Amount
  • MSP IGST Amount
  • HST Amount
  • QST Amount
  • RST Amount
  • MSP GST Amount
  • MSP HST Amount
  • MSP QST Amount
  • MSP RST Amount
  • MSP PST Amount
  • Adj
  • VDisc %
  • VDisc $
  • PPay %
  • PPay $
  • MSP Cli %
  • MSP Cli $
  • MSP Sup %
  • MSP Sup $
  • Invoice #
  • Inv Date
  • AP Inv#
  • Sup Inv #
  • Client Inv #
  • Total Bill
  • Total Pay
  • OT Pay
  • OT Multiplier
  • DT Rate
  • DT Multiplier
  • Filter Billing
  • Requisition Custom Fields - Included if Include custom fields information check box is selected.
  • Client Organization Custom Fields - Included if Include Client Custom Fields check box is selected.
  • Grand Total
  • Units Worked
  • Piece Bill Rate
  • Piece Pay Rate
  • Multiple Rate
  • Date Worked
  • Days
  • Start Time
  • End Time
  • Hours
  • Regular Hours (Detail)
  • Non Billable Hours - Displays only if 'Professional Week' is set in the work schedule.
  • OT Hours (Detail)
  • DT Hours (Detail)
  • Client Bill Amount (Detail)
  • Start Lunch
  • End Lunch
  • Lunch
  • Notes
  • Time Status
  • Time Status Reason
  • Tome Date and Time Approved
  • Time Approved By
  • Time Cost Allocation
  • Work Performed in the US? - Only displays for engagements where the work location is outside of the US.
  • Milestone
  • Milestone Date
  • Milestone Due Date
  • Milestone Comment
  • Milestone Amt
  • Milestone Status
  • Milestone Status Reason
  • Milestone Date and Time Approved
  • Milestone Approved By
  • Milestone Cost Allocation
  • Timeframe to complete milestone from
  • Timeframe to complete milestone to
  • Hours Worked
  • Material
  • Material Date Purchased
  • Material Quantity
  • Material Comment
  • Material Amt
  • Material Status
  • Material Status Reason
  • Material Date and Time Approved
  • Material Approved By
  • Material Cost Allocation
  • 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 Approved By
  • Position Cost Allocation
  • Category
  • Description
  • Purpose
  • Amount
  • Expense Date
  • Create Date
  • Receipts Received
  • Notes
  • Expense Status
  • Expense Status Reason
  • Expense Date and Time Approved
  • Expense Approved By
  • Expense Cost Allocation
  • 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. Approved By
  • Adj. Cost Allocation
  • Category Name
  • Quantity
  • Amount
  • Note
  • Date Benefit
  • Benefit Status
  • Benefit Status Reason
  • Benefit Date and Time Approved
  • Benefit Approved By
  • Date Worked
  • Shift type
  • Shift Value
  • Shift Rate Regular
  • Shift Rate OT
  • Shift Rate DT
  • Shift Hours
  • Shift Hours OT
  • Shift Hours DT
  • Detail Bill Amount
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.
Undo Withdraw Filter the report output by items that have had the 'Undo Withdraw' action applied. This field is set to 'All' by default.
<department> Filter the report output by a configured department for the client organization. You can configure a filter for multiple levels of department (if configured for a client organization). 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.
Supplier Filter the report output by the supplier that filled the request (that is billing the client). 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.
InvoiceSelect the invoice to filter by. This field is set to 'All' by default.
Supplier InvoiceSelect the supplier invoice to filter by. 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
  • Invoice E/D - Filter by invoice 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.
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.
PO Number Filter the report output by the PO Number assigned to the billing item. This field is set to 'All' by default.
Include Time Details Select the check box to include time (billing item detail) in the report output.
Milestone Details For project engagements, select the check box to include milestone information in the report output.
Material Details For project engagements, select the check box to include materials information in the report output.
Position Details For project engagements, select the check box to include position information in the report output.
Note: This information does not include project worker information.
Expense Details Select the check box to include expense information in the report output.
Adjustment Details Select the check box to include adjustment billing item information in the report output.
Benefit Details Select the check box to include benefit billing item information in the report output.
Shift Details Select the check box to include shift information in the report output.
Multiple and Piece Rate Select the check box to include multiple rate or piece rate (whichever is associated with the billing item) in the report output.

For more information about setting up multi rate or piece rates for a client organization, see the 'Financials' section for the relevant request type.
Custom Fields Select the check box to include billing custom field names and values in the report output.

For more information about setting up billing custom fields, see Custom Fields Options by Workflow.
Client Organization Custom Fields Select the check box to include Manager type custom field name and values in the report output.

For more information about manager custom fields, see Custom Fields Options by Workflow.
Do not display 'Rejected' Details Select the check box to exclude rejected billing items in the report output.
Show Only Forced Approvals Select the check box to filter the report output to display billing items that were force approved.

The force approval action is applied on billing items that are saved, but not submitted for approval. For more information about this action, see Force Billing.
Billing Item Type From the selection field, select the billing item types to filter by. This field is set to 'All' by default.
Summarize byFrom the drop down, select how to summarize the output columns in the report.
Optional Columns From the selection field, select optional columns for the report output.