Import payments using a CSV file

To add employee payments, they can be imported in Staffology Payroll using a CSV file.

The CSV file can be created using the relevant payment fields for import, or downloading and completing the CSV Payments Import Template or CSV Additions and Deductions Payments Import Template.

If importing data for the first time, the Mapping template settings must be set during the process. These can be saved as a template for future imports. If a Mapping template is not saved, the settings need to be set each time an import is done.

To learn more about the importing process, go to How importing payments in Staffology Payroll using a CSV file works.

Files can also be imported from uAttend, TimeMoto, or People Planner software.

Before importing payments

Before starting a process in Staffology Payroll, it is important to make sure the right employer is selected.

To select the employer, check the name in the top menu. If the employer needs to be changed, select the current employer name, then select the relevant employer from Other Employers.

If importing a file where each row is used for a single payment, all the payments in the file must be paid on the same Basis as set in the Mapping template.

Import additions and deduction payments for employee records

The headings in the import file, must exactly match the payment field names.

To import addition and deduction payments on employee records for pay runs using a CSV file:

  1. Go to Employees.
  2. Select Import.
  3. Select CSV Payments File.
  1. Upload the file with the payment information.
  2. A preview of the data from the uploaded file displays. The last Mapping template you used is selected automatically. Check the data in the columns matches what you expect. If the matches are not as expected, select different Mapping template settings.
  3. To import all the payments, select Import data.
  4. If there are rows with errors, they are rejected and not imported. Fix the errors, then try to import them again.

Importing payments for a specific pay run

Use this method to import payment amounts directly into an open pay run. If the Import Payments button includes ASYNC in the label, then use the Import payments (Async) steps.

Payments can only be imported for an open pay run. The status of the pay run can be checked on

Import payments

  1. Go to Payroll.
  2. Select the pay run the payments are for.
  3. Select Import Payments.
  4. Select CSV File for Month.
  1. Upload the file with the payment information.
  2. A preview of the data from the uploaded file displays. The last Mapping template you used is selected automatically. Check the data in the columns matches what you expect. If the matches are not as expected, select different Mapping template settings.
  3. To import all the payments, select Import data.
  4. Do not close or leave the page while the data is being imported. When it has been imported, a status message will display to confirm if the import was successful or if some of the data was rejected due to errors.
  5. If there are rows with errors, they are rejected and not imported. Fix the errors, then try to import them again.

Import payments (Async)

  1. Go to Payroll.
  2. Select the pay run the payments are for.
  3. Select Import Payments (Async Beta).
  4. Select CSV File for Month.
  1. Upload the file with the payment information.
  2. A preview of the data from the uploaded file displays. The last Mapping template you used is selected automatically. Check the data in the columns matches what you expect. If the matches are not as expected, select different Mapping template settings.
  3. To import all the payments, select Import data.

  4. The system will import the data. When it has been imported a message will be displayed at the bottom of the page. If you closed the page, or went to another area in the software, the status of the import can be checked in System Tasks.

    The information relates to the Import Overview that shows error reporting for payment imports feature. This is in Beta testing as of August 2026. If you would like to join the Beta group, contact your account manager.

    This feature does not currently work with custom pay schedules.

  5. If there are rows with errors, they are rejected and not imported. Fix the errors, then try to import them again.