Mapping Sales & Expense Accounts
In order to utilize the Accounting Integration in cieTrade.net, you must first establish a list of accounts that will allow the integration to map to your accounting system. Below we will discuss the minimum accounts needed for Accounting Integration, as well as the additional accounts that you will want to map in order to take advantage of other features in cieTrade.net.
How to Export General Ledger Accounts in QuickBooks Online
In QuickBooks (QB) Online this can be accomplished by navigating to Settings > Your Company > Chart of Accounts. Account numbers will need to be enabled.
If this is not already set, you can enable account numbers by going to Settings > Your Company > Account and Settings, click on the Advanced tab and in the Chart of Accounts section check 'Enable account numbers' and 'Show account numbers'.
NOTE: It is important that GL Account Numbers must be enabled in your accounting system in order to map these accounts to cieTrade.
Mapping Accounts on your cieTrade Database
In cieTrade.net:
- 1
- Navigate to Settings > Accounting. Click on the New Account button provided on the top right hand side of the Accounting Mappings page.
- 2
- Enter the Account Number and a unique Description.
- 3
- Select the Class of the Account that you are adding. The A/R, A/R Accrual, A/P, and A/P Accrual accounts are required and the Account Number must match exactly, as these accounts will be hit directly by cieTrade.net.
- 4
- Click Save Changes to finish.
The following accounts should be setup in your system, as well as in your accounting system:
| Suggested Account Name | Class | Accounting System Account Type |
| Accounts Payable |
A/P |
Accounts Payable |
| Accrued Accounts Payable |
A/P ACCRUAL |
Other Current Liabilities |
| Accounts Receivable |
A/R |
Other Current Assets |
| Sales Accrual |
A/R ACCRUAL |
Other Current Assets |
| Freight |
FREIGHT |
Cost of Goods Sold |
| Purchases |
PURCHASES |
Cost of Goods Sold |
| Sales | SALES | Income |
Finally, for those using QB Online as their accounting system, a 'Products and Services' list item must be created when utilizing the cieTrade.net AR Module. To do this, simply navigate to Lists > Products and Services in QB Online and click New to add an item named 'Sales Accrual'. Assign the appropriate Sales Accrual account (utilized in the above setup) to the item's Income Account drop-down and click Save and Close to complete.