Tax Fees and Liability Accounts

The QuickBooks Online integration from PowerSync supports native Magento tax processes and configuration. In addition we are happy to say we also support AvaTax Magento integration. This document covers various ways for you to configure the integration.

Basic Setup

If you would like to capture taxes in QuickBooks Online in the simplest from, all you have to do is to follow these steps and set a few default values in Magento configuration. The configuration section is located in Stores > Configuration > TNW QuickBooks > Orders Taxes (section)

1. Tax Rates from Magento will automatically synchronize with QuickBooks Online if you enable "Auto Sync Taxes" feature.
2. "Default Tax Code" will show you a list Tax Rates defined in your QuickBooks Online
3. "Default Tax Agencies" will give you a list of all Tax Agencies you have available in your QuickBooks Online.

NOTE: these settings are the default settings Magento will use if no other rules are applied. Think of this is a catch-all rule for all taxes fees coming from Magento.

Advanced Setup

(assumes the Basic Setup is completed)

There are many Tax Agencies all over United States. You may need to think about being able to report fees collected. We have a flexible configuration allowing you to "link" a Tax Agency from QuickBooks back to all orders captured for an entire country, a state or a Province, and even a city. Example below will show you how to configure Magento to be able to capture all tax fees collected in Arizona State under the "Department of Revenue" tax agency. NOTE: this is just an example and the name of the Tax Agency or a Liability Account might be different.

1. QuickBooks Online
   1. Navigate to "Taxes" tab on the left side
      
   2. On the right hand side you will see a small list of links. Click on "Add/edit tax rates and agencies"
   3. You will see the list of all Tax Rates you have configured.
   4. Click on "New" button to add "Arizona"
   5. Enter Tax Name, Agency Name, and Tax Rate
      
   6. Click on "Save"
2. Magento Admin Panel
   1. Under Stores > Taxes (section), you will notice a new menu item: QuickBooks Tax Agencies Mapper
      
      
   2. You will see a page list all tax rules for QuickBooks Online
   3. Click on Add New Mapping
      
      
   4. Fill our the form per the screenshot below
      
      
      1. Country: United States
      2. Region: Arizona
      3. City - leave blank (for this example)
      4. Tax Agency - you will see Department of Revenue (this is the Tax Agency we just created in the previous step in QuickBooks Online)
   5. Click Save
      

Related articles