Payroll Exports

Emily Garratley Updated by Emily Garratley

There are 4 Templates for extracting a Payroll Export controlled using a system setting "Payroll Batch Setup Extract Template". This will set the template by default in the Payroll Batch Setup record, this can be changed for each Payroll Batch Setup created. Template AdPay is only available when the "One Advanced Payroll Integration" Business Module is active.

Template 1

Payroll ID

Payroll Code

Quantity

Rate

Gross Amount

Employee

Payroll Batch Tab

Master Pay Arrangement

Break

13512

Care Hours

215.98

12

2592

Augustin Whimbrel

Booking Payments

Fern Avenue - Care

No

 

Template 2

Payroll ID

Payroll Code

Quantity

Rate

AI-1297

KLS TEST

2.50

135.00

Template 3

Payroll ID

Payroll Code

Quantity

Rate

Gross Amount

AI-1297

KLS TEST

3.00

135.00

405.00

Template AdPay

Payroll ID

Pay Element Ref

Amount

Rate of Pay

Cost Centre

Location

000112345

F400

20

11.44

CC101

Ivy view

Payroll ID

Can be set at a staff member or staff member contract level using the system setting "CareProvider_UsePayrollIDPerSystemUser"

Payroll Code

(Pay Element Ref in AdPay Template)

The code the amount needs to be reconciled against the external payroll solution / provider

Quantity

(Amount in AdPay Template)

The number of hours or units to be paid

Rate

(Rate of Pay in AdPay Template)

The rate of pay

Gross Amount

Result of the Quantity multiplied by the Rate

Employee

The employees Name

Payroll Batch Tab

Which tab from care cloud the entry relates (Booking Payments / Expenses / NMW Top Ups / Travel Reimbursements)

Master Pay Arrangement

The Master Pay Arrangement that has been used to apply the rate

Break

Does the entry represent a paid break (Yes / No)

Cost Centre

(AdPay Template Only)

The Cost Centre that the payment should be allocated to

Location

(AdPay Template Only)

The establishment location

There will be a line in the extract for each combination of Payroll ID, Payroll Code and Rate.

Was this article useful?

How to use Mail Merge to Download Gross Pay Advice(s)

Contact