Import any historical payslips that have been created outside KAMI Workforce to compute for accurate year-end tax reporting.

Can be use as well to update computed payroll in KAMI without recomputing the batch

Steps in Importing Payslips

Make sure that you have created a payroll batch for the historical  payslips you are about to import. We suggest you name the batch like Monthly Payroll (Imported) to remind the client that those are imported payslips.

Step 1: Go to settings> Import/Export> Payslips> Import - and download template

Step 2: Fill out the template with the needed data - below are the fields you could add:

ZipID / EmployeeID * – User must already be created in the system to import payslips

Name / Surname – for reference purposes only, will not be imported

Batch ID * – Batch ID of payroll batch.

Will be used as the reference number in importing the data in the correct payroll batch cycle. You can also add various payroll batch ID in one import worksheet.

Batch Name – ex. Regular (Semi-Monthly)

Total Wages * – Basic Salary - Tardy/Absences + Overtime + Holiday pay

Minimum Wage Payslip * – Input Yes if the employee is a Minimum Wage Earner; No if not

Other Payments (OP) - any addition or deduction included in the computation of payroll

Must use the format OP[Type]Payment Name. Example - OP[De Minimus]Rice Subsidy

Please refer here on the different OP Type to use

Wage Type - different working events paid to the employee

Must use the formant Wage[Type]Activity Name. Example - Wage[Holiday pay]Working

Use Wage[Basic salary]Working for normal working day of an employee

Go to Leave & Working activities to see what type are available.

Make sure that there is only one column for each type. Example - Wage[Holiday pay]Working, Wage[Night shift pay]Working, Wage[Overtime pay]Overtime.

Contributions - add the computed contribution per employee and employer share

See contribution type settings to map the correct contribution name. Make sure to add the contribution wage basis used to compute the contribution

Contribution EE share amount shall be added as negative amount

Put 0 if no contribution was deducted.

Note: Change the header of the contributions to be like this when you import:

• [Contribution]SSS - ER
• [Contribution]SSS - EE
• [Contribution]SSS (EC) - ER
• [Contribution]SSS (EC) - EE
• [Contribution]PhilHealth - ER
• [Contribution]PhilHealth - EE
• [Contribution]Pag-IBIG - ER
• [Contribution]Pag-IBIG - EE

Gross Income - (Total Wages + Taxable OPs) recommended to include 

Deductible Expenses – as applicable, if there are tax-deductible expenses in your country 

Net income – (Gross Income + Contribution EE/Deductible Expenses) recommended to include 

Period Tax – withheld income tax for the period

Add value as positive if it's a deduction

Bonus Tax – tax from bonuses, if taxed separately from regular income tax 

Add value as positive

Termination Tax – tax on termination payments, if taxed separately from regular income tax 

Add value as positive

Pension Tax – tax on pensions, if taxed separately from regular income tax

Add value as positive

Tax Payable – total amount from Period Tax to Pension Tax (positive)

Add value as positive if it's a deduction

Total Payable – total amount paid to the employee (or the net pay)

Amount shall be on 2 decimal places only

Step 3: Import data - and wait for a success notification to appear

Import of payslips shall OVERWRITE any existing paysips that overlap for such periods.

If import is rejected, go to your email to review which row/s causes the issue & re-upload the file once done with the amending the data.