Export a Deduction Bank File

Overview

If Deduction Bank Files have been enabled for your portal, you’ll have the option to export a separate bank file for deductions once a pay run is locked.

The Deduction Bank File is used to pay outside agencies directly, and will use the nominated EFT bank account details that have been set up for each deduction in Config > Payroll > Deductions. 

Deduction Bank Files can be either exported from the Process Pay Runs report or from the Pay Run Details report for a selected pay run. 

In both cases, the bank file will include one line per deduction per employee per pay. The data will not summarise, so you will be able to see each deduction amount on a separate line. 

Export a Deduction Bank File from Process Pay Runs

To export the Deduction Bank File:

1. Go to Payroll > Process Payroll > Process Pay Runs

2. Tick the pay run you would like to export the bank file for.

3. Go to With selected Pay Run > Lock > Go > Confirm.

4. Tick the checkbox for the pay run to select it again.

5. Click Export > Export Selected Deduction Bank File(s).

You can export a Deduction Bank File for a Supplier Pay Runs by navigating to Payroll > Process Payroll > Process Supplier Pay Runs and following the above steps. 

Export a Deduction Bank File from Pay Run Details

You can export the Deduction Bank File from within a specific pay run, by following the steps below. 

1. Go to Payroll > Process Payroll > Process Pay Runs or Reports > Payroll > Pay Run Report.

2. Click the pay run number to display details of that pay run.

3. Click Export Results > Export As Deduction Bank File > Export.

The Deduction Bank File status will appear in the summary at the top of the Pay Run Details screen. This status will show as ‘Not Exported’ until the file is exported. After export, the status will summarise the export details in the format ‘Last Export dd/mm/yyyy hh:mm:ss by user.name’.

You can follow the same process for Supplier Pay Runs by navigating to Payroll > Process Payroll > Process Supplier Pay Runs or Reports > Payroll > Supplier Pay Run Report.

Reporting on Deduction Bank Files

The Export Report includes a list of all bank files that have been downloaded for the entity. Selecting ‘Deduction Bank Files’ from the Filter Results drop-down list will display all Deduction Bank Files records only. 

The Export Report contains an export date and time, as well as a link to the exported file.