> For the complete documentation index, see [llms.txt](https://help.allwage.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.allwage.com/modules/payroll/reports.md).

# Reports

Payroll reports: pay run template summary, consolidated employee report, SARS code summary, leave liability, UI-19, Certificate of Service, loans, OID, terminations, ETI and Skills & Equity.

Navigating payroll complexities is streamlined with our payroll reports section. This tool allows you to export detailed summaries of payroll-related information, providing insights into various payroll elements to enhance transparency and aid in compliance. We have Company reports and Pay run reports.

## Company reports

The company reports section now has a new home and that is located in the Payroll, Reports menu:

<figure><img src="https://4190935239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQs9GZ7QOfs5wHesuQLQh%2Fuploads%2FXBMJ5eMVTXt2SNpA5xnw%2Fimage.png?alt=media&amp;token=be5d32f3-cbb6-486b-96cd-b3929ec18165" alt=""><figcaption></figcaption></figure>

It can also still be found in the old Export side panel in Payroll, Pay run:

<figure><img src="https://4190935239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQs9GZ7QOfs5wHesuQLQh%2Fuploads%2Fl90gHYf8EG6dhfHs4ZZn%2Fimage.png?alt=media&amp;token=e481d92e-5b77-46f6-b1b2-e7dc76b50e3b" alt=""><figcaption></figcaption></figure>

Payroll > Reports works per company: choose the company first, and each report covers that company only, except the [Leave Liability](#leave-liability) report.

## Pay Run Template Summary

Get a monthly breakdown of each pay run template per employee. This report includes only those months where all pay runs have been finalised.<br>

1. Navigate to Payroll, Reports.
2. Click on Pay run Template Summary.
3. Select the company from the drop down.
4. Select the starting month you want to view
5. Select the end month you want to view\
   (The report will show you all the months between the start and the end date)
6. Click on the + next to Select Employees and select the employees\
   (Note: you can select all the employees in the list and it will only show you the employees linked to the company you filtered for in step 3).
7. Click on the + in the Include pay run templates section and select the templates you want to view
8. In the Additional info section you can tick if any of these applies to what you want to view:\
   **Show Template Quantities**: Opt to only display the quantities for all pay run templates.\
   **Only Include Taxable Templates**: Filter to include only those templates linked to taxable SARS codes.\
   **Include unprocessed pay runs**: If a month is selected with unprocessed pay runs, those values will also be included in the report.
9. Click on Create

<figure><img src="https://4190935239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQs9GZ7QOfs5wHesuQLQh%2Fuploads%2FH62H4giLIPkFRdIhx6cg%2Fimage.png?alt=media&amp;token=a0b18afc-b1ba-4405-9075-7404136a04ca" alt=""><figcaption><p>Monthly breakdown per employee preview</p></figcaption></figure>

## **Consolidated Employee Report**

Generate a monthly breakdown of each pay run template per employee and a summarised view of all the pay run templates. The report covers one company: to see several companies, create a report for each.

1. Navigate to Payroll, Reports.
2. Click on Consolidated Employee Report.
3. Select the company from the drop down.
4. Select the starting month you want to view
5. Select the end month you want to view\
   (The report will show you all the months between the start and the end date)
6. Tick **Include unprocessed pay runs** if the report must include pay runs that aren't finalised yet. If you leave it unticked, only finalised pay runs are included.
7. Click on the + next to Select Employees and select the employees\
   (***Note:** you can select all the employees in the list and it will only show you the employees linked to the company you filtered for in step 3*). To select only the employees on one pay run, use the **Pay Run** filter in the **Add employees** panel.
8. Click on Create

Each pay run counts in the month its end date falls in. The workbook has these sheets:

* **Employee Breakdown**: the amount of each pay run template per employee per month, with totals per category and **Gross** and **Nett** rows.
* **Consolidated Summary**: the same templates totalled for all the selected employees.
* **Employee Quantities**: the quantity of each template, such as hours or units, per employee per month.
* **Employee Avg Rates**: the average rate of each template per employee per month: the month's amount divided by its quantity, so a month with two pay runs at different rates shows the weighted average. For a fixed amount with no quantity, it shows the rate.
* **Employee Tax Code Summary**: the amounts per SARS code per employee per month.

**Reconciling a month's EMP201.** The EMP201 declares the pay runs that end in the month, so this is the report to reconcile it. Select the same month as the start and end month: the report adds up every pay run that ends in that month, for example both fortnightly pay runs, and you compare its PAYE, UIF and SDL totals with the EMP201.

<figure><img src="https://4190935239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQs9GZ7QOfs5wHesuQLQh%2Fuploads%2FJPRn5Kx2MLff8BkFwIop%2FScreenshot%202024-08-29%20at%2012.00.02.png?alt=media&amp;token=f9497a0d-60e4-4289-93a4-dcf4ee86da42" alt=""><figcaption><p>Monthly breakdown per employee</p></figcaption></figure>

{% hint style="info" %}
**PAYE per employee per month.** This report shows the PAYE deducted from each employee in each month. AllWage never deducts a negative PAYE amount: if a pay run's PAYE calculation comes out below zero, the PAYE deduction for that pay run is R0. So the report doesn't show negative PAYE amounts (PAYE credits). To see how a pay run's PAYE was worked out, see [PAYE Annual Method](https://help.allwage.com/modules/payroll/filing/statutory-deductions.md#paye-annual-method).
{% endhint %}

View our course video here:

{% embed url="<https://youtu.be/nOpPjQGt_6g>" %}

## SARS Code Summary

This report provides a monthly breakdown of each SARS code per employee, again only including months with all pay runs finalised. Use this report when reconciling [bi-annual](https://help.allwage.com/modules/payroll/filing/bi-annual-filing.md) reconciliations.

{% hint style="info" %}
Only finalised pay runs are included in this report.
{% endhint %}

1. Navigate to Payroll, Reports.
2. Click on SARS Code summary.
3. Select the company from the drop down.
4. Select the starting month you want to view
5. Select the end month you want to view\
   (The report will show you all the months between the start and the end date)
6. Click on the + next to Select Employees and select the employees\
   (***Note:** you can select all the employees in the list and it will only show you the employees linked to the company you filtered for in step 3*).
7. Click on Create

<figure><img src="https://4190935239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQs9GZ7QOfs5wHesuQLQh%2Fuploads%2FjEPuEGJmyjpii57L2HLD%2Fimage.png?alt=media&amp;token=0a55ff05-6557-4b4e-97dd-bc23c449af8e" alt=""><figcaption><p>SARS code summary</p></figcaption></figure>

## Leave Liability

1. Navigate to Payroll, Reports.
2. Click on Leave Liability.
3. Click on the + next to Select Employees and select the employees.
4. Click on Create.

* **Which employees are included.** The Leave Liability report has no company drop-down. It includes the current employees you selected, or, if you select none, all current employees you have access to, across all the companies in your profile. The **Current Leave Balances** sheet has a column with each employee's company, so filter on it in Excel to see one company.
* **Large selections take long.** AllWage builds each employee's full leave history for the report, so a report for many employees can take a long time and may seem to hang. If it doesn't finish, select smaller groups of employees and create a report for each.

View our course video here:

{% embed url="<https://youtu.be/YhdLJ12MHcE>" %}

The report allows you to filter specific employees, so only the selected employees will be included in the Excel export.

The report (**leave-liability.xlsx**) has these sheets:

**Current Leave Balances**: one row per employee with their latest closing balances, in days, for **Annual**, **Sick** and **Family Responsibility** leave.

* **Closing Balance Date** is the date the balances apply to. A highlighted date means the balance is from the current pay run, which isn't finalised yet, so it can still change.
* **Leave Config Name** is the employee's leave policy, and **Pay Run Template** their pay run.
* **Annual Leave Daily Payout Rate** is the rate a day of annual leave would be paid out at. It comes from the system rate linked under **Annual leave payout** on the leave policy, or from the employee's own override of that rate. If the policy works in hours, it is that rate times the policy's average working hours per day.
* **Annual Leave Payout Liability** is the rand value of the employee's annual leave balance: the daily payout rate times the annual leave balance. Use it to see what an employee's annual leave would cost to pay out, for example if they resign.
* Both payout columns are empty if the leave policy has no payout rate linked. Only annual leave has payout columns.

**Annual Leave History**, **Sick Leave History** and **Family Responsibility Leave History**: one row per pay run (and take-on balance) for each employee, showing how the balance moved:

* **Opening Balance**, **Accrued**, **Leave Taken**, **Adjustment**, **Payout** (annual leave only) and **Closing Balance**;
* days that expired or were lost from carry-over (**Expired Days**, **Expired Carry Over Days**);
* the **Leave Cycle Start Date**, the pay run's dates, and whether it is **Finalised**.

**Leave Expiry Details**: for leave types with an expiry rule, an estimate of what happens at the end of the current leave cycle: **Est. Days to Expire at Cycle End**, **Est. Days to Carry Forward** and when the carried-over days expire. The estimate uses the current balance only. It doesn't add leave the employee will still accrue or take before the cycle ends.

Other leave types, such as maternity or unpaid leave, have no balances, so they aren't in this report.

To run the report for one employee, use **Export report** on that employee's leave page.

## UI-19

{% hint style="danger" %}
The Employer's Declaration of employment for one or more employees. Available **only** for resigned employees. For information on how to resign an employee, please refer to our [Employee Resignation](https://help.allwage.com/fundamentals/users-and-employees/employee-resignation.md) page.
{% endhint %}

1. Navigate to Payroll, Reports.
2. Click on UI-19.
3. Click on the Select a company drop down and select the company that the employee(s) was in.
4. Click on the + next to Select Employees and select the employees\
   (***Note:** you can select all the employees in the list and it will only show you the employees linked to the company you filtered for in step 3*).

<figure><img src="https://4190935239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQs9GZ7QOfs5wHesuQLQh%2Fuploads%2FTpYVfZ7fWUVKDY66Eran%2Fimage.png?alt=media&amp;token=9396a76d-5f63-48db-bf09-aaf6a7d259c7" alt=""><figcaption></figcaption></figure>

You can also download one employee's UI-19: on their **Active periods**, click **Termination Docs** on the period that ended, tick **UI-19** and click **Download**.

**What the UI-19 covers.** A UI-19 covers one period of employment at one company: the employee's ended active period at the company you select. The commencement date is that active period's **Start date**. The termination date is the date you captured when you resigned the employee. Employment at your other companies, or with other employers, isn't included.

The remuneration and hours on the UI-19 are for **one month only**: the month of the employee's final UIF declaration. They are not totals for the whole employment. See [Which month the UI-19 reports](#which-month-the-ui-19-reports). If that month shows R0, see [If the UI-19 shows R0 and 0 hours](#if-the-ui-19-shows-r0-and-0-hours).

UI-19s from before you used AllWage can't be imported. To keep them with the employee's records, upload them to the employee's **Vault**: see [How to Upload Documents](https://help.allwage.com/modules/document-management/getting-started.md#how-to-upload-documents).

### Which month the UI-19 reports

The UI-19 reports one month: the month in which the employee's last pay run ends. AllWage declares each pay run to UIF in the month the pay run ends, so this is the employee's final UIF declaration month.

* AllWage looks at every pay run the employee is on that overlaps their employment. A final pay run that paid nothing still counts.
* The month is never earlier than the month of the termination date.
* If the final pay run ends in the month after the termination date, the UI-19 reports that later month. The termination date on the form stays the date you captured.
* Pay runs that aren't finalised yet are included. AllWage builds the UI-19 from the current data each time you download it.

For that month only, the UI-19 shows:

* **Remuneration**: the employee's earnings subject to UIF from the pay runs that end in that month.
* **Hours**: the budget hours of those pay runs, counted only for days on or before the termination date. A pay run with no earnings subject to UIF adds no hours. See [Where the hours come from](#where-the-hours-come-from-ui-19-and-certificate-of-service).

**Example: pay runs from the 24th to the 23rd.** The values are an example. An employee works Monday to Friday with 8 budget hours a day and no shift on Saturday or Sunday. Their termination date is 30 September 2026.

* **If the employee is on the 24 September to 23 October 2026 pay run**, that is their last pay run. It ends in October, so the UI-19 reports October 2026. The hours cover only 24 to 30 September: 5 required working days (Thursday 24 September, Heritage Day, plus Friday 25, Monday 28, Tuesday 29 and Wednesday 30 September) × 8 hours = 40 hours. Days after 30 September don't count.
* **If the employee isn't on the 24 September to 23 October 2026 pay run**, their last pay run is 24 August to 23 September 2026. It ends in September, so the UI-19 reports September 2026: that pay run's remuneration, and 23 required working days × 8 hours = 184 hours.

### If the UI-19 shows R0 and 0 hours

If no pay run ending in the UI-19 month has earnings subject to UIF, the UI-19 shows R0 remuneration and 0 hours. The contributor column shows **NO** and the non-contributor reason is **6** (no income paid for the payroll period). If another pay run ending in that month paid the employee, as can happen with weekly pay runs, the UI-19 shows that pay and those hours, even if the final pay run paid nothing.

This happens in two ways:

* **The final pay run paid nothing.** The final pay run sets the UI-19 month even when it paid nothing. This usually means the termination date is wrong: the employee is on a pay run for a period they didn't work. Follow the steps below.
* **None of the employee's pay runs ends in the termination month.** For example, the termination date is 5 October 2026 and the pay run covering it doesn't exist yet. The UI-19 reports October 2026 with nothing in it. Download it again once that pay run exists and has the employee's final pay.

1. Open the employee's **Active periods** and check the termination date on the period that ended. Compare it with the last day the employee actually worked.
2. Check the employee's last pay run and whether it paid them anything.
3. If the termination date is too late, and the resignation is in the current pay run that isn't finalised yet, [cancel the resignation](https://help.allwage.com/fundamentals/users-and-employees/employee-resignation.md#steps-to-cancel-a-resignation). Then [resign the employee](https://help.allwage.com/fundamentals/users-and-employees/employee-resignation.md#steps-to-terminate-employees) again with the correct date. If the correct date is before the current pay run's start date, [remove the employee from the pay run](https://help.allwage.com/modules/payroll/recurring-pay-runs/current-pay-run.md#remove-one-or-more-employees) first.
4. Download the UI-19 again. If you removed the employee from the pay run, it now reports the month of their new last pay run. If the correct date is still inside the same pay run, the month doesn't change, and the UI-19 shows R0 until that pay run has earnings subject to UIF.

If the pay run with the resignation is already finalised, contact [support](https://help.allwage.com/fundamentals/support-channels.md). Send the employee number, the termination date on the active period and the last day the employee worked.

If the employee really was paid nothing in their final pay period, the R0 UI-19 matches their pay.

## Certificate of Service

{% hint style="danger" %}
The Employer's Declaration of employment for one or more employees. Available **only** for resigned employees. For information on how to resign an employee, please refer to our [Employee Resignation](https://help.allwage.com/fundamentals/users-and-employees/employee-resignation.md) page.
{% endhint %}

1. Navigate to Payroll, Reports.
2. Click on Certificate of Service.
3. Click on the Select a company drop down and select the company that the employee(s) was in.
4. Click on the + next to Select Employees and select the employees\
   (***Note:** you can select all the employees in the list and it will only show you the employees linked to the company you filtered for in step 3*).

<figure><img src="https://4190935239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQs9GZ7QOfs5wHesuQLQh%2Fuploads%2Fv5Buowa6IyNxMXtMyXol%2Fimage.png?alt=media&amp;token=e362caa5-1de5-4451-9d0a-e667051e0568" alt=""><figcaption></figcaption></figure>

**What the Certificate of Service shows.** The Certificate of Service lists the employee's employment month by month. Each row shows the month's hours, gross wage and 1% employee UIF contribution, with totals at the bottom. A month holds the pay runs that end in it, not the calendar month. The field **1.5 Average Hours/Month** isn't an average: it shows the hours of the employee's final month, the same number as the hours on the UI-19. See [Where the hours come from](#where-the-hours-come-from-ui-19-and-certificate-of-service).

### Where the hours come from (UI-19 & Certificate of Service)

The UI-19 and the Certificate of Service show the hours the employee was expected to work, not the hours they clocked. The hours come from the **budget hours** (required working hours) on the employee's **clock template**. This works for employees who clock in and out, and for employees who don't clock, such as salaried staff.

* **UI-19:** the hours of one month only, the employee's final UIF declaration month. See [Which month the UI-19 reports](#which-month-the-ui-19-reports).
* **Certificate of Service:** the hours of each month, in its own row. **1.5 Average Hours/Month** shows the final month's hours, the same as the UI-19.

**How the hours are added up**

AllWage counts hours per pay run. Each pay run belongs to the month in which it ends. For each month, AllWage adds up the pay runs that end in that month:

1. For each pay run, it takes the days that fall inside both the pay run and the employee's employment, from their start date to their termination date.
2. For each of those days that is a required working day on the clock template, it adds that day's budget hours.
3. A pay run with no earnings subject to UIF adds no hours, even if the employee is on it.
4. It rounds the total to the nearest whole hour.

A required working day is a day with a shift on the clock template that isn't marked optional. Days marked optional, and days without a shift, add nothing. **Public holidays count as required working days.** A public holiday adds its normal budget hours unless the clock template marks that day of the week as optional.

**Example: an employee who left part-way through a pay run**

The values are an example. Pay runs go from the 24th to the 23rd. The employee works Monday to Friday with 8 budget hours a day and no shift on Saturday or Sunday. Their termination date is 30 September 2026, and they are on the 24 September to 23 October 2026 pay run.

AllWage doesn't take the whole pay run's budget hours and reduce them. It counts only the required working days from 24 to 30 September: Thursday 24 September (Heritage Day, a public holiday), Friday 25, Monday 28, Tuesday 29 and Wednesday 30 September. That is 5 days × 8 hours = 40 hours.

* The pay run ends in October, so on the Certificate of Service the **October 2026** row shows 40 hours, and **1.5 Average Hours/Month** shows 40.
* The **September 2026** row holds the 24 August to 23 September 2026 pay run: 23 required working days × 8 hours = 184 hours.
* The UI-19 reports October 2026 with 40 hours.

#### If the hours don't look right

If the hours on a UI-19 or Certificate of Service are higher or lower than you expect, check these first:

* **The UI-19 shows one month only.** It isn't a total for the whole employment. See [Which month the UI-19 reports](#which-month-the-ui-19-reports).
* **0 hours on the UI-19** usually means no pay run ending in the UI-19 month has earnings subject to UIF. See [If the UI-19 shows R0 and 0 hours](#if-the-ui-19-shows-r0-and-0-hours).
* **A month holds the pay runs that end in it.** With pay runs from the 24th to the 23rd, the October row covers 24 September to 23 October.

Otherwise, the cause is almost always in the employee's **clock template**.

The most common reason for **inflated hours** is a clock template where **every day of the week is marked as a required working day**. When that happens, the budget hours count every day, including Saturdays and Sundays, which pushes the total far higher than the employee actually worked.

To check and fix this:

1. Open the affected employee on the Employee Overview Report and look at their **clock template**.
2. Review how the **budget hours** are set up for each period — in particular, which days are marked as required working days.
3. Adjust the required working days so they reflect the employee's real schedule (for example, weekdays only).

{% hint style="info" %}
You can confirm an employee's expected budget hours on the **Employee Overview report**. If the budget hours there look wrong, the UI-19 and Certificate of Service will be wrong too — fix the clock template and they will all line up.
{% endhint %}

## Loans & Savings History

1. Navigate to Payroll, Reports.
2. Click on Loans & Savings History.
3. Click on the Select a company drop down and select the company that the employee(s) was in.
4. Click on the + next to Select Employees and select the employees\
   (***Note:** you can select all the employees in the list and it will only show you the employees linked to the company you filtered for in step 3*).

<figure><img src="https://4190935239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQs9GZ7QOfs5wHesuQLQh%2Fuploads%2F8og2yMtGUT7yDIbwfeej%2Fimage.png?alt=media&amp;token=6354eab0-a07e-4a3d-a7f7-301670689375" alt=""><figcaption><p>Loan and Savings history</p></figcaption></figure>

The Loans and Savings History Report provides a comprehensive view of each employee's financial transactions related to loans and savings within your organisation. Here’s what each entry in the report represents:

* **Employee Details**: Each row corresponds to a specific employee, identified by their employee number and full name.
* **Pay Run**: Indicates the pay run associated with the transaction. This helps track when the transaction occurred within the payroll cycle.
* **Take-On Balance**: Shows if an opening balance was recorded for the loan or saving at the start of the period. This is critical for tracking the initial amount before any transactions.
* **Opening and Closing Balances**: Reflects the starting and ending balances for the period, providing insight into the net changes due to transactions during that time.
* **Pay out**: Displays any pay outs from the savings or loan repayments made during the pay run.
* **Loan / Saving Deduction**: Shows deductions related to loan or saving repayments within the pay run.
* **Modified**: Indicates if any manual adjustments were made to the transaction. This is important for audit and reconciliation purposes.

This report is essential for managing and reviewing employee savings and loan accounts, ensuring transparency and accuracy in financial documentation.

## OID Return of Earnings

An OID report provides detailed information on the compensation and earnings of employees, specifically for the purposes of Occupational Injuries and Diseases (OID) reporting to relevant authorities.

{% hint style="danger" %}
The OID Config needs to be configured in each pay run before generating this report. Please refer to [OID Config Setup](https://help.allwage.com/modules/payroll/filing/oid-return-of-earnings.md) to assist with this. This report should only be printed after you have rolled into the March period.
{% endhint %}

1. Navigate to Payroll, Reports.
2. Click on OID Report.
3. Click on the Select a company drop down and select the company you want to generate the file for.
4. Enter the start date as March of the previous financial year.
5. Enter the Percentage increase (the average percentage of the increases of your employees salaries in the new financial year).
6. Click on Create.

<figure><img src="https://4190935239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQs9GZ7QOfs5wHesuQLQh%2Fuploads%2FrKD4nrwmukmCkwdcL1em%2Fimage.png?alt=media&amp;token=08110216-6327-441a-97be-295513a28674" alt=""><figcaption></figcaption></figure>

## Termination Report

This report generates a list of all employees who have been terminated, including their start and end dates, UIF status codes, and custom termination reasons.

1. Navigate to Payroll, Reports.
2. Click on Termination report.
3. Click on the Select a company drop down and select the company you want to view
4. You can either filter by date, or by employees (just tick the one you prefer):
   1. Date will allow you to enter a start date and an end date and it will show you the days accrued and taken during this period for all employees and all leave types:\
      ![](https://4190935239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQs9GZ7QOfs5wHesuQLQh%2Fuploads%2F1mDm9rwqHtMtqpDv3943%2Fimage.png?alt=media\&token=1570f78c-f3e9-433c-b395-7a3a873ae083)
   2. Employees will allow you to select specific or all employees that you want to view:\
      ![](https://4190935239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQs9GZ7QOfs5wHesuQLQh%2Fuploads%2FOXB1JYOS0DZGw9AJEYop%2Fimage.png?alt=media\&token=439e6239-19eb-4553-89d5-36bacf8ba7c1)
5. Click on create.

## Employment Tax Incentive (ETI) Breakdown

1. Navigate to Payroll, Reports.
2. Click on Employment Tax Incentive (ETI) Breakdown.
3. Select the company from the drop down.
4. Select the starting month you want to view
5. Select the end month you want to view\
   (The report will show you all the months between the start and the end date)
6. Click on the + next to Select Employees and select the employees\
   (***Note:** you can select all the employees in the list and it will only show you the employees linked to the company you filtered for in step 3*).
7. Click on Create

## Skills & Equity

You can generate the EEA2 and EEA4 reports directly from the system. This is a three step process, you will firstly need to ensure that the Race and Gender for each employee is completed. Secondly you will need to download the template so you can update the employee details that is needed for the report. You will then be able to generate the report. Please see below steps:

1. [Ensure the Race and Gender has been completed for all employees.](#make-sure-the-race-and-gender-is-completed-for-all-employees)
2. [Download and complete the Skills & Equity template.](#download-and-complete-the-skills-and-equity-template)
3. [Import the Template and generate the reports.](#import-the-template-and-generate-the-reports)

#### Make sure the Race and Gender is completed for all employees.

These details can be done in bulk:

**Export the EPI sheet**

1. Navigate to Payroll, Employees.
2. Click on Export/Import on the top of the screen (more to the right).
3. Click on Export.
4. Select Export All Personal Info

This will download an Excel sheet.

**Edit the sheet**

1. Open up the Excel sheet.
2. Click on Enable editing.
3. Select the correct option from the drop down for the employees race.
4. Select the correct option from the drop down for the employees gender.\
   *Note: You can remove any employees or lines you don't want to edit.*
5. Save the excel sheet.

**Import the EPI sheet**

1. Navigate to Payroll, Employees.
2. Click on Export/Import on the top right hand side.
3. Click on Import.
4. Select Import Personal Information.
5. Click on Import.
6. Locate the Excel sheet and select it, then click on Open.
7. Click on Upload file.
8. Click on Next.
9. Click on Validate.
10. If there are any errors - please correct the errors first. If there are warnings, or no errors you can click on Imports with warnings or import.

#### Download and complete the Skills & Equity template

**Download the Template**

1. Navigate to Payroll, Reports.
2. Click on Skills & Equity
3. In the side panel that appears, click on the Select a company drop down and select the correct company.
4. Select the Start date for your Skills and Equity period.
5. Select the End date for your Skills and Equity period.
6. Click on Download template.

This will download an excel file to your preferred download destination.

**Edit the template**

1. Locate the Skills-equity-template-company\_name excel spread sheet from your downloads folder or preferred download destination and open it.
2. Click on Enable editing.
3. Check the **Employment Level** column and edit if needed.\
   *For each employee, please select their employment level by clicking on the cells drop down menu and selecting the correct employment level from the list.*
4. Check the **Was promoted** column and edit if needed.\
   *Each employee that was promoted during the skills and equity period needs to be changed from False to True, click on the drop down and select True. If the employee was not promoted you can leave it as false.*
5. Check the **Had Numeric Goal Training** column and edit if needed.\
   *Each employee that received numeric goal training during the skills and equity period needs to be changed from False to True, click on the drop down and select True. If the employee was not promoted you can leave it as false.*
6. Check the **Disabled** column and edit if needed.\
   *Each employee that is disabled during the skills and equity period needs to be changed from False to True, click on the drop down and select True. If the employee was not promoted you can leave it as false.*
7. Once each employee has been updated you can save the template.

#### Import the template and generate the reports

1. Navigate to Payroll, Reports.
2. Click on Skills & Equity
3. In the side panel that appears, click on the Select a company drop down and select the correct company.
4. Select the Start date for your Skills and Equity period.
5. Select the End date for your Skills and Equity period.
6. Click on the + next to Include pay run templates and select the relevant templates from the list and click on Done.\
   *NOTE: If you are unsure what needs to be included of excluded please refer to the* [*EEA4 specification document*](chrome-extension://efaidnbmnnnibpcajpcglclefindmkaj/https://labourguide.co.za/~documents/route%3A/download/2098)*.*
7. Click on Upload File.
8. Select the skills-equity-template-company\_name that you saved and click on Open.
9. Click on Create

The system will download a zip folder called equity-reports-Company\_Name. In the folder you will find both the EEA2 and the EEA4 reports.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://help.allwage.com/modules/payroll/reports.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
