Pay Run Column-Based Import & Report Packs

Posted on Thursday, 9th Sep '21

Dylan Martinez by Dylan Martinez


The latest update to Staffology includes two ways to help you save time when running your payrolls.

Pay Run Column-Based Import Mapping

We have received requests to make Import more flexible. To that end this release includes the ability to map columns from a csv file to pay codes, rather than having a row for each pay code separately within the import file.

When you perform an import in an open payroll period:

  1. Click on Import Payments
  1. Choose a CSV file
  1. Choose Column based as the Type of import at the top left, as shown below.
  1. Choose the correct Behaviour for your import
  1. and whether the file has a header row.
  1. The first column to map is for employee Payroll Code to match payments to the right individuals.
  1. Click on the Add a Column button to open a dialogue and map columns holding pay data in the CSV to pay codes you have previously set up in Staffology; the Column dropdown relates to columns in the CSV file and the Code column to Pay Codes in Staffology.

Map all the pay columns as needed.

  1. Click Save Mapping (or Update Mapping if you are editing a previously saved one) as a template to re-use in future pay periods.
  1. Click Import Data as normal to proceed with the import.

Optionally, when you are presented with the Open CSV file dialogue you can use the link below to manage any existing templates without running an import.

Report Packs

Create a collection of reports for easy access to reports you run frequently.

Under the Reports section at the top right there is now an option Report Packs.

  1. Click on Report Packs
  1. Click Add Report Pack to open a Pack creation dialogue.
  1. Give the report pack a name
  1. Use the Included Reports drop-down to select all the reports to include
  1. Click Create to save the pack.

You can create as many Report Packs as you wish and use them under the Report Packs view to have quick access to your most-used reports.

Share Your Ideas

If you have any ideas for enhancements like the one above please let us know directly via the Staffology Ideas Portal

Please pay a visit, create new ideas and vote on ideas others have raised. We will give you feedback and let you know how they are incorporated into our roadmap. 

Dylan Martinez, September 9th, 2021

Related Articles

UK National Minimum Wage: everything you need to know

13th Aug '24

Whether you’ve got a large multi-national business or you’re just starting up, understanding the UK National Minimum Wage is a must. But with rates regularly changing, it’s understandable if you’re struggling to keep up. However, getting the Minimum Wage wrong isn’t an option. Fear not! In this blog, we cover everything you need to know […]

by Anthony Wolny

Three benefits of a good Human Resource Management System (HRMS)

9th Jul '24

If it’s not broken, don’t fix it – a classic saying that so many of us use. However, this should not be applied to HR.  While the approach may at times work – a wobbly shelf just hanging on or a dated iPhone that has slowed but still runs.   Your people management, on the other […]

by Anthony Wolny

Absence management: what is the Bradford Factor?

4th Jul '24

Absences are an unavoidable part of workplace management. At one point or another, situations will arise – whether that’s sickness, emergencies or personal responsibilities – and your staff will need time off. As such, businesses need a good absence management framework to support employees and they must provide clear and consistent guidance. One way HR […]

by Anthony Wolny


To top
Chat Now