Skip to main content
Free tools

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?

ColumnWhat goes in it
Employee IDYour own reference for the employee
NameFull name
NICNational identity card number
EPF numberThe employee's EPF member number
Department or cost centreOptional; used to split the payroll journal
BasicBasic pay for the month
AllowancesTotal allowances
OvertimeOvertime pay
GrossTotal earnings before deductions
EPF-liable earningsThe 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
APITTax withheld from employment income
Loan or advance recoveriesStaff loans and salary advances recovered this month
Other deductionsAny other deductions
Net payGross less all employee deductions

How do I use it with Ganana?

  1. Step 1: Fill one row per employee for the pay run, from your own calculations or your payroll bureau's.
  2. Step 2: Upload the file to Ganana's payroll import. Any extra columns can be mapped to new pay components.
  3. Step 3: Ganana recomputes EPF at 8% and 12% and ETF at 3%, compares APIT with the current table, and flags differences as warnings.
  4. 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.

Let the books do themselves.

Start on the Free plan. No card needed.