General information for working with QuickBooks in ERPAG:

  • The user needs to have their own QuickBooks account already created
  • The QuickBooks company that the user wants to connect with ERPAG needs to be created as any country supported by QuickBooks Online.
  • QuickBooks needs to track inventory as well (needs to have the possibility to create an Inventory item)
  • During the synchronization ERPAG sends the following data types into QuickBooks:
  1. Items
  2. Sales Orders
  3. Purchase orders
  4. Work orders
  5. Utility Bill
  6. Stock Adjustments
  7. Landing Cost
  • For the Tax calculation in the Sales Order document (QuickBooks document Invoice) to be correct, In ERPAG, the Customer address (Bill to address) and Ship to address in the Sales Order needs to be entered correctly.
  • Sending data to QuickBooks will be possible only when documents are marked as Invoiced.

To connect ERPAG and QuickBooks you need account for both software. In case you don’t have a QuickBooks account already, you can create it on the following link:

QuickBooks login

Connecting ERPAG and QuickBooks Online

To set up the integration, go to:

Administration > QuickBooks

erpag > quickbooks button

Upon logging in to QuickBooks Online please follow the steps in ERPAG & select “Connect”

Connect button in ERPAG

After connecting, the system will send you to the ERPAG Home page. Then go again to Administration > QuickBooks, and system will open all synchronization parameters:

Documents sent from ERPAG to QuickBooks

There is list of documents that can be sent from ERPAG to QuickBooks Online

Setting up the Items

While creating or editing an item, it is necessary to specify QuickBooks Online accounts.

Note: Product synchronization is always based on SKU.

Quickbooks item setup in ERPAG

Sending out documents to QuickBooks Online

To be sent to QuickBooks Online, documents have to be invoiced. ERPAG is sending only invoiced sales orders and supplier invoices.

Synchronization is not automatic once a document is entered, it requires an operator to click the synchronization button by going to:

Accounting > Synchronization:

ERPAG sync button

When the form opens, all documents that can be sent are displayed, as well as the type of document that will be created in QuickBooks Online.

Bulk action in ERPAG

Then through the Bulk action, we will determine which documents will be sent to QuickBooks Online (e.g. We only send documents from the previous month).

For example, Received and invoiced Purchase orders will become Bill in QuickBooks Online.

And each Bill has its own Transaction journal:

In case you incorrectly set up an account for items, you can see how to amend in the following link:

Read More

Related Posts

ERPAG Change log 08-04-2023

ERPAG Change log 08-04-2023

It's the peak of the summer heat, but that doesn't stop us from improving ERPAG! Here is the list of our newest updates: You can now list the "Additional info" information as a column in your Manufacturing report: 2. Exploded view is now available in the multi-level...

read more
JSON / XML Designer

JSON / XML Designer

JSON/XML Designer in ERPAG is a visual tool that will allow users to transform data from the ERPAG database into JSON or XML format. This can be further used for future integration with API services. This tool provides a user-friendly interface where users can define...

read more
Change log 05/29/2023

Change log 05/29/2023

The biggest change we developed is Automatization and Customization. This change is a huge milestone for us, and we will publish individual instructions for using the new features in the upcoming period. This module is divided into individual wholes: JSON Designer -...

read more