Search Tips
In the Reports sub-menu there are various options for viewing the data entered and generated in the Payroll module.
Pay Register
Pgm: PY1057 – Payroll Register; standard Treeview path: US Payroll > Processing > Reports > Register Report
Use this report to view both the employee and employer portion of benefits and deductions calculated for a range of pay periods. This report can be printed in detail or in summary mode. This report is printed for a FEIN or for specific payroll companies.
The report prints all entries in order of FEIN, company, and then pay period and employee code in the pay run. The report automatically prints a grand total at the end and, if specified, a total after each pay period.
From Home Company, To Home Company
Enter a range of home companies to limit the register to only employees with specific home companies. Leave these fields blank to select all home companies.
Print Outstanding Payments Only – Checkbox
Check this box to print unpaid items where no check has been issued.
Print Summary Only – Checkbox
Check this box to only view grand totals by period.
Period Totals – Checkbox
If this box is checked after each pay period the report prints a pay period total and then a grand total. This only applies if the report is being printed for more than one pay period.
Print Pay Rate – Checkbox
If this box is checked pay rate information is included in the report.
Include Voided Checks – Checkbox
Check this box to include voided check information on the report.
Print Zero Net Pay Only – Checkbox
If this box is checked, the report only prints those employees with zero dollar net pay.
Print Employer Burden – Checkbox
Check this box to print non-cash benefit, deduction, and employer paid taxes on the Payroll Register report.
Check EFT Register
Pgm: PY1081 – Payroll Check EFT Register; standard Treeview path: US Payroll > Processing > Reports > Check/EFT Register
Use this screen to print the check/EFT register and create bank transfer files for direct deposit payments. The check/EFT register prints a listing of all checks printed on a particular pay run for a given period and employee range.
When issuing direct deposit payments, make sure to create the bank ASCII file for transfer to the bank. This is done through this screen which provides the ability to specify the company, pay run, period range, and employee range. Once selected, check the 'Print Deposits' box and the 'ASCII File' box. When the latter has been checked, two buttons appear, allowing for a new file to be created or an existing one to be downloaded.
This screen prints all entries in order of FEIN, company, and then employee code in the pay run. Each new company is distinguished by a solid black line denoting the payments made.
File Number
If a bank file has already been created, enter it here to recreate it with any additional information.
Include New Direct Deposits/Positive Pays – Checkbox
Check this box if a file number has been entered above and to include new direct deposits or positive pays in the file to be generated.
Create New Direct Deposits/Positive Pay File Excluding Old Data – Checkbox
If creating a new direct deposit/positive pay file and no file number has been entered, check this box to exclude old data.
Include Voided Checks – Checkbox
Check this box to include voided checks in the direct deposit/positive pay file.
Print Option
Select whether to print checks, deposits, or both in the register.
Sort By, Employee Name Print Order
Select how to sort the register and in what order employee names should be printed.
Reconcile Deposit(s) – Checkbox
Check this box to reconcile any direct deposits entered.
ASCII File – Checkbox
Check the this box to send the details of this report to an ASCII file. If checked, the Bank Formats field, as well as the [Generate File] and [Download File] buttons become available.
Bank Formats
Select the format of the bank transfer.
[Generate File], [Download File] – Buttons
Press these buttons to generate a new ASCII File or download an existing one, respectively.
Payroll Journal
Pgm: PY1005 – Payroll Journal; standard Treeview path: US Payroll > Processing > Reports > Payroll Journal
The Payroll Journal prints the details of all employee earnings for the specified period and pay run. Only those items that affect net pay are printed. For this reason, non-cash benefits such as company paid insurance are not printed.
Gross amount totals are displayed at the bottom of each heading and the net pay is displayed in the solid black line that denotes each new employee.
This report is most often used to verify employee pay amounts prior to check printing or EFT payment.
Print Summarized – Checkbox
Check this box to print a summarized payroll journal. This summarizes deductions, benefits, and taxes that have the same report code on their master file, into one line per employee.
Print Summary Only Report – Checkbox
If this option is selected then the report only prints totals.
History Transaction Listing
Pgm: PY1006 – History Transaction Listing; standard Treeview path: US Payroll > Processing > Reports > History Transactions Listing
The History Transaction Listing prints the details of everything calculated for an employee on the selected pay group/pay run for the period specified.
All entries are printed in order of employee code, transaction type, and transaction code. Each new employee is distinguished by a solid black line.
Transaction types include: BN-Benefits, BW-Basic Wages, DE-Deductions, EX-Expense, LE-Leaves, LI-Loan Interest, LP-Loan Principle, PL-Public Liability, TX-Taxes, and WC-Workers’ compensation.
PY/AP Combined Positive Pay
Pgm: PYMPOSPAY – PY/AP Combined Positive Pay; standard Treeview path: US Payroll > Processing > Reports > PY/AP Combined Positive Pay
This screen is used to created positive pay files for both the Payroll and Accounts Payable modules. Before using this screen make sure to add a bank positive pay file and a bank positive pay output file in the Bank Maintenance screen (standard Treeview path: System > Global Tables > Banking > Banks).
Company, Bank Code
Enter/select the company and bank codes for the positive pay output file. If the Bank Code field is empty, multiple positive pay files are created, one for each bank found and the data may stretch across companies.
Check As Of Date
Checks with a check date or a void date up to and including this date are selected.
File Path
Select the path to the file location. This path must end with a “\” e.g. C:\Extracts\
The name of the file is defaulted from the Positive Pay Output File Name field in the Bank Maintenance screen.
Include previous process checks – Checkbox
Check this box to include all checks, regardless of whether they have already been sent or not.
Include Void Checks – Checkbox
Check this box to send void checks.
Click the [Process] button to create the file. Messages are displayed as the activity progresses.
Employee Labels Printing
Pgm: PYLABELS – Print Employee Labels; standard Treeview path: US Payroll > Processing > Reports > Labels Printing
Use this screen to print the employee mailing labels for a particular pay run. Labels can be printed by FEIN or Company.
FEIN, Company, Pay Run
Enter/select the FEIN or company code, and the pay run.
Pay Group
Enter/select the pay group for the employees whose mailing labels being printed. Leave this field blank to print the mailing labels for all pay groups in the pay run selected in the previous field.
From Employee, To Employee
Enter/select the range of employees. To print labels for a single employee, enter the same code in both the From and To fields. To print labels for the full range of employees in the pay run, leave both fields blank.
Label Name
Select the layout of the label. Unless a custom version has been created, the only choice is “PY Labels on Laser Printer”.
Font Size
Select whether to print the labels in small, medium, or large font.
Employee Status
Select whether to print for active, inactive, or both types of employee.
Style Sheet
Select the label size and label count.
Sort By
Select whether the printed labels are sorted by employee last name or employee number.