If you use Shopify to manage your online store, you can sync your Shopify sales, inventory, and cost of goods sold (COGS) data directly into MYOB Business by integrating Shopify and MYOB via Amaka. This integration enables you to streamline accounting, stay on top of inventory, and make informed business decisions with accurate, up-to-date financial data.
How it works
Sales Sync
The sales integration syncs your sales data into your MYOB Business file.
Choose whether you’d like to have your daily transactions summarised into a single invoice or in separate invoices per transaction. You can also select whether you’d like to have your invoices broken down on a location-by-location basis.
Bills are automatically created in MYOB Business to reflect any third-party fees.
You can select the desired date you’d like to start your integration sync and also time you’d like it to run.
Using MYOB Business Lite?
To see sales orders sent from third parties using Amaka, you'll need to upgrade your MYOB subscription plan to MYOB Business Pro.
Inventory Sync
Through a daily sync, the integration will create inventory adjustments to maintain alignment of stock-on-hand values across products in Shopify + MYOB.
This will handle sales and refunds that occur within Shopify across each day of trade.
If you're not using Inventory Sync, you'll need to manually enter inventory adjustments in MYOB Business when you sell products in your platform.
COGS Sync
Through a daily sync, the integration will create a journal entry in order to record your cost-of-goods sold expense and inventory category (on a dollar-value).
The COGS sync has been designed to function in conjunction with or independent to the above modules.
Why you should set it up
Centralises your data. Brings Shopify sales, inventory, payments and COGS into MYOB Business for a single source of truth.
Automated financials. Sales and inventory data sync daily, reducing manual entry and error.
Better inventory management. Sync inventory movements, track both sales and refunds to keep stock-on-hand up-to-date automatically.
Helps you make better decisions. The synchronisation supports better decision-making with up-to-date sales insights from MYOB reports.
Easier reconciliation. Automatically sync your sales data from Shopify into MYOB daily via bank feeds, fast-tracking your reconciliation process.
Easy setup. The setup process is streamlined and can be completed in just a few clicks using Amaka's Express Setup, with clear account mapping and customisation options to suit your needs.
Already have sales? No problem, you can back-date your data synchronisation and generate sales summaries for your previous sales.
Pricing
Amaka’s integrations are typically offered under a freemium pricing model (the first integration and some basic features are free to use, additional integrations and advanced features are available for a fee).
For premium integrations, Amaka offers a 7-day free trial - allowing you to find a solution that fits your need before committing to purchase.
Support
Amaka offers extensive support, including unlimited help from Integration Experts. Onboarding and ongoing assistance is available via Zoom calls, live chat, and ticketing. Dedicated help guides are provided for each integration.
Setting up Shopify + MYOB integration
Below is an overview of how to set up the integration based on Amaka's Express simple setup mode. For more details, including the Advanced setup option, refer to the Shopify + MYOB setup guide.
Before you begin
To get the full benefits of this solution, check that you've set these things up in MYOB Business:
-
Customers and suppliers – check that you've created your customer and supplier records so you don't need to enter these each time you buy or sell. You can also speed up getting paid by giving customers an easy way to pay your invoices online – see Online payments.
-
Bank feeds – if you want to reconcile your online sales automatically, you'll need to have set up bank feeds and connected your bank to the MYOB Business category you'll use to track your online sales.
-
Categories – if you choose the Express Amaka setup, you won't need to create any new categories in MYOB Business to track your sales – Amaka will create default categories in MYOB Business to map sales and payments from your e-commerce. If you choose the Advanced Amaka setup (recommended for accountants and bookkeepers), which allows you to choose your own custom sales and payments mapping, you may need to create categories in MYOB Business.
1. Connect accounts
Sign up for or log in to your Amaka account.
On the Integrations page, click Create new one.
Choose Shopify as your e-commerce provider and connect your Shopify store.
On the Connect Accounts page, click Connect to Shopify.
Authorise Amaka to access your Shopify data.
On the Connect Accounts page, click Connect to MYOB.
Set your Company Timezone to ensure transactions are accurately time-stamped in MYOB according to your business's local time.
2. Select relevant features
Choose whether you want to summarise all your daily Shopify transactions as a single invoice in MYOB Business or create a separate invoice for all transactions.
If you need help setting up your integration, click Yes in the Do you need help? message to schedule a call with an integration expert.
3. Choose settings
Tax Types. Map Shopify taxes to your MYOB tax codes for accurate reporting so the tax components of your sales are recorded correctly in MYOB Business.
Bank Accounts. Select which MYOB accounts Shopify payments will be posted to so your sales from Shopify flow directly into MYOB, making your bookkeeping and reconciliation a lot easier and saving you time compared to manually entering the data.
Inventory Sync. Opt-in to sync inventory movements automatically. This enables automatic daily synchronisation of stock-on-hand movements from sales or refunds that occur within Shopify directly into your MYOB Business file. This helps maintain alignment of inventory levels across both platforms without manual data entry.
Invoice Preview. See a sample of how Shopify orders will appear in MYOB.
4. Scheduler
Select the start date for data syncing. You can back-date the integration to import earlier transactions and inventory history.
5. Finish
Find out what to expect next or return to your Amaka dashboard.
FAQs
Can I turn off an integration?
Yes, at any time you can go to the Amaka dashboard and disable an integration by either turning it off or deleting it entirely. For more information, see Amaka help.
How often is my data synchronised from Amaka?
Your e-commerce data is synchronised with MYOB Business daily. The time your data is synchronised depends on the time and date you choose in the Amaka Scheduler:
For more information, see Amaka help.