Hey Frieda,

Thank you for your feedback. My accountant brought in some extra help to get this all sorted and we’ve refined my original couple of sheets. Here’s the final version:

https://docs.google.com/spreadsheets/d/1tW_yI1LYIvA1HMpeXup6lbsPsXs-NwZKtiohb3ydnMo/edit?usp=sharing

A note from my accountant:

Just enter the numbers in the cells that are highlighted blue. Everything else is formula driven. You would use one of these for each employee, or have separate tabs in the worksheet.

The cells that are highlighted yellow are ones that could be hidden if you want, they’re really just there to work things out in the background.

The employee in the example sheet qualifies for an additional 15% of annual income if we hit our high annual target. Pretty sweet!

~James