Commission variance checker
Compare source-reported commission with a flat-rate calculation for each entered basis.
Variance, compared rows
-$40.00- Calculated, compared rows
- $43.00
- Reported, compared rows
- $83.00
- Compared rows
- 3
- Incomplete rows
- 0
Illustrative calculation · AUD where amounts are shown.
| Source row | Basis AUD | Rate % | Calculated AUD | Reported AUD | Variance AUD | Finding |
|---|---|---|---|---|---|---|
| 2 | $200.00 | 40% | $80.00 | $80.00 | $0.00 | Matches |
| 3 | $30.00 | 10% | $3.00 | $3.00 | $0.00 | Matches |
| 4 | -$100.00 | 40% | -$40.00 | $0.00 | -$40.00 | Review assumptions |
A difference is a question.
Start with the line.
The calculator shows arithmetic under the basis and rate you entered. It cannot identify the reason a booking report differs. Keep the source row visible, then test the assumptions one at a time.
- Rows with a difference
- 1
- Sum of absolute differences
- $40.00
- Rows needing input review
- 0
Opposite differences can cancel in the net total (-$40.00 here). The absolute amount keeps those lines visible. It is a review quantity, not money proved to be owed.
Open a source row
The five largest differences are shown here. The result table and download retain every row.
- Entered basis
- -$100.00
- Entered rate
- 40%
- Calculated
- -$40.00
- Source reported
- $0.00
Calculated minus reported. This does not establish which side is correct; compare the source evidence and agreed rule.
Four checks to narrow the cause.
Select a question to see the evidence to bring into a review. None of these checks changes or approves a source row.
Basis and tax
Put the source sale amount, supplied tax and discount beside the basis in this check. Confirm whether the agreement uses the inclusive amount or an amount after tax. A booking report may already be net of a discount; subtracting it again would create another difference.
Bring into the review
- Source invoice and item amount
- Supplied tax or discount columns
- The agreed calculation basis
See how the number is made.
Supply the exact commission basis in the CSV; the tool does not infer tax from gross sales. A rate in a row overrides the default. Blank reported amounts remain missing, never zero. A difference signals an assumption to investigate, not proof that the source report is wrong.
The working
Variance = calculated commission − reported commission. Total variance uses only rows with both amounts.
A −$100.00 basis at 40% calculates −$40.00. If the source reports $0.00, the variance is −$40.00.
- AUD. Monetary results use nearest-cent rounding; exact half cents round away from zero.
- Totals include only rows with a valid basis, rate and reported amount. Missing values are not replaced with zero. A variance is calculated minus reported.
- The entered basis is used directly. Tax has not been inferred or removed.
Use the calculation basis and rules you have agreed. A tool result is a working record; it does not establish an entitlement or send a payment.