Skip to main content
WinCore

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

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

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.

Payroll Register Template | WinCore Resources | WinCore BPO Sri Lanka