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 to | Use |
|---|---|
| Catch the usual mistakes: no wages, zero net pay, missing contributions, no bank account | KAMI's built-in checks. See Payroll automation rules |
| Flag a figure above or below a limit you choose | A rule compared with a fixed amount |
| Flag a figure that's out of proportion to another, whatever the salary | A rule compared with a % of another field |
| Change what someone is paid | Their 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
- Open Payroll › Settings › Payroll Automations.
- Click Add rule at the top, or Add a rule to Wages (or another page) under the section it belongs to.
- Under Flag a payslip when, choose the Field to check and how it compares in Is: equal to, greater than or less than.
- In Compared with, choose A fixed amount or A % of another field.
- Type the Amount, or the Percentage and the field it's a share Of. The value must be above zero.
- 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.
- Under Where it applies, set Checked on, Profile Groups and Batch Cycles.
- 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
| Field | What it does |
|---|---|
| Field | The payslip figure the rule checks. See the list below |
| Is | equal to, greater than or less than |
| Compared with | A fixed amount: the field against a number. A % of another field: the field against a share of a second field |
| Amount / Percentage | The number, or the percentage. Must be above zero |
| Of | The second field, for a percentage rule. It must be a different field from the first |
| Checked on | The batch page the flag belongs to: Wages, Other Payments, Payslips, Compare or Payment. It decides where the rule is listed on this page |
| Profile Groups | Only check employees in these groups. Empty means All Employees |
| Batch Cycles | Only 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 flag | Field | Is | Compared with |
|---|---|---|---|
| Other payments above 30,000 | Total Other Payments | greater than | A fixed amount: 30,000 |
| More than 40 overtime hours in a period | Overtime Hours | greater than | A fixed amount: 40 |
| Overtime pay above half of basic pay | Overtime Amount | greater than | 50 % of Basic Monthly Wage |
| Net pay below 30% of total wage | Total Payable | less than | 30 % 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.