QuickBooks Accounting Integration Overview
How counterparties are synced between cieTrade & QuickBooks Online
When a new cieTrade.net Counterparty is created or an existing Counterparty’s roles are updated and the changes saved to QuickBooks Online (QBO), the “Display Name“ of the Customer or Vendor in QBO will use the following rules:
Adding a Supplier Role
cieTrade.net will check if there are any Customers in QBO that already have a “Display Name” that matches cieTrade’s Company Name. If there aren't any, then a NEW Vendor will be created in QBO with the cieTrade Company Name as the "Display Name". Otherwise, if a matching Customer's "Display Name" is found, then a “-V” suffix will be added when the Vendor is created in QBO.
IE: If you add ABC Paper as a NEW Counterparty, set them as a Supplier and they do not exist in QBO, then the Display Name will match ‘ABC Paper’. If they do exist in QBO as a Customer and you are adding the Supplier role to the Counterparty in cieTrade, then it will be saved in QBO as ‘ABC Paper-V’.
Adding a Customer Role
cieTrade.net will check if there are any Vendors in QBO that already have a "Display Name" that matches cieTrade's Company Name. If there aren't any, then a NEW Customer will be created in QBO with the cieTrade company name as the "Display Name". Otherwise, if a matching Vendor's "Display Name" is found, then a “-C” suffix will be added when the Customer is created in QBO.
IE: If you add ABC Paper as a NEW Counterparty, set as a Customer and they do not exist in QBO, then the Display Name will match ‘ABC Paper’. If they do exist in QBO as a Vendor and you are adding the Customer role to the Counterparty in cieTrade, then it will be saved in QBO as ‘ABC Paper-C’.
Adding a Customer and Supplier Role
cieTrade will first check for existing records as a Supplier, then check for existing records as a Customer. (See above).
Creating a new Counterparty that exists in QBO
If the Customer or Supplier exists in QBO but not in cieTrade, you will be allowed to save the new Counterparty and it will link to the existing Customer or Vendor records in QBO. If the new Counterparty name and relationship do NOT match exactly with the existing Customer or Vendor name in QBO, a new Customer or Vendor will be created (see above).
Creating a duplicate Counterparty in cieTrade
cieTrade does not allow for duplicate Counterparties even if you are trying to save the same Company Name under a different role. If the Company Name is already associated with either a Customer or Vendor within cieTrade, you will receive an error message.
If you have additional questions, please contact the Support Team via email to support@cietrade.net.