The Employee information is kept in the PREMPE.DBF file.
PAYTIME 3:02:13 pm +------------------------------<EMPLOYEE FILE>---------------------------------+ ¦ ¦ ¦Employee Identification: : Company Identification : : ¦ ¦------------------------------------------------------------------------------¦ ¦ First Name : : Initial : : ¦ ¦ ¦ ¦ Surname : : ¦ ¦ ¦ ¦ Position : : Dept : : ¦ ¦ ¦ ¦ Address : : ¦ ¦ ¦ ¦ City : : ¦ ¦ ¦ ¦ Province: : Postal code : : ¦ ¦ ¦ ¦ Telephone No: : Social Insurance Number : 0: ¦ ¦------------------------------------------------------------------------------¦ ¦ Birthday (Mo/Dy/Yr) : / / : Seniority Date : / / : ¦ ¦ ¦ ¦ First Day Worked : / / : Last Day Worked : / / : ¦ +------------------------------------------------------------------------------+ P)roceed to next screen or (C)orrect ( ) |
|
|
Press <S> the computer will skip the rest of the information on this Employee, unless you are adding the Employee.
PAYTIME 11:15:22 am +------------------------------<EMPLOYEE FILE>---------------------------------+ ¦Bee Cee ¦ ¦ Rate of Pay : 15.00: per:H: (M)onth, (W)eek, (H)our or (C)ommission ¦ ¦ ¦ ¦ Effective Date : / / : Average Regular Daily Hours : 7.50: ¦ ¦ ¦ ¦ Skill Rate : 0.000: per hour Mid pay ADVANCE : 0.00: ¦ ¦------------------------------------------------------------------------------¦ ¦ Holiday Pay Percentage : 4.00: Province of Employment :B C: ¦ ¦------------------------------------------------------------------------------¦ ¦ Tax Exemptions per TD1: ¦ ¦ Net Claim Amount : 6456.00: ¦ ¦ Extra Tax per pay : 0.00: Designated Area Amount : 0.00: ¦ ¦ Number of Dependants : 0: OAS Pension : 0.00: ¦ ¦ Provincial 'Y' factor (see MC book for details) : 0.00: ¦ ¦ Authorized Annual Deduction for Payments : 0.00: ¦ ¦ Other Authorized Federal Tax Credits : 0.00: ¦ ¦------- C.P.P. exemption (Y)es :N: E.I. exemption (Y)es :N: -------¦ ¦ Estimated monthly Taxable Benefits, subject to EI : 0.00: ¦ ¦ Estimated monthly Taxable Benefits, Not subject to EI : 0.00: ¦ ¦ Estimated monthly Non Taxable Benefits, subject to EI : 0.00: ¦ +------------------------------------------------------------------------------+ (P)roceed to next screen, (C)orrect or (S)kip to Year to Date ( ) |
6.00% Three weeks
If your company's Holiday Pay Rate is based on some other formula, enter 0.00% in the holiday pay percentage and keep track of the Holiday Pay on a manual system.
+---------+------------------------------+ | Abbrv | Province | +---------+------------------------------+ | | | | ALT | Alberta | | | | | B C | British Columbia | | | | | MAN | Manitoba | | | | | N B | New Brunswick | | | | | NEW | Newfoundland | | | | | N S | Nova Scotia | | | | | ONT | Ontario | | | | | PEI | Prince Edward Island | | | | | P Q | Quebec | | | | | SAS | Saskatchewan | | | | | N T | Northwest Territories | | | | | YUK | Yukon | | | | | CAN | Outside Canada | +---------+------------------------------+ |
Note: make sure there are no periods or that the spacing is correct in this field.
Enter the following Tax Exemptions found on the TD1 form:
Extra Tax (On form TD1(97): Sec.9)
Designated Area Amount (On form TD1(97): Sec.10)
Number of Dependants (On form TD1(97): Sec.11)
Authorized Annual Deductions for Payments (Form Supplied by Government)
Other Authorized Federal Tax Credits (Form Supplied by Government)
When you have entered all the information on this screen the computer will ask you to:
|
Press <S> the computer will skip the rest of the information on this Employee.
PAYTIME 11:17:18 am +------------------------------<EMPLOYEE FILE>---------------------------------+ ¦ ¦ ¦Bee Cee ¦ ¦ ¦ ¦ Private Pension Plan percentage : 0.00: ¦ ¦ Registered Pension Plan No : : ¦ ¦ ¦ ¦ Medical Plan No 1 deduction : 0.00: ¦ ¦ Medical Plan No 2 deduction : 0.00: ¦ ¦ Dental Plan deduction : 0.00: ¦ ¦ Optional Deduction No 1 : 0.00: ¦ ¦ Optional Deduction No 2 : 0.00: ¦ ¦ Court Ordered Maintenance Pymt. : 0.00: ¦ ¦ Recurring Debt No 1 - Total: 0.00: Paid: 0.00: Payment: 0.00: ¦ ¦ Recurring Debt No 2 - Total: 0.00: Paid: 0.00: Payment: 0.00: ¦ ¦ ¦ ¦ Union Dues : 0.00: per Hour ¦ ¦ Union Dues : 0.00: per Month Union ID : : ¦ ¦ ¦ ¦ Automatic HP calculation (Y/N) : : ¦ ¦ Type of Payment - Bank (T)ransfer, (C)heque, (P)ay slip, ( )default : : ¦ +------------------------------------------------------------------------------+ (P)roceed to next screen or (C)orrect ( ) |
Some companies are deducting RRSP contributions from their employees. To use this feature, ENTER 'RRSP' in the pension plan number field. When you run the payroll the computer will ask you for the amount of the contribution under the Pension deduction slot. At the end of the year this amount will be shown on the bottom of the T4 slip and not under the Pension Contributions. You will be able to use either the RRSP feature or the Pension Deductions in the year, but not both.
The maximum deduction for the year will be changed in the Annual Updates for both the Pension deduction and the RRSP deduction as the government regulations are changed.
If you have any other type of calculation write a custom dBASE V program called PTPENA.DBO.
The second method is by HOURLY deductions at a rate of so much per hour. The computer will calculate this deduction based on all the hours worked in the period. Enter the hourly deduction in the amount field and 'H' after the word "per".
The third Method is a combination of both HOURLY and MONTHLY dues.
If any other method is used you will have to use the KEY feature to enter the Union Dues or write a custom dBASE program called PTUNNA.DBO.
PAYTIME 2:12:33 pm +------------------------------<EMPLOYEE FILE>---------------------------------+ ¦ ¦ ¦ YEAR to DATE INFORMATION ¦ ¦ +------------------------------------------------------------+ ¦ ¦ ¦ Regular Pay......: 0.00: Overtime Pay.....: 0.00: ¦ ¦ ¦ ¦ Commissions......: 0.00: Double time Pay..: 0.00: ¦ ¦ ¦ ¦ Holiday Pay......: 0.00: Non-taxable Pay..: 0.00: ¦ ¦ ¦ ¦ Other Pay........: 0.00: GROSS PAY........: 0.00: ¦ ¦ ¦ ¦ CPP Exempt Earn..: 0.00: E I Earnings......: 0.00: ¦ ¦ ¦ ¦ Income Tax.......: 0.00: E I Weeks..........: 0.0000: ¦ ¦ ¦ ¦ C.P.P..............: 0.00: E I Ded............: 0.00: ¦ ¦ ¦ ¦ Pension/RRSP.....: 0.00: Medical No 1.....: 0.00: ¦ ¦ ¦ ¦ Dental Plan......: 0.00: Medical No 2.....: 0.00: ¦ ¦ ¦ ¦ Union............: 0.00: Quebec Tax.......: 0.00: ¦ ¦ ¦ ¦ Optional Ded 1...: 0.00: Optional Ded 2...: 0.00: ¦ ¦ ¦ ¦ Other Deductions.: 0.00: Est.Txble Bnfts..: 0.00: ¦ ¦ ¦ ¦ Holiday Bank.....: 0.00: Hols Paid To......: / / : ¦ ¦ ¦ ¦ Employment Weeks...: 0.0000: Hours Worked.......: 0.00: ¦ ¦ ¦ ¦ Vacation Hours.....: 0.00: Staty Hol Hrs......: 0.00: ¦ ¦ ¦ ¦ Sick Time Hours....: 0.00: Lieu Time Hrs......: 0.00: ¦ ¦ ¦ +------------------------------------------------------------+ ¦ +------------------------------------------------------------------------------+ (C)orrect Year to Date, (N)ext employee or (E)nd entries ( ) |
If you are entering data, or you are reviewing the information, the following message will show on the bottom of the screen:
|
Press <N> to enter/ review another Employee.
PAYTIME 01/01/87 P R I N T I N G E M P L O Y E E I N F O R M A T I O N -------------------------------------------------------------------------------- LOAD printer with 8 1/2" x 11" paper Press 'L' for a listing of EMPLOYEES Press 'D' for a detailed record of EMPLOYEE(s) Press 'T' for TRIAL BALANCE of Employee Information Press 'C' for CUSTOM Report on Employee File -------------------------------------------------------------------------------- Enter your selection or (R)eturn to master menu : : |
If you wish to design a custom dBASE report, name the program PTREPRTA.DBO.
PAYTIME 01/01/87 P R I N T I N G E M P L O Y E E I N F O R M A T I O N -------------------------------------------------------------------------------- Press 'A' for a listing of all EMPLOYEES on the FILE Press 'C' for a listing of all EMPLOYEES of one COMPANY Press 'S' for a SENIORITY listing of one COMPANY -------------------------------------------------------------------------------- Enter your selection or (R)eturn to master menu : : |
ENTER Company No. : : |
|
(Company Name) Is this the correct COMPANY (Y/N) : : |
Press <Y> and the Employee list will print.
PAYTIME 01/01/87 P R I N T I N G E M P L O Y E E I N F O R M A T I O N -------------------------------------------------------------------------------- Press 'A' for a detailed record of all EMPLOYEES on the FILE Press 'C' for a detailed record of all EMPLOYEES of one COMPANY Press 'E' for a detailed record of one EMPLOYEE -------------------------------------------------------------------------------- Enter your selection or (R)eturn to master menu : : |
Press <C> to print a detailed record of all EMPLOYEES of one COMPANY.
Press <E> to print a detailed record of one EMPLOYEE.
If <C> or <E> is selected the following message
appears:
ENTER Company No. : : Enter the Employer Identification |
|
(Company Name) Is this the correct COMPANY (Y/N) : : |
Press <Y> if the Employer is correct.
If <A> All selected the report will be printed.
If <C> or <E> selected the system will prompt:
ENTER Employee No. : : Enter the Employee Identification |
|
(Employee Name) Is this the correct EMPLOYEE (Y/N) : : |
Press <Y> will print out the Employee detail report.