Payroll Payment Listing

This report lists the net pay payments for the selected payroll, grouping them by payment method as currently set for the employee. The report can be used to obtain a listing of cheque numbers if cheques have been automatically generated into the accounts and subsequently need to be hand-written.

To focus on a particular pay run cheque list, set the relevant PAYE year, the pay interval and the PAYE period. Click the GENERATE button to produce the report.

Note that the download file is intended to form the basis of a file for transfer to BACS or an online banking payment service. It will only include items where the current payment method on the employee is BACS/Electronic transfer.

PAYE Year

The PAYE Year drop down list contains valid PAYE years that can be selected. PAYE years run from the 6th April to the following 5th April; So that PAYE Year 2015/2016 means from 6th April 2015 to 5th April 2016.

Pay Interval

Select the pay interval from the dropdown box. The pay interval relates to when payrolls are run.

PAYE Period

PAYE period is the week or month number which includes the date of payment. Weekly and monthly charts are published each PAYE year by the Inland Revenue. e.g. in 2004/2005 week 1 is 6th April to 12th April, month 1 is 6th April to 5th May.

Payment File Format

Payment files can be generated for employee, supplier and customer payments.

Select the most suitable format to use as a starting point for your electronic payment file. Please contact support@libertyaccounts.com if you need a different format for a specific online payment system operated by a major UK bank.

The BACS style files have dates and amounts formatted in the BACS style, but still need to be processed by your BACS software into proper BACS files.

Supplier Payments Generic Format

The following fields are generated in the unpaid bills download:

• Payment Date
• Originator Bank Sort Code
• Originator Bank Account Number
• Originator Bank Account Name
• Originator Reference - Supplier Invoice Number
• Supplier Bank Sort Code
• Supplier Bank Account Number
• Supplier Bank Account Name
• Supplier Reference - Supplier Invoice Number
• Amount (pounds.pence)

Supplier Payments BACS Style Data Format

The following fields are generated in the unpaid bills download:

• Supplier Bank Sort Code
• Supplier Bank Account Number
• Originator Bank Sort Code
• Originator Bank Account Number
• Amount (pence)
• Originator Bank Account Name
• Reference - Supplier Invoice Number
• Supplier Bank Account Name
• Payment Date in BACS processing date format

Supplier Payments Natwest Bankline Standard Payment Format

The records are as per the Natwest Bankline spec and include:

• Originator Reference - Supplier Invoice Number
• Originator Bank Sort Code+Originator Bank Account Number
• Amount (pounds.pence)
• Payment Date (ddmmyyyy)
• Supplier Bank Sort Code
• Supplier Bank Account Number
• Supplier Bank Account Name
• Supplier Reference - Supplier Invoice Number

Customer Payments Generic Format (preparatory to direct debit)

The following fields are generated in the open invoices download:

• Payment Date
• Originator Bank Sort Code
• Originator Bank Account Number
• Originator Bank Account Name
• Originator Reference - Customer Code from customer detail screen
• Customer Bank Sort Code
• Customer Bank Account Number
• Customer Bank Account Name
• Reference - Invoice Number
• Amount (pounds.pence)

Customer Payments BACS Style Data Format (preparatory to direct debit)

The following fields are generated in the open invoices download:

• Customer Bank Sort Code
• Customer Bank Account Number
• Originator Bank Sort Code
• Originator Bank Account Number
• Amount (pence)
• Originator Bank Account Name
• Reference - Customer Code from customer detail screen
• Customer Bank Account Name
• Payment Date in BACS processing date format

Payroll Payments Generic Format

The following fields are generated in the payroll payments download:

• Payment Date
• Originator Bank Sort Code
• Originator Bank Account Number
• Originator Bank Account Name
• Originator Reference - Payroll Reference
• Employee Bank Sort Code
• Employee Bank Account Number
• Employee Bank Account Name
• Reference - Business Name
• Amount (pounds.pence)

Payroll Payments BACS Style Data Format

The following fields are generated in the payroll payments download and should me mapped as required into your BACS software:

• Employee Bank Sort Code
• Employee Bank Account Number
• Originator Bank Sort Code
• Originator Bank Account Number
• Amount in pence
• Originator Bank Account Name
• RTI BACS Subreference if you pay by BACS via your own SUN number
• Originator Reference - the employee payroll reference
• Employee Bank Account Name
• Payment Date in BACS processing date format (spaces with 2 digit year then day of year)
• Payment Date in standard UK date format ("DD/MM/YYYY")
• Reference - Originator business name

Payroll Payments Natwest Bankline Standard Payment Format

The records are as per the Natwest Bankline spec and include:

• Originator Reference - Payroll Reference
• Originator Bank Sort Code+Originator Bank Account Number
• Amount (pounds.pence)
• Payment Date (ddmmyyyy)
• Employee Bank Sort Code
• Employee Bank Account Number
• Employee Bank Account Name
• Reference - Business Name

Payroll Payments Natwest Bankline Bulk List Template Format

The records are as per the Natwest Bankline spec and include an initial debit record with details of the originating account followed by the credit items with the following data:

• Originator Reference - Payroll Reference
• Employee Bank Sort Code
• Employee Bank Account Number
• Employee Bank Account Name
• Reference - Business Name

Payroll Payments Natwest Bankline Bulk List Payment Format

The records are as per the Natwest Bankline spec and include an initial debit record with details of the originating account followed by the credit items with the following data:

• Originator Reference - Payroll Reference
• Amount (pounds.pence)
• Employee Bank Sort Code
• Employee Bank Account Number
• Employee Bank Account Name
• Reference - Business Name

Payment File Originating Account

For payments to employees and suppliers specify the account from which funds paid.

For payments requested from customers (BACS direct debits) specify the account into which funds are received.

Payment File Processing Date

Enter or select the date on which the payment should be processed if this can be used by your payment processor.