Enhanced Accrued Hours 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 Accrued Hours Report provides detailed visibility into talent hours worked within a specified time period. Track regular and overtime hours, verify payroll accuracy, and ensure compliance with benefit qualification thresholds. Access comprehensive hour-level data to support bonus calculations, holiday pay determinations, and workforce planning decisions.

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

→ Strategic 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 ACCRUED or scroll to locate the report
3. Click on the Accrued Hours Report
4. The report loads immediately with data based on your filtering options

Note: Reports load with default date ranges as the initial setting. 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 talent records than colleagues with broader visibility.

Understanding This Report

What This Report Shows You

The Accrued Hours Report displays total hours worked by talent across your organization within a defined time period. Each row represents an individual talent member, showing their regular hours, overtime hours, billing amounts, wage information, and associated transaction details. The report provides both summary-level metrics and granular hour breakdowns by pay code, giving you complete visibility into time tracking and compensation data.

Unlike activity-based reports that track discrete events, this report aggregates time data to show cumulative hours. This makes it particularly valuable for payroll verification, compliance monitoring, and financial analysis where precise hour totals drive critical business decisions.

Why Use This Report

This report helps you answer critical questions about workforce time management and compensation:

• Which talent are approaching benefit qualification thresholds based on hours worked?
• How many total hours did we bill versus pay for a given period?
• Are there discrepancies between entered hours and expected hours that require investigation?
• Which talent qualify for bonus pay or holiday pay based on hour requirements?
• What is the breakdown of regular versus overtime hours across offices or regions?
• How do wage costs compare to billing revenue for specific talent or time periods?
• Are there patterns in overtime usage that indicate staffing gaps or scheduling inefficiencies?

Who Benefits From This Report

Payroll Administrators: Verify hour entries before processing payroll, identify data entry errors, and ensure accurate wage calculations. Use hour totals to confirm timesheet submissions align with placement schedules and catch discrepancies before they become payroll issues.

HR & Benefits Coordinators: Track talent hours to determine benefit eligibility based on hour thresholds. Monitor ACA compliance by identifying talent approaching full-time status, and manage benefit enrollment windows based on qualifying hours worked.

Finance Teams: Analyze wage costs versus billing amounts to understand margin performance at the talent level. Use historical hour data to forecast labor costs, budget for overtime expenses, and identify high-cost placements that may need rate adjustments.

Operations Managers: Monitor overtime patterns to identify potential scheduling improvements or staffing needs. Track hours by office or region to ensure workload distribution aligns with capacity, and use hour trends to plan for seasonal demand fluctuations.

Using Filters

Filters appear on the right side of your screen and help you focus on specific segments of your hour data. All filters default to "Include all" when you first open the report.

Available Filters

Filter Name	What It Does	When to Use It
Division	Filters hours by the employer/division associated with the transaction	Review hour totals for a specific business unit or employer entity
Region	Filters hours by geographic region	Compare labor costs and hour distribution across territories
Office	Filters hours by branch location	Evaluate individual office payroll totals or investigate location-specific overtime patterns
Accounting Period Date	Sets the specific start and end dates for hour calculation using the accounting period.	Define the exact time period for hour analysis, aligned with payroll cycles or reporting periods
Week Worked	Provides preset date range options (Yesterday, Last Week, This Month, etc.) for week worked.	Quickly generate standard reporting periods without manual date entry. Automatically disables Date From/To when selected.

Working with Date Filters

The Accrued Hours Report offers two approaches to defining your time period:

• Date From / Date To: Manually select specific start and end dates for custom time periods
• Date Range: Choose from preset options like Yesterday, Last Week, This Week, This Month, or Last Month

Note: When you select a Date Range option, the Date From and Date To fields automatically disable. You must use either Date Range presets or manual date entry—not both simultaneously.

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, entering values, or choosing from dropdowns
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

Understanding the Report Columns

The Accrued Hours Report displays comprehensive talent information and hour details. Each row represents one talent member with their cumulative hours for the selected time period.

Column	What It Shows	How to Use It
Transaction Employer	The division/employer associated with the time entry	Group hours by business unit for financial reporting
Transaction Region	The geographic region where hours were worked	Analyze regional labor distribution and costs
Transaction Office	The branch location responsible for the transaction	Track office-level payroll totals and overtime usage
Talent ID	The unique identifier for the talent in the system	Reference talent records or cross-reference with other reports
BO Talent ID	The talent's identifier from Back Office/Classic systems	Match records when reconciling data across legacy systems
Talent	The talent member's full name (clickable link to their profile)	Click to view complete talent details or placement history
Talent Status	Current status of the talent (Active, Inactive, etc.)	Identify inactive talent who still have recent hours (potential data issues)
Talent Representative	The recruiter or rep assigned to this talent	Track hours by recruiter for performance analysis
First Name / Middle Name / Last Name	Individual name components for the talent	Export for external systems requiring separated name fields
Address Fields (Street 1, Street 2, City, State, Zip Code, GEO Code)	Complete address information for the talent	Use for tax reporting, benefits administration, or geographic labor analysis
Talent Email / Talent Phone	Contact information for the talent	Reach out regarding hour discrepancies or benefit eligibility
Currently Placed	Indicates if talent is currently on an active placement (Yes/No)	Identify talent with hours who are not currently placed (may indicate end-of-placement timing or data entry lags)
First Placement Start Date	The date the talent began their first placement with your organization	Calculate tenure for retention analysis or longevity-based benefits
Reg Hours	Total regular hours worked during the date range	Verify standard hour expectations and identify under-utilized talent
OT Hours	Total overtime hours worked during the date range	Monitor overtime costs and identify candidates for additional placements to reduce OT
Total Hours for Date Range	Combined regular and overtime hours for the selected period	Compare against benefit thresholds or bonus eligibility requirements
Total Hours Since First Placement	Cumulative paid hours from the talent's first placement to present	Track lifetime hours for milestone recognition or tenure-based benefits
Latest Reg Pay Rate	The most recent regular pay rate for this talent	Verify current compensation levels or identify rate change needs
Reg Bill / OT Bill	Total billing amounts for regular and overtime hours	Calculate gross margin by comparing billing to wage costs
REG Wages / OT Wages	Total wage costs for regular and overtime hours	Track labor costs and budget compliance
Gross Wages	Total wage expense (regular + overtime) for the date range	Use for payroll verification and financial forecasting
Bill Hours	Total billable hours for the date range	Compare to total hours to identify non-billable time
Avg Weekly Pay	Average weekly wages calculated as (Reg Wages / Number of Invoices) per office	Use for ACA reporting or weekly benefit calculations
Avg Daily Pay	Average daily wages calculated as (Avg Weekly Pay / 5)	Estimate per diem costs or daily rate calculations
ACA Status	The talent's ACA status from the Talent profile Extra section	Monitor ACA compliance and benefit offering requirements
ACA Eligibility	Indicates whether talent qualifies for ACA benefits	Ensure compliant benefit administration
Last End Reason	The end reason from the talent's most recently ended placement	Analyze turnover patterns or identify rehire opportunities
Latest Job Title	The job title from the talent's most recent placement	Track skill sets and placement types across your talent pool
Latest Start Date / Latest End Date	Start and end dates of the talent's most recent placement	Identify re-engagement opportunities for recently ended placements
Last Check Date	The most recent paycheck date for this talent	Verify payroll processing is current and identify payment gaps
Dynamic Pay Code Columns	Hours for each pay code selected in the filter parameters appear as individual columns after Last Check Date	Analyze specific pay types like holiday pay, shift differentials, or bonus codes. These columns only appear when the selected pay codes have associated transactions in the date range.

Note: Blue, underlined text in the Talent column indicates clickable links that navigate to talent profiles for more detailed information.

How to Interpret What You're Seeing

High overtime percentages: If talent consistently show OT hours exceeding 20% of total hours, this may indicate understaffing on placements, schedule inflexibility, or opportunities to add additional talent to reduce overtime costs. Compare overtime rates against client billing arrangements to ensure profitability.

Discrepancies between bill hours and total hours: When bill hours are significantly lower than total hours worked, investigate non-billable time categories. This could indicate training time, breaks, or data entry errors that need correction before invoicing.

Talent approaching benefit thresholds: Use the Total Hours for Date Range to identify talent nearing eligibility for health insurance, 401k, or other hour-based benefits. Proactive communication about upcoming eligibility improves talent satisfaction and ensures compliance with benefit offering deadlines.

Inactive talent with recent hours: If talent marked as Inactive show hours in the current period, this may indicate timing lags between placement end dates and status updates, or potential data integrity issues requiring investigation.

Wide variations in average weekly pay: Significant differences in average weekly pay across similar job titles or experience levels may indicate rate inconsistencies, opportunities for rate negotiations with clients, or talent who should be considered for higher-paying placements.

Strategic Applications

Payroll Verification & Accuracy

Run the Accrued Hours Report before each payroll cycle to verify total hours match timesheet submissions. Compare regular and overtime hours against placement schedules to catch data entry errors before processing. Export the report and cross-reference against your payroll system to ensure wage calculations align with entered hours.

Use the Last Check Date column to identify talent who haven't received recent paychecks despite showing active hours. This early detection prevents payment delays and maintains talent satisfaction.

Benefits Administration & Compliance

Filter by Total Hours to identify talent approaching ACA full-time thresholds (typically 130 hours per month or 30+ hours per week). Monitor these talent closely to ensure timely benefit offerings and avoid compliance penalties.

Track cumulative hours using Total Hours Since First Placement to determine eligibility for tenure-based benefits like additional PTO, 401k vesting, or bonus programs tied to lifetime hours worked.

Export historical data quarterly to document ACA measurement periods and administrative periods. This creates an audit trail demonstrating compliance with look-back measurement requirements.

Cost Analysis & Margin Management

Calculate gross margin for each talent by comparing total bill amounts (Reg Bill + OT Bill) against total wages (Gross Wages). Identify talent with low margins—these may require rate renegotiations with clients or placement reviews to improve profitability.

Track overtime costs by office or region to identify locations with excessive OT expenses. High overtime usage may indicate understaffing, poor schedule management, or opportunities to add talent and reduce premium pay.

Use historical hour data to forecast labor costs for budget planning. Analyze seasonal patterns in regular and overtime hours to predict when you'll need additional staffing or when costs typically spike.

Bonus & Incentive Calculations

Filter by specific date ranges to identify talent who qualify for quarterly or annual hour-based bonuses. Export filtered results to streamline bonus payment processing.

Use dynamic pay code columns to isolate holiday pay hours, shift differential hours, or other special rate categories when calculating incentive compensation tied to specific work conditions.

Workforce Planning & Optimization

Analyze hour distribution across offices and regions to identify imbalanced workloads. Offices with consistently higher average hours per talent may need additional placements or recruiting support.

Compare total hours worked against currently placed status to find talent who recently completed assignments. These individuals are prime candidates for immediate re-engagement and new placement opportunities.

Track average weekly hours by job title to understand typical workload patterns for different roles. This data informs job descriptions, client expectations, and helps set realistic placement hour commitments.

Exporting Your Data

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

1. Apply any filters you want to include in your export
2. Click the three-dot menu icon (⋮) in the top right corner of the report area
3. 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—ideal for payroll system imports
   • PDF File: Generates a formatted document suitable for printing or formal distribution
   • Excel File: Creates a native Excel workbook with formatted data

Note: Your export will include only the data visible based on your current filter selections. To export everything, ensure all filters are set to "Include all" before downloading.

Additional Options in the Menu

The three-dot menu also provides options to repeat rows (useful for printing), merge rows, and other display customizations. These settings affect how your report appears on screen and in exports.

Refreshing the Report

Report data refreshes automatically in the background. However, if you want to see the most current information immediately after changing filters or if you know recent time entries have occurred, 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 data from your database, reflecting any new time entries or changes that occurred since you last viewed it.