The Satellite Bookkeeper
Your Virtual Legal Bookkeeper
Payroll Worksheets
Are you still using CRA tables or the online calculator to do your payroll?
We offer custom designed Excel payroll workbooks, suitable for use by small firms
doing their own calculations for payroll deductions. The standard workbook
includes worksheets for two employees and one spare employee sheet. The
individual worksheets calculate the federal and provincial income taxes, CPP and EI
deductions, the employer contributions for CPP and EI, and also tracks accruing
vacation pay. At the end of the year, totals for each employee are displayed at the
bottom of their page, making the completion of T4s a simple task.
The totals page gathers all of the calculations to one worksheet, and provides a
final amount to remit each quarter. This page is also useful for budgeting and
year-over-year comparisons.
Clicking on each of the links below will open sample sheets in separate windows.
You can flip back and forth between them, just as if you were viewing the
workbook. The shaded areas represent the location for entering an employee's
gross wages - the worksheet calculates everything else for you.
We offer custom designed Excel payroll workbooks, suitable for use by small firms
doing their own calculations for payroll deductions. The standard workbook
includes worksheets for two employees and one spare employee sheet. The
individual worksheets calculate the federal and provincial income taxes, CPP and EI
deductions, the employer contributions for CPP and EI, and also tracks accruing
vacation pay. At the end of the year, totals for each employee are displayed at the
bottom of their page, making the completion of T4s a simple task.
The totals page gathers all of the calculations to one worksheet, and provides a
final amount to remit each quarter. This page is also useful for budgeting and
year-over-year comparisons.
Clicking on each of the links below will open sample sheets in separate windows.
You can flip back and forth between them, just as if you were viewing the
workbook. The shaded areas represent the location for entering an employee's
gross wages - the worksheet calculates everything else for you.
Please contact our office for pricing, as there are too many variables
involved to publish set prices. The variables include the number of
employees, pay periods, and tax brackets, to name but a few.
involved to publish set prices. The variables include the number of
employees, pay periods, and tax brackets, to name but a few.
 |
| |
 |
| |
 |
| |
 |