--- title: "Timesheets Report Export" description: "How to export timesheet entries and related information such as timesheet approval statuses, spent time costs, work by Member, work by Work Category, work by Phase, work by Project, work by date, billable work, non-billable work, work by hours, and work descriptions?" url: https://support.mosaicapp.com/en/articles/125-timesheets-report-export collection: "Admin Hub - Data Export" updated: 2026-07-28 language: en --- # Timesheets Report Export How to export timesheet entries and related information such as timesheet approval statuses, spent time costs, work by Member, work by Work Category, work by Phase, work by Project, work by date, billable work, non-billable work, work by hours, and work descriptions? The exported Timesheet file includes approval statuses, time costs, and breakdowns by **Member**, **Work Category**, **Phase**, **Project**, **date**, **billable vs. non-billable work**, **hours**, and **work descriptions**. These exports help project managers monitor time spent across various Projects and Tasks, track progress, and generate accurate reports for billing and invoicing. ## What does it look like? The file will include the following columns: - Date: Date of the timesheet - Member: Member name - Role: Member role - Portfolio: Portfolio - Project: Project name - Project Number: Project number - Phase: Phase name - Phase Number: Phase number - Work Category: Work Category number - Work Category Code: - Description: Description of the timesheet - Hours: Timesheet hours - Bill Rate: Rate for timesheet - Expense Amount: Total currency amount of the timesheet calculated by Rate\*Hours - Billable: True/False, billable or not - Approval Status: Not Submitted, Submitted, Approved ## How to export? 1. Navigate to the **Reports** page and click on **Timesheet Report**. ![](https://staticfiles.gleap.io/ghelparticle/M8VGA3GBZ9gNNNnOgnkVqJ57Ulql31TozblLJ6VC0qXngfdSdWdjbitB4gmsecXyXGc2ZNIrPyd.png) 2. Select the **date range** for the timesheets to export. Use filters to narrow down the results as needed.For example, to export time entries for the **IT Project** between **June 1, 2025** and **June 19, 2025**, apply the **Project** filter and select the appropriate dates. ![](https://staticfiles.gleap.io/ghelparticle/UGpaOCulLNijCJTsTGS82ph3ngkzabUoQahSJhboHlblBPUVkrKkcpwYFEx2EB7VEQeenqJl9jn.png) 3. Click the **three-dot icon** next to the **Filter** button and choose the desired export format. For formatted XLSX option, you can also select to have Work Categories as columns or as groups. All timesheet entries visible on the page will be included in the export. > **Warning:** If the Member performing the export lacks the necessary permissions to view Cost Rates, the Cost Rate column in the exported file will remain blank. ![](https://staticfiles.gleap.io/gattachments/cM955djBK7Beke4RXi1TblEFePp5T1QDligciyU2MeyLAs0sz7VxhKK0Na6SMqPer9Gdcj1eWyR.png) 4. The file will be sent to the email address of the current user once it's ready, as well as a notification in Mosaic, which you can just click on the notification to download the file. ![](https://staticfiles.gleap.io/ghelparticle/B669rCO4qDDxSx1X6u3aqN54BF9wGiQMqibl2fr6e1OzArO1FmOsWce1oZZse4QSU3qtqXatu9b.png) 5. You will see the notification icon with a number on the top right when the file is ready to download. Click the icon to go to notifications page. ![](https://staticfiles.gleap.io/ghelparticle/Xyj7eoO4AFBasQ3f1UvSFacjZezrvrKx6JsUw5admZJPjsmY6CT0CGz2aTKaSSm7NvEF5W1xAgD.png) 6. On the notifications page, the notification looks like this. Click on the download button to download the file. ![](https://staticfiles.gleap.io/ghelparticle/a1cHVDEp3Ba6ZwuLKQQJMNt7hbBhHXMi5dbomA1PzKDMMNz8CmDPgyncjqjEfJlrA8EtTo0et1T.png) The email will look like this. If there is an issue with the Download Exported File button, there is a link at the end of the email that can be copied and pasted into a browser to download the file. > **Warning:** The download link in the email will expire after 24 hours. If the export needs to be downloaded after the link is expired, repeat the export process. ![](https://staticfiles.gleap.io/ghelparticle/P11xKOuG4TvKHdNaIIOxwsN0DEl39BGh2R3a7YMtLujOiX5LcIDQ0Y0JKQTYiC7rAfnZqSEFSqq.png) > **Info:** The export will be processed and made available based on your [email settings](https://support.mosaicapp.com/en/articles/261-data-export.md). ## **Sample Export** [**Download a sample CSV export**](https://samples-csv-export.s3.amazonaws.com/export_timesheet-report-2024-03.csv) [**Download a sample XLSX export**](https://samples-csv-export.s3.amazonaws.com/export_timesheet-report-2024-09.xlsx) ## Recent Updates ### Sep 2024 [Sample](https://samples-csv-export.s3.amazonaws.com/export_timesheet-report-2024-09.xlsx) - Updated xlsx export style ### March 2024 [Sample](https://samples-csv-export.s3.amazonaws.com/export_timesheet-report-2024-03.csv) - Add currency symbol to columns - Bill Rate - Cost Rate - Bill Rate Expense - Cost Rate Expense ### January 2024 [Sample](https://samples-csv-export.s3.amazonaws.com/export_timesheet-report_2024-01.csv) - Added Project Currency column on csv export ### September 2023 [Sample](https://samples-csv-export.s3.amazonaws.com/export_timesheet-report_2023-09.csv) - Updated the column order - Renamed - "Project Number" to "Project Ref#" - "Profit Center" to "Phase Profit Center" - "Work Category Code" to "Work Category Ref#" - "Expense" to "Bill Rate Expense" - Removed - "Role" - Added - "Member Email" - "Project Client" - "Project Profit Center" - "Phase Ref#" - "Cost Rate" - "Cost Rate Expense" - Subphase fields - "Subphase 1" - "Subphase Ref# 1" - ... - "Subphase 9" - "Subphase Ref# 9"