Before integrating your QuickBooks Online account, make sure you’ve taken the following steps to ensure data moves smoothly between Work and QuickBooks.
- Check your version: The QuickBooks Online integration supports the Australian, Canadian, US & UK versions only.
- Check your Income Accounts: Some companies may have multiple Income Accounts (ex. Landscaping and Snowplowing). Please note that the Work integration supports one Income Account at a time. Learn more about QuickBooks’ Income Accounts.
- Check your Sub-Customers: Make sure your QuickBooks Online Sub-Customers represent customer site locations.
- Check Number of Customers and Sub-Customers: If you have over 10,000 Customer and Sub-Customers records in QuickBooks Online, let your Integration Specialist know prior to set up.
In both QuickBooks and Work:
- Check your Company Name: Company Names must be 50 characters or less in order to properly sync between Work and QuickBooks.
- Check your Item names: Like Company Name, your Item names must be 31 characters or less in order to properly sync between Work and QuickBooks.
- Check your Country and Currency: Make sure your Country and Currency in QuickBooks Online matches your Country and Currency in Work.
- Set your tax values: Make sure you have tax rate values set in both systems. The Work integration marks individual items on invoices as “taxable” and then allows QuickBooks to determine the tax applied to the invoice. Learn more about setting tax values in QuickBooks.
- Check the State field: Make sure State information (ex. Massachusetts) is filled-out in QuickBooks for your Customers. If not, and all records are associated with the same State, select the “Use default State in Work” option in your Sync Settings. If records are associated with various States, please make sure the field is filled-out to prevent a “Missing State” error for those records.
- Check for Special Characters: Some special characters such as / \ " '# ^ * tend to cause errors when attempting to sync information from QuickBooks to Work and vice versa.