Inputting Payroll - Basic

---

Purpose

The first step in a series of steps required to issue pay cheques. This input is used in the Payroll Calculation Program option, to tell that program who should be paid and what additional variables, if any, are to be applied in the calculation of a cheque.

An input record is entered for each employee to be paid.

Another purpose is to enter adjustments specific to each employee, like a manual cheque or catch up values if starting up with the KLM Payroll system half way through the year. These also must be processed through the Payroll Calculation Program in order to get them into the history file so they become part of the employee's T4 history.

Keep In Mind

There is a separate input file based on the COMPANY NUMBER entered on the main screen. This does not stop you from entering employees from one company into another companies input file or from splitting up a cheque run for the same company by using another company's input file. Although the appropriate company information for the file will be used in the pay cheque run in Menu#20 the history records will go to the company specified on the employee's master record not the run/input Company number.

The following files are used by this program;

• COMPANY MASTER record
• EMPLOYEE MASTER record
• PAY CODE records.

You can create and process more than one batch of pay input records for the same pay period. Once ALL processing is completed, this file is deleted. Defaults are provided for the COMPANY, WEEK NUMBER and TOTAL WEEKS WORKED fields.

Adding a New Pay Input Record

Upon entering this option you are presented with the first of two screens. You must first select both the COMPANY Number and the WEEN Number before entering NEW Records. Remember you can have multiple input data files (based upon the Company Number).

If any data records already exist for the company in question, they will be displayed on the current screen. If no records exist, that part of the screen will be blank.

To add a NEW record, click once on the ADD NEW RECORD Button. A new BLANK data input record (screen) will appear.

2

This screen is divided into 3 sections:

• Main Information (top 3rd of screen) will contain items such who is to be paid and when.
• Weeks/Hours (middle of screen) will contain data fields for payroll weeks 1 & 2. You can enter both regular and overtime hours along with a trigger for overtime pay (*).
• Pay Adjustments section (bottom 3rd of screen) which services as a way to make adjustments or add additional items. See ALTERNATE Input for usage.

Once you have entered all necessary employee information, you must save the input record before continuing on to the next one.

Saving the New Record

There are two ways to save a new record.

• Saving using the SAVE Button will save the current record then return you to the prior screen. The newly created record should be added to the input record list.
• Saving using the SAVE & NEW Button will SAVE the current record before displaying a new BLANK Pay Input record screen.

Modify Existing Cheque Input Record

Follow the steps below to MODIFY the existing Pay Input information.

1) From the first input Screen, select the COMPANY and Week (if multiple files exist).

• You can change how the records are listed (in what order) by clicking ONCE on the list "headings". For example Click on the EMPLOYEE # to get a list in Employee Number order.
• To select any record, simply Double Click on it and the corresponding data input record will be displayed.

2) Make ALL necessary changes to the appropriate fields. If you are in doubt as to a field's contents, see FIELD Definitions section for further information.

• Remember you can use the LEFT / RIGHT Arrow Buttons to go forward or backward through the data input records (one record at a time).

3) Be sure to save the modified record using either the SAVE or SAVE/NEW Buttons.

Printing Cheque Input Records

Follow the steps below to PRINT a listing of all Pay Input records. KLM recommends reviewing this list before processing payroll as it is easier to fix problems before you have processed the actual payroll (produced pay cheques).

1) From the first input screen, verify the Company and Week numbers to make sure you have the correct file to print.

2) Select the OPTIONS Tab from the MENU Bar. Then Click once on PRINT PAYROLL INPUT LIST option. A Windows Print Preview screen will appear. Make your selections from the various printing options then print the report.

Delete Cheque Input Records or Entire File

To delete one cheque input record, do the following:

1) From the first input screen, select a valid COMPANY No. to to access the correct Pay Input file. Then select the employee record you wish to delete by DOUBLE Clicking on it. The record in question will appear.

2) Alter the following field, in the Pay Input Record. Place an X in the STATUS field. While the record is not physically removed from the file, it will now be ignored during processing.

3) Save the modified record using the SAVE Button.

To delete the ENTIRE Pay Input File, do the following:

1) From the First Input Screen, enter VALID Company and Week Numbers (if more than one file exists).

2) From the MENU Bar click on OPTIONS. From the Pull Down Menu, click on the Delete Current Input Files selection. You will be prompted ARE YOU SURE Click on **OK **if YES Or CANCEL if not sure.

3) Program removes present file, starts fresh file with a blank Pay Input Record. Proceed to input NEW records or EXIT the option.

Field Definitions - Pay Input Record

If you are unsure of what information to put into each of the fields of the Pay Input record, review the definitions listed below.

If employees are paid HOURLY, you MUST record the number of hours worked (regular and/or OT) for each week. For Bi-Weekly pays, be sure to break down hours between the two weeks. For SALARIED employees, leave these fields BLANK unless paying them for hours worked beyond the regular work week.ONLY if the TOTAL WEEKS WORKED is greater than 1, will you have access to the second week's fields.

Use the following fields to apply additional values to the employee cheque input record or record historical year-to-date earnings data, when cheques have already been issued for an employee. The remaining fields can be used in combination or separately. See the ALTERNATE INPUT section for further information.

Extra amounts may be applied to a pay during processing of a record by entering the effected pay codes and dollar amounts in the CODE and AMOUNT fields. Eighteen items per input record may be added.

Special Features: Options Menu - First Screen

In addition to PRINTING or DELETING the Payroll Input File, you have a number of additional utilities that can be used to speed up input of payroll records.

From the File List Screen, select the OPTIONS Tab on the MENU Bar. A list of all available utilities will appear. Click once to select any one of the options.

The available options are as follows:

• Print Pay Input List See PRINT CHEQUE INPUT RECORDS Print a hard copy of the Pay Input Listing
• Add All Active Salary Employees For This Company Will automatically create a Cheque Input record for each active SALARIED Employees indicated by an "S" in the PAY TYPE field of their Master record.
• Re-evaluate Link Labour Details Assigned To Cheque Input Record. Only used if you have Labour Distribution feature.
• Create Pay Input from Current Labour Details File Is ONLY used if you have Labour Distribution feature.
• Create Pay Input from Alternate Labour Input File Option is ONLY used if you have Labour Distribution feature.
• Delete Current Input File See DELETE CHEQUE INPUT FILE. Allows you to physically remove the cheque input ile should you need to start fresh.
• Sort This Pay (Cheque) Input File By Employee, Department or COA Number. Allows you to sort the current input file by either EMPLOYEE NAME or DEPARTMENT NO. order.

Once each utility has complete it's action, such as created a new input file, you will be returned to this same screen. Perform another function or exit this menu option.

Alternate Input

Not all pay input is straight forward, there are instances when you will have to perform special tasks. The following are the most common "special" situations encountered by our clients.

Issuing Vacation Pay

The following applies to issuing of vacation pay for both salaried and hourly employees.

• You can issue ALL or PART of an employee's vacation pay.
• The vacation pay percentage can very according to the defaults in the Company and Employee Master Files. The default is 4% and includes all regular, overtime and holiday pay issued.
• The vacation pay accrual is automatically updated each time it is issued (for hourly employees) or is given. Accrual amounts are not stored for salaried employees.
• Vacation pay owing is stored under the PAY CODE v. Vacation pay issued is stored under the PAY CODE V.
• If including vacation pay on some cheque, the EMPLOYED WEEKS field MUST reflect the actual number of weeks worked, regardless of the amount issued.
• If no time is to be taken, it is recommended to place it on the same cheque as other earnings, so deductions are properly applied.
• Any vacation pay issued is subject to ALL standard government deductions (ie. CPP/UIC/TAX). These are to be taken at the time the vacation pay is issued.

There are different ways to record vacation pay and the method you use is up to you. Unless you have arranged with KLM Software to set up an alternate method, the following method will be in place.

• All hourly employees will have vacation pay automatically accrued each time a pay is issued.
• All salaried employees will be paid their regular wage for any vacation weeks taken.

See the sample screens below for how to record vacation pay for both Salaried and Hourly employees. These are just the most common examples. If unsure of what to enter, contact KLM Software first.

This entry will produce one week of vacation pay and two weeks regular wages for an salary employee paid bi-weekly.The vacation pay amount will be the value of one week's salary.

This entry will pay all vacation accrued plus the hourly employee's bi-weekly wage (based on their hours worked).

This entry will pay an hourly employee part of their vacation pay (if they want only $100 of the vacation pay owed them) along with their bi-weekly pay.

Other Payroll Amounts

Occasionally extra amounts need to be added to a pay cheque, that are not automatically calculated.

• Taxable Benefits effect the GROSS wage upon which all government deductions are based. A Taxable benefit will increase the Gross but not the actual earnings, the employee will not receive extra money. Two pay codes have been set up to act as taxable benefits.
• Lump sum payments such as bonus or severance pay are not considered to be regular wages. Lump sums are be taxed on a straight percentage basis.
• Defaults for lump sum earnings (pay codes) are taxed at a flat rate (stored in field #24 of the Company Master File.
• Amounts for deductions such as: union dues, RRSP's, Group Insurance etc. can be entered as part of the cheque input or as a recurring entry. Certain amounts such as RRSP's will have a direct effect upon the amount of tax taken.

YTD Amounts & Adjustment Cheques

When recording earnings for which NO cheque is to be issued, whether it is to update the Year-To-Date figures or record the issue of a manually calculated pay cheque, you must take the following into consideration.

Whenever you record a manual or adjustment cheque:

• For manual cheques fill in the ADJUSTMENT CHQ# field with the cheque number used. If you don't know the number, enter 999. This prevents a cheque being issued.
• Enter ALL earnings, deductions and net amount of the cheque issued, in the CODE/AMOUNT fields. Earnings MUST include ALL Regular & Overtime pay. The Gross wage must be indicated as a separate amount.
• If Employment Insurance was deducted, enter Insurable Earnings as well as the amount deducted.
• Record the correct week number in the ALLOCATE TO WEEK field and the correct number of EMPLOYED WEEKS worked.
• To record an adjustment only the pay code and dollar amount of the adjustment is recorded in the CODE/AMOUNT fields. All other requirements are the same.

When recording Year-To-Date figures, you must consider:

• Select the best method for transferring YTD figures; All payroll detail or only summary amounts.
• Before you begin be certain that the week number ALLOCATED TO WEEK refers to a specific WEEK.
• Be sure to enter ALL payroll information, as it was recorded and reported upon. Do not allow calculation of past payroll by another method.

Below is a typical "adjustment" cheque inputted to the system to record Year To Date Earnings.