Quickbooks

IXO Commerce sends Sales Orders, payments and refunds to QuickBooks. Two schedulers handle this: the update scheduler and the update payments scheduler.

How it works

Sales Orders

  1. A Sales Order can be edited freely in IXO Commerce until it is Completed.
  2. Once the order has been despatched, it is sent to QuickBooks as an invoice. Cancelled and returned lines are left off.
  3. Payments on the order are then sent to QuickBooks and recorded against the invoice.

Changes after completion

Once a Sales Order is Completed, its invoice in QuickBooks is not changed. Any discount or return added after this point is raised in QuickBooks as a credit note, with the refund payment recorded against that credit note.

Example 1: full return

A customer buys a Women's Hat for £40. The order is despatched and Completed, so a £40 invoice and a £40 payment are sent to QuickBooks. A week later the hat is returned and refunded. The original invoice stays at £40, and a £40 credit note is created in QuickBooks with a £40 refund payment against it.

Example 2: partial refund with mixed VAT

A customer buys two items in one order, paying £55 by card:

Item Nominal Code VAT Rate Net VAT Gross
Women's Hat - Red nom123 Standard (20%) £33.33 £6.67 £40.00
Children's Gloves - Blue nom456 Zero rated £15.00 £0.00 £15.00
Total     £48.33 £6.67 £55.00

The order is despatched and Completed, so a £55 invoice with these two lines and a £55 payment are sent to QuickBooks.

The customer then returns the gloves, and is given a £5 discount on the hat because of a mark on the brim. £20 is refunded to their card. The original £55 invoice is not changed. Instead, a £20 credit note is created in QuickBooks, with each line keeping the VAT Rate and Nominal Code of the line it came from:

Credit note line Nominal Code VAT Rate Net VAT Gross
Children's Gloves - Blue (return) nom456 Zero rated £15.00 £0.00 £15.00
Women's Hat - Red (discount) nom123 Standard (20%) £4.17 £0.83 £5.00
Total     £19.17 £0.83 £20.00

A £20 refund payment is recorded against the credit note. In QuickBooks, net sales for the order are £29.16 (£48.33 less £19.17), with £5.84 of VAT due (£6.67 less £0.83).

Account payments

A sale paid on account is sent to QuickBooks as an invoice with no payment against it. This leaves a balance outstanding on the Customer's account in QuickBooks.

When the Customer pays off their account balance in IXO Commerce, that payment is not sent to QuickBooks. It must also be recorded manually against the invoice in QuickBooks.

Account payments and account refunds are never sent by the integration. Only non-account payments and refunds are passed to QuickBooks.

Product Catalogue

No product catalogue is maintained in QuickBooks.

QuickBooks takes nominal codes from its own product listings, so IXO Commerce can't send them directly. Instead, if a Nominal Code is set against a Variant in IXO Commerce, it is sent to QuickBooks as the SKU code. If a Product with that SKU exists in QuickBooks, the line is matched to it. If not, a new Product is created in QuickBooks.

The Client should set up a Product in QuickBooks for each Nominal Code used in IXO Commerce.

Example

Field Value
SKU Code

nom123

Product Name

nom123 - General Sales

VAT Rate

Standard

When an item is sold, it is sent with its own description, e.g. 'Women's Hat - Red', against the relevant Nominal Code. This allows sales to be reported by nominal code in QuickBooks.

QuickBooks will not hold product level sales data. Product level sales reports must be run in IXO Commerce, e.g. Sold Items.

Update scheduler

Calls the following functions, in this order.

getItems

Gets the default cost price of all items in QuickBooks.

sendOrdersToQuickbooks

Update payments scheduler

Calls the following functions, in this order.

sendOrderPaymentsToQuickbooks

sendOrderRefundPaymentsToQuickbooks


Revision #4
Created 20 November 2026 12:38:58 by Mike
Updated 20 November 2026 16:20:35 by Mike