Sage 50 Sales Commission Report with Excel Rules


Create variable rules for your Sage 50 salesperson commissions report using a spreadsheet. Set your own percentages rules by product, customer, and employee combinations.


Establish your own rules for Sage 50 Sales Commission Report using a spreadsheet.  The report shows invoice details including the paid amount.

Report parameters include:

  • User-defined date range
  • User-defined Employee Range

You can define sales commissions by:

  • Employee
  • Employee and Customer
  • Employee, Customer, and Inventory Items
  • Employee and Inventory Items
The report comes packaged with 2 additional items. A starting spreadsheet and a Spreadsheet Validator Report. The Spreadsheet Validator Report will compare all your commission entries to your company data. Items that don’t exist within your Sage 50 Company will be highlighted for corrections. Spreadsheet Validator Report also has interactive sorting.

This Sage 50 Sales Commission Report works with a Spreadsheet (either DSStudio SpreadSheet, Microsoft Excel, or Open Office) to create commission rules.  Here is an example:

Sage 50 Sales Commission Report With Excel Rule Sheet

The following commission’s rules would apply to the report.
  • Employee BNUNNLEY receives 10% for all sales Customer ARCHER
  • Employee BNUNNLEY receives 2%  for Customer MOSLEY on Inventory Item EQWT-15160
  • Employee BNUNNLEY receives 0% on Inventory Item NURS-22000
  • Employee CSWINTON receives 15% on all sales Customer DASH
  • Employee CSWINTON receives 5% for Customer TEESDALE on Inventory Item AVRY-10100
  • Employee CSWINTON receives 2% for all Customers, all Inventory Items (unless another rule applies)

These rules have been applied to the sample product screenshots.


Additional information

Customize Service

Custom changes to the report.

Output Formats

CSV – Comma Separated Value, HTML, Image, PDF, Report, Spreadsheet, Word Document / Richtext


DSStudio Viewer Version 2.0 or greater

Works with

Peachtree, Sage 50

Sage 50 and Peachtree Accounting Data Services

Data Recovery

Sage 50 US and Peachtree Accounting Data File Repair Service.

 Fiscal Period Change

Change the fiscal period time for a Sage 50 or Peachtree Accounting Company.

Data Transition

Many data-related services, which include: Sage 50 Product Downgrade, Quote Removal Service, Failed Fiscal Year Close Fix, and bulk change inventory item costing.

Purge Service

Data Purging Service for Sage 50 and Peachtree Accounting.  Reducing file size and increasing program execution speed.

Sage 50 Shell Company

Rebuild your Sage 50 / Peachtree Company in half the time.

Sage 50 Quote Stripping

Unable to import transactions into a new company.  The quote " maybe getting in your way.

Get In Touch

In a world full of options, we wanted to take a moment and say thanks for choosing us.

Our Knowledgebase is available for your technical support questions. 

All Sage 50 and Peachtree Accounting support is provided for a fee.

Contact Us

Contact Form

Contact Info

Fort Lauderdale, Florida, USA
Minneapolis, Minnesota, USA

954 - 523 - 8570

s u p p o r t @ d s c o r p . c o m