# Exporting Timesheets to Quickbooks Comm.care makes it easy to gather the hours your team has worked and send them straight to Quickbooks for payroll. In this article we'll walk through how to export your Timesheets into Quickbooks. > _Learn more about:_ [How to export Timesheets from Comm.care](../../features/reporting/running-reports.md)_._ ## Before you start Two quick things to set up the first time you do this: 1. **Tell Comm.care you're using Quickbooks for Timesheets.** Go to **My Organisation > Organisation Information box > Back Office** and set the **Timesheet Integration** to **Quickbooks**. From now on, your Timesheets report will download in the Quickbooks format, ready to upload. <video src="help/Attachments/timesheet-integration-quickbooks.webm" autoplay loop muted playsinline></video> 2. **Add an Employee ID to each staff member.** Go to **Organisation > Staff**, open a staff member's profile, and enter their **Employee ID** (the same ID you use for them in Quickbooks). The field sits under Time Zone on the User Profile and is optional in general, but it's what Quickbooks uses to match each row to the right employee — so fill it in for anyone whose hours you want to export. <video src="help/Attachments/staff-profile-employee-id.webm" autoplay loop muted playsinline></video> ## Download the Timesheet file from Comm.care Go to **Organisation > Reports**, pick **Timesheets** as the report type, choose the dates you want, and click **Generate report**. Then click **Action > Download CSV** to download the CSV in Quickbooks format. <video src="help/Attachments/timesheet-download-quickbooks.webm" autoplay loop muted playsinline></video> Once you've got the file, follow the steps below to bring it into Quickbooks. ## Importing Timesheets to Quickbooks Quickbooks allows CSV file formats to run payroll. To import timesheets, please ensure the timesheet service is enabled with the Timesheet service page under payroll settings in Quickbooks. You’ll be able to enable timesheets and configure providers from there. Follow the steps below to import timesheets into Quickbooks: ## Tab 1: **Select Manage Employees > Import Timesheets on your payroll dashboard**  Choose ‘Custom file upload’ as the source of the timesheet from the drop-down menu.  This option allows you to import CSV files in Quickbooks that we just downloaded from Comm.care. The file contains all the required information for a successful import. ## Tab 2: Select the file to upload  You’ll find the downloaded CSV file under the ‘Downloads’ folder on your computer. Once, the file has been uploaded, you’ll be able to set the date format of the file, which will be ‘Australian’ in this case. > _**Note:**_ that CSV file from Comm.care does not have a location for the timesheet. In this case, the employee’s default location (as per employee records/pay run defaults page) will be assigned to the timesheet when the data is imported. ## Tab 3: Mapping each column/field The next step is to map each column with the type of data. A preview of the first few lines of each column is shown to help you match. The image below shows all the available columns:  Once you map the columns of the CSV with Quickbooks, you can start the import. > _**Note:** If you get any errors during the import, you can always replace the previous import (unless it has been included in a pay run) with a new one after fixing the error._ ## Tab 4: Timesheet approval You can choose if you want the timesheets to be automatically approved or whether they should go through the standard process of approval. Once done, click **Import** to begin.  Once the timesheet is imported, check for errors. You will be able to re-configure the columns and re-upload the file. After a successful import, you may choose to save the file format to be used in future. This will save you time to map the column types each time. To do so, click **Save the file format link > Enter preferred name for it > Save timesheet format**.  You can later delete too by going to view custom file formats> click the delete icon next to it.  That’s it! Following these simple steps will let you import your staff hours easily from Comm.care. **Appendix** Column types to match from Comm.care  ## Related tutorials - [Accounting integration to Quickbooks](quickbooks-setup.md) — set your Invoicing and Timesheet Integration to Quickbooks in Back Office - [How to create new users](../../setup-and-configuration/staff-management/creating-users.md) — where the Employee ID field lives on a staff profile - [Running Reports](../../features/reporting/running-reports.md) — the Timesheets report in Organisation > Reports