How to use ABSS Payroll Migration Tool

Financio Payroll is the next generation of our payroll software, incorporating all the great major features you love from ABSS Payroll, along with a host of new enhancements. We understand that transitioning between software solutions can be a cumbersome task. To streamline this process, we have developed the ABSS Payroll Migration Tool, which is available for free. This tool simplifies the migration of essential data to Financio Payroll.

 

Here are a couple of guidelines to assist you:

1. If your company has fewer than 10 employees, we recommend manually configuring your company in Financio Payroll.

2. If your company has 11 employees or more, you can take advantage of the free ABSS Payroll Migration Tool to upgrade to Financio Payroll.

Minimum application version requirements:

• Malaysia : ABSS Payroll v14.2
• Singapore : ABSS Payroll v14.0

If you are using an older version, you are required to upgrade to the latest version before using the migration tool. Please click on the links above to upgrade your system or contact our Technical Support Team for assistance.

Singapore: support.sg@abassasia.com

Malaysia: support.my@abssasia.com

.

Pre-requisite items

(a) Financio Payroll System

1. User required to subscribe an account in Financio Payroll. Click the below to subscribe:

https://payroll.financio.co/#/signup

2. Setup your company accordingly in Financio Payroll.

    Important Note:

a) If you have a promo code, please create a new company using the provided promo code before continuing with the remaining steps of the migration process outlined below.

b) To set up the default calendar day if your company holiday policy is different from Sat/Sun.

(b) Download and Install Payroll Migration Tool

1. You can download the migration tool from the link here.
2. After download, you will see a folder named PayrollMigrator.zip. Create a folder in your desktop and unzip all files into this folder.
3. Inside the folder, there is a sub folder called Driver. Open the folder and DoubleClick on the file name VFPOLEDBSetup. Follow the on-screen instructions to complete the installation. 

4. You are required to restart your PC after completed the installation.

5. Once done, go back to folder that you created at Step 2 you will see a program named PayrollMigrator. Double-click on it to start running the migration tool. 

Note: Your computer must have .NET Framework 4.7.2 installed to run the Payroll Migration Tool. Please consult your IT personnel if you need help to update your .NET Framework version, or you can down from here. 

6. ABSS Payroll Migrator Tool program will come out. 

 

About The Migration Tool:

The ABSS Payroll Migration Tool has been developed to simplify the process of migrating essential data to Financio Payroll.

Supported Features:

1. Employee Details
   • Employee Personal Info
   • Contract
   • Statutory Info
   • Document (IC or Passport)
   • Residential Address
   • Tax Exemption Info (Malaysia)
2. Race, Religion and Bank Details

Financio Payroll provides a predefined set of races, religions and banks. If Payroll Migration Tool is unable to find a match for this information from the provided lists, it automatically assigns the value as "Other" in Financio Payroll. 

Click here to find out the steps for the mapping.

3. Allowance & Deduction items (global setup)

4. Leave Detail

• Leave Type (global setup)
• Employee Leave Type
• Current year processed leave transactions

Non-Supported Features:

• Employee Allowances & Deductions
• Current year pay run prior to conversion month

Process data migration steps

1. Open the Payroll Migrator Tool.
2. Click on the Browse File to look for the existing ABSS Payroll file (.PAY) and click Open. 

     Example, your data file is located at C:\ABSS Payroll v14.0 SG and the file name is ClearwtrSG.PAY 

3. The Payroll Migration Tool will extract all the information from the data file and you will see a success screen once it is done. The list of the staff name will appear on the left-hand side of the Payroll Migration Tool. 

Remark: The file size and your current computer performance might impact how much time it takes to load the data. 

4. If you want to filter out any resigned staff from the list, you can do so by choosing ‘Exclude staff(s) who resigned before the selected date’ from the dropdown list. Then choose the date and click on Apply. 

5. You may double-click the item on the left panel to bring it to the right panel (remove it from the target migrate employee list).

 6. Click Next button at the right bottom to go to next step. 

7. Fill in the administrator email and password used when you sign up for Financio Payroll at ‘Sign Up Email’ field and click on Login & Get List. The system will show how many companies are registered under that email. 

8. Click on the dropdown list beside Company Name to get the list of company names registered under this email at Financio Payroll. 

Remark: The Payroll Migration Tool will filter the company list based on country. For Example, if you have both Singapore and Malaysia companies registered at Financio Payroll using the same administrator email, only companies with a similar country as per Step 2 will be listed. 

IMPORTANT NOTE: Choose the correct company name because once you click on Go Migrate to start data migration, you might not be able to reverse the process at Financio Payroll. 

9. Select the Payroll Year and Up to what Month you want to migrate your leave transaction.

10. Click on Go Migrate to start the migration process. Once done, you will see a prompt message like below. Click OK to close the message. 

11. The system will log migration status at the Result Log tab. Refer to List of Message log (Appendix A) below for possible solutions. Check Result log if any error(s).

12. You may export the result log and save it as an HTML page for future reference in case any error(s) occur. If you encounter any issues during the data migration process and require assistance, you can send this file to our dedicated Technical Support team.

Singapore: support.sg@abassasia.com

Malaysia: support.my@abssasia.com

 

Delete All button 

If you make some mistake and you intended to remove all user defined information including staff card files, payroll components and leave information in Financio Payroll, you can use the Delete All function. 

Important Notes: System will delete all the above-mentioned records including what you have entered from Financio Payroll system and this action cannot be undo.

 

Post Migration

1.  After completing the data migration process, it is recommended to verify the result from Financio Payroll system. You may proceed to check the result from below user interface:

• • Employee Profiles
  • Leave Profile > Leave Balance

2.   Resigned date - Financio Payroll displays the effective resignation date where staff salary will not be calculated anymore.

         Example:
         Staff resigned on 31/1/2023, then resign date will display as 1/2/2023, where salary ceased to calculate with practical from 1/2/2023.

3.   If there is any missing employee or leave transaction record due to incomplete information from ABSS payroll data or unforeseen scenarios, you may manually adjust or enter directly into Financio Payroll system.

4.  You may proceed to add the allowance and deductions items for your employee(s).

• Go to ABSS Payroll, export Payroll Listing for the latest pay period to Excel for selected employee to import.
• Massage the data to get employee code, name, payroll component name and amount.
• Go to Payroll click on Salary Calculation and click Save, you will see that all Payroll function is expend.

• Select Allowance and Deduction and click on Down Template

• Open the template and copy payroll component information into the Excel file for import.
• Import the Allowance & Deduction details, you can check the import status from the error Excel generated by the system. Information highlighted in yellow indicates errors.
• You are required to fine-tune those error data and perform reimport.
• Once successfully imported, you can proceed to do salary calculations starting from January 2023 up to the current month.

5.  For Malaysia - to compute accurate income tax for employees who joined the organization during the course of the payroll year, you have to enter the income received from the previous employer along with the SOCSO, EPF, Zakat deductions, and taxes that they have paid.

Go to Employee Profiles > Previous Employer/ Previous Month Income, select the payroll year and click Edit to update the relevant amounts.

    Important Note: Please do not exceed TP1 capping limit of RM4,000 for EPF Contribution.

 

6.   We highly recommend users follow a two-step process for processing EA (Malaysia) / IR8A, IR8S, Appendix 8A, and Appendix 8B (Singapore) forms to streamline the data entry and avoid duplicating effort.

• ABSS Payroll - EA (Malaysia) / IR8A, IR8S, Appendix 8A, and Appendix 8B (Singapore) form stating historical salary information prior to the migration.
• Financio Payroll - EA (Malaysia) / IR8A, IR8S, Appendix 8A, and Appendix 8B (Singapore) form stating data starting from the payrun that has been processed in this system onwards.

 

 

 

Appendix A

List of message log inside Result Log

Code	Message	Solutions
9001	Company name is incompatible with sign up email.	This error is not applicable as the company name is selection list after matching the user login email and country.
9002	Staff No. exists in the system.	You can either change the staff no in ABSS payroll or delete the employee record in Financio Payroll, to ensure no same staff no and re-run the migration tool for a particular selected staff,
9004	New IC No contains blank data where ID Type = 1.	New IC No must contain 12 chars.
9005	Branch Code cannot be blank because Account No has data.	To check whether the bank branch mapping is done correctly.
9006	Date Confirmed must be after Date Hired. Last Official Working Date must be after Date Confirmed. Last Official Working Date must be after Date Hired.	Employee confirmation date must be later than the date hired.
9007	The API name must be compatible with the company country.	Internal API error, user may contact Financio Payroll support by providing the data and error log details.
9009	File has been imported successfully	Data migration successfully done; user can proceed to check data from Financio payroll.
9010	Employee does not exist in the selected year.	Selected employee does not have any leave transaction for migrate in current selected year.
9011	From Date Commencement must be before or on To Date Commencement.	Commencement From date must be earlier or equal to To date.
9012	NormalRemuneration must be a positive number.	For previous year opening balance, the total normal remuneration must be a positive figure.
9013	File has not been imported successfully	Migration failed, due to some errors. User can check other error of specific area such as employee details, leave or system setting.
9014	BasisYear must belong to the existing year of the system’s payment period.	Make sure the ABSS payroll’s payroll year is same as system year.
9015	{0} is not active in {1} E.g: Employee ID: E001 is not active in 2022	Make sure the selected employee(s) for migrate are in Probation or Confirmed status.
9016	Year of {0} must be the equal to Year With: {0} : @FieldName Eg: Year of FromDateCommencement must be the equal to the Year.	Employee join year must be equal to current system year.
9017	Year must belong to the existing year of the system’s payment period.	Please select to migrate up to current system month and year to process the migration.
9018	Employee {0} must be calculated salary in basis year for importing other incomes and deductions.	Make sure the employee selected to migrate contained pay run in ABSS payroll for current system year.
9019	Branch code : {0} does not belong to bank code {1}.	Invalid branch code mapping of the employee’s bank code.
Warning	Import Leave : {0} => Skip because this leave name already exist in Financio Payroll System.	This warning is display when you import system leave types such as Annual Leave, Sick Leave, Marriage Leave, Paternity or Maternity Leave. The entitlement balance still will go into the system.

 

 

WARRANTIES AND DISCLAIMERS

The tool is provided “as is” without warranty of any kind, whether express or implied. It is your responsibility to regularly back up your data and to take other appropriate precautions to safeguard your system while using this tool.

By downloading and using this free tool, you agree to these terms and conditions.

 

 

2nd Release (15 August 2023) - What's New

• Enhancement to handle SG Bank Swift Code: DBSSSGSG, CITISGSGGCB, HSBCSGS2, MBBESGS2, BOFASG2XXXX, IRVTUS3N, SBINSGSG bank codes.
• Enhancement to handle MY Bank Swift Code: RHB bank code
• Enhancement to handle inconsistence data field values in customer database