History screens

In the Payroll Query Builder, the History screens contain any values that have been paid through Payroll before the current pay period.

Screen

Information

Car & Fuel History

Tax year, tax period, benefit type, engine size, make, model, CO2 emissions, fuel type etc.

Court Orders History

Tax year, tax period, order name, type, input amount, calculated amount, admin charge, protected earnings etc.

EYU NI Payments History

Tax year, NI category, field name, last submitted

EYU Statutory Payments History

Tax year, field name, last submitted, difference

General Ledger Costs History

Tax year, tax period, GL code in a particular period, debit and credit amount

NI History

Tax year, tax period, threshold amounts, employee and employer contribution amounts

Pay Elements History

Tax year, tax period, standard value, input value, rate value, calculated value, YTD figures at a point in time

Pay Record History

Tax year, tax period, starter/leaver this period, YTD figures at a point in time

Pensions History

Tax year, tax period, employee and employer contributions, calculated amounts, pensionable pay within a certain pay period

Shared Parental Pay History

Tax year, tax period, amount paid and amount recovered in a particular pay period

Statutory Adoption Pay History

Tax year, tax period, amount paid and amount recovered in a particular pay period

Statutory Maternity Pay History

Tax year, tax period, amount paid and amount recovered in a particular pay period

Statutory Paternity Pay History

Tax year, tax period, amount paid and amount recovered in a particular pay period

Statutory Paternity Pay (Additional)

Tax year, tax period, amount paid and amount recovered in a particular pay period

Statutory Sick Pay History

Tax year, tax period, daily rate, calculated value, SSP days

Vehicle Mileage History

Tax year, tax period, calculation method, HMRC bracket, input/rate/calculated value to date

Historic Data example query 1: Court order history

This query shows how much employees have paid against court orders in historic pay periods.

 

 

Historic Data example query 2: Pay elements history

This query provides a breakdown of loan payments made by employees during historic pay periods. If you want to see the variation in element amounts, you can also run this query on different pay elements.

 

 

 

Historic Data example query 3: Pensions history

This query shows employees’ pensionable pay, period-by-period.