Problem

Every month, the payroll department receives many adjustments from the sales operations department relating to salesperson commissions, as referred to in Problem 2. Salespeople and sales managers have been complaining to the executives of INTRAC that they do not trust the detailed sales commissions report. They believe that there may be several problems, and feel that

• detailed invoice amounts do not equal the total reported sales
• reported commissions owed do not equal total sales multiplied by a commission percentage
• the reported payroll amount, which is the amount to be paid this month, does not equal YTD commissions owed minus YTD commissions paid

Unlike the report that was prepared in Problem 2, the sales management needs a balancing report that shows salesperson names. They need this report to review it with their salespeople.