මෙම පිටුව තවමත් සිංහලට පරිවර්තනය කර නැත. පහත දැක්වෙන්නේ ඉංග්රීසි අනුවාදයයි.
නොමිලේ මෙවලම්
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.
Last reviewed:
Which columns are in the template?
| 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 |
How do I use it with rupibooks?
- Step 1: Fill in one row per employee for the pay run. Use your own figures or your payroll bureau's.
- Step 2: Upload the file to rupibooks' payroll import. You can map any extra columns to new pay components.
- Step 3: rupibooks works out EPF at 8% and 12% and ETF at 3% again, checks APIT against the current table, and warns you about any differences.
- Step 4: Check the warnings, then post. rupibooks creates the payroll journal and the EPF, ETF and APIT schedules.
The template is a plain CSV file with a header row and no formulas or macros. Open it in Excel, Google Sheets or LibreOffice.
rupibooks ක්රියාත්මකව බලන්න
විනාඩි කිහිපයකින් නොමිලේ අරඹන්න, නැතහොත් සජීවී ආදර්ශනය දැන්ම විවෘත කරන්න. එහි ඔබේ වැනි ව්යාපාරයක සාම්පල ගිණුම් ඇති අතර, ලියාපදිංචි වීමට අවශ්ය නැත.