Team Billable Hours Export
Finding the Team Billable Hours Export
Open Exports, select Create Export, then select Team Billable Hours.
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, and no more than 366 days after it.
Select a Team Member
Select a Team Member to limit the export to that person. This selection is optional.
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 one or more Teams to limit the export to their members. This selection is optional.
Select Regions
Where Regions are enabled, select one or more Regions to limit the export by the Team Member's Region. Select Unassigned to include Team Members with no Region.
Export Layout
Choose how rows are laid out in the export:
- Daily (default) - one row per Team Member per day, unchanged from before this option existed.
- Summary - one row per Team Member for the whole date range, with Billable Hours, Unbillable Hours, Target Hours and Variance totalled across the period.
Export Layout applies on top of the same Team Member, Teams, Regions and Include deactivated users filters either layout uses.
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
Columns depend on the selected Export Layout.
Daily
- The CSV file includes:
- User ID
- Name
- 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.
Summary
- The CSV file includes:
- User ID
- Name
- Period
- Billable Hours
- Unbillable Hours
- Target Hours
- Variance
Every Team Member in scope appears, with one row for the whole date range - including Team Members who recorded no hours in the period, who get zero Billable and Unbillable Hours. This differs from Daily, which only includes Team Members with Task time in the range.
Period is the selected date range, formatted d/m/Y - d/m/Y (for example, 12/10/2026 - 18/10/2026). Billable Hours and Unbillable Hours total the Team Member's Task time across the whole period. Target Hours is one fifth of the Team Member's weekly billable target multiplied by the number of weekdays in the period. Variance is Billable Hours minus Target Hours.
Deactivated users are not flagged in a separate column in either layout, so match on User ID or Email to identify them.