Spreadsheet: 35810d1233515062-payroll-sheet-with-canada-pension-plan-calculation-that-needs-fine-tuning-copy-of-new-payroll-spreadsheet-with-broken-cpp-calc
Sheet: payroll sheet with broken calc

federal tax rate calculation
59141.45999999999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CPP Rate is 4.95 % of all earning between $3,500 and $46,200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EI Rate is 1.73% of all earnings between $0 and $42,300
Provincial Tax Calculation
50.328
 |  |  |  |  |  | [NAME] | 35
 |  |  |  |  |  | Holiday % Rate | 0.04
 |  |  |  |  |  |  |  |  |  |  | Taxes |  |  |  |  | Canada Pension Plan |  |  | Employment Insurance
 |  |  |  |  |  | Pay Period | Date | Hours Worked | Gross Wages | Wages YTD | Prov | Fed | Additional | Total | Tax YTD | Deducted |  | CPP YTD | Deducted |  | EI YTD | Net Due | Accrued Holiday Pay | Less: Advances or Holiday Paid Out
 |  |  |  |  |  | 1 | 2009-01-02 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -100
 |  |  |  |  |  | 2 | 2009-01-09 00:00:00 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | g | 0 | 731.79 | 731.79 | -2850.39 | 0 | -500
 |  |  |  |  |  | 3 | 2009-01-16 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
92100 |  |  |  |  |  | 4 | 2009-01-23 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 5 | 2009-01-30 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 6 | 2009-02-06 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 7 | 2009-02-13 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0 | -500
 |  |  |  |  |  | 8 | 2009-02-20 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  | 250000 |  |  | 9 | 2009-02-27 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 10 | 2009-03-06 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 11 | 2009-03-13 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  | 8500 |  |  | 12 | 2009-03-20 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 13 | 2009-03-27 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 14 | 2009-04-03 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 15 | 2009-04-10 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 16 | 2009-04-17 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 17 | 2009-04-24 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 18 | 2009-05-01 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 19 | 2009-05-08 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0 | -1000
 |  |  |  |  |  | 20 | 2009-05-15 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 21 | 2009-05-22 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 22 | 2009-05-29 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 23 | 2009-06-05 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 24 | 2009-06-12 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 25 | 2009-06-19 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 26 | 2009-06-26 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 27 | 2009-07-03 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 28 | 2009-07-10 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 29 | 2009-07-17 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 30 | 2009-07-24 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 31 | 2009-07-31 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 32 | 2009-08-07 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 33 | 2009-08-14 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 34 | 2009-08-21 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 35 | 2009-08-28 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 36 | 2009-09-04 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 37 | 2009-09-11 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 38 | 2009-09-18 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 39 | 2009-09-25 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 40 | 2009-10-02 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 41 | 2009-10-09 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 42 | 2009-10-16 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 43 | 2009-10-23 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 44 | 2009-10-30 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 45 | 2009-11-06 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 46 | 2009-11-13 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 47 | 2009-11-20 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 48 | 2009-11-27 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 49 | 2009-12-04 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 50 | 2009-12-11 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 51 | 2009-12-18 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  | 52 | 2009-12-25 00:00:00 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 2118.6 | 0 | 0 | 731.79 | 0 | 0
 |  |  |  |  |  |  | Estimated Yearly Earnings | #N/A | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 2118.6 |  |  |  |  |  | 0 | -2100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Due (owed) | -2100