Back

Payroll Sheet: A Practical Guide to Every Action, from Viewing to Saving and Exporting

Payroll Sheet is a single screen that shows employee payslips in a table: each employee in a row and each salary component in a column. You review and edit values directly, as in a spreadsheet, and net pay and totals are recalculated instantly. This tutorial covers the full workflow on the payroll sheet: opening it, reading it, filtering, editing values and saving or discarding them, adding a salary component to multiple employees, deleting payslips, and exporting.

Before you start

  • A pay run with employee payslips.
  • The View Pay Run permission to open the sheet.
  • The Edit Payslips permission to edit values and add salary components, or Edit His Department Payslips to edit payslips of your department’s employees only.
  • The Delete Payslips permission to delete payslips.

Tutorial example: A sheet with two payslips: the payslip of Documentation Team with the Generated status (Basic 8,000), and the payslip of Technical Docs with the Approved status (Basic 3,000).

Open the Payroll Sheet

From the Payslips list

  1. Go to Payslips, then click Payroll Sheet; the sheet shows the payslips of all pay runs.
Opening the payroll sheet from the Payslips page

From the Pay Run page

  1. Open the pay run you want, and click Payroll Sheet; the sheet shows only this pay run’s payslips.
Opening the payroll sheet from a pay run page

Note: The Approve All button on the pay run page approves all its payslips at once. Finish reviewing and editing values in the sheet before approving, because an approved payslip can’t be edited from the sheet.

Read the sheet

  1. At the top of the sheet, the number of payslips is shown by status: Generated, Approved, and Paid, next to the date and time it was Last saved.
  2. From the top buttons: View Payslips to return to the payslips list, Export, and Save, which becomes available when there are changes.
Payroll sheet header with status counts, last save, and buttons
  1. In the toolbar: Filters, Add Salary Component, Columns, and the Full Screen button.
  2. The table columns are divided into groups: Code and Employee, then Employee Information, then Earning (such as Basic, Transportation Allowance, and Housing Allowance) and deductions if any, then Net Pay, then Payment Information (Payment Status and Pay Date). A Total row appears at the bottom of the table with the number of payslips and the sum of each column.
Payroll sheet toolbar, column groups, and totals row

Note: The — sign in a salary component cell means the component doesn’t exist in this employee’s payslip, while the value 0 means the component exists in the payslip and its value is zero.

Filter the sheet and customize columns

Filtering

  1. Click Filters, and select the field you want to filter by, or search for it in Search for filters. The available fields are: Employee, Pay Run, Designation, Department, Shift, Branch, Currency, Status, Period from / Period to, and Posting Date from / Posting Date to.
Choosing a filter field in the payroll sheet
  1. The field appears as a button next to Filters; select one or more values from it, and the sheet shows only the matching payslips.
  2. To remove all filters, click Clear All, or click the close icon next to a field to remove it alone.
Choosing filter values and Clear All in the payroll sheet

Example: To show only the payslips that can still be edited, select Status, then select Generated.

Showing and hiding columns

  1. Click Columns, and select the columns you want to show in the sheet, such as Department, Designation, Email, and Phone, among other employee data.
Showing and hiding columns in the payroll sheet

Column actions

  1. Hover over any column header, click the Actions button that appears above it, then select:
    • Add Salary Component Left or Add Salary Component Right: to add a new salary component column next to the column.
    • Paste: to paste copied values into the column.
    • Sort Ascending or Sort Descending: to sort the rows by the column values.
    • Move Column Left or Move Column Right: to change the column order.
Column actions menu in the payroll sheet

Edit values and save

  1. Click a salary component cell in the row of a Generated payslip, type the new value, then press Enter.
  2. The edited value appears in a different color with a button next to it to undo the change in this cell, and Net Pay and the Total row are recalculated instantly.
  3. The number of unsaved changes appears at the top of the sheet (such as 1 unsaved change) with the Discard Changes button.
  4. When you finish all edits, click Save.
Editing a cell in the payroll sheet

Result:

  • The new values are saved to the payslips, and the net pay of each payslip is updated.
  • The Last saved date and time at the top of the sheet are updated.
  1. To undo all edits before saving, click Discard Changes, then click Exit and Discard Changes to confirm, or Cancel to return to the sheet.

Warning: Discarded changes can’t be recovered, so save what you want to keep first.

  • Payslips with the Approved or Paid status are view-only, and their values can’t be edited from the sheet.
  • The Basic component can’t be removed from the payslip.
  • Loans and Commissions values are calculated from their sources and aren’t entered manually in the sheet.

Add a salary component to multiple employees

  1. Select employees using the checkbox next to each row, or select all from the checkbox at the top of the table. The number of selected rows appears at the bottom of the sheet.
Selecting rows in the payroll sheet
  1. Click Add Salary Component.
  2. Select the Component.
  3. In Value, select Component Value to use the value defined in the component, or Fixed Amount and enter the Amount.
  4. In Apply To, select Selected Employees Payslips (their names appear in Selected Employees), or All Employees Payslips.
  5. Click Save.
Add Salary Component window in the payroll sheet

Caution: If you select Selected Employees Payslips without selecting any employee, this message appears: No employees selected. Close this modal and check employees in the sheet first.

Result: The salary component column is added to the sheet with the selected value in the chosen employees’ payslips, and the net pay of each is recalculated.

Delete payslips

  1. To delete one payslip, click the Delete Payslip icon at the end of its row. The icon is available for Generated payslips only, and unavailable for approved or paid payslips.
  2. To delete multiple payslips, select them, then click Delete Selected at the bottom of the sheet.
Delete payslip icon and Delete Selected in the payroll sheet
  1. The Delete Payslip confirmation message appears; click Delete to confirm, or Cancel to go back.
Delete payslip confirmation message

Warning: Deletion is permanent and can’t be undone.

Export and full screen

  1. Click Export, and select the file format: Excel, CSV, or PDF. The sheet is exported with the current filters and visible columns.
Exporting the payroll sheet

Note: The export limit is 20,000 rows for Excel and CSV files, and 5,000 rows for PDF files. If the sheet exceeds this limit, use Filters to split it.

  1. To view the sheet in full screen, click the Full Screen button, and to return, click Exit Full Screen.
Full screen button in the payroll sheet

FAQs

Why can’t I edit the values of some payslips?

Because the payslip has the Approved or Paid status; only Generated payslips can be edited from the sheet. Also make sure you have the Edit Payslips permission.

What’s the difference between — and 0 in the sheet?

The — sign means the salary component doesn’t exist in the employee’s payslip, while 0 means it exists and its value is zero.

I edited values and left the page. Were they saved?

No. Edits are saved only when you click Save. The number of unsaved changes appears at the top of the sheet until you save or discard them.

Can I view the sheet for one pay run only?

Yes. Open the sheet from the Payroll Sheet button on the pay run page, or filter the sheet by the Pay Run field.

Why is the delete icon unavailable for some payslips?

The icon is unavailable for approved or paid payslips; only Generated payslips can be deleted, with the Delete Payslips permission.