Portfolio / Case study 06
A leave management sheet covering teams in three countries, built so payroll adjustments came from one reliable record.

Project walkthrough

$ start project "Leave and payroll tracker"
✓ Brief agreed with BBV Group
✓ Built one leave register with country-specific rules
✓ Added balances, approvals and monthly summaries
✓ Connected the monthly summary to payroll inputs
→ Review with the client…
● Delivered and handed over
The project
Leave was tracked differently in each country. Payroll deductions depended on messages and memory rather than a single record.
Payroll inputs for leave came from one sheet, and balances were visible to managers at any time.
Leave rules are not the same everywhere. Public holidays, entitlements and approval habits differ between countries, so a single generic sheet rarely fits every team. When leave is handled through messages and memory, payroll deductions depend on whoever remembers the conversation, and mistakes are only found after the payslip is issued.
I wanted one reliable record that respected the differences between countries instead of ignoring them.
I built a single leave register with the rules of each country built in, including balances, approvals and monthly summaries. Managers could see how much leave each person had left at any time, and employees were not asking around to find out. The register includes:
The monthly summary was connected to the payroll inputs, so deductions and adjustments came from the same record that managers had already approved. That removed a whole round of checking, because the payroll figure and the leave record could no longer disagree.
If your leave is managed in different ways by different teams, a shared register is a good place to begin. It does not need expensive software to work, only clear rules and one place where the answers live.
Gallery and links
Figures are anonymised. Click an image to enlarge it.



Services used
Let's connect
Book a free 30-minute call on Google Meet, or reach me directly.
We use cookies to improve your experience on our site. By using our site, you consent to cookies.
Manage your cookie preferences below:
Essential cookies enable basic functions and are necessary for the proper function of the website.
You can find more information in our Privacy Policy and .