Tracking Hours For Breck SRS Instructors


As Breck SRS instructors, we need to protect our assets.  Not just our health, not just our teaching abilities, but our time as well.  After all, our time is valuable and with the multitude of lesson products and pay scales we operate under, the system can wind up with errors.

That’s why I decided to look after my own paycheck.  Because I value my time and I’d prefer to make sure I get out what I put in.  If you feel the same way, download the attached spreadsheet, and keep reading to learn how simple it is to make sure you know the deal.

Breck SRS Time Sheet

Pay Rate

As we all know, there are several different wages for several different categories of the duties we perform.  When you open the spreadsheet, the first tab you will see is the one called Pay Rate.

Screen Shot 2014-03-18 at 8.01.00 PM

This page has the various different types of work we do and their associated pay scales.  For more details on those designations, see the Breckenridge Employee Manual, Pro Pay System.

The first thing you’ll need to do is input your teaching wage.  From there, the spreadsheet will automatically calculate your private request (time and a half) wage.

Screen Shot 2014-03-18 at 10.07.55 PM

You’ll also notice that there are separate lines for your teaching wage with points incentive bonus.  The points incentive bonus pay scale is contained in the spreadsheet to more easily keep track of your rightful wage.  We’ll touch on how to track your incentive points later, but for now just know that you’ll enter your adjusted pay in total in this box.  (E.g. if your base wage is $10.95 and your points bonus is $0.50, then you’ll enter $11.45 in this box.)

Activity Log

Once the Pay Rate is setup, you’ll need to make your way over to the Activity Log tab.

Screen Shot 2014-03-18 at 8.49.12 PM

Here we can track our pay with clarity.  To begin, you’ll need to keep track of your hours so you can input them in the sheet.  An easy way to do so is to take a picture of your Time Sheet each day, or just keep track in a notes app in your phone.

Once you have something to input, you can open the spreadsheet, and enter each different line item from your time card as a line item for that date on the spreadsheet.

Screen Shot 2014-03-18 at 8.55.02 PM

The date column is setup to automatically fill in the dates, but when you have multiple line items, you’ll need to type in the date on the lines required.

Screen Shot 2014-03-18 at 9.12.23 PM

You can then input the type of work you did using the drop down menu under the Type column.  Just click in the cell, then click the drop down arrow next to it.

Screen Shot 2014-03-18 at 9.14.53 PM

Once the type of work is selected, the spreadsheet will automatically fill in the pay rate with data from the Pay Rate tab.  All you have to do is input the hours worked and the spreadsheet calculates the total.

Screen Shot 2014-03-18 at 9.19.36 PM

 You can then use the notes column for any notes you want to make about the day, for example, if you did a park pass clinic, or it was a private lesson that hasn’t yet rolled.

Keeping Track

Once your day’s data has been input, you can check it against what is on the Breck Instructor Tools website.  If it checks out, just put an x in the Checked? column.

Screen Shot 2014-03-18 at 9.40.51 PM

From there, we can keep track of the total pay during the pay period by simply using the Sum button in Excel.

Screen Shot 2014-03-18 at 9.42.43 PM

 In the SRS Pay Period Column, type in the pay period dates, then select the cell next to it in the Gross Pay column and click on the Sum button.

Screen Shot 2014-03-18 at 9.48.27 PM

This will automatically highlight some cells, but we are going to ignore that and select the cells in the Total column that correspond with the date range we want to total.  Just click on the first cell and drag it to the last cell in the range.  Click on the image above for a detailed screenshot.

Incentive Points

Screen Shot 2014-03-18 at 9.56.07 PMWe can effectively keep track of incentive points and our corresponding pay raises as well.  Whenever you input a qualifying activity on your Activity Log tab, open up the Incentive Points tab and post it under the Incentive Points column.

Screen Shot 2014-03-18 at 10.00.05 PM

The Total Points column will tally them for you completely, then the total will automatically show up under the Pay Rate tab, where you can reference the above chart and adjust your Teaching (+Points Incentive) pay accordingly.

Pay attention to when you hit these thresholds and update accordingly!  If you just hit your first threshold, make sure to start using Teaching (+Points Incentive) when you input your pay type on the Activity Log tab, rather than the Teaching (Base) pay rate.

The Bottom Line

Tracking your pay is a great way to not only ensure that you get every dollar that you earned, but also to keep an eye on your incentive points and to make sure all your returns are entered in correctly, and that you get the priority points as well.

Don’t forget, you can request a pay breakdown to check against your Gross Pay in your spreadsheet.  Just talk to your payroll supervisor!  We can also access paystub information through

Questions or comments?  Drop a line below!

If this post appealed to you, check out the Run Your Life Like a Business series.  There you’ll find a lot of useful information on tracking personal expenses!


Drop a line...

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s