QuickBooks Settings

After you have connected erplain with QuickBooks Online, you need to do a quick set up of the integration.  Go to Menu 'Apps' and click on the 'Configure QuickBooks Online' button:


The settings are divided into the following categories, simply click on each section to make your choices:


Locations

erplain allows you to manage products in multiple stock locations. When syncing the inventory from erplain to QuickBooks, we will count the total of your inventory across all stock locations. When an inventory adjustment is coming from QuickBooks, erplain will adjust the inventory only in this default stock location:

In case you have set up locations in QuickBooks for reporting purposes, you can map your erplain locations with QuickBooks from the Location tab:


When saving an Invoice or a Purchase order, erplain will send the location name to QuickBooks. There is no synchronization of QuickBooks locations to erplain.


Products

- Price Sync

erplain supports multiple price levels, such as Wholesale price and Recommended Retail price. Select which price level you would like to sync with QuickBooks:


- Products sync

For Importing, exporting and mapping your products with QuickBooks Online, please refer to this page.


Customers & Suppliers Import and Sync

You can import your Customers and Suppliers from QuickBooks to erplain by clicking on the button below.

Also, every time you send an Invoice or a Purchase Order from erplain to QuickBooks, the customer or the supplier will be created in QuickBooks automatically if it not already synchronized. Once the sync is done for a customer or a supplier, every change made on one side will automatically sync to the other side.


Ledger accounts mapping

Map your QuickBooks ledger accounts to erplain. We have assigned default accounts when possible. Please check each one:


For product accounts (Income, Expense and Asset) they will only be used when erplain creates a product in QuickBooks. 

You can also edit each product's account directly in the product profile (or in QuickBooks directly)


You can find more information about the Ledger Accounts mapping on this page.


Taxes sync / mapping

You can automatically create a new tax on erplain from the existing taxes in your QuickBooks account. Note that if you create a tax that is a group of multiple taxes, it will automatically create the corresponding sub-taxes.


If you have existing taxes on both systems, you can map them together. This is required to send Invoices and Purchases orders to QuickBooks.

In the left column, we listed all the taxes created from erplain and in the right column, the list of taxes from your QuickBooks account. You need to map the tax code from QuickBooks. Simply select the desired accounts to map your taxes between erplain and QuickBooks:


Payment methods

You can map your erplain payment methods with your QuickBooks payment methods and accounts (on top of the ledger account mapping). Please find more information in the article Payments sync and Payment method mapping.


Documents sync

You can control when to send your erplain transactions (Invoice and Purchase Orders) to QuickBooks. By enabling the option below, your Invoices and Purchase orders will be sent automatically to QuickBooks. If this is disabled, you will see a "Send to QuickBooks" in the transactions.


Selecting the Sync start date is optional. This is only used if you have been using erplain and creating transactions before connecting to QuickBooks.


Custom fields

This option will only be displayed if you have created custom fields in QuickBooks.

- Account Manager Sync

If you have created a custom field in QuickBooks for your sales team (Account managers, Account reps,...), you can map it to erplain's Account Representative field.

- External Reference Sync

If you have created a custom field in QuickBooks for your Purchase Order numbers (for example), you can map it to erplain's External Reference field.

- Sales Order number Sync

You can include the erplain Sales order number in your QuickBooks invoices. Make sure to add a custom field in QuickBooks for the sales order number.


In QuickBooks Online, you can create a custom field by going in 'Settings' > 'Sales':

Connection

In this tab, you can disconnect erplain from your QuickBooks account. 

IMPORTANT - Connecting Erplain to a new QuickBooks account

Disconnecting your Erplain account from QuickBooks to connect to a new QuickBooks account is not supported. We recommend that you either:

1. Open a new Erplain account for the new QuickBooks account or

2. Delete all the data in your account before connecting Erplain to a new QuickBooks account.

Once you connect erplain to QuickBooks, your products are linked, your invoices are linked and your customers are linked. You would experience many inventory issues by connecting to a new QuickBooks account.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.