Supplier Billing Export

This report (Reports > Export > Supplier Billing Export) displays data for billing items submitted over a specific time period. Data is only available if it has been exported previously using the Export Billing function in the Supplier view. For more information about this task, see Export Billing.

This report produces the following columns:
  • Client Name
  • Supplier Name
  • Line #
  • Worker
  • Date Worked
  • Start Time
  • End Time
  • Lunch
  • Day
  • Hours
  • Manager
  • Worker
  • Worker #
  • Pay Group
  • Job Number
  • Requisition #
  • Earnings End Date
  • Export Date
  • Rate Application
  • Currency
  • Bill Rate
  • Pay Rate
  • Regular Hours
  • OT Hours
  • OT Rate
  • DT Hours
  • DT Rate
  • Holiday Hours
  • Holiday Rule
  • Day
  • Position
  • Milestones
  • Materials
  • Expense
  • Adjustment
  • Tax Type
  • Tax Amount
  • Vol Disc %
  • Vol Disc Amount
  • Prompt Pay
  • Prompt Pay Amount
  • MSP Fee %
  • MSP Fee Amt
  • Amt Pay Supplier
  • Status
  • Status Reason
  • Grand Total
Field Description
ClientFrom the drop down, select the client organization to filter results by.
Billing Item Status Click a status value to filter results by. You can select multiple statuses, or select 'None' to display all export data.
Export by Date Click an export date to filter by. You can select multiple dates, or select 'None' to display all export data.
Invoice Click an invoice number to filter by.

Billing items can be associated with an invoice (number) once the item is processed (taxes calculated and record, and so on).
Date Type From the drop down, select the ending date type. You can select the following:
  • Earnings E/D - Select to filter data by earnings end date (range)
  • Invoice E/D - Select to filter data by end date stated on the invoice.

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.
Select ColumnsSelect the columns to include in the report.