This report provides all the information related to the transactions all the way down to the transaction entry item level.
Note: This report is part of the INSIGHTS product, please contact your Account Manager to learn more.
|
Click on the links below for more information:
If you don't have access to INSIGHTS/Analyze, please reach out to your Account Manager. |
CHAPTERSLegend |
Legend
Filter Panel
Locating the Analyze Report
- Click on Analyze Tab
The Reports Sub Tab will automatically be selected - In the Search Reports field, type TRANSACTION DETAIL
- Click on the Transaction Detail Info Report
Logic
This report provides all the information related to the transactions all the way down to the transaction entry item level.
Filter Options
| Parameter Name | Options | Description | |
| Division | All available Employers | Use this filter to refine Employer of Transaction | |
| Region | All available Regions | Use this filter to refine Region of Transaction | |
| Office | All available Offices | Use this filter to refine Office of Transaction | |
| Company Name | Free Text | Use this filter to refine Company of the Transaction | |
| Transaction Type List | All available Transaction Type/Pay Codes | Use this filter to refine Transactional pay codes. | |
| Show Type | Pay Only, Bill Only, Time Entered, Time Unentered, ALL | Use this filter to refine the Pay Only Transactions or Bill Only Transactions or Time Entered Transactions or Time Unentered Transactions | |
| Time Entry Batch ID | Free Text | Use this filter to refine the Time Entry Batch ID of Transaction | |
| Include Burden Factor | Yes/No |
Use this filter to pull amounts based on the Admin Tools >> Burden Factor. If 'Yes', use this filter to see the Worker Compensation Cost, Burden, Agency Cost, Payment Cost, Gross Profit, Gross Profit Percent, Employer Taxes and Employer Contribution based on burden. |
|
| Job Type | All available Job Types | User this filter to refine the Job Type of Transaction | |
| Talent ID | Free Text | Use this filter to refine the Talent of Transaction | |
| Extra Value | All available Transaction Extras | Use this filter to refine the Extras of the Transaction that is copied from Company, Job and Placement extras. | |
| Date Type | Accounting Period Date, Week Worked, Check Date, Invoice Date | Use this filter to refine the Date Type of Transaction | |
| Date From | Use this filter to refine Transactions falling under the date range as per the date type selected | ||
| Date To | |||
| Date Range | None, Yesterday, Today, Tomorrow, Last Week, This Week, Next Month, etc. | When 'Date Range' is selected, 'Date From' and 'Date To' will be automatically disabled. The user will need to select either 'Date Range' or enter 'Date From' and 'Date To'. |
Graphs/Widgets
Field Details
- Click here to go to the Time Category (list of Analyze Reports)
- Click here for more information on Terms and Filters (Analyze Reports)
- Click here for more information on System Terms (Glossary)
| Field Name | Description | Notes |
| Transaction Employer | Transaction's Employer | |
| Transaction Region | Transaction's Region | |
| Transaction Office | Transaction's Office | |
| Accounting Period Date | Transaction's Accounting Period Date | |
| Week Worked | Transaction's Week Worked Date | |
| Time Entry Batch ID | Transaction's Time Entry Batch ID | |
| Batch Description | Transaction's Time Entry Batch Description | |
| Company ID | Transaction's Company ID in Front Office/Classic | |
| Company | Company Name | |
| Department | Company Department | |
| Company Representative | Company Representative | |
| Talent ID | Transaction's Talent ID in Front Office/Classic | |
| BO Talent ID | Talent's ID from Back Office/CLASSIC | |
| Talent | Talent Name | |
| Is W2 | Transaction's w2 (Yes/No) | Indicates whether the transaction is a W2 Transaction or Non-W2 Transaction. |
| Talent Status | Talent Status | |
| Job | Transaction's Job Requisition ID in Front Office/Classic | |
| Job ID | Job ID in Front Office/Classic | |
| Job Sales Rep | Job Sales Rep | |
| Job Type | Job Type | |
| Placement ID | Transaction's Placement ID in Front Office/Classic | |
| BO Placement ID | Placement ID from Back Office/Classic | |
| Placement Recruiter Rep | Placement Recruiter Rep User | |
| Placement Start Date | Placement Start Date | |
| Placement End Date | Placement End Date | |
| Shift | Transaction's Placement Shift Name | |
| Check Accounting Period Date | Paycheck's Accounting Period Date | |
| Check Date | Paycheck's Check Date | |
| Check Number | Transaction's Check Number | |
| Check Branch | Paycheck's Branch | |
| Is Direct Deposit | Paycheck's direct deposit status (Yes/No), denotes if the check is direct deposit or live check. | |
| Invoice Accounting Period Date | Invoice's Accounting Period Date | |
| Invoice Date | Invoice's Invoiced Date | |
| Invoice Number | Transaction's Invoice Number | |
| Invoice Branch | Invoice's Branch | |
| Transaction Type | Transaction's Pay Code | |
| Pay Unit | Transaction's Pay Unit | |
| Pay Rate | Transaction's Pay Rate associated with the Pay Code | |
| Item Pay | Transaction's Item Pay (Pay Unit * Pay Rate) | |
| Bill Unit | Transaction's Bill Unit | |
| Bill Rate | Transaction's Bill Rate associated with the Pay Code | |
| Item Bill | Transaction's Item Bill (Bill Unit * Bill Rate) | |
| Cost Unit | Transaction's CostUnit | |
| Cost Rate | Transaction's CostRate | |
| Item Cost | Transaction's ItemCost (Cost Unit * Cost Rate) | |
| Sales Tax Amount | Transaction's Sales Tax Amount | |
| Total Pay | Transaction's Total Pay | |
| Total Bill | Transaction's Total Bill | |
| Bill Amount | Transaction's Bill Amount | |
| Gross Wages | Transaction's Gross Wages | |
| Total Adjustment Pay | Transaction's Total Adjustment Pay | |
| Total AdjustmentBill | Transaction's Total Adjustment Bill | |
| Worker Comp Cost | Transaction's WorkerCompCost | |
| Cost Worker Comp Cost | Transaction's CostWorkerCompCost | |
| Agency Name | Agency Name associated with non W2 transaction | |
| Agency Cost | Transaction's Agency Cost | |
| Payment Cost | Transaction's Payment Cost | |
| Burden | Transaction's Burden | |
| Wc Code | Transaction's Worker compensation Code | |
| Wc Code Rate | Rate associated with the Transaction's Worker compensation Code | |
| Job Position | Transaction's Job Position | |
| Gross Profit | Transaction's Gross Profit | |
| Gross Profit Percent | Transaction's GrossProfitPercent | |
| Employer Taxes | Transaction's EmployerTaxes | |
| Employer Contribution | Transaction's EmployerContribution | |
| Pay RT Hours | Transaction's Pay Hours for "REG" pay code | |
| Pay OT Hours | Transaction's Pay Hours for "OT" pay code | |
| Pay DT Hours | Transaction's Pay Hours for "DT" pay code | |
| Pay Total Hours | Transaction's PayTotalHours | SUM of pay hours of Reg, OT, DT plus any pay code that is setup with Property "IncludeInOtherhours" = True. |
| Bill RT Hours | Transaction's Bill Hours for "REG" pay code | |
| Bill OT Hours | Transaction's Bill Hours for "OT" pay code | |
| Bill DT Hours | Transaction's Bill Hours for "DT" pay code | |
| Bill Total Hours | Transaction's BillTotalHours | SUM of bill hours of Reg, OT, DT plus any pay code that is setup with Property "IncludeInOtherhours" = True. |
| RT Pay | Transaction's Total Pay for "REG" pay code | |
| OT Pay | Transaction's Total Pay for "OT" pay code | |
| DT Pay | Transaction's Total Pay for "DT" pay code | |
| RT Bill | Transaction's Total Bill for "REG" pay code | |
| OT Bill | Transaction's Total Bill for "OT" pay code | |
| DT Bill | Transaction's Total Bill for "DT" pay code | |
| GP Adjustment Pay | Transaction's GPAdjustmentPay | |
| GP Adjustment Bill | Transaction's GPAdjustmentBill | |
| GP Adjustment Cost | Transaction's GPAdjustmentCost | |
| Non Adjustment Cost | Transaction's Item Cost (Non Deduction Transaction Type) | |
| Worker Comp Wage | Transaction's WorkerCompWage | |
| Credit Card Fee | Transaction's CreditCardFee | |
| Discount Amount | Transaction's DiscountAmount | |
| Rebate Amount | Transaction's RebateAmount from transaction | |
| PO Number | Transaction's Purchase Order | |
| Bill Other Hours | Total Bill Hours of paycode other than Reg, OT, DT that has Property "IncludeInOtherhours" = True. | |
| Pay Other Hours | Total Pay Hours of paycode other than Reg, OT, DT that has Property "IncludeInOtherhours" = True. | |
| ItemText | Transaction's ItemText | |
| TimeSheet Approved By | Transaction Timesheet Approved By User | |
| TimeSheet Approved Date | Timesheet Approved Date | |
| TimeSheet Saved By | Timesheet Saved By User | |
| TimeSheet Saved Time | Timesheet Saved Date | |
| TimeSheet Submitted By | Timesheet Submitted By User | |
| TimeSheet Submitted Time | Timesheet Submitted Date | |
| Dynamic Fields | After the column TimeSheet Submitted Time, the Placement's Commission Users associated with the transaction and Extra Values are displayed dynamically in the report. (These columns are dynamically displayed so these columns would be displayed only if the Commission Users and Extra Values are linked with any transactions during the date range) | |
| Worksite Address | Worksite Address |
Comments
0 commentsPlease sign in to leave a comment.