Changes to Posted Commissions
At the following points, the system will determine if a commission line has been added to the table for the commission agent/invoice. If so, it will determine if an adjustment line needs to be added for the commission.
The rate type/rate for a commission agent is changed
In this case, the commission liability will be recalculated based on the new rate, and a line will be added with a commission liability that brings the total of the original and the new commissions to the current liability requirement.
|
|
Base
|
|
Rate
|
Comm Liability
|
Record in Comm Table
|
Amount in Comm Table
|
|
|
|
|
|
|
|
|
|
Sample 1
|
1000
|
Original
|
10%
|
100
|
1
|
100
|
|
|
1000
|
New
|
20%
|
200
|
2
|
100
|
|
|
|
|
|
|
|
|
|
Sample 2
|
1000
|
Original
|
20%
|
200
|
1
|
200
|
|
|
1000
|
New
|
10%
|
100
|
2
|
-100
|
|
|
|
|
|
|
|
|
|
Sample 3
|
1000
|
Original
|
20%
|
200
|
1
|
200
|
|
|
2
|
New
|
$20
|
40
|
2
|
-160
|
In sample 3, the rate type was change from percent to flat rate. In this case, the base is 2 (2 rent lines, the actual amount of rent lines is not relevant), and the commission liability is 40 (2 x 20). An adjusting entry of -160 brings the liability to 40.
A credit is applied to an invoice, and the rate type is percentage
In this case, the commission base is lower, which results in a lower commission liability.
|
|
Base
|
Rate
|
Comm Liability
|
Record in Comm Table
|
Amount in Comm Table
|
|
|
|
|
|
|
|
|
Original
|
1000
|
10%
|
100
|
1
|
100
|
|
Credit 100
|
900
|
10%
|
90
|
2
|
-10
|
The current liability is 90 (100 – 10).
Note that credit adjustments are not made for flat rates.
A payment is deleted, and the invoice is no longer paid in full
At this point, the commission liability is automatically 0.
|
|
Base
|
Rate
|
Comm Liability
|
Record in Comm Table
|
Amount in Comm Table
|
|
|
|
|
|
|
|
|
Original
|
1000
|
10%
|
100
|
1
|
100
|
|
Delete Payment
|
0
|
10%
|
0
|
2
|
-100
|
(100 – 100 = 0)
The invoice is voided
This is handled in exactly the same way as deleting a payment. Once the invoice is voided, the base becomes 0, and the adjusting line is entered.
|
|
Base
|
Rate
|
Comm Liability
|
Record in Comm Table
|
Amount in Comm Table
|
|
|
|
|
|
|
|
|
Original
|
1000
|
10%
|
100
|
1
|
100
|
|
Invoice Voided
|
0
|
10%
|
0
|
2
|
-100
|
Payable Deletion
If a Commission Agent payable posting is deleted, the liability will reappear in the Batch Post Commission Agent Liabilities screen for reposting.
If a payable is reversed, the liability will not reappear in the Batch Post Commission Agent Liabilities screen for reposting.