Payroll Validation and Verification

1
Payroll Validation and Verification
2
Payroll Validation and Verification

• Current approach
• ESR Reports
• Bespoke Disco reports
• Copy pay advice!
• Manual record cards

3
Payroll Validation and Verification

• Benefits
• More efficient payroll service
• Increase checking of payroll
• Reduced overpayments of leavers, etc.
• Reduced underpayments / CHAPS corrections
• Increased staff satisfaction through payroll
  accuracy

4
Payroll Validation and Verification

• Process
• ESR Process NHS Payroll Run (Monthly)
• (includes generation of xml pay advice)
• Save NHS Pay Advice xml Child Process to secure
  network drive
• Automated process tests if data available every
  15 mins and builds model
• Perform validation reposts and analysis

5
Payroll Validation and Verification

• Standard validation checks include
• Gross Pay Variance change in gross pay by more
  than 20, excluding starters and leavers.
• Net Pay Variance change in net pay by more than
  20, excluding starters and leavers.
• Net Pay gt 5000
• Basic Pay Variance employees with a change in
  basic pay.
• No Pay Current Period employees not due to be
  paid in the current month (typically leavers).
• No Pay Previous Period employees due to be paid
  this month, but not paid last month (typically
  new starters)
• No Pay Current and Previous Period (may be
  suspended employees)
• Sick Report sick pay in the current or previous
  month.
• Maternity Report maternity pay in the current or
  previous month.
• Variance per employee for any element of pay

6
Solution Demonstration
7
Workforce Costing
8
Workforce Costing

• Current approach - Use Excel or Access to
  manually merge
• ESR Reports
• Bespoke Disco reports
• GL Extracts

9
Workforce Costing

• Benefits
• Visibility of expenditure
• Consistency between ESR and GL
• Empowerment of budget holders
• Accountability of expenditure

10
Workforce Costing

• Integration of ESR, General Ledger and 3rd Party
  Data
• ESR Payroll costing analysis
• General Ledger Journals
• 3rd party Agency costs
• General Ledger Budgets
• Establishment structure derived from ESR or
  General Ledger
• Consistent reporting
• Traffic lights - Highlight variances
• Drill down through organisation structure to cost
  centre / Employee
• Automated process tests if data available every
  15 mins and builds model
• Perform validation reposts and analysis

11
Workforce Costing

• Analysis through organisation structure from
  Trust to Employee
• Previous month comparatives
• Cost trends
• Year to date cumulative
• Projected expenditure

12
Workforce Costing

• Analysis of organisation and demographic data,
  e.g.
• Grade
• Employment category
• Gender
• Age
• Trust
• Directorate
• Speciality
• Cost centre
• Assignment
• Analysis by pay code of
• Units
• Rates
• Values

13
Solution Demonstration