MRPeasy & QuickBooks Online Integration

MRPeasy is a simple yet powerful Manufacturing ERP/MRP software that enables manufacturers to cut costs, improve processes, and increase revenue with no prior investment.

The software answers important questions:

  1. When can the order be fulfilled?
  2. How much will it cost?

When connecting MRPeasy and QuickBooks you will be able to send your outgoing and incoming invoices to your accountant with just one click.

Connect MRPeasy & QuickBooks for a complete business solution

  1. If you have an account in MRPeasy, please sign in. Otherwise please sign up for MRPeasy account.
  2. Connect MRPeasy with QB Online – go to MRPeasy -> Settings -> System settings -> Integrations, and click “Connect to QuickBooks”.
  3. Sign in QuickBooks account, and click to the “Connect” button.
  4. Select QuickBooks accounts, and “Save”.

Transcript:

In this video, we will cover the general principles of the MRPeasy and QuickBooks Online integration, as well as how to set up the connection.

In the case of MRPeasy and QuickBooks Online integration, the main principle is that business operations – procurement, inventory management, manufacturing and sales – should be performed in MRPeasy, and QuickBooks Online should be used for accounting purposes.

Generally, there are two ways how the integration can be configured.

First, it is possible to only synchronize purchases and sales. For example, when you create a purchase order and receive an invoice, or when you issue an invoice to the customer, it will be duplicated to QuickBooks.

For an in-depth integration, it is also possible to automatically send journal entries to QuickBooks with financial transactions regarding inventory and manufacturing that are managed in MRPeasy.

For example:

  • When materials are received, these will be counted to the “Materials on Hand” asset account
  • When materials are consumed in production, these will be carried to the “Work in Progress” asset account
  • When manufacturing is finished, MRPeasy calculates the cost of finished goods, clears the “Work in Progress” account, and accounts for the products on the “Finished Goods” asset account
  • When the products are sold, the cost of these is automatically credited from the “Finished Goods” account and debited to the “Cost of Goods Sold” expense account

You will find the full description of the transactions in the MRPeasy User Manual in the section about QuickBooks Online.

Before making the connection, we strongly recommend going through the full documentation and then testing it with demo accounts on both platforms.

Configuring the integration between MRPeasy and QuickBooks Online

To connect with QuickBooks Online, go to “Settings – System Settings –  Integrations” and click “Connect to QuickBooks.“

After logging in to QuickBooks and confirming the connection, you will be taken to the integration settings page in MRPeasy.

First, choose what to synchronize:

  • Purchases and sales invoices can either be configured to synchronize automatically or manually. If automatically, these are sent to QuickBooks within 5 minutes of creation
  • It is possible to enable or completely disable the synchronization of account balances with journal entries to QuickBooks. If enabled, changes in account balances are posted to QuickBooks once per day

Then, choose if a purchase order from MRPeasy should appear as a purchase order or a bill in QuickBooks.

There are a few exceptions to the synchronization of purchase orders; you will find these described in the MRPeasy User Manual, along with a detailed description of each account, which we must choose in the next step.

If balances are not synchronized, then only two accounts must be chosen:

  • The purchases account, which is used for items when a purchase order is sent to QuickBooks
  • The sales account, which is used for items when a sales invoice is sent to QuickBooks

If balances are synchronized, then additionally, the following accounts must be chosen:

  • The default bank account for payments on purchases
  • The inventory account for materials on hand, which are in stock
  • The work in progress account for the value of products that are currently being manufactured
  • The direct labor liability account for the wages workers have earned by performing manufacturing operations
  • The manufacturing overhead liability account for the applied manufacturing overhead costs, also known as factory burden, from performed manufacturing operations
  • The inventory account for finished goods that are in stock
  • The default bank account for received payments
  • The expense account for the cost of goods sold
  • The accounts for positive and negative manual inventory adjustments
  • The transfer orders liability account for costs of internal transfers, which are applied to goods

Now, we are all set.

Back in the Integration settings, we can choose to import information from QuickBooks to MRPeasy.

Here, we can also manually force the synchronization of balances. Keep in mind that the first synchronization will only post changes from current day.

Here, we can also see the detailed log of each synchronization.

Thank you for watching! Please see our other videos for more about MRPeasy.

Keywords: QuickBooks Online, accounting, purchases, sales, inventory transactions

We use cookies to enhance your experience on our website. If you continue using this website, we assume that you agree with these. Agree Learn more Ok