இந்தப் பக்கம் இன்னும் தமிழில் மொழிபெயர்க்கப்படவில்லை. கீழே உள்ளது ஆங்கிலப் பதிப்பு.
இலவசக் கருவிகள்
Free pay sheet template (CSV)
Download a free pay sheet template with one row per employee and the columns Ganana's 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 Excel or Google Sheets and upload it to Ganana each pay run, or 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 less all employee deductions |
How do I use it with Ganana?
- Step 1: Fill one row per employee for the pay run, from your own calculations or your payroll bureau's.
- Step 2: Upload the file to Ganana's payroll import. Any extra columns can be mapped to new pay components.
- Step 3: Ganana recomputes EPF at 8% and 12% and ETF at 3%, compares APIT with the current table, and flags differences as warnings.
- Step 4: Review the flags, then post: Ganana creates the payroll journal and the EPF, ETF and APIT schedules.
The template is a plain CSV with a header row. Open it in Excel, Google Sheets or LibreOffice; it contains no formulas or macros.
கணக்கு வேலைகள் தானாகவே நடக்கட்டும்.
இலவசத் திட்டத்தில் தொடங்குங்கள். அட்டை தேவையில்லை.