Xero

We integrate with Xero, an accounting platform where you are able to seamlessly send across your sales information

Below is what the Xero dashboard looks like:

 

You will then be directed to the login screen for Xero, which will be used to confirm the connection between both systems.

 

To do in Xero

  1. Create a Xero account
    1. If you don’t have a Xero account, then signup and login to Xero. Connect your bank account to Xero (not needed for Goodtill)
  2. Create a Contact
    1. Goodtill creates an invoice with the sales data for a period and applies the payments against it. The invoice will be created against this contact. Please note the contact can also be created on the fly in Goodtill if you prefer - please see the “Select contact to be used” section below. 
    2. If you already have an existing contact that you want to use, skip this step but please note that the contact you use should be entered as a Supplier in Xero and not as a customer
    3. Please also note that the contact that is used for Xero can not have any specific sales/purchase settings or revenue code assigned to it. Please make sure the financial section and the sales/purchase settings are set as below:
  3. Create a Revenue Account
    1. Go to Settings > Chart of Accounts in Xero.
    2. You can use an account that is of type Revenue or create one. This will act as default account for your line items unless you choose to overwrite this by choosing to apply a product/category specific Account Code.
    3. If, in Goodtill, you choose to send the data to Xero “By Product” and want to send some or all the products to different Accounts, you can populate the “Account Code” field on each product. Each product line then will go to the specific Account in Xero (with fallback to the default account if no account code assigned).
    4. If you send the data to Xero “By Category” and want to send some or all the categories to different Accounts, you can populate the “Account Code” field on each category. Each line then will go to the specific Account in Xero (with fallback to default account if no account code assigned).
  4. Create a Tracking Category (Optional)
    1. To track categories, go to Settings > Tracking in Xero. Goodtill supports up to 2 Tracking Categories.
      1. Type: 
        1. Add a tracking category named “Type”.  
        2. This is helpful if you are sending data “By Category”. Add all the categories as inputted in the Goodtill backend exactly. Please note that these are case sensitive, so please take special care, as otherwise it may not set the tracking category as intended in Xero.
      2. Region:
        1. To track location/region, add the outlet name (please note this is case sensitive; to check this you can find it in the Xero page settings in the backend) in one of the options under “Region”.
        2. You can overwrite these categories in Goodtill to match Xero. For example, if you have a tracking category called Department in Xero and you want to use that to track instead of Type, you can do so from the mappings page. You can also overwrite the value for Region which usually defaults to the outlet name. 
        3. You can set this up in Xero by going to Accounting > Advanced > Tracking categories:

          The category options need to match precisely with whatever you put in the region value field in GT (so in the example above, you'd have your tracking category name as LOCATION and the options as one of either Main Outlet, or West Coast for example)
        4. You can also track MISC, SERVICE CHARGE and DELIVERY CHARGE. Just create the options in Xero as such. These will be tracked regardless of the export type if there are any, and if the options are set in Xero correctly (please see the “Extra Settings” Section).

    To do in Goodtill:

    1. Connect your Xero account to Goodtill
      1. Firstly, login to Goodtill back office. Then go to Apps > Xero. Click “Connect to Xero”. 
      2. This will take you to Xero and have you authorise the account and select a company. Once done, it will be redirected to Goodtill. 
      3. If you have multiple outlets and want to use the same Xero organisation to send data from different outlets, you need to tick the option “Use this connection for all other outlets”. Please don’t link each outlet individually to the same Xero account, as this will cause issues - just tick the “Use this connection” option on one outlet. You can still control all the individual aspects of the mappings for each different outlet.
      1. Select Contact to be used
        1. Select one from the list (this will show you all your contacts that you already have created in Xero) or create one by clicking the “+ Create New” link. This will ask you to confirm and will create a contact “The Good Till” in Xero and have it automatically selected in the dropdown. Please note, if you already have a contact with the same name, this might give you an error in which case just select the account from the list. 
        2. All the invoices sent through from this outlet in Goodtill to Xero will be assigned under this contact.
      2. Select Revenue Account to be used
        1. Select a default revenue account from the dropdown that the invoice line items will go to.
        2. You can choose to send each register’s data to a different revenue account (see below “Map Register Data”) .
        3. These can be overwritten by the product/category specific Account Code. So if you choose to send the data to Xero “By Product” and want to send some or all the products to different Accounts, you can populate the “Account Code” field on each product. Each product line then will go to the specific Account in Xero (with fallback to the default account if no account code assigned).
        4. If you send the data to Xero “By Category” and want to send some or all the categories to different Accounts, you can populate the “Account Code” field on each category. Each line then will go to the specific Account in Xero (with fallback to default account if no account code assigned).
      3. Export Type
        1. Select how you want the data to be sent to Xero. 
        2. We can send it “By Product” or “By Category”. If you have an Account Code assigned to a product or category, this will try to send it to that specific revenue account. Please make sure the Account Code exists in Xero. If no Account Code is assigned to the product or category, it will go to the default revenue account.
        3. You can also send “By Summary” which will send only the VAT and non-VAT sales to Xero with no specific product or category information.
      4. Map Register(s) to Revenue Account (Optional)

        1. You can choose to send each register’s data to a different revenue account - just select the revenue account from the dropdown. Please note this is optional, and if left empty, the data will go to the default revenue account.
        6. Xero Tracking Category (Optional)

        1. This is an optional section, and before using, please read the “Create a Tracking Category” section above.

        7. Accounts For Sales VAT (Mandatory)


        Please note this section is mandatory. Please select from the dropdown a VAT rate for each VAT rate that you use. In the example in the picture above, we are only using 20% VAT, No VAT, and 5% VAT on our products, so these are the fields we have filled out. If we were using 15% VAT we would need to fill this field out as well.  
        If the correct VAT rate doesn’t appear in the dropdown, please check that you have the VAT rates set up correctly in your Xero account. If you add a new VAT rate in Xero, please note you may need to refresh this Settings page in Goodtill to see your changes. 
      1. 8. Accounts For Sales Payments (Optional - Recommended)
        Please select from the dropdown a specific Account for each type of payment that you use. In the example in the picture above, we are only taking payments through SumUp so this is the field we have filled out. If we were taking cash payments, then we would need to fill this field out as well.
      2. Only the mapped methods of payments will be sent through to Xero, anything left blank will be ignored. For example, if you leave all fields blank, no payment information will be sent against the invoice and the whole invoice will be overdue. 
      3. If the correct Account doesn’t appear in the dropdown, please check that you have the Account set up correctly in your Xero account. Please make sure the Accounts that you choose here have payments enabled to them.
      4. If you add a new account in Xero, please note you may need to refresh this Settings page in Goodtill to see your changes. 
      5. Please note if you select the default invoice status as “Draft”, this section is irrelevant as you can not apply payments against a Draft invoice.
      6. Your accountant may advise you better on which Accounts to use.

         

      7. Separate Amex Payments (Optional)


        If you want to send Amex payments separately to another Xero account, please configure this here. You will need to map the original payment method for this to work. For example, if you use PaymentSense and want to send Amex payments separately, you will need to map PaymentSense (see above) and then select the checkbox for “Send Amex payments separately” as well as choosing the Amex payment account from the dropdown. 

        What will happen we send data across is if you take £100 in PaymentSense and £30 of that is Amex, it will send £30 to the mapped Amex account and £70 to the mapped PaymentSense account. You can enable/disable this at any time. This will not correct/backdate any old data that's already been sent.
      8. Sending Goodtill Data to Xero

        There are two ways to send your data to Xero:

        Automatically:
        The register closure can be sent to Xero automatically whenever the register closes. The invoice date will be set as the current day. Please choose this option to send it automatically. This will also send an email to the main contact to confirm whether or not the data has been sent successfully. If it’s unsuccessful the email should detail any reasons why. 
        When this option is disabled, any future register closures won’t be sent until it’s enabled again. You will have to send all the register closures manually while it’s disabled. Please note that this will enable automatic data sending going forwards - it won’t backdate any previous register closures - please see the manual section below for how to backdate.

        Manually:
        In the back office, go to Reports > Register Closures. Select a date range and this will display all register closures within these periods.
        Click on a record to see more information about the register closure. This will also display if it has already been sent to Xero (by showing a little tick at the end of the row). You can then send the report to Xero manually by clicking the “Send to Xero” button at the bottom of the register closure report. Choose an invoice date and select send. It will give you a success/failure response. 
        You can view the invoice created in Xero by clicking the “View at Xero” button. You might need to click on the record again to see the update.
        This feature is useful if you have turned off Automatic sending, as you can verify the data before pushing it to Xero, or (even if you have Automatic sending on) if you need to backdate any register closures.

      9. Sending Petty Cash to Xero (Optional)



        If you use Petty cash on the POS and want to send the data to Xero, please enable the option and map the account where the petty cash amount will go to. When enabled, we will deduct the amount from the cash takings and put it in the petty cash account so that you can reconcile it in Xero. For example, if you took 300 as cash payment and withdraw 20 from it as petty cash throughout the day, if enabled, this will bank 280 to your cash account and 20 to your petty cash account. When disabled, all 300 will go to the cash account and if you used any petty cash, you will have to manually transfer it between the accounts.

      10. Extra Settings (Optional)


        Here you can override the default revenue account for the MISC, Service Charge and Delivery Charge if you use these. This is optional and will go to default revenue account if not set.
        You can also change your default invoice status to “Authorised”, “Draft” or “Submitted”. 

      11. Goodeats Sales

        Here you can choose to send Goodeats sales to Xero. They won't automatically be sent with the register closure - you will need to enable this section if you want the information to be sent. This section will only appear if the outlet has Goodeats initialised. If you need to send historic data to Xero, you'll need to go to Reports > Goodeats Report, run the date range, scroll down to the bottom and select Send to Xero.

      12. Beta Features (Optional)If you enable this option, then any sales that have a customer assigned to it will go to Xero on its own and the invoice will be created against the customer. If you decide to send the register closure data in addition to this then any sales with a customer attached will be ignored. Please note that this is an experimental feature, but should work as designed. If you do have any issues or feedback, please email support@thegoodtill.com.