Search our Help.

Quickbooks Integration Setup

Follow

How to Connect to QuickBooks video tutorial

The integration setup

It is important that you perform your integration configuration in the following order;

  1. Access the Integration page.
  2. Go to the Overview page and install QuickBooks, if you have not already done so.
  3. A pop-up message will appear notifying you of an import routine that will be automatically started to bring your settings from QuickBooks into Unleashed. You can check its progress in the notification tray in the upper right corner of the screen. 
    image (1)(2).png
  4. Please ensure you refresh your session to see your settings in effect. In the Configuration tab, you can toggle your individual settings such as customer and supplier mappings and what journals should be exported to QuickBooks and remember to save your configuration.
  5. Go to the Manage your Data tab and import or re-import your customers, suppliers and products (without updating the existing ones) and re-import taxes and chart of accounts (updating the existing ones, or removing records in Unleashed, if they were removed in QuickBooks).
  6. Review Connection Log, if required.

Accessing the integration page

You can access the integration store via the Integration | Integration Store menu.

  1. From the Integration Store page, you can setup and configure your integration.
  2. By hovering your mouse over the QuickBooks icon, a Configure button pops up.
  3. Click Configure to start the integration configuration. The QuickBooks Overview page will then appear.
  4. From this page, you can learn all about the QuickBooks integration, and the inline-help will guide you through the integration process.

QuickBooks overview tab

The QuickBooks overview tab describes:

  • what the QuickBooks application is, and
  • what happens when QuickBooks is integrated with Unleashed.

The aim is to ensure users have all the available information to ensure a seamless integration.

Install the application

If you have not installed the application, click on the Install App button available on this page. It will guide you through installing a QuickBooks account.

Actions you can perform

From this page,

  • users can turn the integration sync on or off by using the switch on the top right, and
  • select the More Apps button to go back to the configuration page at the top of the page.

QuickBooks Configuration tab

Activating the configuration settings

  1. Click the configuration settings to the right of the screen to activate the setting.
  2. When you are happy with your configuration settings, press Save configuration.

Link your QuickBooks accounts to Unleashed

Cost of Goods Account: The Cost of Goods Sold Account selection should be your cost of goods sold account in your QuickBooks Sales and Expense. All shipment journals sent to QuickBooks will be coded to Cost of Goods account and the Stock on Hand account.

Stock On Hand Account: The Stock On Hand Account selection should be your stock on hand account in your QuickBooks Current Assets. All purchases and journals sent from Unleashed will be coded to this account.

All the configuration settings should be checked to enable each interface to flow real-time to QuickBooks (you can un-check them if that information is not needed). After you have imported your stock, you must have the Stock On Hand amount in QuickBooks equal to the Stock On Hand value in Unleashed. Ensure you have this fully implemented before you start performing transactions in Unleashed. The final tax amount will be shown in Unleashed when it is exported to QuickBooks.

Sync your QuickBooks taxes to Unleashed

This section allows you to setup your QuickBooks taxes; taxes in QuickBooks need to be mapped to taxes in Unleashed. The easiest way to do this is automatically or you can do it manually by using the tax drop-down menus.

AUTO SYNC TAX CODES: You have the option to automatically sync tax codes. 

Let me manually do this: When this link is selected, it takes you to the Taxes setup page in Unleashed, where you can have more control on your tax settings.

What exports to QuickBooks?

Export Sales: When selected, all your sales (only the completed ones after the connection to QuickBooks was made) are exported to QuickBooks.

Include Header Comments - this will include any Comment added to the Sales Order

Include Line Comments - this will include any line comments added to the Order Line of the Sales Order.

The Map Customer Reference to Quickbooks Custom Field (Optional) allows you to sync the 'Customer Reference' in Quickbooks with the fields in the dropdown. If you choose to use this, you first need to create the relevant custom field in your Quickbooks account and then trigger the 'Import Sales Custom Fields' from the Manage your Data tab for the required fields to populate.

Export purchase: When selected, all your purchases (only the completed ones after the connection to QuickBooks was made) are exported to QuickBooks . 

Include Header Comments - this will include any Comment added to the Purchase Order

Include Line Comments - this will include any line comments added to the Order Line of the Purchase Order.

Export supplier return: When selected, all your supplier returns from the beginning of time are exported to QuickBooks. 
Export credit: When selected, all your credits (only the completed ones after the connection to QuickBooks was made) are exported to QuickBooks. 
Export customers: When selected, all your sales customers from the beginning of time are exported to QuickBooks. The Display Name attribute in QuickBooks must be unique for all customers. 

Customers Parent accounts and sub-accounts: You may have set up Parent and Sub accounts for your customers in your Quickbooks; Unleashed will treat these as separate individual accounts they sync to. If you have the "Bill parent customer" option ticked, the journals will be sent over to the Parent Customer account. Screen_Shot_2022-10-21_at_4.11.32_PM.png

Export suppliers: When selected, all suppliers (Suppliers, Supplier Returns) data is exported into QuickBooks in real time. The Display Name attribute in QuickBooks must be unique for all suppliers. 
Export credit journal: When selected, credit journal data (only the completed ones after the connection to QuickBooks was made) are exported to QuickBooks in real time.
Export adjustment journal: When selected, adjustment journal data (only the completed ones after the connection to QuickBooks was made) are exported to QuickBooks. 
Export shipment journal When selected, shipment journal data (only the completed ones after the connection to QuickBooks was made) are exported to QuickBooks in real time.

Manage your Data tab

Import all QuickBooks customers and suppliers in just one click

Import customers
When selected, this action copies any new Customer contacts from QuickBooks and imports them into your Unleashed account.
Import suppliers
When selected, this action copies any new Supplier contacts from QuickBooks and imports them into your Unleashed account.
Import products
When selected, this action copies any new Products from QuickBooks and imports them into your Unleashed account.
Import Taxes
When selected, this option synchronizes taxes from QuickBooks to Unleashed. All these taxes are combined to calculate effective tax rates. These effective tax rates are then applied to your transactions (which include; purchase orders, sales orders, customer credits and supplier returns) to calculate the tax amount. As those transactions export from Unleashed to QuickBooks, Unleashed breaks down the tax amount into the related tax rates.

Example
Tax is made into two different taxes: 

  1. 20% on Amount
  2. 5% on Amount + Tax

The effective tax rate is 26%

In Unleashed we apply 26% tax to transactions; for $100 the tax amount is $26.

When exported to QuickBooks, the tax is:

  • 20% on $100 = $20
  • 5%   on $120 = $6

Total tax: $26

When you click the Sync Now switch, be aware that sync times may take longer than expected. If syncing errors persist, contact Unleashed Support. 

Import Accounts
When selected, this option synchronizes chart of accounts from QuickBooks to Unleashed.

Export Data tab

The QuickBooks Export tab shows the status of items exported to QuickBooks.

Code: This search filter searches for specified transaction codes such as sales, purchase orders, journals or anything that has been exported. 
Types: You can filter the results for:

  • Assembly Costs
  • Credit Journals
  • Customer Credits
  • Customer
  • Purchases
  • Purchase Costs
  • Sales Invoices
  • Shipment Journals
  • Stock Adjustment Journals
  • Stock Take Journals
  • Suppliers
  • Supplier Returns
  • Supplier Return Journals
  • Supplier Return Costs

Exports: This drop-down menu option is a filter used to select what export status you want to display on grid.

Header data display

Total Count: Displays the total number of exports.
Total Balance: Displays the total balance of the exports that have been exported, the amount displayed are in base currency.
Total Variance: Displays the difference (variance) between the total balance and the exported total. It is the difference between what has been exported from Unleashed and received from QuickBooks.
Variance Count: Displays the value of the variance in base currency.
Exported Total: Displays the total that has been exported.

Column Descriptions

Tick box: When a tick box or all tick boxes are selected, the Batch actions menu appears. From this menu, you can select Ignore or Re-export.
Type: Displays the different export types.
Code: Displays the code for the specified export. You can click on the hyperlink available to view in detail.
Exported date: Displays the date of the specified export was exported.
Total: Displays the total cost amount in base currency. 
Exported Total: This displays the total amount received from QuickBooks. 
Variance: This is the difference between the total and exported total.
Message: Displays if the specified export has been successful. Smiley face for successful, sad face for unsuccessful.
Status: Displays the outcome of the export, was it successful (happy)or unsuccessful (sad face).
Actions (...): Column that contains the following action options that you can perform at line level;

  • Ignore: Provides you with the option of hide line items from the grid. You can only see ignore ones if you filter the export grid.
  • Re-export: If selected, it will automate the action to re-export the specified line.

Filtering your exports

  1. Select the filters from the top of the page that you want to apply.
    This includes:
  • Date From: It allows you to select the date you want to filter your exports from.
  • Date To: It allows you to select the date you want to filter your exports to. 
  • Type: This filter is used to select what type of export data you want filtered. For example, if you want to see all the exported Credit Journals.
  • Exports: Filter used to select what export status you want to display on grid filtered. For example, you want to see all of the export statuses so you select All Exports.
  1. After you have set your filter requirements, the Export data page displays the set data according to your settings.

Resending your exports

On this page you can resend exports (both failed and successful exports) either;

  • individually, or
  • in bulk (batch)

How to resend individual exports

  1. Select the export line you want to re-export
  2. From the actions selector, select Re-export.

How to resend batch exports

You can easily batch send your exports. To do so,

  1. Multi-select the select column to select all available export lines.
  2. From the Batch actions selector,  select Re-export.

Populate Missing Exports

 You can use the 'Populate missing exports' button in the bottom left of the Export Data page to reconcile and display any missing exports that may not show on the Outstanding or Failed exports list due to a previous unknown outage or a disconnection. 

Was this article helpful?
0 out of 0 found this helpful