If you’re migrating your payroll, you'll most likely want to set the opening balances for the leave entitlements and the year to date payment figures for your employees. Importing your YTD payroll data will allow you to generate reports for the whole basis period.
To set up the opening balances for your employees, open the employee record that you wish to set the opening balances for and then select 'Opening Balances' on the left:
Within the Opening Balances screen, there are six tabs:
- Leave Balances
- Earnings
- Deductions
- Employer Liabilities
- CPF & Tax
- Lump Sum Payments
Leave Balances
When entering leave balances, enter the balance as at the point of transition to this payroll system (that is, as at the last pay run processed in your previous payroll system).
Earnings
Earnings are the year-to-date gross values for the basis period specified. If you need to change the Initial Basis period, click the 'Opening Balances Settings' button at the top of the page. Earnings will be allocated to the employee's primary location (set via the employee's Pay Run defaults page) with an effective date of 1 January. The earnings entered are averaged by the 'Number of Months' selected to calculate the additional wage cap for CPF calculations.
Deductions
Enter the year-to-date deduction amounts for the basis year specified.
Employer Liabilities
If you were previously recording employer liabilities in your previous payroll system, you will be able to enter those YTD figures here. If you have not yet set up any employer liability categories, the following articles will help:
Creating and Managing Employer Liability Categories
Setting up Recurring Employer Liabilities
CPF and Tax
Enter the year-to-date tax and CPF withheld amounts.
Lump Sum Payments
If you are migrating terminated employees' data across to this payroll system, you can include lump sum payment data so that you only need to access one system for reporting and IR8A purposes.
Importing Opening Balances
If you have a large number of employees, you can bulk import their opening balances. To access the template spreadsheet, click on 'Opening Balances Settings' at the top of the page, then click 'Export'. Refer to this article for more information.