Transaction Master Detail Report

Overview

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.

The report provides a detailed focus. For a summary of transactions, use the Transaction Master Summary Report. You can access all the reports through Canvas.

Best Practices

Leverage the Transaction Master Detail Report to conduct research or to perform a reconciliation.

As a tool, Bullhorn developed the Hours and Gross Pay Reconciliation Template as a template for your use. This is not a must-use tool. You should determine the best approach and best practices to manage your reconciliation process.

You should request a copy of the Reconciliation Template from your SI Partner during implementation or your Account Manager after implementation.

Report Uses

The primary reason to run the Transaction Master Detail Report is to pull pay and bill transaction details. This could be done to reconcile payable and billable charges or to research/review transactions related to a specific candidate, placement, client or bill-to client, etc.

Depending on your company's needs, you may need to customize the report. Canvas report customization can be accomplished by one of the following approaches:

• Your Cognos Report Writing resource can copy the Product report and make the necessary changes.

• If you don't have an internal resource, you should contact your SI Partner to discuss the business needs.

Running the Report

1. From the Menu, select Canvas.

2. When Canvas opens, select Run beside the Transaction Master Detail Report.

3. Enter the criteria for the report.

   • If the Period End Date Range is the only desired report criteria, enter the date range and click Finish to run the report.

   • If you need additional report criteria, enter the date range, then click Next to indicate additional criteria on the next page.

4. The report details will display. Depending on your agency’s transaction volume, it may be easier to view the report via Excel.

5. To Export to Excel, select the drop down menu at the top of the report, click View in Excel Options, then select View in Excel 2007 Format.

   • The View in Excel 2007 Format option maintains the same report format as the Canvas report. If you need a data file without needing to keep the Canvas report formatting, then select the Data option.

6. Once the applicable Excel option is selected, BH1 will process the request, and the following screen will appear. Click on the xlsx file to open the file in Excel.
   

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

To view a full sample Transaction Master Details Report, select this link:

Sample Transaction Master Details Report.xlsx

Report Criteria

These options are available as criteria:

• Bill-to Client

• Candidate

• Client Corp

• Payable Export ID

• Placement ID

• Placement Type

• Period End Date Range

• Transaction Date Range

Fields

These fields are available on the 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