ActivTrak for Power BI - Timesheet Reconciliation empowers finance and operations leaders to identify and eliminate timesheet overbilling with precision. This powerful tool reveals unrealized timesheet hours by comparing reported time against actual productive activity, calculates their financial impact by team, and uncovers recurring patterns of discrepancy—transforming timesheet data into strategic cost-savings opportunities that protect your budget and strengthen workforce accountability.
ActivConnect is available as an add-on for customers on a paid plan. Learn more about ActivConnect here.
Contents
Template access requirements
Before you begin, ensure you have:
- An ActivTrak paid plan and the ActivConnect API (Add-on).
- Your ActivConnect username ([account_number]@activtrak.us) and password. Your account number is in the Account Information menu in ActivTrak; access it via the circle icon in the top right corner.
- An active Power BI license.
Access the template
Validate your ActivConnect credentials
- Navigate to Google Cloud Console.
- Log in with your ActivConnect username ([account_number]@activtrak.us) and password.
Copy and update the Timesheet Reconciliation Configuration Template
- Make a copy of the Timesheet Reconciliation - Configuration Template (File > Make a Copy) and give it a unique name. You should now be able to edit the copy of this Google Sheet.
- In the Time Sheet Data tab, update columns A through F ("Date", "Employee ID", "Shift Start", "Shift End", "Break Start", and "Break End") with your own timesheet data.
- In the Hourly Rate tab, update columns A and B ("Employee ID" and "Hourly Rate").
- Once the Google Sheet is updated, copy the URL.
Download and install the PBIT file
- Within the ActivTrak app, navigate to APIs & Integrations > ActivConnect & BI.
- Find the Timesheet Reconciliation card and click the Power BI download icon.
- Unpack the zip file and open the "ActivTrak for Power BI - Timesheet Reconciliation.pbit" file using Power BI Desktop
- Enter your ActivTrak account number and paste the URL of your updated Timesheet Reconciliation Configuration template into the "Configuration URL" field. Your account number is in the Account Information menu in ActivTrak; access it via the circle icon in the top right corner.
- Click Load. This process will take a few minutes.
- During data connection, a pop-up window will appear asking you to log in to Google Sheets. You will be redirected to the browser to complete the sign-in process, then back to Power BI. Once you have signed in, click Connect in the bottom right corner.
- Another pop-up window will then appear to log in to Google BigQuery. Ensure you log in with your ActivTrak-provided credentials in the format of [account_number]@activtrak.us.
- Once complete, go back to Power BI and click Connect
- The data refreshment may take a few minutes. A successful connection results in messaging indicating the number of "rows from GoogleBigQuery" that were refreshed.
Important:
Currently, this template only supports setups where the Employee ID provided in the Google Sheet matches the Employee ID configured on the ActivTrak Users page, with one Employee ID per user. If a user has multiple Employee IDs on the ActivTrak Users page, the Power BI dashboard will not function properly.