Exporting data to Xero (Buyers)

Connect with Xero to export your data

Zeemart Ops Team avatar
Written by Zeemart Ops Team
Updated over a week ago

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 suppliers

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

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

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 & status

In the Export settings & data mapping page (see above image), under Export settings you can also choose:

  • Line item detail: Whether to include all the line items in the invoice or simply export the line items as a total sum.

  • Status of exported invoices: Specify the status of the exported invoices in Xero.

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

Did this answer your question?