Skip to main content
Sparkrock

Generating Payroll Reports

Payroll Management contains options for viewing and analyzing employee pay data along with creating reports for statistical and reference purposes. These are valuable tools for tracking employee payment and calculation data.

Creating User-Defined Reports with the Payroll Control Schedule

You can use the Payroll Control Schedule to create user-defined payroll reports to suit the particular requirements of your organization.

The payroll control schedules you define can then be applied to the following reports to customize the data within these reports:

  • Payroll Check Register (portrait and landscape format)
  • Payroll Schedule (portrait and landscape format)

Creating a Payroll Control Schedule

Payroll Control Schedules are created similarly to how Account Schedules in the General Ledger are created.

To create a user-defined payroll report:

1. Payroll > Analysis and Reporting. The Payroll and Analysis folder opens.

2. Select Payroll Control Schedule. The Payroll Control Schedule window opens.

image

3. In the Name field, click the Assist button. The Payroll Control Schedules list window opens.

image

4. Press the F3 to create a new record.

5. In the Name field, enter a name for the new pay control schedule.

6. In Description field, enter a brief description for the data the report contains.

7. Click OK.

8. The Payroll Control Schedule window opens with the newly created schedule in the Name field.

9. Use the following table to complete the fields in the Payroll Control Schedule window.

Reviewing and Creating the Payroll Control Schedule Information

Field Name

Details

Name

Displays the name of the payroll control schedule. Click the Assist button to add a new payroll control schedule or select an existing one.

Column No.

A column requires a column number if you want to refer to this column in the formula of another column. You can leave this field blank. This field is limited to 10 alphanumeric characters.

Column Header

Enter the text/description to use to identify this column on a printed report. This field is limited to 30 characters.

Column Type

The selections made here determine where the column looks to calculate its value. The options include:

  • Formula: Select this option if you want the value of this column to be determined by a mathematical formula based on the value(s) in other column(s).
  • Payroll Amount: Select this option if you want the value of this column to be determined by summing up the amount posted in the Payroll Ledger Entry table.
  • Taxable Amount: Select this option if you want the value of this column to be determined by summing up the taxable amount posted in the Payroll Ledger Entry table.

Formula

If the column type (see above) for this line is ‘Formula’, then enter the formula into this field. If not ‘Formula’, leave the field blank. Select this option if you want the value in this field to be determined by a mathematical formula based on the value(s) in other column(s).

Comparison Period Formula

If the column type for this line is ‘Formula’, then leave this field blank. Otherwise, you can enter a formula to indicate which period to use to calculate the amount in this column. You can use this if you want to include figures from various periods on this same report.

NOTE: The formula calculates the comparison period in relation to the period represented by the date filter on the report request.

Show Opposite Sign

Check this field if you want the amounts in this column to display using the opposite sign (plus or minus) from that, which is stored in the Payroll Ledger Entry table with the sign they display in the Payroll Journal.

NOTES:

  • An example would be deductions. If your report showed the total of deductions for a certain period, they would show as a negative since that is how they are posted to the Payroll Ledger.
  • Employee contributions are stored as a negative number, so to show those values as positive numbers in a report, you would select this option.

Show

Click the Assist button to select the Show option. This determines whether the amounts in this column show on the report. Your options include:

  • Always: Select this option if you want the amount for this column to show regardless of its value. This is the default selection.
  • Never: Select this option if you want the column to never show.
  • When Positive: Select this option if you want the amount for this column to show only when the value is positive.
  • When Negative: Select this option if you want the amount for this column to show only when the value is negative.

NOTE: In the case of the last two options, the sign of the amount is tested (determined to be positive or negative) before the ‘Show Opposite Sign’ selection is taken into account.

Rounding Factor

Indicates how the numbers in the column will be rounded in the report. Select from the following options:

  • None - This option prints the amounts to the penny.
  • 1 - This option prints the amounts to the nearest dollar.
  • 1000 - This option prints the amounts to the nearest thousand dollars.
  • 1000000 - This option prints the amounts to the nearest million dollars.

NOTE: The amounts are rounded for printing purposes only. All calculations and totals are carried out to the nearest penny.

Type Filter

If the Column Type for this line is ‘Formula’, then leave this field blank. Otherwise, use this field to select the payroll control types you want the program to consider to determine the amount calculated for this column. Leaving this field blank brings in all control types.

Your options include:

  • 0 – Paid Hour
  • 1 – Hour
  • 2 – Earnings
  • 3 – Bonus
  • 4 – Income Tax
  • 5 – Employment/Unemployment Tax
  • 6 – Other Tax
  • 7 – Net Pay
  • 8 – Pre-Tax Deductions
  • 9 – Deduction
  • 10 – Week
  • 12 – Miscellaneous

NOTE: Number 11 – Accrual is not available as an option.

The following columns are all filters of varying types. These can be used to reduce or more clearly define the controls that are used in determining the values reported.

Your options include:

  • Name
  • Rep. Auth. Type Filter
  • Work Rep. Auth. Code Filter
  • State Filter
  • Locality Filter
  • Work Type Filter
  • G/L Post Type Filter
  • Employer No. Filter Tax Form Filter
  • Tax Form Class Filter
  • Payroll Control Code Filter
  • Global Dimension Filters

Most of these fields can be found in the General tab of the Payroll Control Card.

NOTE: These filters are set the same as the filters that are set in the Base Amounts table of a Payroll Control.

Name Filter

If the Column Type for this line is ‘Formula’, then leave this field blank. Otherwise, use this field to select the payroll control types you want the program to consider to determine the amount calculated for this column. Leaving this field blank brings in all control types.

Reporting Authority Type Filter

If the Column Type for this line is ‘Formula’, then leave this field blank. Otherwise, use this field to select the payroll control types you want the program to consider to determine the amount calculated for this column. Leaving this field blank brings in all control types.

Your options include:

  • Federal
  • State
  • Local
  • Other

Work Reporting Authority Code Filter

If the Column Type for this line is ‘Formula’, then leave this field blank. Otherwise, use this field to select the payroll control types you want the program to consider to determine the amount calculated for this column. Leaving this field blank brings in all control types.

Payroll Control Code Filter

If the Column Type for this line is ‘Formula’, then leave this field blank. Otherwise, use this field to select the payroll control types you want the program to consider to determine the amount calculated for this column. Leaving this field blank brings in all control types.

Your options include:

  • …Range
  • And
  • Or
  • Greater Than
  • Less Than
  • Not Equal

Running Payroll-related Reports

Use the Reports option to view and print all payroll-related reports. This option includes reports for internal reporting. Some of the reports offered are the Employee Listing, Payroll Calculation Setup, and Payroll Projection.

If your organization has more specific reports set up, these reports can also appear on the Reports list. You can filter on specific fields to generate reports that contain only the information you want to see.

To access the Payroll Reports:

1. Payroll > Reports.

    The Reports folder opens.

2. Select the report you want.

    Based on your selection, the appropriate window opens.

3. Use the Field and Filter columns in the available tabs to customize/refine the report data.

4. Click the Preview button to review the report before printing.

5. Once you are satisfied with the report content, click the Print button.

Understanding Payroll Report Options and Resulting Data

The following provides a brief description of the data captured in some of the reports that are available. For the most part, the Payroll reports provided are self-explanatory. The reports listed here require a bit more detail to understand fully the use and results of the report.

All Payroll reports can be filtered to customize the data returned.

Payroll Check Register Report (standard and Landscape)

This report enables you to print a Payroll Check Register (report) with up to 12 columns. The cheque number and pay date are automatically included on this report.

You use the Payroll Register table (see, ‘Creating a Payroll Control Schedule’ for details) to define what columns you want included in the report and how you want a Payroll Check Register presented. This table contains the column definitions for a Payroll Check Register. Each record in this table contains the definition of a single column in a Payroll Check Register report. Once you define the columns, you can either print or preview these reports.

Depending on the individual report, you may be able to get up to 12 columns printed. However, if a column is not shown because it is only used as a basis for another column, then that column does not count against this limit.

  • Payroll Check Register, Landscape: This report is the same as the above, only in landscape format. Use this to create reports with several columns.

Payroll Schedule Report (standard and Landscape)

This report enables you to print a Payroll Schedule report with up to 12 columns. Payroll Control Schedules provide the ability to create user – defined payroll reports.

Depending on the individual report, you may be able to get up to 12 columns printed. However, if a column is not shown because it is only used as a basis for another column, then that column does not count against this limit.

  • Payroll Schedule, Landscape: This report is the same as the above, only in landscape format. Use this for reports with several columns.

Payroll Schedule, Excel Export (Advanced Position Management only)

This report enables you to export a Payroll Schedule report to Excel. The report allows filtering on Payroll Ledger Entries and is exported to Excel in Landscape format.

NOTE: To indicate that you want to create the report as an exported file, in the Options tab, you must select the Export to Excel check box.

Import Payroll Journal from Excel

This report enables you to import information into a Payroll Journal using a predefined Excel template.

image

In the Import Payroll Journal window, complete the following:

1. In the Import File text box, click the Navigate icon (…) to browse to and select the Excel file to import.

2. De-select the File has header check box if you deleted the header row from the template.

3. In the Payroll Control Code field, click the Assist icon to select a payroll control if you do not want to fill the Payroll Control Code on the lines of the template, otherwise leave blank.

4. In the Document No. field do one of the following:

  • Leave blank if the Import is to be part of a regular payroll calculation and the process of paying (Issuing cheques or direct deposit) will populate the Document no. field with the appropriate data.
  • Populate a text value from the request form if the import is to be used to post the entries without having to perform a calculation:
    • The process automatically adds the employee number to the text entered. This creates a unique document per employee.
    • The process also populates the Bank Payment Type field with Manual Cheque.

5. Select the Override Dimensions check box when you want the dimension values from the import to override the dimension values associated with the HR Position for the employee.

6. Click the Pay Cycles button to validate that the values are correct. (The pay cycles are automatically populated with the values from the Defaults tab of the Payroll Journal.

Garnishment Report

This report includes the garnishment details for an employee.

Use this report to provide the garnishment authority with the details of the debtors involved, the associated file and reference numbers, the amounts withheld, and the total being remitted. (It also enables you to maintain a ‘backup’ record for payments made to external authorities relative to garnishments.)

The creation of a Garnishment report is typically accomplished after a payroll run has been fully completed and posted both to the general ledger and the payroll sub-ledger (Payroll Ledger Entry table). This ensures that any information of a sensitive nature, such as a garnishment, is based on completely accurate ‘committed’ data that cannot be modified by any other means than an appropriate, auditable adjustment.

After the payroll run is complete, print the report and send the appropriate pages to the external body along with a cheque or a copy of the EFT remittance advice.

There are two steps to the process for generating a garnishment report:

  • Assigning the garnishment details to a payroll control for the employee - if an employee has been flagged by a garnishment authority to have their pay garnished, you can apply the garnishment payroll control. This control enables you to define the dollar amount by which the employee’s wage is being garnished.
  • Running the report

For information on setting up the fields for enabling the garnishment report, see ‘Reviewing the Payroll Controls Assigned to an Employee’.

To create a garnishment report:

1. Open the Employee Card.

2. Click Payroll and select Payroll Controls.

3. From the Payroll Controls List, select a Payroll Control Card.

4. Click to select the Garnishment Control check box.

5. Click to select the Include SIN No. Suffix a check box to specify if the SIN No. Suffix is to be printed following the SIN number for the Payroll Control associated with the given garnishment.

6. From the Payroll menu, select Reports > Garnishment Report.

7. Provide the parameters for the details you want to include in the report.

  • Was this article helpful?