Erply integration with QuickBooks

Quickbooks Exports

● ● ●
Erply Quickbooks setup

Here is screenshot of the Report exportable fields:

● ● ●
Erply Quickbooks report

Here is how to set it up:

Note: This setup dialogue can be found in either Reports -> Export to Accounting (previously Finances) or Settings -> Settings for Administrator

● ● ●
Erply Quickbooks setup

For the actual export file to work correctly in Quickbooks, you need to put in their Chart of Accounts. But the HTML report works fine even without account numbers, you can inspect that.

Box 1: Setup Chart of Accounts for downloading journal files:

CoA is a set of accounts needed for bookkeeping. An accountant must place every transaction on a specific bookkeeping account.

There are four types of accounts, each should have a name and a number:

Some examples:

Numbers and the specific selection of accounts vary from business to business, therefore each company defines their own CoA in their accounting guidelines.

Each account has two sides, debit and credit (one increases value on account and another decreases) and there is a fancy principle called "double-entry bookkeeping" which states that each transaction is simultaneously recorded on two accounts — on one account, the debit side, and on another account, the credit side.

For example, a payment made by customer is recorded as follows:

Bank is debited (you now have more money on hand)

Accounts Receivable is credited (customer is no longer owing you money)

Box 2: Define accounts for Payment Types and Product and Service Groups:

1.) Click on the Payment Types link in the Export to Accounting report, or go to Settings -> Payment Types

● ● ●
Erply Quickbooks setup payment types

Click on the payment type you’d like to add account information to, add the information, and save.

2.) Click on the Product and Service Group link in the Export to Accounting report, or go to Inventory -> Product and Service Groups.

Right click on the service group you’d like to define the account for, and select ‘edit’.

● ● ●
Erply Quickbooks setup

From this screen you need to specify your Quickbooks Accounts, then save.

● ● ●
Erply Quickbook setup

Intuit and QuickBooks are trademarks and service marks of Intuit Inc., registered in the United States and other countries.