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.

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. If you select a deactivated team member, you also need to tick Include deactivated users below — otherwise the export comes back with no rows for them.

Select Teams

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

Include Deactivated Users

Use the checkbox for Include deactivated users if you would like the export to 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. Tick the box when you need a complete picture of a period that someone has since left — for example, reconciling billable hours for a past quarter or finalising payroll for a departing staff member.

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, click on “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 will include several important headings;
  • User ID
  • Name
  • Email
  • Date
  • Billable Hours
  • Unbillable Hours
  • Target Hours
  • Variance

There is one row per team member per day in the date range. Deactivated users aren't flagged in a separate column, so if you've ticked Include deactivated users and need to tell them apart, match on the User ID or Email column.