Logicim's Ready-to-Use Sage 50 CA Commissions by Percentage

Commissions by Percentage

Introduction

The Commissions by Percentage Report calculates sales commissions for a selected date range using a commission percentage entered in the workbook.

Prerequisites

- Microsoft Windows 10 Pro, Windows 11 Pro, or Windows terminal server (2012 and above)

- Microsoft Office 365

- Sage 50 Canadian edition (2014 and above)

- Internet connection

What the Report Does

The Report worksheet shows a Sales Commission Report for the period selected on Instructions. It lists Date, Customer Name, Customer Contact, Phone, Salesperson, Source, Last Invoice Date, Invoice Amount, Paid Amount, and Commission, with a Grand Total row. The Chart worksheet shows Commission Earned by Sales Representative and Monthly Sales. The CA Ready-to-Use catalog places this Report under Customer and Sales / Others and describes it as a Report that calculates commissions based on a specified percentage of invoice or payment amounts.

How to Use the Report

1. Enter the Start Date in cell C8 and the End Date in cell C9 on the Instructions worksheet.

Report screenshot 1

Date range and commission percentage inputs on the Instructions worksheet.

2. Enter the commission percentage in cell C10 on the Instructions worksheet, then click Refresh on the XLGL menu.

3. Click the button labeled Go to Report... or open the Report worksheet to review the Sales Commission Report output.

Report screenshot 2

Sales Commission Report output with customer, invoice, payment, and commission columns.

4. Click the button labeled Go to Chart... or open the Chart worksheet to review the commission and monthly sales charts.

Report screenshot 3

Chart worksheet showing Commission Earned by Sales Representative and Monthly Sales.

Customization Options

You can adjust the date range in cells C8:C9 and the commission percentage in cell C10 on the Instructions worksheet before refreshing the Report. For structural changes, use the workbook's customization link or request customization instead of changing hidden worksheets or formulas.

Common Use Cases

- Review sales commissions for transactions within a selected period.

- Compare invoice amounts, paid amounts, and calculated commissions in one Report output.

- Review commission distribution by salesperson using the Chart worksheet.

- Compare monthly sales activity using the Monthly Sales chart.

Troubleshooting

Issue: The period shown on the Report or Chart worksheet is not the expected period.
Solution: Check the Start Date in cell C8 and the End Date in cell C9 on Instructions, then click Refresh on the XLGL menu.

Issue: The commission amounts do not match the expected percentage.
Solution: Check the commission percentage in cell C10 on Instructions, refresh the Report, and compare the Invoice Amount and Commission columns.

Issue: You are viewing the input page instead of the output.
Solution: Use Go to Report... for the Report worksheet or Go to Chart... for the Chart worksheet.

FAQs

Q: Which inputs control this Report?
A: Instructions!C8 controls the Start Date, Instructions!C9 controls the End Date, and Instructions!C10 controls the commission percentage.

Q: What output columns are visible on the Report worksheet?
A: The visible columns include Date, Customer Name, Customer Contact, Phone, Salesperson, Source, Last Invoice Date, Invoice Amount, Paid Amount, and Commission.

Q: What does the Chart worksheet show?
A: It shows Commission Earned by Sales Representative and Monthly Sales.

Q: Does the workbook use hidden support worksheets?
A: Yes. The workbook contains hidden Data and ChartData worksheets that support the visible Report and Chart outputs.

Best Practices

- Confirm the date range and commission percentage before refreshing the Report.

- Review the Grand Total row on the Report worksheet after refreshing.

- Use the Report worksheet for detailed transaction review and the Chart worksheet for visual commission and sales analysis.

- Keep formula and hidden-worksheet changes for approved customization work.


References

Ready-to-Use Reports for Sage 50 Canada

Request a Custom Report

Related articles
Logicim's ready-to-use Sage 50 CA comparative automated income statement
Logicim's ready-to-use Sage 50 CA automated project income statement
Logicim's ready-to-use Sage 50 CA Transaction Report
Logicim's ready-to-use Sage 50 CA 2-column income statement by projects
Logicim's ready-to-use Sage 50 CA automated trial balance
Logicim's ready-to-use Sage 50 CA mapped balance sheet
Logicim's ready-to-use Sage 50 CA pivot table vendor invoice log
Logicim's ready-to-use Sage 50 CA departmental income statement
Logicim's ready-to-use Sage 50 CA detailed cash flow
Logicim's ready-to-use Sage 50 CA invoice with taxes
Logicim's ready-to-use Sage 50 CA automated detailed cash flow
Logicim's ready-to-use Sage 50 CA automated trial balance by department
Logicim's ready-to-use Sage 50 CA vendor standard invoice
Logicim's Ready-to-Use Sage 50 CA pivot table trial balance with chart
Logicim's ready-to-use Sage 50 CA ratios
Logicim's ready-to-use Sage 50 CA income statement by projects
Logicim's ready-to-use Sage 50 CA vendor list by department
Logicim's ready-to-use Sage 50 CA customer standard invoice
Logicim’s ready-to-use Sage 50 CA customer list
Logicim’s ready-to-use Sage 50 CA customer aging
Logicim’s ready-to-use Sage 50 CA vendor list
Logicim’s ready-to-use Sage 50 CA vendor aging
Logicim's ready-to-use Sage 50 CA Balance Sheet.
Logicim’s ready-to-use Sage 50 CA Reports transactions list
Logicim’s ready-to-use Sage 50 CA summary cash flow
Logicim’s ready-to-use Sage 50 CA formatted customer aging
Logicim’s ready-to-use Sage 50 CA inventory analysis
Logicim’s ready-to-use Sage 50 CA formatted vendor aging
Logicim’s ready-to-use Sage 50 CA financial statements side-by-side
Logicim’s ready-to-use Sage 50 CA dashboard
Logicim’s ready-to-use Sage 50 CA transactions Report
Logicim’s ready-to-use Sage 50 CA project budget by period
Logicim’s ready-to-use Sage 50 CA physical count worksheet
Logicim’s ready-to-use Sage 50 CA ratios
Logicim's ready-to-use Sage 50 CA Inventory Aging
Logicim's ready-to-use Sage 50 CA Job Retainage
Logicim's ready-to-use Sage 50 CA Unbilled Job Expense
Logicim's Ready-to-Use Sage 50 CA Customer Profitability Summary
Logicim's ready-to-use Sage 50 CA Customer Aging- Detailed and Summary
Logicim's Ready-to-Use Sage 50 CA Customer Invoice Log - Cust
Logicim's Ready-to-Use Sage 50 CA Customer Invoice Log - with Commission
Logicim's Ready-to-Use Sage 50 CA Customer Invoice Log
Logicim's Ready-to-Use Sage 50 CA Customer Analysis
Logicim's Ready-to-Use Sage 50 CA Gain or Loss
Logicim's Ready-to-Use Sage 50 CA Inventory Analysis - DB
Logicim's Ready-to-Use Sage 50 CA Product Analysis
Logicim's ready-to-use Sage 50 CA Purchase Analysis.
Logicim's ready-to-use Sage 50 CA Summary Cash Flow - DB.
Logicim's ready-to-use Sage 50 CA Tax.
Logicim's ready-to-use Sage 50 CA Unallocated.
Logicim's ready-to-use Sage 50 CA Sales Analysis - DB.
Logicim's ready-to-use Sage 50 CA Income Statement.
Logicim's ready-to-use Sage 50 CA Income Statement - Current Month - Actual vs Budget.
Logicim's ready-to-use Sage 50 CA Mapped Income Statement Example.
Logicim's ready-to-use Sage 50 CA Pivot Table Comparative Income Statement.
Logicim's ready-to-use Sage 50 CA Pivot Table Departmental Income Statement.
Logicim's ready-to-use Sage 50 CA Pivot Table Income Statement with Chart.
Logicim's ready-to-use Sage 50 CA Pivot Table Cash Flow.
Logicim's ready-to-use Sage 50 CA Pivot Table Comparative Trial Balance.
Logicim's ready-to-use Sage 50 CA Trial Balance.
Logicim's ready-to-use Sage 50 CA Trial Balance- 2 Departments Comparison.
Logicim's ready-to-use Sage 50 CA Trial Balance by Department.
Logicim's ready-to-use Sage 50 CA Standard Receipt.
Logicim's ready-to-use Sage 50 CA Single Stub Receipt.
Logicim's ready-to-use Sage 50 CA Standard Packing Slip.
Logicim's ready-to-use Sage 50 CA Service Bill.
Logicim's ready-to-use Sage 50 CA Retail Invoice.
Logicim's ready-to-use Sage 50 CA Retail Invoice with Statement.
Logicim's ready-to-use Sage 50 CA Standard Payment.
Logicim's ready-to-use Sage 50 CA Receipts by Payment Method.
Logicim's ready-to-use Sage 50 CA Sales by Salesperson and Item.
Logicim's ready-to-use Sage 50 CA Sales Item Summary.
Logicim's ready-to-use Sage 50 CA Balance Sheet - Unf.
Logicim's ready-to-use Sage 50 CA Comparative Monthly Balance Sheets - Unf.
Logicim's ready-to-use Sage 50 CA Departmental Balance Sheet - Unf.
Logicim's ready-to-use Sage 50 CA FIFO Costing.
Logicim's ready-to-use Sage 50 CA Inventory and Services List.
Logicim's ready-to-use Sage 50 CA Inventory and Services Summary.
Logicim's ready-to-use Sage 50 CA Inventory List - Inv.
Logicim's ready-to-use Sage 50 CA Inventory Summary.
Logicim's ready-to-use Sage 50 CA Items Sold by Customers.

Edited: Monday, August 31, 2026

Was this article helpful?

Thank you! Your feedback matters.

We'd love to hear your thoughts! Please provide a comment before submitting.

Thank you for your message!

Would you like a Logicim team member to reply to your message?

If so, please enter your email address below.

You will also receive a copy of your comment.

We protect your personal information.

Thank you for your message!

Verify your inbox or spam folder to find the copy of your comment.
Contact clientcare@logicimtech.com if you didn't receive it.

Contact support@logicimtech.com for technical support or reporting questions.
Book your FREE consultation now with a Logicim Sage 50 Reporting EXPERT.

Fullscreen Image