Albo Book a demo

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 agreementThe formula
Housing, 12% of basic, grades J1 to J5basic * 0.12
Overtime at time and a halfbasic * units * 1.5 / workingHoursPerMonth
Transport, 5% of basic, at most K2,500MIN(basic * 0.05, 2500)
Leave days sold backbasic * 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

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
Email
info@elucive.co
Office
Lusaka, Zambia