Use DataSnipper's Document Matching and Snips to reconcile payroll master data against employment contracts and payroll reports for government audit procedures.
Video tutorial
What the video covers: importing payroll documents, extracting Staff policy data, using Snips to extract Employee Grade data, running Document Matching to reconcile payroll master data against contracts and reports, and performing final grade and payment date checks.
Prerequisites
Payroll Master Data
Payroll Reports
Employment Contracts
Staff Policy
Start procedure
Import all relevant documents into DataSnipper.
Extract all necessary Staff policy data before starting your test.
Using Snips, extract the "Employee Grade" data for each employee in the analysis.
To reconcile the payroll master data against the Employee Contracts and Payroll Reports, open Document Matching and select "Start new document matching".
Select the sample data and the folders with the relevant documents.
Structure your input and output table to tailor the result in Excel to your needs.
For final checks, verify the grade for each employee using the Staff policy, and the date of payment with the payroll report.
