Team Billable Hours Export

Finding the Team Billable Hours Export

To generate an export of team billable hours head to the Exports page in Astalty. Then click *Create Export *and select Team Billable Hours or click here.

You need the Access Exports Module permission.

Configuring the Export

Start Date

The start of the date range you'd like to export for.

End Date

The end of the date range you'd like to export for. This must be the same as or after the Start Date.

Select a Team Member

Select a team member to specify the export to this report. This is an optional selection.

This drop-down includes deactivated users as well as active, invited and restricted ones, so you can pick someone who has since left your organisation. Selecting a deactivated team member includes their hours in the export automatically. Astalty hides Include deactivated users below once a team member is selected, since it no longer applies.

Select Teams

Select a team to specify the export to this report. This is an optional selection.

Select Regions

Where Regions are enabled and you can view all Regions, select one or more Regions to limit the export by the Team Member's Region. Select Unassigned to include Team Members with no Region.

Include Deactivated Users

This checkbox only appears when Select a Team Member is empty. Use it if you'd like a Select Teams or unfiltered export to also cover team members whose accounts have since been deactivated.

This box is unticked by default, so a standard export leaves out anyone whose account has been deactivated. Deactivation is the only status it filters on. Restricted and invited users are still included either way.

Ticking the box only widens which team members are considered. It doesn't change how hours are calculated, and a deactivated user still only appears if they recorded hours within the selected date range.

For how deactivation works and how to reactivate someone, see Restricting, Deactivating and Reactivating Users.

Creating the Export

After setting the date range, select Create Export.

Downloading the Export

When the export is ready it will appear on the Exports page where you can click on Download to save it to your device.

Exported Fields

• The CSV file includes:
  • User ID
  • Name
  • Email
  • Date
  • Billable Hours
  • Unbillable Hours
  • Target Hours
  • Variance

Only Team Members with Task time in the selected range appear. For each included Team Member, the CSV has one row for every day in the range, including days with zero hours.

Billable Hours and Unbillable Hours total the corresponding Task time for that day and are rounded to two decimal places. Target Hours is one fifth of the Team Member's weekly billable target on weekdays and zero on weekends. Variance is Billable Hours minus Target Hours.

Deactivated users are not flagged in a separate column, so match on User ID or Email to identify them.