Learn how you can import your historical payslips that have been created outside KAMI, to accurately calculate the year-end tax reporting in just easy steps!
Steps
Make sure to create a payroll batch first prior importing historical payslips. We suggest to name the batch like Monthly Payroll (Imported) to quickly identify which batches were imported.
Step 1: Get the template - on the Payroll Batch created, click the "More" button > Import Payslips > Click "Get a sample template" and an excel file format will automatically be downloaded on your browser.
Step 2: Fill out the template with necessary data
- EmployeeID *
- Name / Surname - optional
- Batch ID * - you'll see this on the created payroll batch on the upper right corner
Batch ID will be the key identifier to which payroll batch the payslips should be included. You can add various payroll batch ID in one import template.
- Batch Name - you can copy and paste the payroll batch name you have created, i.e. Regular (Semi-Monthly)
- Total Wages * - Gross Pay of the employee (Basic Salary - Tardy/Absences + OT + ND + Holiday Pay)
- Minimum Wage Payslip * - put Yes if employee is a MWE
- Other Payments (OP) - any addition or deduction included in the computation of payroll, i.e. Allowances, Rice Subsidy, Service Charge
Header format must be OP[Type]Payment Name, i.e. OP[De Minimis]Rice Subsidy
Refer to Other Payment Types article for what OP Type to use.
- Wage Type - different working events paid to the employee
Header format must be Wage[Type]Activity Name, i.e. Wage[Basic salary]Working
Go to Leave and Working Activity > Wage Settings section to see which Wage Type to use. Make sure that there is only one column for each Wage type.
- Contributions - put here the employee and employer share
Make sure to encode the correct Contribution name base on your region. Go to Contribution Type Settings to see each of your contributions name.
For EE Share, it must be encoded as "negative" amount.
- Gross Income - recommended to include, it must be the total of Total Wages + Taxable OPs
- Deductible Expenses - as applicable, if there are tax-deductible expenses in your country
- Net Income - recommended to include, it must be the total of Gross Income - Contribution/Deductible Expenses
- Period Tax - the withheld income tax for the period, must be a positive value
- Bonus Tax - tax from the bonuses received by employee (if taxed separately from regular income tax), must be a positive value
- Termination Tax - tax on termination payments (if taxed separately from regular income tax), must be a positive value
- Pension Tax - tax on pensions (if taxed separately from regular income tax), must be a positive value
- Tax Payable - total tax amount from Period Tax to Pension Tax, must be a positive value
- Total Payable - or the Net Pay of employee
Ensure that all amounts are in 2 decimal places only.
Step 3: Import the completed template - go to the Payroll Batch where you need to import this template, click the "More" button > Import Payslips > Browse File > Import.
Import of payslip shall overwrite any existing payslips that overlap for such periods.
If import is rejected, go to you email to review which row/s causes a problem, correct it then reupload the same file.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article