Solution Properties
Solution ID:
200427112313942
Last Modified Date:
Tue Oct 21 14:51:47 UTC 2025
Taxonomy Path:
Case category//How do I...//setting up
Author:
[email protected]
Enter formulae for payments and deductions
Description
Cause
Resolution

Table of Contents

Standard references

  • CURE - The current hours / value entered on the time sheet for this element / deduction
  • CURR - The current rate on the time sheet for this element / deduction
  • CURV - The calculated value for this element / deduction
  • PENP - Pensionable pay. This is the sum of payments marked as pens. on the Payroll Payments men
  • DEDX - The number of deduction weeks. This is useful when an amount is to increase for holidays
  • INSX - The number of insurance weeks
  • TAXP - Taxable pay. This is the sum of payments marked as taxable on the Payroll Payments menu
  • NETP - Net pay. Use this only in the formula for the calculation of split net pay

Formula operators

You can use standard mathematical operators in formulae.
Symbol Meaning
+ Add
- Subtract
* Multiply
/ Divide
% Percent
( Left bracket
) Right bracket

TIP: Formulas use the mathematical order of operations, equations in brackets calculate first.

Specific payments

  • VC[x] - The calculated value for payment number x
  • VE[x] - The entered value / hours for payment number x
  • VR[x] - The effective rate for payment number x
Specific deductions
  • XC[x] - The standard / calculated employee value for deduction number x
  • XD[x] - The standard / calculated employer value for deduction number x
  • XE[x] - The entered amount for deduction number x

Common employee details fields

Field name Description
STD_HOURS Standard Hours
HRLY_RATE1 Hourly Rate 1
HRLY_RATE2 Hourly Rate 2
HRLY_RATE3 Hourly Rate 3
HRLY_RATE4 Hourly Rate 4
MVALUE1 Memo Value 1
MVALUE2 Memo Value 2
MVALUE3 Memo Value 3
MVALUE4 Memo Value 4
GROSS_TE Gross Pay This Employment
GROSS_TY Gross Pay To Date
PENS_PAY Pensionable Pay To Date
NETT_YTD Nett Pay To Date
HOL_BF Holidays Brought Forward
HOL_ALL Holidays Entitlement (Allowance)
HOL_TAK Holidays Taken
CSICK_BF Sick Cert Brought Forward
CSICK_ALL Sick Cert Entitlement (Allowance)
CSICK_TAK Sick Cert Taken
USICK_BF Sick Un-Cert Brought Forward
USICK_ALL Sick Un-Cert Entitlement (Allowance)
USICK_TAK Sick Un-Cert Taken
OTHER_BF Other Brought Forward
OTHER_ALL Other Entitlement (Allowance)
OTHER_TAK Other Taken

Example formulae

  • PENP * 0.03 - pensionable pay (payments ticked as pensionable) multiplied by 3%
  • PENP * HRLY_RATE4 - pensionable pay multiplied by Hourly Rate 4 from the employee record, where Hourly Rate 4 contains a different percentage amount for each employee
  • (PENP - 120.00) * 0.03 - pensionable pay less 120.00, all multiplied by 3%
  • 0 – CURE - this formula will turn the current entered value to a negative amount
  • (VC[1] + VC[2] + VC[3]) * 0.15 calculates the sum of payments 1, 2, and 3, multiplies by 15%, such as a Shift Premium

General notes

  • Always use all upper case letters
  • By default, the formula applies to all employees. To exclude specific employees, set them up with a profile that omits the payment or deduction
  • Unknown Token or Unexpected Symbol - If this message appears, the payment/deduction formula format on the timesheet is incorrect. This includes incorrect brackets, or an invalid field reference on the formula. A comment can also appear on the calculated payslip to indicate which payment or deduction is incorrect

Enter a formula for a payment

  1. Go to Company / Payroll, then select Payments.
  2. Select the relevant payment, then Edit.
  3. In Advanced, enter the content in Formula.
  4. Select Save, then Close.

Enter a formula for a deduction

  1. Go to Company / Payroll, then select Deductions.
  2. Select the relevant deduction, then Edit.
  3. In Advanced, enter the content in the Employee Formula.
  4. In Employer Formula, enter the content for the employer's contribution formula.
  5. Select Save, then Close.

External formula

Sometimes, the formula you require is too long. To enable a longer and more complex formula for your employees' timesheets:

  1. Enter the required formula in a text file with a .fml extension.
  2. Store the .fml file in the Sage 50 Payroll Ireland data directory.
  3. In the formula field in the formula section of the payment or deduction, enter the following:
    program "formula.fml"

Request a formula design

To save you time, we offer a chargeable formula design service. We create a custom formula for all processing scenarios. For more information, contact us.

Steps to duplicate
Related Solutions