In this article, you will learn:
How to export Holiday Balances Report
What information is contained within Holiday Balances Report
How to export Holiday Balances Report
Sign into bizimply.com
Click into 'Reports' tab from navigation bar
Go to Employee Reports > Holiday Balances
Choose Date Range, Locations, Employees
Select Type 'Accrued hours' or 'Standard Allowance of Annual Days'
Select format 'PDF' or 'CSV'
Click the blue 'Export' button
The report will be sent to the inbox of the email address you are signed into Bizimply with
The Holiday Balances Report is a valuable tool for tracking employee holiday entitlements, including accrued holidays, taken holidays, and closing balances. Understanding key columns, such as "Allowance," "Total Hours Taken," "Adjustments," and "Balance Available," allows users to analyze the report effectively. Balances are calculated using the formula: Balance Available = Opening Balance + Adjustments + Allowance - Total Hours Taken.
Please note: All employees are included in this report including those with holiday allowance of 0.
Accrued Hours
Employee name
Employee number
Location (location of shift)
Standard Hours in a Working Day
Approved Hours to Date
Hourly Rate (will state Salary for employees paid salary)
Accrual Method
Accrual %
Allowance
Adjustments
Total Hours Owed
Total Hours Taken
Balance to Date
Total Hours Booked
Balance Available
Allowance: The holiday entitlement accrued during the chosen date range.
Adjustments: Manual adjustments for corrections, prior year balances, or carryover settings.
Total Hours Taken: The sum of holiday hours used by the employee within the set date range.
Balance Available: The final available balance reflecting unused holiday hours calculated by the formula:
Balance Available = Opening Balance + Adjustments + Allowance - Total Hours Taken.
Sample Holiday Balances Report - Accrued Hours in CSV format
Standard Allowance of Annual Days
Employee name
Employee number
Location (location of shift)
Days Allowance
Days Taken
Days Owed
Adjustments
Total Days Owed
Upcoming Approved Days
Balance in Days
Allowance: The annual entitlement of holiday days.
Adjustments: Reflects manual changes such as carryover days or adjustments for corrections.
Days Taken: Total days of holiday taken by the employee.
Balance in Days: Closing balance representing the remaining holiday days available, calculated similarly to balances in "Accrued Hours".
Sample Holiday Balances Report - Standard Allowance of Annual Days in CSV format
Scenarios and Configurations
Locating Closing Balances for Each Employee
To locate an employee's closing holiday balance for a specific period, access the Holiday Balance Report for the required time frame. Review the "Balance Available" column, which reflects the closing balance accurately.
Effect of Carryover Settings
Disabling automatic carryover resets balances at the new period’s start. Manual adjustments may be necessary to include prior balances, and pre-booked leave exceeding entitlement leads to a negative balance.
Related Articles:
Best Practices
Customize Date Ranges: Align date ranges with fiscal or calendar timelines for accurate review.
Double-check Adjustments: Ensure manual inputs reflect accurate corrections or carryover adjustments.
Regular Reviews: Frequently monitor individual holiday balances to identify discrepancies early.