Exporting data to MYOB Business

Connect with MYOB Business to export your data

Will avatar
Written by Will
Updated over a week ago

Applicable to: Buyer Hub
Accessible by: Admin users

This feature is only available for customers in Australia

In order to export documents such as invoices to MYOB Business, you need to first connect your MYOB account to Zeemart. The integration is set up at the company level rather than per outlet.


To set up the integration:

1. Log on to the Buyer Hub desktop panel.

2. Click on your username at the top right corner of the page and select Companies.

3. Click the Actions button next to a company and select Manage integration.

Note: Each company can only integrate with a single accounting software (i.e. either Xero, Quickbooks or MYOB).

4. Select Connect next to the MYOB icon.

5. You will be asked to log in to your MYOB account. Select Allow access
when asked to authorise access to MYOB.

6. Once done, you will be redirected back to Zeemart.

7. Back in the Buyer Hub, you will now need to select the export options for your data.

Mapping suppliers

In Export settings & data mapping > Supplier mapping, map the Supplier listed in Zeemart to the corresponding Supplier within MYOB in the "Export as..." dropdown. Then, pick a category of accounting that this Supplier falls under. Tip: Generally, food expenses are categorised as Cost of Goods Sold.

Note: The options in the "Export as..." and "Chart of Account" are pulled from MYOB and can only be edited within MYOB.

Mapping expense categories (optional)

If you've only done the supplier mapping (see above), all items in the invoices from the same supplier will be assigned the same Chart of Account. To assign individual Chart of Account per item, you must first give each item an expense category, and then map these expense categories to MYOB's Chart of Account in Export settings & data mapping > Expense category mapping page.

Exporting outlet information (optional)

By default, data exported to MYOB does not contain outlet name, only company name. If you need to include outlet name, set up "Jobs" in MYOB by following instructions in this article. After that is done, you can map the outlets in Zeemart with the Jobs you created in MYOB in Export settings & data mapping > Data mapping.

8. Click Save when done.


To export your invoices:

1. In the Buyer Hub, select Invoices from the side navigation and ensure you are in the Invoices tab.

2. To export invoices, click on the Export button next to the invoice in the list.


What data will be exported?

Here's how each field in the invoice data from Zeemart will be mapped to the fields on MYOB. The exported invoices will appear on MYOB under Purchases > Bills.

Zeemart

MYOB

Invoice number

Supplier invoice number

Supplier name

From

Invoice date

Date

Due date

(Not exported - set in MYOB)

SKU name

Description

Qty

Qty

Unit price

Unit price

Chart of Account

Account

Amount

Amount

Subtotal

Subtotal

Tax

Tax

Total

Total

In addition, if the invoice in Zeemart has attachments such as the scanned invoice or the PDF version of it, they will also be exported to MYOB.


Demo video

Did this answer your question?