MACS Commission Reconciliation Module
Commission Reconciliation tracks unpaid commissions, reports variances
between expected and received commissions, and provides salesman
commission statements.
When an invoice is entered into MACS, either through Sales
and Commission Entry or Order Tracking,
MACS stores commission information in an open invoice file.
Commissions are then entered into the system from each manufacturer's
commission statement.
Aged Commissions Receivable Report
R178KB INO\7.11.16 Any Sales Oriented Agency Lee Jacob Mfg PAGE 4
11/15/06 OpnInv Aging: Mfg / Reference Mth 11/06
———————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
**** Reference **** Sales *** Commission ***
Customer Sm Number Date Amount Exp% Exp$ Current 30 Days 60 Days 90 Days
———————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
Abrasive Tool Co 3 60636 06/19/06 2480.00 5.00 124.00 124.00
Abrasive Tool Co 3 60839 07/24/06 3800.00 6.17 234.63 234.63
Babson Tooling 4 60913 07/24/06 5934.00 5.00 206.70 206.70
Abrasive Tool Co 3 61019 08/20/06 2560.00 5.00 128.00 128.00
Babson Tooling 4 61113 08/20/06 1794.00 5.10 91.45 91.45
Abbey Electronic Co 1 61125 09/20/06 4227.98 6.31 266.59 266.59
American Mfg Inc 3 61267 09/20/06 4087.00 7.50 306.54 306.54
Babson Tooling 4 61298 09/20/06 6780.00 5.00 339.00 339.00
-----------------------------------------------------------------------------------------------------------------------
Achin Welding Co 3 61749 10/25/06 3266.00 9.28 302.93 302.93
Adel's Dist / Cinc 2 61760 10/26/06 1000.00 6.00 60.00 60.00
* Manufacturer *LJM* 123670.93 6.83 8442.88 5939.78 1628.32 219.45 655.33
|
"How much commission is owed to my agency by a particular
manufacturer?"
Commission Exception Report
R186AH COE\8.10.13 Any Sales Oriented Agency Lee Jacob Mfg PAGE 3
12/05/06 EOMComExcep: Mfg Mth 11/06
———————————————————————————————————————————————————————————————————————————————————————————————————————————
*** Expected **** *** Actual **** Variance
Customer Name Invoice No Date Sales Comm% Comm$ Comm% Comm$ Comm$
———————————————————————————————————————————————————————————————————————————————————————————————————————————
Abbey Electronic Co. 61125 09/20/06 4227.98 6.31 266.79 6.39 270.00 3.21
Abrasive Tool Co 60839 07/24/06 3800.00 6.17 234.46 5.00 190.00 44.46-
Acme Sign Company 61556 10/02/06 1777.00 7.74 137.54 5.50 97.74 39.80-
Adel's Dist / Cinci 61678 10/21/06 3712.50 7.50 278.44 6.19 230.00 48.44-
American Instruments 61734 10/24/06 4390.00 7.50 329.25 5.00 219.50 109.75-
Adel's Dist / Cinci 61760 10/26/06 1000.00 6.00 60.00 5.00 50.00 10.00-
*Total Mfg *LJM* Lee Jacob Mfg 18907.48 1306.48 1057.24 249.24-
|
"How can I identify commission errors made by my
manufacturers?"
Salesman's Commission Statement
R186EA COE\8.10.15 Any Sales Oriented Agency PAGE 1
11/15/06 EOMComRecd Lst: Smn / Mfg / Cst Smn * 2* Jim Black Mth 11/06
———————————————————————————————————————————————————————————————————————————————————————————————————————————
Manufacturer Name
Customer Name City State Invoice No Date Post Sales Comm% Comm$ Spt Smn$
———————————————————————————————————————————————————————————————————————————————————————————————————————————
Lee Jacob Mfg
Abbott Health Prod Louisville KY 61549 10/02/06 1106 1382.33 7.50 103.67 45 46.65
Acme Sign Company Cincinnati OH 61556 10/02/06 1106 1777.00 5.50 97.74 45 43.98
Adel's Dist / Cinc Cincinnati, OH 61678 10/21/06 1106 3712.50 6.19 230.00 35 80.50
Adel's Dist / Cinc Cincinnati, OH 61717 10/24/06 1106 6758.40 6.05 408.97 35 143.14
Adel's Dist / Cinc Cincinnati, OH 61760 10/26/06 1106 1000.00 5.00 50.00 35 17.50
Aiken Sanding Ashland KY 61181 09/20/06 1106 1895.00 5.00 94.75 45 42.64
Aiken Sanding Ashland KY 61569 10/08/06 1106 1105.00 5.84 64.55 45 29.05
American Instrumen Louisville KY 61708 10/23/06 1106 675.00 7.50 50.63 45 22.78
American Instrumen Louisville KY 61574 10/08/06 1106 5926.00 7.99 473.50 45 213.08
American Instrumen Louisville KY 61734 10/24/06 1106 4390.00 5.00 219.50 45 98.78
Total Mfg *LJM* Lee Jacob Mfg 28621.23 1789.64 742.00
-----------------------------------------------------------------------------------------------------------
Simpso Part Supply
Adel's Dist / Cinc Cincinnati, OH 56098 10/19/06 1106 2165.00 10.35 224.00 45 100.80
Baker Tubing Louisville KY 56115 10/25/06 1106 2794.00 10.00 279.40 45 125.73
Total Mfg *SIM* Simpso Part Supply 4959.00 503.40 226.53
Total Smn * 2* Jim Black 78846.80 4280.64 1851.56
|
"How do I know how much commission to pay my salespeople?" |
