Hi. How can we help?

Setting up the Xero integration with Retail POS (X-Series)

  • Available on Pro, Standard, Advanced, Enterprise
  • Available on Core, Plus

The Retail POS-Xero integration is a link between your Retail POS account and your Xero account; simplifying your accounting by automatically sending daily and account sales, payment totals, and invoices from Retail POS to your Xero accounting system.

This reduces manual data entry, saving you time and increasing accuracy.

Once set up you will be able to:

  • Easily reconcile your payment deposits in your bank account against your sales totals and payment totals from Retail POS.
  • View sales, payments, and posted stock orders — these will be reflected in your Balance Sheet and Profit and Loss statement in Xero.
  • Match payments made to suppliers against your stock order (accounts payable) invoices and payments from invoiced customers against their account sales.
  • View your profitability against wages, rent, marketing, and other expenses in Xero to understand your true real-time performance.
  • If you’re running a loyalty program using Retail POS, you’ll also be able to keep track of outstanding loyalty liabilities and the expense to your business.

Connect Retail POS to your Xero account

  1. Navigate to Setup > Apps.
  2. In the Track financials section, click Connect to Lightspeed Retail under Xero

    Xero-Connect-To-Lightspeed.png

  3. Click Enable Xero.

    Xero-Enable-Xero.png

  4. Enter your Xero login information and click Login.
  5. Select the Xero organization to match your Retail POS store and click Allow access.

    Xero-Allow-Access.png

Once connected, you'll be taken back to Xero settings page in Retail POS to map your Xero accounts to Retail POS.

Setting up your Xero Account Mappings

Lightspeed is unable to offer advice on what accounts to map to as this will vary between businesses. We recommend working with an accountant when setting up your Xero mappings.

For new accounts created in Xero, you will have to click Sync from Xero in the Account section of the Xero settings page in Retail POS before they are available in Retail POS to map.

Xero-Mappings-Page.png

If you have not created accounts in Xero, you can do this in Retail POS by selecting Add a new account from the mapping drop-down menus. These accounts will be automatically created in Xero.

Xero-Mappings-Create-Account.png

Register Closure Settings

Xero-Register-Closure-Settings.png

  • Send register closures to Xero as: Select how you would like Retail POS to send Xero the accounts receivable invoice from each register closure. You can choose to:
  • Summary by Account Code: This will send sales data totals for each sales account code.
  • Summary by Product: This will send sales data totals for each product.
  • Individual Products sold: This will send details of each sale as a separate invoice line. This means products may appear more than once.

Choosing how much detail you'd like to send is a matter of preference. We recommend checking with your financial advisor how much information they would like sent to Xero.

Sales Tax

Xero-Sales-Tax.png

If you have not set up your taxes yet, you can create these directly in Retail POS by selecting Add a new sales tax from the mapping drop-down menus. These accounts will be automatically created in Xero

For tax rates that do exist in Xero, your Retail POS account needs to be matched to the corresponding tax rate you have set up in Xero. From the Xero settings page in Retail POS, you will be able to select your Xero tax rates from the tax drop-downs.

Retail POS gives you the option to set up products with or without tax. You need to fill in the No Tax field by selecting the Xero account you want no tax on a product sale to be sent to.

For more information on setting tax rates in Xero, refer to Add or edit tax rates on the Xero Help Center.

Accounts for products

Xero-Account-For-Products.png

Default sales account:This is the sales account in Xero which all product sales totals will be sent to by default.

Send your product sales totals from register closures and account sales to a specific account in Xero. If you don't want all sales going to the same account, you can set an account for each product on the product page.

Which accounts in Xero can this be mapped to?

  • Sales
  • Current
  • Revenue

If you have not created a default sales account in Xero, you can do this in Retail POS by selecting Add a new Account from the mapping drop-down menus. This account will be automatically created in Xero.

On account sales

You can specify the date when on account invoices are due in Xero. To do this you'll need to have added a default due date in Xero.

Xero-On-Account.png

Underneath Invoice payment date, specify the date you want your customer invoices to be due. You can pick from either None - Due immediately or set a custom timeframe in Xero.

Landed Costs

You can map landed costs, including shipping fees, order discounts, and duty fees directly to specific Xero accounts. These landed costs are automatically exported to Xero when you send purchase orders, with the costs being mapped to your default Cost of Goods.

Expenses

Send Invoice as: Select what status you would like Retail POS to use when sending invoices for stock orders to Xero.

Xero-Expenses.png

You can choose:

  • Approved
  • Awaiting approval
  • Draft

How do you want to record your inventory purchases?

  • Asset: Keep a real-time view of your inventory asset with purchases and sales updating the asset account.
    • On-hand inventory: Select an asset account that will map your current assets.
    • Cost of Goods Sold (COGS): Select an expense account that will map your Cost of Goods Sold (COGS). As sales are made, the COGS move from your inventory asset to your COGS account.
  • Expense: Have a running total of your inventory purchases.
    • Purchases: Select an expense account for stock orders.

If you have not created accounts in Xero, you can do this in Retail POS by selecting Add a new Account from the mapping drop-down menus. These accounts will be automatically created in Xero.

Payment types

Select the Default payment account that all payment types in Retail POS will be sent to in Xero from the drop-down menu.

Xero-Default-Payment-Type.png

You can also choose to map each payment type in Retail POS to an account in Xero. Click the Map individual payment types toggle to enable individual mapping.

Xero-Payment-Mappings.png

Once enabled, select the account you wish each payment type to be mapped to in Xero from the drop-down menu next to the payment type.

If you have not created accounts in Xero, you can do this in Retail POS by selecting Add a new Account from the mapping drop-down menus. These accounts will be automatically created in Xero.

Xero-Payment-Mappings-Drop-Down-Menu.png

Retail POS will only show accounts that have payments enabled in Xero.

Default payment account

Retail POS will send your payment totals to Xero for each payment type your store accepts. You need to select where in Xero to send these totals. Many retailers prefer to send their payments directly to their bank account feed so they can use Xero's account reconciliation feature to match them easily.

As with taxes, if you haven't set up any Xero accounts to map to in the Xero settings page, you can create them from the Xero settings page.

For account sales, Retail POS will send each individual payment to the account you specify. For all other sales, Retail POS will total the amount taken from your register closure and send all payments together.

You can also choose to post these payments to a clearing account. If you choose this option, you'll need to create a clearing account in Xero and ensure that payments to that clearing account are enabled in the Chart of Accounts in Xero.

This account will normally be a current asset account. Make sure the account code is six characters or less. Otherwise, your payments will not post. To learn how to do this in Xero, refer to the Add or edit an account article in the Xero help center.

Refunds

Xero-Refunds.png

Typically, refunds will be deducted from your payment totals for the day. However, if the total refunds issued to customers for a payment type are more than the total payments received that day, we'll post the difference to this account.

Which accounts in Xero can this be mapped to?

  • Current Asset

If you have not created accounts in Xero, you can do this in Retail POS by selecting Add a new Account from the mapping drop-down menus. These accounts will be automatically created in Xero.

Rounding errors

Xero-Rounding.png

To keep a record of the small discrepancies that can occur when calculating tax on small transactions, Retail POS will send these to your selected accounts when you close the register.

Select a Xero account to map these to from the Rounding and Cash rounding expense drop-downs.

Which accounts in Xero can this be mapped to?

  • Current Asset
  • Current Liability
  • Liability
  • Expense
  • Direct Costs
  • Overhead

If you have not created accounts in Xero, you can do this in Retail POS by selecting Add a new Account from the mapping drop-down menus. These accounts will be automatically created in Xero.

Till payment discrepancies

Xero-Till-Payment.png

We recommend you use Retail POS cash management to accurately track all cash movements in Retail POS and record discrepancies in Xero.

Track the differences between the amount expected when you close your register and the amount you count. Retail POS will adjust the totals of your payment accounts and the account you pick here accordingly.

Select a Xero account to map these to from the Till payment discrepancies drop-down.

Which accounts in Xero can this be mapped to?

  • Current Asset
  • Current Liability
  • Liability
  • Expense
  • Direct Cost
  • Overhead

If you have not created accounts in Xero, you can do this in Retail POS by selecting Add a new Account from the mapping drop-down menus. These accounts will be automatically created in Xero.

Discounts

Xero-Discounts.png

Record the discounts you give your customers via the discount button or by using price books.

Select a Xero account to map these to from the Discounts drop-down.

Which accounts in Xero can this be mapped to?

  • Revenue
  • Expenses

If you have not created accounts in Xero, you can do this in Retail POS by selecting Add a new Account from the mapping drop-down menus. These accounts will be automatically created in Xero.

Liabilities

Screen_Shot_2020-11-19_at_3.12.11_PM__2_.png

If you have enabled loyalty, store credit, or gift cards, you'll need to select where in Xero to post the expenses and liabilities.

  • Track the liability to your store created by customers earning loyalty, store credit, and gift cards.
  • Track the expense to your store incurred when customers redeem loyalty or store credit.

If you are not sure how to set these accounts up in Xero, or which codes to use, please contact your financial fdvisor.

Select Liability, Expense, and/or Revenue accounts to map these to from the drop-downs.

Which accounts in Xero can this be mapped to?

  • Liability (for loyalty, store credit, and gift card liability)
  • Expense (for loyalty and store credit expense)
  • Revenue (for gift card expiry revenue)

If you have not created accounts in Xero, you can do this in Retail POS by selecting Add a new Account from the mapping drop-down menus. These accounts will be automatically created in Xero.

Saving your settings

Click Save to complete the initial setup. Your Retail POS store is now configured to send data to Xero.

Xero-Save-Settings.png

Mapping Lightspeed Payments processing fees in Xero

Reconciling your Lightspeed Payments transactions for your accounting is now easier with improved visibility of your Lightspeed Payments processing fees in Xero. When you sync to Xero, processing fees will be listed on your invoices and deducted from your payouts for easier reconciliation.

To setup:

  1. On Retail POS, go to Setup > Apps > Xero.
  2. On the Xero page, check the box Lightspeed Payments expense.

    Lightspeed Payments expense checkbox

  3. Choose or add an expense account relating to your Lightspeed Payments processing fee and click Save.

    Create or choose an account expense

  4. From the main menu, go to Reporting > Register Closure. Find your closed register entry and click on the Xero Icon to access it.

    Xero in register closure.png

  5. In Xero, this fee will show up on your invoice clearly as Lightspeed Payments processing fee.

    Lightspeed payment processing fee xero invoice.png

    You can update the default tax rate of your accounts code associated with your Lightspeed Payments processing fees by navigating to Accounting > Advanced accounting and selecting your default tax rate from the drop down menu.
    Tax default Xero.png

  6. To reconcile your Lightspeed payouts, in your bank statement line, confirm that the amount match in Xero. This amount corresponds to your payout since the processing fee is already deducted.
  7. Click OK to reconcile the amount for your accounting.

    Lightspeed payment reconcile

  8. From there, your accounting will be up-to-date.Reconciled account

If you wish to remove an existing Xero account to connect another Xero account, contact Support.

What's next?

The difference between Asset and Expense in your Xero Expense mappings

Learn more on the difference between Asset and Expense in your Xero Expense mappings.

Learn more

Setting up Cash management with Xero.

Learn more on cash management with Xero.

Learn more

Was this article helpful?