How to perform payroll procedures using DataSnipper

Learn how to document and perform procedures over payroll using the DataSnipper’s Document Matching.

Choose your DataSnipper version:

👉 DataSnipper version 4.1 and later

👉 DataSnipper version 4.0 and earlier

Video Tutorial

Example

Here you can download the workbook shown in the video including all of the sample data and documents.

ToD payroll - example

Template

Here you can download a blank version of the workbook shown in the video to use or customise for your own procedures. 

ToD payroll - template

Prerequisites

  • Payroll master data file from your client's HR system
  • Payslip run 
  • Screenshots or bank statement showing payroll payment
  • Employee contracts

Start procedure

  1. Start by importing your supporting evidence including payslips, employment contract and any other documents such as screenshots from the payroll system.
  2. Click on Document Organizer ans create folders for each type of document.
  3. Click on Document Matching and “Start new Document Matching”.
  4. Select your sample data. If your sample data includes headers, check on the box "First row includes headers". Then, select “Use documents folders” & check the boxes of folders you would like to use.
  5. Next, cross check the output columns and adjust them according to your procedure. Click Match all rows and DataSnipper will automatically match the input and output columns for you.
  6. You can now calculate the total per the payslip run by using the Sum Snip.
  7. Then tie this to the total per the system screenshot or bank statement by using the Text Snip.
  8. Reconcile the details to an individual employee contract by using the smart search functionality to find the correct contract per the employee's name or employee ID and use Text Snip to extract data from the contract or the Validation Snip to evidence signature of the contract.

DataSnipper version 4.0 and earlier

Sharing the file

  1. You can choose to exclude all documents before saving the workbook in your audit file, by selecting the include/exclude documents toggle.
  2. You have some options to delete specific documents, please click here to learn more.