After having integrated TSheets and QuickBooks, you can find more options or edit your original options in the QuickBooks Integration Preferences window:
- In TSheets, click the QuickBooks dropdown in the top right and select Preferences.
This article will outline all the preferences and options you will find in this window:
Employee Timesheets Should Show
These are the options that employees will see on their time cards and what their time will be tracked against.
- Customers & Jobs: When clocking in, your employees will be required to select a customer, and if applicable, a job before they can clock in. (See also: How to set up customer assignments.)
- This option can only be edited upon first integration. If you've already integrated but need it changed, reach out to support to help you with a different set up.
- Service Items: If selected, your employees will be required to select one of these from your QuickBooks Service Items list before they can clock out.
- Billable yes/no choice: If selected, your employees will have the option to mark time as billable or not billable. Billable items can be used when invoicing in QuickBooks.
- Require billable yes/no choice: If selected, your employees will be required to mark their time as billable or not.
- Class: If selected, your employees will be required to select a class before they can clock out.
Exporting Time to QuickBooks
These are the options you can select before Exporting time to QuickBooks.
- Export Approved Timesheets when Syncing (QuickBooks Desktop only): Check this box when you are ready to begin exporting approved timesheets when running a sync for QuickBooks Desktop.
- Don't export timesheets prior to this date: To set a date for the timesheet export to begin, click the calendar icon, and select a date. No time before that set date will export to QuickBooks during syncs.
Automatic import from QuickBooks (QuickBooks Online only)
The QuickBooks Online integration offers an automatic import of any new or edited information in QuickBooks to TSheets. To restrict the import, go to QuickBooks > Preferences. Under Automatically import changes to, deselect the items you don’t want to automatically import. To disable the automatic import entirely, deselect the Automatically import for changes made in QuickBooks.
- Automatically import changes made in QuickBooks
- Automatically import changes to:
- Service Items
- Import Vendors as Employees: This allows you to import your vendors from QuickBooks into TSheets as employees. This is frequently used by companies that employ 1099 contractors. Note: All active vendors with a first and last name in QuickBooks will be imported into TSheets.
- Only Import 1099 Vendors (QuickBooks Desktop only): Limits the Vendor import to only those with "Vendor eligible for 1099" checked in QBD.
- Send me an email when Employee or Vendor details change (QuickBooks Online only): Opt to have an email notification if Employee or Vendor information are updated in QuickBooks, so you know when to run an Import to update TSheets.
- Email a status report after each QuickBooks sync (QuickBooks Desktop only): Opt to have the sync report (QuickBooks dropdown > Sync Log) sent to your email.
Payroll Item Mapping Tool
Each employee must at least one payroll item mapped before time can be exported to Quickbooks. Use this tool to map their QuickBooks payroll items to the appropriate time types in TSheets (i.e., Regular, Overtime, PTO, etc.). See: How to Map QuickBooks Payroll Items