The following guide will walk you through the integration with third-party accounting packages and assumes you have already signed up with a package such as Xero or Sage Business Cloud Accounting. (Formerly Sage One) If you haven't done so already then it is advised you do this first before going ahead.I is also highly recommended that you add your bank account to your accounts package before integration as well.
The integration is a paid add-on that does allow you to trial it for free for 14 days, once activated. You can cancel it at any time should you wish. After the initial 14 days, you will be charged for it. The cost of the integration is £5 per user per month.
Before enabling your integration, you should know that if any of your customers in Gas Engineer Software already exist on your accounting package then duplicates may be produced when syncing your existing data.
If you already have existing data on your accounting package then please contact us and we can match your existing data against the data on Gas Engineer Software to ensure that duplicates are not produced.
Keep in mind that it is not currently possible to prevent the duplication of any existing invoices that may already exist on your accounting package. If some of your existing invoices in Gas Engineer Software have already been manually created under your accounting package, you could end up with duplicates in your accounts package in some circumstances.
If you have yet to add any data to your accounting package then the above does not apply to you.
You will first need to subscribe to the integration by logging into the website and going to Settings > Gas Engineer Subscription Details. Here you will need to select on the Integration you want: Sage Business Cloud Accounting, or Xero.You will receive a free initial 14 days to try it out.
You now need to Authenticate with your accounting package by going to Settings > Integration Settings, and selecting Authenticate.
Clicking on this option will take you to a new page.
At this stage you'll want to click on Authenticate for the service you want to use, which will then require you to sign into Xero/Sage One before it can link your accounts. This login process occurs directly through either Xero/Sage One, so this part of the software is outside of the scope of Gas Engineer Software.You will need to Allow Access to continue.
The next step is to select which bank account you wish invoice payments from GES to be linked to. Select the appropriate bank from the drop down menu and click the Save button.
If you have not added your bank account yet, it is highly recommended that you do so now, before Authenticating. If there is no bank account, Xero/Sage will create a dummy one for payments. If payments get made to this account, you can only move them from it individually to another bank account at a later date. This is tedious and unnecessary if you add your bank first.
After this step has been completed your GES account will then be linked with your accounting software. The status indicator on your Integration Settings page should now indicate that the link is now active.
The tick boxes will change the behavior of the integration. If, for example, the
Sync customers option is checked then any new customers you create will automatically be synced to your accounting package.
Alternatively if the 'Sync invoices' option is checked, then both your customers and invoices will automatically be synced to your accounting package.
If any issues occur while the integration is active, they will be logged on your integration settings page. Typically these errors will be thrown back by the service itself and not by Gas Engineer Software, and unfortunately at times these messages can be vague.
Gas Engineer Software will often provide you links to the record in question that was being synced when the fault occurred but the below will walk you through what each message might possibly mean.
If you're still unsure of the fault then please don't hesitate to give us a call on 0207 129 7058 or send us an email, and we will be more than happy to assist.
|Artefact number must be unique||You're very likely seeing this because an invoice already exists under Sage One with that identification, e.g. 'Ges-1'.|
|This field is required||This indicates that a field that's required in Sage One has not been provided in Gas Engineer Software.
Typically this will mean that you're missing some information under a customer. This message will give you the exact field it's missing and will provide a link to the customer within Gas Engineer Software.
Clicking this link will take you to a new page under which you can ensure all fields have been filled in with information. Once you're done just click save and the software will attempt to sync the customer again.
|You must unallocate credit notes or receipts before editing this invoice||The invoice in Sage One has already been marked as paid in full. If you wish to make any further changes to the invoice then you will need to remove the payments in Sage One.|
|Invoice not of valid status for modification.||This is indicating that the invoice under Xero has been modified - when this occurs, Gas Engineer Software is unable to modify it any further through Xero's API and is in essence locked out.
Unfortunately once this has occurred the only way forward is to modify them independently from one another.
|Another contact has this contact number. Please enter a different contact number.||This means that Gas Engineer Software attempted to sync a customer to Xero, but a customer with the same Unique ID number (Contact Number) already exists under Xero.
Xero requires that each contact has their own unique ID number.
This usually is the case when a contact has been archived in Xero, thus the GES contact can no longer sync to it. To fix this, look in archived contacts in Xero for the same customer name, and restore that contact.
Please see below for further information on dealing with duplicate contacts under Xero.
|Account code '200' has been archived, or has been deleted. Each line item must reference a valid account.||You must make the account code 200 available for GES Sales in order to sync.
1) First go into your ‘Settings’ and then ‘General Settings’
2) From there go into ‘Chart of Accounts’
3) You’ll see a few tabs just below the buttons listed, such as ‘All Accounts’, ‘Assets’ and at the end ‘Archive’
4) If you click on the ‘Archive’ option, you should see an entry with a code of ‘200’ which will need to be restored on the account. This is a default account that Xero requires to exist -even if it is not used.
Click on the checkbox beside it and then click on ‘Restore’.
Once you’ve done this, you’ll be able to go back into your ‘Integration Settings’ within Gas Engineer Software and try syncing again. If the account does not exist, you can create it.
|Organisation is not subscribed to currency EUR.||Within Gas Engineer Software, you're likely using Euros as the selected currency but under your Xero organisation you are using a different form of currency.
You will need to match this setting between Gas Engineer Software and Xero in order to rectify the problem.
|The status 'ARCHIVED' is not valid for contacts.||The customer has been archived under Xero. The solution is to restore that archived contact in Xero.|
|This document cannot be edited as it has a payment or credit note allocated to it.||The invoice in question has already been marked as paid in Xero, in which case Xero will lock Gas Engineer Software out from making any further changes - in this case you will need to make your changes in Xero. Just make sure the invoices match and are correct, and ignore the error from then on.|
|You have reached the limit of invoices you can approve.||Your Xero account won't let you add any more approved invoices, either because you're on the "Starter" plan or you are currently using the trial version of the software.|
If you find that you have created a duplicate contact in the syncing process, you can merge the two contacts together in Xero, and keep the existing invoices of both under one. The key is to merge the existing Xero contact to the newly synced/created GES contact. This is because invoices for this contact will be linked to the GES version of this contact. You can always undo this process as well.
Unfortunately this is not an available option in Sage One.