Applicable to: Buyer Hub
Accessible by: Admin users
In order to export documents such as invoices to Xero, you need to first connect your Xero 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 or Quickbooks).
4. Select Connect next to the Xero icon.
5. You will be asked to log in to your Xero account. Select Allow access when asked to authorise access to Xero.
6. Once done, you will be redirected back to Zeemart.
7. Back in Zeemart 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 Xero 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 Xero's Chart of Account in Export settings & data mapping > Expense category mapping page.
|
Exporting outlet information (optional)By default, data exported to Xero does not contain outlet name, only company name. If you need to include outlet name, set up tracking categories in Xero by following instructions in this article. After that is done, you can map the outlets in Zeemart with the tracking categories you created in Xero in Export settings & data mapping > Data mapping. |
Export fidelity & statusIn the Export settings & data mapping page (see above image), under Export settings you can also choose:
|
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 one by one, click the Export button next to the invoice in the list.
3. You can also multi-select invoices using the checkbox button and select Export to accounting system button at the top of 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 Xero.
Zeemart | Xero |
Invoice number | Bill number |
Supplier name | From |
Invoice date | Date |
Due date | Due date |
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 Xero.