The tables and variables available in Sage Report Designer

Summary

Where to find the tables and variables used by Sage Report Designer, in Sage 50 Payroll.

Description

If you work in the Sage Report Designer to create new reports or amend existing ones, you may need to find which table or variable to use to add the data you require to a report.

Click the sections of the window beneath and hover your cursor over the fields to find the variables and tables for each field. The section below covers the most commonly used variables.

NOTE: If there's a variable you need that this article doesn't cover, contact Sage technical support for help to locate it.

Resolution

By table

You can amend the information on your reports in Sage 50 Payroll by adding variables to them. When you add a variable, you need to add it from a table. To find out what each variable shows, choose the relevant table below.

AbsenceDiary
Variable	Location	Details
Day1-31	Employee > Employee Record > Absence	An alphabetic or numeric code that represents the type of absence for the relevant day of the month.
Month	Employee > Employee Record > Absence	Shows each month within the report's date range.
MonthIndex	Not shown in Sage 50 Payroll.	A monthly reference number. This starts with 0 for the first month of the date range for which you run the report, and increases by 1 for each further month.
Reference	Employee > Employee Record > Personal > Reference	The employee reference number.

AbsenceHistory
Variable	Location	Details
AbsCategory	Employee Record > Absence > Diary	Type of absence: 0 - S.S.P. 1 - Holiday 2 - Absence / Custom Absence Types
AbsenceType	Employee Record > Absence > Date	Secondary description of the absence.
AbsEndDate	Employee Record > Absence > Diary	End date of continuous absence of the same type.
AbsStartDate	Employee Record > Absence > Diary	Start date of continuous absence of the same type.
DateSetPermanent	Not shown in Sage 50 Payroll.	The processing date when the absence converted from temporary to permanent.
DiaryChar	Employee Record > Absence > Diary	Letter used in the absence diary to signify this type of absence.
HalfDayType	Employee Record > Absence > Diary	Length of absence status: 0 - Full day 1 - AM only 2 - PM only
Hourly	Not shown in Sage 50 Payroll.	Indicates if the holiday is entered in hours.
Narrative	Employee Record > Absence > Date	User defined comment on the absence.
NoOfDays	Not shown in Sage 50 Payroll.	Total number of days in continuous absence period.
NumberOfHours	Not shown in Sage 50 Payroll.	Total number of hours in continuous absence.
Reference	Employee Record > Personal > Reference	Employee reference number.

AbsenceSummary
Variable	Location	Details
Adoption	Employee Record > Absence > Other > Absence Year: Adoption - No. Of Days.	Number of days of adoption leave in the current tax year.
Authorised	Employee Record > Absence > Other > Absence Year: Authorised - No. Of Days.	Number of days authorised absence in the current date year.
Compassionate	Employee Record > Absence > Other > Absence Year: Compassionate - No. Of Days.	Number of days compassionate leave in the current tax year.
Custom1-9	Not shown in Sage 50 Payroll.	Number of days absent for the specified custom absence type.
Educational	Employee Record > Absence > Other > Absence Year: Educational - No. Of Days.	Number of days absent on educational leave in the current tax year.
Employment	Employee Record > Absence > Other > Absence Year: Suspension - No. Of Days.	Number of days absent due to suspension in the current tax year.
Jury	Employee Record > Absence > Other > Absence Year: Jury - No. Of Days.	Number of days absent for jury duty in the current tax year.
Maternity	Employee Record > Absence > Other > Absence Year: Maternity - No. Of Days.	Number of days absent for maternity leave in the current tax year.
Medical	Employee Record > Absence > Other > Absence Year: Medical - No. Of Days.	Number of days medical absence in the current tax year.
OtherTotal	Not shown in Sage 50 Payroll.	Number of days absent under the reason Other. This covers all the other absence types.
Paternity	Employee Record > Absence > Other > Absence Year: Paternity - No. Of Days.	Number of days absent for paternity leave in the current tax year.
Punctuality	Employee Record > Absence > Other > Absence Year: Punctuality - No. Of Days	Number of days absent due to punctuality in the current tax year.
Reference	Employee Record > Personal > Reference.	Employee reference number.
Unauthorised	Employee Record > Absence > Other > Absence Year: Unauthorised - No. Of Days.	Number of days unauthorised absence in the current tax year.

Appraisals
Variable	Location	Details
DateOfAppraisal	Employee > Personnel Record > Appraisal Record > Date of Appraisal	The date of the appraisal.
Instance	Not shown in Sage 50 Payroll.	An internal reference, which increases by 1 for each new appraisal record.
NextAppraisal	Employee > Personnel Record > Appraisal Record > Next Appraisal	The date of the next appraisal.
NextInterimReview	Employee > Personnel Record > Appraisal Record > Next Interim Review	The date of the next interim review.
Notes	Employee > Personnel Record > Appraisal Record > Next Interim Review	Any notes about the appraisal.
Reference	Employee > Employee Record > Personal > Reference	The employee reference number.
ReviewedBy	Employee > Personnel Record > Appraisal Record > Reviewed By	The name of the person who did the appraisal.

NOTE: This table is currently not available in the Historical Data or post-update reports areas. For further information please refer to article .

AttachmentAnalysis
Variable	Location	Details
Desc1 - Desc12	Company > Custom Reports > New / Edit > Attachments > Attachment Type	Description of the attachment type.
NumItems	Not shown in Sage 50 Payroll.	The number of active payment elements in the Employee Record > Employment> Pay Elements > Attachments.
Reference	Employee Record > Personal > Reference	Employee reference number.
Total1 - Total12	Enter Payments > Attachments > Amount Deducted	Amount deducted in the current period for the attachment type.
TotalTD1 - TotalTD12	Enter Payments > Attachments > Amount Deducted	Total year to date value for the attachment.

AttachmentBands
Variable	Location	Details
AdminCharged	Pay Elements > Attachments > Admin Fee.	Whether an administration fee is chargeable for this attachment type. 0 - No 1 - Yes
AdminCost	Not shown in Sage 50 Payroll.	The value of administration fee chargeable.
AltDescription	Pay Elements > Attachments > Replacement Description or Employee Record > Employment > Pay Elements > Attachments > Attachment Name or Employee Record > Employment > YTD Values > Attachment > Attachment Name	An alternative user defined description for the attachment of earnings order.
AttachEarningsTo	Not shown in Sage 50 Payroll.	The upper limit for attachable earnings.
AttachReference	Pay Elements > Attachments > Ref.	The reference number for the attachment type. This is set at a company level, and can be one of the following: 1 - 1971 Priority 2 - Child Support 3 - DEO 4 - 1971 Non-Priority 5 - Pre 92 CCAEO 6 - Post 92 CCAEO 7 - CTAEO 8 - Earnings Arrest 9 - CMA 10 - CAO 11 - ISDN This is an automatic reference which you can't amend.
AttType	Not shown in Sage 50 Payroll.	Whether the deduction is a percentage of attachable earnings or a fixed amount.
CalcStatus	Not in use.	Not in use.
CustomReportOrder	Custom Reports > New/Edit > Attachments > Index.	The index number of the attachment type in the custom report setting.
Deduction	Not shown in Sage 50 Payroll.	The value of the attachment to deduct if the earnings are up to the limit of the AttachEarningsTo variable.
DefaultDescription	Pay Elements > Attachments > Standard Description or Employee Record > Employment > YTD Values > Attachments > Attachment Name	The standard description for the attachment of earnings order.
EffectiveFrom	Not shown in Sage 50 Payroll.	The date when the attachment band became effective.
IsPercentage	Not shown in Sage 50 Payroll.	A flag to indicate whether the value is calculated as a percentage.
MinimumDeduction	Not shown in Sage 50 Payroll.	The minimum deduction amount for the attachment.
PayPeriod	Not shown in Sage 50 Payroll.	A flag illustrating the payment period: 0 - Weekly 1 - Monthly

AttachmentHistory
Variable	Location	Details
AdminCostCharged	Not shown in Sage 50 Payroll.	The value of administration cost for particular attachments, if applicable, for each updated period. You can view whether the attachment has an administration fee through Company > Pay Elements > Attachments > Admin Fee.
AdminCostTD	Not shown in Sage 50 Payroll.	YTD value of any administration costs for the attachment.
AltDescription	Pay Elements > Attachments > Replacement Description	Any alternative description for the Attachment of Earnings order.
AmtDednCur	Not shown in Sage 50 Payroll.	The value of the attachment deducted in the current period.
AmtDednHol	Not shown in Sage 50 Payroll.	The value of the attachment deducted in each advanced period.
AmtPercCur	Not shown in Sage 50 Payroll.	The amount of attachment or percentage used in each current updated period for each attachment.
AmtPercHol	Not shown in Sage 50 Payroll.	The amount of attachment or percentage used in each advanced period for each attachment.
AttachCF	Not shown in Sage 50 Payroll.	Any value carried forward at the end of an updated period.
AttachCFCur	Not shown in Sage 50 Payroll.	Any attachment carried forward at the end of the current period.
AttachEarnsCur	Not shown in Sage 50 Payroll.	Attachable earnings in the current period for each attachment.
AttachEarnsHol	Not shown in Sage 50 Payroll.	Attachable earnings in each advanced period for each attachment.
AttachmentInstance	Not shown in Sage 50 Payroll.	A unique numeric reference for the attachment type. This is taken from the order that the attachment types are set up in the employee record.
AttachReference	Pay Elements > Attachments > Ref.	The reference number for the attachment type. This is set at a company level, and can be one of the following: 1 - 1971 Priority 2 - Child Support 3 - DEO 4 - 1971 Non-Priority 5 - Pre 92 CCAEO 6 - Post 92 CCAEO 7 - CTAEO 8 - Earnings Arrest 9 - CMA 10 - CAO 11 - ISDN This is an automatic reference which you can't amend.
AttachTD	Not shown in Sage 50 Payroll.	The total value of the attachment to date at the end of each updated period.
CalcPriority	Not shown in Sage 50 Payroll.	Where there are insufficient attachable earnings, the priority by which the attachments have been deducted.
CourtReference	Not shown in Sage 50 Payroll.	The attachment reference as stipulated by the court order.
DefaultDescription	Pay Elements > Attachments > Standard Description	The standard description for the attachment of earnings order. This is an automatic description and can't be amended.
HistoryRef	Not shown in Sage 50 Payroll.	A three part reference made up of the employee reference and the first and last dates of the updated pay period.
OrderIssuedDate	Not shown in Sage 50 Payroll.	Date on which the court order was made.
PredTotalAmt	Not shown in Sage 50 Payroll.	The date on which the employee's pay was processed for each updated period.
ProtdEarns	Not shown in Sage 50 Payroll.	Any earnings protected by the court to ensure that the employee has enough take home pay. This value is deducted from attachable earnings in calculating whether the employee has enough attachable earnings to deduct the attachment. This is only applied to attachments 1, 2, 3. 4 and 11.
ProtdEarnsCF	Not shown in Sage 50 Payroll.	Protected earnings carried forward at the end of each updated period for each attachment where the employee's pay is insufficient to cover the level of protected earnings set by the court order.
ProtdEarnsCFCur	Not shown in Sage 50 Payroll.	Protected earnings carried forward at the end of each updated period where the protected earnings in the current period are more than the attachable earnings.
ProtdEarnsCur	Not shown in Sage 50 Payroll.	The total protected earnings used in the current updated period including any brought forward amounts for each attachment.
ProtdEarnsHol	Not shown in Sage 50 Payroll.	The total protected earnings used in each advanced period, including any brought forward amounts for each attachment.
TotalAmtDedn	Not in use.	Not in use.
TotalAttachEarns	Not in use.	Not in use.
TotalDeductedTD	Not shown in Sage 50 Payroll.	The total value of the attachment deducted to date for each updated period for each attachment.
TotalProtdEarns	Not in use.	Not in use.

AttachmentTypes
Variable	Location	Details
AdminCharged	Pay Elements > Attachments > Admin Fee.	Whether an administration fee is chargeable for this attachment type. 0 - No 1 - Yes
AdminCost	Not shown in Sage 50 Payroll.	The value of administration fee chargeable.
AltDescription	Pay Elements > Attachments > Replacement Description or Employee Record > Employment > Pay Elements > Attachments > Attachment Name or Employee Record > Employment > YTD Values > Attachment > Attachment Name	An alternative user defined description for the attachment of earnings order.
AttachReference	Pay Elements > Attachments > Ref	The reference number of the attachment.
AttType	Not shown in Sage 50 Payroll.	Whether the deduction is a percentage of attachable earnings or a fixed amount.
CalcStatus	Not in use.	Not in use.
CustomReportOrder	Custom Reports > New/Edit > Attachments > Index.	The index number of the attachment type in the custom report setting.
DefaultDescription	Pay Elements > Attachments > Standard Description or Employee Record > Employment > YTD Values > Attachments > Attachment Name	The standard description for the attachment of earnings order.

CashAnalysis
Variable	Location	Details
CashValue1	Not shown in Sage 50 Payroll.	The numeric value for the highest active denomination in making up each employee's net pay.
CashValue10	Not shown in Sage 50 Payroll.	The numeric value for the tenth highest active denomination in making up each employee's net pay.
CashValue11	Not shown in Sage 50 Payroll.	The numeric value for the eleventh highest active denomination in making up each employee's net pay.
CashValue12	Not shown in Sage 50 Payroll.	The numeric value for the twelfth highest active denomination in making up each employee's net pay.
CashValue2	Not shown in Sage 50 Payroll.	The numeric value for the second highest active denomination in making up each employee's net pay.
CashValue3	Not shown in Sage 50 Payroll.	The numeric value for the third highest active denomination in making up each employee's net pay.
CashValue4	Not shown in Sage 50 Payroll.	The numeric value for the fourth highest active denomination in making up each employee's net pay.
CashValue5	Not shown in Sage 50 Payroll.	The numeric value for the fifth highest active denomination in making up each employee's net pay.
CashValue6	Not shown in Sage 50 Payroll.	The numeric value for the sixth highest active denomination in making up each employee's net pay.
CashValue7	Not shown in Sage 50 Payroll.	The numeric value for the seventh highest active denomination in making up each employee's net pay.
CashValue8	Not shown in Sage 50 Payroll.	The numeric value for the eighth highest active denomination in making up each employee's net pay.
CashValue9	Not shown in Sage 50 Payroll.	The numeric value for the ninth highest active denomination in making up each employee's net pay.
NetPay	Payroll > Enter Payments > Net Pay	The employee's net pay for the current period.
Qty1	Not shown in Sage 50 Payroll.	The number of notes or coins for the highest active denomination in making up each empoyee's net pay.
Qty10	Not shown in Sage 50 Payroll.	The number of notes or coins for the tenth highest active denomination in making up each employee's net pay.
Qty11	Not shown in Sage 50 Payroll.	The number of notes or coins for the eleventh highest active denomination in making up each employee's net pay.
Qty12	Not shown in Sage 50 Payroll.	The number of notes or coins for the twelfth highest active denomination in making up each employee's net pay.
Qty2	Not shown in Sage 50 Payroll.	The number of notes or coins for the second highest active denomination in making up each employee's net pay.
Qty3	Not shown in Sage 50 Payroll.	The number of notes or coins for the third highest active denomination in making up each employee's net pay.
Qty4	Not shown in Sage 50 Payroll.	The number of notes or coins for the fourth highest active denomination in making up each employee's net pay.
Qty5	Not shown in Sage 50 Payroll.	The number of notes or coins for the fifth highest active denomination in making up each employee's net pay.
Qty6	Not shown in Sage 50 Payroll.	The number of notes or coins for the sixth highest active denomination in making up each employee's net pay.
Qty7	Not shown in Sage 50 Payroll.	The number of notes or coins for the seventh highest active denomination in making up each employee's net pay.
Qty8	Not shown in Sage 50 Payroll.	The number of notes or coins for the eighth highest active denomination in making up each employee's net pay.
Qty9	Not shown in Sage 50 Payroll.	The number of notes or coins for the ninth highest active denomination in making up each employee's net pay.
Reference	Employee > Employee Record > Personal > Reference	The employee reference number.
Section	Not shown in Sage 50 Payroll.	A coded variable showing how the variables are used on the report. 1 - Details 2 - Totals
Total	Not shown in Sage 50 Payroll.	The total number of notes and coins required to make up the employee's net pay.
TotalNetPay	Not shown in Sage 50 Payroll.	The total numeric value required to make up the employee's net pay.

CompanyDetails
Variable	Location	Details
AbsYearStartDate	Company > Settings > Absence > Absence Year > Start of Year	The start date of the absence year for SSP purposes.
AccountType	Company > Settings > Bank > Account Details > Account Type	The company's account type, either Bank Account or Building Society Account.
AddAbsCommentFlag	Company > Settings > Details > Add absence comment	A flag indicating whether absence comments are added to the absence diary. 0 - No 1 - Yes
Addr1	Company > Settings > Details > Company Details > Address	The first line of the company address.
Addr2	Company > Settings > Details > Company Details > Address	The second line of the company address.
Addr3	Company > Settings > Details > Company Details > Address	The third line of the company address.
Addr4	Company > Settings > Details > Company Details > Address	The fourth line of the company address.
Addr5	Company > Settings > Details > Company Details > Address	The fifth line of the company address.
AdviseVariances	Company > Variance Settings > Settings > Advise when variances occur	A flag indicating whether a message appears to advise of variances when you open Pre-update Reports. 0 - No 1 - Yes
Analysis1	Company > Settings > Analysis > Employee Analysis > Analysis 1	The custom title for the Analysis 1 box. This changes the title of the box in Employee > Employee Record > Analysis > Employee Analysis.
Analysis2	Company > Settings > Analysis > Employee Analysis > Analysis 2	The custom title for the Analysis 2 box. This changes the title of the box in Employee > Employee Record > Analysis > Employee Analysis.
Analysis3	Company > Settings > Analysis > Employee Analysis > Analysis 3	The custom title for the Analysis 3 box. This changes the title of the box in Employee > Employee Record > Analysis > Employee Analysis.
AutoAdvanceNetToGross	Company > Settings > Details > Settings > Auto Advance Net to Gross Employees	A flag indicating whether pay for net to gross employees is advanced automatically. 0 - No 1 - Yes
AutoNICHolFlag	This variable is no longer used.	This variable is no longer in use.
AutoUpdateDiaryFlag	Company > Settings > Details > Settings > Update Absence Diary Automatically	A flag indicating whether the absence diary is automatically updated with any holiday or maternity days that have been taken up to and including the current processing date. 0 - No 1 - Yes
BACSReference	Company > Settings > Bank > BACS/Automated Credit Transfer > Reference	The company's unique eight digit automated credit transfer number.
BankAcctName	Company > Settings > Bank > Account Details > Account Name	The company's bank account name.
BankAcctNumber	Company > Settings > Bank > Account Details > Account No.	The company's bank account number.
BankAddress1	Company > Settings > Bank > Bank Details > Address	The first line of the address for the company bank account.
BankAddress2	Company > Settings > Bank > Bank Details > Address	The second line of the address for the company bank account.
BankAddress3	Company > Settings > Bank > Bank Details > Address	The third line of the address for the company bank account.
BankAddress4	Company > Settings > Bank > Bank Details > Address	The fourth line of the address for the company bank account.
BankAddress5	Company > Settings > Bank > Bank Details > Address	The fifth line of the address for the company bank account.
BankEMail	Company > Settings > Bank > Bank Details > E-Mail	The email address for the company's bank.
BankFax	Company > Settings > Bank > Bank Details > Facsimile	The fax number for the company's bank.
BankName	Company > Settings > Bank > Bank Details > Bank Name	The name of the company's bank.
BankPostCode	Company > Settings > Bank > Bank Details > Post Code	The postcode of the company's bank.
BankTelephone	Company > Settings > Bank > Bank Details > Telephone	The telephone number of the company's bank.
BIC	Company > Settings > Bank > Bank Details > BIC	The Bank Identifier Code (BIC) for the company's bank.
BldSocNumber	Company > Settings > Bank > Account Details > B/Soc. Roll No.	The company's building society roll number. NOTE: This box is only active if the account type is Building Society Account.
CashRound	Company > Settings > Details > Settings > Cash Rounding Amount	The value to which payments will be rounded for employees who are paid in cash. This can be either a positive or negative amount from -10.00 to 10.00. A positive value rounds the employee's pay up to the nearest multiple, a negative value rounds the pay down to the nearest multiple.
CessationDate
ClearEnterPaymentNotes	Company > Settings > Details > Clear Enter Payment Notes on Update Records	Indicates whether the enter payment notes should be cleared once the payroll is updated for the period.
CsaReference
CustomAbsence1	Company > Settings > Absence > Custom Absence Reasons > Description 1	The first custom absence reason.
CustomAbsence3	Company > Settings > Absence > Custom Absence Reasons > Description 2	The second custom absence reason.
CustomAbsence3	Company > Settings > Absence > Custom Absence Reasons > Description 3	The third custom absence reason.
CustomAbsence4	Company > Settings > Absence > Custom Absence Reasons > Description 4	The fourth custom absence reason.
CustomAbsence5	Company > Settings > Absence > Custom Absence Reasons > Description 5	The fifth custom absence reason.
CustomAbsence6	Company > Settings > Absence > Custom Absence Reasons > Description 6	The sixth custom absence reason.
CustomAbsence7	Company > Settings > Absence > Custom Absence Reasons > Description 7	The seventh custom absence reason.
CustomAbsence8	Company > Settings > Absence > Custom Absence Reasons > Description 8	The eighth custom absence reason.
CustomAbsence9	Company > Settings > Absence > Custom Absence Reasons > Description 9	The ninth custom absence reason.
CustomReportSettings	Company > Custom Reports > Current Custom Report Settings	The current default custom report setting.
DefaultStatement	Employee > Statement of Employment > Templates > Description.	The description of the default statement of employment.
DSSAddr1	Help > Contacts > NIC Office > Address of local department	The first line of the address for the local HMRC NI Contributions office.
DSSAddr2	Help > Contacts > NIC Office > Address of local department	The second line of the address for the local HMRC NI Contributions office.
DSSAddr3	Help > Contacts > NIC Office > Address of local department	The third line of the address for the local HMRC NI Contributions office.
DSSAddr4	Help > Contacts > NIC Office > Address of local department	The fourth line of the address for the local HMRC NI Contributions office.
DSSAddr5	Help > Contacts > NIC Office > Address of local department	The fifth line of the address for the local HMRC NI Contributions office.
DSSContact	Help > Contacts > NIC Office > Contact Name	The name of the contact at the local HMRC NI Contributions office.
DSSEmail	Help > Contacts > NIC Office > EMail Address	The email address of the local HMRC NI Contributions office.
DSSFax	Help > Contacts > NIC Office > Fax Number	The fax number of the local HMRC NI Contributions office.
DSSPostcode	Help > Contacts > NIC Office > Post Code	The postcode of the local HMRC NI Contributions office.
DSSRef	Help > Contacts > NIC Office > Reference Number	The reference number of the local HMRC NI Contributions office.
DSSTel	Help > Contacts > NIC Office > Telephone No.	The telephone number of the local HMRC NI Contributions office.
EBankComponent	Company > Settings > Bank > BACS/Automated Credit Transfer	The name of the e-banking component used by the company.
ECON	Company > Settings > Details > Company Details > ECON	The employer's contracted out number.
EMail	Company > Settings > Details > Company Details > E-Mail	The company's email address.
Fax	Company > Settings > Details > Company Details > Facsimile	The company's fax number.
FirstCheque	Not shown in Sage 50 Payroll.	The first cheque number recorded in the software.
ForecastByCV	Company > Salary Review > Forecast based upon > Current Values / Last Update Values	A flag indicating whether the forecast is based on the current values from Enter Payments or the values for the last updated period. 0 - Current values 1 - Last update values
HolYearStartDate	Company > Settings > Absence > Holiday Year > Start of Year	The start date of the holiday year.
IBAN	Company > Settings > Bank > Account Details > IBAN	The company's International Bank Account Number.
IncStatWkFlag
IRAddr1	Help > Contacts > PAYE Office > Address of local department	The first line of the address for the local tax office.
IRAddr2	Help > Contacts > PAYE Office > Address of local department	The second line of the address for the local tax office.
IRAddr3	Help > Contacts > PAYE Office > Address of local department	The third line of the address for the local tax office.
IRAddr4	Help > Contacts > PAYE Office > Address of local department	The fourth line of the address for the local tax office.
IRAddr5	Help > Contacts > PAYE Office > Address of local department	The fifth line of the address for the local tax office.
IRBankAccName	Company > Settings > HMRC Payments > HMRC Bank Account Details > Account Name	The account name of the collection office for payments of tax and NIC. This area is automatically completed when you select the accounts office.
IRBankAccNumber	Company > Settings > HMRC Payments > HMRC Bank Account Details > Account No.	The account number of the collection office for payments of tax and NIC. This area is automatically completed when you select the accounts office.
IRBankAccOfficeName	Company > Settings > HMRC Payments > HMRC Bank Account Details > Accounts Office	The name of the collection office for payments of tax and NIC. This area is automatically completed when you select the accounts office.
IRBankAccSortCode	Company > Settings > HMRC Payments > HMRC Bank Account Details > Bank Sort Code	The bank sort code for payments of tax and NIC. This area is automatically completed when you select the accounts office.
IRContact	Help > Contacts > PAYE Office > Contact Name	The name of the contact at the local tax office.
IREMail	Help > Contacts > PAYE Office > EMail Address	The email address of the local tax office.
IRFax	Help > Contacts > PAYE Office > Fax Number	The fax number of the local tax office.
IRPostcode	Help > Contacts > PAYE Office > Post Code	The postcode of the local tax office.
IRReference_2	Company > Settings > HMRC Payments > Accounts Office Reference	The middle section of the HM Revenue and Customs reference number for payment to the Collector of Taxes.
IRReference_3	Company > Settings > HMRC Payments > Accounts Office Reference	The third section of the HM Revenue and Customs reference number for payment to the Collector of Taxes.
IRTel	Help > Contacts > PAYE Office > Telephone No.	The telephone number of the local tax office.
MergedData	Not shown in Sage 50 Payroll.
MinimumWageOptOut	Company > Legislation > Minimum Wage > I want to opt out of Minimum Wage validation	Indicates whether the minimum wage validation is enabled.
MultipleYTDsExist	Not shown in Sage 50 Payroll.	A flag to indicate whether the software contains more than one tax year.
Name	Company > Settings > Details > Company Details > Name	The company's name.
NationalHolidays	Company > Holidays > National Holidays > Area	Indicates which national holidays are used in the software. This can be any of the following: 1 - England 2 - Northern Ireland 4 - Scotland 8 - Wales 16 - Custom
NatWestBanklineRef	Company > Settings > Details > Company Details > Name	The four digit reference used with Collector of Taxes if the e-banking component is Natwest Bankline.
NetOfForeignTax	Awaiting information.	Awaiting information.
NextCheque	Not shown in Sage 50 Payroll.	The next cheque number to be used by the software.
NLinkBlankOverride	Company > Nominal Settings > Defaults > Overrides may replace Dept/CC information with blanks	A flag showing whether to use the department and cost centre information set in the overrides. 0 - No 1 - Yes
NNLinkCCOverride	Company > Nominal Settings > Defaults > Override by Cost Centre or Department	A flag showing whether the profit and loss and balance sheet postings can be overridden by department or cost centre. 0 - Department 1 - Cost Centre
NLinkDataPath
NLinkDestination	Company > Nominal Settings > Defaults > Destination	The accounts package to which you export information using the nominal link. 0 - Instant Accounts / Sage 50 Accounts data 1 - Sage 200 Accounts data 2 - Export to file 3 - TAS Accounts data
NLinkEEDataBS	Not shown in Sage 50 Payroll.	Indicates whether to take the department from the employee record for balance sheet categories, where no department is specified.
NlinkEEDataBSCC	Not shown in Sage 50 Payroll.	Indicates whether to take the cost code from the employee record for balance sheet categories, where no cost code is specified.
NLinkDDDataPNL	Not shown in Sage 50 Payroll.	Indicates whether to take the department from the employee record for profit and loss categories, where no department is specified.
NLinkEEDataPNLCC	Not shown in Sage 50 Payroll.	Indicates whether to take the cost code from the employee record for profit and loss categories, where no cost code is specified.
NLinkEnabled	Company > Nominal Settings > Defaults > Use Nominal Link	A flag indicating whether the nominal link function is enabled. 0 - No 1 - Yes
NLinkPath	Company > Nominal Settings > Defaults > Destination > Path to Company File	The path to the company file used for the nominal link when the Instant Accounts / Sage 50 Accounts data option is selected.
NLinkUseFunds	Not shown in Sage 50 Payroll.	Indicates whether the nominal link should use the Funds option in Sage 50 Accounts.
NLTransReference
OnlineUpdateCheck	Company > Legislation > PAYE > Check for online legislation updates	A flag indicating whether legislation should be checked before using the Enter Payments option. 0 - No 1 - Yes
OnlineUpdatePrompt	Company > Legislation > PAYE > Prompt before performing check	A flag indicating whether a prompt to check for online legislation updates should appear when you select Enter Payments. 0 - No 1 - Yes
PayrollId	Company > Pension Schemes > Additional Info > Payroll Id	An optional reference to identify specific payrolls where there are many submissions of payments to the pension provider.
Postcode	Company > Settings > Details > Company Details > Post Code	The company's postcode.
RetireFemale	Company > Settings > Details > Settings	The default retirement age for female employees.
RetireMale	Company > Settings > Details > Settings	The default retirement age for male employees.
SageAddr1	Help > Contacts > Sage	The first line of the Sage office address.
SageAddr2	Help > Contacts > Sage	The second line of the Sage office address.
SageAddr3	Help > Contacts > Sage	The third line of the Sage office address. NOTE: This variable is currently blank as only the first two lines of the address are in use.
SageAddr4	Help > Contacts > Sage	The fourth line of the Sage office address. NOTE: This variable is currently blank as only the first two lines of the address are in use.
SageAddr5	Help > Contacts > Sage	The fifth line of the Sage office address. NOTE: This variable is currently blank as only the first two lines of the address are in use.
SageEMail	Help > Contacts > Sage	The email address for Sage support.
SageFax	Help > Contacts > Sage	The fax number for Sage support.
SagePostCode	Help > Contacts > Sage	The postcode for the Sage office address.
SageTel	Help > Contacts > Sage	The telephone number for the Sage office.
ShowZeroVal	Company > Settings > Details > Settings > Show Zero Values on Payslip	A flag indicating whether pay elements appear on a payslip where there is no value for the pay element in the Enter Payments window. 0 - No 1 - Yes
SortCode	Company > Settings > Bank > Account Details > Bank Sort Code	The company's bank sort code.
StoreHistData	Company > Settings > Details > Settings > Store Historical Data (Years)	The number of years for which historical data should be stored in the software.
TaxDistrict	Company > Settings > Details > Company Details > Tax Dist.	The local tax district.
TaxOfficeName	Company > Settings > Details > Company Details > Tax Off. Name	The local tax office name.
TaxRef	Company > Settings > Details > Company Details > Ref.	The local tax district.
Tel	Company > Settings > Details > Company Details > Telephone	The company's telephone number.
UseOldSSPEntry	Company > Settings > Use Old Style SSP Entry in Enter Payments	A flag showing whether the SSP entry in Enter Payments should use the same format as Sage 50 Payroll 2009 and below.
V52DiaryStyleFlag	Company > Settings > Details > Settings > Old style Absence Diary	A flag indicating whether the absence diary should be viewed in the old format. 0 - No 1 - Yes
VarianceBasedAvePay	Company > Variance Settings > Settings > Variance based upon > Average Pay	A flag indicating whether the variance settings are based on average pay. 0 - No 1 - Yes
VarianceBasedLastUpdate	Company > Variance Settings > Settings > Variance based upon > Last Update Values	A flag indicating whether the variance settings are based on the last updated values. 0 - No 1 - Yes
VarianceBasis	Company > Variance Settings > Settings > Variance based upon.	Text showing the basis of the variance settings. Average Pay Last Update Values

CompanyQDPatterns
QDayReference	Not shown in Sage 50 Payroll.	An internal band identifier, starting with 1.
SunToSatPattern	Company > Settings > Absence > SSP/Holiday Working Patterns > Sunday - Saturday	The weekly qualifying day patterns for holiday and sickness. N - A non-qualifying day Q - A qualifying day

CompanyQDPatterns

Variable

Location

Details

QDayReference

Not shown in Sage 50 Payroll.

An internal band identifier, starting with 1.

SunToSatPattern

Company > Settings > Absence > SSP/Holiday Working Patterns > Sunday - Saturday

The weekly qualifying day patterns for holiday and sickness.

N - A non-qualifying day
Q - A qualifying day

ContactAddress
Variable	Location	Details
DSSAddr1	Help > Contacts > NIC Office > Address of local department	The first line of the address for the local HMRC NI Contributions office.
DSSAddr2	Help > Contacts > NIC Office > Address of local department	The second line of the address for the local HMRC NI Contributions office.
DSSAddr3	Help > Contacts > NIC Office > Address of local department	The third line of the address for the local HMRC NI Contributions office.
DSSAddr4	Help > Contacts > NIC Office > Address of local department	The fourth line of the address for the local HMRC NI Contributions office.
DSSAddr5	Help > Contacts > NIC Office > Address of local department	The fifth line of the address for the local HMRC NI Contributions office.
DSSContact	Help > Contacts > NIC Office > Contact Name	The name of the contact at the local HMRC NI Contributions office.
DSSEMail	Help > Contacts > NIC Office > EMail Address	The email address of the local HMRC NI Contributions office.
DSSFax	Help > Contacts > NIC Office > Fax Number	The fax number of the local HMRC NI Contributions office.
DSSPostcode	Help > Contacts > NIC Office > Post Code	The postcode of the local HMRC NI Contributions office.
DSSRef	Help > Contacts > NIC Office > Reference Number	The reference number of the local HMRC NI Contributions office.
DSSTel	Help > Contacts > NIC Office > Telephone No.	The telephone number of the local HMRC NI Contributions office.
IRAddr1	Help > Contacts > PAYE Office > Address of local department	The first line of the address for the local tax office.
IRAddr2	Help > Contacts > PAYE Office > Address of local department	The second line of the address for the local tax office.
IRAddr3	Help > Contacts > PAYE Office > Address of local department	The third line of the address for the local tax office.
IRAddr4	Help > Contacts > PAYE Office > Address of local department	The fourth line of the address for the local tax office.
IRAddr5	Help > Contacts > PAYE Office > Address of local department	The fifth line of the address for the local tax office.
IRContact	Help > Contacts > PAYE Office > Contact Name	The name of the contact at the local tax office.
IREMail	Help > Contacts > PAYE Office > EMail Address	The email address of the local tax office.
IRFax	Help > Contacts > PAYE Office > Fax Number	The fax number of the local tax office.
IRPostcode	Help > Contacts > PAYE Office > Post Code	The postcode of the local tax office.
IRTel	Help > Contacts > PAYE Office > Telephone No.	The telephone number of the local tax office.
SageAddr1	Help > Contacts > Sage	The first line of the Sage office address.
SageAddr2	Help > Contacts > Sage	The second line of the Sage office address.
SageAddr3	Help > Contacts > Sage	The third line of the Sage office address. NOTE: This va NOTE: riable is currently blank as only the first two lines of the address are in use.
SageAddr4	Help > Contacts > Sage	The fourth line of the Sage office address. NOTE: This variable is currently blank as only the first two lines of the address are in use.
SageAddr5	Help > Contacts > Sage	The fifth line of the Sage office address. NOTE: This variable is currently blank as only the first two lines of the address are in use.
SageEMail	Help > Contacts > Sage	The email address for Sage support.
SageFax	Help > Contacts > Sage	The fax number for Sage support.
SagePostCode	Help > Contacts > Sage	The postcode for the Sage office address.
SageTel	Help > Contacts > Sage	The telephone number for the Sage office.
TaxRef	Help > Contacts > PAYE Office > Reference Number	The company's HMRC tax reference.

CostCentres
Variable	Location	Details
CCName	Company > Settings > Analysis > Cost Centres > Name	The cost centre name.
CCReference	Company > Settings > Analysis > Cost Centres > Ref.	The cost centre reference.

CurrentPay
Variable	Location	Details
AddPayTD	Not shown in Sage 50 Payroll.	Additional pay for the employee in the full tax year to date, up to and including the current period.
AdjustedTaxPaid	Awaiting information.	Awaiting information.
AdjustedTaxPaidTD	Awaiting information.	Awaiting information.
AdjustTaxPayTD	Payroll > Enter Payments > Information > Income Tax > Taxable Pay To Date	Adjusted taxable pay for the employee in the full tax year to date, up to and including the current period.
ASPPAPaid	Payroll > Enter Payments > Information > Statutory Payments > ASPP Current Period	The additional statutory paternity pay for adoption paid to the employee in the current period.
ASPPAWeeksCurrentlyDue	Employee > Employee Record > Absence > SPP(A) > Entitlement > Details > Currently Due > Weeks	The number of weeks for which ASPP(A) is paid in the current period.
ASPPAWks	Employee > Employee Record > Absence > SPP(A) > Entitlement > Details > Currently Due > Weeks	The number of weeks for which ASPP(A) is paid in the current period.
ASPPNICComp	Not shown in Sage 50 Payroll.	The value of NI contributions that can be reclaimed on ASPP recovered for the employee in the current period.
ASPPPaid	Payroll > Enter Payments > Information > Statutory Payments > SPP Current Period	The additional statutory paternity pay for the employee in the current period.
ASPPRecovd	Not shown in Sage 50 Payroll.	The value of ASPP that can be reclaimed against the employee in the current period.
ASPPWeeksCurrentlyDue	Employee > Employee Record > Absence > SPP > Entitlement > Details > Currently Due > Weeks	The number of weeks for which ASPP is paid in the current period.
ASPPWks	Employee > Employee Record > Absence > SPP > Entitlement > Details > Currently Due > Weeks	The number of weeks for which ASPP is paid in the current period.
AVCAmountCur	Payroll > Enter Payments > Summary > Pensions > AVC (Current Period)	The employee's AVC for all pension schemes in the current period.
AVCAmountHol	Payroll > Enter Payments > Summary > Pensions > AVC (Advanced Period)	The employee's AVC for all pension schemes in the advanced period.
CashRndBF	Payroll > Enter Payments > Summary > Total Net Pay > Rounding B/F	Any values brought forward from the previous updated period for cash rounding purposes.
CashRndCF	Payroll > Enter Payments > Summary > Total Net Pay > Rounding C/F	Any values carried forward to the previous updated period for cash rounding purposes.
ChequeNo	Not shown in Sage 50 Payroll.	The last cheque number recorded for the employee.
ConOutFlag	Payroll > Enter Payments > Information > National Insurance > Current NI Category	A flag showing whether the NI category for the employee is contracted out for the current period. 0 - No 1 - Yes
ConOutNICEarns	This variable isn't in use.	This variable isn't in use.
ConOutNICEmployee	This variable is not in use.	This variable isn't in use.
CostOfNetPay	Payroll > Enter Payments > Payments > Cost of Net Payments > Total	The total cost to the employer for net payments, for each employee in the current period.
CourtOrders	Payroll > Enter Payments > Summary > Attachments > Current + Advanced	The total value of attachments for the employee in the current period.
DirEarnsAdjPrv1	Not shown in Sage 50 Payroll.	Any adjustment to earnings value for the previous director NI category for each employee in the current period.
DirEarnsAdjPrv2	Not shown in Sage 50 Payroll.	Any adjustment to earnings value for the second previous director NI category for each employee in the current period.
DirEarnsAdjPrv3	Not shown in Sage 50 Payroll.	Any adjustment to earnings value for the third previous director NI category for each employee in the current period.
DirEENICCur	Not shown in Sage 50 Payroll.	Employee NI contributions for the director NI category for the current period.
DirEENICPrv1	Not shown in Sage 50 Payroll.	Employee NI contributions for the previous director NI category for the current period.
DirEENICPrv2	Not shown in Sage 50 Payroll.	Employee NI contributions for the second previous director NI category for the current period.
DirEENICPrv3	Not shown in Sage 50 Payroll.	Employee NI contributions for the third previous director NI category for the current period.
DirEERebateCur	Not shown in Sage 50 Payroll.	The employee NI rebate for the current director NI category, for each contracted out employee in the current period.
DirEERebatePrv1	Not shown in Sage 50 Payroll.	The employee NI rebate for the previous director NI category, for each contracted out employee in the current period.
DirEERebatePrv2	Not shown in Sage 50 Payroll.	The employee NI rebate for the second previous director NI category, for each contracted out employee in the current period.
DirEERebatePrv3	Not shown in Sage 50 Payroll.	The employee NI rebate for the third previous director NI category, for each contracted out employee in the current period.
DirERNICCur	Not shown in Sage 50 Payroll.	Employer NI contributions for the current director NI category for the current period.
DirERNICPrv1	Not shown in Sage 50 Payroll.	Employer NI contributions for the previous director NI category for the current period.
DirERNICPrv2	Not shown in Sage 50 Payroll.	Employer NI contributions for the second previous director NI category for the current period.
DirERNICPrv3	Not shown in Sage 50 Payroll.	Employer NI contributions for the third previous director NI category for the current period.
DirERRebateCur	Not shown in Sage 50 Payroll.	The employer NI rebate for the current director NI category, for each contracted out employee in the current period.
DirERRebatePrv1	Not shown in Sage 50 Payroll.	The employer NI rebate for the previous director NI category, for each contracted out employee in the current period.
DirERRebatePrv2	Not shown in Sage 50 Payroll.	The employer NI rebate for the second previous director NI category, for each contracted out employee in the current period.
DirERRebatePrv3	Not shown in Sage 50 Payroll.	The employer NI rebate for the third previous director NI category, for each contracted out employee in the current period.
EesMinPayCOMPS	Not shown in Sage 50 Payroll.	The employer's minimum payment to COMPS for each employee in the advanced period.
EmployeeNIC	Not shown in Sage 50 Payroll.	The gross employee NI contributions for each employee in the current period.
EmployeePensCur	Payroll > Enter Payments > Summary > Pension Contributions > Current	The employee's pension contributions, including AVCs, for all pension schemes in the current period.
EmployeePensHol	Payroll > Enter Payments > Summary > Pension Contributions > Advanced	The employee's pension contributions, including AVCs, for all pension schemes in the advanced period.
EmployeeRebate	Payroll > Enter Payments > Summary > Employee NIC Rebate > Current + Advanced	The employee's NI rebate for each contracted out employee in the current period.
EmployeeRebatePaid	This variable isn't in use.	This variable isn't in use.
EmployerNIC	Not shown in Sage 50 Payroll.	The gross employer NI contributions for each employee in the current period.
EmployerPensCur	Payroll > Enter Payments > Employers > Pension (Current)	The employer pension contributions to all pension schemes for the employee in the current period.
EmployerPensHol	Payroll > Enter Payments > Employers > Pension (Advanced)	The employer pension contributions to all pension schemes for the employee in the advanced period.
EmployerRebate	Payroll > Enter Payments > Employers > Employer's NIC Rebate	The employer's NI rebate for each contracted out employee in the current period.
EndPIWDate	Payroll > Enter Payments > SSP/KIT > Recording SSP > Last day of sickness	The end date for the last unlinked period of incapacity for work.
ErsMinPayCOMPS	Not shown in Sage 50 Payroll.	The employer's minimum payment to COMPS for each employee in the current period.
ForeignTaxCreditCur	Awaiting information.	Awaiting information.
ForeignTaxCreditHol	Awaiting information.	Awaiting information.
ForeignTaxCreditTD	Awaiting information.	Awaiting information.
FreePayTD	Not shown in Sage 50 Payroll.	The free pay allowance in the tax year to date for each employee up to and including the current period.
GrossForNIC	Not shown in Sage 50 Payroll.	The employee's gross pay for NI calculations in the current period.
GrossForTax	Payroll > Enter Payments > Summary > Taxable Gross Pay > Current + Advanced	The employee's gross pay for PAYE calculation in the current period.
GrossForTaxTD	Payroll > Enter Payments > Information > Income Tax > Gross Taxable Pay To Date	The employee's gross pay for PAYE calculation in the full tax year to date, up to and including the current period.
GrossPayForSalarySacrifice	Payroll > Enter Payments > Information > Salary Sacrifice > Pre-sacrifice pay	The employee's gross pay for the salary sacrifice pension calculation.
HolBase	Payroll > Enter Payments > Advance Pay	The value of any pay advanced for one period for the employee. NOTE: This variable currently doesn't pick up the correct values, it currently includes the values for all periods.
HolidayFundAccrued	Not shown in Sage 50 Payroll.	The amount of the holiday fund accrued in the current period.
HolidayFundAccruedHol	Not shown in Sage 50 Payroll.	The amount of the holiday fund accrued in the advanced period.
HolidayFundAfterAccrual	Payroll > Enter Payments > Holiday Fund > Calculate the Holiday Fund Payment	A flag showing whether the amount paid from the holiday fund in this period should be calculated before or after taking into account the accrual in the current period. 0 - Calculate before the accrual for the current period 1 - Calculate after the accrual for the current period
HolidayFundIsPercentage	Payroll > Enter Payments > Holiday Fund > Pay from Fund (Current Period) > Amount / Percent	A flag showing whether the amount paid from the holiday fund in the current period is a fixed amount or a percentage. 0 - Fixed amount 1 - Percentage
HolidayFundIsPercentageHol	Payroll > Enter Payments > Holiday Fund > Pay From Fund (Advanced Periods) > Amount / Percent	A flag showing whether the amount paid from the holiday fund in the advanced period is a fixed amount or a percentage. 0 - Fixed amount 1 - Percentage
HolidayFundPaid	Not shown in Sage 50 Payroll.	The actual amount of the holiday fund paid to the employee in the current period.
HolidayFundPaidByEmployer	Not shown in Sage 50 Payroll.	The amount paid by the employer into the holiday fund in the current period.
HolidayFundPaidHol	Not shown in Sage 50 Payroll.	The actual amount of the holiday fund paid to the employee in the advanced period.
HolidayFundToPay	Payroll > Enter Payments > Holiday Fund > Pay From Fund (Current Period) > Value	The amount or percentage of the holiday fund paid to the employee in the current period
HolidayFundToPayHol	Payroll > Enter Payments > Holiday Fund > Pay From Fund (Advanced Periods) > Value	The amount or percentage of the holiday fund paid to the employee in the advanced period.
HolPay	Payroll > Enter Payments > Payments / Deductions / Attachments > Advanced Pay	The value of the pay advanced for the total advanced period for the employee.
HolPrd	Payroll > Enter Payments > Advance Pay > Number of periods to advance	The number of holiday periods advanced for the employee.
KCodeRegLimit	Not shown in Sage 50 Payroll.	The regulatory limit. applicable to K-codes, for each employee in the current period.
NetForGrossCur	Payroll > Enter Payments > Net To Gross > Value	The total value of the employee's net payments for the current period.
NetForGrossHol	Payroll > Enter Payments > Advance Pay > Net To Gross > Value	The total value of the employee's net payments for the advanced period.
NetPay1	Payroll > Enter Payments > Summary > Total Net Pay > Net Pay (1)	Net pay before any rounding for each employee in the current period.
NetPay2	Payroll > Enter Payments > Summary > Total Net Pay > Net Pay (2)	Net pay before any rounding in the current period, but including any brought forward cash rounding values, for each employee in the current period.
NICat	Employee > Employee Record > Employment > NI Category	The employee's NI category.
NICEarnsToEeET	This variable isn't in use.	This variable isn't in use.
NICEarnsToErET	This variable isn't in use.	This variable isn't in use.
NICEarnsToET	Employee > Employee Record > Employment > YTD Values > NIC > Earnings LEL to ET	NI earnings for each employee between the LEL and ET in the full tax year to date.
NICEarnsToLEL	Employee > Employee Record > Employment > YTD Values > NIC > Earnings up to LEL	NI earnings for each employee up to the LEL in the full tax year to date.
NICEarnsToUAP	Employee > Employee Record > Employment > YTD Values > NIC > Earnings ET To UAP	NI earnings for each employee between the ET and the UAP in the full tax year to date.
NICEarnsToUEL	Employee > Employee Record > Employment > YTD Values > NIC > Earnings UAP To UEL	NI earnings for each employee between the UAP and UEL in the full tax year to date.
NICHolNotConOut	This variable isn't in use.	This variable isn't in use.
NICHolRecovd	Not shown in Sage 50 Payroll.	The value of NI holiday payment that can be recovered in the current period.
NICostOfNetPay
OnHoliday	Not shown in Sage 50 Payroll.	A flag showing whether the employee is currently on holiday. 0 - No 1 - Yes
PaidTaxRefundWithheld	Not shown in Sage 50 Payroll.	Tax values withheld during a trade dispute but subsequently repaid, for each employee in the current period.
Pensionable	Not shown in Sage 50 Payroll.	The employee's gross pensionable salary in the current period.
PreTaxDed	Payroll > Enter Payments > Summary > Pre-Tax Deductions > Current + Advanced	The total value of any deduction types subject to income tax in the current period.
PreTaxPay	Payroll > Enter Payments > Summary > Pre-Tax Payments > Current + Advanced	The total value of any payment types subject to income tax in the current period.
PrimaryRebate	Not shown in Sage 50 Payroll.	This variable is no longer required as it contains the same value as the EmployerRebate variable.
ProcessDate	Payroll > Change Process Date > Process Date	The current process date.
ProcessMonth	Payroll > Change Process Date > Tax Period > Month	The current process month.
ProcessPeriod	Company > Change Process Data > Tax Period > Week/Month	The week number for employees paid weekly, fortnightly or four weekly, or the month number for monthly paid employees.
ProcessWeek	Payroll > Change Process Date > Tax Period > Week	The current process week.
ProcessYear	Payroll > Change Process Date > Tax Period > Year	The current process tax year.
PstTaxDed	Payroll > Enter Payments > Summary > Post-Tax Deductions > Current + Advanced	The total value of any deduction types not subject to income tax in the current period.
PstTaxPay	Payroll > Enter Payments > Summary > Post-Tax Payments > Current + Advanced	The total value of any payment types not subject to income tax in the current period.
RecalcSAPEntitlement	This variable isn't in use.	This variable isn't in use.
RecalcSMPEntitlement	This variable isn't in use.	This variable isn't in use.
RecalcSPPEntitlement	This variable isn't in use.	This variable isn't in use.
Reference	Employee > Employee Record > Personal > Reference	The employee's reference number.
RefundFlag	Not shown in Sage 50 Payroll.	A flag showing whether the tax is a refund or a payment of tax. 0 - Payment of tax 1 - Refund of tax
RndNetPay	Payroll > Enter Payments > Payments / Deductions / Attachments / Tax Credits > Net Pay	The rounded net pay value for each employee in the current period.
RndNetPaySecAcc	Not shown in Sage 50 Payroll.	The rounded net pay value to be paid to the employee's second bank account in the current period.
SalarySacrificeAmount	Payroll > Enter Payments > Information > Salary Sacrifice > Salary Sacrifice	The salary sacrifice amount for the current period.
SalarySacrificeDeductionAmount	Awaiting information.	Awaiting information.
SAPNICComp	Not shown in Sage 50 Payroll.	The value of NI contributions that can be reclaimed on SAP recovered for the employee in the current period.
SAPPaid	Payroll > Enter Payments > Information > Statutory Payments > SAP Current Period	The statutory adoption pay for the employee in the current period.
SAPRecovd	Not shown in Sage 50 Payroll.	The value of SAP that can be recovered against the employee in the current period.
SAPWeeksCurrentlyDue	Employee > Employee Record > Absence > SAP > Entitlement > Details > Currently Due > Weeks	The cumulative number of weeks for which SAP is paid for each employee in the current period.
SAPWks	Employee > Employee Record > Absence > SAP > Entitlement > Details > Currently Due > Weeks	The cumulative number of weeks for which SAP is paid for each employee in the current period.
SecondaryRebate	Employee > Employee Record > Employment > YTD Values > NIC > Contributions > Employee's NIC Rebate	The secondary NI rebate for contracted out employees.
ShPPNICComp	Not shown in Sage 50 Payroll.	The value of NI contributions that can be reclaimed on ShPP recovered for the employee in the current period.
ShPPPaid	Payroll > Enter Payments > Information > Statutory Payments > ShPP Current Period	The shared parental pay for the employee in the current period.
ShPPRecovd	Not shown in Sage 50 Payroll.	The value of ShPP that can be reclaimed against the employee in the current period.
ShPPWeeksCurrentlyDue	Awaiting information.	Awaiting information.
ShPPWks	Awaiting information.	Awaiting information.
SLRPaymentCur	Payroll > Enter Payments > Summary > Student Loan Payment > Current	The student loan repayments for the employee in the current period.
SLRPaymentHol	Payroll > Enter Payments > Summary > Student Loan Payment > Advanced	The student loan repayments for the employee in the advanced period.
SMPNICComp	Not shown in Sage 50 Payroll.	The value of NI contributions that can be reclaimed on SMP recovered for the employee in the current period.
SMPPaid	Payroll > Enter Payments > Information > Statutory Payments > SMP Current Period	The statutory maternity pay for the employee in the current period.
SMPRecovd	Not shown in Sage 50 Payroll.	The value of SMP that can be reclaimed against the employee in the current period.
SMPWeeksCurrentlyDue	Employee > Employee Record > Absence > SMP > Entitlement > Details > Currently Due > Weeks	The number of weeks for which SMP is paid in the current period.
SMPWks	Employee > Employee Record > Absence > SMP > Entitlement > Details > Currently Due > Weeks	The number of weeks for which SMP is paid in the current period.
SPPAPaid	Payroll > Enter Payments > Information > Statutory Payments > SPP Current Period	The statutory paternity pay for adoption paid to the employee in the current period.
SPPAWeeksCurrentlyDue	Employee > Employee Record > Absence > SPP(A) > Entitlement > Details > Currently Due > Weeks	The number of weeks for which SPP(A) is paid in the current period.
SPPAWks	Employee > Employee Record > Absence > SPP(A) > Entitlement > Details > Currently Due > Weeks	The number of weeks for which SPP(A) is paid in the current period.
SPPNICComp	Not shown in Sage 50 Payroll.	The value of NI contributions that can be reclaimed on SPP recovered for the employee in the current period.
SPPPaid	Payroll > Enter Payments > Information > Statutory Payments > SPP Current Period	The statutory paternity pay for the employee in the current period.
SPPRecovd	Not shown in Sage 50 Payroll.	The value of SPP that can be reclaimed against the employee in the current period.
SPPWeeksCurrentlyDue	Employee > Employee Record > Absence > SPP > Entitlement > Details > Currently Due > Weeks	The number of weeks for which SPP is paid in the current period.
SPPWks	Employee > Employee Record > Absence > SPP > Entitlement > Details > Currently Due > Weeks	The number of weeks for which SPP is paid in the current period.
SSPBand	Not shown in Sage 50 Payroll.	The band or threshold used to calculate SPP for the employee in the current period.
SSPPaid	Payroll > Enter Payments > Information > Statutory Payments > SSP Current Period	The statutory sick pay for the employee in the current period.
SSPPaidTD	Payroll > Enter Payments > Information > Statutory Payments > SSP to Date	The value of SSP paid to date, including the current pre-update period, in the current period of incapacity for work.
SSPWks	Payroll > Enter Payments > SSP > SSP Weeks	The cumulative number of weeks for which SSP is paid for the employee in the current period.
StartPIWDate	Payroll > Enter Payments > SSP/KIT > Recording SSP > First day of sickness	The start date of the last unlinked period of incapacity for work.
StdNICEarns	Payroll > Enter Payments > Information > National Insurance > Earnings for NI	The employee's standard earnings for NI in the current period.
StdNICEarnsHol	Not shown in Sage 50 Payroll.	The employee's standard earnings for NI in the advanced period.
TaxCode	Payroll > Enter Payments > Payments / Deductions / Attachments / Tax Credits > Tax Code	The employee's tax code for the current period.
TaxCostOfNetPay	Payroll > Enter Payments > Payments > Cost of Net Payments > Tax	The cost to the employer of income tax for net payments, for each employee in the current period.
TaxCreditsCur	This variable isn't in use.	This variable isn't in use.
TaxCreditsHol	This variable isn't in use.	This variable isn't in use.
TaxDue	Not shown in Sage 50 Payroll.	The total income tax due for the employee in the current period. If the K-code regulatory limit is in operation this value may be larger than the tax paid.
TaxDueTD	Payroll > Enter Payments > Information > Income Tax > Tax Due To Date	The total income tax due in the tax year to date for the employee, including the current period. If the K-code regulatory limit is in operation this value may be larger than the tax paid to date.
TaxNotCol	Payroll > Enter Payments > Information > Income Tax > Tax Not Collected	The value of income tax not collected for each employee in the current period. This applies to K-codes.
TaxPaid	Payroll > Enter Payments > Payments / Deductions / Attachments / Tax Credits > PAYE	The total income tax paid for each employee in the current period. If the K-code regulatory limit is in operation this value may be less than the tax due.
TaxPaidTD	Not shown in Sage 50 Payroll.	The employee's income tax paid in the full tax year to date.
TaxRefundWithheld	Payroll > Enter Payments > Information > Income Tax > Tax Refund Due But Not Paid	The value of tax withheld for the employee due to a trade dispute.
TotalAttach	Payroll > Enter Payments > Information > Attachments > Total Attachments	The total value of attachments for the employee in the current and advanced period.
TotalAttachCosts	Payroll > Enter Payments > Information > Attachments > Administration Charges	The total value of administration fees for attachments for the employee in the current period.
TotalAttachCur	Payroll > Enter Payments > Summary > Attachments > Current	The total value of attachments for the employee in the current period.
TotalAttachHol	Payroll > Enter Payments > Summary > Attachments > Advanced	The total value of attachments for the employee in the advanced period.
TotalGross	Payroll > Enter Payments > Payments / Deductions / Attachments / Tax Credits > Gross Pay	The total gross pay for the employee, prior to any deductions, in the current period.
TotalLoansPaid	Payroll > Enter Payments > Summary > Loan Repayments > Current	The value of loan repayments made by the employee in the current period.
TotalLoansPaidHol	Payroll > Enter Payments > Summary > Loan Repayments > Advanced	The value of loan repayments made by the employee in the advanced period.
User8Wks	Not shown in Sage 50 Payroll.	A flag showing whether the 8 Weeks Average Gross Pay has been manually calculated for the employee in the current period. 0 - No 1 - Yes NOTE: You can only enter the 8 Weeks Average Gross Pay value manually if you haven't updated any pay periods for the employee.
WaitDays	Not shown in Sage 50 Payroll.	The number of waiting days accrued in the current period of incapacity for work.
Wk1BasisFlag	Employee > Employee Record > Employment > Wk1 Mth1 Basis	A flag showing whether the employee's tax is calculated on a week 1 / month 1 basis. 0 - No 1 - Yes

DateParameters
Variable	Location	Details
EndOfTaxYear	Not shown in Sage 50 Payroll.	The last day in the current tax year.
ProcessDate	Payroll > Change Process Date > Process Date	The current process date.
StartOfTaxYear	Not shown in Sage 50 Payroll.	The first day of the current tax year.
TaxMonth	Payroll > Change Process Date > Tax Period > Month	The tax month into which the current process date falls.
TaxWeek	Payroll > Change Process Date > Tax Period > Week	The tax week into which the current process date falls.

NOTE: This table is currently not available in the Historical Data or post-update reports areas. For further information please refer to article .

DeductionAnalysis
Variable	Location	Details
Desc1-30	Company > Custom Reports > New / Edit > Deductions > Deduction Type	The description of the deduction pay element.
Holiday1-30	Payroll > Enter Payments > Advance Pay > Deductions > Amount	The amount paid for the pay element for any advanced period.
Hours1-30	Payroll > Enter Payments > Deductions > Hours/No	The hours or number for the deduction pay element in the current period.
NumItems	Not shown in Sage 50 Payroll.	The number of active deduction pay elements set up in Employee > Employee Record > Employment > Pay Elements > Deductions.
Rate1-30	Payroll > Enter Payments > Deductions > Rate	The rate for the pay element.
Reference	Employee > Employee Record > Personal > Reference	The employee reference number.
Total1-30	Payroll > Enter Payments > Deductions > Amount	The amount paid for the deduction pay element.
TotalTD1-30	Not shown in Sage 50 Payroll.	The amount paid for the deduction pay element in the full tax year to date.
Type1-30	Not shown in Sage 50 Payroll.	The type of deduction.

DeductionHistory
Variable	Location	Details
DeductionAmtCur	Not shown in Sage 50 Payroll.	The amount deducted in each period for each deduction type.
DeductionAmtHol	Not shown in Sage 50 Payroll.	The amount deducted for each holiday period for each deduction type.
DeductionAmtTotal	Not shown in Sage 50 Payroll.	The total amount deducted in each period for each deduction type.
DeductionCCAEOFlag	Not shown in Sage 50 Payroll.	A flag showing whether each deduction type was deducted before calculating Community Charge Attachment of Earnings Orders for each updated period. 0 - No 1 - Yes
DeductionCTAEOFlag	Not shown in Sage 50 Payroll.	A flag showing whether each deduction type was deducted before calculating Council Tax Attachment of Earnings Orders for each updated period. 0 - No 1 - Yes
DeductionDescription	Not shown in Sage 50 Payroll.	The description of the deduction type.
DeductionHrsNoCur	Not shown in Sage 50 Payroll.	The hours or number for each updated period for each deduction type.
DeductionHrsNoHol	Not shown in Sage 50 Payroll.	The hours or number for each holiday period for each deduction type.
DeductionInstance	Not shown in Sage 50 Payroll.	A unique reference identifier for the deduction type, taken from the order in which the deduction types are set up on the employee record.
DeductionNICFlag	Not shown in Sage 50 Payroll.	A flag showing whether each deduction type was deducted before calculating National Insurance contributions for the updated period. 0 - No 1 - Yes
DeductionOtherAttachFlag	Not shown in Sage 50 Payroll.	A flag showing whether each deduction type was deducted before calculating other attachment of earnings orders for the updated period. 0 - No 1 - Yes
DeductionPensnFlag	Not shown in Sage 50 Payroll.	A flag showing whether each deduction type was deducted before calculating main pension contributions for the updated period. 0 - No 1 - Yes
DeductionRateAmtCur	Not shown in Sage 50 Payroll.	The rate or amount of each updated period for each deduction type.
DeductionRateAmtHol	Not shown in Sage 50 Payroll.	The rate or amount of each updated holiday period for each deduction type.
DeductionReference	Employee > Employee Record > Personal > Reference	The employee reference number.
DeductionStatus	Not shown in Sage 50 Payroll.	Text indicating the status of each deduction type. Variable Global Fixed
DeductionTaxFlag	Not shown in Sage 50 Payroll.	A flag showing whether each deduction type was deducted before calculating income tax for the updated period. 0 - No 1 - Yes
DeductionValueTD	Not shown in Sage 50 Payroll.	The cumulative year to date value at the end of each updated period for each deduction type.
HistoryRef	Not shown in Sage 50 Payroll.	A three part reference comprised of the employee's reference number, the first date of the updated pay period and the last date of the updated pay period. For example, if an employee with a reference of 7 is updated for the week ending 25/08/2012 the reference is 000007/19082010/25082012.

DeductionTypes
Variable	Location	Details
AutoAdv	Company > Pay Elements > Deductions > New / Edit > Deduct this value before calculating > Pension (AVC)	A flag showing whether this deduction type should be deducted before calculating advance voluntary contributions. 0 - No 1 - Yes
AVCFlag	Company > Pay Elements > Deductions > New / Edit > Holiday > Auto Advance	A flag showing whether the last updated period values are automatically used in the holiday period when holiday pay is advanced. 0 - No 1 - Yes
BatchOrderFourWeekly	This variable isn't in use for deductions.	This variable isn't in use for deductions.
BatchOtherMonthly	This variable isn't in use for deductions.	This variable isn't in use for deductions.
BatchOrderTwoWeekly	This variable isn't in use for deductions.	This variable isn't in use for deductions.
BatchOrderWeekly	This variable isn't in use for deductions.	This variable isn't in use for deductions.
CCAEOFlag	Company > Pay Elements > Deductions > New / Edit > Deduct this value before calculating > CCAEO	A flag showing whether this deduction type should be deducted before calculating community charge attachment of earnings orders. 0 - No 1 - Yes
ClearYE	Company > Pay Elements > Deductions > New / Edit > Miscellaneous > Clear To Date at Year End	A flag showing whether the year to date value of this deduction is set to 0 at the year end. 0 - No 1 - Yes
CTAEOFlag	Company > Pay Elements > Deductions > New / Edit > Deduct this value before calculating > CTAEO	A flag showing whether this deduction type should be deducted before calculating council tax attachment of earnings orders. 0 - No 1 - Yes
CustomReportOrder	Company > Custom Reports > New / Edit > Deductions > Index	The index number of this deduction type in the default custom report setting.
DednReference	Company > Pay Elements > Deductions > Ref Company > Pay Elements > Deductions > New / Edit > Type > Reference	The reference number for the deduction type.
Description	Company > Pay Elements > Deductions > Description Company > Pay Elements > New / Edit > Type > Description Employee > Employee Record > Employment > Pay Elements > Deductions > Deduction Name Employee > Employee Record > Employment > YTD Values > Payments & Deductions > Deduction Name Payroll > Enter Payments > Deductions > Deduction Name Payroll > Enter Payments > Advance Pay > Deductions > Deduction Name	The description of the deduction type.
ERPays	This variable isn't in use for deductions.	This variable isn't in use for deductions.
HolidayAccrual	Company > Pay Elements > Deductions > New / Edit > Holiday > Include for Holiday Accrual	A flag showing whether this deduction type should be included when calculating the holiday fund accrual. 0 - No 1 - Yes
HrsNo	Company > Pay Elements > Deductions > Hours/No Company > Pay Elements > Deductions > New / Edit > Default > Hours/No	The default hours or number for the deduction type.
Inc12Week	Company > Pay Elements > Deductions > New / Edit > Holiday > Include for Weekly Average	A flag showing whether this deduction type should be included when calculating the weekly gross pay. 0 - No 1 - Yes
IncForTimesheets	Company > Pay Elements > Deductions > New / Edit	A flag showing whether this deduction appears on the deductions tab in timesheet entry. 0 - No 1 - Yes
IncForVariance	Company > Variance Settings > Deductions > Variance > Include	A flag showing whether this deduction type is included in the variance analysis. 0 - No 1 - Yes
InclHoursMinWage	Company > Pay Elements > Deductions > New / Edit	A flag showing whether hours will be deducted from the minimum wage calculation. 0 - No 1 - Yes
InclRateMinWage	Company > Pay Elements > Deductions > New / Edit	A flag showing whether the rate will be deducted from the minimum wage calculation. 0 - No 1 - Yes
NICFlag	Company > Pay Elements > Deductions > New / Edit > Deduct this value before calculating > National Insurance	A flag showing whether this deduction type should be deducted before calculating national insurance contributions. 0 - No 1 - Yes
OtherAttachFlag	Company > Pay Elements > Deductions > New / Edit > Deduct this value before calculating > Other AEOs	flag showing whether this deduction type should be deducted before calculating other attachment of earnings orders. 0 - No 1 - Yes
PensnFlag	Company > Pay Elements > Deductions > New / Edit > Deduct this value before calculating > Pension (Main)	A flag showing whether this deduction type should be deducted before calculating main pension contributions. 0 - No 1 - Yes
RateAmt	Company > Pay Elements > Deductions > Rate Company > Pay Elements > Deductions > New / Edit > Default > Rate	The default rate for the deduction type.
Status	Company > Pay Elements > Deductions > Status Company > Pay Elements > Deductions > New / Edit > Type > Status	The status of the deduction type. Variable Global Fixed
TaxFlag	Company > Pay Elements > Deductions > New / Edit > Deduct this value before calculating > PAYE	A flag showing whether this deduction type should be deducted before calculating PAYE. 0 - No 1 - Yes
VarianceAmount	Company > Variance Settings > Deductions > Variance	The amount or percentage to be used for the variance.
VarianceType	Company > Variance Settings > Deductions > Variance Type	The code for the variance type. 0 - Fixed amount 1 - Percentage
VarianceTypeText	Company > Variance Settings > Deductions > Variance Type	The description of the variance type. This can be any of the following: Fixed amount Percentage

DefaultVariances
Variable	Location	Details
Description	Company > Variance Settings > Settings > Description	The type of variance, from the following list: Gross Pay Net Pay Employer's Pensions Employee's Pensions Total Payments Total Deductions
IncForVariance	Company > Variance Settings > Settings > Include	A flag to indicate whether this type is included for variance. 0 - No 1 - Yes
Reference	Not shown in Sage 50 Payroll.	A unique reference, which increases by 1, for each different type of variance.
VarianceAmount	Company > Variance Settings > Settings > Variance	The amount of the variance.
VarianceType	Not shown in Sage 50 Payroll.	A flag indicating the type of variance. 0 - Fixed amount 1 - Percentage
VarianceTypeText	Company > Variance Settings > Settings > Variance Type	The description of the variance type. N/A Fixed amount Percentage

Departments
Variable	Location	Details
DepartmentName	Company > Settings > Analysis > Departments > Name.	The name of the department.
DepartmentReference	Company > Settings > Analysis > Departments > Ref	The department reference.

EmployeeAttachments
Variable	Location	Details
AdminCharged	Company > Pay Elements > Attachments > Admin Fee	Whether an administration fee is chargeable for this attachment type. 0 - No 1 - Yes
AdminCostAllowed	Not shown in Sage 50 Payroll.	The admin fee chargeable for the attachment.
AdminCostCharged	Not shown in Sage 50 Payroll.	A flag to indicate whether an admin fee is charged for the attachment.
AdminCostTD	Employee > Employee Record > Employment > YTD Values > Attachments > Admin Fee To Date	The year to date value of administration costs for the attachment.
AltDescription	Company > Pay Elements > Attachments > Replacement Description	The alternative description of the attachment. You can change this manually within Sage 50 Payroll.
AmtDednCur	Payroll > Enter Payments > Attachments > Amount Deducted	The value of the attachment deducted in the current period.
AmtDednHol	Payroll > Enter Payments > Advance Pay > Attachments > Total Deducted	The value of the attachment deducted in the advanced period.
AmtPercCur	Payroll > Enter Payments > Attachments > Attach Value	The amount of the attachment or percentage used in the current period.
AmtPercHol	Payroll > Enter Payments > Advance Pay > Attachments > Attachment Value	The amount of the attachment or percentage used in the advanced period.
AttachCF	Employee > Employee Record > Employment > YTD Values > Attachments > Attachment C/F	The value of any portion of a priority order that could not be paid in a previous period and has been carried forward.
AttachCFCur	Payroll > Enter Payments > Attachments > Amount CF	Any value of the attachment carried forward after being unable to deducted the whole amount of the attachment due to insufficient earnings.
AttachEarnsCur	Payroll > Enter Payments > Attachments > Attach Earnings	The attachable earnings in the current period.
AttachEarnsHol	Payroll > Enter Payments > Advance Pay > Attachments > Attachable Earnings	The attachable earnings in the advanced period.
AttachReference	Company > Pay Elements > Attachments > Ref	The reference number for the attachment type at a company level. This is an automatic number and can't be amended. 1 - 1971 Priority 2 - Child Support 3 - DEO 4 - 1971 Non-Priority 5 - Pre 92 CCAEO 6 - Post 92 CCAEO 7 - CTAEO 8 - Earnings Arrest 9 - CMA 10 - CAO 11 - ISDN
AttachTD	Employee > Employee Record > Employment >YTD Values > Attachments > Attachment Value YTD	The total value of the attachment deducted in the specified tax year.
AttType	Not shown in Sage 50 Payroll.	Whether the deduction is a percentage of attachable earnings or a fixed amount.
CalcPriority	Employee > Employee Record > Employment > Pay Elements > Attachments > Priority Order	The priority order used to deduct attachments if there are insufficient attachable earnings.
CalcStatus	This variable is no longer in use.	This variable is no longer in use.
CourtReference	Employee > Employee Record > Employment > Pay Elements > Attachments > Order Reference	The attachment reference from the court order.
CustomReportOrder	Custom Reports > New/Edit > Attachments > Index	The index number of the attachment type in the custom report setting.
DefaultDescription	Pay Elements > Attachments > Standard Description or Employee Record > Employment > YTD Values > Attachments > Attachment Name	The standard description for the attachment of earnings order.
EndOfTaxYear	Not shown in Sage 50 Payroll.	The end of the tax year to which this year to date value appears.
Instance	Not shown in Sage 50 Payroll.	An identifier reflecting the order in which the attachment appears on the employee record.
NormalDeduction	Employee > Employee Record > Employment > Pay Elements > Attachments > Normal Deduction Rate	The normal deduction rate of the attachment.
OrderEndDate	Employee > Employee Record > Employment > Pay Elements > Attachments > Order End Date	The date on which the order ends.
OrderIssuedDate	Employee > Employee Record > Employment > Pay Elements > Attachments > Order Issued Date	The date on which the court order was made and becomes effective.
PercentageSign	Payroll > Enter Payments > Attachments > Amount\Percent	If the attachment is calculated as a percentage deduction, a % appears. If the attachment is taken as a fixed amount, nothing appears.
PredTotalAmt	Employee > Employee Record > Employment > Pay Elements > Attachments > Total Attachment	The total amount of the attachment. If the attachment is ongoing, this amount is zero.
ProtdEarns	Employee > Employee Record > Employment > Pay Elements > Attachments > Protected Earnings	Any earnings protected by the court.
ProtdEarnsCF	Employee > Employee Record > Employment > YTD Values > Attachments > Protected Earnings C/F	Any protected earnings carried forward when the employee's pay in the period isn't enough to cover the level of protected earnings.
ProtdEarnsCFCur	Payroll > Enter Payments > Attachments > Protd CF	Any protected earnings carried forward to the next period where the protected earnings in the current period are in excess of attachable earnings.
ProtdEarnsCur	Not shown in Sage 50 Payroll.	The total value of protected earnings used in the current period, including any brought forward.
ProtdEarnsHol	Not shown in Sage 50 Payroll.	The total value of protected earnings used in the advanced period, including any brought forward.
Reference	Employee > Employee Record > Personal > Reference	The employee reference number.
TotalAmtDedn	This variable is no longer in use.	This variable is no longer in use.
TotalAttachEarns	This variable is no longer in use.	This variable is no longer in use.
TotalDeductedTD	Employee > Employee Record > Employment > YTD Values > Attachments > Attachment Value To Date	The total value of the attachment deducted to date.
TotalProtdEarns	This variable is no longer in use.	This variable is no longer in use.

EmployeeBankAccounts
Variable	Location	Details
BACSReference	Employee > Employee Record > Banking > BACS/Automated Credit Transfer > Reference	The employee's automated credit transfer number.
BankAcctName	Employee > Employee Record > Banking > Account Details > Account Name	The employee's bank account name.
BankAcctNumber	Employee > Employee Record > Banking > Account Details > Account No	The employee's bank account number.
BankAcctType	Employee > Employee Record > Banking > Account Details > Account Type	The type of account, either Bank Account or Building Society Account.
BankAddress1-5	Employee > Employee Record > Banking > Branch Details > Address	The bank account address.
BankFax	Employee > Employee Record > Banking > Branch Details > Facsimile	The bank's fax number.
BankName	Employee > Employee Record > Banking > Branch Details > Bank	The employee's bank's name.
BankPostcode	Employee > Employee Record > Banking > Branch Details > Post Code	The bank postcode.
BankTelephone	Employee > Employee Record > Banking > Branch Details > Telephone	The bank's telephone number.
BIC	Employee > Employee Record > Banking > BIC	The employee's bank identifier code. This is used for international payments.
BldSocNumber	Employee > Employee Record > Banking > Account Details > B/Soc Roll No.	The employee's building society roll number. If the account type is Bank Account, this option isn't available.
IBAN	Employee > Employee Record > Banking > IBAN	The employee's international bank account number.
Reference	Employee > Employee Record > Personal > Reference	The employee's reference.
SecondAcctBIC	Employee > Employee Record > Banking > Second Account > BIC	The employee's bank identifier code for their second account.
SecondAcctIBAN	Employee > Employee Record > Banking > Second Account > IBAN	The employee's international bank account number for their second account.
SecondAcctPercFix	Employee > Employee Record > Banking > Second Account > Pay Into Second Account > Value	The percentage or amount of the employee's net pay to be paid into their second bank account.
SecondAcctPercFixFlag	Employee > Employee Record > Banking > Second Account > Pay Into Second Account > Percentage or Fixed	Indicates whether the value to be paid into the second bank account is a percentage or a set amount.
SecondBACSReference	Employee > Employee Record > Banking > Second Account > BACS/Automated Credit Transfer > Reference	The employee's automated credit transfer number for their second account.
SecondBankAcctName	Employee > Employee Record > Banking > Second Account > Account Details > Account Name	The employee's bank account name for their second account.
SecondBankAcctNumber	Employee > Employee Record > Banking > Second Account > Account Details > Account No	The employee's bank account number for their second account.
SecondBankAcctType	Employee > Employee Record > Banking > Second Account > Account Details > Account Type	The type of account, either Bank Account or Building Society Account, for the employee's second bank account.
SecondBankAddress1-5	Employee > Employee Record > Banking > Second Account > Branch Details > Address	The bank account address for the employee's second bank account.
SecondBankFax	Employee > Employee Record > Banking > Second Account > Branch Details > Facsimile	The fax number for the employee's second bank account.
SecondBankPostcode	Employee > Employee Record > Banking > Second Account > Branch Details > Post Code	The bank postcode for the employee's second bank account.
SecondBankTelephone	Employee > Employee Record > Banking > Second Account > Branch Details > Telephone	The telephone number for the employee's second bank account.
SecondBldSocNumber	Employee > Employee Record > Banking > Second Account > Account Details > B/Soc Roll No.	The employee's building society roll number for their second bank account. If the account type is Bank Account, this option isn't available.
SecondSortCode	Employee > Employee Record > Banking > Second Account > Account Details > Sort Code	The employee's sort code for their second bank account.
SortCode	Employee > Employee Record > Banking > Account Details > Sort Code	The employee's sort code.

EmployeeDeductions
Variable	Location	Details
AmtCur	Payroll > Enter Payments > Deductions > Amount	The amount of each of the employee's deduction types in the current period.
AmtHol	Payroll > Enter Payments > Advance Pay > Deductions > Amount	The amount of each of the employee's deduction types in the advanced holiday period.
AmtTotal	Not shown in Sage 50 Payroll.	The total amount of the employee's deduction types in both the current and the advanced holiday period.
AutoAdv	Company > Pay Elements > Deductions > New / Edit > Deduct this value before calculating > Pension (AVC)	A flag showing whether this deduction type should be deducted before calculating advance voluntary contributions. 0 - No 1 - Yes
AVCFlag	Company > Pay Elements > Deductions > New / Edit > Holiday > Auto Advance	A flag showing whether the last updated period values are automatically used in the holiday period when holiday pay is advanced. 0 - No 1 - Yes
BatchOrderFourWeekly	This variable isn't in use for deductions.	This variable isn't in use for deductions.
BatchOrderMonthly	This variable isn't in use for deductions.	This variable isn't in use for deductions.
BatchOrderTwoWeekly	This variable isn't in use for deductions.	This variable isn't in use for deductions.
BatchOrderWeekly	This variable isn't in use for deductions.	This variable isn't in use for deductions.
CCAEOFlag	Company > Pay Elements > Deductions > New / Edit > Deduct this value before calculating > CCAEO	A flag showing whether this deduction type should be deducted before calculating community charge attachment of earnings orders. 0 - No 1 - Yes
ClearYE	Company > Pay Elements > Deductions > New / Edit > Miscellaneous > Clear To Date at Year End	A flag showing whether the year to date value of this deduction is set to 0 at the year end. 0 - No 1 - Yes
CTAEOFlag	Company > Pay Elements > Deductions > New / Edit > Deduct this value before calculating > CTAEO	A flag showing whether this deduction type should be deducted before calculating council tax attachment of earnings orders. 0 - No 1 - Yes
CustomReportOrder	Company > Custom Reports > New / Edit > Deductions > Index	The index number of this deduction type in the default custom report setting.
DednReference	Company > Pay Elements > Deductions > Ref Company > Pay Elements > Deductions > New / Edit > Type > Reference	The reference number for the deduction type.
DefaultHrsNo	Employee > Employee Record > Employment > Pay Elements > Deductions > Default Hours / No	The employee's default hours or number for each deduction type.
DefaultRateAmt	Employee > Employee Record > Employment > Pay Elements > Deductions > Default Rate	The employee's current rate for each deduction type.
Description	Company > Pay Elements > Deductions > Description Company > Pay Elements > New / Edit > Type > Description Employee > Employee Record > Employment > Pay Elements > Deductions > Deduction Name Employee > Employee Record > Employment > YTD Values > Payments & Deductions > Deduction Name Payroll > Enter Payments > Deductions > Deduction Name Payroll > Enter Payments > Advance Pay > Deductions > Deduction Name	The description of the deduction type.
EndOfTaxYear	Not shown in Sage 50 Payroll.	The end of the tax year to which the value applies.
ERPays	This variable isn't in use for deductions.	This variable isn't in use for deductions.
HolidayAccrual	Company > Pay Elements > Deductions > New / Edit > Holiday > Include for Holiday Accrual	A flag showing whether this deduction type should be included when calculating the holiday fund accrual. 0 - No 1 - Yes
HrsNo	Company > Pay Elements > Deductions > Hours/No Company > Pay Elements > Deductions > New / Edit > Default > Hours/No	The default hours or number for the deduction type.
HrsNoCur	Payroll > Enter Payments > Deductions > Hours / No	The hours or number for each of the employee's deduction types in the current period.
HrsNoHol	Payroll > Enter Payments > Advance Pay > Deductions > Hours / No	The hours or number for each of the employee's deduction types in the advanced holiday period.
Inc12Week	Company > Pay Elements > Deductions > New / Edit > Holiday > Include for Weekly Average	A flag showing whether this deduction type should be included when calculating the weekly gross pay. 0 - No 1 - Yes
IncForVariance	Company > Variance Settings > Deductions > Variance > Include	A flag showing whether this deduction type is included in the variance analysis. 0 - No 1 - Yes
Instance	Not shown in Sage 50 Payroll.	A reference number for the deduction type. This is set at an employee level.
InUse	Employee > Employee Record > Employment > Pay Elements > Deductions > In Use	A setting marking whether the pay element is in use for the employee.
NICFlag	Company > Pay Elements > Deductions > New / Edit > Deduct this value before calculating > National Insurance	A flag showing whether this deduction type should be deducted before calculating national insurance contributions. 0 - No 1 - Yes
OtherAttachFlag	Company > Pay Elements > Deductions > New / Edit > Deduct this value before calculating > Other AEOs	A flag showing whether this deduction type should be deducted before calculating other attachment of earnings orders. 0 - No 1 - Yes
PensnFlag	Company > Pay Elements > Deductions > New / Edit > Deduct this value before calculating > Pension (Main)	A flag showing whether this deduction type should be deducted before calculating main pension contributions. 0 - No 1 - Yes
RateAmt
RateAmtCur
RateAmtHol
Reference
Status
TaxFlag
ValueTD
VarianceAmount
VarianceType
VarianceTypeText

EmployeeHistory
Variable	Location	Details
Address1-5	Not shown in Sage 50 Payroll.	The employee's address for each updated historical period.
AdjustedTaxPaidTD	Awaiting information.	Awaiting information.
ASPPAWksTD	Awaiting information.	Awaiting information.
ASPPPaidTD	Awaiting information.	Awaiting information.
ASPPWksTD	Awaiting information.	Awaiting information.
BACSReference	Not shown in Sage 50 Payroll.	The employee's BACS reference for each updated historical period.
BankAcctName	Not shown in Sage 50 Payroll.	The employee's bank account name of the first account for each updated historical period.
BankAcctNumber	Not shown in Sage 50 Payroll.	The employee's bank account number for their first account for each updated historical period.
BldSocNumber	Not shown in Sage 50 Payroll.	The employee's building society number for their first account for each updated historical period.
CCName	Not shown in Sage 50 Payroll.	The name of the employee's cost centre for each updated historical period.
CCRef	Not shown in Sage 50 Payroll.	The number of the employee's cost centre for each updated historical period.
CCReference	Not shown in Sage 50 Payroll.	The reference of the employee's cost centre for each updated historical period.
DateDirshipBegan	Not shown in Sage 50 Payroll.	The start date of the employee's last directorship for each updated historical period.
DepartmentName	Not shown in Sage 50 Payroll.	The name of the employee's department for each updated historical period.
DepartmentReference	Not shown in Sage 50 Payroll.	The reference of the employee's department for each updated historical period.
DeptReference	Not shown in Sage 50 Payroll.	The number of the employee's department for each updated historical period.
DirectorStatus	Not shown in Sage 50 Payroll.	The director status of the employee for each updated historical period. 0 - Not a director 1 - Director 2 - Director (Table Method)
EmailAddress	Not shown in Sage 50 Payroll.	The employee's email address for each updated historical period.
EmployeeEntitlement	Not shown in Sage 50 Payroll.	The employee's holiday entitlement for the holiday year for each updated historical period.
EmployeeNIC	Not shown in Sage 50 Payroll.	The gross employee NI contributions for each updated period.
EmployeeNICTD	Not shown in Sage 50 Payroll.	The employee's employee National Insurance contributions, inclusive of the current period, year to date for each updated historical payment period.
EmployerNICTD	Not shown in Sage 50 Payroll.	The employee's employer National Insurance contributions, inclusive of the current period, year to date for each updated historical payment period.
EnterPaymentNotes	Not shown in Sage 50 Payroll.	Any notes entered during Enter Payments for each updated historical period.
ForeignTaxCreditTD	Awaiting information.	Awaiting information.
Forename	Not shown in Sage 50 Payroll.	The employee's forename for each updated historical period.
Gender	Not shown in Sage 50 Payroll.	The employee's sex for each updated historical period.
HolidaysTaken	Not shown in Sage 50 Payroll.	The holiday days or hours taken for each updated historical period.
HolPayTD	Not shown in Sage 50 Payroll.	The employee's holiday pay paid, inclusive of the current period, year to date for each updated historical payment period.
HolUnitsRemain	Not shown in Sage 50 Payroll.	The holiday units remaining for each updated historical period.
HolUnitsTaken	Not shown in Sage 50 Payroll.	The holiday units taken up to and including the updated historical period.
ManualNICFlag	Not shown in Sage 50 Payroll.	A flag showing whether NI contributions were manually calculated for each updated historical period. 0 - No 1 - Yes
ManualSAPFlag	Not shown in Sage 50 Payroll.	A flag showing whether SAP was manually calculated for each updated historical period. 0 - No 1 - Yes
ManualSMPFlag	Not shown in Sage 50 Payroll.	A flag showing whether SMP was manually updated for each updated historical period. 0 - No 1 - Yes
ManualSPPFlag	Not shown in Sage 50 Payroll.	A flag showing whether SPP was manually updated for each updated historical period. 0 - No 1 - Yes
ManualSSPFlag	Not shown in Sage 50 Payroll.	A flag showing whether SSP was manually updated for each updated historical period. 0 - No 1 - Yes
MaritalStatus	Not shown in Sage 50 Payroll.	The employee's marital status for each updated historical period.
NetPayTD	Not shown in Sage 50 Payroll.	The employee's net pay to date, including the current period for each updated historical period.
NICGrossTD	Not shown in Sage 50 Payroll.	The employee's gross pay to be taken into account for calculating National Insurance contributions for the current employment. This includes the current period.
NINumber	Not shown in Sage 50 Payroll.	The employee's NI number for each updated historical period.
P45Gross	Not shown in Sage 50 Payroll.	The employee's taxable gross pay from previous employment for each updated historical period.
P45Tax	Not shown in Sage 50 Payroll.	The employee's tax paid from previous employment for each updated historical period.
PayslipComment	Not shown in Sage 50 Payroll.	Any payslip comment entered for each updated historical period.
PayStatus	Not shown in Sage 50 Payroll.	The pay status of the employee for each updated historical period. This can be any of the following: 0 - OK 1 - On Hold 2 - Trade Dispute
PensnEmployeeTD	Not shown in Sage 50 Payroll.	The cumulative employee's pension contributions up to and including the updated period.
PensnEmployerTD	Not shown in Sage 50 Payroll.	The cumulative employer's pension contributions up to and including the updated period.
Postcode	Not shown in Sage 50 Payroll.	The employee's postcode for each updated historical period.
SalarySacrificeTD	Not shown in Sage 50 Payroll.	The salary sacrifice amount for the full tax year up to and including the updated period.
SAPPaidTD	The employee's tax paid from previous employment for each updated historical period.	The employee's SAP, inclusive of the current period, for each updated historical period in the full tax year to date.
SecondBankAcctName	Not shown in Sage 50 Payroll.	The employee's bank account name for their second bank account for each updated historical period.
SecondBankAcctNumber	Not shown in Sage 50 Payroll.	The employee's bank account name for their second bank account for each updated historical period.
SecondBldSocNumber	Not shown in Sage 50 Payroll.	The employee's building society number for their second account for each updated historical period.
SecondSortCode	Not shown in Sage 50 Payroll.	The employee's sort code for their second bank account for each updated historical period.
Sensitivity	Awaiting information.	Awaiting information.
SLFromDate	Not shown in Sage 50 Payroll.	The date from which the employee's student loan repayments began for each updated historical period.
SLPriority	Not shown in Sage 50 Payroll.	The priority of the attachment of earnings after which the student loan repayments were deducted for each updated historical period.
SLProtEarns	Not shown in Sage 50 Payroll.	The value of any protected earnings which can't be used in calculating student loan repayments for each updated historical period.
SLToDate	Not shown in Sage 50 Payroll.	The date from which the employee's student loan repayments ended for each updated historical period.
SMPPaidTD	Not shown in Sage 50 Payroll.	The employee's SMP, inclusive of the current period, for each updated historical period in the full tax year to date.
SMPWksTD	Awaiting information.	Awaiting information.
SortCode	Awaiting information.	Awaiting information.
SPPAWksTD	Awaiting information.	Awaiting information.
SPPPaidTD	Not shown in Sage 50 Payroll.	Each employee's SPP and SPPA paid, inclusive of the current period, for each updated historical period in the full tax year to date.
SPPWksTD	Awaiting information.	Awaiting information.
SSPPaidInPIW	Awaiting information.	Awaiting information.
SSPPaidTD	Awaiting information.	Awaiting information.
StdEarnsTD	Not shown in Sage 50 Payroll.	Each employee's standard earnings for NI, inclusive of the current period, year to date for each updated historical payment period.
Surname	Not shown in Sage 50 Payroll.	The employee's surname for each updated historical period.
TaxGrossTD	Not shown in Sage 50 Payroll.	Each employee's taxable gross income, inclusive of any previous employment and the current period, for each updated historical period in the full tax year to date.
Telephone	Not shown in Sage 50 Payroll.	The employee's telephone number for each updated historical period.
Title	Not shown in Sage 50 Payroll.	The employee's title for each updated historical period.
TitleAndName	Not shown in Sage 50 Payroll.	The employee's title and name for each updated historical period.
TotalGrossTD	Not shown in Sage 50 Payroll.	Each employee's total gross pay, inclusive of any previous employment and the current period, for each updated historical period in the full tax year to date.
TotalTaxTD	Not shown in Sage 50 Payroll.	Each employee's income tax paid, inclusive of any previous employment and the current period, for each updated historical period in the full tax year to date.
UseAttachTables	Not shown in Sage 50 Payroll.	A flag showing whether the pre-defined tables were used when deducting CCAEOs, CTAEOs or Earnings Arrestments for each updated historical period. 0 - Not using pre-defined tables 1 - Using pre-defined tables
WorksNumber	Not shown in Sage 50 Payroll.	The employee's works number for each updated historical period.

NOTE: In Sage 50 Payroll v21, some variables from this table have moved to the Employees.YTD table. For further information, please refer to the New variable views in v21 tab.

Employees
Variable	Location	Details
Address1-5	Employee > Employee Record > Personal > Address	The employee's address.
Analysis1	Employee > Employee Record > Analysis > Employee Analysis > Analysis 1	The first user-defined analysis field.
Analysis2	Employee > Employee Record > Analysis > Employee Analysis > Analysis 2	The second user-defined analysis field.
Analysis3	Employee > Employee Record > Analysis > Employee Analysis > Analysis 3	The third user-defined analysis field.
Apprentice	Awaiting information.	Awaiting information.
BasicSalary	Not shown in Sage 50 Payroll.	This variable doesn't apply to Sage 50 Payroll. The variable exists within the data to support Sage Instant Payroll.
BriefNotes	Employee > Employee Record > Analysis > Notes	A memo field taken from the employee record. NOTE: As the wrapping options don't work on this variable, it isn't suitable for adding long notes to reports or layouts.
Contact	Employee > Employee Record > Personal > Contact Details > Name	The name of the employee's emergency contact.
ContactAddress1-5	Employee > Employee Record > Personal > Contact Details > Address	The address of the employee's emergency contact.
ContactEmail	Employee > Employee Record > Personal > Contact Details > Email	The email address of the employee's emergency contact.
ContactMobile	Employee > Employee Record > Personal > Contact Details > Mobile	The mobile number for the employee's emergency contact.
ContactPostcode	Employee > Employee Record > Personal > Contact Details > Post Code	The postcode of the employee's emergency contact.
ContactTel	Employee > Employee Record > Personal > Contact Details > Telephone	The telephone number of the employee's emergency contact.
ContractedHours	Employee > Employee Record > Employment > Salary > This employee works	The number of hours that the employee is contracted to work.
ContractedHoursFrequency	Employee > Employee Record > Employment > Salary > contracted hours per	The employment period during which the employee works the set number of hours.
CostCentreName	Company > Settings > Analysis > Cost Centres > Name	The cost centre name.
CostCentreReference	Employee > Employee Record > Analysis > Company Analysis > Cost Centre	The cost centre number for the employee's cost centre.
Country	Employee > Employee Record > Personal > Country	The employee's country of residence.
CurrentJobTitle	Employee > Employee Record > Employment > Terms	The employee's job title.
DateDirShipBegan	Employee > Employee Record > Employment > YTD Values > Director's NIC > Date Directorship Began	The date when the employee became a director.
DateLeftPrevEmployment	Employee > Employee Record > Enter P45 > Next	The date that the employee left their previous employment.
DateOfBirth	Employee > Employee Record > Personal > Date of Birth	The employee's date of birth.
DaysHolAccruedToDate	Employee > Employee Record > Absence > Holiday > Entitlement > Accrued to date	The date to which the employee's holiday accrual is calculated.
Deceased	Employee > Employee Record > Employment > Leaver > Deceased	A flag showing whether the employee is deceased. 0 - Not deceased 1 - Deceased
DepartmentName	Company > Settings > Analysis > Departments > Name.	The name of the department.
DepartmentReference	Employee > Employee Record > Analysis > Company Analysis > Department	The department number to which the employee belongs.
DirectorStatus	Employee > Employee Record > Employment > Director Status	The director status of the employee. 0 - Not a director 1 - Director 2 - Director (Table Method)
Disabled	Employee > Employee Record > Personal > Disabled	A flag showing whether the employee is disabled. 0 - No 1 - Yes
ElectronicPayslipAgreementDate	Employee > Employee Record > Employment > Analysis	The date on which the employee agreed to receive their payslips by email.
ElectronicPayslipEmailAddress	Employee > Employee Record > Employment > Analysis	The email address to use for sending payslips to the employee.
ElectronicPayslipPassword	Employee > Employee Record > Employment > Analysis	The password to use on the PDF for the employee's payslip.
EmailAddress	Employee > Employee Record > Personal > E-Mail	The employee's email address.
EmployeeEntitlement	Employee > Employee Record > Absence > Holiday > Entitlement > Due > Employee's Entitlement	The employee's holiday entitlement for the year, taking into account the employee's start date.
EmployeeEntitlementToDate	Employee > Employee Record > Absence > Holiday > Entitlement > Accrual > Accrued to date	The employee's holiday entitlement up to the current process date, taking into account the employee's start date. NOTE: When you use this variable on a post-update report, the full employee entitlement for the year appears. On a pre-update report, this variable gives the entitlement to date.
EmploymentUntilDate	This variable isn't in use.	This variable isn't in use.
EmpPeriodDuration	Employee > Employee Record > Employment > Terms	The duration of the employment, if the employment period is temporary.
EmpPeriodTimeScale	Employee > Employee Record > Employment > Terms	The time in which the duration is measured, for example Weeks, Days, Months or Years.
EmpStatusType	Employee > Employee Record > Employment > Status	The status of the employee. This can be OK, On Hold or Trade Dispute. NOTE: This variable currently doesn't work correctly. As an alternative, you can use the variable Employees.PayStatus.
EndPIWDate	Employee > Employee Record > Absence > SSP > Previous PIW > Previous PIW > End Date	The end date of the last period of incapacity for work. If the is a current period of incapacity for work, this is the end date for the current period.
EnterPaymentNotes	Payroll > Enter Payments > Notes	The notes entered for the employee on the Enter Payments window.
EthnicOrigin	Employee > Employee Record > Personal > Ethnic Origin	The ethnic origin of the employee.
FinalPayDateFlag	Payroll > Enter Payments > Summary > Total Net Pay > Final Pay Run	A flag showing whether this is the employee's final payment period. 0 - No 1 - Yes
Forename	Employee > Employee Record > Personal > Forenames	The employee's forename.
Gender	Employee > Employee Record > Personal > Sex	The employee's gender.
HolDaysBF	Employee > Employee Record > Absence > Holiday > Entitlement > Due > B/F from previous year	Any holidays brought forward from the previous year.
HolDaysBooked	Employee > Employee Record > Absence > Holiday > Entitlement > Analysis > Days booked (not taken)	Any holidays booked in the current year.
HolDaysBookedThisPayPeriod	Not shown in Sage 50 Payroll.	Any holidays booked in the current payment period.
HolDaysCF	Employee > Employee Record > Absence > Holiday > Entitlement > Due > C/F from previous scheme	Any holidays carried forward from a previous holiday scheme.
HolDaysRemain	Employee > Employee Record > Absence > Holiday > Entitlement > Accrued Entitlement > Days Remaining	The holidays remaining to be taken in the current holiday year. This is calculated based on accrued entitlement minus any days taken.
HolDaysTaken	Employee > Employee Record > Absence > Holiday > Entitlement > Analysis > Days Taken	Any holidays taken in the current holiday year.
HolHoursBF	Employee > Employee Record > Absence > Holiday > Entitlement > Due > B/F from previous year	Any holidays brought forward from the previous year, for hourly holiday schemes.
HolHoursBooked	Employee > Employee Record > Absence > Holiday > Entitlement > Analysis > Booked (not taken)	Any holidays booked in the current year, for hourly holiday schemes.
HolHoursBookedThisPayPeriod	Not shown in Sage 50 Payroll.	Any holidays booked in the current payment period, for hourly holiday schemes.
HolHoursCF	Employee > Employee Record > Absence > Holiday > Entitlement > Due > C/F from previous scheme	Any holiday hours carried forward from a previous holiday scheme.
HolHoursRemain	Employee > Employee Record > Absence > Holiday > Entitlement > Accrued Entitlement > Remaining	Any holiday hours remaining to be taken in the current holiday year. This is calculated based on accrued entitlement minus any hours taken.
HolHoursTaken	Employee > Employee Record > Absence > Holiday > Entitlement > Analysis > Taken	Any holidays taken in the current holiday year, for hourly holiday schemes.
HolidayFundToAccrue	Employee > Employee Record > Absence > Holiday > Payments > Accrual Details > Value	The percentage of pay to accrue for the holiday fund.
HolReference	Employee > Employee Record > Absence > Holiday > Entitlement > Scheme Number	The employee's holiday scheme reference.
HolYearStartDate	Employee > Employee Record > Absence > Holiday > Settings > Scheme Start Date	The start date of the company's holiday year.
InitialForm	Employee > Employee Wizard > Next > Next > Next > P45 / P46 / None	A flag showing the type of form supplied by a new starter. 0 - None 1 - P45 2 - P46
Initials	Employee > Employee Record > Personal > Initials	The employee's initials.
LastNICCatForm	Not shown in Sage 50 Payroll.	A flag showing the last NI category warning message shown for the employee in the employee record. 0 - None 1 - CA4139, CF383 or CF380A 2 - CA2700 3 - CA4140 or CF384
LastPostingNLDate	Not shown in Sage 50 Payroll.	The date that the employee's values were last posted through the nominal link.
LastProcessedDate	Employee > Employee List > Last Updated	The date that the employee's record was last updated.
LastWeekAveCalc	Employee > Employee Record > History > View P11 > Weekly Averages > Average Type	A flag showing whether the employee's weekly average is calculated on a 12 or 13 week basis. 0 - 12 week basis 1 - 13 week basis
ManualEmployeeEntitlement
ManualHolidayEntitlement
ManualNICFlag	Employee > Employee Record > Employment > Manual NI Entry	A flag showing whether NI contributions are calculated manually. 0 - No 1 - Yes
ManualPension	Not shown in Sage 50 Payroll.	This value doesn't apply to Sage 50 Payroll. The variable appears in the table as the database is shared with Sage Instant Payroll.
ManualSSPFlag	Employee > Employee Record > Absence > SSP > Qualifying Days > Manual SSP > Manual Statutory Sick Pay Calculations	A flag showing whether SSP is calculated manually. 0 - No 1 - Yes
MaritalStatus	Employee > Employee Record > Personal > Marital Status	The employee's marital status.
MinimumWageChk	Employee > Employee Record > Employment > Pay Elements	A flag to show whether the minimum wage calculation should be done for the employee. 0 - No 1 - Yes
MobileTelephone	Employee > Employee Record > Personal > Mobile	The employee's mobile telephone number.
Nationality	Employee > Employee Record > Personal > Nationality	The nationality of the employee.
NetOfForeignTax	Awaiting information.	Awaiting information.
NICat	Employee > Employee Record > Employment > NI Category	The employee's NI category.
NICCont	Employee > Employee Record > Employment > NI Category	A flag showing whether the employee's NI category is contracted out. 0 - No 1 - Yes
NINumber	Employee > Employee Record > Employment > NI Number	The employee's NI number.
NoOfDaysHolAccrued	This variable is no longer in use.	This variable is no longer in use.
OptOutDate	Awaiting information.
P46StatementD	This variable isn't in use.	This variable isn't in use.
P46Statements	Employee > Employee Record > Employment > P46 Statement	The statement chosen on a new starter's form P46. 0 - No statement 1 - A only 2 - A and B 3 - B only 4 - B and C 5 - C only 6 - A and C
PatternStartDate	Employee > Employee Record > Absence > Holiday > Settings > Working Day Pattern (Sun - Sat) > Pattern Start Date	The date on which the qualifying date pattern for the employee's holiday starts. This date must be a Sunday.
PayByNet	Employee > Employee Record > Employment > Pay Elements > Payments > Apply Net To Gross Payments	A flag showing whether the employee is paid using net to gross. 0 - No 1 - Yes
PaymentMethod	Employee > Employee Record > Employment > Payment Method	The payment method used for the employee. This can be any of the following: BACS Cash Cheque Credit Transfer
PaymentPeriod	Employee > Employee Record > Employment > Payment Frequency	The employee's frequency of payment. This can be any of the following: Weekly Fortnightly Four weekly Monthly
PayslipComment	Employee > Employee Record > Analysis > Payslip Comment	The user-defined comment to appear on payslip layouts.
PayStatus	Employee > Employee Record > Employment > Status	The pay status of the employee. 0 - OK 1 - On Hold 2 - Trade Dispute
PensionableSalary	Employee > Employee Record > Employment > Pension > Annual Salary > Pensionable	The employee's pensionable salary for reporting to the pension provider.
PensSalEffectiveDate	Employee > Employee Record > Employment > Pension > Annual Salary > Effective From	The date from which the pensionable salary became effective.
Postcode	Employee > Employee Record > Personal > Post Code	The employee's post code.
PreviousSurname	Employee > Employee Record > Personal > Previous Surname	The previous surname of the employee.
PreviousTaxDistrict	Employee > Employee Record > Employment > YTD Values > Tax > Previous Employment > Tax Dist	The previous tax district for a new starter.
PreviousTaxRef	Employee > Employee Record > Employment > YTD Values > Tax > Previous Employment > Tax Ref	The previous tax reference for a new starter.
QDPatternStartDate	Employee > Employee Record > Absence > SSP > Qualifying Days > SSP Qualifying Day Pattern (Sun - Sat) > Pattern Start Date	The date on which the qualifying date pattern for employee absence starts. This date must be a Sunday.
QualifyingSchemeOptOut	Awaiting information.
Reference	Employee > Employee Record > Personal > Reference	The employee reference number.
Relationship	Employee > Employee Record > Personal > Contact Details > Relationship	The relationship to the employee of their emergency contact.
SalaryEvery	Not shown in Sage 50 Payroll.	This variable doesn't apply to Sage 50 Payroll. It appears in the table because the database is shared with Sage Instant Payroll.
Sensitivity	Employee > Employee Record > Analysis > Access Level	The access level set for the employee. This determines which Sage 50 Payroll users can access their record.
SLRFromDate	Employee > Employee Record > Employment > Student Loan > From	The date from which the employee's student loan repayments start.
SLRPriority	Employee > Employee Record > Employment > Student Loan > Priority	The priority of the attachment of earnings after which the student loan repayments should be deducted.
SLRProtEarnings	Employee > Employee Record > Employment > Student Loan > Protected	Any protected earnings. These can't be used when deducting student loan repayments.
SLRToDate	Employee > Employee Record > Employment > Student Loan > To	The date when the employee's student loan repayments are to end.
SLRPriority	Employee > Employee Record > Employment > Student Loan > Priority	The priority of the attachment of earnings after which the student loan repayments should be deducted.
SLRProtEarnings	Employee > Employee Record > Employment > Student Loan > Protected	Any protected earnings. These can't be used when deducting student loan repayments.
SLRToDate	Employee > Employee Record > Employment > Student Loan > To	The date when the employee's student loan repayments are to end.
SspAverage8WeeksPay	Not shown in Sage 50 Payroll.	This variable doesn't apply to Sage 50 Payroll. It appears in the table because the database is shared with Sage Instant Payroll.
SSPBand	Employee > Employee Record > Absence > SSP > Previous PIW	A flag showing whether the current period of incapacity for work qualifies for SSP. 0 - No 1 - No
SSPExclFlag	Not shown in Sage 50 Payroll.	A flag showing whether an SSP exclusion form should be issued if the SSP reaches 28 weeks. 0 - No 1 - Yes
SSPPaid	Not shown in Sage 50 Payroll.	The total SSP paid for each employee in the current period of incapacity for work, in the full tax year to date.
SSPPaidTD	Employee > Employee Record > Employment > YTD Values > Statutory Payments > Sick Pay > Total Amount Paid	The total SSP paid for each employee in the full tax year to date.
SSPTransFlag	Not shown in Sage 50 Payroll.	A flag showing whether an SSP transfer form should be issued if the SSP reaches 23 weeks. 0 - No 1 - Yes
SSPWks	Employee > Employee Record > Employment > YTD Values > Statutory Payments > Sick Pay > Weeks in PIW	The total weeks SSP paid for each employee in the full tax year to date.
StartPIWDate	Employee > Employee Record > Absence > SSP > Previous PIW > Previous PIW > Start Date	The start date of the current period of incapacity for work, if current. If there is no current period of incapacity for work, the start date of the last period of incapacity for work appears.
StatementEmploymentDetails	Employee > Employee Record > Terms > Period of Employment	Any text entered as a note against the period of employment.
StatementEmploymentPeriod	Employee > Employee Record > Terms > Period of Employment	The employee's contract, either Permanent, Fixed term or Temporary.
StatementNoticeDetails	Employee > Employee Record > Terms > Notice Period	Any text entered as a note against the notice period.
StatementNoticePeriod	Employee > Employee Record > Terms > Notice Period	The amount of notice the employee must give.
StatementOfEmployment	Employee > Employee Record > Employment > Terms	The name of the statement of employment template set for the employee.
StatementSSPDetails	Employee > Employee Record > Employment > SSP Terms and Conditions	Any text entered as a note against the SSP terms and conditions.
StatementSSPTerms	Employee > Employee Record > Employment > SSP Terms and Conditions	The type of sick pay the employee receives, either Company Sick Pay or Occupational Sick Pay.
StatementUpdateRequired	Employee > Statement of employment.	This variable indicates if a new statement of employment should be printed for the employee.
Surname	Employee > Employee Record > Personal > Surname	The employee's surname.
Tax Code	Employee > Employee Record > Employment > Tax Code	The employee's current tax code.
TaxCodePrevEmployment	Not shown in Sage 50 Payroll.	The employee's tax code from any previous employment.
Telephone	Employee > Employee Record > Personal > Telephone	The employee's telephone number.
Title	Employee > Employee Record > Personal > Title	The employee's title.
TitleAndName	Employee > Employee Record > Personal > Title + Initials + Surname	The employee's title, initials and surname.
UseAttachTables	Employee > Employee Record > Employment > Pay Elements > Attachment of Earnings Orders > Use Tables for Community Charge, Council Tax, Earning Arrestments and Fines Enforcement	A flag showing whether pre-defined tables should be used when deducting CCAEOs, CTAEOs or Earning Arrestments. 0 - Not using pre-defined tables 1 - Using pre-defined tables
UseElectronicPayslip	Employee > Employee Record > Employment > Analysis	A flag showing whether the employee receives their payslips by email.
UseManualHolEntitlement	Awaiting information.	Awaiting information.
UseManualSSPAverage	Awaiting information.	Awaiting information.
UserID	Not shown in Sage 50 Payroll.	The login reference for the user logged in to Sage 50 Payroll.
Sensitivity	Employee > Employee Record > Analysis > Employee Access Level	The access level a user must have to be able to work with this employee's information.
WaitDays	Employee > Employee Record > Absence > SSP > Previous PIW > Previous PIW > Accrued waiting days	The number of waiting days accrued during the employee's period of incapacity for work.
WelfareToWork	Employee > Employee Record > Employment > Welfare To Work	Indicates if the employee is part of the Welfare To Work scheme.
Wk1BasisFlag	Employee > Employee Record > Employment > Wk1 / Mth1 Basis	A flag showing whether the employee's tax is calculated on a week 1 / month 1 basis. 0 - No 1 - Yes
Wk1BasisFlagPrevEmployment		A flag showing whether the employee's tax was calculated on a week 1 / month 1 basis during their previous employment. 0 - No 1 - Yes
WorkEndDate	Employee > Employee Record > Employment > Employment Period To	The date that the employee left their employment.
WorksNumber	Employee > Employee Record > Employment > Works Number	The employee's works number.
WorkStartDate	Employee > Employee Record > Employment > Employment Period From	The date that the employee started their employment.

EmployeeLoans
Variable	Location	Details
Amount	Employee > Employee Record > Employment > Pay Elements > Loans > Loan Amount	The total amount of the loan to be repaid.
AmountPaidTD	Employee > Employee Record > Employment > Pay Elements > Loans > Amount Paid To Date	The total amount of the loan repaid to date.
AmtPaidCur	Payroll > Enter Payments > Loans > Repayment Made	The amount of the loan actually repaid in the current pre-update period.
AmtPaidHol	Payroll > Enter Payments > Advance Pay > Loans > Repayment Due	The amount of the loan actually repaid in the current advanced pre-update period.
AmtToPayCur	Payroll > Enter Payments > Loans > Repayment Due	The amount of the loan to be repaid in the current pre-update period.
AmtToPayHol	Payroll > Enter Payments > Advance Pay > Loans > Repayment Due	The amount of the loan to be repaid in the current advanced pre-update period.
CustomReportOrder	Company > Custom Reports > New / Edit > Loans > Index	The index number for this loan within custom reports.
DefaultAmount	Company > Pay Elements > Loans > Loan Amount	The default total amount of the loan type. If the default amount has been changed for this employee, this variable still prints the original default amount.
DefaultNDR	Company > Pay Elements > Loans > Normal Deduction Rate	The default rate at which the loan repayments are to be deducted in each payment period. If the default rate has been changed for this employee, this variable still prints the original default amount.
Description	Company > Pay Elements > Loans > Description	The description of the loan.
Instance	Not shown in Sage 50 Payroll.	An internal identifier for the loan within the employee record. This increases by one for each loan on the employee record and resets for the next employee.
LoanReference	Company > Pay Elements > Loans > Ref	The reference number for the loan. This is set at a company level.
NDR	Employee > Employee Record > Employment > Pay Elements > Loans > Normal Deduction Rate	The normal rate at which the loan repayments are to be deducted in each payment period.
Reference	Employee > Employee Record > Personal > Reference	The employee reference number.
StartDate	Employee > Employee Record > Employment > Pay Elements > Loans > Start Date	The date from which the employee is to start repaying the loan.
Status	Employee > Employee Record > Employment > Pay Elements > Loans > Status	The current status of the loan. This can be any of the following: Active Written Off Paid
TransferP11D	Company > Pay Elements > Loans > New / Edit > P11D > Transfer to Sage P11D	A flag showing whether the loan details can be transferred to Sage P11D. 0 - No 1 - Yes

EmployeePayments
Variable	Location	Details
AmtCur	Payroll > Enter Payments > Payments > Amount	The amount of the payment type for the employee in the current period.
AmtHol	Payroll > Enter Payments > Advance Pay > Payments > Amount	The amount of the payment type for the employee in the advanced period.
AmtTotal	Not shown in Sage 50 Payroll.	The total amount of the payment type for the employee in both the current and advanced period.
AutoAdv	Company > Pay Elements > Net Payments / Payments > New / Edit > Add this value before calculating > Pension (AVC)	A flag which shows whether the last updated payment values are automatically used in the holiday period when the holiday pay is advanced. 0 - No 1 - Yes
AVCFlag	Company > Pay Elements > Net Payments / Payments > New / Edit > Holiday > Auto Advance	A flag showing whether this payment type should be added before calculating AVCs. 0 - No 1 - Yes
BasePaymentRef	Not shown in Sage 50 Payroll.	The reference of the pay element used as the base of a factor.
BatchOrderFourWeekly	Payroll > TimeSheet Entry	The order in which the payment types appear in TimeSheet Entry for four weekly paid employees.
BatchOrderMonthly	Payroll > TimeSheet Entry	The order in which the payment types appear in TimeSheet Entry for monthly paid employees.
BatchOrderTwoWeekly	Payroll > TimeSheet Entry	The order in which the payment types appear in TimeSheet Entry for two weekly paid employees.
BatchOrderWeekly	Payroll > TimeSheet Entry	The order in which the payment types appear in TimeSheet Entry for weekly paid employees.
CCAEOFlag	Company > Pay Elements > Net Payments / Payments > New / Edit > Add this value before calculating > CCAEO	A flag showing whether this payment type should be added before calculating Community Charge Attachment OF Earnings Orders. 0 - No 1 - No
ClearYE	This variable isn't in use.	This variable isn't in use.
CTAEOFlag	Company > Pay Elements > Net Payments / Payments > New / Edit > Add this value before calculating > CTAEO	A flag showing whether this payment type should be added before calculating Council Tax Attachment of Earnings Orders. 0 - No 1 - Yes
CustomReportOrder	Company > Custom Reports > New / Edit > Payments > Index	The index number used for this payment type in the default custom report setting.
DefaultFactorMultiplier	Employee > Employee Record > Employment > Pay Elements > Payments > Multiplier	The default multiplier rate for factored pay elements.
DefaultHrsNo	Employee > Employee Record > Employment > Pay Elements > Payments > Default Hours / No	The employee's default hours or number for the payment type.
DefaultRateAmt	Employee > Employee Record > Employment > Pay Elements > Payments > Default Rate	The employee's rate for the payment type.
Description	Company > Pay Elements > Net Payments / Payments > Description	The description of the payment type.
EndOfTaxYear	Not shown in Sage 50 Payroll.	The end of the tax year to which the YTD value applies.
ERPays	Company > Pay Elements > Net Payments > New / Edit > Payment Adjusted For Employee's Tax / Employee's Tax and NI	A flag showing whether this payment type is to be grossed up. 0 - Not grossed up - the values are taken from the Payments tab 1 - Grossed up for PAYE only - the value is taken from the Net Payments tab 2 - Grossed up for both PAYE and NI - the value is also from the Net Payments tab
FactorMultiplierCur	Payroll > Enter Payments > Payments > Multiplier	The multiplier rate for the payment type in the current period.
FactorMultiplierHol	Payroll > Enter Payments > Advance Pay > Payments > Multiplier	The multiplier rate for the payment type in the advanced period.
HolidayAccrual	Company > Pay Elements > Net Payments / Payments > New / Edit > Holiday > Include for Holiday Accrual	A flag showing whether this payment type is to be included when calculating the holiday fund accrual. 0 - No 1 - Yes
HrsNo	Company > Pay Elements > Net Payments / Payments > New / Edit > Default Hours / No	The default hours or number set for the payment type at a company level.
HrsNoCur	Payroll > Enter Payments > Payments > Hours / No	The hours or number for each payment type in the current period.
HrsNoHol	Payroll > Enter Payments > Advance Pay > Payments > Multiplier	The hours or number for each payment type in the advanced period.
Inc12Week	Company > Pay Elements > Net Payments / Payments > New / Edit > Holiday > Include for Weekly Average	A flag showing whether this payment type is to be included when calculating the weekly average gross pay. 0 - No 1 - Yes
IncForTimesheets	Company > Pay Elements > New / Edit > Include in TimeSheet Entry	Indicates if this pay element is to be shown on the TimeSheet Entry window.
IncForVariance	Company > Variance Settings > Payments > Variance > Include	A flag showing whether the payment type is included in the variance analysis. 0 - No 1 - Yes
IncludeInSalarySacrifice	Company > Pay Elements > New/Edit > Salary Sacrifice	A flag indicating whether the payment type is taken into account for salary sacrifice pension schemes. 0 - No 1 - Yes
Instance	Not shown in Sage 50 Payroll.	A unique reference number for the payment type. This is set at an employee record level.
InUse	Employee > Employee Record > Employment > Pay Elements > Payments > In Use flag	A variable marking whether the pay element is in use for the employee. Pay elements with this option set to No do not appear in Enter Payments.
MultiplierDesc	Company > Pay Elements > Net Payments / Payments > New / Edit	Shows whether the factor is a percentage of the payment or a multiplier.
NICFlag	Company > Pay Elements > Net Payments / Payments > New / Edit > Add this value before calculating > National Insurance	A flag showing whether this payment type should be added before calculating NI contributions. 0 - No 1 - Yes
OtherAttachFlag	Company > Pay Elements > Net Payments / Payments > New / Edit > Add this value before calculating > Other AEOs	A flag showing whether this payment type should be added before calculating other AEOs. 0 - No 1 - Yes
PaymentReference	Company > Pay Elements > Payments > Ref	A unique reference number for the payment type. This is set at a company level.
PensnFlag	Company > Pay Elements > Net Payments / Payments > New / Edit > Add this value before calculating > Pension (Main)	A flag showing whether this payment type should be added before calculating pension contributions. 0 - No 1 - Yes
RateAmt	Company > Pay Elements > Net Payments / Payments > Rate	The default rate set for the payment type at a company level.
RateAmtCur	Payroll > Enter Payments > Payments > Rate	The actual rate used for the payment type in the current period.
RateAmtHol	Payroll > Enter Payments > Advance Pay > Payments > Rate	The actual rate used for the payment type in the advanced period.
RateAmtPreAdjust	Not shown in Sage 50 Payroll.	The rate before any adjustment for the minimum wage.
Reference	Employee > Employee Record > Personal > Reference	The employee reference number.
Status	Company > Pay Elements > Net Payments / Payments > Status	The status of the payment type. This can be any of the following: Variable Global Fixed
TaxFlag	Company > Pay Elements > Net Payments > Payments > New / Edit > Add this value before calculating > PAYE	A flag showing whether this payment type should be added before calculating income tax. 0 - No 1 - Yes
ValueTD	Employee > Employee Record > Employment > YTD Values > Payments & Deductions > Amount	The amount paid for the payment type within the specified tax year.
VarianceAmount	Company > Variance Settings > Payments > Variance > Variance	The amount of the variance.
VarianceType	Company > Variance Settings > Payments > Variance > Variance Type	The type of variance. 0 - Fixed Amount 1 - Percentage
VarianceTypeText	Company > Variance Settings > Payments >Variance > Variance Type	The description of the type of variance. This can be any of the following: N/A Fixed Amount Percentage

EmployeePensions
Variable	Location	Details
AdministratorEMail	Company > Pension Schemes > New / Edit > Details > Administrator Details > E-Mail	The email address of the pension administrator.
AdministratorName	Company > Pension Schemes > New / Edit > Details > Administrator Details > Name	The name of the pension administrator.
AdministratorTelephone	Company > Pension Schemes > New / Edit > Details > Administrator Details > Telephone	The telephone number of the pension administrator.
AVCAmount	Payroll > Enter Payments > Summary > Pension Contributions > AVC (Current)	The employee's advance voluntary pension contributions for the current pay period.
AVCAmountAdvanced	Payroll > Enter Payments > Summary > Pension Contributions > AVC (Advanced)	The employee's advance voluntary pension contributions for the advanced pay period.
AVCTD	Employee > Employee Record > Employment > YTD Values > Pension > Pension (AVC)	The employee's year to date AVCs for each pension scheme in the specified tax year.
EmployeeAmount	Payroll > Enter Payments > Summary > Pension Contributions > Pension (Current)	The employee's pension contributions, including AVCs, for the current pay period.
EmployeeAmountAdvanced	Payroll > Enter Payments > Summary > Pension Contributions > Pension (Advanced)	The employee's pension contributions, including AVCs, for the advanced pay period.
EmployeeBandOption	Company > Pension Schemes > New / Edit > Employee > Contribution Details > Band Options	A code for the application to pensionable earnings for the employee. 0 - Apply to all pensionable earnings 1 - Restrict to statutory NI upper / lower bands 2 - Restrict to specific upper / lower bands
EmployeeLimitFlag	This variable isn't in use.	This variable isn't in use.
EmployeeLowerEarnings	Company > Pension Schemes > New / Edit > Employee > Contribution Details > Lower	The lower value for employer's pensionable pay, if the pensionable earnings on which the employee's pension contribution is based is restricted to user defined parameters.
EmployeeMaximum	Company > Pension Schemes > New / Edit > Employee > Contribution Details > Maximum Contribution (period)	The maximum employee contribution in the pay period if set within the pension scheme. This option only applies if the type of contribution is set to percentage.
EmployeeMinimum	Company > Pension Schemes > New / Edit > Employee > Contribution Details > Minimum Contribution (period)	The minimum employee contribution in the pay period if set within the pension scheme. This option only applies if the type of contribution is set to percentage.
EmployeePercFix	Employee > Employee Record > Employment > Pension > Add / Edit > Pension Details > Employee Contributions > Amount	The amount or percentage applied as the employee pension contribution. NOTE: This variable only prints a value if the value on the employee's record is different from the company default.
EmployeePercFixFlag	Employee > Employee Record > Employment > Pension > Add / Edit > Pension Details > Employee Contributions > Fixed or Percentage	The type of employee pension contribution for this pension scheme as set on the employee record. This can be either Percentage or Fixed Amount. NOTE: This variable only prints a value if the value on the employee's record is different from the company default.
EmployeeRebateFlag	Company > Pension Schemes > New / Edit > Employee > Settings > Calculate Minimum Rebate	A flag showing whether the NI contracted out rebate for employees, or the minimum contribution to a contracted out pension scheme, is calculated. 0 - Not calculated 1 - Calculated
EmployeeReliefFlag	Company > Pension Schemes > New / Edit > Employee > Settings > Deduct Before Tax	A flag showing whether the employee's pension contribution is deducted before or after tax is calculated. 0 - Deducted after tax 1 - Deducted before tax
EmployeeSAPFlag	Company > Pension Schemes > New / Edit > Employee > Settings > Include SAP Payments	A flag showing whether SAP is included when calculating the amount of pay to use when calculating the employee's pension contribution. 0 - No 1 - Yes
EmployeeSchemeRef	Employee > Employee Record > Employment > Pension > Add / Edit > Pension Details > Employee Pension Reference	A unique employee pension reference for the scheme.
EmployeeShPPFlag	Company > Pension Schemes > New / Edit > Employee > Settings > Include ShPP Payments	A flag showing whether ShPP is included when calculating the amount of pay to use when calculating the employee's pension contribution. 0 - No 1 - Yes
EmployeeSMPFlag	Company > Pension Schemes > New / Edit > Employee > Settings > Include SMP Payments	A flag showing whether SMP is included when calculating the amount of pay to use when calculating the employee's pension contribution. 0 - No 1 - Yes
EmployeeSPPFlag	Company > Pension Schemes > New / Edit > Employee > Settings > Include SPP Payments	A flag showing whether SPP is included when calculating the amount of pay to use when calculating the employee's pension contribution. 0 - No 1 - Yes
EmployeeSSPFlag	Company > Pension Schemes > New / Edit > Employee > Settings > Include SSP Payments	A flag showing whether SSP is included when calculating the amount of pay to use when calculating the employee's pension contribution. 0 - No 1 - Yes
EmployeeTD	Employee > Employee Record > Employment > YTD Values > Pension > Pension (Main)	The employee's pension contributions, excluding AVCs, for each pension scheme in the specified tax year.
EmployeeTotalFlag	Company > Pension Schemes > New / Edit > Employee > Settings > Include Rebate and Amount	A flag showing whether the minimum rebate value is added to the employee's pension contribution. 0 - Uses the value or the contribution or the rebate, whichever is higher. 1 - Uses the total of the contribution and the rebate
EmployeeUpperEarnings	Company > Pension Schemes > New / Edit > Employee > Contribution Details > Upper	The upper value for the employer's pensionable pay, if the earnings on which the employee's pension contribution is based are restricted to use defined parameters.
EmployerAmount	Payroll > Enter Payments > Summary > Pension Contributions > Employers (Current)	The employer's pension contributions for the current pay period.
EmployerAmountAdvanced	Payroll > Enter Payments > Summary > Pension Contributions > Employers (Advanced)	The employer's pension contributions for the advanced pay period.
EmployerBandOption	Company > Pension Schemes > New / Edit > Employer > Contribution Details > Band Options	A code showing the application to pensionable earnings for the employer. 0 - Apply to all pensionable earnings 1 - Restrict to statutory NI upper / lower bands 2 - Restrict to specific upper / lower bands
EmployerLimitFlag	This variable isn't in use.	This variable isn't in use.
EmployerLowerEarnings	Company > Pension Schemes > New / Edit > Employer > Contribution Details > Lower	The lower value for the employer's pensionable pay, if the earnings on which the employee's pension contribution is based are restricted to use defined parameters.
EmployerMaximum	Company > Pension Schemes > New / Edit > Employer > Contribution Details > Maximum Contribution (period)	The maximum employer contribution in the pay period if the pension scheme includes a maximum contribution per pay period. This only applies if the type of contribution is set to percentage.
EmployerMinimum	Company > Pension Schemes > New / Edit > Employer > Contribution Details > Minimum Contribution (period)	The minimum employer contribution in the pay period if the pension scheme includes a minimum contribution per pay period. This only applies if the type of contribution is set to percentage.
EmployerPercFix	Employee > Employee Record > Employment > Pension > Add / Edit > Pension Details > Employer Contributions > Amount	The amount or percentage applied as the employer pension contribution. NOTE: This variable only prints a value if the value on the employee's record is different from the company default.
EmployerPercFixFlag	Employee > Employee Record > Employment > Pension > Add / Edit > Pension Details > Employer Contributions > Fixed or Percentage	The type of employer pension contribution for this pension scheme as set on the employee record. This can be either Percentage or Fixed Amount. NOTE: This variable only prints a value if the value on the employee's record is different from the company default.
EmployerRebateFlag	Company > Pension Schemes > New / Edit > Employer > Settings > Calculate Minimum Rebate	A flag showing whether the NI contracted out rebate for employers is calculated. 0 - Not calculated 1 - Calculated
EmployerReliefFlag	This variable isn't in use.	This variable isn't in use.
EmployerSAPFlag	Company > Pension Schemes > New / Edit > Employer > Settings > Include SAP Payments	A flag showing whether SAP is included when calculating the amount of pay to use when calculating the employer's pension contribution. 0 - No 1 - Yes
EmployerShPPFlag	Company > Pension Schemes > New / Edit > Employer > Settings > Include ShPP Payments	A flag showing whether ShPP is included when calculating the amount of pay to use when calculating the employer's pension contribution. 0 - No 1 - Yes
EmployerSMPFlag	Company > Pension Schemes > New / Edit > Employer > Settings > Include SMP Payments	A flag showing whether SMP is included when calculating the amount of pay to use when calculating the employer's pension contribution. 0 - No 1 - Yes
EmployerSPPFlag	Company > Pension Schemes > New / Edit > Employer > Settings > Include SPP Payments	A flag showing whether SPP is included when calculating the amount of pay to use when calculating the employer's pension contribution. 0 - No 1 - Yes
EmployerSSPFlag	Company > Pension Schemes > New / Edit > Employer > Settings > Include SSP Payments	A flag showing whether SSP is included when calculating the amount of pay to use when calculating the employer's pension contribution. 0 - No 1 - Yes
EmployerTD	Employee > Employee Record > Employment > YTD Values > Pension > Employer's Pension	The employer's pension contributions for each pension scheme in the specified tax year.
EmployerTotalFlag	Company > Pension Schemes > New / Edit > Employer > Settings > Include Rebate and Amount	A flag showing whether the minimum rebate value is added to the employer's pension contribution. 0 - Uses the value or the contribution or the rebate, whichever is higher. 1 - Uses the total of the contribution and the rebate
EmployerUpperEarnings	Company > Pension Schemes > New / Edit > Employer > Contribution Details > Upper	The upper value for the employer's pensionable pay, if the earnings on which the employer's pension contribution is based are restricted to user defined parameters.
EndOfTaxYear	Not shown in Sage 50 Payroll.	The end of the tax year to which the YTD value applies.
IsSalarySacrifice	Company > Pension Schemes > New / Edit > Salary Sacrifice Scheme	A flag to indicate if this is a salary sacrifice pension scheme.
JoinedScheme	Employee > Employee Record > Employment > Pension > Add / Edit > Pension Details > Dates > Joined Scheme	The date when the employee joined or is due to join the pension scheme.
LeftScheme	Employee > Employee Record > Employment > Pension > Add / Edit > Pension Details > Dates > Left Scheme	The date when the employee left or is due to leave the pension scheme.
LocalAVCAmount	Employee > Employee Record > Employment > Pension > Add / Edit > Pension Details > Additional Voluntary Contribution > Amount	The amount or percentage of AVC for the pension scheme.
LocalAVCType	Employee > Employee Record > Employment > Pension > Add / Edit > Pension Details > Additional Voluntary Contribution > Fixed or Percentage	The type of AVC for this pension scheme. This can be either Percentage or Fixed Amount.
LocalPension	Not shown in Sage 50 Payroll.	A flag showing whether any of the pension settings have been changed from the company defaults for the pension scheme. 0 - The employee's settings for the pension scheme are the default. 1 - The employee's settings for the pension scheme have been changed from the company defaults.
MinEmploymentPeriod	Company > Pension Schemes > New / Edit > Details > Pension Details > Minimum Employment Period (Months)	The minimum number of months an employee needs to work before they are eligible for the pension scheme.
PaymentMethod	Company > Pension Schemes > New / Edit > Provider > Provider Payment Details > Payment Method	The method by which the provider is paid. Cheque Direct Credit Direct Debit Telegraphic Transfer
PensionDescription	Company > Pension Schemes > New / Edit > Details > Pension Details > Description	The description of the pension scheme.
PensionReference	Company > Pension Schemes > New / Edit > Details > Pension Details > Reference	A unique internal numeric identifier for each pension scheme.
PensionType	Company > Pension Schemes > New / Edit > Details > Pension Details > Type	The type of the pension scheme. 0 - Other 1 - COMP 2 - COSR 3 - CISR 4 - COMB 5 - GPP 6 - PPP 7 - Stakeholder
PrimaryScheme	Employee > Employee Record > Employment > Pension > Add / Edit > Pension Details > Primary Scheme	A flag showing whether the pension scheme is the employee's primary pension scheme. 0 - The scheme isn't the primary scheme. 1 - The scheme is the primary scheme.
ProviderAccNumber	Company > Pension Schemes > New / Edit > Provider > Provider Payment Details > A/C No	The pension provider's bank account number.
ProviderAccType	Company > Pension Schemes > New / Edit > Provider > Provider Payment Details > Bank A/C Type	The pension provider's bank account type. This can be either Bank Account or Building Society Account.
ProviderAddress1-5	Company > Pension Schemes > New / Edit > Provider > Provider Details > Address	The pension provider's address.
ProviderContact	Company > Pension Schemes > New / Edit > Provider > Provider details > Contact	The pension provider's contact name.
ProviderEmail	Company > Pension Schemes > New / Edit > Provider > Provider Details > E-Mail	The pension provider's email address.
ProviderFax	Company > Pension Schemes > New / Edit > Provider > Provider Details > Facsimile	The pension provider's fax number.
ProviderName	Company > Pension Schemes > New / Edit > Provider > Provider Details > Name	The name of the pension provider.
ProviderNotifiedJoined	Employee > Employee Record > Employment > Pension > Add / Edit > Pension Details > Dates > Provider Notified (Joined)	A flag showing whether the pension provider has been notified that the employee has joined the pension scheme. 0 - Not notified 1 - Notified
ProviderNotifiedLeft	Employee > Employee Record > Employment > Pension > Add / Edit > Pension Details > Dates > Provider Notified (Left)	A flag showing whether the pension provider has been notified that the employee has left the pension scheme. 0 - Not notified 1 - Notified
ProviderPostcode	Company > Pension Schemes > New / Edit > Provider > Provider Details > Post Code	The pension provider's post code.
ProviderRollNumber	Company > Pension Schemes > New / Edit > Provider > Provider Payment Details > B/Soc Roll No	The pension providers building society roll number.
ProviderSchemeRef	Company > Pension Schemes > New / Edit > Provider > Provider Details > Scheme Ref	The scheme number of the pension provider.
ProviderSortCode	Company > Pension Schemes > New / Edit > Provider > Provider Payment Details > Sort Code	The pension provider's bank sort code.
ProvidersRef	Company > Pension Schemes > New / Edit > Provider > Provider Details > Providers Ref	The company reference for the pension provider.
ProviderTelephone	Company > Pension Schemes > New / Edit > Provider > Provider Details > Telephone	The pension provider's telephone number.
Reference	Employee > Employee Record > Reference	The employee reference number.
SalarySacrificeAmount	Payroll > Enter Payments > Information > Salary Sacrifice	The salary sacrifice amount in the current pay period.
SalarySacrificeAmountAdvanced	Not shown in Sage 50 Payroll.	The salary sacrifice amount for the advanced period.
SalarySacrificeTD	Not shown in Sage 50 Payroll.	The full salary sacrifice amount in the tax year to date.
SchemeRef	Employee > Employee Record > Employment > Pension > Add / Edit > Pension Details > Scheme Reference	A unique reference for the pension scheme.
SCONRef	Company > Pension Schemes > New / Edit > Details > Scheme Details > SCON	The scheme contracted out number, if you run a contracted out occupational pension scheme.
Type	Employee > Employee Record > Employment > Pension > Add / Edit > Pension Details > Type	The type of the pension scheme. This can be any of the following: COMP COSR CISR COMB GPP PPP Stakeholder

EmployeesYTD
Variable	Location	Details
ASPPAWks	Employee > Employee Record > Employment > YTD Values > Statutory Payments >Paternity Pay/Paternity Pay (Adoption)	The total weeks ASPPA paid for each employee in the full tax year to date.
ASPPNICCompTD	Employee > Employee Record > Employment > YTD Values > Statutory Payments >Paternity Pay/Paternity Pay (Adoption)	The total NI compensation applicable to ASPP in the full tax year to date.
ASPPPaidTD	Employee > Employee Record > Employment > YTD Values > Statutory Payments >Paternity Pay/Paternity Pay (Adoption)	The ASPP paid for each employee in the full tax year to date
ASPPRecovdTD	Employee > Employee Record > Employment > YTD Values > Statutory Payments >Paternity Pay/Paternity Pay (Adoption)	The ASPP recovered for each employee in the full tax year to date.
ASPPWks	Employee > Employee Record > Employment > YTD Values > Statutory Payments >Paternity Pay/Paternity Pay (Adoption)	The total number of weeks ASPP paid for each employee in the full tax year to date.
AVCAmountTD	Employee > Employee Record > Employment > YTD Values > Other YTD > Pension > Pension (AVC)	The Advance Voluntary Contributions (AVC) for the year to date for each employee. This shows one value for all of the employee's pension schemes.
CashRndBF	Employee > Employee Record > Employment > YTD Values > Other YTD > Pension > Pension (AVC) or Employee > Employee Record > Employment > YTD Values > Pension > AVC	The cash rounding value brought forward year to date, for each employee.
Class1ACars	Employee > Employee Record > Employment > YTD Values > NIC > Contributions > Car Charges (Class 1A)	The Class 1A value on company cars year to date for each employee.
Class1AFuel	Employee > Employee Record > Employment > YTD Values > NIC > Contributions > Fuel Charges (Class 1A)	The Class 1A value on fuel for company cars year to date for each employee.
DirEarnsAsEE	Employee > Employee Record > Employment > YTD Values > Director's NIC > As Employee - NI-able Earnings	Standard earnings for NI contributions year to date, prior to the employee being made a director.
DirEarnsCur	Employee > Employee Record > Employment > YTD Values > Director's NIC > Current - NI-able Earnings	Standard earnings for NI contributions year to date, prior to the employee being made a director.
DirEarnsPrv1	Employee > Employee Record > Employment > YTD Values > Director's NIC > Previous 1 - NI-able Earnings	Standard earnings for NI contributions year to date, for the employee's previous NI category.
DirEarnsPrv2	Employee > Employee Record > Employment > YTD Values > Director's NIC > Previous 2 - NI-able Earnings	Standard earnings for NI contributions year to date, for the employee's second previous NI category.
DirEarnsPrv3	Employee > Employee Record > Employment > YTD Values > Director's NIC > Previous 3 - NI-able Earnings	Standard earnings for NI contributions year to date, for the employee's third previous NI category.
DirEENICAsEE	Employee > Employee Record > Employment > YTD Values > Director's NIC > As Employee - Employee's NI	Employee NI contributions year to date for the employee prior to being a director.
DirEENICCur	Employee > Employee Record > Employment > YTD Values > Director's NIC > Current - Employee's NIC	Employee NI contributions year to date for the employee's current NI category.
DirEENICPrv1	Employee > Employee Record > Employment > YTD Values > Director's NIC > Previous 1 - Employee's NIC	The employee's NI rebate for contracted out employees year to date for the employee's previous NI category.
DirEENICPrv2	Employee > Employee Record > Employment > YTD Values > Director's NIC > Previous 2 - Employee's NIC	The employee's NI rebate for contracted out employees year to date for the employee's second previous NI category.
DirEENICPrv3	Employee > Employee Record > Employment > YTD Values > Director's NIC > Previous 3 - Employee's NIC	The employee's NI rebate for contracted out employees year to date for the employee's third previous NI category.
DirEERebateAsEE	Employee > Employee Record > Employment > YTD Values > Director's NIC > As Employee - Employer's NIC Rebate	The employer NI rebate for contracted out employees year to date, prior to being a director.
DirEERebateCur	Employee > Employee Record > Employment > YTD Values > Director's NIC > Current - Employer's NIC Rebate	The employer NI rebate for contracted out employees year to date, for the employee's current NI category.
DirEERebatePrv1	Employee > Employee Record > Employment > YTD Values > Director's NIC > Previous 1 - Employer's NIC Rebate	The employer's NI rebate for contracted out employees year to date for the employee's previous NI category.
DirEERebatePrv2	Employee > Employee Record > Employment > YTD Values > Director's NIC > Previous 2 - Employer's NIC Rebate	The employer's NI rebate for contracted out employees year to date for the employee's second previous NI category.
DirEERebatePrv3	Employee > Employee Record > Employment > YTD Values > Director's NIC > Previous 3 - Employer's NIC Rebate	The employer's NI rebate for contracted out employees year to date for the employee's third previous NI category.
DirERNICAsEE	Employee > Employee Record > Employment > YTD Values > Director's NIC > As Employee - Employer's NIC	The employer NI contributions year to date for the employee prior to being made a director.
DirERNICCur	Employee > Employee Record > Employment > YTD Values > Director's NIC > Current - Employer's NIC	The employer NI contributions year to date for the employee's current NI category.
DirERNICPrv1	Employee > Employee Record > Employment > YTD Values > Director's NIC > Previous 1 - Employer's NIC	The employer NI contributions year to date for the employee's previous NI category.
DirERNICPrv2	Employee > Employee Record > Employment > YTD Values > Director's NIC > Previous 2 - Employer's NIC	The employer NI contributions year to date for the employee's second previous NI category.
DirERNICPrv3	Employee > Employee Record > Employment > YTD Values > Director's NIC > Previous 3 - Employer's NIC	The employer NI contributions year to date for the employee's third previous NI category.
DirERRebateAsEE	Employee > Employee Record > Employment > YTD Values > Director's NIC > As Employee - Employer's NIC Rebate	The employer NI rebate for contracted out employees year to date, prior to being made a director.
DirERRebateCur	Employee > Employee Record > Employment > YTD Values > Director's NIC > Current - Employer's NIC Rebate	The employer NI rebate for contracted out employees year to date for the employee's current NI category.
DirERRebatePrv1	Employee > Employee Record > Employment > YTD Values > Director's NIC > Previous 1 - Employer's NIC Rebate	The employer's NIC rebate for contracted out employees year to date, for the employee's previous NI category.
DirERRebatePrv2	Employee > Employee Record > Employment > YTD Values > Director's NIC > Previous 2 - Employer's NIC Rebate	The employer's NIC rebate for contracted out employees year to date, for the employee's second previous NI category.
DirERRebatePrv3	Employee > Employee Record > Employment > YTD Values > Director's NIC > Previous 3 - Employer's NIC Rebate	The employer's NIC rebate for contracted out employees year to date, for the employee's third previous NI category.
DirGrossAsEE	Employee > Employee Record > Employment > YTD Values > Director's NIC > As Employee - Gross for NI	Gross pay to be taken into account for calculating NI contributions year to date, for the employment prior to being made a director.
DirGrossCur	Employee > Employee Record > Employment > YTD Values > Director's NIC > Current - Gross for NI	Gross pay to be taken into account for calculating NI contributions year to date for the employee's current NI category.
DirGrossPrv1	Employee > Employee Record > Employment > YTD Values > Director's NIC > Previous 1 - Gross for NI	Gross pay to be taken into account for calculating NI contributions year to date for the employee's previous NI category.
DirGrossPrv2	Employee > Employee Record > Employment > YTD Values > Director's NIC > Previous 2 - Gross for NI	Gross pay to be taken into account for calculating NI contributions year to date for the employee's second previous NI category.
DirGrossPrv3	Employee > Employee Record > Employment > YTD Values > Director's NIC > Previous 2 - Gross for NI	Gross pay to be taken into account for calculating NI contributions year to date for the employee's third previous NI category.
DirHasAPP	Employee > Employee Record > Employment > YTD Values > Director's NIC > Does Director have an Appropriate Personal Pension?	A flag showing whether the director has an appropriate personal pension. 0 - No 1 - Yes
DirNICatCurrent	Employee > Employee Record > Employment > YTD Values > Director's NIC > Current > NI Category	The current NI category for a director for this year.
DirNICCatPrv1	Employee > Employee Record > Employment > YTD Values > Director's NIC > Previous 1 - NI Category	The employee's previous NI category.
DirNICCatPrv2	Employee > Employee Record > Employment > YTD Values > Director's NIC > Previous 2 - NI Category	The employee's second previous NI category.
DirNICCatPrv3	Employee > Employee Record > Employment > YTD Values > Director's NIC > Previous 3 - NI Category	The employee's third previous NI category.
EmployeeNICTD	Not shown in Sage 50 Payroll.	The gross NI contributions year to date for each employee.
EmployeeRebate	Employee > Employee Record > Employment > YTD Values > NIC > Contributions > Employee's NIC Rebate	The employee's NI rebate year to date for each employee.
EmployerCostTD	Not shown in Sage 50 Payroll.	The year to date value, including the current un-updated value, of the total costs to the employer.
EmployerNICTD	Not shown in Sage 50 Payroll.	The gross employer NI contributions year to date for each employee.
EmployerRebate	Employee > Employee Record > Employment > YTD Values > NIC > Contributions > Employer's NIC Rebate	The employer's NI rebate year to date for each employee.
EndOfTaxYear	Not shown in Sage 50 Payroll.	The end of the tax year to which the cumulative value applies.
HolidayFund	Employee >Employee Record > Employment > YTD Values > Other YTD > Other > Holiday Fund	The holiday fund accrued for each employee for the full tax year to date.
HolidayFundPaidByEmployer	Not shown in Sage 50 Payroll.	The total value of holiday fund paid by the employer.
HolPayTD	Employee > Employee Record > Employment > YTD Values > Other YTD > Other > Advanced Pay	The advanced pay for the employee for the full tax year to date.
NetPayTD	Employee > Employee Record > Employment > YTD Values > Other YTD > Other > Total Net Pay	The rounded net pay for the employee in the full tax year to date.
NICEarnsToET	Employee > Employee Record > Employment > YTD Values > NIC > Earnings LEL to ET	NI earnings for each employee between the LEL and ET in the full tax year to date.
NICEarnsToETAsEE	Employee > Employee Record > Employment > YTD Values > Director's NIC > Earnings As Employee > LEL to ET	NI earnings for each employee between the LEL and the ET in the period within the current tax year prior to being made a director.
NICEarnsToLEL	Employee > Employee Record > Employment > YTD Values > NIC > Earnings up to LEL	NI earnings for each employee up to the LEL in the full tax year to date.
NICEarnsToLELAsEE	Employee > Employee Record > Employment > YTD Values > NIC > Director's NIC > Earnings As Employee > Up to LEL	NI earnings for each employee up to the LEL in the period within the current tax year prior to being made a director.
NICEarnsToUAP	Employee > Employee Record > Employment > YTD Values > NIC > Earnings ET To UAP	NI earnings for each employee between the ET and the UAP in the full tax year to date.
NICEarnsToUAPAsEE	Employee > Employee Record > Employment > YTD Values > NIC > Director's NIC > Earnings As Employee > ET to UAP	NI earnings for each employee between the ET and the UAP in the period within the current tax year prior to being made a director.
NICEarnsToUEL	Employee > Employee Record > Employment > YTD Values > NIC > Earnings UAP To UEL	NI earnings for each employee between the UAP and UEL in the full tax year to date.
NICEarnsToUELAsEE	Employee > Employee Record > Employment > YTD Values > NIC > Director's NIC > UAP to UEL	NI earnings for each employee between the UAP and the UEL in the period within the current tax year prior to being made a director.
NICGrossTD	Employee > Employee Record > Employment > YTD Values > Tax > Current Employment > Gross Pay for NIC	The gross pay to be taken into account when calculating NI contributions for this employee in the current tax year to date.
P45Gross	Employee > Employee Record > Employment > YTD Values > Tax > PAYE > Previous (P45) Employment > Gross Pay For Tax	The value of any taxable gross pay from previous employment.
P45Tax	Employee > Employee Record > Employment > YTD Values > Tax > PAYE > Previous (P45) Employment > Tax Paid	The value of any tax paid in previous employment.
PensionableTD	Employee > Employee Record > Employment > YTD Values > Other YTD > Pension > Pensionable Gross	Pensionable earnings for the employee in the tax year to date.
PensnEmployeeTD	Employee > Employee Record > Employment > YTD Values > Other YTD > Pension > Pension (Main)	The employee's pension contributions in the full tax year to date, inclusive of AVCs. This value includes all pension schemes.
PensnEmployerTD	Employee > Employee Record > Employment > YTD Values > Other YTD > Pension > Employer's Pension	The employer's pension contributions for this employee in the full tax year to date. This value includes all pension schemes.
SalarySacrificeDeductionAmountTD	Awaiting information.	Awaiting information.
SalarySacrificeTD	Not shown in Sage 50 Payroll.	The total amount of salary sacrifice contributions in the full tax year to date.
SAPNICCompTD	Employee > Employee Record > Employment > YTD Values > Statutory Payments > NIC Compensation	The total value of NI compensation for SAP in the full tax year to date.
SAPPaidTD	Employee > Employee Record > Employment > YTD Values > Statutory Payments > Adoption Pay > Total Amount Paid	The SAP paid for each employee in the full tax year to date.
SAPRecovdTD	Employee > Employee Record > Employment > YTD Values > Statutory Payments >Adoption Pay > Amount Reclaimed	The SAP recovered for each employee in the full tax year to date.
SAPWks	Employee > Employee Record > Employment > YTD Values > Statutory Payments > Weeks SAP Paid	The total number of weeks SAP paid in the tax year to date for each employee.
ShPPNICCompTD	Employee > Employee Record > Employment > YTD Values > Statutory Payments > Paternity Pay/Paternity Pay (Adoption)	The total NI compensation applicable to ShPP in the full tax year to date.
ShPPaidTD	Employee > Employee Record > Employment > YTD Values > Statutory Payments > Paternity Pay/Paternity Pay (Adoption)	The ShPP paid for each employee in the full tax year to date
ShPPRecovdTD	Employee > Employee Record > Employment > YTD Values > Statutory Payments > Paternity Pay/Paternity Pay (Adoption)	The total ShPP recovered for each employee in the full tax year to date.
ShPPWks	Employee > Employee Record > Employment > YTD Values > Statutory Payments > Paternity Pay/Paternity Pay (Adoption) > Weeks ShPP Paid	The total number of weeks ShPP paid for each employee in the full tax year to date.
SLRPaidTD	Employee > Employee Record > Employment > YTD Values > Other YTD > Other > Student Loan	The student loan repayments for each employee in the full tax year to date.
SMPNICCompTD	Employee > Employee Record > Employment > YTD Values > Statutory Payments > Maternity Pay > Total Amount Paid	The total SMP recovered for each employee in the full tax year to date.
SMPPaidTD	Employee > Employee Record > Employment > YTD Values > Statutory Payments > Maternity Pay > Total Amount Paid	The SMP paid for each employee in the full tax year to date.
SMPRecovdTD	Employee > Employee Record > Employment > YTD Values > Statutory Payments > Maternity Pay > Amount Reclaimed	The total SMP recovered for each employee in the full tax year to date.
SMPWks	Employee > Employee Record > Employment > YTD Values > Statutory Payments > Maternity Pay > Weeks SMP Paid	The total weeks SMP paid for each employee in the full tax year to date.
SPPAWks	Employee > Employee Record > Employment > YTD Values > Statutory Payments > Paternity Pay/Paternity Pay (Adoption) > Weeks SPPA Paid	The total weeks SPPA paid for each employee in the full tax year to date.
SPPNICCompTD	Employee > Employee Record > Employment > YTD Values > Statutory Payments > Paternity Pay/Paternity Pay (Adoption)	The total NI compensation applicable to SPP in the full tax year to date.
SPPPaidTD	Employee > Employee Record > Employment > YTD Values > Statutory Payments > Paternity Pay/Paternity Pay (Adoption)	The SPP paid for each employee in the full tax year to date
SPPRecovdTD	Employee > Employee Record > Employment > YTD Values > Statutory Payments > Paternity Pay/Paternity Pay (Adoption)	The total SPP recovered for each employee in the full tax year to date.
SPPWks	Employee > Employee Record > Employment > YTD Values > Statutory Payments > Paternity Pay/Paternity Pay (Adoption) > Weeks SPP Paid	The total number of weeks SPP paid for each employee in the full tax year to date.
StdEarnsTD	Employee > Employee Record > Employment > YTD Values > NIC	The standard earnings for NI contributions for each employee in the full tax year to date.
TaxCreditsTD	Employee > Employee Record > Employment > YTD Values > Statutory Payments > Tax Credits > Total Paid	Tax credits for each employee in the full tax year to date.
TaxGrossTD	Employee > Employee Record > Employment > YTD Values > PAYE > Tax Year Values To Date > Gross Pay for Tax	Taxable gross income, inclusive of previous employment, for each employee in the full tax year to date.
TaxRefundsWithheldPrev	Employee > Employee Record > Employment > YTD Values > Tax > Tax Refunds Withheld > Previous Tax Year	Tax refunds withheld from the employee, carried over from the previous tax year.
TaxRefundsWithheldTD	Employee > Employee Record > Employment > YTD Values > Tax > Tax Refunds Withheld > Current Tax Year	Tax refunds withheld from the employee in the full current tax year.
TaxYearStart	Not shown in Sage 50 Payroll.	The year in which the current tax year began. For example, if the tax year is 2010/2011, this value is 2010.
TotalGrossTD	Employee > Employee Record > Employment > YTD Values > PAYE > Tax Year Values To Date > Total Gross Pay	Total gross pay, inclusive of previous employment, for each employee in the current tax year.
TotalTaxTD	Employee > Employee Record > Employment > YTD Values > Tax > PAYE > Tax Year Values To Date > Tax Paid	Income tax paid, inclusive of previous employment, for each employee in the full tax year to date.
TotLoans	Employee > Employee Record > Employment > YTD Values > Other YTD > Other > Loan Repayments	The loan repayments made for each employee in the full tax year to date.
WidowOrphans	Employee > Employee Record > Employment > YTD Values > Other YTD > Widows & Orphans Fund	The value paid to the Windows & Orphans Fund in the full tax year to date.

HolidaySchemes
Variable	Location	Details
AccrualMethod	Company > Holidays > Holiday Schemes > New/Edit > Entitlement Accrue > Accrue Holiday Basis	The method used to accrue holiday under this scheme, either daily or monthly.
AccrueMethod	Company > Holidays > Holiday Schemes > New / Edit > Payments > Accrual Details > Accrue Holiday Fund As	A coded variable showing the accrual method for the holiday. 0 - No accrual scheme 1 - Accrue as a percentage of the gross 2 - Accrue as a percentage of holidayable gross 3 - Accrue as a fixed amount
AccrueMethodText	Company > Holidays > Holiday Schemes > New / Edit > Payments > Accrual Details > Accrue Holiday Fund As	Text showing the accrual method for the holiday. This can be any of the following: None (no accrual scheme is used) A percentage of gross A percentage of holidayable gross An amount
AVCFlag	Company > Holidays > Holiday Schemes > New / Edit > Payments > Add Payments Before Calculating > Pension (AVC)	A flag to show whether payments to and from this holiday fund should be included when calculating CCAEOs. 0 - No 1 - Yes
AverageWeeks
CCAEOFlag	Company > Holidays > Holiday Schemes > New / Edit > Payments > Add Payments Before Calculating > Community Charge	A flag showing whether payments to and from this fund should be included when calculating CCAEOs. 0 - No 1 - Yes
CTAEOFlag	Company > Holidays > Holiday Schemes > New / Edit > Payments > Add Payments Before Calculating > Council Tax	A flag showing whether payments to and from this fund should be included when calculating CTAEOs. 0 - No 1 - Yes
DaysAdvFlag	Company > Holidays > Holiday Schemes > New / Edit > Entitlement Settings > Allow Entitlement B/F From Previous Year	A flag showing whether holiday can be brought forward from the previous year. 0 - No 1 - Yes
DaysCFFlag	Company > Holidays > Holiday Schemes > New / Edit > Entitlement Settings > Allow Entitlement Advanced From Next Year	A flag showing whether holiday can be carried forward to the next year. 0 - No 1 - Yes
DeductFromGross	Company > Holidays > Holiday Schemes > New / Edit > Payments > Accrual Details	A flag showing whether the employee's contribution to the scheme should be deducted from the employee's gross or net pay. 0 - Deducted from net pay 1 - Deducted from gross pay
DefaultValue	Company > Holidays > Holiday Schemes > New / Edit > Payments > Accrual Details > Value	The amount or percentage to accrue for the holiday scheme.
EntitlementPeriod		The holiday entitlement period.
HolDescription	Company > Holidays > Holiday Schemes > New / Edit > Scheme Name	The holiday scheme name.
HolReference	Company > Holidays > Holiday Schemes > New / Edit > Scheme Number	The holiday scheme reference number.
IncludeCurrentPrdFlag	Company > Holidays > Holiday Schemes > New / Edit > Entitlement Settings > Include Current Pay Month	A flag showing whether the month of the process date should be included when calculating the holiday accrual. 0 - No 1 - Yes
IncludeHolidayPay	Company > Holidays > Holiday Schemes > New / Edit > Payments > Accrual Details > Include Holiday Pay in Gross for Actual	A flag showing whether the holiday pay should be included in the gross amount when working out the accrual. 0 - No 1 - Yes
IncludeNatHols	Company > Holidays > Holiday Schemes > New / Edit > Entitlement Settings > Include National Holidays in Entitlement	A flag showing whether national holidays are included in the holiday entitlement. 0 - National holidays are in addition to the maximum entitlement 1 - National holidays are included in the maximum entitlement
IncludeStartPrdFlag	Company > Holidays > Holiday Schemes > New / Edit > Entitlement Settings > Include Starting Pay Month	A flag showing whether the calendar month in which the employment starts is counted as the first full period for holiday accrual. 0 - No 1 - Yes
MaxDays	Company > Holidays > Holiday Schemes > New / Edit > Entitlement Basis > Entitlement of	The maximum number of days holiday entitlement under the scheme.
MinMths	Company > Holidays > Holiday Schemes > New / Edit > Entitlement Settings > Minimum Employment (Months)	The minimum number of months that the employee must have been employed before they begin accruing holiday under the scheme.
OtherAttachFlag	Company > Holidays > Holiday Schemes > New / Edit > Payments > Add Payments Before Calculating > Other Attachments	A flag showing whether payments to and from this fund should be included when calculating other AEOs. 0 - No 1 - Yes
PatternStartDate	Company > Holidays > Holiday Schemes > New / Edit > Settings > Working Day Pattern (Sun - Sat) > Pattern Start Date	The date on which the first holiday pattern starts. This date must be on a Sunday.
PensnFlag	Company > Holidays > Holiday Schemes > New / Edit > Payments > Add Payments Before Calculating > Pension (Main)	A flag showing whether payments to and from this fund should be included when calculating pension contributions. 0 - No 1 - Yes
PriorToType
SchemeFundedByEE	Company > Holidays > Holiday Schemes > New / Edit > Payments > Accrual Details > Scheme Funded By	A flag showing whether the scheme is funded by the employee or the employer. 0 - Funded by the employer 1 - Funded by the employee
SchemeStartDateType	Company > Holidays > Settings > Scheme Start Date	Indicates the date on which the holiday year starts. This can start with the company holiday year or with the employee's start date.
SchemeType	Company > Holidays > Entitlement > Entitlement Basis > Scheme Type	The type of holiday scheme. This can be either of the following: Specified Entitlement Calculated Entitlement
ShowWarningFlag	Company > Holidays > Holiday Schemes > New / Edit > Entitlement Accrue > Display Excess Entitlement Warning	A flag showing whether a warning should appear when an employee exceeds their holiday entitlement. 0 - No 1 - Yes

NOTE: This table is currently not available in the Historical Data or post-update reports areas. For further information please refer to article .

LoanAnalysis
Variable	Location	Details
Desc1-10	Company > Custom Reports > New / Edit > Loans > Loan Type	The description of the loan type.
NumItems	Not shown in Sage 50 Payroll.	The number of active pay elements set up in the employee record.
Reference	Employee > Employee Record > Personal > Reference	The employee reference number.
Total1-10	Payroll > Enter Payments > Loans > Repayment Made	The amount repaid for the loan type in the current period.

LoanHistory
Variable	Location	Details
AmtPaidCur	Not shown in Sage 50 Payroll.	The amount repaid for each loan type in each updated period.
AmtPaidHol	Not shown in Sage 50 Payroll.	The amount repaid for each loan type in each updated advanced period.
BalanceBF	Not shown in Sage 50 Payroll.	The amount of outstanding loan brought forward for each loan type into each updated period.
BalanceCF	Not shown in Sage 50 Payroll.	The amount of outstanding loan carried forward for each loan type for each employee into the next updated period.
HistoryRef	Not shown in Sage 50 Payroll.	A three part reference made up of the employee's reference number, the first date of the updated pay period and the last date of the updated pay period. For example, if employee 12 is updated for the week ending 28th August 2012, the reference is 000012/22082012/28082012.
Instance	Not shown in Sage 50 Payroll.	An internal identifier for the loan for each employee. This increases by one for each loan the employee has, and resets for the next employee.
LoanDescription	Not shown in Sage 50 Payroll.	The description of the updated loan.
LoanReference	Not shown in Sage 50 Payroll.	The reference number for the loan. This is set at a company level.
Status	Not shown in Sage 50 Payroll.	The status of the loan at each updated payment period. This can be any of the following: 0 - Active 1- Written Off 2 - Paid

LoanTypes
Variable	Location	Details
Amount	Company > Pay Elements > Loans > Loan Amount	The total amount of the loan to be repaid.
CustomReportOrder	Company > Custom Reports > New / Edit > Loans > Index	The index number for this loan within custom reports.
Description	Company > Pay Elements > Loans > Description	The description of the loan.
NDR	Company > Pay Elements > Loans > Normal Deduction Rate	The normal deduction rate at which the employee pays back the loan.
Reference	Company > Pay Elements > Loans > Ref	The reference number for the loan. This is set at a company level.
TransferP11D	Company > Pay Elements > Loans > New / Edit > P11D > Transfer to Sage P11D	A flag showing whether the loan details can be transferred to Sage P11D. 0 - No 1 - Yes

NLinkSettings
Variable	Location	Details
bBalanceSheet	Company > Nominal Settings > BS Analysis	A flag showing whether this category is a balance sheet posting. 0 - No 1 - Yes
bCostCentre	Company > Nominal Settings > P&L Analysis / BS Analysis > Cost Centre Override?	A flag showing whether this category has a cost centre. 0 - No 1 - Yes
bDeduction	Company > Nominal Settings > P&L Analysis > Deductions Override	A flag showing whether this category has a deductions override. 0 - No 1 - Yes
bDepartmental	Company > Nominal Settings > P&L Analysis / BS Analysis > Departmental Override?	A flag showing whether this category has a departmental override. 0 - No 1 - No
bErsNI	Company > Nominal Settings > P&L Analysis > Employer's NI Override	A flag showing whether this category has an employer's NI override. 0 - No 1 - Yes
bGlobal	Company > Nominal Settings > P&L Analysis / BS Analysis	A flag showing whether this record is a non-override setting. 0 - No 1 - Yes
bLoan
bPayment	Company > Nominal Settings > P&L Analysis > Payments Override	A flag showing whether this category has a payments override. 0 - No 1 - Yes
bPension	Company > Nominal Settings > P&L Analysis / BS Analysis > Pensions Override?	A flag showing whether this category has a pensions override. 0 - No 1 - Yes
bProfitLoss	Company > Nominal Settings > P&L Analysis	A flag showing whether this category is a profit and loss posting. 0 - No 1 - Yes
Category	Company > Nominal Settings > P&L Analysis / BS Analysis > Category	The category name.
CategoryIndex	Not shown in Sage 50 Payroll.	This variable isn't in use.
CostCentre	Company > Nominal Settings > P&L Analysis / BS Analysis > Override > C/C	The destination cost centre.
CostCentreReference	Company > Nominal Settings > P&L Analysis / BS Analysis > Cost Centre Override > Ref	A reference to the cost centre record within Sage 50 Payroll, if this category has a cost centre.
Department	Company > Nominal Settings > P&L Analysis / BS Analysis > Override > Dept	The destination department.
DepartmentRef	Company > Nominal Settings > P&L Analysis / BS Analysis > Departmental Override > Ref	A reference to the department record within Sage 50 Payroll, if this category has a department.
NominalCode	Company > Nominal Settings > P&L Analysis / BS Analysis > Override > N/C	The destination nominal code.

NominalLink
Variable	Location	Details
Amount	Not shown in Sage 50 Payroll.	The value to be posted.
CostCentre	Not shown in Sage 50 Payroll.	The cost centre to which the transaction is posted.
Dept	Not shown in Sage 50 Payroll.	The department to which the transaction is posted.
EeRef	Payroll > Nominal Link > Next > Next > Ref	A unique payroll identifier of the employee. This applies when posting the values ungrouped as single employee values.
Narrative	Not shown in Sage 50 Payroll.	The category description for the transaction that has been posted.
NominalCode	Not shown in Sage 50 Payroll.	The nominal code to which the transaction is posted.
PosterAccessLevel	Tasks > Security > Access Rights > Access Record Level	The access level of the user posting the nominal link.
ReferenceNo	Payroll > Nominal Link > Next > Next > Next > Transaction Reference	The transaction reference entered when posting the nominal link.
Source	Company > Nominal Settings > Defaults > Destination	A code representing the software or file to which the nominal link is posted. 0 - Instant Accounts / Sage 50 Accounts data, TAS Accounts data or Export to file 1 - Sage 200 Accounts data
TranDate	Payroll > Nominal Link > Next > Next > Next > Transaction Date	The process date on which the transactions were posted using nominal link.
TranType	Not shown in Sage 50 Payroll.	This variable isn't in use.
VatMonth	Not shown in Sage 50 Payroll.	This variable isn't in use.

NOTE: This table is currently not available in the Historical Data or post-update reports areas. For further information please refer to article .

PaymentAnalysis
Variable	Location	Details
Desc1-30	Company > Custom Reports > New / Edit > Payments > Payment Type	The description of the payment pay element.
Holiday1-30	Payroll > Enter Payments > Advance Pay > Payments > Amount	The amount paid for the pay element for the advanced period. NOTE: This variable currently doesn't work and always produces a zero value.
Hours1-30	Payroll > Enter Payments > Payments > Hours/No	The hours or number for the pay element in the current period.
NumItems	Not shown in Sage 50 Payroll.	The number of active payment pay elements set up in the employee record.
Rate1-30	Payroll > Enter Payments > Payments > Rate	The rate for the pay element for the current period.
Reference	Employee > Employee Record > Personal > Reference	The employee reference number.
Total1-30	Payroll > Enter Payments > Payments > Amount	The amount paid for the pay element in the current period.
TotalTD1-30	Employee > Employee Record > Employment > Payments & Deductions > Amount	The total year to date amount for the pay element for this employee.

PaymentHistory
Variable	Location	Details
HistoryRef	Not shown in Sage 50 Payroll.	A three part reference made up of the employee's reference number, the first date of the updated pay period and the last date of the updated pay period. For example, if an employee with a reference of 12 is updated on the 28th August 2012, the reference is 000012/22082012/28082012.
PaymentAmtCur	Not shown in Sage 50 Payroll.	The amount paid in the updated period for each payment type.
PaymentAmtHol	Not shown in Sage 50 Payroll.	The amount paid in the updated period for advance pay for each payment type.
PaymentAmtTotal	Not shown in Sage 50 Payroll.	The total amount paid in the updated period for each payment type.
PaymentCCAEOFlag	Not shown in Sage 50 Payroll.	A flag showing whether the payment type was added before calculating Community Charge Attachment Of Earnings Orders for each updated period. 0 - No 1 - Yes
PaymentCTAEOFlag	Not shown in Sage 50 Payroll.	A flag showing whether the payment type was added before calculating Council Tax Attachment Of Earnings Orders for each updated period. 0 - No 1 - Yes
PaymentDescription	Not shown in Sage 50 Payroll.	The description of the payment type.
PaymentHrsNoCur	Not shown in Sage 50 Payroll.	The hours or number for each updated current period for each payment type.
PaymentHrsNoHol	Not shown in Sage 50 Payroll.	The hours or number for each updated holiday period for each payment type.
PaymentInstance	Not shown in Sage 50 Payroll.	A reference number for the payment type. This is taken from the order that the payment types are set up in the employee record.
PaymentNICFlag	Not shown in Sage 50 Payroll.	A flag showing whether each payment type was added before calculating NI contributions for each updated period. 0 - No 1 - Yes
PaymentOtherAttachFlag	Not shown in Sage 50 Payroll.	A flag showing whether each payment type was added before calculating other Attachment Of Earnings Orders for each updated period. 0 - No 1 - Yes
PaymentPensnFlag	Not shown in Sage 50 Payroll.	A flag showing whether each payment type was added before calculating pension contributions for each updated period. 0 - No 1 - Yes
PaymentRateAmtCur	Not shown in Sage 50 Payroll.	The rate or amount for the payment type in each updated period.
PaymentRateAmtHol	Not shown in Sage 50 Payroll.	The rate or amount for the payment type in each updated holiday period.
PaymentReference	Company > Pay Elements > Payments > Ref	The pay element reference number.
PaymentStatus	Not shown in Sage 50 Payroll.	The status of the payment. This can be any of the following: Variable Global Fixed
PaymentTaxFlag	Not shown in Sage 50 Payroll.	A flag showing whether each payment type was added before calculating income tax for each updated period. 0 - No 1 - Yes
PaymentValueTD	Not shown in Sage 50 Payroll.	The year to date value for each payment type as of the process date for the updated period.

PaymentTypes
Variable	Location	Details
AutoAdv	Company > Pay Elements > Net Payments / Payments > New / Edit > Holiday > Auto Advance	A flag showing whether the last updated payment values are automatically used in the holiday period when the holiday pay is advanced. 0 - No 1 - Yes
AVCFlag	Company > Pay Elements > Net Payments / Payments > New / Edit > Holiday > Auto Advance	A flag showing whether this payment type should be added before calculating AVCs. 0 - No 1 - Yes
BasePaymentRef	Not shown in Sage 50 Payroll.	The reference of the pay element used as the base of a factor.
BatchOrderFourWeekly	Payroll > TimeSheet Entry	The order in which the payment types appear in TimeSheet Entry for four weekly paid employees.
BatchOrderMonthly	Payroll > TimeSheet Entry	The order in which the payment types appear in TimeSheet Entry for monthly paid employees.
BatchOrderTwoWeekly	Payroll > TimeSheet Entry	The order in which the payment types appear in TimeSheet Entry for two weekly paid employees.
BatchOrderWeekly	Payroll > TimeSheet Entry	The order in which the payment types appear in TimeSheet Entry for weekly paid employees.
CCAEOFlag	Company > Pay Elements > Net Payments / Payments > New / Edit > Add this value before calculating > CCAEO	A flag showing whether this payment type should be added before calculating Community Charge Attachment OF Earnings Orders. 0 - No 1 - No
ClearYE	This variable isn't in use.	This variable isn't in use.
CTAEOFlag	Company > Pay Elements > Net Payments / Payments > New / Edit > Add this value before calculating > CTAEO	A flag showing whether this payment type should be added before calculating Council Tax Attachment of Earnings Orders. 0 - No 1 - Yes
CustomReportOrder	Company > Custom Reports > New / Edit > Payments > Index	The index number used for this payment type in the default custom report setting.
Description	Company > Pay Elements > Net Payments / Payments > Description	The description of the payment type.
ERPays	Company > Pay Elements > Net Payments > New / Edit > Payment Adjusted For Employee's Tax / Employee's Tax and NI	A flag showing whether this payment type is to be grossed up. 0 - Not grossed up - the values are taken from the Payments tab 1 - Grossed up for PAYE only - the value is taken from the Net Payments tab 2 - Grossed up for both PAYE and NI - the value is also from the Net Payments tab
HolidayAccrual	Company > Pay Elements > Net Payments / Payments > New / Edit > Holiday > Include for Holiday Accrual	A flag showing whether this payment type is to be included when calculating the holiday fund accrual. 0 - No 1 - Yes
HrsNo	Company > Pay Elements > Net Payments / Payments > New / Edit > Default Hours / No	The default hours or number set for the payment type at a company level.
Inc12Week	Company > Pay Elements > Net Payments / Payments > New / Edit > Holiday > Include for Weekly Average	A flag showing whether this payment type is to be included when calculating the weekly average gross pay. 0 - No 1 - Yes
IncForTimeSheets	Company > Pay Elements > New / Edit > Include in TimeSheet Entry	Indicates if this pay element is to be shown on the TimeSheet Entry window.
IncForVariance	Company > Variance Settings > Payments > Variance > Include	A flag showing whether the payment type is included in the variance analysis. 0 - No 1 - Yes
InclHoursMinWage	Company > Pay Elements > Net Payments / Payments > New / Edit > Include Hours/No in Minimum Wage calculation	Shows whether the hours are to be included in the minimum wage calculation.
InclRateMinWage	Company > Pay Elements > Net Payments / Payments > New / Edit > Include Rate in Minimum Wage calculation	Shows whether the rate is to be added to the minimum wage calculation.
IncludeInSalarySacrifice	Company > Pay Elements > Payments > New/Edit > Salary Sacrifice	Shows whether the payment is to be included when calculating salary sacrifice pension contributions.
MinWagePremium	Company > Pay Elements > Net Payments / Payments > New / Edit > This payment includes a premium element.	Shows if the rate contains a premium element.
MultiplierDesc	Company > Pay Elements > Net Payments / Payments > New / Edit	Shows whether the factor is a percentage of the payment or a multiplier.
NICFlag	Company > Pay Elements > Net Payments / Payments > New / Edit > Add this value before calculating > National Insurance	A flag showing whether this payment type should be added before calculating NI contributions. 0 - No 1 - Yes
OtherAttachFlag	Company > Pay Elements > Net Payments / Payments > New / Edit > Add this value before calculating > Other AEOs	A flag showing whether this payment type should be added before calculating other AEOs. 0 - No 1 - Yes
PaymentReference	Company > Pay Elements > Net Payments / Payments > Ref	The reference number for the payment type. This is set at a company level.
PensnFlag	Company > Pay Elements > Net Payments / Payments > New / Edit > Add this value before calculating > Pension (Main)	A flag showing whether this payment type should be added before calculating pension contributions. 0 - No 1 - Yes
RateAmt	Company > Pay Elements > Net Payments / Payments > Rate	The default rate set for the payment type at a company level.
Status	Company > Pay Elements > Net Payments / Payments > Status	The status of the payment type. This can be any of the following: Variable Global Fixed
TaxFlag	Company > Pay Elements > Net Payments > Payments > New / Edit > Add this value before calculating > PAYE	A flag showing whether this payment type should be added before calculating income tax. 0 - No 1 - Yes
VarianceAmount	Company > Variance Settings > Payments > Variance > Variance	The amount of the variance.
VarianceType	Company > Variance Settings > Payments > Variance > Variance Type	The type of variance. 0 - Fixed Amount 1 - Percentage
VarianceTypeText	Company > Variance Settings > Payments >Variance > Variance Type	The description of the type of variance. This can be any of the following: N/A Fixed Amount Percentage

PayslipAttachments
Variable	Location	Details
Desc1-12	Enter Payments > Attachments > Name	Description of the attachment type. This displays the Replacement Description, or if there is none, the Standard Description as derived from Pay Elements > Attachments. When the Payment Sort criteria is set to Custom and the employee has more than one attachment of the same type, the variable will inaccurately only pick up one of the numeric instances of the attachment type.
HistoryRef	None.	Not applicable to Pre-update reports.
NumItems	None.	The number of active payment elements in the Employee Record > Employment> Pay Elements > Attachments.
Reference	Employee Record > Personal > Reference	Employee reference number.
Total1-12	Enter Payments > Attachments > Amount Deducted	Amount deducted in the current period for the attachment type.
TotalTD1-12	Enter Payments > Attachments > Amount Deducted	Total to date value for the attachment

PayslipDeductions
Variable	Location	Details
Desc1-30	Payroll > Enter Payments > Deductions > Deduction Name Company > Custom Reports > New / Edit > Deductions > Deduction Type Payroll > Enter Payments > Advance Pay > Deductions > Deductions Name	The description of the deduction pay element.
HistoryRef	Not shown in Sage 50 Payroll.	This variable is only in use for historical data reports.
Holiday1-30	Payroll > Enter Payments > Advance Pay > Deductions > Amount	The amount paid for the pay element for any advanced period.
Hours1-30	Payroll > Enter Payments > Deductions > Hours/No	The hours or number for the deduction pay element in the current period.
NumItems	Not shown in Sage 50 Payroll.	The number of active deduction pay elements set up in Employee > Employee Record > Employment > Pay Elements > Deductions.
Rate1-30	Payroll > Enter Payments > Deductions > Rate	The rate for the pay element.
Reference	Employee > Employee Record > Personal > Reference	The employee reference number.
Total1-30	Payroll > Enter Payments > Deductions > Amount	The amount paid for the deduction pay element.

PayslipLoans
Variable	Location	Details
Desc1-10	Payroll > Enter Payments Loans > Description	The description of the loan type.
HistoryRef	Not shown in Sage 50 Payroll.	Not used in pre-update reports. In historical reports, this is a three part reference made up of the employee's reference number, the first date of the updated pay period and the last date of the updated pay period. For example, if employee 12 is updated for the week ending 28th August 2012, the reference is 000012/22082012/28082012.
NumItems	Not shown in Sage 50 Payroll.	The number of active pay elements set up in the employee record.
Reference	Employee > Employee Record > Personal > Reference	The employee reference number.
Total1-10	Payroll > Enter Payments > Loans > Repayment Made	The amount repaid for the loan type in the current period.

PayslipPayments
Variable	Location	Details
Department	Employee > Employee Record > Analysis > Company Analysis > Department	The name of the department to which the employee has been assigned.
Desc1-30	Payroll > Enter Payments > Payments > Payment Name	The description of the payment pay element.
Holiday1-30	Payroll > Enter Payments > Advance Pay > Payments > Amount	The amount paid for the pay element for the advanced period. NOTE: This variable currently doesn't work and always produces a zero value.
Hours1-30	Payroll > Enter Payments > Payments > Hours/No	The hours or number for the pay element in the current period.
NumItems	Not shown in Sage 50 Payroll.	The number of active payment pay elements set up in the employee record.
Rate1-30	Payroll > Enter Payments > Payments > Rate	The rate for the pay element for the current period.
Reference	Employee > Employee Record > Personal > Reference	The employee reference number.
TaxCode	Employee > Employee Record > Employment > Tax Code	The employee's current tax code.
Total1-30	Payroll > Enter Payments > Payments > Amount	The amount paid for the pay element in the current period.

PensionHistory
Variable	Location	Details
AVCAmount	Not shown in Sage 50 Payroll.	The employee's advanced voluntary contributions for each pension scheme in each updated pay period.
AVCAmountAdvanced	Not shown in Sage 50 Payroll.	The employee's advanced voluntary contributions for each pension scheme in each updated advanced pay period.
EmployeeAmount	Not shown in Sage 50 Payroll.	The employee's pension contributions, including AVCs, for each pension scheme in each updated pay period.
EmployeeAmountAdvanced	Not shown in Sage 50 Payroll.	The employee's pension contributions, including AVCs, for each pension scheme in each updated advanced pay period.
EmployerAmount	Not shown in Sage 50 Payroll.	The employer's pension contributions for each pension scheme in each updated pay period.
EmployerAmountAdvanced	Not shown in Sage 50 Payroll.	The employer's pension contributions for each pension scheme in each updated advanced pay period.
HistoryRef	Not shown in Sage 50 Payroll.	A three part reference made up of the employee's reference number, the first date of the updated pay period and the last date of the updated pay period. For example, if employee 12 is updated for the week ending 28th August 2012, the reference is 000012/22082012/28082012.
JoinedScheme	Not shown in Sage 50 Payroll.	The date that the employee joined the pension scheme.
PensionDescription	Not shown in Sage 50 Payroll.	The description of each pension scheme used in each updated pay period.
SalarySacrificeAmount	Not shown in Sage 50 Payroll.	The salary sacrifice amount for each pension scheme in each updated pay period.
SalarySacrificeAmountAdvanced	Not shown in Sage 50 Payroll.	The salary sacrifice amount for each pension scheme in each updated advanced pay period.
SchemeRef	Not shown in Sage 50 Payroll.	A unique numeric identifier for each updated pension scheme.
SCONRef	Not shown in Sage 50 Payroll.	The scheme contracted out number for each pension scheme for each updated period.

PensionSchemes
Variable	Location	Details
AdministratorEMail	Company > Pension Schemes > New / Edit > Details > Administrator Details > E-Mail	The email address of the pension administrator.
AdministratorName	Company > Pension Schemes > New / Edit > Details > Administrator Details > Name	The name of the pension administrator.
AdministratorTelephone	Company > Pension Schemes > New / Edit > Details > Administrator Details > Telephone	The telephone number of the pension administrator.
EmployeeBandOption	Company > Pension Schemes > New / Edit > Employee > Contribution Details > Band Options	A code for the application to pensionable earnings for the employee. 0 - Apply to all pensionable earnings 1 - Restrict to statutory NI upper / lower bands 2 - Restrict to specific upper / lower bands
EmployeeLimitFlag	This variable isn't in use.	This variable isn't in use.
EmployeeLowerEarnings	Company > Pension Schemes > New / Edit > Employee > Contribution Details > Lower	The lower value for employer's pensionable pay, if the pensionable earnings on which the employee's pension contribution is based is restricted to user defined parameters.
EmployeeMaximum	Company > Pension Schemes > New / Edit > Employee > Contribution Details > Maximum Contribution (period)	The maximum employee contribution in the pay period if set within the pension scheme. This option only applies if the type of contribution is set to percentage.
EmployeeMinimum	Company > Pension Schemes > New / Edit > Employee > Contribution Details > Minimum Contribution (period)	The minimum employee contribution in the pay period if set within the pension scheme. This option only applies if the type of contribution is set to percentage.
EmployeePercFix	Company > Pension Schemes > New / Edit > Employee > Contribution Details > Amount	The default amount or percentage used for the employee pension contribution.
EmployeePercFixFlag	Company > Pension Schemes > New / Edit > Employee > Contribution Details > Percentage or Fixed Amount	This option shows whether the employee contribution is a percentage or fixed amount.
EmployeeRebateFlag	Company > Pension Schemes > New / Edit > Employee > Settings > Calculate Minimum Rebate	A flag showing whether the NI contracted out rebate for employees, or the minimum contribution to a contracted out pension scheme, is calculated. 0 - Not calculated 1 - Calculated
EmployeeReliefFlag	Company > Pension Schemes > New / Edit > Employee > Settings > Deduct Before Tax	A flag showing whether the employee's pension contribution is deducted before or after tax is calculated. 0 - Deducted after tax 1 - Deducted before tax
EmployeeSAPFlag	Company > Pension Schemes > New / Edit > Employee > Settings > Include SAP Payments	A flag showing whether SAP is included when calculating the amount of pay to use when calculating the employee's pension contribution. 0 - No 1 - Yes
EmployeeSMPFlag	Company > Pension Schemes > New / Edit > Employee > Settings > Include SMP Payments	A flag showing whether SMP is included when calculating the amount of pay to use when calculating the employee's pension contribution. 0 - No 1 - Yes
EmployeeSPPFlag	Company > Pension Schemes > New / Edit > Employee > Settings > Include SPP Payments	A flag showing whether SPP is included when calculating the amount of pay to use when calculating the employee's pension contribution. 0 - No 1 - Yes
EmployeeSSPFlag	Company > Pension Schemes > New / Edit > Employee > Settings > Include SSP Payments	A flag showing whether SSP is included when calculating the amount of pay to use when calculating the employee's pension contribution. 0 - No 1 - Yes
EmployeeTotalFlag	Company > Pension Schemes > New / Edit > Employee > Settings > Include Rebate and Amount	A flag showing whether the minimum rebate value is added to the employee's pension contribution. 0 - Uses the value or the contribution or the rebate, whichever is higher. 1 - Uses the total of the contribution and the rebate
EmployeeUpperEarnings	Company > Pension Schemes > New / Edit > Employee > Contribution Details > Upper	The upper value for the employer's pensionable pay, if the earnings on which the employee's pension contribution is based are restricted to use defined parameters.
EmployerBandOption	Company > Pension Schemes > New / Edit > Employer > Contribution Details > Band Options	A code showing the application to pensionable earnings for the employer. 0 - Apply to all pensionable earnings 1 - Restrict to statutory NI upper / lower bands 2 - Restrict to specific upper / lower bands
EmployerLimitFlag	This variable isn't in use.	This variable isn't in use.
EmployerLowerEarnings	Company > Pension Schemes > New / Edit > Employer > Contribution Details > Lower	The lower value for the employer's pensionable pay, if the earnings on which the employee's pension contribution is based are restricted to use defined parameters.
EmployerMaximum	Company > Pension Schemes > New / Edit > Employer > Contribution Details > Maximum Contribution (period)	The maximum employer contribution in the pay period if the pension scheme includes a maximum contribution per pay period. This only applies if the type of contribution is set to percentage.
EmployerMinimum	Company > Pension Schemes > New / Edit > Employer > Contribution Details > Minimum Contribution (period)	The minimum employer contribution in the pay period if the pension scheme includes a minimum contribution per pay period. This only applies if the type of contribution is set to percentage.
EmployerPercFix	Company > Pension Schemes > New / Edit > Employer > Contribution Details > Amount	The default amount or percentage used for the employer pension contribution.
EmployerPercFixFlag	Company > Pension Schemes > New / Edit > Employer > Contribution Details > Percentage or Fixed Amount	The type of employer pension contribution, either Percentage or Fixed Amount.
EmployerRebateFlag	Company > Pension Schemes > New / Edit > Employer > Settings > Calculate Minimum Rebate	A flag showing whether the NI contracted out rebate for employers is calculated. 0 - Not calculated 1 - Calculated
EmployerReliefFlag	This variable isn't in use.	This variable isn't in use.
EmployerSAPFlag	Company > Pension Schemes > New / Edit > Employer > Settings > Include SAP Payments	A flag showing whether SAP is included when calculating the amount of pay to use when calculating the employer's pension contribution. 0 - No 1 - Yes
EmployerSMPFlag	Company > Pension Schemes > New / Edit > Employer > Settings > Include SMP Payments	A flag showing whether SMP is included when calculating the amount of pay to use when calculating the employer's pension contribution. 0 - No 1 - Yes
EmployerSPPFlag	Company > Pension Schemes > New / Edit > Employer > Settings > Include SPP Payments	A flag showing whether SPP is included when calculating the amount of pay to use when calculating the employer's pension contribution. 0 - No 1 - Yes
EmployerSSPFlag	Company > Pension Schemes > New / Edit > Employer > Settings > Include SSP Payments	A flag showing whether SSP is included when calculating the amount of pay to use when calculating the employer's pension contribution. 0 - No 1 - Yes
EmployerTotalFlag	Company > Pension Schemes > New / Edit > Employer > Settings > Include Rebate and Amount	A flag showing whether the minimum rebate value is added to the employer's pension contribution. 0 - Uses the value or the contribution or the rebate, whichever is higher. 1 - Uses the total of the contribution and the rebate
EmployerUpperEarnings	Company > Pension Schemes > New / Edit > Employer > Contribution Details > Upper	The upper value for the employer's pensionable pay, if the earnings on which the employer's pension contribution is based are restricted to user defined parameters.
EnrolmentReviewDate
IsSalarySacrifice
MinEmploymentPeriod	Company > Pension Schemes > New / Edit > Details > Pension Details > Minimum Employment Period (Months)	The minimum number of months an employee needs to work before they are eligible for the pension scheme.
PaymentMethod	Company > Pension Schemes > New / Edit > Provider > Provider Payment Details > Payment Method	The method by which the provider is paid. Cheque Direct Credit Direct Debit Telegraphic Transfer
PensionDescription	Company > Pension Schemes > New / Edit > Details > Pension Details > Description	The description of the pension scheme.
PensionReference	Company > Pension Schemes > New / Edit > Details > Pension Details > Reference	A unique internal numeric identifier for each pension scheme.
PensionType	Company > Pension Schemes > New / Edit > Details > Pension Details > Type	The type of the pension scheme. 0 - Other 1 - COMP 2 - COSR 3 - CISR 4 - COMB 5 - GPP 6 - PPP 7 - Stakeholder
ProviderAccNumber	Company > Pension Schemes > New / Edit > Provider > Provider Payment Details > A/C No	The pension provider's bank account number.
ProviderAccType	Company > Pension Schemes > New / Edit > Provider > Provider Payment Details > Bank A/C Type	The pension provider's bank account type. This can be either Bank Account or Building Society Account.
ProviderAddress1-5	Company > Pension Schemes > New / Edit > Provider > Provider Details > Address	The pension provider's address.
ProviderContact	Company > Pension Schemes > New / Edit > Provider > Provider details > Contact	The pension provider's contact name.
ProviderEmail	Company > Pension Schemes > New / Edit > Provider > Provider Details > E-Mail	The pension provider's email address.
ProviderFax	Company > Pension Schemes > New / Edit > Provider > Provider Details > Facsimile	The pension provider's fax number.
ProviderName	Company > Pension Schemes > New / Edit > Provider > Provider Details > Name	The name of the pension provider.
ProviderPostCode	Company > Pension Schemes > New / Edit > Provider > Provider Details > Post Code	The pension provider's post code.
ProviderRollNumber	Company > Pension Schemes > New / Edit > Provider > Provider Payment Details > B/Soc Roll No	The pension providers building society roll number.
ProviderSortCode	Company > Pension Schemes > New / Edit > Provider > Provider Payment Details > Sort Code	The pension provider's bank sort code.
ProvidersRef	Company > Pension Schemes > New / Edit > Provider > Provider Details > Providers Ref	The company reference for the pension provider.
ProviderTelephone	Company > Pension Schemes > New / Edit > Provider > Provider Details > Telephone	The pension provider's telephone number.
QualifyingScheme
SchemeRef	Company > Pension Schemes > New / Edit > Provider > Provider Details > Scheme Ref	The scheme number of the pension provider.
SCONRef	Company > Pension Schemes > New / Edit > Details > Scheme Details > SCON	The scheme contracted out number, if you run a contracted out occupational pension scheme.

PersonalCars
Variable	Location	Details
Colour	Employee > Employee Record > Personal Cars > Colour	The colour of the personal car.
Instance	Not shown in Sage 50 Payroll.	A unique reference for the car within the employee record. This increases by one for each personal car record and resets for each employee.
Make	Employee > Employee Record > Personal Cars > Make	The make of the personal car.
Model	Employee > Employee Record > Personal Cars > Model	The model of the personal car.
Reference	Employee > Employee Record > Reference	The employee reference number.
Registration	Employee > Employee Record > Personal Cars > Registration	The registration number of the personal car.

QDPatterns
QDayReference	This variable isn't in use.	This variable isn't in use.
SunToSatPattern	Employee > Employee Record > Absence > SSP > Qualifying Days > SSP Qualifying Day Pattern (Sun - Sat) > Qualifying Day Pattern	The weekly qualifying day pattern for SSP. N - Non-qualifying day Q - Qualifying day

QDPatterns

Variable

Location

Details

QDayReference

This variable isn't in use.

SunToSatPattern

Employee > Employee Record > Absence > SSP > Qualifying Days > SSP Qualifying Day Pattern (Sun - Sat) > Qualifying Day Pattern

The weekly qualifying day pattern for SSP.

N - Non-qualifying day
Q - Qualifying day

StatutoryPayments
Variable	Location	Details
ASPPDeclarationFlag	Awaiting information.	Awaiting information.
ASPPEndedWorkDate	Awaiting information.	Awaiting information.
ASPPKITDays	Awaiting information.	Awaiting information.
ASPPKITDaysThisPeriod	Awaiting information.	Awaiting information.
ASPPPartnerDeclarationFlag	Awaiting information.	Awaiting information.
ASPPReturnedWorkDate	Awaiting information.	Awaiting information.
ASPPStandardPayWeeks	Awaiting information.	Awaiting information.
ASPPStandardPayWeeksPrvYr	Awaiting information.	Awaiting information.
ASPPStartedByDeathFlag	Awaiting information.	Awaiting information.
ASPPTotalCompensation	Awaiting information.	Awaiting information.
ASPPTotalCompensationTD	Awaiting information.	Awaiting information.
ASPPTotalPaidTD	Awaiting information.	Awaiting information.
ASPPTotalRecoveredTD	Awaiting information.	Awaiting information.
ASPPTotalToPay	Awaiting information.	Awaiting information.
ASPPTotalToRecover	Awaiting information.	Awaiting information.
ASPPWeeksPaidTD	Awaiting information.	Awaiting information.
ASPPWeeksToPay	Awaiting information.	Awaiting information.
ASPPWeeksWorked	Awaiting information.	Awaiting information.
ASPPWeeksWorkedThisPeriod	Awaiting information.	Awaiting information.
AverageWeeklyPay	Employee > Employee Record > Absence > SMP / SAP / SPP / SPP(A) > Dates > Average Weekly Gross Pay	The average weekly earnings of the employee.
BabyDeliveredDate	Employee > Employee Record > Absence > SMP / SPP > Dates > Baby Arrival Dates > Actually Born On Employee > Employee Record > Absence > SAP / SPP(A) > Dates > Child Arrival Dates > Actual Date of Placement	The date the baby was actually born on, or the date on which an adopted child is placed with the employee.
BabyDueDate	Employee > Employee Record > Absence > SMP / SPP > Dates > Baby Arrival Dates > Expected On (EWC) Employee > Employee Record > Absence > SAP / SPP(A) > Dates > Child Arrival Dates > Expected Date of Placement	The date that the baby is due, or the date that the adopted child is due to be placed with the employee.
EndedWorkDate	Employee > Employee Record > Absence > SMP / SAP / SPP / SPP(A) > Dates > Employment Dates > Ended work for MPP/APP/PPP	The date that work ended to begin the statutory pay period.
EvidenceReceivedFlag	Employee > Employee Record > Absence > SMP > Dates > Additional Information > Medical Evidence Received Employee > Employee Record > Absence > SAP > Dates > Additional Information > Matching Evidence Received Employee > Employee Record > Absence > SPP / SPP(A) > Dates > Additional Information > Declaration Received	Employee > Employee Record > Absence > SMP > Dates > Additional Information > Medical Evidence Received Employee > Employee Record > Absence > SAP > Dates > Additional Information > Matching Evidence Received Employee > Employee Record > Absence > SPP / SPP(A) > Dates > Additional Information > Declaration Received
HigherPayRate	Employee > Employee Record > Absence > SMP > Entitlement > Details > Higher Rate Curr. Yr. > Rate	The value of the maternity pay paid at the higher rate.
HigherPayRatePrvYr	Not shown in Sage 50 Payroll.	The value of the maternity pay paid at the higher rate in the previous year. This applies if the maternity pay period crossed two tax years.
HigherPayWeeks	Employee > Employee Record > Absence > SMP > Entitlement > Details > Higher Rate Curr. Yr. > Weeks	The number of weeks that maternity pay was paid at the higher rate.
HigherPayWeeksPrvYr	Not shown in Sage 50 Payroll.	The number of weeks that maternity pay was paid at the higher rate in the previous year. This applies if the maternity pay period crossed two tax years.
KITDays	Employee > Employee Record > Absence > SMP > Keep in Touch Days	The number of Keep in Touch days during this maternity pay period.
KITDaysThisPeriod	Not shown in Sage 50 Payroll.	The number of Keep in Touch days during the current period.
ManualPaymentFlag	Employee > Employee Record > Absence > SMP > Dates > SMP Setting > Manual SMP Calculations Employee > Employee Record > Absence > SAP > Dates > SAP Setting > Manual SAP Calculations Employee > Employee Record > Absence > SPP > Dates > SPP Setting > Manual SPP Calculations Employee > Employee Record > Absence > SPP(A) > Dates > SPP(A) Setting > Manual SPP(A) Calculations	A flag showing whether the payment is calculated manually. 0 - Not calculated manually 1 - Calculated manually
MatchingDate	Employee > Employee Record > Absence > SAP > Dates > Child Arrival Dates > Matching Date Employee > Employee Record > Absence > SPP(A) > Dates > Child Arrival Dates > Matching Date	The date that an employee who is adopting a child was notified that they have been matched with a child.
PaymentStartDate	Employee > Employee Record > Absence > SMP > Entitlement > Periods > Start of Maternity Pay Period Employee > Employee Record > Absence > SAP > Entitlement > Periods > Start of Adoption Pay Period Employee > Employee Record > Absence > SPP > Entitlement > Periods > Start of Paternity Pay Period Employee > Employee Record > Absence > SPP(A) > Entitlement > Periods > Start of Paternity Pay Period	The date of the first day of the employee's leave.
PaymentType	Not shown in Sage 50 Payroll.	The type of statutory payment. This can be any of the following: Statutory Maternity Pay Statutory Adoption Pay Statutory Paternity Pay Statutory Paternity Pay (Adoption)
PrematureBirthFlag	Employee > Employee Record > Absence > SMP > Dates > Additional Information > MPP started by early birth	A flag showing whether the maternity pay started due to early birth. 0 - Not started early 1 - Started early
QualifyingWeek	Employee > Employee Record > Absence > SMP / SPP > Entitlement > Periods > Start of Qualifying Week Employee > Employee Record > Absence > SAP / SPP(A) > Entitlement > Periods > Start of Matching Week	The date of the first Sunday in the qualifying week.
RecalcEntitlementFlag	Not shown in Sage 50 Payroll.	A flag showing whether the entitlement should be recalculated. 0 - No 1 - Yes
Reference	Employee > Employee Record > Personal > Reference	The employee reference number.
ReturnedWorkDate	Employee > Employee Record > Absence > SMP / SAP / SPP / SPP(A) > Dates > Employment Dates > Returned to Work	The date that the statutory payment period ended for the employee to return to work.
StandardPayRate	Employee > Employee Record > Absence > SMP / SAP / SPP / SPP(A) > Entitlement > Details > Standard Rate Curr. Yr. > Rate	The value of the statutory payment at the standard rate.
StandardPayRatePrvYr	Not shown in Sage 50 Payroll.	The value of the statutory payment at the standard rate in the previous year. This applies where the statutory payment period covers two tax years.
StandardPayWeeks	Employee > Employee Record > Absence > SMP / SAP / SPP / SPP(A) > Entitlement > Details > Standard Rate Curr. Yr. > Weeks	The number of weeks of the statutory payment paid at the standard rate.
StandardPayWeeksPrvYr	Not shown in Sage 50 Payroll.	The number of weeks of the statutory payment paid at the standard rate in the previous year. This applies where the statutory payment period covers two tax years.
StartedBySicknessFlag	Not shown in Sage 50 Payroll.	A flag showing whether maternity pay started early due to sickness. 0 - No 1 - Yes
ShPPInvokedFrom	Awaiting information.	Awaiting information.
ShPPDeclaration	Awaiting information.	Awaiting information.
ShPPWeeksAvailable	Awaiting information.	Awaiting information.
ShPPWeeksToTake	Awaiting information.	Awaiting information.
ShPPWeeksTakenTD	Awaiting information.	Awaiting information.
SPLiT Days Worked	Awaiting information.	Awaiting information.
TotalCompensation	Not shown in Sage 50 Payroll.	This value only applies to Sage Instant Payroll. The variable appears in the table as Sage 50 Payroll shares a database with Sage Instant Payroll.
TotalCompensationTD	Not shown in Sage 50 Payroll.	This value only applies to Sage Instant Payroll. The variable appears in the table as Sage 50 Payroll shares a database with Sage Instant Payroll.
TotalPaidTD	Not shown in Sage 50 Payroll.	This value only applies to Sage Instant Payroll. The variable appears in the table as Sage 50 Payroll shares a database with Sage Instant Payroll.
TotalRecoveredTD	Not shown in Sage 50 Payroll.	This value only applies to Sage Instant Payroll. The variable appears in the table as Sage 50 Payroll shares a database with Sage Instant Payroll.
TotalToPay	Not shown in Sage 50 Payroll.	This value only applies to Sage Instant Payroll. The variable appears in the table as Sage 50 Payroll shares a database with Sage Instant Payroll.
TotalToRecover	Not shown in Sage 50 Payroll.	This value only applies to Sage Instant Payroll. The variable appears in the table as Sage 50 Payroll shares a database with Sage Instant Payroll.
WeeksPaidTD	Not shown in Sage 50 Payroll.	This value only applies to Sage Instant Payroll. The variable appears in the table as Sage 50 Payroll shares a database with Sage Instant Payroll.
WeeksToPay	Not shown in Sage 50 Payroll.	This value only applies to Sage Instant Payroll. The variable appears in the table as Sage 50 Payroll shares a database with Sage Instant Payroll.
WeeksTradeDispute	Employee > Employee Record > Absence > SMP / SAP / SPP / SPP(A) > Dates > No. of Weeks > On Trade Dispute	The number of weeks in which the employee has been on trade dispute since joining the company.
WeeksWorked	Employee > Employee Record > Absence > SMP / SAP / SPP / SPP(A) > Dates > No. of Weeks > Worked During MPP/APP/PPP/SPP	The number of weeks that the employee has worked during the statutory payment period.
WeeksWorkedThisPeriod	Not shown in Sage 50 Payroll.	The number of weeks that the employee has worked during the current payment period.

TaxBands
Variable	Location	Details
BandFrom	Company > Legislation > PAYE > Income Tax (Bandwidths and Rates) >From	The amount of taxable earnings from which the band starts.
BandTo	Company > Legislation > PAYE > Income Tax (Bandwidths and Rates) > To	The amount of taxable earnings at which the band ends.
BRBandFlag	Company > Legislation > PAYE > Income Tax (Bandwidths and Rates) > Basic Rate Band	A flag showing whether the band is the basic rate of income tax. 0 - No 1 - Yes
EndOfTaxYear	Not shown in Sage 50 Payroll.	The end of the tax year to which the band applies.
Perc	Company > Legislation > PAYE > Income Tax (Bandwidths and Rates) > Rate %	The percentage applied to taxable earnings within this band.
SequenceID	Not shown in Sage 50 Payroll.	An internal identifier used to track any updated legislation settings downloaded from sage.co.uk.
TaxBand	Company > Legislation > PAYE > Income Tax (Bandwidths and Rates) > Bandwidth	The amount of taxable earnings within the bandwidth.
TaxBandReference	Not shown in Sage 50 Payroll.	An internal band identifier. This value increments by 1 for each band available.
ValidFrom	Not shown in Sage 50 Payroll.	The date from which the legislation applies.

NOTE: In Sage 50 Payroll v21, some variables in this table have moved to the Employees.YTD table. For further information, please refer to the New variable views in v21 tab.

Updates
Variable	Location	Details
AddPayTD	Employee > Employee Record > History > View P11 > PAYE > Additional Pay To Date	Additional pay in the full tax year to date, for each updated period.
AdjustedTaxPaid	Awaiting information.	Awaiting information.
AdjustTaxPayTD	Employee > Employee Record > History > View P11 > Taxable Pay To Date	Adjusted taxable pay in the full tax year to date, for each updated period.
ASPPAWeeksCurrentlyDue	Not shown in Sage 50 Payroll.	The number of weeks of ASPP(A) due as of the updated period.
ASPPAWks	Not shown in Sage 50 Payroll.	The total weeks ASPP(A) paid for the employee, inclusive of the current period, for each updated historical period in the full tax year to date.
ASPPNICComp	Not shown in Sage 50 Payroll.	The value of NI contributions able to be reclaimed on ASPP recovered for each employee for each updated period.
ASPPPaid	Not shown in Sage 50 Payroll.	The employee's ASPP paid in each updated period.
ASPPRecovd	Not shown in Sage 50 Payroll.	The value of ASPP that can be reclaimed for each employee for each updated period.
ASPPWeeksCurrentlyDue	Not shown in Sage 50 Payroll.	The number of weeks of ASPP due as of the updated period.
ASPPWks	Not shown in Sage 50 Payroll.	The total weeks ASPP paid for the employee, inclusive of the current period, for each updated historical period in the full tax year to date.
AVCAmountCur	Not shown in Sage 50 Payroll.	The value of the employee's AVC for the updated period.
AVCAmountHol	Not shown in Sage 50 Payroll.	The value of the employee's AVC for the updated holiday period.
BACSHashRandomString
CashRndBF	Not shown in Sage 50 Payroll.	Any amount brought forward from the previous updated period for cash rounding purposes.
CashRndCF	Not shown in Sage 50 Payroll.	Any amount carried forward to the next updated period for cash rounding purposes.
ChequeNo	Not shown in Sage 50 Payroll.	The cheque number used for the employee in the updated period if they are paid by cheque.
ConOutFlag	Employee > Employee Record > History > Con/Out	A flag showing whether the NI category of the employee is contracted out. 0 - No 1 - Yes
ConOutNICEarns	Not shown in Sage 50 Payroll.	This variable isn't in use.
ConOutNICEmployee	Not shown in Sage 50 Payroll.	This variable isn't in use.
CostOfNetPay	Not shown in Sage 50 Payroll.	The total cost to the employer for net payments, for each updated period.
CourtOrders	Not shown in Sage 50 Payroll.	The total value of attachments for each employee in each updated period.
DirEarnsAdjPrv1	Not shown in Sage 50 Payroll.	Any adjustment to earnings value for the previous director NI category for each employee in each updated historical period.
DirEarnsAdjPrv2	Not shown in Sage 50 Payroll.	Any adjustment to earnings value for the second previous director NI category for each employee in each updated historical period.
DirEarnsAdjPrv3	Not shown in Sage 50 Payroll.	Any adjustment to earnings value for the third previous director NI category for each employee in each updated historical period.
DirEENICCur	Not shown in Sage 50 Payroll.	The employee's NI contributions for the current director's NI category, for each updated period.
DirEENICPrv1	Not shown in Sage 50 Payroll.	The employee's NI contributions for the first previous director's NI category, for each updated period.
DirEENICPrv2	Not shown in Sage 50 Payroll.	The employee's NI contributions for the second previous director's NI category, for each updated period.
DirEENICPrv3	Not shown in Sage 50 Payroll.	The employee's NI contributions for the third previous director's NI category, for each updated period.
DirEERebateCur	Not shown in Sage 50 Payroll.	The employee's NI rebate for the current director's NI category, for each updated period.
DirEERebatePrv1	Not shown in Sage 50 Payroll.	The employee's NI rebate for the first previous director's NI category, for each updated period.
DirEERebatePrv2	Not shown in Sage 50 Payroll.	The employee's NI rebate for the second previous director's NI category, for each updated period.
DirEERebatePrv3	Not shown in Sage 50 Payroll.	The employee's NI rebate for the third previous director's NI category, for each updated period.
DirERNICCur	Not shown in Sage 50 Payroll.	The employer's NI contributions for the current director's NI category, for each updated period.
DirERNICPrv1	Not shown in Sage 50 Payroll.	The employer's NI contributions for the first previous director's NI category, for each updated period.
DirERNICPrv2	Not shown in Sage 50 Payroll.	The employer's NI contributions for the second previous director's NI category, for each updated period.
DirERNICPrv3	Not shown in Sage 50 Payroll.	The employer's NI contributions for the third previous director's NI category, for each updated period.
DirERRebateCur	Not shown in Sage 50 Payroll.	The employer's NI rebate for the current director's NI category, for each updated period.
DirERRebatePrv1	Not shown in Sage 50 Payroll.	The employer's NI rebate for the first previous director's NI category, for each updated period.
DirERRebatePrv2	Not shown in Sage 50 Payroll.	The employer's NI rebate for the second previous director's NI category, for each updated period.
DirERRebatePrv3	Not shown in Sage 50 Payroll.	The employer's NI rebate for the third previous director's NI category, for each updated period.
DirNICatPrv1	Not shown in Sage 50 Payroll.	The NI category letter for the previous director NI category, for each updated period.
DirNICatPrv2	Not shown in Sage 50 Payroll.	The NI category letter for the second previous director NI category, for each updated period.
DirNICatPrv3	Not shown in Sage 50 Payroll.	The NI category letter for the third previous director NI category, for each updated period.
DirNIContPrv1	Not shown in Sage 50 Payroll.	A flag showing whether the employee was contracted out for the previous director's NI category, for each updated period. 0 - No 1 - Yes
DirNIContPrv2	Not shown in Sage 50 Payroll.	A flag showing whether the employee was contracted out for the second previous director's NI category, for each updated period. 0 - No 1 - Yes
DirNIContPrv3	Not shown in Sage 50 Payroll.	A flag showing whether the employee was contracted out for the third previous director's NI category, for each updated period. 0 - No 1 - Yes
EBankPostFlag	Not shown in Sage 50 Payroll.	A flag showing whether the values for each employee for the updated period were posted using e-banking. 0 - No 1 - Yes
EmployeePensCur	Not shown in Sage 50 Payroll.	The value of the employee pension contributions for each pension scheme in the updated period. This value includes AVCs.
EmployeePensHol	Not shown in Sage 50 Payroll.	The value of the employee pension contributions for each pension scheme in the updated holiday period. This value includes AVCs.
EmployeeRebate	Not shown in Sage 50 Payroll.	The employee's NI rebate for each contracted out employee in each updated period.
EmployeeRebatePaid	Not shown in Sage 50 Payroll.	This variable isn't in use.
EmployerNIC	Not shown in Sage 50 Payroll.	The gross employer's NI contributions for each employee in each updated period.
EmployerPensCur	Not shown in Sage 50 Payroll.	The value of the employer pension contributions for each pension scheme in the updated period.
EmployerPensHol	Not shown in Sage 50 Payroll.	The value of the employer pension contributions for each pension scheme in the updated holiday period.
EmployerRebate	Not shown in Sage 50 Payroll.	The employer's NI rebate for each contracted out employee in each updated period.
EmploymentStatus	Not shown in Sage 50 Payroll.	A flag showing whether the employee was on hold at that updated period. 0 - No 1 - Yes
EndPIWDate	Not shown in Sage 50 Payroll.	The end date of the last unlinked period of incapacity for work for each employee for each updated period.
FinalPayRun	Payroll > Enter Payments > Final Pay Run	Indicates whether the current period is the employee's final pay run.
ForeignTaxCreditCur	Awaiting information.	Awaiting information.
ForeignTaxCreditHol	Awaiting information.	Awaiting information.
FreePayTD	Employee > Employee Record > History > View P11 > PAYE > Free Pay To Date	The free pay allowance in the full tax year to date, for each employee, in each updated period.
GrossForNIC	Not shown in Sage 50 Payroll.	The gross pay used for NI calculations, for each employee in each updated period.
GrossForTax	Employee > Employee Record > History > View P11 > PAYE > Gross Pay For Tax This Period	The gross pay used for PAYE calculation, for each employee in each updated period.
GrossForTaxTD	Employee > Employee Record > History > View P11 > PAYE > Gross Pay For Tax To Date	The gross pay used for PAYE calculation in the full tax year to date, for each employee up to the updated period.
GrossPayForSalarySacrifice	Not shown in Sage 50 Payroll.	The gross pay used for the calculation of salary sacrifice pension schemes in the full tax year to date, for each employee up to the updated period.
HistoryRef	Not shown in Sage 50 Payroll.	A three part reference made up of the employee's reference number, the first date of the updated pay period and the last date of the updated pay period. For example, if an employee with reference 12 is updated for the week ending 28th August 2010, the reference is 000012/22082010/28082010.
HolBase	Not shown in Sage 50 Payroll.	The value of any pay advanced for one period for each employee for each updated period.
HolDayBF	Not shown in Sage 50 Payroll.	The number of holiday days brought forward for each updated historical period.
HolidayFundAccrued	Not shown in Sage 50 Payroll.	The value added to the holiday fund for the employee in the updated period.
HolidayFundAccruedHol	Not shown in Sage 50 Payroll.	The value added to the holiday fund for the employee in the updated advanced period.
HolidayFundPaid	Not shown in Sage 50 Payroll.	The value paid from the holiday fund to the employee in the updated period.
HolidayFundPaidByEmployer	Not shown in Sage 50 Payroll.	The value paid to the holiday fund by the employer in the updated period.
HolidayFundPaidHol	Not shown in Sage 50 Payroll.	The value paid from the holiday fund to the employee in the updated period.
HolidayFundTD	Not shown in Sage 50 Payroll.	The value of the holiday fund in the full tax year to date, up to the updated period.
HolidaySchemeRef	Not shown in Sage 50 Payroll.	The holiday scheme reference number.
HolPay	Not shown in Sage 50 Payroll.	The value of any pay advanced for the total advanced period for each employee for each updated period.
HolPrd	Not shown in Sage 50 Payroll.	The number of holiday periods advanced for the employee in each updated period.
InactiveYear	This variable isn't in use.	This variable isn't in use.
KCodeRegLimit	Employee > Employee Record > History > View P11 > PAYE > Regulatory Limit	The regulatory limit for each employee for the updated period. This applies to all K codes.
Leaver	This variable isn't in use.	This variable isn't in use.
Manual8Wks	Not shown in Sage 50 Payroll.	A flag showing whether the 8 weeks average gross pay was manually calculated for each employee in each updated period. 0 - No 1 - Yes
ManualNI	Not shown in Sage 50 Payroll.	A flag showing whether the NI contributions for the employee were manually calculated. 0 - No 1 - Yes
NetForGrossCur	Not shown in Sage 50 Payroll.	The total value of net payments for the employee in each updated period.
NetForGrossHol	Not shown in Sage 50 Payroll.	The total value of net payments for the employee in each updated advanced period.
NetPay1	Not shown in Sage 50 Payroll.	The total unrounded net pay for each employee in each updated period.
NetPay2	Not shown in Sage 50 Payroll.	The total unrounded net pay, including any values brought forward for cash rounding purposes, for each employee in each updated period.
NICat	Employee > Employee Record > History > Nat. Ins. Category	The employee's NI category for each updated period.
NICEarnsToEeET	Not shown in Sage 50 Payroll.	This variable isn't in use.
NICEarnsToErET	Not shown in Sage 50 Payroll.	This variable isn't in use.
NICEarnsToET	Employee > Employee Record > History > View P11 > National Insurance > Earnings LEL to ET	NI earnings between the LEL and the ET for each employee for each updated period.
NICEarnsToLEL	Employee > Employee Record > History > View P11 > National Insurance > Earnings Up to UEL	The employee's NI earnings up to the LEL for each updated period.
NICEarnsToUAP	Employee > Employee Record > History > View P11 > National Insurance > Earnings ET to UAP	The employee's NI earnings up to the UAP for each updated period.
NICEarnsToUEL	Employee > Employee Record > History > View P11 > National Insurance > Earnings UAP to UEL	The employee's NI earnings up to the UEL for each updated period.
NICHolNotConOut	Not shown in Sage 50 Payroll.	This variable isn't in use.
NICHolRecovd	This variable isn't in use.	This variable isn't in use.
NICostOfNetPay	Not shown in Sage 50 Payroll.	The cost to the employer of NI contributions for net payments, for each employee in each updated period.
NIGross8Wks	Not shown in Sage 50 Payroll.	The gross pay to be used in calculating the 8 weeks average gross pay for each employee in each updated period.
NLBankPostDate	Not shown in Sage 50 Payroll.	The date that the bank payment was posted to the nominal ledger.
NLBankPostReference	Not shown in Sage 50 Payroll.	The reference used to post the bank payment to the nominal ledger.
NLPostDate	Not shown in Sage 50 Payroll.	The date when the updated values were posted using the nominal link.
NLPostFlag	Not shown in Sage 50 Payroll.	A flag showing whether the updated data for the employee was posted using the nominal link. 0 - No 1 - Yes
OnHoliday	Not shown in Sage 50 Payroll.	A flag showing whether the employee was on holiday for the updated period. 0 - No 1 - Yes
PaidTaxRefundWithheld	Not shown in Sage 50 Payroll.	The value of tax withheld during a trade dispute but subsequently repaid, for each employee in each updated period.
PayByNet	Not shown in Sage 50 Payroll.	A flag showing whether the employee is paid using net payments. 0 - No 1 - Yes
PaymentMethod	A flag showing whether the employee was on holiday for the updated period. 0 - No 1 - Yes	The method of payment used for the employee for the updated period. BACS Cash Cheque Credit Transfer
PaymentPeriod	Not shown in Sage 50 Payroll.	The payment frequency used for the employee for the updated period. Weekly Fortnightly Four Weekly Monthly
Pensionable	Not shown in Sage 50 Payroll.	The employee's pensionable earnings for each updated period.
PeriodEnd	Not shown in Sage 50 Payroll.	The last date of the tax week or month into which the updated process date falls.
PeriodStart	Not shown in Sage 50 Payroll.	The first date of the tax week or month into which the updated process date falls.
PreTaxDed	Not shown in Sage 50 Payroll.	The employee's total value of individual deduction types subject to income tax, for each updated period.
PreTaxPay	Not shown in Sage 50 Payroll.	The employee's total value of individual payment types subject to income tax, for each updated period.
PrimaryRebate	Not shown in Sage 50 Payroll.	This variable is no longer required as it now contains the same value as the EmployerRebate variable.
ProcessDate	Employee > Employee Record > History > Date Processed	The date on which the employee record was updated.
PstTaxDed	Not shown in Sage 50 Payroll.	The employee's total value of individual deduction types that are not subject to income tax, for each updated period.
PstTaxPay	Not shown in Sage 50 Payroll.	The employee's total value of individual payment types that are not subject to income tax, for each updated period.
QualifyingEarnings	Awaiting information.	Awaiting information.
QualifyingEarningsBelowAEThreshold	Awaiting information.	The employee's earnings after the automatic enrolment bands have been applied, for each updated period.
QualifyingEarningsHol	Awaiting information.	The employee's earnings after the automatic enrolment bands have been applied, for each updated advanced period.
Reference	Employee > Employee Record > Personal > Reference	The employee's reference number.
RefundFlag	Not shown in Sage 50 Payroll.	A flag showing whether the tax for the employee is a payment or a refund. 0 - Payment of tax 1 - Refund of tax
RndNetPay	Employee > Employee Record > History > Total Net Pay	The rounded net pay for each employee in each updated period.
RndNetPaySecAcc	Not shown in Sage 50 Payroll.	The rounded net pay to be paid to the employee's second account in each updated period.
SalarySacrificeAmount	Not shown in Sage 50 Payroll.	The salary sacrifice amount for the updated period.
SAPNICComp	Not shown in Sage 50 Payroll.	The value of NI contributions able to be reclaimed on SAP recovered for each employee for each updated period.
SAPPaid	Not shown in Sage 50 Payroll.	The employee's SAP paid in each updated period.
SAPRecovd	Not shown in Sage 50 Payroll.	The value of SAP that can be reclaimed for each employee for each updated period.
SAPWeeksCurrentlyDue	Not shown in Sage 50 Payroll.	The number of weeks of SAP due as of the updated period.
SAPWks	Not shown in Sage 50 Payroll.	The total weeks SAP paid for the employee, inclusive of the current period, for each updated historical period in the full tax year to date.
SCONRef	Not shown in Sage 50 Payroll.	The Scheme Contracted Out Number for each employee for each updated period. This only applies if the employee is part of a contracted-out occupational pension scheme.
SecondaryRebate	Not shown in Sage 50 Payroll.	This variable is no longer required as it now contains the same value as the EmployeeRebate variable.
SelForHistReport	Not shown in Sage 50 Payroll.	Indicates whether the employee should appear on historical reports.
ShPPWeeksCurrentlyDue	Not shown in Sage 50 Payroll.	The number of weeks of ShPP due as of the updated period.
ShPPWks	Not shown in Sage 50 Payroll.	The cumulative number of weeks for which ShPP is paid for each employee in each updated period.
ShPPNICComp	Not shown in Sage 50 Payroll.	The value of NI contributions that can be reclaimed on the ShPP recovered for each employee in each updated period.
ShPPPaid	Not shown in Sage 50 Payroll.	The employee's ShPP paid in each updated period.
ShPPRecovd	Not shown in Sage 50 Payroll.	The value of ShPP that can be reclaimed for each employee for each updated period.
SLRPaymentCur	Not shown in Sage 50 Payroll.	The employee's student loan payment in each updated period.
SLRPaymentHol	Not shown in Sage 50 Payroll.	The employee's student loan payment in each advanced period.
SMPNICComp	Not shown in Sage 50 Payroll.	The value of NI contributions that can be reclaimed on SMP recovered for each employee for each updated period.
SMPPaid	Not shown in Sage 50 Payroll.	The employee's SMP paid in each updated period.
SMPRecovd	Not shown in Sage 50 Payroll.	The value of SMP that can be reclaimed for each employee for each updated period.
SMPWeeksCurrentlyDue	Not shown in Sage 50 Payroll.	The number of weeks of SMP due as of the updated period.
SMPWks	Not shown in Sage 50 Payroll.	The cumulative number of weeks for which SMP is paid for each employee in each updated period.
SPPAWeeksCurrentlyDue	Not shown in Sage 50 Payroll.	The number of weeks of SPP(A) due as of the updated period.
SPPAWks	Not shown in Sage 50 Payroll.	The cumulative number of weeks for which SPPA is paid for each employee in each updated period.
SPPNICComp	Not shown in Sage 50 Payroll.	The value of NI contributions that can be reclaimed on the SPP recovered for each employee in each updated period.
SPPPaid	Not shown in Sage 50 Payroll.	The employee's SPP paid in each updated period.
SPPRecovd	Not shown in Sage 50 Payroll.	The value of SPP that can be reclaimed for each employee for each updated period.
SPPWeeksCurrentlyDue	Not shown in Sage 50 Payroll.	The number of weeks of SPP due as of the updated period.
SPPWks	Not shown in Sage 50 Payroll.	The total number of weeks SPP paid, inclusive of the current period, for each updated historical period in the full tax year to date.
SSPBand	Awaiting information.	Awaiting information.
SSPPaid	Not shown in Sage 50 Payroll.	The employee's SSP paid in each updated period.
SSPWks	Not shown in Sage 50 Payroll.	The cumulative number of weeks for which SSP is paid for each employee in each updated period.
StartPIWDate	Not shown in Sage 50 Payroll.	The start date for the last unlinked period of incapacity for work for each employee in each updated period.
Status	Not shown in Sage 50 Payroll.	A flag showing the status of the employee for each updated period. 0 - OK 1 - On Hold 2 - Trade Dispute
StdNICEarns	Not shown in Sage 50 Payroll.	The employee's standard earnings for NI for each updated period.
StdNICEarnsHol	This variable isn't in use.	This variable isn't in use.
TaxCode	Employee > Employee Record > History > Tax Code	The employee's tax code for each updated period.
TaxCostOfNetPay	Not shown in Sage 50 Payroll.	The cost to the employer of income tax for net payments, for each employee in each updated period.
TaxCreditsCur	This variable isn't in use.	This variable isn't in use.
TaxCreditsHol	This variable isn't in use.	This variable isn't in use.
TaxDue	Employee > Employee Record > History > View P11 > PAYE > Total Tax Due	The employee's income tax due for each updated period. If the K-code regulatory limit is in operation, this value may be greater than the TaxPaid.
TaxDueTD	Employee > Employee Record > History > View P11 > PAYE > Total Tax Due To Date	The employee's income tax due in the full tax year to date for each updated period. If the K-code regulatory limit is in operation, this value may be greater than the TaxPaidTD.
TaxMonth	Employee > Employee Record > History > Tax Month	The tax month in which the employee's record was updated.
TaxNotCol	Employee > Employee Record > History > View P11 > PAYE > Tax Not Deducted	The value of income tax not collected, applicable to K-codes, for each employee in each updated period.
TaxPaid	Employee > Employee Record > History > View P11 > PAYE > Tax Deducted or Refunded	The employee's income tax paid for each updated period. If the K-code regulatory limit is in operation, this value may be lower than the TaxDue.
TaxPaidTD	Not shown in Sage 50 Payroll.	The employee's income tax paid in the full tax year to date for each updated period. If the K-code regulatory limit is in operation, this value may be lower than the TaxDueTD.
TaxRefundWithheld	Not shown in Sage 50 Payroll.	The value of any tax refund withheld due to a trade dispute, for each employee in each updated period.
TaxWeek	Employee > Employee Record > History > Tax Week	The tax week in which the employee's record was updated.
TaxYearStart	Not shown in Sage 50 Payroll.	The start of the tax year into which the updated processing date falls.
TotalAttachCosts	Not shown in Sage 50 Payroll.	The total administration fees for attachments, for each employee in each updated period.
TotalGross	Employee > Employee Record > HIstory > Total Gross Pay	The employee's total gross pay prior to any deductions, for each employee in each updated period.
TotalHours	Employee > Employee Record > History > View P11 > Weekly Averages > Total Pay	The number of hours taken into account for each employee for each updated period when calculating the 12 or 13 weekly average.
TotalLoansPaid	Not shown in Sage 50 Payroll.	The employee's loan repayments made for each employee in each updated period.
TotalLoansPaidHol	Not shown in Sage 50 Payroll.	The employee's loan repayments made for each employee in each advanced period.
TotalPay	Employee > Employee Record > History > View P11 > Weekly Averages > Total Pay	The value of pay taken into account for each employee for each updated period when calculating the 12 or 13 weekly average.
UpdateVersion	Not shown in Sage 50 Payroll.	An internal value which increments each time a major change occurs within the table. This value is used with the rollback feature.
UserID	Not shown in Sage 50 Payroll.	The login reference for the user logged in to Sage 50 Payroll when the period was updated
WaitDays	Not shown in Sage 50 Payroll.	The number of waiting days in the current period of incapacity for work for each employee for each updated period.
Wk1BasisFlag	Employee > Employee Record > History > Wk1 Mth1	A flag showing whether the employee's tax code is using a week 1 / month 1 basis, for each employee in each updated period. 0 - No 1 - Yes

Variance
Variable	Location	Details
Address1-5	Employee > Employee Record > Personal > Address	The employee's address.
Analysis1	Employee > Employee Record > Analysis > Employee Analysis > Analysis 1	The first user-defined analysis field.
Analysis2	Employee > Employee Record > Analysis > Employee Analysis > Analysis 2	The second user-defined analysis field.
Analysis3	Employee > Employee Record > Analysis > Employee Analysis > Analysis 3	The third user-defined analysis field.
BriefNotes	Employee > Employee Record > Analysis > Notes	A memo field taken from the employee record. NOTE: As the wrapping options don't work on this variable, it isn't suitable for adding long notes to reports or layouts.
CCReference	Employee > Employee Record > Analysis > Company Analysis > Cost Centre	The cost centre number for the employee's cost centre.
Contact	Employee > Employee Record > Personal > Contact Details > Name	The name of the employee's emergency contact.
ContactAddress1-5	Employee > Employee Record > Personal > Contact Details > Address	The address of the employee's emergency contact.
ContactEmail	Employee > Employee Record > Personal > Contact Details > Email	The email address of the employee's emergency contact.
ContactMobile	Employee > Employee Record > Personal > Contact Details > Mobile	The mobile number for the employee's emergency contact.
ContactPostcode	Employee > Employee Record > Personal > Contact Details > Post Code	The postcode of the employee's emergency contact.
ContactTel	Employee > Employee Record > Personal > Contact Details > Telephone	The telephone number of the employee's emergency contact.
CostCentreReference	Not shown in Sage 50 Payroll.	The cost centre number for the employee.
Country	Employee > Employee Record > Personal > Country	The employee's country of residence.
CurrentValue	Not shown in Sage 50 Payroll.	The current period value.
DateDirshipBegan	Employee > Employee Record > Employment > YTD Values > Director's NIC > Date Directorship Began	The date when the employee became a director.
DateOfBirth	Employee > Employee Record > Personal > Date of Birth	The employee's date of birth.
DaysHolAccruedToDate	Employee > Employee Record > Absence > Holiday > Entitlement > Accrued to date	The date to which the employee's holiday accrual is calculated.
Deceased	Employee > Employee Record > Employment > Leaver > Deceased	A flag showing whether the employee is deceased. 0 - Not deceased 1 - Deceased
DepartmentReference	Employee > Employee Record > Analysis > Company Analysis > Department	The department number to which the employee belongs.
Description	Company > Variance Settings > Settings > Variance > Description or Company > Variance Settings > Payments > Variance > Description or Company > Variance Settings > Deductions > Variance > Description	The type of variance. This can be any of the following: Gross Pay Net Pay Employer's Pensions Employee's Pensions Total Payments Total Deductions
DirectorFlag	Employee > Employee Record > Employment > Director Status	A flag showing whether the employee is a director. 0 - Not a director 1 - Director or Director (Table Method) NOTE: There is a known issue with this variable and it does not appear correctly for directors unless they are on the table method. As an alternative, use the DirectorStatus variable.
DirectorStatus	Employee > Employee Record > Employment > Director Status	The director status of the employee. 0 - Not a director 1 - Director 2 - Director (Table Method)
Disabled	Employee > Employee Record > Personal > Disabled	A flag showing whether the employee is disabled. 0 - No 1 - Yes
EmailAddress	Employee > Employee Record > Personal > E-Mail	The employee's email address.
EmployeeReference	Employee > Employee Record > Personal > Reference	The employee's reference number.
EthnicOrigin	Employee > Employee Record > Personal > Ethnic Origin	The ethnic origin of the employee.
Forename	Employee > Employee Record > Personal > Forenames	The employee's forename.
Gender	Employee > Employee Record > Personal > Sex	The employee's gender.
Initials	Employee > Employee Record > Personal > Initials	The employee's initials.
MaritalStatus	Employee > Employee Record > Personal > Marital Status	The employee's marital status.
MobileTelephone	Employee > Employee Record > Personal > Mobile	The employee's mobile telephone number.
Nationality	Employee > Employee Record > Personal > Nationality	The nationality of the employee.
NINumber	Employee > Employee Record > Employment > NI Number	The employee's NI number.
NoOfDaysHolAccrued	This variable is no longer in use.	This variable is no longer in use.
OnHoldFlag	Employee > Employee Record > Employment > Status	A flag showing whether the employee is currently on hold. 0 - Not on hold 1 - On hold
PatternStartDate	Employee > Employee Record > Absence > Holiday > Settings > Working Day Pattern (Sun - Sat) > Pattern Start Date	The date on which the qualifying date pattern for the employee's holiday starts. This date must be a Sunday.
PayStatus	Employee > Employee Record > Employment > Status	The pay status of the employee. 0 - OK 1 - On Hold 2 - Trade Dispute
Postcode	Employee > Employee Record > Personal > Post Code	The employee's post code.
PreviousSurname	Employee > Employee Record > Personal > Previous Surname	The previous surname of the employee.
PreviousValue	Not shown in Sage 50 Payroll.	The amount of average pay or last updated value.
QDPatternStartDate	Employee > Employee Record > Absence > SSP > Qualifying Days > SSP Qualifying Day Pattern (Sun - Sat) > Pattern Start Date	The date on which the qualifying date pattern for employee absence starts. This date must be a Sunday.
Reference	Not shown in Sage 50 Payroll.	A unique reference for the variance.
Relationship	Employee > Employee Record > Personal > Contact Details > Relationship	The relationship to the employee of their emergency contact.
Sensitivity	Employee > Employee Record > Analysis > Access Level	The access level set for the employee. This determines which Sage 50 Payroll users can access their record.
Surname	Employee > Employee Record > Personal > Surname	The employee's surname.
Telephone	Employee > Employee Record > Personal > Telephone	The employee's telephone number.
Title	Employee > Employee Record > Personal > Title	The employee's title.
UseAttachTables	Employee > Employee Record > Employment > Pay Elements > Attachment of Earnings Orders > Use Tables for Community Charge, Council Tax, Earning Arrestments and Fines Enforcement	A flag showing whether pre-defined tables should be used when deducting CCAEOs, CTAEOs or Earning Arrestments. 0 - Not using pre-defined tables 1 - Using pre-defined tables
VarAsAmt	Not shown in Sage 50 Payroll.	The variance as an amount.
VarAsPct	Not shown in Sage 50 Payroll.	The variance as a percentage.
WorkEndDate	Employee > Employee Record > Employment > Employment Period To	The date that the employee left their employment.
WorkReturnedDate	Employee > Employee Record > Absence > No processing until	The next date at which the employee can be processed.
WorksNumber	Employee > Employee Record > Employment > Works Number	The employee's works number.
WorkStartDate	Employee > Employee Record > Employment > Employment Period From	The date that the employee started their employment.

The tables and variables available in Sage Report Designer

Summary

Description

Resolution

By table

SUPPORT & TRAINING

PARTNERS

COMPANY

FAQs