Create a Gross Earnings report

Create a Gross Earnings report

1. Select Reports on the side menu, click on the Custom Reports tab, and then select Pay Runs (under Payroll Reports).

2. Filter your report to the specific date range or pay period you would like to view, then press Submit.

3. Select Layout and choose the columns you want to see in your report. We recommend the following selections: Pay Run Number, Name, Employee Code, Dept Code, Dept Name, Type, Amount. Press OK to update your report.

4. Select Filter and choose the following selections:

  1. Filter Column: Type

  2. Comparison: Contains

  3. Value: Earning

Click Add to save your selections.

5. To eliminate any 0 values from your report, we recommend adding the following selection as well:

  1. Filter Column: Amount

  2. Comparison: Not =

  3. Value: 0

Click Add to save your selections.

6. Select Aggregate and choose the following selections:

  1. Data Column: Amount

  2. Aggregate Function: Sum

Click Add to save your selections.

7. Select Group and then choose how you want your data to be grouped (e.g. by employee, department, or position). For more detailed reporting, you can select Add to create multiple groupings, such as by department AND employee. 

To hide the data within your grouping, select Exclude Detail Rows.

8. Your report is displayed underneath your selections.

    • Related Articles

    • Standard Payroll reports overview

      Departmental Payroll Register This report breaks down your register entries into department sections. Each department will have a departmental total, and the report shows a company total at the bottom. You can export this report to a pdf. Employee ...
    • Custom Payroll reports overview

      Opening a custom report Select Reports on the side menu and choose the Custom Reports tab. Click on any custom report to view or edit. Exporting a custom report to Excel 1. Once you open your report, adjust your filters and press Submit. The filters ...
    • Processing payroll overview

      For details on your payroll cutoff (input due date), please see your funding agreement. Always review the Invoice Report and make sure that you have enough funds in your bank on the withdrawal date as shown on your invoice report before you click ...
    • Payroll reporting functions overview

      How to customize a Custom Report Custom reports provide a large amount of information, and there are functions provided to help narrow down the report to just the data required. We highly recommend using the functions available to make the ...
    • FAQ: Payroll setup

      Q: How does Rise calculate deductions for federal and provincial taxes? A: Rise uses cumulative averaging, meaning that our system uses the year-to-date options in the tax calculation as described in the Payroll Deductions Formulas for Computer ...