இந்தப் பக்கம் இன்னும் தமிழில் மொழிபெயர்க்கப்படவில்லை. கீழே உள்ளது ஆங்கிலப் பதிப்பு.
இலவசக் கருவிகள்
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-வை செயலில் பாருங்கள்
சில நிமிடங்களில் இலவசமாகத் தொடங்குங்கள், அல்லது நேரடி டெமோவை இப்போதே திறங்கள். அதில் உங்களைப் போன்ற வணிகத்தின் மாதிரிக் கணக்குகள் உள்ளன; பதிவு செய்யத் தேவையில்லை.