Ideal Online Documentation

46768 P/R LISTINGS, REPORTS AND FORMS
PR5-18 Tax Summary Report

 

PURPOSE

 

The payroll tax summary report prints a listing of all employee earnings and deductions by department and division. It is typically run as part of your month end routine to prepare withholding tax remittance. The tax summary report is also accessed from the batch processing options of the payroll by batch program. See 46733 PAYROLL REPORTS.

 

Tax Summary Report is accessed from:

  • Payroll by Batch program, Batch Options menu.
  • Main Payroll menu.

 

PROCEDURE

 

Select Tax Summary Report from the Main Payroll menu or the Batch Processing Options of the Payroll by Batch program. The following prompts display.

 

** 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 desired starting date in the format MMDDYYYY.

 

[Enter] to accept current system date.

 

[F3] to return to the previous field.

 

[F4] to exit to menu.

 

** ENDING DATE:    11302007

 

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

 

 

Enter desired ending date in the format MMDDYYYY.

 

[Enter] to accept current system date.

 

[F3] to return to the previous field.

 

[F4] to exit to menu.


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

 

[Enter] to accept the 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.

 

** PRESS ENTER TO CONTINUE:

 

[Enter] to proceed to print selection menu.

 

[F3] to return to the previous field.

 

[F4] to exit to menu.

 

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 Tax Summary 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