Skip to main content

Zap Data Hub – Compare the Average Timesheet Rates report

Compare the Zap Data Hub Average Timesheet Rates report with the Time+Billing WIP Ledger Entries Report using activity‑based filtering

Generate a comparison report in Time+Billing

1. Open the WIP Ledger Entries report

  1. In Time+Billing, go to Reports

  2. Select WIP Ledger

  3. Click WIP Ledger Entries Report

2. Configure the report

  1. Set Report type to Activity

  2. Select a single Activity code

    • (Any valid activity code can be selected)

3. Add a WIP filter

  1. Click Add filters

  2. In the Select report filters window, click the ellipsis (…) next to WIP filter

  3. Locate and highlight the filter called WIP For Cost Code '200'

  4. Click Copy

4. Create a new custom filter

  1. Give the filter a name that includes your required cost code

    • Example: WIP For Cost Code 101

  2. Click Save

5. Edit the filter expression

  1. Highlight the filter you just created

  2. Click Edit

  3. Change the cost code in the filter expression so it matches your new filter name

  4. Click Save

  5. Select the new filter

  6. Click OK

6. Generate the report

Time+Billing will now generate the report using your updated WIP filter.

7. Export the report to Excel

  1. Click File > Export to Excel

  2. Open the exported spreadsheet

8. Calculate the average timesheet rate

In Excel:

  • Add up all rate values

  • Divide the total by the number of rows in the exported data

This gives you the average rate that can be compared to the Average Timesheet Rates Report in Zap Data Hub.

Related Articles
Did this answer your question?