Although MoneyWorks does not include payroll calculation tables, payroll cheques can be processed within MoneyWorks recording the expenses and liabilities.
The deductions for income tax withholdings, CPP and EI deductions, along with any other source deductions must be calculated outside of MoneyWorks.
The Federal & Provincial tax rates (amount of tax to be deducted) are available at the Revenue Canada site here, the CPP deductions here the EI deductions here and you can use the online Payroll Calculator here.
The standard Canadian business charts included as customizable templates, list the Canadian Payroll Deduction, Current Liability accounts and Expense accounts.
Current Liability account 2600, 2610 and 2620 being the employee deductions that will record the liability for each payroll cheque.
Current Liability account 2630 the Employers EI & CPP share that can be used if you are recording the liability on each payroll before remitting to the government, (Usually larger businesses).
Expense account 7010 to record the total Wages per employee on each payroll.
Expense account 7120 the CPP/EI paid by the employer, which you could use alternatively to Account 2630 above, recording the employer’s remittance for CPP & EI amounts directly to the expense, at the time of remitting to the government. Again for larger businesses with large payrolls.
In other words you may not need to use 2630 if you only record the employers liability at the time of remitting. Your choice.
Note: Account 7140 Health Plan is an example of other payroll deductions that you may have, which have to be recorded at the time of payroll and remitted to your provincial government.
Recording Payroll Payments
In this example Tom Smith is an employee of an Ontario business who makes $35,000 a year and is paid every two weeks.
The first line of the Payment is Tom’s Gross biweekly pay before deductions, charged to the Wages expense account.
The following lines are the Liability accounts listed above that are entered as negative amounts. Resulting in Tom’s gross pay or take home of $1,056.26.
As Tom is a regular employee you can set Tom’s Payroll payment up as a recurring entry for every 15 days or some other frequency at which time a new unposted transaction will be created with these details on that date. Since new recurring entries are unposted you can simply change the cheque number, or any other details, i.e. an employee reaching the maximum deductions for EI and CPP. and then post. Saves a lot of re-entry.
Tom’s Payroll Cheque if printed on a three part form will print out with the details listing the Gross pay less deductions as entered in the detail lines of the payment, thus giving Tom a record of the deductions taken on his behalf.
Remitting to Revenue Canada
At some point in time you have to remit the funds that you have withheld on the employee’s behalf to Revenue Canada.
In our example we remit once a month and we only have one employee old reliable Tom. So our payroll remittance recording the two cheques Tom received in January would be entered like so…
The first line being account 2600 for the total Taxes withheld for the month (using the account enquiry for the totals per account for the month) or $615.30 in our case.
Then the CPP withheld and the EI withheld from the employees, charged to their respective liability accounts.
Or in accounting terminology we originally debited the liability accounts with a negative amount when creating the Payroll payments, and now we are debiting the same liability accounts with a positive amount, which zeros out the balances, thus eliminating the liability.
The Employer’s portion or contribution, sometimes referred to as the Employer’s Burden is also recorded at this time where the EI share is 1.4 x the amount deducted and the CPP share is equal to the amount deducted. These two entries are recorded directly to the Expense account 7120, CPP EI Paid (the Employer’s share) or two separate expense accounts if you set them up in your chart of accounts. Your choice.
For companies that require or desire a standalone Payroll package, MoneyWorks will import payroll files that were created in CheckMark Payroll, which is a full function Canadian Payroll application that runs on Mac & Windows, producing T4 statements etc. Transactions exported from CheckMark can be imported into MoneyWorks Gold or Express as individual payments for each employee.
For more information about MoneyWorks Support in Canada, in the USA, or in the UK contact www.moneyworkssupport.wordpress.com