How to Sync Magento 2 to QuickBooks

You can connect Magento 2 with QuickBooks using tools like Zapier and Automate and extensions like QuickBooks Online Integration.

The benefit of using Zapier is that it automatically syncs Magento 2 to QuickBooks every 1 to 15 minutes based on your plan. You don’t have to set up auto-sync separately to manage your accounting data.

This article will show you how to integrate QuickBooks with Magento using Zapier to automate recurring tasks.

Note: You’ll need accounts with Zapier and Quickbooks to sync Magento 2 to Quickbooks.

Sync Magento 2 to Quickbooks using Zapier

Generate a Zap

  1. Log in to your Zapier account and click the orange Create Zap button.

    Zapier Dashboard
    Click Create a Zap

  2. Name the Zap on the top left by clicking on the Edit icon.

    Edit Icon
    Click the Edit Icon

Create a Trigger Event

  1. Set up the following fields in the “Choose app & event” section:
    App event: Add Magento 2.x (Premium) from the search box to kick off the automation process.
    Event: Select a “trigger” event to start a zap. The event can be a new product, customer, order, sales order credit memo, sales order credit invoice, or sales order shipment.
    Click Continue to proceed.

    Choose app & event
    Configure the Choose app & event section

  2. Click Sign in to allow Zapier to connect to your Magento 2.x account in the “Choose Account” section. Enter the entire domain, admin username, password, and store code of your Magento store. Click Continue to go to the next section.

    Choose account
    Configure the Choose account section

  3. Next, in the “Test Trigger” section, click Test Trigger to verify if your Magento store is connected to Zapier correctly. Click Continue upon success.

    Test Trigger
    Test Trigger and click Continue

Create an Action Event

  1. Set up the following in the “Choose app & event” section:
    App event: Add QuickBooks Online from the search box.
    Event: Select one of the twenty-seven action events. An “action” is an event that a Zap performs when the trigger event occurs.
    Click Continue to proceed.

    Choose app & event
    Choose app & event and click Continue

  2. Click Sign in to allow Zapier to connect to your QuickBooks account in the “Choose Account” section. Once you’ve signed into the account, click Allow to let Zapier access your account. Click Continue to proceed.

    Choose account
    Sign in to QuickBooks account

  3. Select appropriate options in the fields in the “Set up action” section. The fields displayed depend on the trigger event. Click Continue.

    Set up action section
    Configure the Set up action section

  4. Click on Test action to check if the integration between the two applications is working correctly. You may choose to skip the test by clicking on Skip test.

    Test Trigger section
    Click Test & continue or Skip test

  5. Click Publish Zap to create a zap.

    Publish Zap
    Click Publish Zap

You’ve now successfully connected Magento 2 with QuickBooks using Zapier. You can read examples of how to automate tasks with QuickBooks here.

Liam is a marketing specialist at StartMarketing.net. Based in Dubai, he graduated from Trinity College Dublin in 2020 with a degree in Computer Science (Intelligent Systems). He has since 2021 worked for Google as a Sales and Marketing specialist, within their Dublin headquarters. Liam has over 4 years of experience in e-commerce sales, digital marketing and branding.

Leave a Comment