Quickbooks Desktop Connector for Magento 2

• The admin can synchronize the Magento 2 store Orders and invoice to the QuickBooks Desktop.
• Select when to create Sales Receipt in Quickbooks – Order Place, Invoice Create, or Order Complete.
• The admin can configure the time period for Quickbooks Scheduler.
• Sync customers who have placed the orders.
• Sync the product for which the orders have been placed.
• The sync payment method used in placing the order and their details.
• Sync Guest user orders from Magento 2 to Quickbooks Desktop.
• The order invoice is exported to QB for the selected payment methods.
• The customers are created with their name instead of email.
• Magento Order id will be added in MEMO of QB Order.
• Sync shipping options used in placing the order and their details.
• Sync the tax rates, Magento Order Id, and also the custom options in the sales order receipt.
• The admin can export Magento Orders according to the date range.
• The payment information is synced with the sales receipt.
• Customer type and customer address sync with the customer on Quickbooks.
• Tax information is exported to QuickBooks with the sales receipts.

Customers will get a zip folder and they have to extract the contents of this zip folder on their system. The extracted folder has an src folder, inside the src folder you have the app folder. You need to transfer this app folder into the Magento2 root directory on the server as shown below.

After the successful installation, you have to run these commands in the Magento 2 root directory.

First command- composer require consolibyte/quickbooks

Second command- php bin/magento setup:upgrade

Third Command – php bin/magento setup:di:compile

Fourth Command – php bin/magento setup:static-content:deploy

After running these commands, you have to flush the cache from the Magento admin panel by navigating through->System->Cache management as shown below.

The admin can configure the module settings. For this, the admin will navigate to Stores -> Configuration -> Quickbooks Desktop Connect as per the below image.

Here, the admin will –

GENERAL THINGS:

• Enable: Set the status of the module as Enable or Disable as per the requirement.
• Sales Receipt create on Quickbook: Set the order state as per which you want to create the Sales Receipt on Quickbooks automatically. Here the admin has three choices to pick up as per the choice-

               Order Place: As Sales order on QB.

              Invoice Create:  As Invoice on QB.

             Order Complete: As sales receipt in QB.

• Invoice Create On QB: The admin can select Yes to export an invoice automatically on QuickBook else select NO. If selected yes, then the admin will also have to select the payment method for the order invoice.
• Payment method for order invoice: Now, when a customer will pay using the selected payment method (those payment methods which are selected by the admin previously from the multi-select options) then the invoice will generate automatically for the selected payment method.
   Invoice of the order will create on QB which order placed using selected payment methods and when invoice of those orders will create on Magento.

• User: Enter the QuickBooks Web connector User Name (you can enter a username as per your requirement).
• Password: Set the QuickBooks Web Connector Password(you can enter a password as per your requirement and the same will be used for the app validation).
• Quickbooks Scheduler: Enter the time duration for the web connector scheduler in one minute. This will automatically fetch the data in the Quickbooks after every time interval the admin has configured.
• Do you charge sales tax: Here, the admin can select Yes if the admin charges the tax on sales else select NO. Therefore, to enable the functioning to charge sales tax, the admin requires to enable the same on Quick Books Desktop.
• Support Page: Enter the support page for Quickbooks Web Connector.

**Note: After filling up all the information under the “General Settings” section, the admin needs to save the configuration first and then click on the “Download QWC File” button to get the QWC file.

Export Product Field –

• QB Product Name: The admin can select the QB Product Name from the drop-down menu as “Store Product SKU” or “Store Product Name”
• QB Product Description: The admin can select the QB Product Description from the drop-down menu as “Store Product Name”, “Store Product Description”, or “Store Product Short Description.”

ACCOUNTS:

• Income Account: This account is for maintaining the record of the income in the Quickbooks and lets the admin track the business income more conveniently. The selected income account will also reflect on product information in QuickBooks.
• Asset Account: This account is for maintaining the record of all the products created in Quickbooks. The selected asset account will also reflect product information in QuickBooks.
• Expense Account: This account is for maintaining the record of all the expenses in Quickbooks. The selected expense account will also reflect product information in QuickBooks.
• Discount Account: This account in the Quickbooks is for maintaining the record of the discounts applied to the item sold.
• Shipping Account: This account in the Quickbooks is for maintaining the record of the shipment cost of the item involved.
• Tax Vendor Account: This account in Quickbooks is for maintaining the record of sales tax calculation.

**Note: Initially these accounts will get auto-configured after the first order placed in your online store. However, if you have created the respective accounts in the Quickbooks then, you can even change these accounts as per the need.

Please follow the below-mentioned steps to create a Quickbooks Web Connector app:

Step 1: After filling up all the information under the “General Settings” section, the admin first needs to save the configuration and then click on the “Download QWC File” button to download a wbc.qwc file on the system.

Step 2: Now, open the QuickBooks Web Connector on your system and click the Add an Application button.

Step 3: Clicking the Add an Application button will bring up a section to browse for the wbc.qwc file. Browse the file and select it. After that you will be prompted for the access permissions, allow them to create your application. After that, you will be able to see your created application.

Step 4: After selecting the wbc.qwc  file you need to give certain permissions. The pop-up that comes up click on Ok.

Step 5: After the above step, it will display another pop-up and ask for authorization for which you can check the options as per the requirement. If you select –

• No – this will not sync the data.
• Yes, Prompt each time – this will prompt you each time you request for data sync.
• Yes, whenever this QuickBooks company file is open – this will sync the data only when your company file is open.
• Yes, always; allow access even if QuickBooks is not running – this will sync the data even when your company file is not open.

Once you have selected the option hit the Continue button.

Step 6: Lastly, you will see the Access Confirmation pop-up box. Here, click the Done button as shown below in the snapshot.

Step 7: After you have created the application for the first time you will have to update the created app. To update, select the checkbox for the app and enter the password that you have set above for the QuickBooks Web connector Password in the module config settings under the admin panel and then click the Update Selected button.

**Note: For Updating the app at regular intervals, you can also keep the column Auto-Run checkbox marked and set the interval at which the app should get auto-updated.

Sales Tax Enabling in Quick Books Desktop

Therefore, to enable the functioning to charge sales tax on the Magento 2 store, the admin requires to enable the same on Quick Books Desktop. 

Firstly, the admin has to go to the menu bar, then click on Vendors->Sales Tax-> Manage Sales Tax.

After clicking on Manage Sales Tax, the admin will be redirected to the next page.

Here, the admin needs to click on Sales Tax Preferences, a pop-up window appears.

Now, the admin requires to set the Do you charge sales tax? as “Yes”.

The admin can also set pay sales tax preference on a Monthly, Quarterly, and Annually basis.

After all the changes are done as per the choice, the admin requires to save them by clicking on the OK button.

After the successful installation of the extension, the admin will have the QuickBooks Desktop Connect menu in the left menu bar with  Map Orders Sales Receipt, Map Orders, Map Invoice, Map Credit Memo, Customer Map List and Configuration sub-menu as shown in the image below –

Map Orders Sales Receipt: 

Here, the admin can manage all the orders sales receipt.

The admin can also manually add the Magento store orders to the Queue. For this, the admin will click on the “Add Orders in QuickBooks Queue for Export” button. Now the admin can select the order status which the admin wants to export and select the date range of the order and then click on the Export Order From Store To Quickbooks.

Now it will display the message about the products that will be exported as shown in the image below –

This will export the orders to the QuickBooks queue from your Magento store. And will be created in QuickBooks when you connect your QuickBooks with a web connector application.

Map Orders: 
Under this section, the admin can view all the synchronized orders from the Magento store to the Quickbooks.

The admin can vew order details by clicking view order under  Actions.

SYNC STATUS:

• In Queue – This status signifies that the Magento order is not synced with the Quickbooks desktop. These orders will be created in QuickBooks when you connect your QuickBooks with web connector application.
• Successfully – This status signifies that the Magento order is synced with the Quickbooks desktop.
• Error – In case an error occurred while synchronizing the data, the admin will see ‘Error’ Sync Status. The admin can also try to re-sync the orders for which error occurred.
  To re-sync the order, the admin needs to select that order and click on the re-export option from the action dropdown.  

Map Invoice –

The admin can click on the “Map Invoice” sub-menu under the Quickbooks Desktop Connect to view the synchronized invoices from the Magento store to the QuickBooks.

Moreover the admin can select an invoice and re-export invoice when error is displayed in the sync status by clicking on the Action button and then click on the Re-Export Invoice also the admin can Delete the Invoice Map Record.

Map Credit Memo

Here, the admin can view created credit memo.

To view the credit memo, the admin requires to click on the view, under the Action section.

Here, the admin can see order memo details, also can add comments to the order.

Customer Map List

Here, the admin can view mapped customer’s record, also the admin can delete customer map record by selecting the particular record and then click Delete Customer Map Record, under the Action tab.