How to integrate Shopify with Xero?

← Back to support index

How does the integration work?

The integration will automatically sync sales from Shopify as invoices in Xero, breaking down sales data into:

  • Sales (Taxed) and Sales (Tax Free)
  • Discounts (Taxed) and Discounts (Tax Free)
  • Shipping Fees (Taxed) and Shipping Fees (Tax Free)

The user can choose which account in Xero these amounts should sync to in “Accounts” in the Amaka settings page.


How does the integration sync Sales?

The integration syncs sales by applying each sales amount type to a desired account of your choosing on the invoice. The user can choose which account in Xero each sales type should sync to in “Accounts” section in the Amaka settings page.


How does the integration sync Payments?

The integration syncs payments by applying each payment type to a desired account of your choosing against the invoice. The user can choose which account in Xero each payment type should sync to in the “Payments” section in the Amaka settings.


How does the integration handle Gift Cards?
  • Purchases of a Gift Card – the integration will sync the purchase of gift cards on the sales invoice and the user is able to map these sales to a corresponding liability account within Xero (e.g. a “Gift Cards” Liability Account).
  • Using a Gift Card to pay for an order – Payments of orders via gift cards will be applied on the invoice the same way as other payment types. Payments via Gift Cards can also be mapped to the same liability account as above (where Gift Cards are sold) in order to maintain a running balance of gift cards that have been issued as well as their corresponding redemptions.

How does the integration sync Shopify returns/refunds?

The integration syncs returns/refunds as credit notes in Xero, showing discounts and shipping fees as separate line items on the credit note.


How does the integration sync orders marked as pending payments?

For orders that are marked as pending via bank deposit, the integration will capture the sales and also the expected bank deposit payment , e.g. if an order (sale) of $100 was made on 1/1 and the payment was marked as pending via bank deposit, the integration would capture the $100 as a sales amount (revenue) and record a payment of $100 (receipt/asset).

When the payment is received from the customer, this amount would be reconciled against the account where the integration originally created the payment.

Using the example above:

On the 1/1, the integration would record both the sale and the pending payment.
Cr Sales $100
Dr Cash (current asset account) $100
When payment is actually deposited into the bank account
Cr Cash $100
Dr Bank Account $100

© 2019 Amaka IO Pty Ltd. All rights reserved. Trademarks and brands are the property of their respective owners.