In this article:

Commission Tracker in Google Sheets (Free Template in 2024)

May 8, 2024

Commission Tracking Google Sheets Template

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. 

commission tracker google sheets

Select File > Make a copy.

commission tracking google sheets

How to Use Commission Tracker in Google Sheets

Follow the steps below to create a commission tracker in Google Sheets. 

1. Start a New Google Sheets Document and Label Columns for Commission Data

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".

2. Input Sales and Commission Rates

Start entering your sales data under the respective columns. Fill in the "Date", "Sale Amount", and "Commission Rate" for each transaction.

3. Apply Formula to Calculate Commission Earned

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.

4. Format Sales and Commission Columns as Currency

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".

5. Summarize Total Sales and Commissions

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.

6. Highlight Key Commissions with Conditional Formatting

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.

7. Enable Sorting and Filtering with Data Filters

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.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->