Skip to Content
ERPX Documentation — Your complete guide to the ERPX platform

Leave Reports

Go to: HR → Reports → Leaves

Two reports, and the distinction between them matters: Balance is the answer, Ledger is the working.

ReportWhat it shows
Leave LedgerEvery leave transaction, in date order, with a running balance
Leave BalanceCurrent entitlement and remaining days per employee

1. Leave Ledger

Go to: HR → Reports → Leaves → Leave Ledger

Every row that has ever moved an employee’s leave balance. This is the report to open for any balance dispute, because the balance itself is only a total of these rows.

Report columns

ColumnMeaning
Sr No.Row number
TransactionThe document that wrote the row. Opens the source
Transaction TypeWhich kind of event this was. See below
DateWhen it took effect
Leave TypeWhich entitlement moved
AllocatedDays granted by this row
UsedDays consumed by this row
ReversedDays returned by this row
BalanceRunning balance after the row

Transaction types

TypeWritten when
Leave AllocationAn allocation grants days, usually from an approved policy assignment
Leave Allocation ReversalAn allocation is cancelled or unapproved
Leave ApplicationA leave application is approved and consumes days
Leave Application ReversalAn approved application is cancelled and returns days
Attendance On LeaveAttendance marked On Leave consumes days directly
Attendance On Leave ReversalThat attendance row is corrected or removed
Leave AdjustmentA manual correction

Notice that leave can be consumed from two directions: a Leave Application or an attendance record marked On Leave. When a balance drops with no application to explain it, look for the attendance row.

Filters: employees, departments, designations, leave types, transaction types, document number, and allocation status. Select Generate Leave Ledger to run it.

Settling a balance dispute

  1. Run the ledger for the employee and leave type. Do not filter by date yet.
  2. Read from the top: the first Leave Allocation rows are the entitlement.
  3. Follow the Balance column down until it diverges from what the employee expects.
  4. Open the Transaction on that row to see the document that wrote it.
  5. Correct the document, not the balance. The ledger and balance recompute from it.

There is no editable balance field anywhere in HR. If a balance is wrong, a document is wrong. See Leave → Leave Allocation for the write path.


2. Leave Balance

Go to: HR → Reports → Leaves → Leave Balance

The period-end summary: one row per employee, with entitlement and what remains.

Report columns

ColumnMeaning
Sr No. / CodeRow number and employee code
EmployeeName
Department / DesignationPlacement
Total AllocatedDays granted across leave types
Total AvailableDays remaining

The export carries a Grand Total row across the filtered set.

Filters: employees, departments, designations, and allocation status. Select Generate Leave Balance to run it.

Employees show as Not Allocated when no leave allocation exists for them. That is a setup gap, not a zero balance. They need a Leave Policy Assignment approved before leave will work for them at all.

Use it for: period-end entitlement summaries, provisioning leave liability to Finance, and finding employees who were never allocated leave.