Portfolio / Case study 06

PayrollHR dataGoogle Sheets

Leave and payroll tracker

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

ClientBBV Group
IndustryTeams across Pakistan, India and Vietnam
My roleBusiness Operations Manager
ToolsGoogle Sheets, Excel
Leave and payroll tracker for BBV Group

Project walkthrough

See how the work was put together

Leave and payroll tracker, project walkthrough
Leave and payroll trackerClick to play
finzain · project log

$ 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

Problem, approach and result

01

The challenge

Leave was tracked differently in each country. Payroll deductions depended on messages and memory rather than a single record.

02

What I did

  • Built one leave register with country-specific rules
  • Added balances, approvals and monthly summaries
  • Connected the monthly summary to payroll inputs
03

The result

Payroll inputs for leave came from one sheet, and balances were visible to managers at any time.

Why leave tracking breaks across countries

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.

One register with country-specific rules

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:

  • Entitlements and balances for each person
  • An approval step for every request
  • Country-specific holidays and rules
  • A monthly summary that is easy to review

Connecting leave to payroll

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

Screens from the project

Figures are anonymised. Click an image to enlarge it.

Leave and payroll tracker main screen
Main view
Leave and payroll tracker detail screen
Detail
Leave and payroll tracker report screen
Report

Let's connect

Want something like this for your business?

Book a free 30-minute call on Google Meet, or reach me directly.