# Team Billable Hours Export

Source: https://docs.astalty.com.au/guide/exports/team-billable-hours

> Generate an export of your team's billable hours from the Exports page.

## Finding the Team Billable Hours Export

Open [**Exports**](https://app.astalty.com.au/exports), select **Create Export**, then select **Team Billable Hours**.

![The Create Export page scrolled to the Finance group, with the Team Billable Hours row highlighted below Team Billables.](https://docs.astalty.com.au/assets/tbhs-guide.png)

## 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.

![The Team Billable Hours Export form with Olivia Brennan selected as the team member and no Include deactivated users checkbox shown.](https://docs.astalty.com.au/assets/team-billable-hours-export-team-member-selected-guide.png)

### 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.

![The Team Billable Hours Export form with the Export Layout drop-down open, showing Daily and Summary options.](https://docs.astalty.com.au/assets/team-billable-hours-export-layout.png)

### 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.

![The Team Billable Hours Export form showing Start Date and End Date fields, optional Select a Team Member, Select Teams and Select Regions drop-downs, Export Layout set to Daily, and an unticked Include deactivated users checkbox above the Create Export button.](https://docs.astalty.com.au/assets/team-billable-hours-export-include-deactivated-users.png)

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.

> **Which hours are included?**
>
> Astalty includes the hours a deactivated user recorded while they were working, based on the date range you select. Deactivating a user does not remove their historical hours.

For how deactivation works and how to reactivate someone, see [Restricting, Deactivating and Reactivating Users](https://docs.astalty.com.au/guide/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](https://app.astalty.com.au/exports) page where you can click on **Download** to save it to your device.

> **Export taking longer than expected?**
>
> All exports run in the background. If the export takes at least 20 seconds to become ready, Astalty also emails you. Download it from the Exports page.

## Exported Fields

Columns depend on the selected **Export Layout**.

### Daily

- 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.

### Summary

- The CSV file includes:
  - User ID
  - Name
  - Email
  - 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.