Sync your Canopy account with QBO
Written by Avery Simmons
Updated at November 4th, 2021
Info
- Currently, only one team member can connect their firm to a QBO account. Generally, the administrator would connect their QBO account for all team members to connect with.
- Quickbooks Integrations is only available on Standard and Pro licenses with contact-based pricing.
Begin the Integration Sync and Sync your Contacts with QBO
QuickBooks Online can be integrated with your Canopy account to help sync Contacts, Invoices, and Service Items between each application. Once connected, whenever a contact, invoice, or service item is created in Canopy, they will be automatically synced to QBO. To link your Canopy account to QBO, first navigate to your Settings page in Canopy.
Roles/Permissions:
- Roles: Admin
- Permissions: Manage Integrations
Info
The QBO Integration sync process can be restarted at any time by clicking the Options menu in the QBO Integration card and selecting Restart integration.
1. Select Integrations from the left-side column.
2. Find the QBO integration and click Connect.
- If the Connect button is greyed out, your account either does not have the Manage Integrations permission activated, or you are using a freemium or legacy account. To fix this, please upgrade your account to a paid account and ensure that your account is assigned a role with the Manage Integrations permission activated.
3. Enter your QBO login information in the pop-up window. Click Sign In.
4. Read and understand the data sharing agreement. Click Connect to continue.
5. Read through the recommended steps for successful integration. Click Start to confirm.
- Names of your Canopy contacts should match the names of your QBO contacts.
- Any active customers in QBO that don't match a contact in Canopy will be created as a new contact in Canopy.
6. Click Next to cycle through sync menus.
7. Click Sync contacts.
- Your QBO contacts will be synced with your Canopy account and you will be return to the Integrations page.
- Unmatched Contacts from Canopy will not be synced to your QBO account.
- Duplicate Contacts are not synced between your accounts.
Info
As long as your Canopy and QBO accounts are connected, all new contacts created in Canopy will be automatically be synced with QBO. Contacts created in QBO will need to be manually synced to Canopy.
Sync your Invoices and Service Items with QBO
The next step in the QBO Integration setup process will help you to sync your invoices and service items with QBO. Once synced, all service items or invoices created in Canopy will be automatically synced to QBO.
Please Note
Currently, the QBO Invoice sync will only sync from Canopy to QBO. All invoices previously created in QBO will still need to be manually created in Canopy.
Roles/Permissions:
- Roles: Admin
- Permissions: Manage Integrations
1. Click Next on the integration setup page.
2. Click Start to begin the sync setup.
- Alternatively, you may choose to Skip Service Items & Invoices.
3. Review your matched and unmatched service items. Cycle through menus using the left-side column or by clicking Next.
- Please note, Unmatchedservice items will not sync. To fix any unmatched service items, you will need to ensure that service items in Canopy match the name, rate, and SKU of a service item in QBO.
- Once you have confirmed that the service items are matched, you will need to repeat the the QBO sync process.
4. Once all necessary service items match, click Sync service items.
5. Click Finish.
- All Service Items and Invoices will be synced between Canopy and QBO.
- Going forward, any new Service Items or Invoices created in Canopy will be automatically synced to QBO.
Sync Unmatched Contacts with QBO
Any Canopy contacts that do not match a contact in QBO will not be synced to QBO. In order to sync these contacts to QBO, you will have to export your Canopy contacts, upload them to QBO, and re-do the QBO connection process. To get started, navigate to your Contact List in Canopy.
Roles/Permissions:
- Roles: Admin
- Permissions: Manage Integrations
1. Click on the Options menu in the top-right corner.
2. Select Export Active Contacts from the drop-down menu.
- Your contacts will be downloaded to a .CSV document.
3. Login to your QBO Accountant account on the QuickBooks website.
4. Click on the Settings wheel.
5. Choose Import Data from the Tools column.
6. Select Customers.
7. Click Browse in the Select a CSV box.
8. Select the CSV file downloaded in step 2.
9. Click Next in the bottom-right corner.
10. Map the QBO fields to the fields in your CSV file.
11. Click Next in the bottom-right corner.
12. Ensure that each contact you wish to upload is checked.
13. Click Import in the bottom-right corner.
