Browse categories
Explore
Fiverr Pro
English
$
USD
I will reconcile employee leave balances and create an excel leave tracker
HR and Payroll Administration Specialist , Excel and Employee Data
Experienced HR & Payroll Administration professional with nearly 20 years of hands-on HR experience. I help businesses organise employee records, clean and reconcile Excel data, manage leave and payro...
About this Gig
I will reconcile your employee annual leave balances and organise the results in a clear Excel workbook.
With over 18 years of HR administration experience, I understand how opening balances, accruals and leave taken can become difficult to track.
Using your supplied records and leave rules, I will:
Calculate opening balance + accruals leave taken
Compare calculated balances with your recorded balances
Highlight discrepancies and missing information
Provide an editable Excel workbook with visible formulas
Explain the calculations and how to use the workbook
BASIC: Up to 5 employees, covering up to 12 months.
STANDARD: Up to 15 employees, covering up to 12 months, plus a reusable leave tracker.
PREMIUM: Up to 30 employees, covering up to 12 months, plus a reusable tracker and summary sheet.
Please provide opening balances, accrual rates, leave transactions and your companys leave rules. Use employee reference numbers where possible; ID numbers and banking details are unnecessary.
This service applies your supplied rules and does not include legal advice or payroll system updates. Revisions cover adjustments within the agreed scope.
Please message me before ordering if records are in
Platform:
Excel
•
Google Sheets
Development technology:
Excel
Expertise:
Formatting
•
Fixing
•
Formulas
•
Functions
•
Data validation
FAQ
What information do you need to reconcile leave?
Please provide opening leave balances and their dates, accrual rates, leave taken, the period to check, and your company’s leave rules. Include existing balances if you want me to compare them.
Can employees have different leave accrual rates?
Yes. Please supply the correct rate and applicable rules for each employee, including any changes during the period.
What will I receive?
All packages include an editable Excel reconciliation workbook and calculation notes. Standard adds a reusable leave tracker. Premium also includes a summary sheet.
Can you work with incomplete records?
Please message me before ordering. I can flag missing information, but accurate balances depend on complete records. I will not invent missing transactions.
What does a revision include?
A revision covers adjustments within the original scope using the records and rules supplied. Additional employees, periods or new records may require a custom offer.
