IdealWare Online Users Manual

PR5-14 P/R LISTINGS, REPORTS AND FORMS
46733 Payroll Reports

 

PURPOSE

 

The payroll reports program permits you to print a variety of earnings, benefits, deductions and tax reports. Reports may be printed as part of your payroll processing and as part of your month end routine in preparation for tax remittance.

 

From the batch processing options menu of the payroll by batch program the following payroll reports are available:

 

Payroll Earnings Report

Payroll Deductions Report

Payroll Benefits Report

Payroll Summary Report

Payroll Tax Report

Payroll Union Report

 

Additionally, the following payroll reports are also accessible directly from the main payroll menu:

 

Payroll Earnings Report

Payroll Summary Report

Tax Summary Report

 

When you select the payroll summary report from the main payroll menu, you also have access to all six of the payroll reports.

 

When you press [F4] to exit the report program you will be returned to the batch processing options menu if you accessed the report program from there, and returned to the main payroll menu if you accessed the program from there.

 

 

PROCEDURE - ACCESS

 

(1) From the Batch Processing Options menu of the Payroll by Batch program.

 

PAYROLL BY BATCH - BATCH OPTIONS MENU

┌────────────────────────────────────────────────────────────────────────────────┐
│BATCH PROCESSING OPTIONS:                                                       â”‚
│( 1)  SELECT ANOTHER BATCH                                                      â”‚
│( 2)  CHANGE BATCH DESCRIPTION                                                  â”‚
│( 3)  ABORT BATCH                                                               â”‚
│( 4)  ENTER/EDIT PAYROLL                                                        â”‚
│( 5)  VIEW PAYROLL                                                              â”‚
│( 6)  PRINT CHEQUES, DO DIRECT DEPOSIT OR PRINT EARNING STATEMENTS              â”‚
│( 7)  PRINT PAYROLL JOURNAL                                                     â”‚
│( 8)  PRINT PAYROLL REPORT                                                      â”‚
│( 9)  PRINT REGISTER THEN OPTIONALLY DO UPDATE                                  â”‚
│SELECT PROCESSING OPTION: __                                                    â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
SELECT PROCESSING OPTION: __

 

Select item (8) Print Payroll Report. The following report options are offered.


(1) PAYROLL EARNINGS REPORT
(2) PAYROLL DEDUCTIONS REPORT
(3) PAYROLL BENEFITS REPORT
(4) PAYROLL SUMMARY REPORT
(5) PAYROLL TAX REPORT
(6) PAYROLL UNION REPORT

** ENTER SELECTION (ENTER=''):

 

"1" to print the Payroll Earnings Report.

 

"2" to print the Payroll Deductions Report.

 

"3" to print the Payroll Benefits Report.

 

"4" to print the Payroll Summary Report.

 

"5" to print the Payroll Tax Report.

 

"6" to print the Payroll Union Report.

 

See PROCEDURE - PAYROLL DATA SELECTION.

 

 

 

(2) From the Main Payroll menu:

 

PAYROLL MAIN MENU

┌────────────────────────────────────────────────────────────────────────────────┐
│Terminal: TF5           THE IDEAL PAYROLL COMPANY INC.            Date: Dec03/07│
│Config:   iw73                 MAIN PAYROLL MENU                  Time: 17:13:12│
│                                                                                â”‚
│    â”Œâ”€Employee Maintenance────────────┐  â”Œâ”€Payroll Reports─────────────────┐    â”‚
│    â”‚  1 Employee Master              â”‚  â”‚ 41 Payroll Earnings             â”‚    â”‚
│    â”‚  2 Employee Listing             â”‚  â”‚ 42 Payroll Summary              â”‚    â”‚
│    â”‚  3 Employee Forms               â”‚  â”‚ 43 Tax Summary                  â”‚    â”‚
│    â””─────────────────────────────────┘  â””─────────────────────────────────┘    â”‚
│    â”Œâ”€Payroll Processing──────────────┐  â”Œâ”€YTD/EI Reports──────────────────┐    â”‚
│    â”‚ 11 Payroll by Batch             â”‚  â”‚ 51 YTD Report                   â”‚    â”‚
│    â”‚ 12 Enter/Edit Payroll           â”‚  â”‚ 52 EI Report                    â”‚    â”‚
│    â”‚ 13 Payroll Journal              â”‚  â””─────────────────────────────────┘    â”‚
│    â”‚ 14 Cheques/Statements           â”‚  â”Œâ”€Vacation Pay Summary────────────┐    â”‚
│    â”‚ 15 Register & Update            â”‚  â”‚ 61 Maintenance                  â”‚    â”‚
│    â””─────────────────────────────────┘  â”‚ 62 Report                       â”‚    â”‚
│    â”Œâ”€Payroll Inquiry─────────────────┐  â””─────────────────────────────────┘    â”‚
│    â”‚ 21 View Current Payroll         â”‚  â”Œâ”€Other───────────────────────────┐    â”‚
│    â”‚ 22 View Monthly Payroll         â”‚  â”‚ 71 Company Parameters           â”‚    â”‚
│    â”‚ 23 View History Payroll         â”‚  â”‚ 72 Year-end Processing          â”‚    â”‚
│    â””─────────────────────────────────┘  â”‚ 73 Super User Menu              â”‚    â”‚
│    â”Œâ”€Month-end Processing────────────┐  â”‚ 74 Report Generator             â”‚    â”‚
│    â”‚ 31 Month-end Purge              â”‚  â””─────────────────────────────────┘    â”‚
│    â””─────────────────────────────────┘                                         â”‚
│                     ** Enter Selection (F4 To End): ____                       â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘

 

The following report options are offered.

 

Payroll Earnings
Payroll Summary
Tax Summary

** Enter Selection (F4 To End):

 

"4""1" to access the Payroll Earnings Report.

 

"4""2" to access the Payroll Summary Report.

 

"4""3" to access the Tax Summary Report.

 

Depending on your security profile and the programs displayed on the menu, the reference numbers of these reports may not be the same as illustrated here, but the program NAMES will always appear the same. See PROCEDURE - PAYROLL DATA SELECTION.

 

 

 

PROCEDURE - PAYROLL DATA SELECTION

 

(1) Select the desired report from the report options of the batch processing options menu of the payroll by batch program. The program defaults to the current payroll batch only and displays the information about the current payroll batch and the report selected and the following prompts.

 

** CURRENT PAYROLL ONLY
** FOR SPECIFIED SOURCE BATCH
** ENTER DESIRED SOURCE BATCH: WP5082
** A=ACTUAL DIVISION/DEPARTMENT, C=CURRENT DIVISION/DEPARTMENT: A
** PAYROLL EARNINGS REPORT

 

** PAGE BREAK AFTER EACH DIVISION ? (Y/N): N

 

[Enter] to accept the default "N".

 

"Y" to add a page break after each division.

 

"N" to not add a page break after each division.

 

** PRESS ENTER TO CONTINUE:

 

[Enter] to proceed to print selection menu.

 

See PROCEDURE - PRINTER SELECTION.

 

 

[F3] to return to the previous field.

 

[F4] to exit to menu.

 

 

(2) Select the desired payroll report from the main payroll menu. When you select the Earnings Report or the Tax Report you are prompted whether to display data from the monthly or history files and the desired payroll dates.

 

** USE MONTHLY OR HISTORY PAYROLL HOLDING FILE ? (M/H):

 

"M" to use the monthly payroll file.

 

"H" to use the history payroll file.

 

[F4] to exit to menu.

 

** STARTING DATE:  11302007

 

This date should be the first day of the first pay period to include in the report.

 

 

Enter the desired starting date in the format MMDDYYYY.

 

[Enter] to accept the current system date.

 

[F3] to return to the previous field.

 

[F4] to exit to menu.

 

** ENDING DATE:    11302002

 

This date should be the last day of the last pay period to include in the report.

 

 

Enter the desired starting date in the format MMDDYYYY.

 

[Enter] to accept the current system date.

 

[F3] to return to the previous field.

 

[F4] to exit to menu.

 

 

When you select the Summary Report from either the Payroll by Batch, Batch Options menu or the Main Payroll menu you are offered the following report options for selection.

 

PAYROLL SUMMARY REPORT SELECTION MENU

┌────────────────────────────────────────────────────────────────────────────────┐
│Dec03/07 TF5           ***** PAYROLL SUMMARY REPORT *****                 IWPSR â”‚
│                                                                                â”‚
│                                                                                â”‚
│(1) PAYROLL EARNINGS REPORT                                                     â”‚
│(2) PAYROLL DEDUCTIONS REPORT                                                   â”‚
│(3) PAYROLL BENEFITS REPORT                                                     â”‚
│(4) PAYROLL SUMMARY REPORT                                                      â”‚
│(5) PAYROLL TAX REPORT                                                          â”‚
│(6) PAYROLL UNION REPORT                                                        â”‚
│** ENTER SELECTION (ENTER='4'):                                                 â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** ENTER SELECTION (ENTER='4'):

 

Enter the reference number of the report to print.

 

[Enter] to accept the default "4".

 

As you make your selections at the following prompts, the selected options are displayed at the top of the screen.

 

(1) CURRENT PAYROLL ONLY
(2) MONTH-TO-DATE PAYROLL ONLY
(3) HISTORICAL PAYROLL
** ENTER SELECTION (ENTER='1'): 1

 

[Enter] to accept the default "1".

 

"1" to select current data only.

 

(1) FOR ANY SOURCE BATCH
(2) FOR SPECIFIED SOURCE BATCH
** ENTER SELECTION (ENTER='1'): 1

 

[Enter] to accept the default "1".

 

"1" to select any current batch.

 

"2" to specify the current batch.

 

** ENTER DESIRED SOURCE BATCH:

 

Enter desired batch number.


"2" to select current month to date data only.

 

(1) FOR ANY DATE OR SOURCE BATCH
(2) FOR A SPECIFIED SOURCE BATCH
(3) FOR SPECIFIED DATE(S)
** ENTER SELECTION (ENTER='1'): 1

 

[Enter] to accept the default "1".

 

"1" to select any current month to date batch or date.

 

"2" to select a specified batch.

 

** ENTER DESIRED SOURCE BATCH:

 

Enter desired batch number.

 

"3" to select specified payroll dates.

 

(1) FOR A SPECIFIED PAYROLL DATE
(2) FOR A SPECIFIED RANGE OF PAYROLL DATES
** ENTER SELECTION (ENTER='1'): 1

 

[Enter] to accept the default "1".

 

"1" to specify a payroll date.

 

** SPECIFIED PAYROLL DATE: 12032007

 

Enter desired payroll date in the format MMDDYYYY.

 

[Enter] to accept current system date.

 

"2" to specify a range of payroll dates.

 

** ENTER STARTING PAYROLL DATE: 12032007

 

Enter desired starting date in the format MMDDYYYY.

 

[Enter] to accept current system date.

 

** ENTER ENDING PAYROLL DATE: 12032007

 

Enter desired ending date in the format MMDDYYYY.

 

[Enter] to accept current system date.

 

"3" to select historical payroll data only.

 

(1) FOR ANY DATE OR SOURCE BATCH
(2) FOR A SPECIFIED SOURCE BATCH
(3) FOR SPECIFIED DATE(S)
** ENTER SELECTION (ENTER='1'): 1

 

[Enter] to accept the default "1".

 

"1" to select any batch or date.

 

"2" to select a specified batch.

 

** ENTER DESIRED SOURCE BATCH:

 

Enter desired batch number.

 

"3" to select specified payroll dates.

 

(1) FOR A SPECIFIED MONTH
(2) FOR A SPECIFIED YEAR
(3) FOR A RANGE OF MONTHS
(4) FOR A SPECIFIED PAYROLL DATE
(5) FOR A RANGE OF PAYROLL DATES
** ENTER SELECTION (ENTER='1'): 1

 

[Enter] to accept the default "1".

 

"1" to specify a month.

 

** SPECIFIED PAYROLL MONTH: 200712

 

Enter desired month in the format YYYYMM.

 

[Enter] to accept current system month.

 

"2" to specify a year.

 

** ENTER PAYROLL YEAR: 2007

 

Enter desired year in the format YYYY.

 

[Enter] to accept current system year.

 

"3" to specify a range of months.

 

** ENTER STARTING MONTH: 200712

 

Enter desired starting month in the format YYYYMM.

 

[Enter] to accept current system month.

 

** ENTER ENDING MONTH: 200712

 

Enter desired ending month in the format YYYYMM.

 

[Enter] to accept current system month.

 

"4" to select a specified payroll date.

 

** SPECIFIED PAYROLL DATE: 12032007

 

Enter desired payroll date in the format MMDDYYYY.

 

[Enter] to accept current system date.

 

"5" to select a range of payroll dates.

 

** ENTER STARTING PAYROLL DATE: 12032007

 

Enter desired starting date in the format MMDDYYYY.

 

[Enter] to accept current system date.

 

** ENTER ENDING PAYROLL DATE: 12032007

 

Enter desired ending date in the format MMDDYYYY.

 

[Enter] to accept current system date.


** 1=HISTORICAL DIVISION/DEPARTMENT, 2=CURRENT DIVISION/DEPARTMENT: 1

 

[Enter] to accept the displayed default "1".

 

"1" for historical.

 

The report will be based on the division/department assigned to the employee when each payroll was processed.

 

 

"2" for current.

 

The report will be based on the division/department assigned to the employee currently.

 

 

[F3] to return to the previous field.

 

[F4] to exit to menu.

 

** PAGE BREAK AFTER EACH DIVISION ? (Y/N): N

 

[Enter] to accept the default "N".

 

"Y" to add a page break after each division.

 

"N" to not add a page break after each division.

 

** PRESS ENTER TO CONTINUE:

 

[Enter] to proceed to print selection menu.

 

[F3] to return to the previous field.

 

[F4] to exit to menu.

 

 

PROCEDURE - PRINTER SELECTION

 

PRINTER SELECTION & CONFIGURATION

┌────────────────────────────────────────────────────────────────────────────────┐
│08/14/07                *****  PRINTER SELECTION  *****                         │
│                                                                                â”‚
│                                                                                â”‚
│** MAKE SURE PRINTER IS READY BEFORE PRESSING CR .....                          â”‚
│                                                                                â”‚
│1. PRINTER NAME ................................. P1  OKIDATA 390               â”‚
│                                                                                â”‚
│2. CHARACTERS PER INCH ? (10,12,17) ............. 10                            â”‚
│   SINGLE OR DOUBLE DENSITY ? (S,D) ............. S   SINGLE DENSITY            â”‚
│                                                                                â”‚
│** PRESS CR TO SET PRINTER, OPTION# TO CHANGE, F4 TO END (BYPASS): _            â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** PRESS CR TO SET PRINTER, OPTION# TO CHANGE, F4 TO END (BYPASS):

 

"1" to change printers.

 

"2" to change the CPI and/or print density.

 

[Enter] to print.

 

[F4] to not print and exit to the menu.

 

[F5] to display a list of printers for selection.

 

An example Monthly Earnings Report printout follows. 




                                                  THE IDEAL PAYROLL COMPANY INC.
Dec03/07  18:33:57                                                                                                       PAGE: 1
                                                        PAYROLL TAX REPORT
                                       SELECTION CRITERIA: [CURRENT] [SOURCE BATCH: WP5082]
-----------------------------------------------------------------------------------------------------------------------------------
                           GROSS     INCOME   EMPLOYEE   EMPLOYER      TOTAL   EMPLOYEE   EMPLOYER      TOTAL      TOTAL        NET
DIV  DEP EMPL               PAY       TAX       CPP        CPP          CPP       EI         EI          EI
-----------------------------------------------------------------------------------------------------------------------------------
000  000 CEDJA            950.00     197.08      41.49      41.49      82.98      20.90      29.26      50.16     330.22     684.56
         JACMI            900.00     181.51                                                                       181.51     818.46
         MORDE            850.00     165.93      36.79      36.79      73.58      18.70      26.18      44.88     284.39     622.98
         NICWI            950.00     200.72                                                                       200.72     851.27
         OHAMA            550.00      80.61      22.69      22.69      45.38      12.10      16.94      29.04     155.03     431.15
         PHIRO            950.00     197.08                                                                       197.08     749.04
         SMIBI            950.00     197.08                                                                       197.08     746.20
          000-000       6,100.00   1,220.01     100.97     100.97     201.94      51.70      72.38     124.08   1,546.03   4,903.66
           000-ALL      6,100.00   1,220.01     100.97     100.97     201.94      51.70      72.38     124.08   1,546.03   4,903.66
001  000 MURPE          1,000.00     216.30                                                                       216.30     891.07
          001-000       1,000.00     216.30                                                                       216.30     891.07
           001-ALL      1,000.00     216.30                                                                       216.30     891.07
COUNT: 8                7,100.00   1,436.31     100.97     100.97     201.94      51.70      72.38     124.08   1,762.33   5,794.73