A Commission Tracking Google Sheets Template is vital for accurately calculating and managing sales commissions, fostering transparency and motivation among sales teams. Get a copy of our commission tracking Google Sheets template here.
Select File > Make a copy.
Follow the steps below to create a commission tracker in Google Sheets.
Start a new spreadsheet in Google Sheets and name it "Commission Tracker." Create column headings in the first row: "Date", "Sale Amount", "Commission Rate", and "Commission Earned".
Start entering your sales data under the respective columns. Fill in the "Date", "Sale Amount", and "Commission Rate" for each transaction.
To calculate the commission for each sale, input a formula in the "Commission Earned" column. Assuming "Sale Amount" is in column B and "Commission Rate" is in column C, use the formula "=B2*(C2/100)" for the first data row. Then, drag the fill handle down to apply this formula to the rest of the rows.
Highlight the "Sale Amount" and "Commission Earned" columns, then format these cells as currency by going to Format > Number > Custom Currency.
Select the applicable currency and click "Apply".
Add a section to summarize your total sales and commissions. Use the SUM function to add up the values in the "Sale Amount" and "Commission Earned" columns.
Apply conditional formatting to the "Commission Earned" column to highlight commissions over a certain value. Select the column, choose Format > Conditional formatting, and set your desired rule.
You can apply format rules to a specific range.
Enable sorting and filtering for your data by adding filters. Click the row with your column headings and select Data > Create a filter.
We hope that you now have a better understanding of how to create a commission tracker in Google Sheets and use our Commission Tracking Google Sheets template. If you enjoyed this article, you might also like our article on the profit margin formula in Google Sheets or our article on how to make a checklist in Google Sheets.
