Shopify MYOB integration: map sales and stock
Connect Shopify and MYOB without confusing sales, payouts or stock. Compare connection methods and check tax, refunds and order records.
- Published
- Last updated
Yes, Shopify MYOB integration is available through connectors such as Amaka, which MYOB lists for MYOB Business and AccountRight. Choose the connection for your exact MYOB product, then map sales and payments separately from stock movements.
A customer’s payment, your sales income and the payout reaching your bank are different amounts. Keeping them separate prevents a net deposit from understating sales or a refund from returning damaged stock to sale.
Match the connector to your MYOB product
Record your MYOB product, subscription edition and company file before choosing a connector. MYOB Business Pro and AccountRight are different configurations, even when both appear in a connector’s compatibility list.
MYOB’s Amaka marketplace listing names MYOB Business and AccountRight as supported products. Its MYOB Business setup guidance says Business Lite users need Pro to see sales orders sent through Amaka. A marketplace listing for the MYOB family doesn’t establish every feature for every edition.
Connection methods
| Method | What it does | Where it fits |
|---|---|---|
| Marketplace partner connector | Amaka sends Shopify accounting data into MYOB on a daily schedule | Documented sales posting with optional inventory modules |
| Other third-party automation | Transfers the objects included in that vendor’s workflow | A supported workflow matching your edition and required records |
| Custom application programming interface (API) connection | A developer implements authentication, mappings and error handling | Requirements outside the connector’s supported workflow |
| File transfer | Imports prepared records using the product’s supported templates | Controlled batches with manual reconciliation |
Amaka is a third-party connector built in partnership with MYOB. Calling it a universal native Shopify integration would hide the separate service and configuration it requires.
The MYOB API getting-started guide distinguishes products and file locations. Custom development needs an explicit scope for invoices, payments and inventory, plus a retry policy. An API’s existence doesn’t make those workflows automatic.
For manual work, AccountRight desktop imports use field-matched text files. A Shopify export needs conversion to the required import format. That is a batch transfer with an import log, not continuous synchronisation.
Amaka’s Shopify integration plans include a free tier for one store and up to 60 orders each month. Inventory and cost-of-goods-sold features require a paid tier. Include historical imports in your transaction allowance before choosing a plan.
Map Shopify sales into MYOB
Map sales to income categories and customer payments to the appropriate payment accounts. Use a separate clearing account for money held by a payment provider before settlement.
Amaka supports daily summary invoices or an invoice for each order. A summary reduces invoice volume, while individual invoices retain order-level accounting records. Keep the Shopify order references and the connector’s breakdown available whichever format you choose.
Amaka’s mapping guide separates product sales, discounts and shipping from payment mappings. Its Express setup creates default accounts. Advanced setup lets you select your existing accounts instead.
Map each Shopify tax treatment to the corresponding MYOB tax code. Goods and services tax (GST) applies according to the sale’s treatment and your registration. A GST-free product must retain its own treatment when posted alongside taxable items.
The Australian Government’s GST guide explains the 10% rate and one-eleventh GST component of a taxable, GST-inclusive price. Apply the tax code to the relevant sales lines. Recording their tax again on the bank deposit would duplicate it.
Illustrative sale and account mapping
This fictional GST-registered retailer sells $220 of taxable goods, gives a $22 discount and charges $22 taxable shipping. All customer-facing amounts include GST. The customer pays $220 after the discount and shipping.
Assume a $3 processing fee and a $217 payout, with no other settlement adjustments. The example claims no GST credit on that fee. Use the actual provider invoice to determine its tax treatment.
| Event | Amount | Illustrative MYOB mapping | Accounting effect |
|---|---|---|---|
| Goods before discount | $200 excluding GST | Sales income | Increases product revenue |
| Discount | $20 excluding GST | Discounts category | Reduces revenue |
| Shipping charged | $20 excluding GST | Shipping income | Increases delivery revenue |
| GST after discount and shipping | $20 | GST liability through tax codes | Records tax on the $220 customer payment |
| Customer payment | $220 | Payment-provider clearing account | Records funds awaiting settlement |
| Processing fee | $3 | Processing fees expense | Reduces the clearing balance |
| Bank payout | $217 | Transfer from clearing to the receiving bank account | Clears this example’s remaining balance |
The ledger category answers what the transaction is: sales income, discount or fee expense. The receiving bank account answers where the payout lands. Choosing your bank account doesn’t assign the sale’s income or tax treatment.
Incorrect: record the $217 deposit as a new sale. Correct: match the deposit to the settlement transfer after recording the $220 customer payment and $3 fee.
Amaka’s bank reconciliation guide describes matching Shopify Payments payouts to synced bank transfers. A real payout can combine multiple orders and refunds, so reconcile its included transactions rather than matching it to one order by amount alone.
Keep refunds and stock changes distinct
A refund reduces the accounting sale, while a restock decision changes the quantity available for another customer to buy. Treat both events explicitly when a customer returns part of an order.
For a separate illustrative partial refund, assume the retailer refunds $55 of taxable goods. The credit reduces sales by $50 and GST by $5. The payment record shows $55 returned to the customer.
Amaka’s refund documentation describes a negative invoice and payment-account allocation for refunds. Trace that credit back to the original order. Don’t also enter a manual credit for a refund the connector has already posted.
Shopify’s refund controls let you choose whether to restock tracked items. If the returned item is saleable, restock its quantity at the receiving location after inspection. A damaged item can receive the same financial refund while remaining unavailable for sale.
Amaka’s documented inventory workflow makes Shopify the authoritative stock system and copies stock quantities into MYOB daily. Its inventory settings guide maps Shopify variant stock keeping units (SKUs) to MYOB item identifiers. It also transfers product details such as price and cost.
That Shopify-to-MYOB direction doesn’t publish an MYOB stock correction back to the storefront. In this workflow, edit the tracked quantity at the correct Shopify location to change stock available there. Price and cost fields have separate purposes and don’t replenish stock.
If your warehouse must control stock from MYOB, choose a connector with a documented MYOB-to-Shopify quantity flow. Define its location mapping and update timing before enabling writes. The Shopify inventory sync guide explains stock-source rules across connected systems.
Configure a controlled first synchronisation
Start with a narrow import period and prove the accounting mappings before bringing across older records. Keep existing manual entries outside that period so the first run doesn’t recreate them.
- Record the Shopify store and exact MYOB company file. Identify who owns accounting approval and stock corrections.
- Authorise each connection through its provider’s sign-in flow. Use an account permitted to install the Shopify app and access the required MYOB file.
- Select the invoice format and company time zone. Map income categories, tax codes and each payment method’s clearing account.
- Match existing products by unique variant SKU and MYOB item identifier. Resolve duplicate SKUs before allowing automatic item creation.
- Set the import starting point and daily schedule. Enable only the inventory and cost modules your workflow needs.
- Review the invoice preview, then inspect one completed sale and its accounting entry. Check shipping and the discount as well as tax.
- Follow one partial refund through its credit and payment allocation. Inspect the returned item’s location quantity separately.
- Match a settled payout to its bank transfer and inspect the clearing balance. Import older periods only after explaining every difference.
MYOB’s Shopify setup guide covers authorisation, tax mapping and the scheduler. Its documented daily sync means a newly activated connection won’t necessarily create records immediately.
If you’re deciding between accounting platforms, the Shopify Xero integration guide covers that alternative workflow. Keep your current MYOB pilot confined to the selected company file.
Resolve unmatched or duplicate records
Use the connector’s failed-record details and the original Shopify identifiers to locate a mismatch before replaying it. Distinguish a record that failed before creation from one already present in MYOB.
| Symptom | Inspect | Controlled correction |
|---|---|---|
| Tax code is unmapped | Shopify tax treatment and selected MYOB code | Correct the mapping, then review the affected record before retrying |
| Product is missing | Variant SKU, MYOB item identifier and item-creation settings | Match the existing item or create the intended item once |
| Sale appears twice | Shopify order reference, MYOB invoice references and overlapping import periods | Pause the overlapping import and establish which entry belongs |
| Clearing balance won’t reconcile | Payout contents, refund allocations, fees and pending settlements | Explain each remaining amount before adding an adjustment |
| Returned item is still unavailable | Restock choice, Shopify location quantity and sync direction | Correct stock in its authoritative system and observe the next sync |
Before retrying, search MYOB for the source order reference and compare its totals. A failed response can leave a created record behind. Use a connector’s targeted retry or support-assisted recovery when available, with the affected identifiers retained.
If a duplicate has reached a reconciled or closed accounting period, have the bookkeeper correct that entry through the appropriate credit or reversal workflow. Preserve its audit history. Restart only the affected interval after recording what already exists and what still needs posting.
Give your store its own shopping agent
Customers ask in their own words. Your agent finds, compares and checks out from your catalogue, right on your site.