Blog
Your conditions of service are formulas. Your payroll should be too.
A collective agreement is full of arithmetic: 12% of basic for these grades, time and a half on weekdays, double on Sundays, a cap on transport. A payroll system that only gives you a box for an amount leaves a gap, and the gap is where the spreadsheets come from.
Where fixed fields run out
A payroll system with fixed fields works until your rules stop being simple. A housing allowance that is a percentage for junior grades and a flat amount for managers. Overtime at one rate on weekdays and another on Sundays and public holidays. A transport allowance that is 5% of basic but never more than K2,500. Leave days sold back at a day's pay.
When the system cannot hold a rule, the rule has to live somewhere else: a spreadsheet, worked out each month and loaded into the payroll as a fixed amount. Now the real rule lives in one person's file, nobody else can check it, and when that person is on leave the allowance is guessed.
The other way out is a change request to the supplier, paid for, and waited on, every time the union agrees something new.
The same rules, written as formulas
In Albo each allowance and deduction carries a formula, written in plain words over the figures payroll
already knows: basic, the units entered for the month such as overtime hours, days worked,
and working days and hours in the period. MIN, MAX, IF and
ROUND handle caps, tiers and conditions.
| The rule in the agreement | The formula |
|---|---|
| Housing, 12% of basic, grades J1 to J5 | basic * 0.12 |
| Overtime at time and a half | basic * units * 1.5 / workingHoursPerMonth |
| Transport, 5% of basic, at most K2,500 | MIN(basic * 0.05, 2500) |
| Leave days sold back | basic * 12 * units / workingDaysPerYear |
| Employer's share of a private pension, 15% | basic * 0.15 |
A rule covers a set of grades and starts from a date. When a new agreement raises the housing allowance from 12% to 14%, that is one new rule dated from the day it starts, not hundreds of edited amounts, and the months before it keep the rule they were paid on.
Worked through for one person
Natasha is on grade J3 with a basic of K8,000. This month she worked 10 hours of overtime, and the month has 176 working hours.
- Housing: K8,000 × 0.12 = K960.00
- Transport: 5% of K8,000 is K400, under the K2,500 cap, so K400.00
- Overtime: K8,000 × 10 × 1.5 ÷ 176 = K681.82
Every figure on her payslip can be traced back to a line anyone in the office can read. If her manager asks how the overtime was worked out, the answer is on the screen, not in someone's head.
Checked before it pays anyone
A formula is only as good as the person who wrote it, so Albo lets you test any formula against sample figures before a run uses it. When you move to Albo, we set your components up with you from your conditions of service and a recent payslip, and a month run side by side with your old system proves each one before it goes live.
Bring your collective agreement to a demonstration, pick the three rules your current system handles worst, and we will set them up in front of you.
More from the blog
- Choosing a payroll system in Zambia: 12 questions
What to ask before you sign, and what a good answer sounds like.
- Payroll for mines and large workforces
Casuals, shifts and piece work, thousands of people in one run.
- Every article
Payroll in Zambia, written for the people who run it.
See Albo with your own pay rules
Tell us how many people you pay, how they are paid, and what you use today. We will show you Albo working on rules like yours, at your office or online.
- Call
- +260 979 068 878
- info@elucive.co
- Office
- Lusaka, Zambia