The Opening Balance page lets authorized users add an employee’s existing leave, overtime, and lieu hours from before they started using Office-X. This helps keep their balances accurate by adding their previous records instead of starting from zero. You can open it from the Employees page by clicking Opening Balance beside Add Employee.
Who Can Use This Feature #
Subscriber Admin can always access the Opening Balance page, without needing any specific permission. Employees can access it only if they hold the permission below.
Permission Behavior
This is controlled from: Admin → Permission → Employee → Manage Opening Balance (For All)
- Manage Opening Balance (For All)
Required action: Update
Lets you view and set opening balance values for any employee.
Without this permission (and without being the Subscriber Admin), the Opening Balance button doesn’t appear on the Employees page, and opening the page directly shows Access Denied. This permission can be assigned directly to an employee, or to an entire team at once. See the Permissions Management guide for how to assign permissions.
Overview #
The Opening Balance feature is mainly used for companies that already have employees with previous leave usage, overtime, or lieu records before using Office-X.
When employees are added or migrated into the system, their leave entitlement may already be partially used. Some employees may also have existing overtime or lieu hours that need to be recorded. This page is one table listing your employees, where you can search, sort, and page through them and set these opening values inline, cell by cell.
Each value you save here becomes the employee’s opening balance and cannot be edited later. This helps keep leave and payroll records accurate.
If you see N/A in any field, it means that option is not enabled for that employee. To use it, go to Employee → Edit and enable the required option, such as Night Premium, Daily OT, or Weekly OT etc. Once enabled, the field will become available here, and you can enter the opening hours for that employee. These settings can be different for each employee.
When to Use This Feature #
Use Opening Balance when:
- An existing employee has already used paid leave before being added to the system.
- An existing employee has already used unpaid leave before being added to the system.
- An employee has existing overtime or lieu hours that need to be recorded.
- A company is migrating employee balance data from a previous system or manual records.
- HR needs to record historical leave usage for accurate leave balance calculation.
- HR needs to record opening overtime or lieu hours.
- Payroll calculations need correct leave, overtime, or lieu history.
- The organization wants to start employee leave tracking with accurate opening balances.
The Table: Search, Sort, and Columns
You can search employees by ID, Name, or Email, sort the list by name, and page through it (10/20/30 rows per page).
Every non-Lieu leave type your company has configured under Admin → Leave Type gets its own column, shown for every employee row. If a particular employee isn’t actually assigned that leave type, their cell for it simply shows N/A instead of an editable field — the columns themselves aren’t filtered per employee, only the ability to edit each one is.
Lieu Leave doesn’t share a column with the other leave types — it gets its own dedicated Lieu Hours column, described separately below.
What Can Be Updated #
For each leave type column, you can set:
- Used Paid
- Used Unpaid
Read-only, never editable here:
- Earned
- Already-adjusted values (once locked, see below)
- N/A cells for leave types, overtime categories, or lieu hours that don’t apply to that employee
Good to know: “Earned” here works exactly like the Earned figure on the employee’s own Leave Quota tab — it’s not the employee’s full yearly entitlement, it’s prorated based on how long they’ve actually been with the company (Entitled ÷ 365 × days since joining). It keeps growing day by day even as you’re using this page, so don’t expect it to equal the full yearly number unless the employee has been with the company a full year already.
Example
Say an employee is entitled to 12 days of Casual Leave per year, joined 6 months ago, and had already used 4 days as paid leave before being added to Office-X. Enter 4 days in the Used Paid field for that leave type. After saving:
- Earned Casual Leave (prorated for 6 months): roughly 6 days
- Used Paid Casual Leave: 4 days
- Remaining Casual Leave right now: roughly 2 days
As more time passes, Earned keeps growing toward the full 12 days, so the remaining balance grows too — the 4 days you entered stays fixed as a permanent starting point.
Overtime and Lieu Hours #
Unlike the leave-type columns, overtime doesn’t have one single “OT Hours” field — it’s broken down into up to 20 separate overtime columns, one for each category your company has enabled under Business → Payroll Configuration:
- Night Premium
- Daily OT
- Daily OT (Night)
- D/T2 OT (Daily Tier 2 / Double-Time Overtime)
- D/T2 OT (Night)
- Weekly OT
- Weekly OT (Night)
- Rest Day Premium
- Rest Day (Night)
- Rest Day OT
- Rest Day OT (Night)
- Rest Day D/T2 OT
- Rest Day D/T2 OT (Night)
- Holiday Premium
- Holiday (Night)
- Holiday OT
- Holiday OT (Night)
- Holiday D/T2 OT
- Holiday D/T2 OT (Night)
- Monthly Excess OT
Each of these 20 overtime types has its own column. They are only available for employees who are Eligible for Overtime and have that overtime type enabled. Otherwise, the column shows N/A. Lieu Hours is separate again, shown only for employees marked Eligible for Lieu Leave.
Good to know — Overtime and Lieu Hours work differently:
- Overtime: Enter the overtime hours the employee had before they started using Office-X. These hours are added to any overtime they earn later through attendance.
- Lieu Hours: Enter the employee’s starting Lieu balance from before they started using Office-X.
Example: If an employee had 10 hours of Daily OT before joining Office-X, enter 10 in the Daily OT column, as long as Daily OT is enabled for that employee.
One-Time Edit Rule #
Opening Balance adjustment is a one-time action, enforced separately for every individual value:
- Each employee
- Each leave type’s Used Paid
- Each leave type’s Used Unpaid
- Lieu Hours
- Each individual overtime category (Daily Overtime, Weekly Overtime, Night Premium, and so on) — locking one category doesn’t lock the others
Before you confirm a save, Office-X shows a warning: “Are you sure you want to update this to [value]? You can only edit this value one time. Once updated, it cannot be edited again.” Once you save:
- That specific value becomes read-only.
- The edit/save/cancel icons disappear for it.
- It stays locked after a page refresh, and after logging out and back in.
- Trying to set it again is rejected on the server with a message like “Paid leave balance has already been adjusted and cannot be modified again” — this is enforced by Office-X itself, not just hidden in the interface, so it can’t be bypassed.
Good to know: If you remove a leave type that already has an opening balance, that opening balance will also be removed when you save the updated leave entitlements. It cannot be recovered afterward, so make sure to check the opening balance before removing a leave type.
How This Affects Leave Balance and Payroll #
Entering Used Paid or Used Unpaid leave reduces the employee’s remaining leave balance immediately. These values are added to the employee’s actual leave balance, just like an approved leave request, and are shown in the Leave Quota tab.
Office-X also checks the opening balance against the leave the employee would have earned by their first payroll (if supported). If the Used Paid leave is more than their earned leave, the extra amount is deducted from their first payroll as Opening Balance Deficit. This deduction happens only on the first payroll and will not be repeated in later payrolls.
Key Features #
- Record opening paid leave usage for existing or migrated employees.
- Record opening unpaid leave usage for existing or migrated employees.
- Record opening overtime hours per overtime category, and opening Lieu hours, for eligible employees.
- Display leave types dynamically from Admin → Leave Type — not hardcoded to specific leave types like Casual or Sick Leave.
- Keep Earned leave values permanently read-only.
- Show N/A wherever a leave type, overtime category, or Lieu isn’t applicable to that employee.
- Allow every eligible value to be updated only once, enforced by the server.
- Support employee search by ID, name, and email, plus sorting and pagination.
- Feed directly into leave balance display and first-payroll calculations.
- Restrict access to the Subscriber Admin and authorized employees only.
Summary #
The Opening Balance feature provides a controlled way to record employees’ starting leave, overtime, and lieu balances. It is especially useful when a company starts using Office-X with existing employees or migrates historical employee data from another system. Every value — each leave type’s Used Paid and Used Unpaid, Lieu Hours, and each individual overtime category — can be set exactly once, enforced by Office-X itself, and feeds directly into the employee’s real leave balance and their first payroll calculation.
