Adnia Solutions.

Experience the impact of professional Excel templates

Sales KPI and Commission Tracker Template


The Sales KPI and Commission Tracker is an advanced Excel spreadsheet template developed to help business owners and managers track the most important sales numbers and set sales goals. With this template, you can easily visualize sales data to understand trends and sales performance.

This versatile Excel template was developed using Microsoft Power BI technology (Power Query & Power Pivot), and is complete with macros to automatically update your reports. Sales KPI and Commission Tracker contains 4 dashboards and 11 ready-to-use reports with slicer options. You can also create custom reports using Pivot Table.

Key Features

  • Interactive and dynamic dashboard that summarizes sales performance indicators on a single page
  • Sales and Commissions reports that are friendly, flexible and aesthetic
  • View Sales results by customer, product, sales manager and salesperson
  • Automates tasks to reduce errors, save time and increase efficiency
  • Clearly visualize results with easy-to-interpret charts and tables
  • Follow your team’s performance

Simple and Professional

  • Microsoft Excel spreadsheet template
  • Side menu for easy navigation between pages
  • Spreadsheets ready for printing without Adnia logo
  • No monthly fees
  • Immediate download
  • Secure payment with PayPal (no PayPal account needed)
  • Fully unlocked template

What is included?
Two spreadsheets are available for download; one with sample data and another ready to receive your data.

Other Information

  • Built for Excel 2016 or later
  • Windows only


This template is so easy to use. Start by registering your sales team, products and customers. Then, enter your sales data in the appropriate worksheet, set your sales goals and click the “Update Reports” button. All your sales indicators and reports will be updated automatically.

Take a tour:

Available Sales Dashboard:

  • Sales Dashboard
  • Sales KPI Dashboard
  • Commission Dashboard
  • Top Salesperson

Available Sales Reports:

  • Sales KPI Report 1
  • Sales KPI Report 2
  • Sales Report
  • Sales Target vs Actual Report
  • Commission Payable Report
  • Sales by Sales Manager
  • Sales by Salespersons
  • Sales by Customers
  • Sales by Products
  • Sales by Categories and Subcategories
  • Sales by Location
  • 3 additional reports that you can customize for your specific needs

Some of the indicators that you can use in the customizable reports:

Sales Target
Total Sales of Goal%
Sales Amount
Sales Last Year
Sales Variation $
Sales Variation %
Current Month Sales
Previous Month Sales
Month Sales Variation $
Month Sales Variation %
Total Orders
Last Year Sales
Order Variation (qty)
Order Variation %
Total Commission Payable
Last Year Commission Payable
Commission Payable Variation $
Commission Payable %

And many more!

Other Information

  • Built for Excel 2016 or later
  • Windows Only
  • Licensed for Private Use Only (not for distribution or resale)

The template may NOT be sold, distributed, published to an online gallery, hosted on a website, or placed on any server in a way that makes it available to the general public.



There are no reviews yet.

Be the first to review “Sales KPI and Commission Tracker Template”

Your email address will not be published. Required fields are marked *

Back to Top