Atrieve Payroll

Cheque Parameters Profile

The Cheque Parameters Profile module allows the input of parameters to customize the payroll cheque. It can handle cheques that are stub first or last, earnings and deductions side by side, earnings with deductions following, or any combination. Year-to-date information is also available if needed.

The way to enter the information is to specify a line on the cheque and then specify all the fields to go on that line. It will display the fields on the line. Up to 13 fields may be entered on one line. The maximum number of lines that can be entered is 25.

When entering the parameters, the line number you use should be one Less than the line you want the output on (e.g., need output on line 9, use line 8 in profile).

Print mask size must consider the minus (-) sign which can, when required print at the right side of each number.

Print masks and line numbers operate differently between the Cheque and Earnings statement programs.


Required

Use for Cheque

Use for Earn STMT

Print Mask

9 characters

9

8

Line Number

Line 9

8

9

This module must be entered and exited (to set up a blank file) - if not being used.

Line #

  • Enter a line number from 1 to 80 of the cheque to set up or change. The default line spacing is 10 lines per inch vertically. If the cheque is to be printed at a different number, the printer must be set to the correct number of lines per inch and the cheque format built in relation to this.

Type

  • Enter 'R' if this line is to be repeated for a list of pay codes/deduction codes. It will repeat until the list of codes is exhausted or it encounters a line which is type 'N' or 'V'.

  • Enter 'B' if this line is to be repeated as in type 'R' but it is to follow on the next line after an 'R' line is finished. Specify the first possible line that this cheque line can print on in the Line # prompt.

  • Enter 'N' if this line is not repeated or a void line.

  • Enter 'V' if this line is to contain a **VOID** message, if two stubs are required to be printed to contain all the pay information. Void lines should be used on the last possible line that a prior repeating line can print. It is also common to use a void line for the line that would otherwise print the cheque amount.

Line Types 'E'arnings, 'D'eductions, or 'S'torage banks are special compression lines. The compression line is for use where multiple cheques caused by VOIDS is not desirable.

The compress line types are for defining the maximum line one of the repeating items can be printed on. The compression line will total all remaining values left to be printed beyond the compression line and print this summary total as the last item on the line number defined by the compression line.

The compression line types will only accept Literal field definitions. The only elements to be defined on these line types is the comment to be used in place of the description field. e.g. define a literal of 'REMAINING Earnings' on an 'E' line and this literal description will be used in place of the pay code description should the earnings be summarized.

  • Enter 'E' if the line number defined is to be the last possible line the repeating earnings list can print on.

  • Enter 'D' if the line number defined is to be the last possible line the repeating deductions list can print on.

  • Enter 'S' if the line number defined is to be the last possible line the repeating storage banks list can print on.

In the situation where the earnings, deductions and/or storage banks are defined to be printed side by side and you want the final compress line of both items to be on the same line; define the first compression line on the line you want the compression to take place. Define the second and/or third compression line using line 90 or 91. Lines 90 and 91 have been reserved for only compression lines and these special line numbers indicate that the actual line number to be used is the same line as the first (or true) compression line number.

For cheque parameters that defined with multiple repeating lines following each other (e.g.: all earnings followed by all deductions) define the starting line of the first repeating field using a 'R' type line. The second repeating set is defined on the next line using a 'B' type line. This will ensure no gaps are left between the two repeating sets. The compression lines will be defined based on the maximum number of earnings/deductions you want to allow. The cheque printing will adjust to ensure no gaps are left and the final compression line will be the maximum printing line for the two repeating sets.

Col#

Specify the column number that the field to be entered should start at. The column must be 1-80 for the start of the field although the end may go past 80 columns.

  • Enter 'T' to change the Type field.

  • Enter 'D' to delete a field from this line. The prompt will remain at the COL # field. Enter the column number of the field to delete. It will refresh the screen and the prompt will return to COL # for input of the next field.

Field

This is the list of codes that are valid on the cheque line. Choose any of the following. Numbers indicate the maximum length. 'N' means numeric.

Name 

Employee's name. (maximum 50)

ADD1 

Address line 1. (30)

ADD2 

Address line 2. (30)

ADD3 

City, Prov Code (maximum 40)

City 

The City line, (28 maximum)

PROV 

Prov Code or value in province field

PROV2 

Long form of province

ADD4 

City, Province Long form

ADD5 

City, Province Code Postal Code

ADD6 

City, Province Long Form Postal Code

POST 

Postal Code. (10)

EMP# 

Employee number. (10)

YPP   

Pay period. (Always 6)

LOCAT

Location of employee. (4)

SIN  

Social Insurance number. (10)

FEXP 

Federal Exemption dollars. (N)

ACC# 

Bank account number (Always 12)

Trans

Bank Transit number (Always 8)

PEXP 

Provincial Exemption dollars. (N)

CDATE

Cheque date YYYYMMDD. (Always 8)

MDATE

Cheque date MMDDYYYY. (Always 8)

DDATE

Cheque date DDMMYYYY. (Always 8)

CDATX

Cheque date Y Y Y Y M M D D (Always 15)

MDATX

Cheque date M M D D Y Y Y Y (Always 15)

DDATX

Cheque date D D M M Y Y Y Y (Always 15)

PDATE

Pay period end date. (Always 8)

CDATL

The expanded cheque date DD-MMM-YYYY (Always 11)

PDATL

The expanded pay period end date DD-MMM-YYYY (Always 11)

PCODE

Pay Code. (Always 2)

PDESC

Pay Code description. (30)

PHour

Pay Code hours. (N)

PRate

Pay Code rate. (N)

PAMT 

Pay Code amount. (N)

PYTD 

Pay Code YTD amount. (N)

PYTDH

Pay Code YTD hours. (N)

GYTD 

Total Earnings to date (N)

HRYTD

Total Hours to date (N)

DCODE

Deduction Code. (Always 2)

DDESC

Deduction Code description. (30)

DAMT 

Deduction Code employee's amount. (N)

DYTD 

Deduction Code YTD amount. (N)

DEDTD

Sum of Deduction to date (N)

Gross

Gross pay. (N)

DTOT 

Deduction total. (N)

NET   

Net pay. (N)

DNET

Dollar portion of net pay, no decimal (N)

CNET

Cents portion of net pay (Always ##)

DSHR 

Current Employer's share (N)

SHYTD

Employer's Share YTD (N)

SHTD 

Total Employer's share to date (N)

SHTOT

Total Employer's share for current period (N)

BNAMT 

Benefit Pay Period Amount (Repeating)

BNYTD 

Benefit YTD Amount (Repeating)

BENTD 

Benefits Total YTD Amount

BCODE

Storage bank code. (Always 2)

BDESC

Storage bank code description. (Maximum 30)

TDESC

Storage bank table code description (Maximum 30)

BHour

Storage bank table hours balance. (N)

BAMT

Storage bank table earnings balance. (N)

BVAL

Storage bank table hours or earnings balance. (N)

BTOT 

Benefits Total Pay Period Amount

CHEK 

Cheque number. (13)

CAMT 

Cheque amount. (Always 10  Asterisk filled)

CFULL

Cheque written amount. (Always 39)  (************##,###.##**************)

CAMT$

Word version of cheque amount. Reserves 75 characters. When used, this option should be the only item on the line due to the length of the words.

LIT 

Literal up to 7 characters will be printed on cheque exactly as typed.

# Characters

The number of characters to be printed for field selected. The characters are taken from left to right if maximum is not selected for alphabetic fields.

For numeric fields the characters are taken from right to left from the following mask - #,###,###,###.##-. This field is skipped for literals.

Literal

If the field selected is LIT then this prompt is valid. Input up to 7 characters which will appear exactly as input on the cheque.

NOTE: For the multiple items pay codes, deduction codes and storage bank codes it is mandatory to print some portion of the corresponding description. 

NOTE: The last line defined in the cheque parameters CANNOT be a repeating line. This refers to both 'R' and 'B' type lines.