Adding Xero to Expandly and completing Sales Channel, Other Revenues and Taxes Mapping

Overview

In this guide, we will show you how to add your Xero account to Expandly

Adding your Xero account to Expandly

1. Click Settings (left menu) and then Xero

2. On the Configure Xero page, click (top right) to be redirected to Xero

3. Login to your Xero account

4. On the next page, click to authorise Expandly to connect with your Xero account

5. You will then be redirected back to your Configure Xero page in Expandly

Viewing your Xero status bar

At the top of the Configure Xero page, you'll see your Xero Status bar:

You can use this to:

View and Refresh Currencies imported from Xero

This field will show all currencies imported from your Xero account (If any new currencies are added to Xero after the connection is established on Expandly, you will be required to Refresh Currencies to bring these in)

Select your 'Send SKU to Xero' preference

This allows SKU information to be sent across to Xero alongside your invoices - we would recommend turning this off if your SKUs exceed Xero's character length limit of 30

View and Refresh the Lock Date importing from Xero

A lock date can be set on Xero to stop users from changing data before, and including, a specific date. These are typically used to prevent data editing when financial records for the year are being prepared, or at the end of a sales tax period. If a Lock Date has been set, date information can be viewed here (you will need to alter this date in Xero direct and Refresh on Expandly if you are wanting to import orders to Xero from before the lock date)

Deactivate the connection to a Xero Organisation

Delete the connection with Xero

This will remove our connection with your Xero account and you will no longer be able to send orders to Xero via Expandly

Mapping your Sales Channels, Other Revenues and Taxes

To get started, you want to link your sales channels in Expandly to the appropriate account in Xero, map any other revenues (such as shipping and gift wrapping) and taxes

1. On the Configure Xero page, within the Map Sales Channels section, for each separate sales channel, select the following from the drop-down menus:

Sales Account - select the sales account you want your orders to go to, per sales channel

Status - this determine what section you want the invoices to be sent ot in Xero. You can send as Draft (invoices go into Xero's draft section for you to approve in Xero), Approved (invoices go in to Xero's approved section for you to sent to 'Paid' in Xero) or Paid (invoices go straight into Xero's paid section)

Bank/Control Account - will allow you to select the default bank account in Xero. Also, by clicking on the edit icon, gives you the ability to map individual payment method with different bank accounts, including your asset (also known as control, suspense or contra) account

N.B. Xero require all accounts to have unique numerical codes. For more information on how to add this information to your Bank Accounts, click here

Batch - allows you to send orders as either Individual (order sent individually to Xero, creating individual invoices) or Grouped (orders are batched together according to sales channel, tax method & currency and are sent together to Xero, creating a group invoice with a combined total)

Due Date - the invoice due date on the invoice will be set as the date when the order was placed on the channel. By entering a value in this field, it will increase the due date that appears on Xero

2. Once finished, click (top right of the Map Sales Channels section)

3. If any changes are made in Xero itself (you add a new Bank Account for example), click (top right of the Map Sales Channels section), to update Expandly

4. Further down the Configure Xero page, you will also be require to map your Other Revenue and Taxes by selecting the relevant Xero Account Type and Xero Tax Name in the drop-down boxes. Click (top right of both the Other Revenues and Taxes sections)

(For guidance on adding sales taxes to Expandly, click here)

Adding Tracking Categories

If you have any tracking categories in Xero, you can map them in Expandly to Account Name, Payment Method, Country, Origin, Destination or Sales Channel:

1. On the Configure Xero page scroll to the bottom and within the Tracking Categories section, select the applicable Expandly Fields you wish to map to.

2. Once selected, press

Setting up Xero Schedule / automatically pushing orders to Xero

You can set up Expandly to automatically push you orders to Xero by:

1. On the Configure Xero page scroll to the bottom and within the Xero Schedule Setting section, click the 'Send Automatically to Xero' to and use the drop-down box to select your preferred frequency (Daily, Weekly or Monthly) and Time Zone.

N.B. Expandly will send orders to Xero from up until midnight of the previous day. The scheduler will also only come into effect as of the date that this is switched on Expandly. If you are hoping to send historical orders over to Xero, these will not be picked up on the Scheduler and you will be required to manually push these orders instead

2. Press to finish

Expandly: Help & Support