How to Create a Sales Commission-Tracking Google Sheets Template
By The Editorial team
I’ve been managing my own sales commission structure in Google Sheets and have recently developed my first commission-tracking Google Sheets template that you can use to do the same thing with your business.
What is Google Sheets?
Google Sheets is an app for creating and editing spreadsheets. It’s relatively similar to Microsoft Excel, but it was made by Google, so it’s free! You can use it on any device with an internet connection, including laptops, phones and tablets. If you’re using a laptop or desktop, your data will be saved online and immediately synced across your devices.You can access the Google Sheets here.
Whether you are an online marketer selling your own services, or you are an affiliate marketer promoting other people’s products and earning commissions based on the number of sales they make, this commission tracking template can help you easily monitor and analyze your sales numbers to help maximize your earnings!
A commission-tracking Google Sheets template can be an invaluable tool in your quest to make the most money possible as an entrepreneur and see how your commissions-on-sale are coming. This article explains how to set up your own commission-tracking Google Sheets template, complete with tips and tricks that will help you make the most of this valuable resource.
The Benefits of Tracking Commissions in Google Sheets
Traditionally, salespeople are tasked with keeping track of their sales results and commissions earned in an Excel spreadsheet. This can prove difficult if you’re dealing with multiple clients and numerous commission plans. Commissions are sometimes deducted from your paycheck before you even receive them and it’s hard to keep up with sales goals when you have no way of knowing where you stand at any given time.
Tracking your commissions in Google Sheets is both faster and easier than keeping track on paper.
Because Google Sheets is cloud-based, you will always have access to your sales data every time you need to.
Also, it’s easy to add new clients and update commission plans as your business grows.
In addition, you can share your sales data with anyone who needs it in real time. This is especially helpful if you’re working with an accountant or payroll department.
Finally, because Google Sheets is free and simple to use, there’s no reason not to give it a try!
Who the commission-tracking Google Sheets template is for
This template can be used by marketers, affiliate marketers, sales development representatives (SDRs), and anyone else who works in an environment where they draw against commission. It’s especially useful for people who are paid on commission and have multiple sources of income.
This can be a great way to keep close tabs on your sales and commission and also see how and where to make improvements . In other words, it’s a good idea for anyone who has been in business for themselves or is about to start their own business.
Setting up your spreadsheet
You will need a Gmail account to setup a Google Sheets template. You can sign up here or sign in if you already have an account.
Next click on the products tab and select Sheets from the top right area of your account(next to your profile picture)
Open up a blank document in Google Sheets, click File in top left corner, or click the bottom-left plus sign on the Google Sheets homepage to start your new spreadsheet.
In order for commission tracking to work correctly, we need to insert names on multiple rows and columns on our sheet depending on the sales parameters that are relevant.
A simple Google sheets commission template should have a column for the brand(s)/company(ies) you sell for, a target column, sales column and a commissions column.
Remember that you need to segment these within a period – months work just fine (see sample template below).
Filling your templates with data and formula
The first step is planning how you want your template to look once it’s filled in with data. You want it to be easy to read and understand (especially if more people will have access to your template) and easy for you when you are populating it. You also don’t want it too difficult to construct. Keep in mind when planning where people will input data and what types of cells they will have access to modify—this should help determine which other cells they need access too, whether they can enter data into those rows or columns, etc.
Simply fill in required data into the “brand/company” cell. Fill as many companies as you work for.
Next, fill in your targets or goals. This can be personal or based on targets set by the company you work for.
On the sales column, fill in how much you sold so far for the period covered. Do the same for the commissions rate (COMM RATE); this depends on what your company or brand has offered to pay per product sold.
To get the commission paid (COMM) simply use formula =10/100*G5. This will divide the amount of sales and multiply it by the percentage of sales commission offered. Once you get your commission in Dollars, you can drag the hold of your cell down till the end of the column to get results automatically for the cells below.
Remember to sum all your sales to get a total of what you are making. To do this, use the =SUM(B5:B12). This adds the figures from the first cell down through to the last cell on the column.
If you’d like to share your template with your team or manager, simply use the Google Sheets share button from the Files Menu or download a copy and send via mail.
Now that you are all set, you will be able to keep track of your sales and adjust accordingly. Feel free to tweak this template as you like.