ONTARIO PAYROLL 3.50 (c) 1992,1993, John S. Macera March 1993 As expected, the Ontario government has again changed the Provincial payroll deductions effective January 1, 1993. Replace your existing PAYROLL.EXE with the new program PAYROLL.EXE and PAYVARS.DAT with the revised PAYVARS.DAT file. The files included in this package are: 1. PAYROLL.EXE - THE PROGRAM 2. README.TXT - THIS FILE 3. PAYVARS.DAT - ASCII DATA FILE OF TAX VARIABLES REQUIRED: 384K RAM, COLOUR (preferred) or MONOCHROME MONITOR. ------------------------------------------------------------------------- WARRANTY Simply put, there is NO warranty of any kind, express or implied, including without limitation, any warranties of merchantability and/or fitness for a particular purpose. By using this program, you expressly agree that the author shall not be liable for any damages, whether direct, indirect, special or consequential arising from a failure of this program to operate correctly or in any manner described herein or desired by the user. The author shall not be liable for any damage to data or property which may be caused, directly or indirectly, by use of the program. IN NO EVENT WILL THE AUTHOR BE LIABLE FOR ANY DAMAGES, INCLUDING ANY LOST PROFITS, LOST SAVINGS OR OTHER INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF YOUR USE OR INABILITY TO USE THE PROGRAM, OR FOR ANY CLAIM BY ANY OTHER PARTY. ------------------------------------------------------------------------- SHAREWARE This program is provided at no cost for its use. If you find it useful, you can send a donation of $10.00 to the author. This will inspire me to continue to provide updates of the tax data, which is about twice a year, and program modifications. If you have a special request for a particular program modification, send me a note by mail and I'll do my best to answer your request. ------------------------------------------------------------------------- Using Ontario Payroll NOTE: It is important to make a backup of the program file << PAYROLL.EXE >> and the data file << PAYVARS.DAT >> !! 1. ADD EMPLOYEE If this is the first time you have used the program, you must first add employees. A screen for adding new employees appears. The SIN number is verified using the standard modulus 10 check digit formula which is used and approved by REVENUE CANADA. All employees are automatically sorted in alphabetical order (great for T4 preparation). Annual salary may be entered. Optionally, an hourly rate may be entered by using the H key as prompted by the program. Additionally, TD1 deductions for 1993 (basic deduction for 1993 is 6456.00), taxable benefits (if any) per cheque, other deductions per cheque, and other TD1 information. If a termination date is entered, the wages routine will by-pass that employee after the termination date. If a salary review date is entered, the program will beep when the review is due or overdue for a particular employee. OWNER - Business owners do not pay UIC for themselves, and are not entitled to collect UIC. If you are the owner, or own more that 40% of the voting shares of a business, and are on the payroll, simply list your JOB DESCRIPTION, in columns 1-5 of the field, as OWNER. Any other words can appear in the remaining field locations of the job description. The UIC calculation will be 00.00 for such entries, so do not use the job description OWNER as the first word in a job description for non-owners. CALCULATOR - Use C to invoke a 16 significant digit calculator. Only 2 decimal digits are displayed. Exit thc calculator mode by using the ESC key. Use + to add, - to subtract, * to multiply, / to divide, and C to clear. 2. ENTER WAGES The pay period wage, together with all deductions, is calculated and displayed in a second window. The date, gross pay, taxable benefits, other deductions, cheque number can all be altered from the expected actual amount using the up and down arrows. If an employee is designated as an hourly employee, a window will open to permit you to enter the number of hours worked to calculate gross pay. The UP arrow key can be used to change the hourly rate for a particular paycheque. The rate and number of hours will be displayed and printed on the payslip. The date automatically increments to the next pay period date unless manually altered. The cheque number automatically increments unless manually altered. New tax, CPP, UIC deductions are automatically calculated if the gross pay or a taxable benefit is manually changed for a particular cheque. If the pay cheque is the same as the last pay cheque for the particular employee, all you need to do is press one key - the << F10 >> key. To by-pass an employee, simply press << F5 >>. Bonus, overtime, and retroactive payments can be made by using <> to enter the Bonus mode. The number of pay periods is displayed. Valid pay periods are 26, 27, 52, or 53. The default number of pay periods is the number set in the ASCII file, which can be changed using command line input. For example, type PAYROLL 52 for weekly pay periods. Typing << PAYROLL >> is the same as typing << PAYROLL 26 >> unless the Variable << P >> is changed in the << PAYVARS.DAT >> file. It can also be changed through the CHANGE VARIABLES routine from the main menu. If the employee job description is OWNER, no UIC will be deducted. In addition, if the employee has not earned sufficient income of worked sufficient hours, no UIC will be deducted. CALCULATOR - When in the WAGES screen, use C to invoke a 16 significant digit calculator. Only 2 decimal digits are displayed. The total of the calculations will remain displayed after exiting the calculator mode by using the ESC key. Use + to add, - to subtract, * to multiply, / to divide, and C to clear. BONUS PAYMENTS - RETROACTIVE PAY - OVERTIME When a separate cheque is used for a bonus, retroactive pay, or overtime pay, while in the WAGES menu, press B (that is, hold down the ALT key and press the B key). A special calculation is performed for the foregoing types of payments. More income tax is deducted, and the limits for CPP are different. The program stays in the BONUS mode for only that particular employee. Other employees can be by-passed using the < F5 > key, or a BONUS payment can be calculated for them by again using the B key. To escape from the BONUS mode, use the B key again (it is a toggle between normal mode and BONUS mode). In addition, if the amount of the cheque is less than the UIC minimum amount, the program will prompt for the number of hours worked to determine if UIC should be paid by the employee. 3. MODIFY EMPLOYEE First, an alphabetical list of employees appears, and this can be scrolled by the up and down arrow keys to select an employee. Use this option to change gross annual or hourly pay, termination date, address, TD1 deductions or other deductions, etc. << F10 >> saves changes; << ESC >> aborts. CALCULATOR - Use C to invoke a 16 significant digit calculator. Only 2 decimal digits are displayed. Exit thc calculator mode by using the ESC key. Use + to add, - to subtract, * to multiply, / to divide, and C to clear. 4. PRINT PAYSLIPS Prints, in condensed print, the payslips for a given date. Currently supports HP laser jet codes, and IBM proprinter codes. The printer type can be changed through the ascii data file PAYVARS.DAT or through the CHANGE VARIABLES routine from the main menu. [ The only special printing features used are small print (from 15 to 20 cpi) ]. 5. HOLIDAY/SICK DAY OR AUTHORIZED LEAVE If your monitor is EGA or better, and if the variable in the file is set to (VGA=ON), the entire year will be displayed. Otherwise, 6 months at a time are displayed. In the file, set the variable VGA=ON or VGA=OFF. PgUp and PgDn will change the year which is displayed. First, scroll employees and select. The current year calendar appears, with the cursor on today's date. Use only the following keys: to enter a full day holiday; <2H> to enter a half-day holiday; to enter a full day sick day; <2S> to enter a half-day sick day; to enter a full day of leave; <2L> to enter a half-day of leave; to quit; to save (and amend if necessary). These keys select a date and display the date at the bottom of the screen, while the date selected is highlighted. The 4 arrow keys are used to scroll around the calendar, as well as F1 to select either the first 6 or last 6 months if either the variable VGA=OFF in the file or your video card is not EGA or better. aborts selections. << F10 >>moves the cursor to the bottom of the screen to the selected dates, at which time you may amend the selections: (1) H - full day holiday (2) 2H or H2 - 1/2 day holiday (3) S - full sick day (4) 2S or S2 - 1/2 sick day (5) 2L or L2 - 1/2 day leave (6) L - full day leave A particular day can only be selected once. Use the key to delete a previously selected date. The key will not delete a date which is just now selected. Use the key to exit the routine, and then re-enter it. 6. MONTHLY TOTALS Print this out monthly. The printout will tell you how much you have to remit to the Receiver General on the 15th for withheld and employer contributed CPP, UIC, Income Tax. Also tells you if Ontario health tax (EHT) is due, and if so, when, and how much. Gives you all the other totals. 7. REVIEW PAYSLIPS First, you select the employee by scrolling through the names. Payslips will be displayed in turn by using the ENTER key until there are no more for that employee. Payslips can be deleted by using the D key when the payslip is displayed. 8. PRINT EMP. PAGES This will print all the payroll data and holiday/sick day data for all employees from the beginning of the year to date. Generally, there is only 1 page per employee until near the end of the year. 9. DISPLAY HOLIDAYS If your monitor is EGA or better, and if the variable in the file is set to , the entire year will be displayed. Otherwise, 6 months at a time are displayed. In the file, set the variable VGA=ON or VGA=OFF. PgUp and PgDn can be used to display other years. Total holidays, sick days, and leave days for a selected employee are shown on the calendar by differential highlighting of the days. A colour monitor is advantageous. A. CHANGE VARIABLES Once the program has been loaded, use this routine to change either the default printer or the number of pay periods.