Overview of Shopify + MYOB integration
Connect Shopify and MYOB to start syncing your sales transactions, payments, products and stock-on-hand inventory values.
- Sales
- On a daily basis, the integration will sync a summary of your previous day’s sales data into MYOB generating an invoice or opt to sync each Shopify order into an individual MYOB invoice.
- You can customise your preferred sales summary view choosing from a wide array of formats.
- Capture all payment transactions including gift cards, tips, tax and payment fees.
- Easily reconcile Shopify sales and payments in MYOB.
- Cost of Goods Sold
- Automatically synchronise the total cost from sold items and adjust the inventory amount, generating a journal entry.
- InventoryMYOB Lite & Pro users that do not have the Premium Inventory add-on will only be able to sync up to 10 Shopify products/MYOB items.
- On a daily basis, the integration fetches all products from Shopify.
- Each Shopify Product will only be created once as an MYOB Item.
- An inventory adjustment is created on a daily basis to account for the stock movement between the stock count from Shopify and on-hand quantity in MYOB.
Before you start
- Sign up for a Shopify account and a MYOB account (if you haven’t already).
How to set up Shopify + MYOB integration
- Register or sign in the Amaka dashboard to get started.
- Click the New integration button and select Shopify + MYOB from the integrations list to commence the setup.
- Sign in to your Shopify account by clicking the Connect new account button underneath Shopify logo. Follow the guided authentication process to grant all relevant permissions.
- Authenticate your MYOB account following the same procedure, then click Save + Continue.
- Follow the wizard to choose your preferred setup method, invoice breakdown, invoice format, mapping, scheduler and inventory options to complete the setup of the integration.
- Click Save + Continue to finish and activate the integration.
After completing the setup, the new integration will be listed on the app dashboard where you can edit it or start a new one.
Setup methods
Express setup
Every day, an invoice with your daily sales summary will be created into MYOB.
The integration will automatically map sales, payments and inventory from Shopify into MYOB by creating the following default accounts:
Default accounts mappingAccount and code mapping
Sales Type | MYOB Account | MYOB Account Type |
Sales | Shopify Sales | Income |
Discounts | Shopify Discounts | Income |
Shipping/Delivery Fees | Shopify Shipping/Delivery Fees | Income |
Shopify Fees | Shopify Fees | Expense |
Tips | Shopify Tips | Current Liability |
Gift Card | Shopify Gift Card | Current Liability |
Adjustment | Shopify Sales | Income |
Cost of Goods Sold | Shopify COGS | Cost of Sales |
Inventory | Shopify Inventory | Current Asset |
For US regions only:
Transaction Type | QBO Account and Product Name | QBO Account Type |
Sales Tax | Shopify Collected Taxes | Other Current Liability |
Payment mapping
Payment Type | MYOB Account | MYOB Account Type |
Shopify Payment | Shopify Payment Balance | Bank |
Cash | Shopify Cash Clearing | Current Asset |
Cash on Delivery (COD) | Shopify Cash Clearing | Current Asset |
Gift Card | Shopify Gift Card | Current Liability |
Exchange Credit | Shopify Exchange Credit Clearing | Current Liability |
All Other Payment Types | Shopify Other Payment Clearing | Current Asset |
Inventory mapping
Transaction Type | MYOB Account | MYOB Account Type |
Sales | Shopify Sales | Income |
Cost of Goods Sold | Shopify COGS | Cost of Sales |
Inventory | Shopify Inventory | Assets |
Advanced setup
The advanced setup will allow you to choose your own custom mapping related to Shopify Sales, Cost of Good Sold, and Inventory. Take note that account filtering will only show MYOB Account Type which are Income, Cost of Sales, and Assets.
Tax codes
Items | Tax Code |
Items to Sell | Goods and Services Tax |
Items to Buy | Goods and Services Tax |
SKU mapping
Products are mapped using SKU Values provided in the Shopify Field (Stock keeping Unit) and the MYOB Field (Item ID/Number). All SKU values from Shopify must be entered and unique across all product variants.- Default Setup – Enabled, If the user does not require or intend on using SKU Values within MYOB.
- The Integration will Proceed to map the product without SKU
- SKU Number is not required/filled in Shopify Products
- The Integration will create new items in MYOB regardless of items were already created prior to the integration
- All Shopify Products have no SKU
- The Integration will look up Shopify Products and make sure it has no duplicates
- If SKU is detected or has duplicates and is not resolved the Integration won’t be able to create Product Mapping/Items in MYOB
- Disabled – The User may proceed to enable Advance Product Mapping
Advanced product mapping
- The Integration will fetch all Products in Shopify with SKU
- The Integration will fetch all Items in MYOB
- The User should map Shopify Products with MYOB Items created through the product filtering fetch in MYOB
- If left blank, the integration will auto-create a new MYOB item that will be mapped for the Shopify Product