Sync Atera With QuickBooks Online

Sync Atera with QuickBooks Online to export invoices that your accounting software recognizes. Our sync wizard gets taxes, products and customers aligned between Atera and QuickBooks Online, ensuring a seamless and smooth billing experience. Additionally, you can continue to manage any future sync ups via Atera's Accounting management page. 

This article describes how to:

• Use the Sync Wizard
• Manage your QuickBooks Online Integration
• Export Invoices to QuickBooks Online
• Disconnect from QuickBooks Online

Use the Sync Wizard

The sync wizard gets taxes, products and customers aligned between Atera and QuickBooks Online. After completing the wizard, taxes, products, and customers in Atera will be handled a bit differently. These are the changes, detailed by category:

Taxes

• Will only be created and edited in QuickBooks Online (so as to avoid duplicate/conflicting taxation on invoices).
• Your Atera invoices will be exported without taxes (for the above-mentioned reason).
• Taxes will automatically be added to your invoices in QuickBooks Online.

Products (and Rates/Services)

• We will replace Atera products and rates with those in QuickBooks Online (so as to avoid duplicate/conflicting items). 
• Going forward, products and rates (services) will only be created and edited in QuickBooks Online.

Customers

• Atera customers will have a matching customer in QuickBooks Online.
• You’ll be able to import your QuickBooks Online customers, who aren’t matched in Atera, so that invoices exported to QuickBooks Online will be recognized.

To sync Atera with QuickBooks Online:

1. From Admin (on the side panel), click Accounting.

The Accounting page appears.

2. In the Accounting Software Integration tab, click Connect, under the QuickBooks logo.

The QuickBooks login page appears.

3. Enter your QuickBooks Online credentials, and click Sign In.

 The Connecting to Atera page appears.

4. Click Connect.

The sync wizard welcome screen appears.

5. After reading through the wizard welcome page, click Next.

The Match products step appears.

6. Match products: In this step, Atera will automatically find 'exact match' product (and rate/service) matches between Atera and QuickBooks Online. You will need to manually match the unmatched Atera items by selecting them from the QuickBooks Product/Service dropdown menu. If an appropriate match doesn't exist, click the icon to create it in QuickBooks Online. When done, click Next.

 Notes:

• Upon completion of the wizard, unmatched Atera products and rates will no longer appear in Atera.
• Products and rates will appear in QuickBooks Online with the same Atera pricing.
• There is a limit of 8000 products that can be synced between Atera and Quickbooks Online.

7. Match customers: In this step, Atera and QuickBooks Online customers are matched up. Atera will automatically find 'exact match' customers between Atera and QuickBooks. You will need to manually match the unmatched customers by selecting them from the dropdown menus. If an appropriate match doesn't exist, click the icon to create the customer in QuickBooks Online. When done, click Next.

8. Import customers: This final step enables you to import any QuickBooks Online customers, who aren't matched or don't yet exist in Atera. After making your selection(s), click Next.

9. The Summary: After reviewing, click Done.

Note: Clicking Done saves all selections and changes made in the previous steps. Failure to click done will result in your selections not being saved.

A confirmation screen appears confirming a successful Atera and QuickBooks Online sync.

Notes:

• Products and rates - When accessing a contract as well as the 'Time Entries' and 'Products and Expenses' within tickets (in Atera), you will be able to see and choose from your list of QuickBooks Online products and rates (services).
• Taxes - Anything having to do with taxes within Atera will be grayed out, as long as you are integrated with QuickBooks Online.  Should you choose to disconnect the integration, the tax features will again be useable.

Manage your QuickBooks Online Integration

You can manage your integration and sync-ups at any time on the Accounting management page (after having completed the wizard).

To manage your integration:

1. From Admin (on the side panel), click Accounting.

The Accounting management page appears.

Note: This page only appears if, at some point, you had completed the sync wizard. Otherwise, you will be prompted to do so.

You can manage all aspects of the Atera and QuickBooks Online sync, exactly as found in the wizard. This includes management of taxes, products (and rates/services), customer matching, and importing.

Export Invoices to QuickBooks Online

You can export Atera invoices to QuickBooks Online.

To export invoices: 

1. From Billing on the side panel, click on (or create) the Invoice Batch you wish to export.

2. Click Export.

Notes:

• When exporting invoices to QuickBooks Online, you will be prompted to match any unmatched Atera and QuickBooks customers, to ensure invoice recognition. You can also check 'Create' to have the new customer created in QuickBooks if the appropriate customer doesn't already exist.

• When exporting invoices with products/rates that don't exist in QuickBooks Online, the products/rates will automatically be created in QuickBooks Online, and will appear with the same pricing as in Atera.
• We've added a default 0% product/service tax rate, when 'non-taxable' is specified on QuickBooks Online, to enable smooth integration with QuickBooks Online International, which requires entry of a product/service tax rate.
• Changes made to invoices from Quickbooks will not reflect on invoices you see in Atera. 

When viewing an exported invoice, on Atera's Billing page, you can link directly to the invoice in QuickBooks Online.

Disconnect from QuickBooks Online

If you wish to discontinue your integration with QuickBooks Online, you can do so at any time. 

To disconnect:

1. From Admin (on the side panel), click Accounting to access the Accounting management page.

2. Scroll to the bottom of the page and click Disconnect from QuickBooks Online.

After confirming, Atera will disconnect from QuickBooks Online.