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 suppliersIn 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.
|
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.