Home

User manual

1. CER tene CER ren e CES EL 28 1 Pay nine E d sitos oso p ou ne sud ooa det nasce d trs sr 32 12 G ledger general ledger esses 41 Doe ReDOFIS Loco oie ob pti ae ane iati pie ne 44 Previous pays with corrections allowed 45 Detailed or summary payroll results for a given period of time 46 List of all pays with possibility to erase cancelled pays 49 List of pays for an employee before a date can be used to establish an amount for a statutory holiday Tm 50 Source deductions and employer contributions to 53 Source deductions and employer contributions to 55 VSPS 2013 13 Reports con t TA odi eic elc cid il Eu uL te e unc uu ud e ui UL e DE EMT 56 pili era AT 59 Detailed vacation to pay to an employee 63 Vacation to pay at a certain date for selected employees 65 Record of employment ROB ioter onto ordena reir rati rir rationi 68 ERLA ONLI SSSR EE Re E E UEM E m eU cue 75 Hour and cost report for a selected 77 14 Database menu Change paSSWOrd
2. icon of the main VSPS window Remember that you can create as many projects as you wish In the time sheet for a pay period you can select up to 5 different projects to allocate hours The Project 1 Miscellaneous is always present because it represents the default project This is why in this section there are 6 zones to enter hours To be able to enter hours in a zone other than the one for Project 1 first you must select the project in the scrolling list Then you have to reduce hours for Project 1 for this day For example if the employee worked 8 hours on a given day by clicking on the Hour distribution per project tab 8 hours are automatically displayed in Project 1 because it is the default project Miscellaneous If you wish to attribute 3 hours to Project 2 you must first enter a maximum of 5 hours in Project 1 zone otherwise the program will refuse to allocate time to Project 2 30 VSPS 2013 In this screen there is also a function to transfer all Project 1 hours the default project in another project This speeds up the distribution of hours if the employee did most of his hours for a specific project When you quit this tab if a line does not balance the difference is attributed to Project 1 Miscellaneous Note that when you have attributed hours to different projects it becomes possible to generate a report to establish hours and costs for a selected project during an interval o
3. As indicated in these circumstances you must quit the VSPS program restart VSPS and select the Compress database function again If the program still denies compacting the database this means that you must shut down your computer and restart it Then it will be possible to compress the database Note that the payroll database can not be compressed by other software Winzip etc because the database is encrypted Repair database Even if this is rather rare sometimes database problems can occur for various reasons power failures surges etc The present function allows you to try repairing the database A message is displayed whether or not this operation was successful Note that when a database is repaired it is also compressed CONFIRMATION 1 The database File 000000 Canada Inc 13 DL7 was successfully repaired Figure 14 03 Message displayed after a successful database repair 81 VSPS 2013 Erase all data related to an employee Sometimes an employer has created a new record in the employee records but this person changed his mind and never came to work for the company The present function is used to delete all information related to a person in the payroll database For security purposes if the payroll database contains at least one pay for this person the VSPS program denies this operation to avoid possible errors Nevertheless if for a certain reason you wish to erase all data concerning an
4. Delete on your keyboard Concerning vacation when you want to enter this kind of payment you have to double click on the cell in the vacation column or press F3 This will display the data entry screen for the vacation payment To know how to proceed in this screen please refer to chapter 15 in section You have to pay an amount for annual vacation 33 VSPS 2013 In the case of a final payment of vacation when an employee is terminated prior to processing his final pay it is very important to go in the employee s record to select Employment termination for the type of vacation pay This way after this pay there will be no vacation balance for this employee In Quebec remember that the employer must calculate a vacation amount on each amount paid including vacation pay except in the case of a vacation pay given when the employee is terminated From the pay window you can always access the employee s record by positioning the cursor on this employee s line and clicking on the Employee button By default in the pay window all the columns are displayed However it is preferable to hide all the columns that you do not use in order to reduce the number of fields to scroll and accelerate moving through the window To hide unnecessary columns you must click on the Config button In the next screen displayed simply unselect the columns that you do not want to appear in the pay window A selected box means that this
5. It remains very important to verify the hourly rate and to obtain the same net salary amounts Remember that in the pay window if a calculated amount i e the federal income tax is different from the amount really withheld before you can enter this amount In these circumstances a red star is displayed beside the overwritten field With this option the vacation pay balance to enter in the Previous window is the one at the beginning of the year Second option When you have several employees and there are many pay periods before the use of VSPS you can choose to enter only the cumulative payroll results from the beginning of the year until the last pay day registered in the previous payroll system Of course proceeding this way will not enable you to generate detailed reports for this interval of time Concerning the vacation pay balance to enter in this window with this option the amounts must be those at the conversion date at the end of the use of the previous payroll system Whatever the option you decide to use remember that you must even enter information for employees that worked during the year but no longer work for the enterprise because this way you will be able to generate year end reports T4 etc for all employees 25 VSPS 2013 9 Config cheque printing configuration Customized cheque for printing 000000 Canada Inc Company Name Company Address 1st line Company Address 2nd
6. Save Save the current file in another directory Location of file Drive Be Directory C C3XVSPS 2013 DEMO amp Backup Figure 5 01 Screen to save a payroll database in another folder It is important to note that with the VSPS software all data is saved automatically in the database Each modification is saved immediately Therefore you do not have to select the present function to save your data In fact this function is used to save a backup copy of the payroll database file with the extension DL7 in a different folder from the current directory To save a copy of the payroll database first you must click on the Save icon of the main window Once in the selection screen you must choose the folder and click on the Save button Finally remember that it is very important to regularly make a backup copy of the VSPS 2013 complete folder since it also includes other important information in the subdirectories You should always make external backup on a CD DVD or other device The best thing is to preserve this backup in a different location in case of fire theft etc VSPS 2013 6 Company business information This window is used to enter different information about the business Note that a field with a blue background is an obligatory field It is still recommended to fill out all applicable fields For example if you wish to print the business address on your pay cheques this inform
7. CCQ monthly report part 1 Employer s monthly report summary Employee contribution to a registered pension plan RPP _ Employer contribution to registered pension plan D 1454 95 Employer contribution for insurance _ 85281 7 Social benefits total of column in the detailed report 8 Sales tax on insurance 9 Special compensation fund 10 A E C Q hourly contribution 11 A E C Q annual contribution 12 GST on A E C Q contribution 13 QST on A E C Q contribution 14 CCQ Vacations and general holidays pays 15 Levy 16 Union contributions 17 Qualification fund 18 Training fund 19 Sectorial contribution wN N eo amp 2 Period Sunday 26 05 2013 to Saturday 29 06 2013 To restore an overwritten formula press F8 being in that cell Figure 16 13 Third tab of the screen used to fill out the CCQ monthly report 105 VSPS 2013 It is important to print the data in the second tab results per employee and the data in the third tab summary and total amount to pay In both cases you have to click on the Print button at the bottom of the screen Then you will be able to fill out the official CCQ monthly report because you will have all the needed information It is recommended to fill out the CCQ monthly report directly on their website http www ccq org Finally for those who have not purchased the option to have the VSPS CCQ monthl
8. Of course most of the time many account numbers remain the same from one department to another For this reason VSPS enables you to copy account numbers used in a department to another department To do so you must click on the Copy to another department button For example you could copy the GL account numbers that you entered for department 1 and then paste them for department 2 Then for department 2 you simply have to change the account numbers that differ from the ones used for department 1 This way to proceed is not only faster but reduces the risk of errors When you select a department the program displays a data entry screen to enter all basic default GL account numbers Most of them are obligatory account numbers in order to be able to generate payroll journal entries You must remember that if you do not enter a specific GL account number for an element the program will use the default GL account number For example if no specific GL account number is entered for the federal income tax VSPS will then affect the GL account number for Federal source deductions and employer contributions to pay The following figure illustrates the basic GL account numbers used when you do not enter any specific GL account number GL account numbers 000000 Canada Inc Account numbers in Accpac Simply Simple Comptable for department 1 Sales Selection Basic accounts Earnings Benefits Deduct Employercontrib The
9. Schedule of wages B 3 Industriel Status code if applicable None gt no code for a construction employee Code for work region 07 Estie e Union s name ex CSN CSN Employer contributions related to CCQ field of construction in Qu bec This information is used to produce the CCQ monthly report Pension per hour Insurance per hour 2 170 Qualification fund per hour 000 Sectorial contribution per hour gt 04 for the employer if residential sector otherwise 0 Contribution to AECQ per hour Special compensation fund per hour Training fund per hour CCQ Levy of gross earnings Paydates Calendar Quit Figure 16 08 Other information needed to produce the monthly report to submit to the CCQ It is important to make sure to enter all the data including the employer contributions payable to the CCQ pension insurance and qualification fund This information is essential to generate the CCQ monthly report Please note that some information those written in gray are already entered and can not be modified because they are determined automatically by the software 99 VSPS 2013 When all required information is entered in the employee s form it then becomes possible to process the payroll for this employee In the pay window Pay icon in the VSPS main window if you have at least one employee working in the field of construction in Qu
10. 2 200 He is allowed 2 weeks of vacation This employee decides to take his vacation and wants to receive his full vacation pay If his employer pays this amount plus his regular pay on the same pay cheque the total earnings will be 3 000 In order to avoid the calculation of the income tax on a weekly salary of 3 000 the program offers another method to calculate the income tax In this example with this method the income tax would be 3 times the amount based on the average earnings of 1 000 per week 3 000 for 3 weeks because the employee is working one week and on vacation 2 weeks without being paid Federal Quebec Total earnings before vacation pay Vacation pay 2 000 00 2 000 00 Total taxable income Number of pay periods for which the employee will not receive any pay Do you wish to use this method to calculate the income tax if you select no the income tax will be calculated normally Figure 16 01 Data entry screen to register a vacation amount 87 VSPS 2013 If you select the method based on the average remuneration the Results tab will allow you to see some information on the income tax calculation Also the difference between the two income tax calculation methods will be shown Informations about a vacation pay Function Current file 2 Mary Something Period 4 From 13 01 2013 to 19 01 2013 Cheque 24 01 2013 Therefore these earnings cover 3 00 pay periods For fede
11. 21 03 2013 03 03 2013 08 03 2013 14 03 2013 24 02 2013 02 03 2013 07 03 2013 17 02 2013 23 02 2013 28 02 2013 10 02 2013 16 02 2013 21 02 2013 03 02 2013 08 02 2013 14 02 2013 27 01 2013 02 02 2013 07 02 2013 20 01 2013 26 01 2013 31 01 2013 13 01 2013 18 01 2013 24 01 2013 06 01 2013 12 01 2013 17 01 2013 30 12 2012 05 01 2013 10 01 2013 23 12 2012 29 12 2012 03 01 2013 16 12 2012 22 12 2012 25 12 2012 09 12 2012 15 12 2012 18 12 2012 02 12 2012 08 12 2012 11 12 2012 25 11 2012 01 12 2012 04 12 2012 18 11 2012 24 11 2012 27 11 2012 11 11 2012 17 11 2012 20 11 2012 1 2 3 4 5 6 8 CC ECHTE E 1 993 81 76 73 To restore an overwritten formula press Delete on this cell To go to the employee time sheet double click or press F3 on any hour cell Figure 13 28 Last part of the ROE worksheet 73 MISES VSPS 2013 Once the verification is done in the worksheet primarily for the insurable hours for El and the El insurable earnings it is recommended to print this worksheet and to keep it for your records with a copy of the The next step is to click on the Results for the ROE tab The program displays a report very similar the ROE form which makes it easy to fill out the official form Worksheet for the Record of employment ROE 000000 Canada Inc SEE Function Information for the ROE paper format of 1 John So And So Employee selectio
12. Employee number Current file 2 Mary Something Regul T172 Select hours hours T2 hours 1 John So And So 2 Mary Something TOTAL 0 00 62 0 0 62 14 To go to the employee time sheet double click or press F3 on any hour cell Figure 13 02 Previous pays with corrections allowed report 45 VSPS 2013 In this report you can even modify data for a selected pay period To do so in the Select column you must select each employee you want to make a correction for and click on the Edit button Then the pay window is displayed and only contains information about the chosen employees You can make the necessary corrections and even print new cheques Once all corrections are made do not forget to click on the Report button to save your changes in the payroll database After you posted your corrected payroll data it is important to quit the pay window and to return in the Previous pays with corrections allowed report to reprint the corrected pay reports Moreover if needed you can create a new file of journal entries If you also have to correct payroll journal entries in your accounting software for this pay period you could reverse these payroll journal entries To know how to proceed please refer to chapter 11 Finally if you have forgotten an employee in a pay prior to the current pay period this kind of correction can not be done in the Previous pays with corrections all
13. this report calculates hours and project costs for a given interval of time You can apply criteria for this report such as the selected employees the type of results the interval of time etc Hour and cost for a selected projet Function Detail per employee Yes Detail per pay Yes Pay frequency All pay frequencies Period for report Year to date cheque dates Type of results Per pay results Employees Project 1 Miscellaneous From January 1st 2013 to December 31 2013 Hour and cost per projet Regular T172 Name Pay period Hours hours at hours at rate 1 rate 2 rate 1 rate 1 John So And So 1 Cheque 03 01 2013 Mary Something 1 Cheque 03 01 2013 John So And So 2 Cheque 10 01 2013 Mary Something 2 Cheque 10 01 2013 John So And So 3 Cheque 17 01 2013 Mary Something 3 Cheque 17 01 2013 TOTAL Figure 13 32 First part of the Hour and cost report for a selected project 77 VSPS 2013 Hour and cost for a selected projet Function Pay frequency All pay frequencies Detail per employee Yes Detail per pay Yes Type of results pay results Period for report Year to date cheque dates Employees All Project 1 Miscellaneous From January 1st 2013 to December 31 2013 Hour and cost per projet T2 hours Total hours Cost for this Name Pay period nt mio 2 for this project project John So And So 1 Cheque 03 01 2013 750 0
14. 06 01 2013 2 30 12 2012 1 23 12 2012 52 16 12 2012 51 09 12 2012 50 02 12 2012 49 25 11 2012 48 18 11 2012 47 11 11 2012 23 03 2013 16 03 2013 03 03 2013 02 03 2013 23 02 2013 16 02 2013 03 02 2013 02 02 2013 26 01 2013 19 01 2013 12 01 2013 05 01 2013 29 12 2012 22 12 2012 15 12 2012 08 12 2012 01 12 2012 24 11 2012 17 11 2012 28 03 2013 21 03 2013 14 03 2013 07 03 2013 28 02 2013 21 02 2013 14 02 2013 07 02 2013 31 01 2013 24 01 2013 17 01 2013 10 01 2013 03 01 2013 25 12 2012 18 12 2012 11 12 2012 04 12 2012 27 11 2012 20 11 2012 388 00 375 00 362 00 388 00 375 00 375 00 1 001 00 325 00 937 50 337 50 387 50 337 50 337 50 337 50 337 50 937 50 337 50 937 50 937 50 388 00 975 00 962 00 388 00 975 00 375 00 1 001 00 325 00 337 50 337 50 387 50 337 50 337 50 337 50 337 50 337 50 337 50 337 50 337 50 25 651 50 1917 08 To restore an overwritten formula press Delete on this cell To go to the employee time sheet double click or press F3 on any hour cell Figure 13 27 Third part of the ROE worksheet As we can see from the previous figure in this worksheet there are also columns for the insurable hours for El and the El insurable earnings Note that you are allowed to modify amounts in these columns For example if for a given pay period an employee received an amount registered in the Other income 1 statutory holiday etc c
15. 27 9 From 17 02 2013 to 23 02 2013 1 582 27 1 621 27 10 From 24 02 2013 to 02 03 2013 1 621 27 i 1 660 79 11 From 03 03 2013 to 09 03 2013 1 660 79 1 699 27 12 From 10 03 2013 to 16 03 2013 1 699 27 1 736 2 13 From 17 03 2013 to 23 03 2013 1 738 2 x led TOTAL 1 276 73 501 06 Eoo TE Figure 13 20 Second part of the Detailed vacation to pay to an employee report As shown in the figure above notice that in this report if necessary in the Adjustment column you can even enter a positive or negative amount to affect the balance 64 VSPS 2013 Vacation to pay at a certain date for selected employees This report displays the detailed vacation amount to pay to selected employees at a certain date By default all employees are included and the report date is the end of the calendar year However as shown the following figure if you click on the Criteria tab it becomes possible for you to select employees and enter the date you wish to use to calculate vacation amounts to pay Selection Vacation to pay for selected employees 000000 Canada Inc Function Report selection Criteria All pay frequencies All employees C 1st pay frequency weekly C Selection by employees 2nd pay frequency none C Selection by departments ex 1 3 5 for departments 1 3 and 5 o C Per group None i Year to date From To From January 1
16. 4 decimals Employee profile Construction 12345 Qc Inc Cu ps gt Employee number Find next Current file 1 John One Basic Incomes Benefits Deduct Fed incometax Prov incometax Miscell Pay frequency Weekly 52 or 53 pays per year Y Pay type Hourly or fixed salary Fixed salary per pay period Regular hourly rate Time and half 11 2 after hours Double T2 after hours For any subsequent change or to add new rate click here gt Other earnings per pay Other income 1 Safety equip C 590900 per hour not taxable z Other income 2 Fixed amount taxable Vacation Rate 1 ex if 4 enter 4 at beginning of the year Rate 2 if it changes during the year effective from dd mm yyyy Type of vacation pay Paid later Figure 16 04 Example of the non taxable income for the safety equipment 95 VSPS 2013 The next step is to click on the Benefits tab On the line Other taxable benefits for PROVINCIAL only first select per hour Then you will be able to enter the amount with a possibility of 4 decimals Employee profile Construction 12345 Qc Inc ER 2 Name On c Employee number Current file 1 John One Basic Incomes Benefits Deduct Fed incometax Prov incometax Miscell Benefits income not paid but taxable Board and lodging Fixed amount Other taxable benefit
17. In this last case you simply have to enter the first cheque number and the program automatically enters the following numbers If the employees are paid by cheques even manual cheques the next step is to click on the Cheques button to display the cheques and pay stubs print screen In this screen you can select employees one by one or per department The Print detailed stubs button allows you to give to each of the employees a more detailed pay stub because there is no space constraint as opposed to a pay stub on a cheque By clicking on the Export detailed stubs you can create a detailed pay stub in text format for each of the employees Then you can send this by email Do not forget to provide the pay stubs to your employees A pay stub contains the current and the cumulative payroll results 36 VSPS 2013 It is very important to remember that if you want to reprint a pay cheque for a previous pay period you must not proceed in the pay window but rather from the report function using the Previous pays with corrections allowed report For more details please refer to chapter 13 If you have forgotten an employee in a pay prior to the current pay period this kind of correction can not be done in the Previous pays with corrections allowed report In this case please refer to chapter 15 in section You forgot an employee in a previous pay period If some employees are paid by direct deposit instead of by cheque
18. T 2013 Number of slips Contributions to QPP Employee s contribution 1 1414 Employer s contribution 2 1149 64 Contributions to QPIP Employee s contribution 11 74 Employers contribution Quebec Income tax Relev 1 10 230674 Relev 2 CT 00 Subtotal Payment made for QPP QPIP and Quebec Total Contribution to the Quebec health services fund QHSF W ages paid or deemed paid 24 291 50 Wages exempted is Wages subject to the QHSF Payment made for QHSF If this is a MODIFIED Summary select this box gt M 4 gt To restore an overwritten formula press F8 on this cell Figure 13 16 First part of the worksheet used to fill out the Relev 1 Summary 61 VSPS 2013 Relev 1 Current file 1 John So And So ME Function Search Employee number Slip number 190000016 Relev 1 slip Summary Summary of source deductions and employer contributions con t Contribution to the financing of the Commission des normes du travail CNT Remuneration subject to this contribution calculated on form LE 39 0 2 x 08 41 19 43 Contribution to the Fonds de d veloppement et de reconnaissance des comp tences de la main d oeuvre FDRCHD Remuneration if it exceeds 1 000 000 x 1 Eligible training expenditures please fill out the work chart E Line 51 minus line 52 if negative 0 Addition or subtraction of lines 27 39 41 and 53 Balanc
19. app Em m m m Employee s name and address So And So John RPP contributions line 207 Charitable donations Schedule 1 123 Main Street 5 here QC TREI JOZ Pension adjustment line 206 RPP or DPSP registration 50 Employee s premiums QPIP insurable earnings Note 2 7 If this T4 is CANCELLED select this box gt 4 E aga N e N e e n2 ceo co P A ce N Nm e Box Box2 Box3 PL ol pE Box4 Box5 Box6 CRE 00 Kd gt To restore an overwritten formula press F8 on this cell Figure 13 11 T4 slip This function allows you to issue T4 slips It is very important to install the last VSPS upgrade in order to be sure to use the last authorized T4 version for this year This upgrade is usually available at the beginning of January for example January 2014 for 2013 T4 slips To move through the T4 slips you can click on the scrollbar at the bottom left hand side You can also use the search box It is even possible to change a calculated amount except if the field is greyed out implying the field is disabled In this case a red star beside the box would be displayed to indicate an overwritten cell To restore the calculated amount to an overwritten field simply select this field and press F8 At the bottom of the slip you can enter codes and notes 56 VSPS 2013 When you select the Print button the print
20. aut Figure 7 02 Incomes tab of the employee record With VSPS an employee can be remunerated on an hourly rate and or fixed salary The program even allows you to pay an employee with two different hourly rates For example in the restaurant business a person could have an hourly rate for hours worked as waitress and another rate for hours worked in the kitchen The second hourly rate must be entered in the addendum of the employee record To display this window you have to click on the Modify button In the field Pay type there is a choice to indicate that the employee will be paid mainly by commissions If this is the case do not forget to fill out the required information in the Fed income tax tab estimated total income and expenses for the year in form TD1X It is important to note that when the hourly rate or the fixed salary changes for example when a pay raise happens you must not enter this modification directly in the employee record window because in this screen the amount is the one effective at the beginning of the year Instead you must enter this in the Addendum window by clicking on the Modify button see figure 7 03 18 VSPS 2013 With the program you can register up to 3 salary changes during the year However if an employee has more than 3 salary changes in a year you can always use the second hourly rate if the employee is paid on only one hourly rate When you registe
21. cell and press Delete on your key board 32 VSPS 2013 New 000000 Canada Inc MALE Function Pay window Instructions for the pay window Pay Period gt frequency ET number From January 6 2013 to January 12 2013 Date of cheque 17 01 2013 January 17 2013 Name Search On C Employee number Current file 1 John So And So CPP or pensionable earnings Other Vacation Total earnings Basic salary income 1 before benefits 1 John So And So 2 Mary Something 1 911 50 LATTES EE 1 911 50 To restore an overwritten formula press Delete on this cell To go to the employee time sheet double click or press F3 on any hour cell 14 DR CR s123 Erase Cheques Direct Post Confio Print Employees Calendar Quit Figure 11 02 Other part of the pay window As soon as you enter the hours VSPS calculates the basic salary fixed salary and or hours multiplied by the hourly rate other incomes and all the source deductions El income tax etc Note that in the case of an employee paid by fixed salary you must enter the number of hours worked in order to have the incomes and deductions calculated otherwise the fields will remain blank As mentioned before you can modify a calculated field except in a column with a yellow background Remember that to restore an overwritten entry you simply have to position the cursor on the cell and press
22. description the deduction will be named Other deduction X X representing a number from 1 to 10 Even if most of the time these deductions are non deductible for income tax matters if needed you can select a box in the right hand side to indicate that this deduction is tax deductible Federal or Provincial Business profile information 000000 Canada Inc ER Function Basicinfo Pay Departments Groups Other income and deduct Projects CSST Otherinfo This screen allows you to name other incomes and other deductions max 20 car Other income 1 1 Other income 2 Po The program already contains the standard deductions union RPP RRSP etc but you can use up to 10 other deductions Note that normally these other deductions are non deductible for income tax matter However if a deduction is tax deductible click to select the box beside the line Deductible for income tax Federal Provincial Other deduction 1 Other deduction 2 Other deduction 3 Other deduction 4 Other deduction 5 Other deduction 6 Other deduction 7 Other deduction 8 Other deduction 9 Other deduction 10 Calenda The Other income deduct tab of the business information window Figure 6 05 13 VSPS 2013 The Projects tab is used when you want to compile in the time sheets hours and costs related to certain activities For example this is useful for any business that is claiming
23. dues Parity committee or similar body Group insurance Registered pension plan RPP Registered retirement savings plan Retirement compensation arrangement Labour sponsored funds Charitable donations Reimbursement of advances For other deductions click here Other deductions L Pay dates Export basic info_ New employee Calendar Qui Figure 7 05 Deduct tab of the employee record 21 VSPS 2013 It is important to notice that one of the interesting features of VSPS is the power offered for deduction calculation As shown in the following figure for any type of deduction you can define the calculation on several bases For example a deduction could be a fixed amount per pay plus an amount per hour plus a percentage of the total income In fact it is possible to use up to 8 bases to calculate a deduction You can even register a minimum and a maximum amount per pay period Calculation rules for a deduction Function Current file 1 John So And So Union or professional dues Calculation rules The present window is used to indicate the rules to calculate the amount to be paid for a certain deduction As you can see this amount can be established on several bases For example this amount of deduction could be a fixed amount per pay PLUS another amount per hour You simply have to enter the amounts in the applicable boxes and leave the other ones at 0 Amount per pay Amount per mont
24. earned during the four complete weeks of pay preceding the week of the holiday excluding overtime However it is essential to consult the laws in effect in your province to be sure to properly calculate the amounts to pay With the VSPS software to calculate the indemnity for a statutory holiday you have to go in the main window click on the Reports icon and select the report List of pays for an employee before a date can be used to establish an amount for a statutory holiday For more information on this report please refer to page 50 of this manual Furthermore with the VSPS program when you want to pay an amount for a statutory holiday to an employee you can proceed in different ways If the employee is remunerated on an hourly rate and you are using the VSPS time sheet you can enter the hours paid for this statutory holiday in the Adjustment hours column and write a note in the following column to describe the holiday However some employers prefer that this kind of payment be displayed distinctly in the pay report To do so they calculate the gross amount to pay for the statutory holiday and enter this amount in the Other income 1 column of the pay window Then it is preferable to explain the calculation in the Notes column of the pay window i e 8 hours paid for Christmas Day With this method it is important to not forget to modify the Insurable hours for E l to include the hours related to the statutor
25. employee even if you registered payroll data for this employee i e if you registered this employee in the wrong company you can still do it To proceed you have to select in the report selection List of all pays with possibility to erase cancelled pays and erase every pay for this employee Then it will become possible to use the present function to erase all information related to this employee Replace an employee number by the one he had in the previous year This function is used in a very specific situation Let us recall that when you select the Create a new database for next year carry forward function the program transfers information for all employees except the ones indicated as terminated in the employee records Employees icon in the main window of the program When a former employee terminated in the year before comes back to work but in the previous year you have indicated in the employee record that he was terminated the payroll database of the current year does not contain any information for this employee For this reason you must recreate an employee record for this person Since the employee numbers are attributed by the program this former employee will receive a different employee number higher than the previous one because the program increments the number each time a new employee record is created For some VSPS reports it is very important that an employee preserves the same employee number fr
26. end of pay period dates option For example in these circumstances if you choose For a month and select the month of March the program generates the report by including payroll results of each pay period ending in March even if the cheque date is in the next month April This possibility is useful when you have to fill out certain reports like the employee contributions to pay to a parity committee for a given month because for these kinds of reports you have to proceed on the end pay period date instead of cheque dates 47 VSPS 2013 In the Criteria selection window since the program offers many different options it becomes easy to obtain payroll results on different criteria For example in the case of a manufacturing business if you wish to compile payroll results for direct labour costs you can select only employees to be included in the report In these circumstances if you have separated your employees per different department numbers in the employee records you could make the report selection by departments which is a lot faster You could also use the Per group option As mentioned before in the Company window there is a tab to create as many groups as you want for example union parity committee professional associations etc Then in the employee s record if you wish you simply have to indicate in what group an employee must be included This allows you to generate reports for a selected group If y
27. entries for this pay period in your accounting system you have to reverse these journal entries If you are not familiar with the procedure please consult chapter 11 If you need to correct a previous pay the procedure is somewhat different First in the main VSPS window you must click on the Reports icon Then you have to select Previous pays with corrections allowed and click the Continue button Entering in this report the program always displays the first pay period To advance to the desired period you must click on the pay period scrollbar and click the Confirm button The next step is to click on the Select box for each employee you wish to make a pay correction Then you have to click the Edit button As you do the program displays the pay window However in this screen only the selected employees appear You can then make the modifications and even print new cheques Remember that once the modifications are done you must click on the Post button to save your new changes in the payroll database Following your modifications it is important to quit the pay window to return to the Previous pays with corrections allowed report After selecting the period you can reprint the pay reports summa report detailed earnings etc and create a new payroll journal entries file As explained above if you have imported journal entries for this pay period in your accounting system you must reverse these journal
28. in this screen once you have selected the employees you must click on From to and enter the cheque date of the pay period that includes the end date of the reference year Remember that in order to help you to find the cheque date to enter the Pay dates button enables you to consult for each of the pay periods the beginning date the end date and the cheque date Selection Vacation to pay for selected employees 000000 Canada Inc Function Report selection Criteria All pay frequencies All employees C 1st pay frequency weekly C Selection by employees Reset selection C Selection by departments ex 1 3 5 for departments 1 3 and 5 Per group None Year to date From From 01 01 2013 January 1st 2013 To 30 04 2013 dd mm yyyy Select Name Pay frequency Job title John So And 50 Salesman Mary Something Bookkeeper F Pay dates Continue du Criteria for the Vacation to pay at a certain date for selected employees report Figure 15 01 As you click the Continue button the program displays the annual vacation to pay for each employee 86 VSPS 2013 Sometimes an employee asks the employer how his annual vacation indemnity was calculated With VSPS it is easy to answer this kind of question In the report selection you have to choose Detailed vacation to pay to an employee For more information please
29. income not paid but taxable Board and lodging Fixed amount x Other taxable benefits for federal AND provincial Fixed amount Y Private health care insurance Quebec Fixed amount Other taxable benefits for PROVINCIAL only Fixed amount Y ther taxable benefits for FEDERAL only Fixed amount Y Poy dates Esport basic into_ Mew employee Calendar Figure 7 04 Benefits tab of the employee record 20 VSPS 2013 In the Deduct tab of the employee record first you have to indicate if the employee is exempt from Canadian employment insurance El Canadian or Quebec pension plan CPP QPP or Quebec parental insurance plan QPIP This window also permits you to register periodic deductions for an employee As mentioned in chapter 6 with VSPS the most popular deductions union dues group insurance RPP RRSP etc are already predefined but VSPS also allows you to use up to 10 other deductions To access the window for these other deductions you have to click on the Other deductions button Employee profile 000000 Canada Inc EEK i Name Search O On C Employee number Current file 1 John So And So Fed income tax Prov incometax Miscell Exemption for Canadian employment insurance C Yes No Exemption for CPP QPP Canadian or Quebec pension plan C Yes No Exemption for QPIP Quebec parental insurance plan Yes No Union or professional
30. it is also possible to register hours in columns for Rate 2 in the case of an employee remunerated on 2 hourly rates 29 VSPS 2013 Time sheet 000000 Canada Inc PRI Function Time sheet Hour distribution per project Name al C Employee number Pay Period frequency Weekly 52 or 53 pays per year Ln 3 From January 6 2013 to January 12 2013 Date of cheque January 17 2013 Time sheetfor Employee 1 John So And So Fixed salary 0 00 Hourly rate1 25 00 and Hourly rate2 0 00 Regular T1 2 T2 hours Regular T1 2 2 hours hours at hours at at rate hours at hours at at rate rate 1 rate 1 1 rate 2 rate 2 2 Total hours payable Sunday 06 01 2013 Monday 07 01 2013 Tuesday 08 01 2013 Wednesday 09 01 2013 Thursday 10 01 2013 Friday 11 01 2013 Saturday 12 01 2013 Two different formats are allowed to enter hours For example 10 30 hh mm or 10 50 fraction of hour To restore an overwritten formula press Delete on this cell Erase line Paste Print Qui Figure 10 03 Other part of the time sheet window Furthermore the Hour distribution per project tab allows you to allocate hours worked between different activities Scientific Research and Experimental Development training hours related to a certain customer etc As mentioned before all the projects must be created in the business information screen
31. last Record of employment 27 12 2010 December 27 2010 Last day of work 2 032013 March 22 2013 Final pay period ending date 23 03 2013 March 23 2013 Type of ROE Record Of Employment form ROE paper format max 27 pay periods for the insurable EARNINGS Figure 13 24 Selection for the Record of employment ROE report 69 VSPS 2013 If you used the VSPS software in the previous year you must enter the directory where you installed VSPS last year for example C VSPS 2008 Let us recall that this information has to be registered in the business information window icon of the VSPS main window When you choose the Record of employment ROE report you must select the employee by typing the name in the search box As soon as you begin to type the program starts displaying employee names and certain information S I N first day of work since the last ROE etc When you have selected the employee you must click on the Worksheet tab Then for each of the pay periods to be included in the ROE report if weekly 53 last weeks if by bi weekly 27 last pay periods etc the program displays the hourly rate the hours worked etc Note that as required by the government these pays are listed beginning by the most recent pay Worksheet for the Record of employment ROE 000000 Canada Inc Function Information for ROE paper format of 1 John So And So Employee selectio
32. screen is displayed As we can see in the following figure in this screen first you must indicate if you wish to print the T4 slips or the T4 Summary For the T4 slips printing if necessary you can select employees You must also choose the type of print one or two names per page Note that for the T4 slips to give to the employees you have to select 1 employee per sheet 2 copies because each employee must receive 2 copies of the T4 slip one to attach to his income tax form and one to keep for his records In other words you have to give every employee a sheet representing two T4 copies and the instructions sheet for the T4 boxes printed automatically by VSPS As for the copy to send to the Canada Revenue Agency with the T4 Summary you must always print 2 different names per page With this selection as required the program also prints the business number BN on each T4 slip The T4 slips produced by VSPS are authorized by Canada Revenue Agency You simply have to print them on white paper However be sure to use the last VSPS upgrade usually available in the month of January following the year end When you are printing the T4 slips the number beginning by RC must be followed by the last 2 digits of the year i e RC 13 for 2013 m T4 slips and T4 Summary print Function Print T4 slips FB Print T4 Summary All employees C Selection by employees Reset selection C Selection by de
33. 0 Mary Something 1 Cheque 03 01 2013 704 00 John So And So 2 Cheque 10 01 2013 Mary Something 2 Cheque 10 01 2013 John So And So 3 Cheque 17 01 2013 Mary Something 3 Cheque 17 01 2013 OA Figure 13 33 Last part of the Hour and cost report for a selected project 78 VSPS 2013 14 Database menu Change password The use of a password is optional However since pay information is confidential it is recommended to request a password to access the database The present function enables you to register or edit a password If you wish you can use a distinct password for each of the businesses that you process payrolls Note that if you ever forget your password you must contact us We can retrieve your password for you Finally because a password protection is never foolproof you should always restrict access to your payroll database Set password 000000 Canada Inc Please enter the new password max 15 characters Please enter the new password again for verification Screen to register or edit a password Figure 14 01 79 VSPS 2013 Create a new database for next year carry forward This function not only creates a new payroll database but also transfers all required payroll information for the next year employee records cheque print configuration vacation balance for each employee GL account numbers etc It is important to note th
34. 10 43 per pay 0 065 per hour Parity committee or similar body Group insurance Registered pension plan RPP 1 350 per hour Regist retirement savings plan RRSP Retirement compensation arrangement Labour sponsored funds Charitable donations Reimbursement of advances For other deductions click here gt Other deductions Export basic info_ New employee Calendar Quit Figure 16 06 Example for union dues and pension plan 97 VSPS 2013 Next at the bottom of the screen you must click on the Other deductions button A window will be displayed to define how to calculate the sectorial contribution and the CCQ Levy Once again this is only the portion paid by the employee do not include the employer s contribution For the sectorial contribution if the sector is residential the employee has no amount to pay In this case only the employer has to pay 04 per hour For any other sector industrial etc the employer has nothing to pay It is rather the employee that must pay normally 02 per hour Concerning the CCQ Levy the amount to pay by the employee is usually 7596 of the gross income excluding taxable benefits The contribution for the employer is the same as the employee Addendum Other information change of hourly rates etc Construction 12345 Qc Inc Function Current file 1 John One Sectorial contrib 0 020 per hour CCQ Levy 0 750 of gross earnings
35. 12 01 2013 Ch 17 01 2013 1 John So And So 4 End 19 01 2013 Ch 24 01 2013 2 Mary Something 4 End 19 01 2013 Ch 24 01 2013 1 John So And So 5 End 26 01 2013 Ch 31 01 2013 To go to the employee time sheet double click or press F3 on any hour cell LI Ll O Ll O m 0 2 OO OI OI Figure 13 05 List of all pays with possibility to erase cancelled pays report 49 VSPS 2013 List of pays for an employee before a date can be used to establish an amount for a statutory holiday This report is mostly used to establish the indemnity for a statutory holiday when the employee did not work the day of the holiday In Canada workers are entitled to an indemnity or a compensatory leave for each of the statutory holidays New Year s day Christmas Day etc For example in Quebec according to the Commission des normes du travail www cnt gouv qc ca usually the compensation to pay to an employee is 1 20 of the wages earned during the four complete weeks of pay preceding the week of the holiday excluding overtime However it is essential to consult the laws in effect in your province to be sure to properly calculate the amount to pay For this report you have to select the employee enter a cheque date and the desired number of pay periods preceding this date Report selection and criteria 000000 Canada Inc Sele F JNCCION Report selection Previous pays with
36. 2 or F me Period frequency Weekly 52 or 53 pays per year 3 From January 6 2013 to January 12 2013 Date of cheque 12 01 2013 January 17 2013 Name Employee number Insurable hours for EI 1 John So And So 2 Mary Something TOTAL 0 00 61 5 0 0 61 5 81 5 4 b To restore an overwritten formula press Delete on this cell To go to the employee time sheet double click or press F3 on any hour cell Figure 11 01 First part of the pay window When you open this window you must first select the pay period by clicking on the scroll bar and then click on the Confirm button that is only visible when a pay period changes The program displays the beginning date the end date and the cheque date of the chosen pay period Note that you are allowed to change the cheque date If you filled out a time sheet for an employee for this pay period the hours are already displayed in the pay window To modify this time sheet you can position the cursor in an hour column on the employee s line and double click on the cell or press F3 As we mentioned before you are not obligated to fill out the time sheets In fact you can enter directly the total hours in the pay window In these circumstances because this represents an overwritten entry a red star appears beside the hours amount To restore the hour calculation based on the time sheet like for any overwritten calculation you must position the cursor on this
37. 25 00 hour effective from 01 01 2013 January 1st 2013 Time and half T172 after o0 hours Double T2 after 00 hours New rate 26 00 hour effective from 14 02 2013 February 14 2013 Time and half T172 after hours Double T2 after hours New rate hour effective from dd mm yyyy Time and half T172 after hours Double T2 after hours New rate hour effective from dd mm yyyy Time and half T172 after hours Double T2 after hours Pap dates Calender Figure 7 03 Addendum for the employee record 19 VSPS 2013 Concerning the vacation rate because this rate can change during the year a box is reserved for any vacation rate modification It is important to note that you must not enter the new rate in Rate 1 field because this field is used for the vacation rate effective at the beginning of the year As indicated in the screen you must enter the new vacation rate in Rate 2 box and enter the cheque date of the pay period that includes this change Moreover the Benefits tab of the employee record permits you to register other periodic income that is not paid in money but must be included in the taxable income These amounts are considered in the income tax calculation and other source deduction i e CPP Employee profile 000000 Canada Inc ER gie C Employee number Deduct Fed income tax Prov income tax Miscell Benefits
38. 50 1 391 23 5 From 20 01 2013 to 26 01 2013 4 Paid later 337 50 1 428 73 B From 27 01 2013 to 02 02 2013 4 Paid later 325 00 1 466 23 From 03 02 2013 to 09 02 2013 4 Paid later 1 001 00 1 503 23 8 From 10 02 2013 to 16 02 2013 4 Paid later 975 00 1 543 27 9 From 17 02 2013 to 23 02 2013 4 Paid later 975 00 1 582 27 10 From 24 02 2013 to 02 03 2013 4 Paid later 988 00 1 621 27 11 From 03 03 2013 to 09 03 2013 4 Paid later 962 00 1 660 79 12 From 10 03 2013 to 16 03 2013 4 Paid later 975 00 1 699 2 13 From 17 03 2013 to 23 03 2013 4 Paid later 988 00 1 738 2 E 1252550 Vacation Period rate Figure 13 19 First part of the Detailed vacation to pay to an employee report 63 VSPS 2013 Detailed report for vacation 000000 Canada Inc Function 1 John So And So Vacation to pay Vacation Vacation Amount of Vacation 1 Period balance earned for vacation Adjustment balance at beginning this period paid the end 1 From 23 12 2012 to 29 12 2012 1 276 73 1 314 23 2 From 30 12 2012 to 05 01 2013 1 314 23 1351243 3 From 06 01 2013 to 12 01 2013 1361043 Tasia 4 From 13 01 2013 to 19 01 2013 LIRE 1 428 73 5 From 20 01 2013 to 26 01 2013 1 428 73 1 466 23 6 From 27 01 2013 to 02 02 2013 1 466 23 14509 23 From 03 02 2013 to 09 02 2013 1 503 23 1 543 27 8 From 10 02 2013 to 16 02 2013 1 543 27 1 582
39. 79 Create a new database for next year carry forward 80 Compress tu Sean en adiu catalan depend tn Leo us tu Mq a ve 81 Repar dala Da e s a dort e pd e ETE DARE THAN ai E Td dd Ud i e be nes 81 Erase all data related to an employee 4 44 82 Replace an employee number by the one he had in the previous 82 Delete the current pay table in the database and create a new one 83 15 What to do when You hire a iex pr tub le 84 You want to modify the salary or the vacation rate for an employee 84 You have to pay an amount for a statutory holiday 85 You have to pay an amount for annual vacation 85 NOUS L CORTE CL A DAY uade 89 You forgot an employee in a previous pay period 90 An employee quit definitively ses 91 You want to make a backup COPY nnn nnne enne err nnn nenne 91 16 Quebec construction worker rules 92 VSPS 2013 1 Terms and conditions As displayed when you install the VSPS software it is important to read the following terms and conditions COPYRIGHT and DISCLAIMER OF WARRA
40. B QuickBooks Simply Accounting etc For more details please refer to chapter 11 because the process is similar to the one for payroll journal entries As for the payroll journal entries the program always saves the journal entries export file in the subdirectory Export Business name XP of the VSPS folder by default C VSPS 2013 The name of this file is easy to recognize for example Payroll expenses Fed period 15 Freq 12 Export 001 TXT Furthermore the Criteria tab is used when the employer rate for Canadian employment insurance El in the case of certain employees is not the normal rate Let us recall that for 2013 normally the employer has to pay an amount representing 1 4 times the employee contributions Nevertheless when some employees are covered by a private insurance Canada Revenue Agency can reduce the employer El contribution for these employees In these circumstances the employer has 2 business numbers BN from the Canada Revenue Agency and must produce 2 remittance forms for each of the remittance periods The Criteria tab enables you to select employees depending on which remittance form you are filling out To facilitate the selection you can proceed by department selection if you have previously classified your employees per department based on the related business number in the employee records Finally it is important to remember that if the El employer contribution for an employee is different f
41. NTY because the installation will indicate your acceptance of the following terms and conditions COPYRIGHT Contrary to most softwares you are allowed to install VSPS on as many computers as you wish However the user has the right to process payrolls only for businesses that he bought an annual license for It is strictly prohibited to copy or reproduce in whole or in part this software or the documentation without a written approval of DL Soft Inc Copyright c 2003 2013 DL Soft Inc All rights reserved Windows is a trademark of Microsoft Corporation DISCLAIMER OF WARRANTY Even though many efforts have been made during the preparation of the VSPS software to ensure its accuracy and compatibility this program is provided as is without any warranty of any kind Therefore DL Soft Inc does not give any explicit or implicit guarantee and disclaims any responsibility for damage due to the use of the VSPS software Moreover the present manual is subject to change without notice VSPS 2013 2 Overview VSPS 2013 000000 Canada Inc File Language Configuration Goto Reports Database Help Config www vsps123 com Version 2013 001 Figure 2 01 Main window of the VSPS program INTRODUCTION Dear customer we thank you for your purchase of the VSPS program and hopes that you will appreciate it Briefly the major VSPS features are Unique presentation of the data resembling a payroll book to offer a ve
42. Note that most of the information is only available in French Once on the website click on Employer click on Salary rates choose the sector i e Industriel click on Continuer select the occupation in Comp tences select the skill level i e Apprenti 1 and click on Continuer Once the results are displayed you must print them The following is an example in French Vous tes ici Accueil gt Taux de salaire et de cotisations Taux de salaire et de cotisations Secteur M tier Occupation Taux et cotisations pour la p riode du 28 juillet 2013 au 31 ao t 2013 M tier 110 Briqueteur macon Comp tence Apprenti 1 Secteur Industriel Description des annexes e R gle g n rale travail de jour e B6 Chantiers isol s Baie James travail de jour e 1 Industrie lourde Travail de jour e N4 Industrie lourde Travail de jour Clause 3 03 Annexes B3 B6 N1 R gulier 20 85 21 62 heure Demi N A N A heure Double 41 70 42 47 heure Avantages sociaux part du salari retraite 1 350 1 350 heure part de l employeur retraite 3 335 3 335 heure part de l employeur assurance 2 170 2 170 heure Total part de l employeur 5 505 5 505 heure Total part du sal et de l empl 6 855 6 855 heure Avantages imposables 2 042 2 042 heure Fonds de qualification 0 00 0 00 heure Fonds de formation 0 20 0 20 heure Equipement de s curit 2 0 50 0 50 heure Contribution secto
43. Quebec Quebec Health Services Fund QHSF CSST applicable for Quebec only Ontario Health Services Fund EHT blue box means that you must enter an account number if an amount is entered in the pay program If you are only using the basic accounts in the Basic accounts tab at each EACH remittance period the employer s contributions account expense will be debited and the source deduction to pay account federal or Quebec will be credited Copy to another department Quit Figure 12 03 Employer contrib tab of the G ledger module 43 VSPS 2013 13 Reports Pepatts In the report selection screen it is important to remark that for some reports there is a Criteria tab that allows you to choose the selected employees the interval of time etc Report selection and criteria 000000 Canada Inc Function Report selection Criteria Previous pays with corrections allowed Some popular choices for this report you can modify the criteria if you want Detailed report with monthly totals Summary report with monthly totals C Monthly results only Cumulative results per employee for the year to date List of all pays with possibility to erase cancelled pays List of pays for an employee before a date can be used to establish an amount for a statutory holiday Source deductions and employer contributions to Federal Source deductions and employer con
44. Scientific Research and Experimental Development SR amp ED since tax authorities require you to maintain a detailed record of hours worked for each eligible activity Therefore the Projects tab permits you to create projects You can create as many projects as you wish In the time sheets you can then select one or several projects to distribute hours worked Remember that in the time sheets when you want to divide hours between different projects it becomes possible to generate a report for hours and costs related to a project for a given period of time for selected employees Business profile information 000000 Canada Inc EI Function Basicinfo Pay Departments Groups Otherincome and deduct Projects CSST Otherinfo Since you can distribute hours between projects in the time sheets this window is used to add or edit a project Note that the first project Miscellaneous is obligatory and is the default project Project customer etc Ill Miscellaneous Research amp Development Training Customer 1 Customer 2 Customer 3 Figure 6 06 The Projects tab of the business information window 14 VSPS 2013 The CSST tab is used by Quebec employers to enter the rate for the CSST insurance premiums If this rate changes during the year you have to enter the new rate and the effective date Note that since 2011 employers are required to pay the CSST insurance premiums periodically to Reven
45. VSPS 2013 Note that in order to improve the viewing of the illustrations you can always zoom in for example at 125 www vsps123 com VSPS 2013 TABLE OF CONTENTS 1 Terms and conditions 1 2 Overview DIV ERC NC UUM ES 2 System requitemenls 021 dt pt eed a ae a E EU E Did 3 Installing thie V SPS Progra ert 4 Uninstalling the programme tristes eoe tete teet eie Pete e ete etes te etit Ro 5 staring the ea ia a ha bi 5 3 First use of VSPS for a business 22 c cece cece cece etter treet 6 4 Open selection of a payroll database 7 DAVE oe cess cesecen cederene 8 6 Company business information 9 7 Employees employee records 17 8 Previous to enter previous payroll results before the first use of VSPS 24 9 Config cheque printing configuration 26 10 Ime Sh Umo shoot oec ecce ree etd ree et
46. active Other Other Vacation income 1 income 2 earnings 13 17 03 2013 23 03 2013 28 03 2013 12 10 03 2013 16 03 2013 21 03 2013 11 03 03 2013 08 03 2013 14 03 2013 10 24 02 2013 02 03 2013 07 03 2013 g 17 02 2013 23 02 2013 28 02 2013 8 10 02 2013 16 02 2013 21 02 2013 7 03 02 2013 09 02 2013 14 02 2013 B 27 01 2013 02 02 2013 07 02 2013 5 20 01 2013 26 01 2013 31 01 2013 4 13 01 2013 19 01 2013 24 01 2013 3 06 01 2013 12 01 2013 17 01 2013 2 30 12 2012 05 01 2013 10 01 2013 1 23 12 2012 29 12 2012 03 01 2013 52 16 12 2012 22 12 2012 25 12 2012 51 09 12 2012 15 12 2012 18 12 2012 50 02 12 2012 08 12 2012 11 12 2012 49 25 11 2012 01 12 2012 04 12 2012 48 18 11 2012 24 11 2012 27 11 2012 47 11 11 2012 17 11 2012 20 11 2012 To restore an overwritten formula press Delete on this cell To go to the employee time sheet double click or press F3 on any hour cell Figure 13 26 Second part of the ROE worksheet 71 VSPS 2013 Worksheet for the Record of employment ROE 000000 Canada Inc Function Information for the ROE paper format of 1 John So And So Employee selection Worksheet Results forthe ROE Total Insurable hours hours for El El insurable earnings Total earnings Per From before benefits Cheque 13 17 03 2013 12 10 03 2013 11 03 03 2013 10 24 02 2013 8 17 02 2013 8 10 02 2013 7 103 02 2013 6 127 01 2013 5 120 01 2013 4 13 01 2013 3
47. amount for the remitting period and the number of employees in the last pay period For every remittance period there are also columns to enter the amount really paid the date of payment and the cheque number There is even a column that calculates the difference between the amount to pay and the amount really paid Even if all amounts are already calculated you are allowed to change an amount A red star is displayed beside a modified field to indicate that this amount was overwritten To restore a calculated amount you only have to position the cursor on this cell and press Delete on your keyboard Source deductions and employer contributions to Federal for 2013 Function 000000 Canada Inc Federal Criteria Period E EL Total Federal tax employee employer January February March April May June July August September October TOTAL 2 222 61 m To restore an overwritten formula press Delete on this cell Print Qui Figure 13 09 Source deductions and employer contributions to Federal report 53 VSPS 2013 The DR CR button allows you to generate the federal employer contributions journal entries for a selected remittance period Once the journal entries screen is displayed the Export button is used to create a file that can be imported into many different accounting programs such as Accpac Acomba Fortune 1000 MYO
48. arch 31st year end you could obtain the payroll results for the fiscal year ending in 2013 by entering April 1 2012 as the beginning date for the interval of time and March 31 2013 as for the end date Detailed or summary payroll results for a given period of time 000000 Canada Inc Function Pay frequency All pay frequencies Detail per employee Yes Detail per pay Yes Type of results Monthly results Period for report From 01 04 2012 to 31 03 2013 cheque dates Employees DA Employee number Regul 1 2 Pay period hour hours hours 1 Lahn So And So 14 End 31 03 2012 Ch 03 04 2012 2 Mary Something 14 End 31 03 2012 Ch 03 04 2012 1 John Sonde 15 End 07 04 2012 Ch 10 04 2012 2 Mary Something 15 End 07 04 2012 Ch 10 04 2012 1 John So And So 16 End 14 04 2012 Ch 17 04 2012 ECO To go to the employee time sheet double click or press F3 on any hour cell onto Employees Calender aut Figure 13 04 Example of the Detailed or summary payroll results for a given period of time report It is important to remember that by default concerning the dates to enter for an interval of time the VSPS program proceeds upon cheque dates In fact to help users at the bottom of the screen the Pay dates button enables you to consult for each of the pay periods the beginning date the end date and the cheque date However you can always select the Based on
49. are many tabs Incomes Benefits Deduct etc each being a distinct section of the employee record It is always recommended to take the time to revise all information entered in particular the name the date of birth the Social Insurance Number SIN and the vacation rate For more details on the employee records please refer to chapter 7 You want to modify the salary or the vacation rate for an employee In the employee records you must select the Incomes tab In this screen among other things there is the effective remuneration at the beginning of the year When the fixed salary or the hourly rate changes you must not modify these amounts in this screen You must rather click on the Modify button to access the employee s record addendum to enter the new amount to be paid In this addendum when you change the fixed salary or the hourly rate you have to indicate the effective date this modification takes effect It is important to note that with the VSPS program you must enter the cheque date For example if an employee receives a pay raise effective June 1st you must enter the cheque date of the pay period that includes June 1st In other words a salary change is always effective from the beginning of a pay period To help you determine the cheque date to enter the Pay dates button allows you to view the details for every pay period beginning of the pay period end of the pay period and cheque da
50. ast file creation number Name of file only for the Canadian National Bank With the Canadian National Bank this name usually starts with TF and is followed by 10 digits Notes Calenda Qt Figure 6 08 The Other info tab of the business information window 16 VSPS 2013 7 Employees employee files This window is used to fill out employee records There are different tabs in this screen Each blue box represents an obligatory field When you have to create a new record for a new employee and you do not have his social insurance number S I N the program offers you to generate a temporary number in order to be able to continue the record creation Of course when you get the real S I N from this employee you have to return to his record and change this number To create a new employee record you must click on the New employee button Note that in these circumstances it is the VSPS program that generates the employee number because this number is used for identification and must be unique To move from one employee record to another you can use the arrows at the bottom of the screen You can also use the search box to find an employee by his name or by his number This is faster when there are several employees Employee profile 000000 Canada Inc E te ce number Current file 1 John So And So Basic Incomes Benefits Deduct Fed incometax Prov incometax Miscell First nam
51. at the program transfers information for all employees except the ones indicated as terminated in the employee files Employees icon in the main window of the program If an employee no longer works for the business but may come back to work eventually you must select No in the box Terminated This function is authorized only at the end of December Of course it is important to select this procedure after you have posted the last pay of the year Post button of the pay window Another important issue is to be sure to use the last VSPS version the one available at the end of December In fact it is only at the end of the year that we know for sure what will be the necessary database structure for the next year Remember that all VSPS upgrades during the year are free It is highly recommended to visit our web site www vsps123 com regularly to be sure to use the most recent version The new database creation does not affect the current database because it is a distinct file You can do this operation as many times as you wish i e if you made changes in the payroll database of the current year because the program will ask you every time if you want to replace the file By default the new file is saved in the VSPS 2013 folder but you can use any other directory you want The name of the database is always composed of the business name followed by 13 DL7 For example if the business name is My company Inc the database
52. ation must be entered in this window Business profile information 000000 Canada Inc Function Departments Groups Otherincome and deduct Projects CSST Otherinfo Address 77 Industrial Boulevard Address Cd City Town Province Quebecs Postal code J z 979 Phone L9 roe ff Remittance frequency for federal Monthly Remittance frequency for Quebec Monthly Business number BN for Canada Revenue example 123456789RP0001 123456789RP0001 Quebec Registration Number example 1234567890RS 0001 123456789085 0001 Quebec enterprise number example 1234567890 1234567890 Transmitter number this is used only for Rel 1 slips in XML example NP123456 NP123456 First 8 digits of the first serial number for Rel 1 on paper nothing to enter here 2012 pay directory example C AVSPS 2012 E VSPS 2012 D Calendar Figure 6 01 The Basic info tab of the business information window VSPS 2013 Business profile information 000000 Canada Inc Function Basicinfo Departments Groups Otherincome and deduct Projects CSST Otherinfo Normal pay frequency Weekly 52 or 53 pays per year v Pay cheques are issued 5 days after the end of pay period Date of the beginning of the 1st pay period December 23 2012 Next date if semi monthly frequency D dd mm yyyy First period From 23 12 2012 to 29 12 2012 Date of the 1s
53. bs the notes from the pay window For example the note entered in the pay window can be useful to send an explanation or message to your employees The best way to adjust the cheque printing is to insert a blank page in your printer and to click on the Print test button After that you can put this sheet in front of a cheque align the two documents and look at them in front of a light to see if you need to move some fields or not To modify the position of an element to print on the cheque you must drag this field with your mouse If a field disappears you simply have to click on the Refresh button 27 VSPS 2013 T 10 Time sh Time sheets mesh Time sheet 000000 Canada Inc Function Time sheet Hour distribution per project Name Search On p Employee number v Pay Period a EE Weekly 52 or 53 pays per year 1 number 3 From January 6 2013 to January 12 2013 Date of cheque 17 01 2013 January 17 2013 Time sheetfor Employee 1 John So And So Fixed salary 0 00 Hourly ratel 25 00 and Hourly rate2 0 00 Hours before adjustment Adjustment hours Starting Finish Note for the adjustment time Sunday 06 01 2013 Monday 07 01 2013 Tuesday 08 01 2013 Wednesday 09 01 2013 Thursday 10 01 2013 Friday 11 01 2013 Saturday 12 01 2013 TOTAL Two different formats are allowed to enter hours For example 10 30 hh mm or 10 50 fract
54. column will be displayed However if you try to unselect a column that is already used in your pay calculation this action will be denied the field will be displayed in light grey For example this will happen in the case of a Quebec employer who is trying to hide the QPP Quebec pension plan column When loading the pay window the configuration screen is displayed over the pay window This is to advise the user of the possibilities If you want to stop showing the pay window configuration screen when loading the pay window simply select this choice at the bottom left hand side of the screen 34 VSPS 2013 Pay window configuration 000000 Canada Inc Function he following represents the list of all optional columns A check mark means that this column will be visible Therefore in the pay indow you can always select the configuration window to activate or deactivate a column Note that it is preferable to display on ecessary columns Tips and gratuities F Advances from or to the employee Commissions eamings Child support Lump sum or retroactive earnings F nt Other deduction 2 Other income 2 gt inc Other deduction 3 Sick leave pay Union or professional dues Other deduction 4 Benefit for board and lodging Parity committee or similar body Other deduction 5 Benefit for use of employer s vehicule Group insurance Other deduction 6 oh aa benefits for federal AND Registered pensio
55. corrections allowed Detailed or summary payroll results for a given period of time Some popular choice C Detail C Summary report with monthly totals C Monthly results only 2 umulative results per employee List of all pays with possibility to erase cancelled pays List of pays for an employee before a date can be used to establish an amount for a statutory holiday Selection of the employee A os Employee number Number of the selected employee in this software Name of this employee Desired number of pay periods for the report 4 BEFORE the following date date of cheque 1 04 dd mm yyyy L_ Paydates Continue Quit Figure 13 06 Required information to calculate an indemnity for a statutory holiday 50 VSPS 2013 Once the required information is entered VSPS list the desired number of pays for this employee preceding the chosen date If ever a pay period is not eligible based on this province labour standards you can exclude this pay by removing the check mark in the Select column For example in Qu bec when the pay frequency is weekly you must list the 4 last pay periods preceding the pay period in which the compensation will be paid off If ever a pay period is not normal for example the employee missed a couple of days because he was sick you must then select the last 5 pay periods preceding the cheque date and remove the check mark in the Select column for the excluded pay
56. direct deposit file Once you have paid your employees either by cheque or by direct deposit it is strongly recommended printing the pay reports Summary Detailed earnings etc and stapling them to the pay stubs To do so click on the Print button and select the desired report After do not forget to click on the Post button to save the payroll data for this pay period the database It is essential to always remember that the pay window is like a worksheet If you change the pay period for a previous pay period the hours will be updated based on the time sheets However all overwritten entries will stay in the pay window In fact to consult or modify a previous pay you must not proceed in the pay window but rather use the Previous pay with corrections allowed report For more details please refer to chapter 13 Note that you can post the payroll data as many times as you wish So if you make a modification just do not forget to click on the Post button to save the changes you made 38 VSPS 2013 Furthermore the DR CR button is there to generate and display the payroll journal entries Figure 11 06 illustrates an example In the journal entries window the Export button enables you to create a file that can be imported into many different accounting programs such as Accpac Acomba Fortune 1000 MYOB QuickBooks Simply Accounting etc Of course in order to be able to create this file you must have indica
57. e Refund iT o Balanced co Kd gt To restore an overwritten formula press F8 on this cell Figure 13 17 Second part of the worksheet used to fill out the Relev 1 Summary 62 VSPS 2013 Detailed vacation to pay to an employee For this report first you must select the employee by clicking on the scrollbar at the bottom left hand side or by using the search box Once the selection is done you have to click on the Continue button Then the program displays for each of the pay periods details related to the vacation calculation vacation rate effective at the pay period remuneration for vacation calculation balance at the beginning vacation amount earned in the period balance at the end etc Selection of the employee for the vacation report Name On C Employee number Number of the selected employee in this software Name of this employee John So And So Figure 13 18 Employee selection screen for the vacation report Detailed report for vacation 000000 Canada Inc Function 1 John So And So Vacation to pay Remuner Vacation Vacation Type of vacation pay for vacation balance at earned for calculation beginning this period 1 From 23 12 2012 to 29 12 2012 Paid later 937 50 1 276 73 2 From 30 12 2012 to 05 01 2013 4 Paid later 937 50 1 31423 3 From 06 01 2013 to 12 01 2013 4 Paid later 987 50 1 351 73 4 From 13 01 2013 to 19 01 2013 4 Paid later 937
58. e Last name o And So Address Street app 23 Main Street Address continuation City Somewhere Province Quebec Postal code J Z 1A1 Phone 1 Social insurance number SIN 000 001 005 Phone 2 Date of birth 01 01 1980 January 1st 1980 1st day of work 27 12 2010 December 27 2010 Same since last Record of employment 27 12 2010 December 27 2010 Last day of work March 22 2013 Terminated Yes No Department number 1 Sales Group or association None Paid by cheque Paid by direct deposit Relev 1 for this employee 9 Figure 7 01 tab of the employee record 17 VSPS 2013 Employee profile 000000 Canada Inc Search TEE C Employee number Current file 1 John So And So Pay frequency Weekly 52 or 53 pays per year Pay type Hourly or fixed salary Fixed salary per pay period Regular hourly rate 25 00 Time and half T172 after hours Double 2 after hours For any subsequent change or to add new rate click here gt Other earnings per pay ther income 1 Fixed amount taxable ther income 2 Fixed amount taxable Vacation Rate 1 ex if 4 enter 4 4 0000 at beginning of the year Rate 2 if it changes during the year 0000 Z effective from I dd mm yyyy Type of vacation pay Paid later Pay dates Esport basic into employee Calendar
59. ebec additional columns are displayed Two of these columns are used for vacation pay Note that for an employee working in the field of construction in Quebec the CCQ requires the employer to add to the income at each pay period 13 for vacation 13 x number of hours subject to CCQ rules x hourly rate In reality it is 6 for annual vacation 5 596 for statutory public holiday and 1 596 for sick leave However this vacation amount is not paid directly to the employee The employer must instead pay this amount to the CCQ that pays twice a year an allowance to all Quebec construction workers Since the employee does not receive this amount with his pay the software displays another column for the vacation CCQ deduction By default this amount is the same as the one in the vacation CCQ income Moreover for a Quebec construction worker in the pay window by default the program assumes that the hours entered are all worked hours in the field of construction in Quebec However in the last columns of the pay window the user can modify the number in the Hours subject to CCQ column and the amount in the Gross income for vacation CCQ calculation column This affects the CCQ vacation calculation and also other incomes and deductions related to CCQ rules In other words if a construction worker in a pay period has worked hours subject to CCQ and hours not subject to CCQ do not forget to modify the Hours subject to CCQ column in order t
60. entries To know how to proceed please refer to chapter 11 Finally if you have forgotten an employee in a pay prior to the current pay period this kind of correction can not be done in the Previous pays with corrections allowed report In this case please read the next section You forgot an employee in a previous pay period 89 VSPS 2013 You forgot an employee in a previous pay period Note that VSPS does not save any payroll data when the net salary amount is equal to zero If you have forgotten an employee in a previous pay period you can not use the Previous pays with corrections allowed report because for this pay period no pay was posted for this employee In these circumstances instead you must click on the Pay icon Normally the current pay is displayed If you had not done it yet you should click on the Post button to save the current payroll data in the database Thereafter it is very important to click on the Erase button in order to have a blank worksheet If you are using the time sheets hours may be displayed in this screen If so for each of the employees except for the one you forgot to pay you should enter over any number of hours a red star will be displayed beside the overwritten field In fact the net salary of any other employee must be equal to zero Then in the top of the screen you must select the desired pay period by clicking on the scroll bar Once positioned on this pay per
61. erwritten formula press F8 on this cell Figure 13 14 Relev 1 slip This function allows you to issue Relev 1 slips to employees who are Quebec residents It is very important to install the last VSPS upgrade in order to be sure to use the right Relev 1 version This upgrade is usually available at the beginning of January for example January 2014 for 2013 Relev 1 slips As for the T4 to move through the slips you can click on the scrollbar at the bottom left hand side You can also use the search box It is even possible to change a calculated amount except if the field is greyed out implying the field is disabled In this case a red star beside the box would be displayed to indicate an overwritten cell To restore the calculated amount to an overwritten field simply select this field and press F8 In the middle of the slip you can also enter notes 59 VSPS 2013 When you select the Print button the print screen is displayed As we can see in the following figure in this screen first you must indicate if you wish to print the Relev 1 slips or the Relev 1 Summary For the Relev 1 slips printing if necessary you can select employees The Relev 1 slips produced by VSPS are authorized by Revenu Qu bec You simply have to print them on white paper However be sure to use the last VSPS upgrade usually available in the month of January following the year end When you are printing the Re
62. excluding ben Other deduction 3 Other deduction 4 Other deduction 5 Other deduction 6 Other deduction 7 Other deduction 8 Other deduction 9 Other deduction 10 Paydates Calendar Quit Example for the sectorial contribution and the CCQ Levy Figure 16 07 98 VSPS 2013 Finally you must click on the Miscell Tab and check the box to indicate that this employee works in the field of construction in Quebec when CCQ rules apply A screen will be displayed to enter all the information needed for the monthly report to submit to the CCQ At any time in the Miscell tab you can access this screen by clicking on the Info CCQ button Addendum Other information change of hourly rates etc Construction 12345 Qc Inc Function Current file 1 John One Hourlyrate 1 Hourlyrate 2 Fixedsalary Other deductions To configure the various payroll elements for employee working in the field of construction in Quebec it is very important to consult the help function or the user manual in the section Quebec construction worker CCQ rules The topics are among others the CCQ vacations the compensation amount for safety equipment the Quebec taxable benefits the contribution for pension plan the union dues the sectorial contribution and the CCQ levy Sector of activities B Industrial Trade code occupation 110 Briqueteur ma on Apprenticeship period lAppreni1
63. f time It is also possible to choose employees to consider for the report For more information on this report please refer to Hour and cost report for a selected project in chapter 13 Reports Time sheet 000000 Canada Inc EEK Function Time sheet Hour distribution per project Time sheet for Employee 1 John So And So Fixed salary 0 00 Hourly rate1 25 00 and Hourly rate2 0 00 Period 3 Weekly From 06 01 2013 To 12 01 2013 Cheque 17 01 2013 Project 1 1 Project 4 None Project 2 Tm Project 5 None Project 3 None Project Project 1 Project 1 regular T172 hours at hours at rate 1 rate 1 Sunday 06 01 2013 0 00 0 00 Monday 07 01 2013 i 5 0 00 Tuesday 08 01 2013 0 00 Wednesday 09 01 201 i i 0 00 10 01 2013 0 00 Regul T1 2 T2 T1 2 T2 hours hours hours hours hours hours ratel ratel ratel rate2 rate2 rate Transfer all project 1 hours in another project Print Qut Figure 10 04 Hours distribution per project in the time sheet Finally when you quit the time sheet if the distribution of hours does not balance the program warns you of this problem 31 VSPS 2013 11 Pay L Pe New pay 000000 Canada Inc Function Pay window Instructions forthe pay window Pay Weekly 5
64. f vacation pay Thereby the program will enter automatically the vacation balance in the Vacation column of the pay window With the VSPS program when a Quebec employee is terminated if the employer forgets to go in the employee s record to select Employment termination for the type of vacation pay and enters directly the amount in the Vacation column of the pay window the program will assume that this amount is for annual vacation In these circumstances even after the last pay cheque to this employee there will be an outstanding amount for vacation Let us recall that in Quebec the employer must calculate a vacation amount on each amount paid including vacation pay except in the case of a vacation pay given when the employee is terminated Fortunately even if this kind of error is made and the terminated employee already received his final payment VSPS allows you to void the vacation balance To do so you have to select the Detailed vacation to pay to an employee report and enter the balance but as a negative amount on the last line the last pay period of the report in the Adjustment column For more information on this report please refer to chapter 13 Furthermore when an employee is terminated and all the payroll process is done for this pay period if you wish in the employee s record you can select Yes for the Terminated box Thereby this employee will not be displayed anymore in the pay window However befo
65. following account numbers must be entered in order to be able to export entries However Advances to employees account is needed only if an amount is entered for this account in the pay program Expenses Bank Advances to employees Federal source deductions and employer contrib to pay Quebec source deductions and employer contrib to pay Net salaries to pay Wages and salaries Payroll expenses If you are only using basic accounts here are the payroll journal entries the program also makes other journal entries for the employer s contributions DR CR W ages and salaries Net salaries to pay Federal source deduct and employer contrib to pay Bank cheque Qc source deduct and employer contrib to pay Net salaries to pay Entries for EACH employee to post salaries Default entries for pay payments L Copy to another department Qui Figure 12 02 Basic accounts tab of the G ledger module 42 VSPS 2013 As we can see in the next illustration for certain elements two account numbers are required one for the expense and one for the liability debt GL account numbers 000000 Canada Inc Account numbers in Accpac Simply Simple Comptable for department 1 Sales Expenses Bal sheet Canada pension plan contributions CPP premiums Other contributions to Revenu Canada Quebec pension plan contributions QPP Quebec parental ins plan QPIP Other contributions to Revenu
66. from and select Copy Then you have to position the cursor on the first line where you wish to copy the information to and select Paste In the small screen displayed you must indicate the number of consecutive lines you want to paste the information By default this will paste the starting time the finish time adjustment of hours and the adjustment note However it is possible to exclude any of these elements m Paste Function Number of consecutive lines to paste Information to paste M Starting time M Finish time Adjustment of hours M Note for the adjustment Figure 10 02 Screen to copy and paste recurring data on other lines of the time sheet In the time sheet as you enter your data the program calculates the hours worked By default the hours are considered like regular hours at rate 1 1st hourly rate However you can always allocate some of these hours in other columns For example on a certain day an employee could have worked 9 payable hours At first the program would display 9 hours in the Regular hours at rate 1 column but it would be possible to modify this field by entering 8 hours A red star beside this box would be displayed to indicate an overwritten cell In these circumstances the program would display 1 hour in the T1 2 hours at rate 1 column but once again you could modify this by affecting another column for example the one for double time rate As mentioned before
67. h to be paid on the first pay of the month per worked hour distinction between regular or overtime hours per hour at regular rate per hour at T 172 rate per hour at double time of hourly rate ex if 40 and hourly rate of 20 the amount to be paid is 8 per pay of gross earnings EXCLUDING benefits ex if 5 and gross earnings of 1000 the amount to be paid is Mimimum per pay period if applicable Maximum per period if applicable Maximum per year if applicable P Pay dates Calender dur Window used to define the calculation method of a deduction Figure 7 06 22 VSPS 2013 In the employee record the Fed Income tax and Prov income tax tabs are used to enter necessary data for tax calculation based on different forms filled out by the employees i e TD1 TP 1015 3 etc to establish their income tax calculation Note that when an employee does not give you any form the income tax deduction is calculated only on the basic exemption Employee profile 000000 Canada Inc ER Employee number Current file 1 John So And So Income tax table to use for the employee Quebec Employment code must appears on T4 for certain type of employment Total annual tax credits on TD1 FEDERAL 11 038 0 Other deductions for the year authorized by federal tax centre factor F1 ther federal tax credits for the year authorized by a federal tax cent
68. iod you must click on the Confirm button that is only visible when a pay period changes Although all employees are displayed in the pay window you must only process the payroll of the employee that you have forgotten before Once this is done you have to click on the Post button to save your data in the payroll database Since you have already posted the other employees data for this pay period a message will be displayed for every employee that has a salary for this pay period In this message you will be asked if you wish to erase the data you posted before For each of them you must answer NO meaning that you do not want to erase any payroll data for this employee Finally it is important to quit the pay window to return to the Previous pays with corrections allowed report After selecting the pay period you can reprint the pay reports summary report detailed earnings etc and if needed create a new payroll journal entries file As explained before if you have imported journal entries for this pay period in your accounting system you must reverse these journal entries To know how to proceed please refer to chapter 11 90 VSPS 2013 An employee quits definitively When an employee is terminated and you have to prepare his last pay usually this includes the outstanding vacation pay Before selecting the pay window you must go in the employee record and choose Employment termination for the type o
69. ion to download the VSPS program and the upgrades VSPS 2013 INSTALLING THE VSPS PROGRAM 1 First you must download the software from the web site www vsps123 com To do so select VSPS complete software in the Download menu Then select the 2013 year and click Install VSPS2013 exe Click on Run If the message The publisher could not be verified Are you sure you want to run this software is displayed click on Run If the message An unidentified program wants access to your computer is displayed click on Allow Follow the instructions and answer the questions At the end if the message This program might not have installed correctly is displayed click on This program installed correctly Once the installation is complete you must copy in the VSPS installation folder by default C VSPS 2013 the file NAMES 13 TXT that you received by email after your purchase of the VSPS 2013 license This file is a control file containing the coded name of businesses for which you bought the VSPS 2013 license Without this file it is impossible to open or create a payroll database This is why when you start the program you can only open a file for an authorized business meaning a business name that we added in your NAMES 13 TXT file If you used VSPS in 2012 for a business you do not have to re enter all information on this business the employees balance of vacation to pay etc This pr
70. ion of hour To restore an overwritten formula press Delete on this cell Paste Prit Figure 10 01 First part of the time sheets This function is used to fill out a time sheet i e the detailed hours worked in a pay period for an employee In this window as soon as you select the pay period the program generates all the dates for this pay period The next step is to choose the employee Note that from the pay window you can always access directly an employee s time sheet by positioning the cursor on any hour field for this employee and by pressing F3 or by double clicking on this cell In the time sheet to enter beginning and ending hours worked VSPS allows 2 different formats hour and minutes i e 14 30 or hour and fraction i e 14 50 28 VSPS 2013 There is a column to register hour adjustments In the next column you can enter an explanation for each of these adjustments i e time taken for lunch An adjustment must be entered in a fraction of an hour i e 5 to subtract 30 minutes In figure 10 01 notice that the Erase line button at the bottom left hand side enables you to erase all data on the positioned line This can be useful when you did not enter the data on the right line To accelerate the data entry the program allows you to copy and paste certain information that has a tendency to repeat itself To do so first you must position the cursor on the line to copy
71. layed As we can see in the following figure you can even export this information in a file Excel Word etc Reports to print Print selection Type of print Summary list of employees C To printer C Detailed list of employees To file export File format Excel XLS Y Name of file Location of file Drive S c gx SPS 2013 DEMO Directory Backup CN DirectDeposit 23 Doc C Export 000000 Canada Inc 13 DL7 000000 Canada Inc 13 1db Config ini DI dll d pw dll Export employees basic information into an Access database Figure 13 31 Print screen for the list of employees The Export employees basic information into an Access database button enables you to create an Access database containing for each of the selected employees the name address and other information telephone number date of birth etc This file is always saved in the VSPS folder by default C VSPS 2013 The file name is Employees of followed by the business name and the file extension MDB The main purpose of this file is to allow you to print labels with programs such as Microsoft Word Label Pro etc This database can also be useful in other situations like when you want to send a letter to your employees 76 VSPS 2013 Hour and cost report for a selected project In the time sheets if you have attributed hours to specific activities i e research and development training etc
72. lev 1 slips the number beginning by FS must be followed by the last 2 digits of the year i e FS13 for 2013 Note that if you have more than 50 employees a button will be displayed to create a file of the Relev 1 slips in XML format This file must be sent to Revenu Quebec Remember that paper copies are not accepted if you have more than 50 employees In this case please contact us Relev 1 slips and Relev 1 Summary print Select Name So And So John Something Mary Figure 13 15 Print screen for Relev 1 slips and Summary 60 VSPS 2013 In the VSPS Relev 1 window when you select the Summary tab the program displays the worksheet intended to help you fill out the Relev 1 Summary form You can print this worksheet but as opposed to the Relev 1 slips this is not an official form that you can send to Revenu Quebec Indeed you must fill out the Relev 1 Summary form manually or use the dynamic pdf form i e rlz 1 s 2013 10 d8 pdf for the year 2013 available from the Revenu Quebec web site or from www vsps123 com in the F A Q section It is recommended to print this worksheet and keep it for your records with a photocopy of the Relev 1 Summary form Relev 1 Current file 1 John So And So Function Search On Name Employee number Slip number 190000016 Releve 1 slip Summary cont Summary of source deductions and employer contributions
73. line Company City Prov O loyee Address 1st line Emp loyee Address 2nd line Print company name Cheque model Cheque Stub Stub Print company address Yes Print dollar sign Yes Number of lines after the second section Ls Print Paid to Yes Number of lines after the third section 5 Print pay note on the stub Yes Print the word Date before the date Yes Print dd mm yyyy under the date C Yes No Export format for the stubs pdf and text If you drag a field outside of the printing zone and the field disappears click on the Refresh button Pamen Renen o Figure 9 01 Window for cheque printing configuration The present module allows you to adjust the pay cheque printing Your cheque must be ink jet or laser format 8 5 x 11 sheet As we can see in the above figure you have to indicate the cheque model For example if the model is Cheque stub stub this means that the first part of the sheet is the cheque followed by 2 detachable stubs Some boxes are there to indicate the number of empty lines between different sections of the cheque 26 VSPS 2013 It may be possible that some information is already printed on the cheque business name address dollar sign or the mention Pay to If this is the case you simply have to select No to indicate that you do not print this information Also there is an option to print or not on the stu
74. lus autres frais 0 065 0 065 0 065 0 065 heure sac Hebdomadaire 8 70 8 70 8 70 8 70 semaine CPQMC Local 0004 Hebdomadaire 14 00 14 00 14 00 14 00 semaine Plus autres frais 0 025 0 025 0 025 0 025 heure CPQMC Local 0007 Mensuel 30 00 30 00 30 00 30 00 mois Plus autres frais 0 025 0 025 0 025 0 025 heure FTQ Local 0100 Hebdomadaire 15 00 15 00 15 00 15 00 semaine Remarques maximum 23 sem ann e Figure 16 02 Example of CCQ payroll data part 2 93 VSPS 2013 In the VSPS software first you must rename one field in the Other income section and two fields in the Other deduction section This will permit to have more precision in the pay window the reports and the pay stubs Therefore in the main window of VSPS you must click on the Company icon and then on the Other income and deduct tab If you are not currently using Other income 1 otherwise use Other income 2 rename it to something like Safety equip This is the amount paid to the employee for his safety equipment Regarding the 2 Other deductions to rename you could rename the first one by Sectorial contrib and the second one by CCQ Levy In both cases it is important to check the boxes to indicate that these are deductible for Federal and Provincial For better understanding the following figure shows an example Business profile information Construction 12345 Qc Inc Function Pr
75. ly report part 1 monthly report part2 Initial Number of Code for Code for Code for gt z Trade code Code for Surname first weeks apprenticeship sector of schedule of name worked period na SEE activities wage 1 000 001 013 One 5 2 000 002 013 Two TOTAL 4 gt To restore an overwritten formula press Delete on this cell T Figure 16 10 First part of the CCQ monthly report monthly results per employee 102 VSPS 2013 Detailed or summary payroll results for a given period of time Construction 12345 Qc Inc Function Pay window CCQ monthly report part 1 monthly report part2 AEN Assessable Vacations Surname Union s name E earnings CCQ 4128 30 6 776 25 1 000 001 013 One 2 000 002 013 Two TOTAL 393 10 904 55 1 417 58 4 To restore an overwritten formula press Delete on this cell Figure 16 11 Second part of the CCQ monthly report monthly results per employee 103 VSPS 2013 Note that in the official CCQ monthly report column 5 Social benefits is actually the total of 3 items Employee contribution to the pension plan Employer contribution to the pension plan Employer contribution for insurance This is why in the VSPS CCQ monthly report in order to provide more details there is a column for each of these 3 elements There is also the column Total social benefits that is the sum of these 3 compo
76. ment Description 1 Sales 2 Administration 3 4 5 6 7 it 8 9 10 D Calendar Qt Figure 6 03 The Departments tab of the business information window 11 VSPS 2013 The tab is used to define groups classes or employee associations unions professional associations etc This allows you to generate pay reports for a selected group Note that there is no limit for the number of groups that you can create Business profile information 000000 Canada Inc EEK Function Basicinfo Pay Departments Groups Otherincome and deduct Projects CSST Otherinfo If some of your employees are part of groups or associations the present window is used to add or edit a group Note that it is possible to generate pay reports based on a selected group Group of employees associations etc Figure 6 04 The Groups tab of the business information window 12 VSPS 2013 With the VSPS program the most popular deductions union dues group insurance RPP RRSP etc are already predefined In other words in the pay window there is already a column for each of these deductions However in the Other income and deduct tab VSPS permits you to define up to 10 other deductions It is recommended to enter a brief description in the example Child support in order to provide more precision in the pay window and in the reports If you do not enter a
77. n EEJ 20 insurable hours for EL Employee number EX 555 5 gt insurable earnings for E l Business number BN for Canada Revenue Pay period type Social insurance number First day of work since last ROE dd mm yyyy Last day of work dd mm yyyy Final T ES date Vacation paid in the last pay period 174 Caution If this employee received a vacation pay AFTER the last pay period you must add this amount to box 17A on the ROE form John So And So 123 Main Street Somewhere QC JOZ 1A1 Figure 13 29 Results for the ROE form 74 VSPS 2013 List of employees This function allows you to print a summary or detailed list of information for selected employees name address telephone number etc In the Criteria tab by default all the employees are selected for the report but you can also choose Selection List of employees 000000 Canada Inc Function Report selection Criteria All pay frequencies C 1st pay frequency weekly 2nd pay frequency Select 1 John So And So 2 Mary Something All employees C Selection by employees Selection by departments ex 1 3 5 for departments 1 3 and 5 C Per group Non Pay frequency Job title Salesman Bookkeeper Reset selection Figure 13 30 Selection screen for the list of employees 75 VSPS 2013 When you click on the Continue button the print screen is disp
78. n Worksheet Results forthe ROE per Fixed Total Basic Tips and Per From To Chenue LES salary hours salary gratuities Commissi 17 03 2013 23 03 2013 28 03 2013 2 988 00 10 03 2013 16 03 2013 21 03 2013 975 00 03 03 2013 08 03 2013 14 03 2013 962 00 24 02 2013 02 03 2013 07 03 2013 988 00 17 02 2013 23 02 2013 28 02 2013 975 00 10 02 2013 16 02 2013 21 02 2013 975 00 03 02 2013 08 02 2013 14 02 2013 1 001 00 27 01 2013 02 02 2013 07 02 2013 925 00 20 01 2013 26 01 2013 31 01 2013 937 50 13 01 2013 19 01 2013 24 01 2013 937 50 06 01 2013 12 01 2013 17 01 2013 987 50 30 12 2012 05 01 2013 10 01 2013 750 00 23 12 2012 29 12 2012 03 01 2013 750 00 16 12 2012 22 12 2012 25 12 2012 337 50 09 12 2012 15 12 2012 18 12 2012 337 50 02 12 2012 08 12 2012 11 12 2012 937 50 25 11 2012 01 12 2012 04 12 2012 937 50 18 11 2012 24 11 2012 27 11 2012 337 50 11 11 2012 17 11 2012 20 11 2012 337 50 46 689 00 1 2 d 4 5 6 8 To restore overwritten formula press Delete this cell To go to the employee time sheet double click or press F3 on any hour cell Figure 13 25 First part of the worksheet 70 VSPS 2013 Worksheet for the Record of employment ROE 000000 Canada Inc fol Function Information for the ROE paper format of 1 John So And So Employee selection Worksheet Results forthe ROE Lump sum or Per From To Cheque retro
79. n plan RPP Other deduction 7 Private health care insurance Quebec Registered retirement savings plan RRSP Other deduction 8 Other taxable benefits for provincial only Retirement compensation arrangement RCA Other deduction 9 Other taxable benefits for federal only Labour sponsored funds Other deduction 10 Total federal taxable income Charitable donations Total Quebec taxable income lt Check this box to stop displaying this window when loading the pay window Figure 11 03 Pay window configuration screen 35 VSPS 2013 New pay 000000 Canada Inc Function Pay window Instructions for the pay window Pay Weekly 52 or 53 pays per year Period 3 frequency number From January 6 2013 to January 12 2013 Date of cheque 12 01 2013 January 17 2013 Name pauci on Employee number Current file 1 John So And So EI Quebec Federal Total income premiums income tax tax deductions Net salary 1 John So nd So 2 Mary Something 29 05 232 18 176 54 541 08 1 370 42 To restore an overwritten formula press Delete on this cell To go to the employee time sheet double click or press F3 on any hour cell Figure 11 04 Other part of the pay window In the pay window once the data entry is done if you are paying your employees by cheque you must fill out the cheque number column You can enter these numbers directly or you can use the 123 button
80. n the main VSPS window you must select Open In the file selection screen you simply have to click on the business name and then click on the Create new file button In order to process payrolls the next steps are Enter the business information chapter 6 Fill out the employee records chapter 7 Enter previous payroll results before the first use of VSPS if applicable chapter 8 Set up the cheque and pay stub print configuration chapter 9 If you wish to export payroll journal entries enter all needed general ledger accounts chapter 12 VSPS 2013 4 Open selection of a payroll database 2 Open file Function Business selection Name 000000 Canada Inc Location of file Drive c Directory gx VSPS 2013 DEMO J Backup CN DirectDeposit Doc J Esport 000000 Canada Inc 13 DL7 Figure 4 01 Screen for the payroll database selection To open a certain business payroll database you must click on Open and select the business name in the scrolling list of the Business selection Then in the File box click on the database file for this business the one with the DL7 extension and click on the Continue button If the desired business name is not in the Business selection list or if the database is not displayed in the File box please read the previous chapter First use of VSPS for a business VSPS 2013 E 5 Save
81. n this screen you can select employees one by one or per department In the direct deposit window it is also possible to save each of the pay stubs in a text file This option is interesting for employers who prefer to send pay stubs by email When you select Export stubs the program creates a text file for each of the employees paid by direct deposit Note that this pay stub format is different from the format on a cheque In fact the pay stub is more detailed because there is no space constraint as opposed to a pay stub on a cheque The pay stub files are always saved in the subdirectory DirectDeposit Your business name DD Stubs Pay xx xx representing the number of the pay period in the VSPS folder by default C VSPS 2013 As you can see the program creates a subdirectory for each of the pay periods As for the files the name is composed with the employee s name and the pay period i e John Something Pay1 txt 37 VSPS 2013 New pay 000000 Canada Inc Pay window Instruction From January 6 2013 to Janua Current file 2 Mary Soma Total Insurable S hours for hours 1 John So And So select 39 5 4 John So And So 42 2 Mary Something Mary Something TOTAL 0 81 5 81 5 Export stubs Print stubs Create fie To restore an overwritten fomu To go to the employee time sheet double click or press F3 on any hour cell Figure 11 05 Screen to create the
82. name and address 000000 Canada Inc RRP contributions Employee s El premiums Pension ajustment Employer s El premiums 52 00 For Canadian controlled private corporations or unincorporated emplovers 5 SIN IN Total deductions 16 27 18 19 22 999 999 998 D 80 First name person to contact Last name person to contact Number of T4 slips filed for employees whose addresses are in the U S A EER Minus remittances 3 108 7 Difference Dif lt 2 00 Amount enclosed Bob Telephone number Extension number 5141234567 E mail address person to contact Overpayment Balance due If this is a MODIFIED Summary select this box gt 7 KIKI gt To restore an overwritten formula press F8 on this cell Figure 13 13 Worksheet used to fill out the T4 Summary 58 VSPS 2013 Relev s 1 Relev 1 Current file 1 John So And So EI Function Search Name Employee number Slip number 190000016 Summary Summary cont 1252650 594 23 19041 152952 12 526 50 20 02 125269 oof _ 00 o Additional Information to select double click on a box below Employee s name and address So And So John 123 Main Street Somewhere QC Employer s name and address 000000 Canada Inc 77 Industrial Boulevard Somewhere QC JE 929 Cancel last Modified for this slip b To restore ov
83. name for 2013 will be My company Inc 13 DL 7 When you will purchase your new 2013 license we will send you a new control file NAMES 13 TXT This file will contain the coded name of every authorized business for VSPS 2013 Then you will have to install VSPS 2013 and copy the file NAMES 13 TXT in the VSPS 2013 folder by default C VSPS 2013 Finally you will need to copy the new database s in the same folder 80 VSPS 2013 Compress database Over time as you use it the payroll database gets bigger which is normal because you constantly add information Moreover any database becomes fragmented over time The present function rearranges how the database file is stored on disk When complete the compacted database has reclaimed wasted space and is usually smaller than the original By compacting the database optimal performance of the database application is ensured and page corruptions due to hardware problems power failures or surges and so on are resolved For security purposes this function is usually authorized only if you just started the VSPS program For this reason if you made certain operations and then try to compress the database the following message could be displayed o Can not compress this database For the moment Please quit the program reload the program and select this operation immediately after Figure 14 02 Error message when the program denied the Compress database function
84. nc dun C Employee number Current file 1 John So And So Lump sum or Commissions retroactive earnings Tips and gratuities Insurable hours for El Basic salary John So And So Mary Something TOTAL 0 0 00 0 00 0 00 0 00 4 Figure 8 01 Previous function window Firstly this function enables you to enter the vacation pay balance for each employee at the beginning of the year which is equal to the vacation pay owed at the end of the previous year However if you used VSPS the year before and executed the Create a new database for next year function these amounts will already be displayed in this window Remember that VSPS only carries forward information of employees who were not stated as terminated in the employee records Secondly since the beginning of the year if you used another payroll system manual or a software this window permits you to enter previous cumulative payroll results before the first use of VSPS In this case two options are possible 24 VSPS 2013 First option the one recommended The best way is to enter every pay of the year that you have done before the use of VSPS because you will have all the needed data to generate the reports Even if this sounds like an arduous task with VSPS it could actually be accomplished relatively fast You do not have to use the time sheet As a matter of fact you can enter directly the total hours in the pay window
85. nents So in the official CCQ monthly report in column 5 Social benefits you must enter the amounts that are displayed in the Total social benefits of the VSPS CCQ monthly report Detailed or summary payroll results for a given period of time Construction 12345 Qc Inc Function Pay window CCQ monthly report part 1 monthly report part2 Initial Employee Employer Employer Surname first Union dues contribution contribution contribution to name to pension to pension insurance 1 000 001 013 One 267 30 1 35729 2 000 002 013 Two 526 50 1 744 2 Total social Sectoria benefits contributiol TOTAL 164 59 793 80 1245495 652 81 4 MI To restore an overwritten formula press Delete on this cell Figure 16 12 Last part of the CCQ monthly report monthly results per employee 104 VSPS 2013 In the third tab the last part of the CCQ monthly report is displayed the summary section and the total amount to pay Once again in this section of the VSPS CCQ monthly report if needed you can change most of the amounts In such a case a red star is displayed beside the amount to indicate that the user has entered the amount manually As shown at the bottom of the screen to restore the formula position the cursor on this field and press F8 on your keyboard Detailed or summary payroll results for a given period of time Construction 12345 Qc Inc Function Pay window
86. o calculate the proper incomes and deductions Because VSPS allows you to enter 2 different hourly rates for an employee in these circumstances the program always assumes that the first hourly rate is the one used for the hours subject to CCQ rules So if ever an employee with 2 different hourly rates has hours that are not all subject to CCQ rules you must allocate rate 1 hours those subject to CCQ and rate 2 hours hours not subject to CCQ Regarding the monthly report to produce to the CCQ with the VSPS software each license of 2 businesses or more includes the function to produce the necessary data for the monthly report to submit to the CCQ In the case of a single business license this is an option 50 plus taxes In the main window of VSPS to access this report you must click on the Reports icon select CCQ monthly report and click on the Continue button A screen will be displayed to select the criteria Note that only employees subject to CCQ are listed Moreover the criteria for this report are already selected and can not be changed In fact you only have to choose the month and click on the Continue button The report itself includes 3 tabs 100 VSPS 2013 The first tab lists the details of every payroll period which ends in the selected month only employees subject to CCQ This information is used to understand the origin of some of the CCQ monthly report data Detailed or summary payroll re
87. ocedure is done automatically To do so first you must download the last upgrade for VSPS 2012 After the upgrade installation you can create the 2013 database from the database menu of VSPS 2012 Be sure to save the 2013 database file with the name of the business and followed by 13 DL7 in the VSPS 2013 installation directory by default C VSPS 2013 It is very important to note that the program transfers to the new database information for all employees except the ones indicated as terminated in the employee files Employees icon in the main window of the program Caution If an employee no longer works for the business but may come back to work eventually you must select No in the box Terminated Finally please note that the new database creation does not affect the 2012 database If you are not familiar with the VSPS program we strongly recommend that you read the section First use of VSPS for a business VSPS 2013 UNINSTALLING THE PROGRAM 1 Click on start All Programs and Uninstall VSPS 2013 2 Follow the instructions and answer the questions STARTING THE PROGRAM 1 On your desk double click on the VSPS icon You can also click on start All Programs and VSPS 2013 VSPS 2013 3 First use of VSPS for a business As mentioned in the COPYRIGHT section you are allowed to install VSPS on as many computers as you wish However when you buy the VSPS 2013 software yo
88. ojects CSST Otherinfo his screen allows you to name other incomes and other deductions max 20 car Other income 1 Oterinoome2 5 5 E he program already contains the standard deductions union RPP RRSP etc but you can use up to 10 other deductions Note that normally these other deductions are non deductible for income tax matter However if a deduction is tax deductible click to select the box beside the line Deductible for income tax Federal Provincial Other deduction 1 Other deduction 2 CCQ Levy Other deduction 3 Other deduction 4 lt lt Other deduction 5 Other deduction 6 Other deduction 7 Other deduction 8 Other deduction 9 Other deduction 10 NM NM M F calendar Screen used to other incomes other deductions in order to obtain more precision Figure 16 03 94 VSPS 2013 Thereafter you must fill out the employee form Employees icon in the VSPS main window After entering the basic information name address etc you must enter the incomes and deductions You must refer to the information obtained from the CCQ see figures 16 01 and 16 02 for an example In the Incomes tab of the employee record you must enter the hourly rate For the Safety equip income first you must select per hour not taxable Then you will be able to enter the amount with a possibility of
89. olumn and that you forgot to add the equivalent in term of hours in the Insurable hours for El column you can modify these hours in the ROE worksheet This kind of change is only effective in the ROE worksheet They do not affect the payroll database 72 VSPS 2013 Moreover for an employee paid by an hourly rate the last two columns of the worksheet are useful to help detect possible errors In fact in the Earnings before benefits per hour column the program calculates the total earnings divided by the hourly rate which is normally equivalent to the Insurable hours for El The last column displays the difference between this result and the Insurable hours for El Nevertheless if a difference appears in the last column this does not necessarily mean that there is an error For example if an employee worked overtime hours at a higher rate than the regular rate it is normal to obtain a difference in the last column In other words this column is to attract your attention to a particular situation that deserves to be verified in order to avoid errors Worksheet for the Record of employment ROE 000000 Canada Inc Function Information for ROE paper format of 1 John So And So Employee selection Worksheet Results forthe ROE Earnings Difference before compared to benefits insurable hours per hour for El Per From To Cheque 17 03 2013 23 03 2013 28 03 2013 10 03 2013 16 03 2013
90. om one year to the other For example with the ROE report the program often needs to consider payroll results of the previous year Note that when searching payroll results for an employee VSPS always proceeds with the employee number In other words if the employee number differs from the one used in the previous year the program will be unable to consider the payroll results of the previous year for this employee To remedy this situation the present function allows you to replace the employee number by the one he had in the year before 82 VSPS 2013 Delete the current pay table in the database and create a new one This function must be used only if you call the technical support and an agent is recommending you to erase the pay table The present function erases the pay table in the database and creates a new one In these circumstances most of the times all the data entered for the current pay period in the pay window are lost However other sections of the database are not affected by this operation all the pays you posted in the database employee records etc 83 VSPS 2013 15 What to do when You hire a new employee new employee record must be created To do so in the VSPS main window click on the Employees icon Once in this screen you have to click on the New employee button and enter the information related to this employee In the employee record window you will notice that there
91. once the pay is completed you simply have to click on the Direct button In this screen once again if you wish you can always select the employees the default is all the employees Note that in the list only employees paid by direct deposit are listed After the selection is done you must click on the Create file button The program always saves this file in the subdirectory DirectDeposit Your business name DD in the VSPS folder by default C VSPS 2013 The name of this file is composed with the pay period the pay frequency and a sequential number for example Pay period 15 Freq 26 001 txt In case of error you can always redo the file creation In these circumstances the sequential number is incremented for example Pay period 15 Freq 26 002 txt In other words the most recent file is the one with the highest number at the end VSPS follows Standard 005 of the Canadian Payments Association which is the required norm for the exchange of financial data on AFT files containing 1464 characters per line To know how to send this kind of file to your financial institution you must contact your bank branch As required by law even if an employee is paid by direct deposit you have to give him his pay stub in order to let him know the payroll details number of hours current incomes and deductions cumulative results etc In the direct deposit screen to print the pay stubs simply click on the Print stubs button I
92. ou are a new user of the VSPS software it remains important to experiment with different selection criteria to have an idea of all the possibilities this report offers 48 VSPS 2013 List of all pays with possibility to erase cancelled pays This report lists all the pays that you have posted in the payroll database However the main purpose of this function is to allow you to delete pays that you have posted before In fact if for any reason you wish to delete a pay in the database you simply have to select this pay in the list by clicking the box in the Select column Once the selection is done you must click on the Erase button Of course the program will ask you to confirm this command Since this action is irreversible it is essential to take the time to verify the selection before this deletion List of all pays with possibility to erase cancelled pays 000000 Canada Inc Function Pay frequency All pay frequencies Detail per employee Yes Detail per pay Type of results Per pay results Period for report Year to date Employees All Name Search On Employee number Current file 2 Mary Something Select Pay period 1 John So And So 1 End 29 12 2012 Ch 03 01 2013 Mary Something 1 End 29 12 2012 Ch 03 01 2013 1 John So And So 2 End 05 01 2013 Ch 10 01 2013 Mary Something 2 End 05 01 2013 Ch 10 01 2013 1 John So And So 3 End 12 01 2013 Ch 17 01 2013 Mary Something 3 End
93. ou process a pay is to erase all data by clicking the Erase button This is important because this erases all overwritten cells cheque numbers and notes entered in the pay window When you will select the next pay period the pay window will be blank except for the hours entered in the time sheets for this pay period 40 VSPS 2013 12 G ledger General ledger This module is very interesting if you use a software for your accounting As mentioned before VSPS allows you to create files of journal entries that can be imported into several accounting programs Of course in order to be able to make journal entries for a pay period or for employer contributions the software needs to know which general ledger GL accounts to use Once you have indicated the accounting software you are using you must enter the GL account numbers for every department you created Remember that in the Company window VSPS enables you to register up to 10 departments Consequently you can affect different GL account numbers depending on the departments for example direct labour sales department office etc GL account numbers 000000 Canada Inc Account numbers in Accpac Simply Simple Comptable for department it 1 Sales Software Accpac Simply Simple Comptable Y P Department number 1 Sales Copy to another department Figure 12 01 First screen of the G ledger module 41 VSPS 2013
94. owed report In this case please refer to chapter 15 in section You forgot an employee in a previous pay period Detailed or summary payroll results for a given period of time When you choose this report you must select the criteria in the next screen Selection Detailed or summary payroll results for a given period of time 000000 Canada Inc TER Function Report selection Criteria All pay frequencies All employees C 1st pay frequency weekly C Selection by employees Reset selection 8 C Selection by departments ex 1 3 5 for departments 1 3 and 5 Detail per employee Yes C No Detail pay Yes C No f Per group C Per pay results Monthly results C Cumulative results per employee Year to date From To From 01 04 2012 April 1st 2012 To 31 03 2013 dd mm yyyy C For a month Based on cheque dates Based on end of pay period dates Select Name Dpt Pay frequency Job title John So And 50 Salesman Mary Something Bookkeeper F Pay dates Continue du Figure 13 03 Example of criteria for this report 46 VSPS 2013 As we can see in figure 13 03 on the previous page for this report many options are offered By default the report covers all the year to date but you can also choose a month or an interval of time Note that for this report the interval of time can even start in the previous year For example if a company has a M
95. partments ex 1 3 5 for departments 1 3 and 5 D 1 employee per sheet 2 copies 2 employees per sheet for Canada Revenue Select Name Dpt So And So John something Mary Figure 13 12 Print screen for T4 and T4 Summary 57 VSPS 2013 When you select the Summary tab the program displays the worksheet intended to help you fill out the T4 Summary form You can print this worksheet but as opposed to the T4 slips this is not an official form that you can send to Canada Revenue Agency Indeed you must fill out the T4 Summary form manually or use the dynamic pdf form i e t4sum fill 13b pdf for the year 2013 available from the Canada Revenue Agency web site or from www vsps123 com in the F A Q section It is recommended to print this worksheet and keep it for your records with a photocopy of the T4 Summary form Finally if the business has more than 50 employees a button will be displayed to create a file of the T4 slips in XML format This file must be sent to Canada Revenue Agency Remember that paper copies are not accepted if you have more than 50 employees In this case please contact us m 74 Current file 1 John So And So Function MALE Search Name C Employee number For the year ending December 31 2013 umber of T4 slips filed Employee s CPP contributions HS mployment income Employer s CPP contributions 77 Industrial Boulevard Somewhere QC JE 929 Employer s
96. period In these circumstances do not forget to click on the button Recalc totals Detailed or summary payroll results for a given period of time 000000 Canada Inc Function Pay window Indemnity calculation for a statutory holiday Pay frequency Detail per employee Yes Detail per pay Yes Type of results pay results Period for report From 07 03 2013 to 28 03 2013 cheque dates Employees Selected Regul LEF hours hours Teh Select Pay period John Sc And So si0End02032013Ch07032013 000 26 00 John Sonde 11 End 09 03 2013 Ch 14 03 2013 26 00 John Se And Sa 12 End 16 03 2013 Ch 21 03 2013 26 00 John Eo And Sa 13 End 23 03 2013 Ch 28 03 2013 26 00 TOTAL 150 5 4 n To go to the employee time sheet double click or press F3 on any hour cell Recalc totals MIHI Config Print Employees Calendar Figure 13 07 Detailed employee s pays for the chosen interval 51 VSPS 2013 It is important to note that you must click on the tab Indemnity calculation for a statutory holiday to view the worksheet used to calculate the compensation for the statutory holiday In this window depending on the province labour standards if needed you can modify some data for example the number of days to establish the average amount per day Detailed or summary payroll results for a given period of time 000000 Canada Inc Function Pay window Calculation of the indemnity for a stat
97. r a change for the hourly rate or the fixed salary you must indicate the effective date of this modification It is important to note that with VSPS you have to enter the cheque date For example if an employee receives a pay raise effective June 1st you must enter the cheque date of the pay period that includes June 1st In other words a salary change is always effective from the beginning of a pay period To help you determine the cheque date to enter the Pay dates button allows you to view the details for every pay period beginning of the pay period end of the pay period and cheque date If the salary change does not occur at the beginning of a pay period you can proceed in different manners Let us take the following example During a pay period an employee worked 16 hours at 10 00 per hour and 24 hours at a new hourly rate of 11 00 To calculate his pay the simplest way is to enter an amount of 24 00 in the Other income 1 column of the pay window only the amount of the raise and register the new hourly rate effective from the cheque date of the next pay period Another way is to use an average hourly rate of 10 60 Finally you could also proceed with Rate 1 and Rate 2 of the time sheet Addendum Other information change of hourly rates etc 000000 Canada Inc Function Current file 1 John So And So Hourly rate 1 Hourlyrate 2 Fixedsalary Otherdeductions Rate 1 Rate at beginning of the year __
98. ral income tax purpose the average earnings amount is then 360 00 per pay period For Quebec income tax purpose the average earnings amount is then 360 00 per pay period Federal income tax Federal income tax per pay period based on the calculated average earnings Number of pay periods considered Total federal income tax for this pay period If not the federal income tax would 489 64 a difference of 212 84 Quebec income tax Quebec income tax per pay period based on the calculated average earnings Number of pay periods considered Total Quebec income tax for this pay period If not the Quebec income tax would 582 82 a difference of Figure 16 02 The Results tab when paying vacation and using the average remuneration method for income tax calculation 88 VSPS 2013 You must correct a pay If you wish to make a correction in the current pay period you simply have to click on the Pay icon and enter the desired changes Do not forget to click on the Post button to save your modifications in the payroll database Remember that you can post your data as many times as you want Each time all data is updated replaced for this pay period When you make a correction you are allowed to issue new pay cheques and reprint the pay reports summary report detailed earnings etc If necessary you can create a new payroll journal entries file Furthermore if you already imported journal
99. re factor K3 Additional tax deduction for the pay period requested by the employee Employee remunerated by commission Total remuneration for the year as reported by the employee on the form TD1X commissions salary or wages Commission expenses for the year as reported by the employee on the form TD1X L Pay dates Esport basic New employee Calendar aut Figure 7 06 Fed income tax tab of the employee record When you select the Miscellaneous tab a window is displayed to register different information If an employee is paid by direct deposit instead of by cheque this window allows you to enter the information needed Note that in this screen you can modify for the current employee the IE employer contribution rate normally 1 4 times the employee contribution if this employee is covered by a private insurance Finally the Export basic info permits you to create an Access database containing the name address phone number and other employee information This file is always saved in the VSPS 2013 folder by default C VSPS 2013 and has an MDB extension The main purpose of this file is to allow you to print labels with programs like Microsoft Word Label Pro etc This database can also serve to send letters to your employees 23 VSPS 2013 8 Previous Vacation balance and cumulative previous pay report for 2013 before use of VSPS software Function 000000 Canada I
100. re selecting Yes in the Terminated box of the employee s record you have to be sure that you really finished all steps of the payroll process posting data in the database printing cheques or making the file for the direct deposit printing reports and if applicable creating the payroll journal entries file to import in your accounting program Finally concerning the production of the Record of Employment ROE please refer to chapter 13 You want to make a backup copy As mentioned before a payroll database is a file with a DL7 extension This database is created by VSPS and the name is composed of the business name followed by 13 DL7 For example if the business name is My company the file name will be My company Inc 13 DL7 The payroll databases are always in the VSPS installation directory by default C VSPS 2013 Because this folder also contains other information in the subdirectories we strongly recommend that you copy the complete VSPS 2013 folder You should always make external backup on a CD DVD or other device The best thing is to preserve this backup in a different location in case of fire theft etc 91 VSPS 2013 16 Quebec construction worker CCQ rules In order to be able to register this kind of employee in VSPS the first thing you must do is to obtain the payroll information from the CCQ One simple way to get this is to go on their website http www ccq org
101. refer to chapter 13 In the pay window when you have to register an amount as an annual vacation indemnity it remains very important to enter this amount in the Vacation column to ensure that the program subtracts this amount from the vacation balance of this employee Besides when you pay a vacation amount especially if this amount is paid at the same time as the regular remuneration the income tax deduction is often much higher than normal As explained in the following figure to reduce the fiscal impact in these circumstances VSPS offers an option to establish the income tax amount based on the fact that this remuneration is received for more than one pay period In fact as soon as you begin entering an amount in the Vacation column the following screen is displayed Informations about a vacation pay Function Current file 2 Mary Something Period 4 From 13 01 2013 to 19 01 2013 Cheque 24 01 2013 Data Results The present function is used to calculate income tax when a vacation pay occurs As we know when an employee receives his annual vacation pay the amount of earnings is often higher than the normal pay because usually the vacalion pay covers more than a pay period This amount is even greather when the vacation amount is paid with the last pay before vacation Let us take the following example employee makes 800 per week and the pay period is weekly His accumulated amount for annual vacation is
102. rielle 0 02 0 02 heure Taxe sur assurance 9 00 du montant d assurance Cong s et jours f ri s pay s 1 13 00 du salaire cotisable Fonds d indemnisation 0 02 heure Frais de participation volontaire au r gime d avantages sociaux part du salari 0 075 heure part de l employeur 0 075 heure Pr l vement minimum 10 00 part du salari 0 75 du total salaire cong s pay s part de l employeur 0 75 du total salaire cong s pay s Figure 16 01 Example of CCQ payroll data part 1 92 VSPS 2013 Cotisation horaire A E C Q 0 03 heure TPS et TVQ applicables min 5 00 Cotisation annuelle A E C Q 225 00 ann e TPS et TVQ applicables TPS applicable 5 000 TVQ applicable 9 975 1 Cette cotisation est pay e par l employeur 2 Le taux d quipement de s curit repr sente le maximum applicable et est pay par l employeur Veuillez vous r f rer aux conventions collectives 3 Pour les secteur A B et C la contribution sectorielle est pay e par le salari et pour le secteur D elle est pay e par l employeur 4 Cette cotisation s applique seulement aux heures rapport es sous le code de statut A H ou J du rapport mensuel Cotisations syndicales pay es par le salari Annexes B3 B6 N1 N4 Hebdomadaire 10 92 10 81 10 81 semaine Plus autres frais 0 055 0 055 0 055 0 055 heure Hebdomadaire 10 92 10 81 10 81 semaine P
103. rom the normal rate 1 4 times the employee s contribution ou must enter this rate in the Miscellaneous tab of the employee record Employees icon of the VSPS main Window 54 VSPS 2013 Source deductions and employer contributions to Quebec This function applies only to Quebec employers Since this report is similar to the one described in the previous section for more information please refer to this section Source deductions and employer contributions to Quebec for 2013 Function 000000 Canada Inc Quebec Period LIT uU Total Q P P cA EE employee employer employee employer January February March 4 April September October November December I TOTAL 1 148 64 1 148 64 restore overwritten formula press Delete this cell Figure 13 10 Source deductions and employer contributions to Quebec report 55 VSPS 2013 T4 3 w T4 Current file 1 John So And So ER Function Search On Name Employee number Summary Employer s name Year Employment income line 101 Income tax deducted line 437 15650 Employee s CPP contributions line 308 El insurable earnings 4 Employee s OPP contributions line 308 pensionable earnings Business number Province of employment a loyment code Employee s El premiums line 312 Union dues line 212 Exempt S LN 28 c p gpp
104. ry simple look and detailed results Exceptional flexibility substitutions allowed for most of the calculated fields possibility to modify and even erase a pay possibility to reprint cheques reverse a batch of payroll journal entries etc Time sheets with option to attribute hours to projects i e research and development training activities customers etc VSPS 2013 Journal entries with possible exportation to many accounting programs Accpac Simply Accounting Acomba QuickBooks etc Very useful reports e Previous pay report with corrections allowed e Detailed or summary payroll results for a given period of time upon different criteria e Source deductions and employer contributions per period monthly quarterly etc e Detailed report for vacation to pay e Record of employment ROE when an employee quits definitely e T4 and Relev 1 slips e Hour and cost report for a given project and selected employees A user friendly approach Even if VSPS is very easy to use we strongly recommend that you take the time to read this manual to explore all power and options that this software provides to get your money s worth SYSTEM REQUIREMENTS IBM PC or compatible Pentium 2 processor or higher At least 512 MB megabytes of memory RAM Windows XP or Vista or Windows 7 or Windows 8 50 MB of free hard disk space Video display with at least 800 x 600 resolution Internet connect
105. s for federal AND provincial Fixed amount Private health care insurance Quebec Fixed amount Other taxable benefits for PROVINCIAL only per hour Other taxable benefits for FEDERAL only Fixed amount Figure 16 05 Example of the taxable benefit Quebec only 96 VSPS 2013 Next you must select the Deduct tab to configure the union dues and the contributions for pension plan It is very important to enter the data for these two elements on the right lines If not the amounts will not appear correctly on the T4 and Relev 1 slips Concerning the pension plan the line to be used is Registered pension plan RPP You have to enter only the employee s portion do not include the employer s contributions As for any deduction in both cases you have to double click on the box to the right of the label A screen will be displayed to define how the deduction must be calculated Regarding the union dues depending on the occupation and the union sometimes there can be several parameters amount per pay period amount per hour minimum maximum etc Employee profile Construction 12345 Qc Inc Name A earc Employee number Current file 1 John One Exemption for Canadian employment insurance El C Yes No Exemption for CPP QPP Canadian or Quebec pension plan C Yes No Exemption for Quebec parental insurance plan C Yes No Union or professional dues
106. s occurs the employee quits his job is laid off or terminated etc It remains very important to refer to the law to correctly fill out this form You can consult the government web site servicecanada gc ca in the All Canadians section click on Employment Insurance El click on Employment Insurance Information for Employers and click on How to complete the ROE form The ROE form must be filled out manually or electronically However VSPS enables you to print worksheet to help you fill out this form When you must fill out ROE form first you have to go in the employee records Employees icon of the VSPS main window to enter the first day of work even if this is several years ago However If a ROE form was ever issued for this employee you must enter the first day worked after the last ROE form was filled out In the employee record you must also enter the last day of work 68 VSPS 2013 Worksheet for the Record of employment ROE 000000 Canada Inc Function Information for the ROE of 1 John So And So Employee selection Worksheet BEFORE you select the present report you must enter the date of the first day of work since the last Record of employment ROE and also the date of the last day of work in the employee profile 3 Name Search On C Employee number Number of the selected employee in this software Name of this employee Employee 5 I N First day of work since
107. st 2013 To 31 03 2013 dd mm yyyy Pay frequency Job title John Sa And So Salesman Mary Something Bookkeeper _Continue Figure 13 21 Criteria for the Vacation to pay at a certain date for selected employees report 65 VSPS 2013 Vacation to pay for selected employees 000000 Canada Inc Function On March 31 2013 Vacation to pay Remuner Vacation Vacation Amount of Va for vacation balance at earned for vacation Adjustment bala calculation beginning this period paid th 1 John So And So 12 526 50 501 06 2 Something 11 765 00 1 197 31 470 60 m TOTAL 2429150 247464 371 66 PC Figure 13 22 First part of the Vacation to pay at a certain date for selected employees report 66 VSPS 2013 Vacation to pay for selected employees 000000 Canada Inc PRI Function On March 31 2013 Vacation to pay Vacation Vacation Amount of Vacation balance at earnedfor vacation Adjustment balance at beginning this period paid the end 1 John So And So 1 276 73 501 06 0 00 1777 79 2 Mary Something 1 197 91 470 60 0 00 1 668 51 EM TOTAL 2 474 84 371 66 000 344630 o E o Figure 13 23 Second part of the Vacation to pay at a certain date for selected employees report 67 VSPS 2013 Record of employment ROE This function aims to help you fill out the Record of Employment ROE form when an interruption of earning
108. sults for a given period of time Construction 12345 Qc Inc Function Pay window monthly report part 1 monthly report part 2 Pay frequency All pay frequencies Detail per employee Yes Detail per pay Yes Type of results pay results Period for report For June 2013 pay period dates Employees Selected Pay period ilein One 23 End 01 06 2013 Ch 06 06 2013 Tus 23 End 01 06 2013 Ch 06 06 2013 1 John One 24 End 08 06 2013 Ch 13 06 2013 2 John Two 24 End 08 06 2013 Ch 13 06 2013 TiehwOne 25 End 15 06 2013 Ch 20 06 2013 First tab of the CCQ monthly report Figure 16 09 101 VSPS 2013 The screen of the second tab displays the data required to complete the first part of the CCQ monthly report one line per employee Thus in this window there is all the information required for each employee occupation code region code etc and the monthly results hours assessable earnings CCQ vacation union dues etc In this tab if needed the user can modify most of the data When you overwrite an amount a red star is displayed to the right of this field As indicated at the bottom of the screen to restore an overwritten formula position the cursor on this field and press Delete on your keyboard The following figures show the columns of this report Detailed or summary payroll results for a given period of time Construction 12345 Qc Inc Function Pay window CCQ month
109. t pay cheque 03 01 2013 Other pay frequency optional No other frequency X Pay cheques are issued days after the end of pay period Date of the beginning of the 1st pay period Ces dd mm yyyy Next date if semi monthly frequency dd mm yyyy Health Services Fund rate Quebec QHSF 2 7000 2 Ex enter 2 7 for 2 7 Ontario 0000 Calendar Qt Figure 6 02 The Pay tab of the business information window As we can see in figure 6 02 the program allows 2 different pay frequencies For example a business could pay some employees on a weekly basis and others on a bi weekly basis 10 VSPS 2013 In the Departments tab you are allowed to name up to 10 departments i e direct labour sales department office etc We have to mention that in the employee window the department number is obligatory because this information is needed for some reports This is why by default when you create a new employee file the department number is 1 but you can always change this number Business profile information 000000 Canada Inc ER Function Other income and deduct Projects CSST Otherinfo ou can classify your employees by department ie sales factory administration etc In fact the program allows you to generate payroll reports based on the selected departments Furthermore for GL entries the program also allows you to enter different GL accounts for each depart
110. te If the salary change does not occur at the beginning of a pay period you can proceed in different manners Let us take the following example During a pay period an employee worked 16 hours at 10 00 per hour and 24 hours at a new hourly rate of 11 00 To calculate his pay the simplest way is to enter an amount of 24 00 in the Other income 1 column of the pay window only the amount of the raise and register the new hourly rate effective from the cheque date of the next pay period Another way is to use an average hourly rate of 10 60 Finally you could also proceed with Rate 1 and Rate 2 of the time sheet 84 VSPS 2013 Concerning the vacation rate because this rate can change during the year a box is reserved for any vacation rate modification It is important to note that you must not enter the new rate in Rate 1 field because this field is used for the vacation rate effective at the beginning of the year As indicated in the screen you must enter the new vacation rate in Rate 2 box and enter the cheque date of the pay period that includes this change You have to pay an amount for a statutory holiday In Canada workers are entitled to an indemnity or a compensatory leave for each of the statutory holidays New Years day Christmas Day etc For example in Quebec according to the Commission des normes du travail www cnt gouv qc ca usually the compensation to pay to an employee is 1 20 of the wages
111. ted in the ledger module your accounting software and all the needed account numbers for the payroll processing For more details please refer to chapter 12 At the beginning of each journal entry in the Exp column the mention Yes indicates that this journal entry will be included in the export file If for whatever reason you wish to exclude a journal entry you have to double click on the check box to display No The program always saves the journal entries export file in the subdirectory Export Business name XP of the VSPS folder by default CAVSPS 2013 The name of this file is composed of the pay period the pay frequency the mention Export and a sequential number for example Pay period 15 Freq 52 Export 001 TXT If needed you can click the Export button as many times as you want Each time the sequential number at the end of the file name is incremented for example Pay period 15 Freq 52 Export 002 TXT when you click for the second time in the same pay period As soon as the file is created journal entries can be imported in the general ledger of your accounting software You must refer to your accounting program user manual or call their support service Usually the file importation remains quite simple to perform Because it is normal to make errors VSPS even allows you to reverse the journal entries Therefore if you ever import GL entries of this type into your accounting software and some of
112. them contain errors the best way to correct the situation is often to reverse all of them Then you can make the necessary corrections and create a new export file To reverse a batch of journal entries you must click on the Select Exported GL entries and select the export file This file is easy to identify because its name makes reference to the pay period and the pay frequency When the journal entries are displayed you simply have to click the Reverse GL entries button to make all debit amounts become credit amounts and vice versa After that you just have to select Export again and import this new batch of journal entries into your accounting software to void the previous posting This new export file is easy to recognize for example REVERSAL Pay period 1 Freq 26 Export 001 TXT 39 VSPS 2013 Entries 000000 Canada Inc Pay 3 from 06 01 2013 to 12 01 2013 Date of cheques 17 01 2013 Freq 52 Exp Account References Basic salary QPP Gc tax EI Fed tax Net salary to pay Pay 3 Ending 12 01 2013 Net salary to pay Bank John So And So Ch 1850 Net salary to pay Bank Mary Something Ch 1851 Date for GL entries 17 01 2013 Total DR 328192 TotalcR 3 281 92 Before exporting your entries be sure to fill in your GL account numbers in GL function Select exported GL entries Figure 11 06 Payroll journal entries window Finally the last thing to do when y
113. tributions to Quebec T4 Relev s 1 Detailed vacation to pay to an employee Vacation to pay at a certain date for selected employees Record of employment ROE List of employees Hour and cost report for a selected project C C C C C C E C C L Paydates Continue Quit Figure 13 01 Report selection window 44 VSPS 2013 Previous pays with corrections allowed This report is used to review every previous pay that you have posted in the database When loading the screen always displays the pay period 1 To select the desired pay period you have to click on the arrow pointing down until the desired pay period is displayed and click on the Confirm button This report can be useful in many circumstances For example if you forget to create a file of journal entries to import into your accounting program the present function gives you the chance to create this file You simply have to click on the DR CR to display the journal entries for this pay period Then all you need to do is to click on the Export button It is also possible to reprint all the pay reports for a chosen period summary report detailed earnings etc by clicking on the Print button Previous pays 000000 Canada Inc Function P Period ATE Weekly 52 or 53 pays per year Y adres a From December 23 2012 to December 29 2012 Date of cheque January 3 2013 Name Findnext Search
114. u Quebec with the source deductions and employer contributions to Quebec Business profile information 000000 Canada Inc Function Basicinfo Pay Departments Groups Otherincome and deduct Projects CSST Otherinfo CSST for Quebec employers only Rate at beginning of the year example if 1 8 enter 1 8 effective from 99 0000 effective from I dd mm yyyy X effective from dd mm yyyy iCalendar Figure 6 07 The CSST tab of the business information window 15 VSPS 2013 The Other info tab is used to enter the information needed when an employer wants to pay his employees by direct deposit instead of printing cheques You can obtain this information by contacting your bank In this window you can also enter 5 lines of notes Business profile information 000000 Canada Inc Function Basicinfo Pay Departments Groups Otherincome and deduct Bank transfer information for direct deposit Business name for direct deposit Summary business name max 15 characters 1 riginator ID number for direct deposit 10 characters O Financial institution number Please make selection Financial institution data center number 5 digits Branch routing number 5 digits second group of digits on the bottom of the cheque Account number usually 5 to 9 digits last group of digits on the bottom of the cheque L
115. u can only process payrolls for businesses that you purchased the VSPS 2013 license for The control of the authorized businesses is done by the coded file NAMES 13 TXT This file is sent to you by email You must copy the NAMES 13 TXT file in the VSPS 2013 installation directory by default C VSPS 2013 When you start the program you can only open a file for an authorized business meaning for which the name is coded in the NAMES 13 TXT file Each user has a unique NAMES 13 TXT file Note that this file can contain several authorized business names Concerning the payroll database this file is saved with a DL7 extension This database is created VSPS and the name is composed of the business name followed by 13 DL7 For example if the business name is My company the file name will be My company Inc 13 DL7 The payroll databases are always in the VSPS installation directory by default CAVSPS 2013 However if you wish to make a backup we strongly recommend that you copy the complete VSPS 2013 folder since it also includes other important information in the subdirectories You should always make external backup on a CD DVD or other device The best thing is to preserve this backup in a different location in case of fire theft etc From the first use of this software for a business once you have copied the NAMES 13 TXT file in the VSPS 2013 directory you can then create the new payroll database To do so i
116. utory holiday Considering the 4 pay periods before 04 04 2013 from 07 03 2013 to 28 03 2013 cheque dates Employee 1 John So And So Itis essential to consult the laws in effect in the province Amount included in the earnings Vacations included 00 Tips included Total earnings before benefits Overtime included Overtime to exclude for the indemnity calculation Other adjustments you can enter a positive or a negative amount Total if negative 0 Number of days to establish the average amount per day Average per day which is the indemnity for the statutory holiday To restore an overwritten formula press F8 being in that cell Figure 13 08 Worksheet to calculate the indemnity for a statutory holiday 52 VSPS 2013 Source deductions and employer contributions to Federal As an employer you have to remit the CPP contributions the El premiums and income tax deducted from your employees income along with your share of CPP contributions and El premiums This report displays the detailed amounts to pay to the federal government as source deductions and employer contributions for each of the remittance periods Remember that the remittance frequency monthly quarterly etc must be indicated the business information window icon of the VSPS main window The present report gives you all the necessary data to fill out your remittance form including the gross payroll
117. y holiday In these circumstances a red star appears indicating that this is an overwritten cell You have to pay an amount for annual vacation Normally an employee is entitled to a vacation each year For example in Quebec the entitlement to a vacation is acquired during a period of 12 consecutive months Known as the reference year this period extends from May 1st to April 30 The length of vacation and the indemnity are established based on the employee s period of uninterrupted service Prior to the start of his vacation the employee must receive his annual vacation indemnity This amount must be equal to 4 or 6 if the employee has 5 years or more of uninterrupted service of the gross annual wages earned by the employee during the reference year In other provinces an employer can choose the common anniversary date for vacation similar to the reference year in Quebec 85 VSPS 2013 Obviously to be sure to properly calculate the indemnity and the duration of vacation you should consult the applicable laws in your province For example in Quebec you can visit the Commission des normes du travail web site www cnt gouv qc ca With the VSPS software to establish the amounts of annual vacation to pay first you have to click on the Reports icon In the report selection choose Vacation to pay at a certain date for selected employees and click on the Criteria tab As we can see in the following figure
118. y report it remains possible to generate a report in which you can obtain monthly data for selected employees those subject to CCQ rules For more details please refer in chapter 13 of this user manual to section Detailed or summary payroll results for a given period of time In the criteria for this report first you must only select the employees that are subject to CCQ rules Then you have to choose No for Detail per pay select Monthly results select For a month and choose the desired month It is also very important to note that you must select the option Based on end of pay period dates instead of Based on cheque dates You will then obtain for each of the employees the CCQ worked hours the earnings and the deductions for the selected month With this information it also becomes possible to calculate manually all the employer contributions for the purposes of the CCQ monthly report 106

User manual

Contents

Download Pdf Manuals

Related Search

Related Contents