Click on the Menu - Business Reports in the menu. Click on the Revenue tab.

Scroll down to the report called Revenue Summary. This is the one you’ll need!

Choose the start date and end date for the period you want to check. The numbers will update automatically.

Click on Download to Excel. This will save the report as a spreadsheet on your computer.

Open the spreadsheet you just downloaded. You’ll see a list of your staff, how much they made from services, and how much they sold in retail.

Click and drag to highlight the whole table – names, service totals, and retail totals. Then right-click and choose Copy (Press the command key and C on a Mac to copy!).

Open your Commission Calculator spreadsheet. This is the one made for you with your business details.

Click on the second tab in that spreadsheet. That’s where the data goes.

Click at the top and right-click to Paste the data you copied earlier. (You can also press command and V on a Mac!).

The calculator will now work everything out for you – how much commission each staff member has earned from services and retail.