Enhanced Transaction Detail Info Report

Enhanced Standard Reporting Availability 

Enhanced Standard Reporting is now available as an optional feature for your system.

Want to opt in NOW? Submit a support ticket or contact your CSM to enable this feature and access faster processing, extended historical data, and improved reliability.

Customizing and Sharing This Report

Columns: Use the column selector to show, hide, or reorder columns to match your workflow.

Filters: Your filter selections are remembered between sessions — the report opens with your last-used settings automatically.

Sharing (INSIGHTS users): You can duplicate, rename, and share customized versions of this report with team members, and schedule automated delivery by email. System-level reports remain unchanged and available to all users.

Sharing (Standard users): You can duplicate this report and customize filters for personal use. To share a customized version with your team, duplicate the report, apply your preferred filters, and share it directly with individual users. System-level reports cannot be modified or set as a default for all users. See Enhanced Standard Reporting Overview for more detail.

The Transaction Detail Info Report provides comprehensive transaction data down to the entry item level, giving you complete visibility into payroll and billing transactions. Use this report to analyze transaction details, verify billing accuracy, track worker compensation costs, and monitor transaction processing across your organization.

Enhanced Reports

Note: This report is part of the INSIGHTS product. Contact your Account Manager to learn more about accessing INSIGHTS and Analyze Reports.

On This Page

→ Accessing the Report

→ Understanding This Report

→ Using Filters

→ Reading the Data

→ Practical Applications

→ Exporting Your Data

Accessing the Report

1. Click the Analyze tab in the main navigation
   The Reports section will automatically open in the left sidebar
2. In the search field, type Transaction Detail or scroll to locate Transaction Detail Info
3. Click Transaction Detail Info to open the report
4. The report loads immediately with data based on your previous filtering options

Note: Reports load with Today & Yesterday as the initial default. Once you adjust filters, the report remembers your selections for future sessions. If you see unexpected results, check your active filters in the right panel. The data you see depends on your security permissions—users with restricted access may see fewer transactions than colleagues with broader visibility.

Understanding This Report

What This Report Shows You

The Transaction Detail Info Report displays every transaction processed through your Avionté system, broken down to the individual transaction entry item level. Each row represents a single transaction line item, providing complete details about the transaction type, pay and bill amounts, associated talent and company, and related payroll or invoice information.

Unlike summary reports that aggregate financial data, this report gives you the granular, transaction-by-transaction detail needed to reconcile billing, troubleshoot payroll discrepancies, audit transaction processing, and analyze worker compensation costs at the most detailed level available.

Why Use This Report

This report helps you answer critical operational and financial questions:

• What transactions were processed for a specific talent or company during a date range?
• How do pay rates and bill rates compare across different transaction types?
• Which transactions include worker compensation costs or burden factors?
• What are the gross profit margins on specific transactions or placements?
• How do agency costs impact non-W2 transactions?
• Which transactions were included in a specific check or invoice batch?

Who Benefits From This Report

Different roles use this report to address specific operational needs:

Payroll Managers: Verify transaction accuracy before processing payroll, investigate discrepancies in pay calculations, reconcile time entry batches, and ensure proper application of pay codes and rates.

Billing Managers: Audit invoice accuracy, verify bill rates match client agreements, track sales tax applications, review markup percentages, and reconcile billing for VMS clients.

Finance Teams: Analyze gross profit at the transaction level, track worker compensation costs, monitor burden factor applications, calculate employer taxes and contributions, and prepare detailed financial analysis.

Operations Managers: Review transaction processing efficiency, identify patterns in time entry submissions, monitor timesheet approval workflows, and troubleshoot processing issues.

Compliance Officers: Audit transaction classification (W2 vs. non-W2), verify proper worker compensation code assignments, track agency cost allocations, and ensure regulatory compliance in transaction processing.

Using Filters

Filters appear on the right side of your screen and help you focus on specific transaction segments. All filters default to "Include all" when you first open the report. Use filters strategically to narrow down large transaction datasets to exactly what you need to analyze.

Available Filters

Filter Name	What It Does	When to Use It
Division	Filters transactions by employer/division	Analyze transaction activity for a specific business unit or employer entity (not all accounts have divisions enabled)
Region	Filters transactions by geographic region	Compare transaction volumes and profitability across territories or analyze regional billing patterns
Office	Filters transactions by branch location	Evaluate individual office performance or investigate branch-specific transaction processing
Company Name	Filters transactions by client company (free text search)	Focus on transactions for a specific customer or analyze billing patterns with key clients
Transaction Type List	Filters by specific pay codes (REG, OT, DT, etc.)	Analyze specific transaction types like overtime, double-time, or specialized pay codes
Show Type	Filters by Pay Only, Bill Only, Time Entered, Time Unentered, or ALL transactions	Focus on pay-only adjustments, bill-only charges, or distinguish between entered and unentered time
Time Entry Batch ID	Filters by specific time entry batch identifier (free text)	Review all transactions within a single time entry batch for reconciliation or troubleshooting
Include Burden Factor	Yes/No option to include burden factor calculations	When set to Yes, displays worker compensation cost, burden, agency cost, payment cost, and gross profit calculations based on Admin Tools burden factor settings
Job Type	Filters transactions by job classification	Analyze transaction patterns for specific job types or compare profitability across different assignment categories
Talent ID	Filters transactions for a specific talent (free text search)	Review all transactions for an individual contractor or investigate specific talent payment history
Extra Value	Filters by transaction extras copied from Company, Job, and Placement	Analyze transactions tagged with specific extra values for custom reporting or tracking
Date Type	Choose from Accounting Period Date, Week Worked, Check Date, or Invoice Date	Select which date field to use for your date range filter—critical for accurate period reporting
Date From / Date To	Filters transactions by the selected Date Type within a specific range	Define the exact period you want to analyze based on the Date Type you selected
Date Range	Quick-select date ranges (Yesterday, Today, Tomorrow, Last Week, This Week, etc.)	Rapidly filter to common date periods without manually entering dates

Note: When using Date Range, the Date From and Date To fields automatically disable. Select either Date Range or manually enter Date From and Date To—not both. Always select your Date Type before setting your date range to ensure accurate filtering.

Applying Your Filter Selections

1. Click on the edit icon next to any filter name to expand it
2. Make your selections by checking boxes, choosing from dropdowns, or entering text
3. Click Apply to update the report with your filtered view
4. Click Cancel to discard changes and return to the previous filter state

Reading the Data

The Transaction Detail Info Report displays each transaction entry item as a separate row with comprehensive details about the transaction, associated entities, and financial calculations. The extensive field list allows you to export exactly the information you need for your specific analysis or reconciliation needs.

Key Field Categories

The report organizes information into logical categories to help you find what you need:

Organizational Information: Transaction Employer, Transaction Region, Transaction Office

Transaction Dates: Accounting Period Date, Week Worked, Check Date, Invoice Date, Check Accounting Period Date, Invoice Accounting Period Date

Batch Information: Time Entry Batch ID, Batch Description, Check Number, Check Branch, Invoice Number, Invoice Branch

Company Details: Company ID, Company Name, Department, Company Representative

Talent Information: Talent ID, BO Talent ID, Talent Name, Is W2, Talent Status

Job and Placement: Job, Job ID, Job Sales Rep, Job Type, Job Position, Placement ID, BO Placement ID, Placement Recruiter Rep, Placement Start Date, Placement End Date, Shift

Transaction Details: Transaction Type (Pay Code), Pay Unit, Pay Rate, Item Pay, Bill Unit, Bill Rate, Item Bill, Cost Unit, Cost Rate, Item Cost

Financial Calculations: Total Pay, Total Bill, Bill Amount, Gross Wages, Sales Tax Amount, Total Adjustment Pay, Total Adjustment Bill

Worker Compensation: Worker Comp Cost, Cost Worker Comp Cost, WC Code, WC Code Rate, Worker Comp Wage

Agency and Burden: Agency Name, Agency Cost, Payment Cost, Burden

Profitability: Gross Profit, Gross Profit Percent, Employer Taxes, Employer Contribution

Hours Breakdown: Pay RT Hours, Pay OT Hours, Pay DT Hours, Pay Total Hours, Pay Other Hours, Bill RT Hours, Bill OT Hours, Bill DT Hours, Bill Total Hours, Bill Other Hours

Amount Breakdown: RT Pay, OT Pay, DT Pay, RT Bill, OT Bill, DT Bill

Additional Details: Is Direct Deposit, PO Number, Credit Card Fee, Discount Amount, Rebate Amount, Item Text

Timesheet Processing: Timesheet Approved By, Timesheet Approved Date, Timesheet Saved By, Timesheet Saved Time, Timesheet Submitted By, Timesheet Submitted Time

Dynamic Fields: Placement Commission Users (multiple columns) and Extra Values are displayed dynamically based on the transactions in your filtered results

Field Category	How to Use It
Transaction Types and Rates	The Transaction Type field shows the pay code (REG, OT, DT, etc.) used for each transaction. Compare Pay Rate, Bill Rate, and Cost Rate to understand the full financial structure of each transaction. Item Pay, Item Bill, and Item Cost show the calculated amounts based on units and rates.
Date Fields	Multiple date fields serve different purposes. Week Worked shows when the work occurred, Accounting Period Date indicates when the transaction was recorded financially, and Check Date or Invoice Date shows when payment or billing happened. Use the appropriate date field based on your reporting needs.
Hours Breakdown	Separate fields for Regular Time (RT), Overtime (OT), Double Time (DT), and Other Hours allow you to analyze exactly how hours are classified and billed. Total Hours fields aggregate these categories for quick reference. Pay hours and Bill hours may differ based on your billing arrangements.
Burden and Profitability	When Include Burden Factor is set to Yes, the report calculates Worker Comp Cost, Burden, Agency Cost, Payment Cost, Gross Profit, and Gross Profit Percent based on your Admin Tools burden factor settings. These fields help you understand true profitability beyond simple bill-to-pay margins.
W2 vs. Non-W2	The Is W2 field distinguishes between W2 employee transactions and non-W2 contractor transactions. Agency Name and Agency Cost fields populate only for non-W2 transactions. This distinction is critical for compliance and financial reporting.
Timesheet Workflow	Timesheet Saved, Submitted, and Approved fields track the complete workflow of each transaction. Use these to audit approval processes, identify bottlenecks, or investigate when specific transactions were processed through each stage.

Understanding What You're Seeing

Multiple rows for one timesheet: A single timesheet typically generates multiple transaction rows—one for each pay code used (regular time, overtime, double-time, etc.). This granularity allows precise analysis but means you'll see several related rows.

Pay-only or bill-only transactions: Some transactions have amounts in only Pay fields or only Bill fields. These represent adjustments, corrections, or special billing arrangements. Use the Show Type filter to focus on these specific transaction types.

Adjustment transactions: Total Adjustment Pay and Total Adjustment Bill fields capture transaction adjustments. GP Adjustment Pay, Bill, and Cost fields show adjustments that affect gross profit calculations.

Blank worker compensation fields: If worker compensation fields are blank, either the transaction doesn't require worker comp (like some administrative pay codes) or the WC Code hasn't been properly assigned to the placement.

Different total hours calculations: Total Hours includes Regular, Overtime, Double-Time, plus any pay codes configured with the "IncludeInOtherHours" property. Other Hours shows only the additional pay codes beyond RT/OT/DT.

Practical Applications

Reconciling Payroll Batches

Use the Time Entry Batch ID filter to pull all transactions from a specific payroll batch. Export to Excel and compare totals against your batch summary to verify accurate processing. This helps you catch data entry errors before finalizing payroll.

Auditing Client Billing

Filter by Company Name and Date Range, then set Date Type to Invoice Date. Review the Bill Rate, Bill Unit, and Item Bill fields to verify all transactions billed correctly according to client rate agreements. Export for client-facing backup documentation.

Analyzing Overtime Costs

Use Transaction Type List to filter for OT and DT pay codes. Analyze which placements generate the most overtime, compare overtime bill rates to pay rates, and identify opportunities to optimize scheduling or adjust billing arrangements.

Monitoring Gross Profit by Transaction Type

Set Include Burden Factor to Yes, then filter by specific Transaction Types or Job Types. Compare Gross Profit and Gross Profit Percent across different transaction categories to understand which types of work generate the best margins.

Investigating Payment Discrepancies

Filter by Talent ID and date range to see every transaction for a specific contractor. Review Pay Rate, Pay Unit, and Item Pay to identify discrepancies. Check Timesheet Approved By and Timesheet Approved Date to verify proper approval workflow.

Tracking Non-W2 Agency Costs

Filter to show only non-W2 transactions (Is W2 = No), then review Agency Name and Agency Cost fields. This helps you monitor subcontractor costs and ensure proper markup on agency placements.

Exporting Your Data

Export your report data to perform detailed analysis in Excel, share with stakeholders, or maintain records for auditing and compliance purposes.

1. Apply all filters you want to include in your export
2. Verify your Date Type and date range settings are correct
3. Click the three-dot menu icon (⋮) in the top right corner of the report area
4. Select your preferred format from the Download submenu:
   • Image: Creates a visual snapshot of the report as currently displayed
   • CSV File: Exports raw data compatible with Excel, Google Sheets, and database tools—recommended for detailed analysis
   • PDF File: Generates a formatted document suitable for printing or formal distribution

 

Note: Your export will include only the data visible based on your current filter selections. Transaction Detail reports can generate very large exports—use filters strategically to keep file sizes manageable and focus on relevant data.

Working with Large Exports

Transaction Detail exports can contain thousands of rows. To make analysis easier:

• Use narrow date ranges to reduce export size
• Filter to specific offices, companies, or transaction types before exporting
• Export to CSV for fastest processing and smallest file size
• Consider splitting large exports into multiple smaller reports by date range or office

Refreshing the Report

Report data refreshes automatically in the background. However, if you want to see the most current information immediately after processing payroll or approving timesheets, you can manually refresh.

1. Locate the circular arrow icon above the filter panel on the right side

2. Hover over the icon to see it expand and display the word "UPDATE"
3. Click the icon to re-run the report based on your current filter selections

The report will reload with the latest transaction data from your database, reflecting any new time entries, approved timesheets, or processed batches since you last viewed it.