QuickBooks 3PL Integration

Integration Summary 

• Exports 3PL Invoices to Sage One Business Cloud with ledger mapping

Settings Changes

Please go to Settings > Customer Account Settings and change Accounting integration type to Quickbooks:

https://om.mintsoft.co.uk/Settings/CustomerAccountSettings

Setup Connection

Navigate to Connect > Accounting > Quickbooks

Add a new account and leave all fields blank except delay - please enter a value here of 15.

You'll also need to set the type of account Fulfilment Accounting:

Once the account is created - hit the connect button:

Please Note: In order to Connect to QuickBooks, you must be using the https://om.mintsoft.co.uk URL. This will not work when using a custom portal.

Then login & connect to Quickbooks:

Then you will receive a success message advising the API key has been successfully updated:

Set Default Income Account

Once the connection has successfully authorised - edit the connection in Mintsoft and check the default income account is correct for your sales (sales will get posted here if we do not find an item code already setup)

Then hit save

3PL Invoice - Account Mapping

It is imperative that you complete Ledger Mapping in order for 3PL invoices to be created in Quickbooks for all invoice item type groups.

Please click on the Account Mappings to proceed with configuring the Mappings:

To configure the mappings, please map the AccountCodeType in Mintsoft to the relevant Quick Books income account:

Once completed, there should be a mapping for each AccountCodeType.

A completed example can be seen below:

You must also ensure that any ledger accounts you have mapped to have got a VAT rate set in your chart of accounts on Quick Books

Om QuickBooks go to Accounting > Chart of Accounts

Then edit any accounts being used and make sure they have a specified VAT rate:

3PL Invoice - Configuring Clients / Customers

In order to Create an Invoice in QuickBooks, we must be able to identify which QuickBooks Customer is mapped to which Mintsoft Client.

This can be done by ensuring the Client Name on Mintsoft,matches the Display Name of the Customer on QuickBooks.

In this example, the client on Mintsoft is called "Josh Client"; the corresponding Customer on QuickBooks must therefore be called Josh Client in the Display Name As field.

To check or create a new customer - on Quick Books go to Invoicing > Customers

If the names do not match you will receive an error when trying to create invoice:

3PL Invoice

Once you have confirmed your 3PL Invoice on Mintsoft - hit the create invoice in accounting integration button: