Articles in this section

Release Notes: Timesheet Validation - BI Template (GA)

Release Date: Jan 2026

Critical information:

Status

  • General Availability (GA): Fully released and available to all eligible Users.

 

Availability

  • Plans: All ActivConnect subscription tiers
  • Rollout schedule: Immediate

 

Requirements

  • ActivConnect (Add-on): Required ActivConnect subscription
  • BI platform: Power BI Pro or Premium license (Tableau and Looker support coming in future releases)
  • Data input: Google Sheets access
  • Agent deployment: The ActivTrak agent must be deployed to the user machines
  • Permissions: Admin role required for setup
  • Report access: Based on Power BI configuration permissions

 

What's new:

Feature description

Turn timesheet validation from a trust-based system into a data-verified process. Analytics-based reconciliation compares reported timesheet hours to actual productive hours worked, without requiring employees to change their reporting workflows or adopt new time-tracking systems.

 

Key capabilities

  • Team-level analysis: Break down unrealized timesheet hours by team to identify discrepancies and drive accountability
  • Financial impact calculator: Automatic calculation of dollar impact and annualized costs to quantify potential savings
  • Discrepancy rate analysis: View unrealized capacity by timesheet discrepancy rate bands to identify patterns and prioritize action
  • Recurring pattern detection: Identify users with consecutive months of unrealized timesheet hours to surface systemic issues
  • Trend visualization: Monthly trending of unrealized timesheet costs and affected user percentages to monitor improvement over time
  • Export capabilities: Export data for further analysis, documentation, and operational review

 

Use cases

Organizations with significant workforce spend can identify and address timesheet discrepancies that lead to unrealized costs. Finance, HR, and operations leaders gain visibility into timesheet accuracy by comparing reported hours to actual productive time—enabling stronger payroll integrity, workforce accountability, and fair, transparent time reporting.

 

How to access:

  • Download directly from within the app. Log in to ActivTrak and navigate to API & Integration > ActivConnect & BI
  • Access Requirements: Active ActivConnect subscription

 

Implementation:

  • Standard setup: Less than 30 minutes
    • 5-10 minutes - Power BI template installation
    • 5-10 minutes - Google Sheets configuration
    • 5-10 minutes - Initial data load and validation

 

Additional information:

Known limitations

  • V1 Data Entry: Manual data entry via Google Sheets required. Direct integration with ADP, Workday, and other HRIS systems is coming in future versions.

 

Coming soon

  • Direct HRIS integrations (ADP, Workday)
  • Tableau and Looker BI platform support
  • Advanced analytics custom packages

 

Resources:

Documentation

 

Support

Was this article helpful?
0 out of 0 found this helpful