# Free salary sheet template (CSV)

Download a free pay sheet template with one row per employee. The columns match what rupibooks' payroll import expects: basic pay, allowances, overtime, gross pay, EPF at 8% and 12%, ETF at 3%, APIT, recoveries, other deductions and net pay. Fill it in using Excel or Google Sheets and upload it to rupibooks each pay run, or just use it on its own.

Canonical: https://rupibooks.com/tools/pay-sheet-template
Download: https://rupibooks.com/tools/pay-sheet-template.csv

## Columns
| Column | What goes in it |
| --- | --- |
| Employee ID | Your own reference for the employee |
| Name | Full name |
| NIC | National identity card number |
| EPF number | The employee's EPF member number |
| Department or cost centre | Optional. Used to split the payroll journal |
| Basic | Basic pay for the month |
| Allowances | Total allowances |
| Overtime | Overtime pay |
| Gross | Total earnings before deductions |
| EPF-liable earnings | The earnings EPF and ETF are charged on |
| EPF employee 8% | Deducted from the employee |
| EPF employer 12% | Paid by the employer |
| ETF employer 3% | Paid by the employer |
| APIT | Tax withheld from employment income |
| Loan or advance recoveries | Staff loans and salary advances recovered this month |
| Other deductions | Any other deductions |
| Net pay | Gross pay minus all employee deductions |
