Primaseller provides a very comprehensive integration with QuickBooks that covers Invoices and Payments from all integrated online, POS and B2B channels, Purchase Orders and Receipts (Bills).
PS: To configure your QuickBooks account, click here.
Countries Supported
Primaseller supports QuickBooks in USA, Canada, UK, India, Australia as well as rest of the world. There is an exception though – in France the integration may not work due to some unsupported functions.
Objects Created from Primaseller into QuickBooks
- SKUs from Primaseller are created as Products of type Inventory in QuickBooks.
- Combo Products/Bundles (Composite Products) from Primaseller are not synced to QBO. Instead, when you have a transaction, we sync the child SKUs as invoice items into QuickBooks online since you technically purchase and sell the child SKUs and the composite SKU is only a temporary entity
- Customers from Invoices are created on the fly in QuickBooks. Repeat Invoices are identified and mapped to the same customer
- Suppliers are created on the fly in QuickBooks
- Channels are Created as Classes in QuickBooks
- Facilities are created as Departments in QuickBooks
Objects that need to be Pre-Created in QuickBooks before Integrating Primaseller
- Tax Codes
- Accounts (You can use these or create their equivalents)
- Inventory Asset
- Cost of Goods Sold or equivalent
- Sale of Product Income or equivalent
- Account Payables
- Account Receivables
- Inventory Shrinkage (for inventory adjustments)
- Undeposited Funds (Cash Transactions)
- Accounts for other Payment Methods
How Transactions Sync from Primaseller to QuickBooks
Invoices and Returns
For every Invoice that is closed in Primaseller, we will create an Invoice in QuickBooks which automatically creates the following Transaction Journals:
- Debit Account Receivables
- Credit Sale of Product Income
- Debit Cost of Sales
- Credit Inventory Asset
On Return, a Credit Note is created with the following Transaction Journal entries:
- Credit Account Receivables
- Debit Sale of Product Income
- Credit Cost of Sales
- Debit Inventory Asset
Payments and Refunds
For every Payment in Primaseller, if the payment is marked as ‘Paid’, we create a Payment in QuickBooks associated with the corresponding invoice which creates the following Transaction Journal entries:
- Debit <Account Mapped to Payment Method in QuickBooks Configurations>
- Credit Account Receivables
For every Refund in Primaseller, we create the following direct Transaction Journals in QuickBooks Online:
- Credit <Account Mapped to Payment Method in QuickBooks Configurations>
- Debit Account Receivables
Purchase Orders and Receipts
For every Purchase Order Created in Primaseller, we create a Purchase Order in QuickBooks. However, Purchase Orders in QuickBooks are non-posting entities and no Transaction Journals are created.
For every Receipt in Primaseller, we create a Bill in QuickBooks with the following Journal entries:
- Credit Accounts Payable
- Debit Inventory Asset