How do I 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:
Filter Column: Type
Comparison: Contains
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:
Filter Column: Amount
Comparison: Not =
Value: 0
Click Add to save your selections.
6. Select Aggregate and choose the following selections:
Data Column: Amount
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
How to process payroll
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 ...Frequently Asked Questions - Payroll
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 ...How do custom reports work?
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 ...How to add payroll instructions
Who can use this feature? Users with Payroll Organization Admin role Available on Start , Grow , and Optimize plans. Introduction Payroll instructions are fundamental building blocks in Rise Payroll. They calculate and track the amounts of earnings, ...How to create an earning pay code
There are three types of earning payroll instructions. If you wish to enter a number of hours into the input sheet and have the hours calculate at the hourly or salary rate outlined in the employee's compensation policy, you will need to set up ...