In an effort to speed up the payroll process, I did up an Excel workbook with in/out time columns that calculates total hours worked in a 14-day period, and the Gross $ Total for the pay period based on the wage.

However, I want to take the Gross Total and perform the calculations that the Canada Revenue Agency online calculator (http://www.cra-arc.gc.ca/esrvc-srvce.../pdoc-eng.html) does directly in the Excel workbook. Since these are hourly positions, rather than salaried ones, the hours may change from pay-period to pay-period. As such, it would be time consuming to need to go back to the on-line calculator every two weeks to redetermine deductions.

The following data is an example of what I have to work with...

Wage: $9.00/hr
Hours per Week: Variable, determined by timesheet input (max 40)

These are the rates (on the Gross) that I believe the CRA calculator is deducting (as of April 1, 2009)...
CPP rate: 4.95%
EI rate: 1.73%
Fed. Tax.: 15% (Minimum)
Prov. Tax.: New Brunswick?


Simplified Example: Considering a New Brunswick incorporated small business in the minimum bracket with no other deductions than mandatory... What would be the deductions from a $720.00 bi-weekly pay cheque (80 hrs @ 9.00/hr). This can be easily found on the website above. Now how do I make Excel do that?

Hope this wasn't too confusing...


Thanks!