Ideal Online Documentation

31360 P/R LISTINGS, REPORTS AND FORMS
PR5-19 Tax Table Listing

 

PURPOSE

 

The tax table listing program prints a list of your current tax table settings that the system uses for payroll calculations.

 

Tax Table Listing is accessed from:

  • Payroll Year End Processing menu.

 

PROCEDURE

 

Select Tax Table Listing from the Payroll Year End Processing menu. The tax table maintenance options are displayed.

 

** TABLE FOR WHAT TAX YEAR:

 

Enter the tax year to list the table in the format YYYY.

 

** A=JANUARY 1ST EDITION, B=JULY 1ST EDITION:

 

"A" for tax table as at January 01.

 

"B" for tax table as at July 01.

 

>> THIS TABLE DOESN'T EXIST. PRESS ENTER:

 

If the table you select does not exist in the system this prompt will be displayed, press [Enter] to clear the message and reselect the tax table.

 

** HOW MANY COPIES ? 1

 

Enter the number of copies to print.

 

[Enter] or "1" to print 1.

 

** PRESS ENTER TO CONTINUE:

 

[Enter] to proceed to the 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 Table Listing printout follows.

  



                       THE IDEAL PAYROLL COMPANY INC.
Dec01/07  13:11:26                                          PAGE: 1
                                TAX TABLES

FEDERAL TAX TABLE
-----------------

ANNUAL TAXABLE INCOME (A)       RATE          CONSTANT
  FROM:    TO:                   -R-               -K-

--------------------------------------------------------------------------------
      0 -  31,677              .1600                 0
 31,677 -  63,354              .2200             1,901
 63,354 - 103,000              .2600             4,435
103,000 - 999,999              .2900             7,525
      0 -       0              .0000                 0
      0 -       0              .0000                 0
      0 -       0              .0000                 0
      0 -       0              .0000                 0
      0 -       0              .0000                 0
      0 -       0              .0000                 0
      0 -       0              .0000                 0
      0 -       0              .0000                 0
      0 -       0              .0000                 0
  7,634 -       0              .0000                 0

--------------------------------------------------------------------------------




FEDERAL SURTAX RATE
-------------------

SURTAX RATE 1                            .0000
FEDERAL TAX MINIMUM 1                        0

SURTAX RATE 2                            .0000
FEDERAL TAX MINIMUM 2                        0

--------------------------------------------------------------------------------




TD1 FEDERAL TAX CREDIT DEFAULT
------------------------------
TD1 DEFAULT                      7,634.00

--------------------------------------------------------------------------------




                       THE IDEAL PAYROLL COMPANY INC.
Dec01/07  13:11:26                                          PAGE: 2
                                TAX TABLES


INSURABLE EARNINGS TABLE AND U.I. RATE
--------------------------------------

PAY PERIOD       MINIMUM    MINIMUM       MAXIMUM          YEAR      U.I.
                  HOURS   INSURABLE     INSURABLE       MAXIMUM      RATE
                           EARNINGS      EARNINGS       PREMIUM
--------------------------------------------------------------------------------
WEEKLY               15      149.00        745.00      1,162.20     .0300
BI-WEEKLY            30      298.00      1,490.00      1,162.20     .0300
SEMI-MTHLY           33      322.83      1,614.16      1,162.20     .0300
MONTHLY              65      645.66      3,228.33      1,162.20     .0300
10 MONTHLY           78      774.80      3,874.00      1,162.20     .0300
13 PERIODS           60      596.00      2,980.00      1,162.20     .0300
22 PERIODS           35      352.18      1,760.90      1,162.20     .0300


--------------------------------------------------------------------------------



CANADA PENSION PLAN FACTORS
---------------------------

CPP RATE                           4.7000
MAXIMUM ANNUAL CONTRIBUTION         1,673
MONTHLY CONTRIBUTION               39,100
BASIC EXEMPTION                     3,500
MINIMUM AGE                            18
MAXIMUM AGE                            70


--------------------------------------------------------------------------------




                       THE IDEAL PAYROLL COMPANY INC.
Dec01/07  13:11:26                                          PAGE: 3
                                TAX TABLES


PROVINCIAL TAX RATES
--------------------

                     (V)       (V1)       (V2)       (V3)       (V4)        (S)
--------------------------------------------------------------------------------
PROVINCE      PROVINCIAL     SURTAX   FLAT TAX   FLAT TAX   N.I. TAX   PRV. TAX
                     TAX               ON N.I.    ON T.I.     SURTAX  REDUCTION
--------------------------------------------------------------------------------
                    RATE       RATE(1)    RATE       RATE     AMOUNT       RATE
                          THRESHOLD(1)                     THRESHOLD    CEILING
                               RATE(2)                     TH AMOUNT   THRESHLD
                          THRESHOLD(2)
                           Y-FACTOR
--------------------------------------------------------------------------------
AB  ALBERTA        .1000                            .1000


--------------------------------------------------------------------------------
BC  BRITISH COLUM  .0000


--------------------------------------------------------------------------------
MB  MANITOBA       .0000                                                  .0100
                                                                            225
                                                                            300
--------------------------------------------------------------------------------
NB  NEW BRUNSWICK  .0000


--------------------------------------------------------------------------------
NF  NEWFOUNDLAND   .6900


--------------------------------------------------------------------------------
NS  NOVA SCOTIA    .5950      .1000
                             10,000

--------------------------------------------------------------------------------
ON  ONTARIO        .0000      .2000
                              3,685                                         161
                              .3600                                         328
                              4,648
--------------------------------------------------------------------------------
PE  PRINCE EDWARD  .5950      .1000
                             12,500

--------------------------------------------------------------------------------
PQ  QUEBEC         .0000      .0800
                             13,500

--------------------------------------------------------------------------------
SK  SASKATCHEWAN   .0000                 .1150


--------------------------------------------------------------------------------
YT  YUKON TERRITO  .4600

                              .1500
                              4,000
--------------------------------------------------------------------------------