This video shows you the steps for setting up the integration between SimplePay and Xero.
SimplePay currently supports integration with Xero. You will be able to import your chart of accounts into SimplePay and then specify mappings from SimplePay’s accounts to your accounts in Xero.
Once you’ve enabled this integration, the Pay Runs screen will contain links for posting finalised Pay Runs to Xero.
Click on a header below to go to that section:
- Preliminary Steps
- Initial Setup
- Creating a Pay Run
- Importing Charts of Accounts
- Final Steps: Mapping Charts of Accounts
- Changing Xero Organisations
- Posting to Separate Entities
- Accounting for SDL Rounding
- Disconnecting Xero Entity from SimplePay
Before integrating with SimplePay, you will need to ensure that Xero is correctly configured in order to be able to map accounts.
You will need to create certain accounts in Xero to be mapped to SimplePay – any account in Xero that has a lock next to its name is not accessible by SimplePay e.g. the Wages Payable liability. You will, therefore, need to create your own custom accounts for these transactions; for example, you will need to create a Liability account to map to salaries and wages payable. You will also need to set up the relevant expense and liability accounts to map to any IRAS, CPF or similar transactions.
Once you have created the relevant accounts in Xero, you can proceed with the Xero integration.
This guide will help you set up the integration between SimplePay, the online Singaporean payroll system, and the Xero online accounting system.
To begin the integration:
- Go to Settings on the left sidebar menu.
- Click on Accounting
- Select “Accounting Integration” from the dropdown, as shown below:
- Select “Xero via Journal” or “Xero via Bill” from the dropdown.
- Click Save.
Xero via Journal
This option posts nett pay to an account as a manual journal.
Xero via Bill
This option creates a salary bill / invoice that you have to pay. The nett pay is not posted but is rather calculated as the balancing amount. Furthermore, you will be able to post your SGD payroll to a bank account that is in another currency, e.g. USD.
For both these options you will usually have to do a reconciliation using clearing accounts.
Please refer to the following section for more information about this third option:
Creating a Pay Run
This step is not specific to the Xero integration, but a general function of SimplePay.
- Click on Pay Runs.
- Click the Finalise link which will appear under the number of pending payslips.
- Then click Create Pay Run.
- Click Send to Xero after the Pay Run has been created, as seen below.
Importing the Chart of Accounts
After performing the above action, you will be prompted to map your payroll accounts to Xero accounts. Under each payroll account, you will find a drop-down list of potential Xero accounts to which it can be mapped.
- Click Import now to link the accounts found in Xero.
You will then need to authorise SimplePay to access your data on Xero. This authorisation will be remembered in future – it can be revoked at any time from within Xero.
You may be asked by Xero for your login details if you are not yet logged in. Ensure that, if you have multiple companies on Xero, the correct company corresponding to the one you are currently working on in SimplePay is selected.
- Click Allow access:
Final Steps: Mapping Chart of Accounts
You will now be back on the Account Mappings screen shown above, but this time the list of Xero accounts will be populated. The list of Xero accounts that appear in the dropdown list when mapping payroll accounts will depend on whether the item to be mapped appears under the Debit or Credit section on the Account Mappings screen. For instance, the dropdown list for Basic Salary will show asset and expense accounts in Xero, since these are the accounts that are usually debited in accounting. However, you can map to any type of account by clicking on ‘Show More Accounts‘ under the ‘Other’ section in the dropdown list. After mapping the accounts, you will be able to post the journal to Xero.
In future, you will not be asked to map accounts. However, if you’ve started using a new payroll account since the last time you posted data to Xero, e.g. you are now paying sales commission for the first time, you will be asked to map that account. This is because SimplePay only maps accounts that you’ve actually used, saving you the trouble of mapping accounts that you may have on paper but never actually use in practice.
Changing Xero Organisations
After you have integrated with Xero by following the steps mentioned above, you will be able to change the organisation from the dropdown as shown below. If changed, you will be notified to update the Chart of Accounts.
*Please note that the list of organisations that appear in the dropdown depends on when the Xero authorisation took place as seen in the above step. The list of organisations is applicable to the current user on SimplePay.
Posting to Separate Entities
The above information is applicable in the standard case – where you wish to integrate your company in SimplePay with one company in Xero. This would be applicable to most businesses.
If, however, you use pay points in SimplePay and, therefore, want to link a Pay Point / company in SimplePay to multiple companies in Xero, please refer to the below section:
Accounting for SDL Rounding
Additional posting to Xero might be required to deal with issues related to the rounding of the SDL total on your monthly CPF Return. This type of posting can be done from the Submissions tab. More information about this can be found in the following section:
Disconnecting Xero Entity from SimplePay
To disconnect your Xero entity from SimplePay, visit Xero and do the following:
- Go to Settings > Connected Apps
- Click on Remove.
More information can be found on this Xero page.