QuickBooks Desktop: Importing Project Time for Billing

Note: These instructions assume you have completed the setup instructions for Project Time to QuickBooks Desktop Edition. If you have not, see this article for instructions.

Step 1. Exporting your Data

  1. In your Timesheets.com account, visit the Reports page and then click Customizable Report under Project Time Tracking.
  2. Select your date range and other filters for your download file.
  3. Once you’ve selected all the correct criteria, set the Group type to None and the Format to Detailed, then click View at the bottom of the page.
  4. In the upper right corner of the next page, select the QuickBooks CSV from the drop-down menu.
  5. Do not open the file. Instead, save it locally in a directory of your choice. Export files are saved in your Downloads directory unless you specify otherwise.

Step 2. Importing your Data to QuickBooks Desktop

  1. Open the Timesheets.com Importer App by double clicking the icon you installed on your desktop during setup.
  2. Click the Project Time for Billing button along the top of the app window. An “open” window will appear. Find and select your downloaded file.
  3. When opened, your data will appear in the importer window. You can make any last minute changes to the data here by editing the cells directly.
  4. At the bottom of the importer app window, you can select whether to create invoices automatically and whether to import time if the Customer or Job cannot be found in QuickBooks.
  5. Click the Import to QuickBooks button in the bottom-left to begin the import process.
  6. Once your data is imported, you’ll see a message confirming your import. You may now close the Timesheets.com Importer App and begin your billing process in QuickBooks. The data will have been written to individual employee or contractor timesheets.

Notes

  • Employees are compared between Timesheets.com and QuickBooks using their employee number, so exact spelling of names is no longer required, but other list items must have exact spelling and capitalization of names; otherwise, the import will not work. This includes customers and jobs, service items, classes, and payroll items.
  • Once the import process is complete, the data will be in QuickBooks on the weekly timesheets. When you create invoices, QuickBooks will notify you that you have unbilled time on your timesheets and ask you if you want to use that data.
  • The Account Code from Timesheets.com can be configured to translate into any of these QuickBooks values:
    • Service Item (default value)
    • Payroll Item
    • Sub-Job
    • Class
  • When importing, if you check the box for the option to create or reactivate customers and jobs, then the process will create or reactivate customers and jobs if they don’t already exist in QuickBooks at the time of the import.
  • While projects can be used between multiple customers in Timesheets.com, this is not true in QuickBooks. QuickBooks requires each customer to have its own unique jobs even if they have the same name.

Was this article helpful?

Related Articles