Download PDF

Connecting to Xero

As shown in the image above, to connect to Xero, one must first click the “Xero Online Setup” button.  This will direct you to the following page:

 

******* Note this is a Pop up Window.  You must make sure your Pop Up Blocker is off********

Simply click the “connect to Xero” button, and you will then be directed to the next screen, which will ask you to enter your credentials.  After entering your credentials, Xero is going to ask you for permission to share data with Apex HCM.  The screen should look like the below.

You will of course need to allow access in order to utilize the integration as well as the features built in. After you have done so, you will be taken to the Xero Online Integration Setup screen where you can begin mapping accounts.  It should look like the below.

At this point, you are connected to Xero and can begin mapping your accounts.  Data will flow according to the diagram below.  Should you ever need to disconnect from Xero for any reason, you can do so by clicking the “Disconnect from Xero” button in the top right corner of the screen.  ***** If you do disconnect, it will erase all of the mapping that has been done, and it will not repopulate the mapping you currently have, upon your reconnection to Xero.****

Mapping Basics

 

Upon establishing your connection to Xero, you are now ready to begin mapping all of the accounts that you have set up in Employer on the Go to accounts that exist in Xero.  Before you jump in, there are a few things that you will need to be aware of.

In order for the accounts to populate in the drop down, you must first select the “GL Account Type” of the account you are looking to map to.

Upon selecting the account type, all accounts of that type will be pulled into the next drop down, which is titled “Xero Mapped Account”.

From here, you can select the account that you wish the GL account in Employer on the GO to map to in Xero.

 

There are limitations in which accounts can be mapped to as well as what their set up has to include in Xero, which we will discuss now. Currently, you can only map to Xero accounts that have one of the types listed below:

  • Expense
  • Liability
  • Asset

You do not have the ability to post directly to a cash account. 

You will need to complete this process for each and every account in order to progress to the next step.  Once you have done so, you will be able to move onto the “sync” page and select which pay date that you wish to have data pushed into Xero for.

One process that we would suggest, especially for those Setup with a large number of accounts, is to take advantage of the “Save” feature.  This will save the accounts that are currently mapped should your screen freeze up, you accidentally navigating to another page, or the screen timing out as examples.  The save button is located in the bottom right of the screen, shown below.

Once every account is mapped, you will be able to move onto the Sync GL Data Tab after you save your work.

Upon Successfully mapping all of the accounts and hitting save, you will be greeted with the below message:

 

At this point, you can move to the sync GL data tab mentioned prior.  Upon moving to the tab, you will then be prompted to pick a pay date to sync.

You may notice in the image below that there are two dates highlighted.  The one highlighted yellow, is a date that has yet to be synced.  The one highlighted green, is a date that has already been synced.  One should also notice that, once a date has been synced, its date in the dropped down is followed by “Sent”.  This serves to help you make sure that you are picking the right paydate and not sending the same dates over again causing duplicate entries to show up in Xero.

After you select your pay date, you will need to hit the “sync” button in order for the data to move.  Please be patient with the system as it pushes all the journal entries over into Xero.  Upon completion of the data movement, you will have a message pop up like the one below.  This indicates that the sync was successful.

Advanced Mapping Set Up

Outside of what was just covered, there are additional features and functionalities that can be used in order to tag or push data at a more granular level.  These features are as follows:

  • Detail Line Mapping
  • Tracking Code 1
  • Tracking Code 2

These features are “tagged” in the Employer on the GO GL Account Setup screen.  From the same screen that you initiate the connection to Xero, you can also choose to edit an account instead.  You can do this, by clicking on the account to highlight it, and hitting edit in the bottom right hand corner.  You will then be taken to a screen as the one below.

The highlighted area is where we are going to focus our attention now.  First, we will talk about the “Detail Line Mapping” and then move onto the tracking categories.

Detail Line mapping is an option that allows you to more granularly push data into specific accounts.  For example, we see that there are six(6) detail lines that are specifying what data is to be pulled into this account.  If you have need to map the detail lines to different accounts, that can be done by checking the “Detail Lines Mapping” box before going into the Xero setup screen.  This will result in the setup screen below.

You will notice that there is now a drop down arrow next to the account that has Detail Line mapping enabled.  You will need to select the GL Account Type for this account, so that they correct accounts can be mapped.  Its worth pointing out that when selecting the GL account type, you are doing so for all the detail lines at once, so if you need different account types, they must be in different accounts in EOG.

In the image above, you can see that you now have the option to select an individual account for each detail line that is included in the GL Account.  Each user would have their own reasons for using this functionality.  As an example, any user might want to tag all of these to the same tracking category, but need different GL accounts.  In this scenario, this could be done.  It might also be used just as a way to speed up the set up of accounts in EOG, though this would be discouraged.

****Note, if you do select Detail Line Mapping for one account, you must do so for all accounts in order for it to sync.  This update for this limitation will be released shortly.****

Tracking Categories are available in order to tag the data to specific places in Xero.  Its up to the user how they have their categories set up in Xero, but the most common example would be that of tagging accounts to locations and departments.  You will notice that there are four(4) fields regarding tracking categories available to each account.  This is done to allow you to specify which type of tracking category you want to use and then pick from the values of the category from Xero.

The user can select the values from the ones currently available in Xero, by populating the values into the fields shown above.  In the example being previously described(tagging locations and departments), the detail lines would all be set to only pull data from a specific department or maybe group of departments.  This would allow all of those lines to be tagged with the appropriate categories.  When combined with the detail lines mapping, you could then put different detail lines into different accounts, but have them all display the same tracking categories.  This scenario is an example of why you would need to think through how you set up the General Ledger and the Accounts with Employer on the GO carefully, before you start creating them.  You may find that depending on the route you choose to go, you could be doing a lot of repetitive work.