Payroll validation rules

Payroll validation rules

A validation rule is a check you write yourself, so KAMI flags any payslip whose figures look wrong for your company: other payments above 30,000, overtime hours above 40, net pay above twice the basic wage. Rules run on every payslip each time a batch is calculated, next to KAMI's built-in checks, and a payslip that breaks one is flagged for the reviewer before anyone is paid.

Where: Payroll › Settings › Automation › Payroll Automations, under Your rules on each batch page section

You need: the Settings Payroll right with write access to add, edit, switch or delete rules.

Which one, when

You want toUse
Catch the usual mistakes: no wages, zero net pay, missing contributions, no bank accountKAMI's built-in checks. See Payroll automation rules
Flag a figure above or below a limit you chooseA rule compared with a fixed amount
Flag a figure that's out of proportion to another, whatever the salaryA rule compared with a % of another field
Change what someone is paidTheir payslip or payroll settings. A rule never changes a figure

A rule describes the wrong case

A rule says what a bad payslip looks like. "Total Other Payments is greater than 30,000" flags every payslip whose other payments are above 30,000. Write the sentence you'd say out loud when something has gone wrong.

How to add a rule

  1. Open Payroll › Settings › Payroll Automations.
  2. Click Add rule at the top, or Add a rule to Wages (or another page) under the section it belongs to.
  3. Under Flag a payslip when, choose the Field to check and how it compares in Is: equal to, greater than or less than.
  4. In Compared with, choose A fixed amount or A % of another field.
  5. Type the Amount, or the Percentage and the field it's a share Of. The value must be above zero.
  6. Read the preview line, for example "Flags a payslip when Total Other Payments is greater than 30,000." If it doesn't say what you mean, change it now.
  7. Under Where it applies, set Checked on, Profile Groups and Batch Cycles.
  8. Click Add rule.

The rule is switched on as soon as it's saved and shows under Your rules, tagged Yours, with its scope beside it.

How to change, pause or delete a rule

  • Edit: click the pencil on the rule's row, change it, then Save.
  • Pause: click its switch to turn it off. It stays on the page for later.
  • Delete: click the bin, then confirm. The rule stops being checked. Payslips it already flagged keep their flag until they're recalculated.

The fields in the rule window

FieldWhat it does
FieldThe payslip figure the rule checks. See the list below
Isequal to, greater than or less than
Compared withA fixed amount: the field against a number. A % of another field: the field against a share of a second field
Amount / PercentageThe number, or the percentage. Must be above zero
OfThe second field, for a percentage rule. It must be a different field from the first
Checked onThe batch page the flag belongs to: Wages, Other Payments, Payslips, Compare or Payment. It decides where the rule is listed on this page
Profile GroupsOnly check employees in these groups. Empty means All Employees
Batch CyclesOnly check payslips in these cycles. Empty means All Batch Cycles

A rule with both left empty reads Everyone, every batch cycle. With groups chosen, an employee in any one of them is checked.

The fields you can check

Payslip totals: Basic Monthly Wage, Basic Daily Wage, Basic Hourly Wage, Total Wage, Total Other Payments, Total Contributions Employee, Total Contributions Employer, Net Monthly Income, Net Annual Income, Total Payable, Total Taxes, Tax Payable.

Wage components, added up the way the batch's Wages tab shows them, in money and in time: Overtime Amount, Overtime Hours, Holiday Amount, Holiday Hours, Night Shift Amount, Night Shift Hours, Leave Amount, Leave Days, Absence Amount, Absence Days.

Total Payable is the net pay the employee receives. Use it for limits on what leaves the bank.

Worked examples

You want to flagFieldIsCompared with
Other payments above 30,000Total Other Paymentsgreater thanA fixed amount: 30,000
More than 40 overtime hours in a periodOvertime Hoursgreater thanA fixed amount: 40
Overtime pay above half of basic payOvertime Amountgreater than50 % of Basic Monthly Wage
Net pay below 30% of total wageTotal Payableless than30 % of Total Wage

What Happens Next

  • Rules run when a batch is calculated or recalculated. A new or changed rule doesn't touch payslips already calculated. Recalculate to apply it.
  • A payslip that breaks a rule is marked Invalid Payslip. In the batch, it appears under the Validations filter on the Payslips tab, with a red icon on its row. Its details show the rule that fired.
  • A flag never blocks approval or payment. It tells the reviewer where to look.
  • Paid payslips are never re-checked. They can't be recalculated.

Tips

  • Write rules for mistakes you've actually had. One rule per past incident is worth more than twenty invented up front.
  • Prefer percentage rules for relationships. "Other payments above 50% of basic wage" stays right after a pay rise. A fixed amount goes stale.
  • Start loose and tighten. A rule that flags twenty payslips every run gets ignored within two cycles.
  • Scope rules that only make sense for some staff, such as an overtime limit for office staff, with Profile Groups rather than writing exceptions.
  • Recalculate an open batch after adding a rule, to see what it would have caught.

Troubleshooting / FAQ

My rule isn't flagging anything. Recalculate the batch: rules run at calculation. Then check the direction of Is, and that the employee is in the rule's groups and cycles.

Every payslip is flagged. The limit is too tight, or greater than and less than are the wrong way round.

Can I write a rule for a value of zero, such as "net pay equal to 0"? No: the value must be above zero. Use the built-in checks Net pay is zero or negative and A payslip is calculated with no wages instead.

I chose "equal to 50% of" a field and it never fires. With equal to, a percentage rule flags only when the two fields are exactly equal, whatever percentage you type. Use greater than or less than for a share.

The rule window says "Compare the field with a different one." A percentage rule can't compare a field with itself. Pick another field in Of.

Related articles