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. After clicking that, you will be prompted to import your chart of accounts and do the mapping.
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.
The first step is to tell SimplePay that you’d like to use the Xero integration. Go to Settings > Accounting > Accounting System Integration, as illustrated below:
When you click the drop-down menu under Accounting System, you will have the three options shown below. Select the one you want and 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:
Note that, so far, no communication between SimplePay and Xero has taken place.
Creating a Pay Run
This step is not specific to the Xero integration, but a general function of SimplePay. Click on Pay Runs.
First, you will need to finalise the payslips for the period. If your screen does not have a 0 under Pending as illustrated below, you may click the Finalise link which will appear under the number of pending payslips, in order to do a bulk finalise. Then click Create Pay Run.
After the pay run has been created, you will see the screen below. Click Send to Xero:
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 that it can be mapped to.
Because SimplePay does not yet have the list of Xero accounts, click Import now:
You will then 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. Then click Allow access:
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. That’s 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.
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:
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: