Transaction Master Detail Report

Bullhorn Support is able to assist with navigating sample reports, but they are unable to build customizations on reports for you. If you need customizations, you will need a Business Intelligence specialist who is familiar with writing database queries.

The Transaction Master Detail Report provides transaction detail visibility to Pay/Bill Transactions, which originate from the time entry system (i.e Bullhorn Time & Expense - BTE) or are manually entered in Payable or Billable Charges. This report provides a detailed focus.

This is one of three similarly-named reports, which provide visibility to the same data through a different lens. The other Transaction Master Reports are:

Transaction Master Summary: Rollup of the Transaction Master Detail report; summarized by Candidate Placement ID, Week Ending Date, and Earn Code.
Transaction Master Summary Exceptions Report: Uses the Transaction Master Summary report as a base, and applies various exceptions parameters to the aggregate hours for the week.

The following fields are available on this report.

Data Item in Report	Definition
Client	Client Name from the Company Profile.
Bill To Client Name	Company Name to which the billing is sent, which can be different from the Client Name. Example: the candidate may be working at IBM; however, the invoice is sent to the MSP provider (perhaps Beeline).
Candidate Name	Candidate name listed on the Bullhorn Candidate Profile.
Candidate ID	ID number automatically assigned by Bullhorn on the Candidate Profile.
Job ID	ID number automatically assigned by Bullhorn on the Job Order Profile.
Job Title	Job Title listed on the Bullhorn Job Order Profile.
Placement ID	ID number automatically assigned by Bullhorn on the Placement
Employee Type	Employee Type selected on the Placement. Options include, but are not limited to: W2, T4, 1099.
Employment Type	Type of employment selected by the user prior to entering the Placement data. Options include, but are not limited to: Contract, Contract to Hire, Permanent.
Bill Item	Represents the revenue category for the charge that is linked to a GL account; determined from the related earn code’s bill item field.
Class	General category to describe the placement’s employment type (i.e. Empl Type - Contract, then it is consultant hourly). Depending on the transaction, it is determined from the charge, placement or related earn code. This field is typically utilized with QuickBooks.
Period End Date	End date of the timecard associated with the transaction.
Payable Charge ID	ID number automatically assigned by Bullhorn on the Payable Charge.
Pay Status	Bullhorn Status of the Payable Charge. Options include: Exported, Processing, Export Error, Ready to Pay or Not Ready to Pay.
Pay Transaction Status	Status of the Timecard/Payable Charge. Options include: Submitted or Approved
Pay Transaction Origin	Origin of the Pay Transaction Data. Options include: PeopleNet or Manual
Pay Description	Combined description of: Candidate Name, Job Title, and Period End Date. Example: Elizabeth Green - Inspector - 2022-01-09
Pay Transaction Date	Date the Pay Transaction occurred; also referred to as what date did the work occur.
Pay Earn Code	Earn Code associated with pay being processed. Options include, but are not limited to: Reg, OT, DT, Per Diem, PTO, etc.
Pay Qty	Number of hours/units paid associated with the pay earn code.
Pay Rate	Dollar amount paid per hour/unit.
Pay Amount	Pay Qty multiplied by Pay Rate.
Billable Charge ID	ID number automatically assigned by Bullhorn on the Billable Charge.
Bill Status	Bullhorn Status of the Billable Charge. Options include: Ready to Bill, Needs Review, Invoicing, Invoiced, Unbillable, Processing Failed, Processing, or Not Ready to Bill.
Bill Transaction Status	Status of the Timecard/Billable Charge. Options include: Approved or Submitted
Bill Transaction Origin	Origin of the Bill Transaction Data. Options include: PeopleNet or Manual
Bill Description	Combined description of: Candidate Name and Period End Date. Example: Elizabeth Green - 2022-01-09
Bill Transaction Date	Date the Pay Transaction occurred; also referred to as what date did the work occur.
Bill Earn Code	Earn Code associated with billing being processed. Options include, but are not limited to: Reg, OT, DT, On Call, Call Back, etc.
Bill Qty	Unit of Measure associated with the bill earn code. Examples include: hours, units, days, or miles.
Bill Rate	Dollar amount billed per hour/unit.
Bill Amount	Pay Qty multiplied by Bill Rate.
Pre Invoice ID	ID number automatically assigned by Bullhorn when the invoice is created.
Invoice Statement Number	Invoice Statement Number assigned when the invoice is finalized.
Invoice Date	Date assigned when the invoice is finalized; this will be the date to use in calculation for payment terms.
Invoice Status	Status of the Bullhorn Invoice. Options include: New, Ready, Finalized, Finalization Error, Finalization in Progress

Use Cases

The primary reason to run the Transaction Master Detail Report is to pull pay and bill transaction details. This could be done for the following reasons:

Reconcile payable and billable charges
Research/review transactions related to a specific candidate, placement, client or bill-to client, etc.

Run the Transaction Master Detail Report weekly as a tool to reconcile transactions. Run on Friday view the current pay period, or run on Monday to refer to last week’s pay period.

See Sample Transaction Master Details Report to view an example of this report in action.

Running the Report

If you anticipate the report may exceed the 10,000 row limit, utilize the report parameters to break the data into smaller groups. For example, use the Company filter to pull Company names that begin with A-M and then N-Z.

From your Bullhorn ATS Menu, select Canvas.
Select Run beside the Transaction Master Detail Report.
Enter the Period End Date Range. This is the only required criteria.
- On this page, you can also enter the Transaction Date Range or Transaction Date Added to filter the report further. This is optional.
Click Next.
Enter any additional Criteria. These settings are all optional.
- Report Criteria
  - Payable Export ID
  - Bill-To Client
  - Pay-To Client
  - Placement ID
  - Placement Type
  - Candidate
Click Finish.

Any transactions entered manually/directly into your Payroll or Billing systems will not be included on this report.

Exporting to Excel

Depending on the amount of data, it may be easier to view the report via Excel. Follow these steps to export your report to Excel:

From the HTML drop down button in the top right corner, click View in Excel Options > View in Excel 2007 Format.

The Excel format you choose can be based on personal preference. We recommend using View in Excel 2007 Format to maintain the same format that you see in Bullhorn Reporting (Canvas) and/or if you plan to use standard Excel functions (pivot, sort, etc).
The request will process and a pop up stating "Your report is ready and will download to your Web browser in a few moments" will appear.
When prompted, Save the report to your computer.

Once the report is exported to Excel, you can utilize standard Excel functions to filter, sort and pivot the data.