Skip to main content
Talk to usGet a free quoteFree quote

Gross-to-net workbook

Payroll Register Template

A practical worksheet to document monthly payroll for Sri Lankan teams, capturing EPF/ETF, APIT, and take-home pay with traceability.

Audience: Payroll officers, HR managersUpdated: 2025-07-05Estimated time: Monthly update ~25 minutes
  • Supports variable pay including overtime, incentives, and allowances
  • Calculates statutory contributions automatically from basic pay
  • Generates summary totals for finance reconciliation

Enter your email to download

Payroll Register Template (PDF). Enter your email and your download starts right away. We will not email this file or add you to a newsletter. Follow-up tips are optional and currently paused. Our Privacy Policy explains how we handle your details.

Template tabs explained

  • Employee master - stores employment details, tax status, and bank references
  • Payroll sheet - monthly input area with built-in EPF/ETF/APIT logic
  • Approval log - space for HR and finance sign-off with timestamp
  • Statutory summary - aggregated employer vs employee contributions for submissions

Implementation checklist

  • Update employee status (full-time, contract, resigned) before payroll processing
  • Validate attendance or timesheet data for overtime calculations
  • Review payroll exceptions (negative pay, high allowances) prior to approval
  • Generate bank upload file or payslip extract for communication

Governance reminders for Sri Lankan teams

If approvals or reconciliations start to lag, hand the register to the WinCore payroll pod or request HR documentation support via /services/hr.

  • Log approvals from HR and finance before releasing bank files to comply with EPF audit expectations
  • Attach supporting schedules for incentive or allowance payouts so Inland Revenue questions can be closed quickly
  • Track outstanding recoveries and salary advances and reconcile them with management accounts each quarter

Column structure per employee row

  • Employee name, NIC, EPF member number, department
  • Basic salary, fixed allowances, variable pay, overtime
  • Gross earnings for the month
  • Employee EPF deduction (8% of gross)
  • APIT deduction (per applicable table or manual calculation)
  • Other deductions (advances, loans, salary sacrifices)
  • Net pay (take-home amount)
  • Employer EPF contribution (12% of gross)
  • Employer ETF contribution (3% of gross)
  • Total cost to company for the month

Need help putting this into action?

WinCore consultants can implement the processes outlined in this resource. Pick the next conversation that fits your needs.

Looking for something more specific? Email info@wincore.lk with your requirements and we will tailor the template or checklist for your industry.