Backpay Calculator for 2018 CS CA

How this calculator works

After entering in all your details this calculator breaks everything down into periods which are ranges of dates with the same yearly, hourly, and/or daily rate of pay.

For example, let's say you became a CS-02 (step 1) on August 1, 2017. This collective agreement will come into effect on . No backpay will be calculated before the start date of the collective agreement. So, from to your annual rate of pay will be $70 439. That's the first period. Then on you have your 1 year anniversary as a CS-02 and you move up to step 2. From to you'll have an annual rate of pay of $72 694. That's the second period.

If you start an Acting period, that starts a new period which goes until your pay changes again, either through a raise in the collective agreement, the end of your Acting period, or an anniversary raise.

Anything which causes a change in your rate of pay starts a new period. And the period lasts as long as you're at that rate of pay.

When you click "Calculate", the calculator takes your yearly rate of pay to get what step you're at, and when your anniversary date is (if you're not yet at the highest step). It takes all your acting periods, and leave-without-pay periods and creates a succession of periods each with its own rate of pay. Then for each of those periods it calculates what you did make (based on the top rates in the last collective agreement), and what you would have made had the current offer/tentative agreement been signed by the start date of that agreement. The Results table, which appears below the Calculate button after it's clicked, shows these, and the difference, your level, your step your rate of pay, and the number used to calculate that rate of pay.

For each of those periods the calculator counts the weekdays in the period and multiplies that by the daily rate of pay at that step. This calculator assumes you work full time hours on a regular schedule. This will not work for those on part time schedules, or who work erratic schedule.

Within each period, extra money made through overtime, or standby, or vacation cash-out will be paid out based on your rate of pay at that time.

Using the above example, if you do 4 hours of overtime at time-and-a-half on , that's part of the first period. In terms of calculating your backpay, it doesn't matter when exactly you did that overtime. All that matters is what your rate of pay was in that period. That's why the dates aren't the same in the results table as what you entered into the date fields.

That also means that if you do one hour of overtime once a week for 4 weeks during a particular period, you don't need to add 4 separate overtime amounts. Instead pick a single date in that period and enter 4 hours.

What This Calculator Doesn't Do

Parental Leave
This calculator doesn't handle parental leave. I'm not sure how that works. If you know how it works, and want it added, submit an issue on the GitHub Repo with a link or explanation of how it works. Or fork this repo, add it, and submit a pull request.
Collective agreements other than the PIPSC CS groups
Eventually, I'd like to build that in. So if you're a CS with CRA, this won't have your numbers. If you're an AS, then this won't be of help.
Part time work
If you work only 3 days a week, or 5 hours a day, this won't help you. Maybe one day.

What's New

Your Information

Note: All dates should be formatted as YYYY-MM-DD.

For example, if you started as a CS-02 on March 15, 2015, enter .

(ie: either the date you stopped being a CS, or when the contract is implemented.)
Promotions

Were you promoted (to another CS level) during this time? (Promotions to EX should be considered as Leave Without Pay.)

Acting
Leave without Pay
Overtime / Standby

You don't need to put every single overtime instance in. Just a total of hours for each rate (1.5 or 2.0) for each period. Example: if you worked for an extra hour every day for a week where your pay rate didn't change, enter any date within that week, and enter 5 for the number of hours, and 1.5x for the rate.

Lump Sum Payments

Example: unused vacation cash-out.

Results

All amounts are gross. You'll have to figure out your own taxes. (And sometimes your taxes are pretty gross! Nyuk nyuk nyuk)

Pay periods
Period What You Made What You Should Have Made Backpay Amount