Filters and options in the Employee Ledger report
Complete reference of filters available to customize the Employee Ledger report.
Jul 11, 2026
| Filter / Option | Purpose | Example |
|---|---|---|
| Employee | Select one or more employees to display. Leave blank to show all. | Rashid, Ahmad, Zahra |
| Date Range | Set the start and end date for the ledger. | January 1, 2026 – December 31, 2026 |
| Department | Limit results to employees in a specific department or cost center. | Sales, Warehouse, Administration |
| Employee Status | Filter by active, inactive, or all employees. | Active only |
| Pay Frequency | Filter by payment cycle (monthly, bi-weekly, weekly). | Monthly |
| Currency | If your organization uses multiple currencies, select the currency for display. | AFN (Afghan Afghani) |
| Show Deductions | Toggle detailed breakdown of deductions (taxes, insurance, etc.) in each row. | On/Off |
| Show Cumulative YTD | Display year-to-date totals for gross pay in a separate column. | On/Off |
| Sort By | Reorder the ledger by employee name, date, or gross pay amount. | Employee Name (A–Z) |
Common filter combinations
- Annual review: Date Range = Jan 1 – Dec 31, 2026; Employee = [selected]; Show Cumulative YTD = On. Provides full-year compensation summary for one employee.
- Department payroll audit: Department = [selected]; Date Range = [full year or quarter]; Sort By = Employee Name. Shows all department members' pay history in one view.
- New hire verification: Employee = [new hire]; Date Range = [hire date onwards]; Show Deductions = On. Confirms the hire's pay has been processed correctly since day one.
- Year-end compliance: All employees; Date Range = Jan 1 – Dec 31; Show Deductions = On; Show Cumulative YTD = On. Supports year-end tax and benefits reporting.
Was this helpful?