Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Thank you for purchasing my our extension. If you have any questions that are beyond the scope of this help fileguide, please feel free to send us an email via my the user page contact form here. Thanks so much!. Thank you.

Created: 30/07/2017 | By: Magenest | Email: [email protected].         

Table of Contents

Support portal: http://servicedesk.izysync.com/servicedesk/customer/portal/33

Table of Contents
outlinetrue
stylenone

 

...

Introduction

Image Removed

Quickbooks Desktop Integration extension for magento Magento 2 Quickbooks Desktop Integration for Magento 2 is a powerful tool which allows automatically synchronize and update accounting data from Magento 2 to Quickbooks Desktop.

 

Please view more detail here: Quickbooks Desktop Integration

Hot Features 

  • Allows synchronizing and updating Customers from Magento 2 store to Quickbooks Desktop Items.
  • Allows synchronizing and updating Products from Magento 2 store to Quickbooks Desktop Customer.

  • Allows synchronizing and updating Orders from Magento 2 store to Quickbooks Desktop Sales Orders.

  • Allows synchronizing and updating Invoices Magento 2 store to Quickbooks Desktop Invoices.

  • Friendly user interface and easy usage.      

System Requirements

 

Your store should be running on Magento Edition version 2.0.0 and more.

Note that our Quickbooks Desktop Integration is compatible with all Quickbooks versions. 

You only need to choose the QuickBooks Web Connector which is compatible with your QuickBooks version and download them here.

 

Main Functions

  • Create and manage user 

We created a Quickbooks Desktop tab which allows admin to control all of things related Quickbooks Desktop Integration extension. 

 

Image Removed
Firstly, admins need to create a new user to start using this extension by navigating Stores > Manage User, click on Add New User button.             
Image Removed

 

Image Removed

 

Then, click on Save Information  button to save the entered information.

 

Image Removed

 

  • Set configuration 

After completing a new user, admins need to set configuration to integrate with QuickBooks. 

Go to Stores > Configuration > QuickBooks Desktop, there are two sections which are needed to set before using the extension.

Image Removed

(plus) Export QWC Files:

There are some sections that admins need to set before starting to use this extension. 

 

(minus) Option: There are two options to choose, include

  • Default: sync orders to real customers.
  • Customize: enable sync all orders to only one customer (except for the orders of wholesale customer).

In Customer Receive, type the CUSTOMER NAME of the customer above as in QuickBooks Desktop 

Note: You have to create this customer in QuickBooks Desktop first.

In Vendor Tax Agency Name, name of the vendor you want to create, this field is required in order to sync Tax.

Fill all the other fields, including: Base URL, User name, Scheduler and the 4 Account fields.

Then click Save Config to store all information.

 

 

Image Removed

(plus) Account Type Settings:

Image Removed

 

In order to know how to enter exactly 4 fields, include: 

(minus) Income Account

(minus) Expense Account

(minus) Assert Account

(minus) Cost of Goods Sold Account

--> Please open the QuickBooks Desktop software and go to Lists > Item List

Image Removed

Then, navigate to Item > New > Account and choose one of them to enter 4 fields above.

Image Removed

 

  • Query the Company admin are using in Quickbooks to Magento 2 

...

extension that helps merchants synchronize error-free data from your Magento 2 store to QuickBooks Desktop automatically in real-time. Merchants can transfer unlimited online transaction data at a glance.

Image Added

Main Features 

  • Connect to multiple QuickBooks company file
  • Synchronize customer data from Magento 2 to QuickBooks. Update Customer data when updating customer information from Magento 2.
  • Synchronize Guest data depend on Magento Order information to QuickBooks
  • Synchronize Payment method & Shipping method from Magento 2 to QuickBooks
  • Synchronize Product data to QuickBooks. Update Product data include updating stock when there is modification action from Magento 2.
  • Mapping Tax data between Magento 2 and QuickBooks
  • Synchronize Order data from Magento to QuickBooks with full information such as Shipping/Billing Address, order line items with tax/non-tax, Discount/Shipping amount
  • Synchronize Partial/Full Invoice and corresponding Receive Payment from Magento 2
  • Synchronize Partial/Full Credit memo data from Magento 2 with adjustment fee/adjustment refund

System Requirements

Your store needs to be running on Magento version 2.2.1x, 2.3.x, 2.4.x

Prerequisites

  • You have to use SSL for your website
  • Web connector application is required on the computer that installs QuickBooks with version 2.1.0.30 and older versions
  • Support QuickBooks version:
    • QuickBooks Enterprise Solutions
    • QuickBooks Premier (2002 or later)
    • QuickBooks Pro (2002 or later)
    • QuickBooks Simple Start (2006 or later)
    • Canadian editions of QuickBooks Pro, Premier, or Enterprise (2003 or later)
    • UK editions of QuickBooks Pro or Accountant Edition (2003 or later)
(minus) Please note: QuickBooks Web Connector 2.1.0.30 and older versions only support up to TLS 1.0


...

How to setup connection

First of all, you have to set up the connection between the Magento website and QuickBooks software through the Web connector application. Please follow the below steps:

Step 1: Create a user for QuickBooks Web Connector

(plus) In this step, you have to create a user account that will be used to establish a connection between Magento 2 and Web connector. You can create one by going to QuickBooks Desktop > Manage User, and click on Add New User.

Image Added

Image Added



(plus) Fill all the fields then click Save Information to save the entered information. The username and password will be used with QuickBooks Web Connector later on.


Image Added


(plus) At the end of this step, you have to set up the account for the connection by going to QuickBooks Desktop > Configuration > Connection Settings


Image Added




Step 2: Establish the connection

(plus) Please click on the “Query company” button to download the connection file to add to the Web connector application:



Image Added

(plus) While adding the application file, there are some pop-ups to request permission for this file:

Image Added

Image Added


Image Added

(plus) QuickBooks will then ask you how and when you'd like for QuickBooks to allow Web connector to access your company file. There are 4 options in the above image:

  • No: not allow read and modify, if you choose this option, it will not read or modify Quickbooks data, so cannot integrate data between 2 systems.
  • Yes, prompt each time: every time that you run the application, it will ask again
  • Yes, whenever this QuickBooks company file is open
  • Yes, always; allow access even if QuickBooks is not running


(plus) After adding the connection file to the Web connector application, run the application that has been added:

Image Added

(minus) Note: the password is the password of the user which be created in Step 1


(plus) Once the connection setup is done, you should see the following image:


Image Added

(minus) Note: You only need to establish a connection once for one company.



...

Mapping Tax


In this step, the module will map the existing taxes in both systems, therefore, you have to have the corresponding taxes in both Magento and QuickBooks.

When all taxes have been prepared, please do the following step to mapping them:

Step 1: Query Tax from QuickBooks

(plus) First of all, get query-tax.qwc file to add to Web connector:

Image Added


Image Added

(plus) After Update Selected, you will see all of the taxes that exist in QuickBooks in the Mapping Tax table. 

Image Added

Step 2: Mapping Taxes

(plus) QuickBooks Desktop -> Mapping -> Mapping Taxes, you will see a table which shows all of the taxes in both Magento and QuickBooks

You should set the mapping for the QuickBooks tax that corresponds to the Magento tax.

(plus) Finally, click the Apply button to save the Mapping.

Image Added


...

Synchronize Magento Data

Magento data will be synchronized into QuickBooks when all of them exist in the Queue table with Queue status.

Configuration

(plus) You have to set up some configuration before synchronizing Magento data into QuickBooks. Go to QuickBooks Desktop -> Configuration -> Synchronize Settings

Image Added


(plus) When you open each section, you may see the following settings:

  • Synchronization date from: set update which use to filter when you add object data to Queue by click the button in the Header of the Queue table (second way to add data to Queue table)
  • Auto insert id to customer name: Select Yes in case you want to add an ID to the customer name. To avoid customers synchronization failure because customers have the same name. 
  • Allow Sync Order: Select No if you don't want to sync orders.
  • Allow Sync Invoice: Select No if you don't want to sync invoices and receive payments.
  • Allow Sync Credit Memo: Select No if you don't want to sync credit memos.
  • Max records per Request: When you click Update Selected or Autorun is triggered in the Web connector, there will be a lot of requests sent to Magento to get data and import to QuickBooks. This field will set the number of items that will be imported into Quickbooks in each of these requests. By default, if you don't set a value for this configuration, it will process all records of one type for each request.
(minus) Please note that you shouldn’t set it up too large or leave it blank to avoid connection timeout errors.

Synchronize Product


Image Added

  • Income Account: Enter Income account name which use to create Inventory Item in QuickBooks
  • Other Income Account: Enter Income account name which use to create Other charge item in QuickBooks
  • Discount Income Account: Enter Income account name which use to create Discount item in QuickBooks
  • Account for Non-Inventory Item: Enter account name which use to create Non-Inventory item in QuickBooks
  • Cost of Goods Sold Account: Enter COGS account name which use to create Inventory item in QuickBooks
  • Asset Account: Enter Asset account name which use to create Inventory item in QuickBooks


(star) You can get these accounts by going to your company file. Then go to Lists > Chart of Accounts and you'll see a list of your existing accounts. If not, create new ones.

Image Added

Add data to Queue table

(plus) You can add Magento data to the Queue table in the following way:

  • Auto-add by trigger add/edit object. It means when you create a new customer or new Order or same that, it is automatically added into the Queue table.

 

  • Add a set of object data with date filter by clicking the button in the header of the Queue table

Image Added

  • Add specific object data by using Mass action:

Image Added

Synchronize Data to QuickBooks

Step 1: Download Synchronize Queue file

(plus) Go to QuickBooks Desktop -> Configuration -> Synchronize Settings, click the Synchronize from Magento button to download the sync-queue.qwc file

Image Added

Step 2: Run the file in the Web connector

(plus) Add the file that you downloaded in step 1 to the Web connector. Then you can update manually by Update Selected or use the Autorun function to get data from Magento to QuickBooks.


Image Added

(minus) Note:


  • Simple, Virtual, Giftcard, Downloadable, and child item of configurable products in Magento will create an inventory item in Quickbooks.
  • Other products such as Bundle products, Configurable products, Group products will create a non-inventory item without a list of child items. Only SKU, price, and description will be imported.
  • Only Support Inventory item and Non-inventory item when synchronizing Sales Order.
  • The order of the items that are processed while importing to Quickbooks are Shipping method, Payment method -> Customer/Guest -> Product -> Order -> Invoice -> Receive payment -> Credit memo.

          You have to make sure that all the information needed to create an order/invoice/receive payment/credit memo must be imported successfully before importing them into Quickbooks to avoid not-found error.

Queue table information

In default, the Queue table only shows the item that belongs to the current company. When you change to another company, you have to add data again.

Explain the columns function:

  • Entity ID: Magento entity id
  • Type: Magento entity type
  • Increment ID: The ID of Order, Invoice, Receive payment (is Invoice ID) and Credit memo
  • Action name: Add or Mod
  • Status:

- Queue: the records are ready to synchronize to Quickbooks.

- Synchronizing: the records are being processed by Web connector. 


Image Added


(minus) Note: Sometimes there are some errors while synchronizing, so the records are still in Synchronizing status although the Web connector already stopped. In this case, please submit ticket support for assistance.


- Fail: this record cannot synchronize. You should take care of Message error and follow the documentation How to fix some common errors while importing data to Quickbooks

- Success: the records are imported to Quickbooks successfully. 

- Blocked: these records will not be imported to Quickbooks. You can change these records to Blocked if you don’t want to import one to Quickbooks.

  • Enqueue DateTime: the date-time that this record was added
  • Dequeue DateTime: the date-time that this record was processed by the Web connector
  • Message error: when a record cannot be imported, Quickbooks will return an error message that shows why the error occurred. In this case, you should follow the document How to fix some common errors while importing data to Quickbooks. Then you have to correct the data of this record before synchronizing it again.
  • Action: You can quickly go to the Magento entity by clicking the View

...

Result

(tick)Sync customers from Magento 2 to QuickBooks 

Image Added


Image Added

(tick)Sync products from Magento 2 to QuickBooks

Image Added

Image Added


(tick)Sync Orders from Magento 2 store into QuickBooks Desktop Sales Order


Image Added

Image Added

(tick)Sync Invoices Magento 2 store into QuickBooks Desktop Open Invoices and Receive Payment.

Image Added

Image Added



Image Added


(tick)Sync Credit Memos Magento 2 store into QuickBooks Desktop Credit Memos


Image Added


Image Added

 (minus) Note: The QuickBooks Desktop Integration supports one-way synchronization only, so the admin should not edit the synced data in QuickBooks manually. This will affect the data update/synchronization.



...

Debug Setting

 

If you enable Debug mode, the error will write to a file. You should attach the debug file when submitting a request to help us investigate the issue quickly.


Image Added




...

Update

 

 Only do this step when admins use this extension for the first time or when admins want to change the company in the Quickbooks Desktop application 
Image Removed

(minus) At Select Type select field, admins choose Query Company then click Save Config

(minus) Click on Export QWC Config button and save the created Company QWC file.

(minus) Open the Quickbooks Web Connector software application. Then, admins need to click on Add an application button and choose the Company file above.

Then, admin have to open the Quickbooks Web Connector software application. Then, admins need to click on Add an application button and choose the Company file which are saved at the step above.

 

Image Removed

 

Admin will choose the checkbox and enter password which is set Configuration.

Click on Update Selected button to complete.

Image Removed

 

Note

 Note: If admin wants to use other Company in Quickbook Desktop application, create a company with different name first then query the company again with Quickbooks Web Connector.

 

  • Manage queue

After you query a company for first use, then you will need to add some fields to the Manage Queue table before starting to sync data from the Magento 2 to the QuickBooks Desktop software.

Go to Stores > Manage Queue to do that.

Image Removed

 

...

(minus) Sync Payment, Sync Shipping Methods, Sync Tax Rates: Admins will need to sync three fields before using this extension (must).

(minus) Sync Customers: If admins will need to sync this data if they want to sync the old customers.

(minus) Sync Products: If admins will need to sync this data if they want to sync the old customers.

(minus) Sync Orders: If admins want to sync the old orders, admins will need to sync these fields above before.

(minus) Sync Invoice: If admins want to sync the old invoices, they will need to sync orders before.

 

Image Removed

How to sync data from QuickBooks to Magento 2

Admin have to open the Quickbooks Web Connector software application. Then, admin need to click on Add an application button and choose the Default file which are saved at the previous step.                    

 

Image Removed

Admin will choose the checkbox and enter password which is set Configuration.

Click on Update Selected button to complete. 

Image Removed

 

  • Sync customer from Magento 2 to Quickbooks 

Image Removed

 

Image Removed

 

There are two ways to sync data from Magento 2 to QuickBooks Desktop, including:

-  Manual updating by clicking on Update Selected button.

-  Automatically updated by setting Scheduler

Thus, all of data about existing customers on Magento 2 will be automatically synced to QuickBooks desktop. 

 

  • Sync products from Magento 2 to Quickbooks   

T

Image Removed

 

Image Removed

 

 

 

 

  • Sync and  Orders from Magento 2 store into Quickbooks Desktop Sales Orders.

When there is an order created at Magento 2, it will be synced through QuickBooks Desktop. 

 

Image Removed

 

To view details this order at Quickbooks Desktop, admin only click on Sales Orders.   

 

Image Removed

 

  • Allows synchronizing and updating Invoices Magento 2 store into Quickbooks Desktop Invoices.

When there is an invoice created at Magento 2, it will be synced through QuickBooks Desktop. To view details this order, admin only click on Create Invoices.  

 

Image Removed

 

Image Removed

 

Update

  • When a bug fix or new feature is released, we will provide you with the module's new package.
  • All you need to do is repeating the above installing steps and uploading the package onto to your store. The code will automatically override.
  • Flush the configure cache. Your store and newly installed module should be working as expected.
 



Support

  • We will reply to support requests after within 2 business days.
  • We will offer lifetime free update and 6 months of free support for all of our paid products. Support includes answering questions related to our products, bug/error fixing to make sure our products fit well in on your site exactly like our demo.
  • Support DOES NOT include other series services such as customizing our products, installation, and uninstallation service.

...

...