Is everyone calculating commission in a spreadsheet?

Question

I have a landscaping business.&nbsp;I have a pay for performance model, pay out for google reviews, and am thinking about providing sales people with a commission for specific types of jobs.&nbsp;Right now, I use a whiteboard to show the crew and calculate in Excel. Is there a better way to do this? I feel like paying a flat rate (percentage of invoice or flat rate per sale) is simple. But when it comes to tracking hours, or paying based on margins, upsells etc. It can get pretty complicated tracking everything in Excel.&nbsp;&nbsp;

matthewl · Answer

This is our Review board. &nbsp;$25 per review paid out at the end of the quarter. &nbsp;About $2500 by the end of quarter 3. &nbsp;Quarter four we have this plus the “door hanger” contest. &nbsp;Pass out the hangers to neighbors of jobs. &nbsp;Write your name on it. &nbsp;CSR will ask the caller whose name is on it. &nbsp;$1000 to the winner at our quarter 4 mtg the week before Christmas. &nbsp;For commission we give our sales guy a decent weekly salary plus 2% commission on all jobs. &nbsp;He keeps track of the jobs completed and &nbsp;turns it in each week and we just double check it. &nbsp;We specialize in fence and decks so he earns an extra $100 for each of these sold. &nbsp;Works well for us. &nbsp;If a technician gets an upsell they also get 2%. &nbsp;If anyone brings us a job that was not our original Lead such as a friend or family member etc. &nbsp;we give them 25% of the profit for that job. &nbsp;

ryaantuttle · Answer

We created something very similar for realtors utilizing Zapier &amp; Airtable.Realtors are able to track all of the referrals and payouts in Airtable. &nbsp;

judithvirag · Answer

Great question. I am curious as well. :)&nbsp;

josegrados · Answer

Hey Matthew!&nbsp;That is a great way to generate more reviews.&nbsp; How many total employees do you have?&nbsp;I have a fence/ deck company as well, but It's only me and my crew at the moment, so sounds like I'm much smaller. Do you think hiring sales reps has been a good way to generate leads/ jobs?Right now I am basically only doing google ads for marketing. And only with that, I don't think I am able to bring an employee to help me with operations.&nbsp;Any advice is greatly appreciated!&nbsp;Thank you.&nbsp;

seanroz · Answer

We are in the same boat, with 2-3 sales reps it can be challenging to account for everything in a excel spreadsheet.

Forum Discussion

Is everyone calculating commission in a spreadsheet?

7 Replies