> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.easyteam.io/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Export time tracking and time card data

You can export time tracking data from Easyteam to support payroll, reporting, and record review for a selected date range.

Exports can include all staff, only the staff currently shown in the table, or only selected staff members. Finalized time cards are included in exports. In-progress shifts are not.

## On this page

* [Choose the date range and filters](#2-choose-the-date-range-and-filters)
* [Export all staff or filtered staff](#2-export-all-staff-or-filtered-staff)
* [Summary export vs. Detailed export](#2-summary-export-vs-detailed-export)
* [Understand overtime and in-progress shifts in exports](#2-understand-overtime-and-in-progress-shifts-in-exports)
* [Troubleshoot exports](#2-troubleshoot-exports)

---

## Choose the date range and filters

Before you export, review the filters on the **Timesheets** page so the file matches what you need.

![Filtering timesheets data by dates](https://storage.crisp.chat/users/helpdesk/website/931439f481791800/snimok-ekrana-2024-02-14-v-011_fc6sny.png)

You can usually filter by:

* date range
* location
* staff name
* job position
* status, if your store uses approvals or suggestions

![Filtering timesheets data by locations](https://storage.crisp.chat/users/helpdesk/website/931439f481791800/snimok-ekrana-2024-03-11-v-202_qhep7i.png)

| If you only need a subset of records, then filter first and export second. This reduces cleanup later.

---

## Export all staff or filtered staff

Use this option when you want one export for the full team or for everyone currently shown in the table.

![Easily export the data to external systems](https://storage.crisp.chat/users/helpdesk/website/931439f481791800/snimok-ekrana-2024-02-14-v-014_1n5bin4.png)

#### Steps:

1. From Easyteam, go to **Timesheets**.
2. Select the date range that you want to export.
3. Apply any location or staff filters that you need.
4. Click **Export**.
5. Choose your export format and one of the following:
* **All staff** to export everyone in the selected date range.
* **Staff shown on table** to export only the records currently shown after filtering.
6. When exporting to Excel, you can export one sheet per location.
7. Click **Export Timesheets**.

![Select staff members to export and the desired format](https://storage.crisp.chat/users/helpdesk/website/-/9/3/1/4/931439f481791800/image_rqzohq.png)

---

### Single staff member time card export

To export time tracking data for one specific staff:
1. Go to the **Timesheets** page
2. Click a specific staff member
3. Click **Export**
4. Choose your export format and click **Export**

![](https://storage.crisp.chat/users/helpdesk/website/-/9/3/1/4/931439f481791800/image_arnqxk.png)

The file will contain only time tracking data for a specific person.

---

## Summary export vs. Detailed export

When exportin, you have the option to choose between **Standard** and **Detailed** export. 

Use the detailed format when you need one row per finalized time card.

![](https://storage.crisp.chat/users/helpdesk/website/931439f481791800/snimok-ekrana-2024-02-14-v-012_zrchtg.png =648xauto)

This format can include fields such as:

* staff name
* clock-in time
* clock-out time
* worked hours
* location
* amount

| Times and dates in exports follow the time zone used by the device or view that generated the export.

The Standard format includes a sum of all combined shifts, with just the totals.

---

## Understand overtime and in-progress shifts in exports

Easyteam treats overtime and in-progress shifts differently from regular finalized time cards.

### In-progress shifts

In-progress shifts are excluded from totals and exports. If a record hasn't been clocked out yet, then it won't appear in the exported totals.

If you need to finalize a record first, then refer to [Review, edit, and finalize time cards](/en/article/review-edit-and-finalize-time-cards-l9vbon/).

### Overtime

For payroll-enabled shops that use supported payroll connections, overtime can appear in exports for the selected date range.

Overtime behavior to know:

* overtime is calculated for the selected date range
* overtime is not distributed across individual shift rows
* multi-staff exports can include dedicated overtime columns
* single-staff exports can include a separate overtime summary section

For more information, refer to [Understand overtime in timesheets](/en/article/understand-overtime-in-timesheets-1ghpeol/) 

---

## Troubleshoot exports

#### A record is missing from the export

Check whether the record is still labeled **In progress**. Only finalized time cards are exported.

#### The export includes too many staff members

Review your selection method:

* **All staff** exports everyone in the date range
* **Staff shown on table** follows the current filters
* **Selected staff** exports only checked staff members

#### You want to review time cards before export

If your store wants approvals or suggestions before data is exported, then refer to [Approve and review time cards](/en/article/approve-and-review-time-cards-1pjdjfv/)

---

| Questions or need help with setup? Use the 💬 chat bubble in the bottom right corner or schedule a [1-1 free setup meeting](https://calendly.com/easyteam/30min?utm_source=crisp_helpdesk&utm_medium=crisp_helpdesk&utm_campaign=links-in-helpdesk-articles) with our team.

[**View all Time Tracking articles**](/en/category/time-clock-timesheets-8vhdx2/)