Commission tax basis: make the amount behind the percentage explicit

Separate the sale amount, tax component and commission rate

These are three different inputs. In the fictional example below, the item amount is $220.00, the supplied tax component is $20.00 and the commission rate is 40%. The exclusive calculation basis is therefore $200.00. No choice of commission rate changes the source sale amount.

This guide demonstrates arithmetic with supplied values. It does not determine whether a business must charge tax, which supplies have tax, or which commission basis an employment or commercial arrangement permits. Resolve those questions through the appropriate records and advice before choosing the calculation inputs.

Compare two explicit assumptions

Both numbers follow their stated formula. The $8.00 difference cannot tell you which assumption applies to a particular arrangement. It tells you what to investigate when a provider-reported amount is $88.00 and your worksheet shows $80.00.

Record the selected basis beside the rate rather than burying it in a spreadsheet formula. That makes a later review possible without asking the original preparer to remember why one column was used.

If tax is missing, label the assumption

With an explicitly assumed 10% rate, an inclusive amount of $220.00 corresponds to $220.00 ÷ 1.10 = $200.00 before the assumed tax. Subtracting 10% of $220.00 gives $198.00, which is not the same calculation. At a 40% commission rate, that shortcut understates the example by $0.80.

An assumed rate is not a replacement for reliable source detail. A file with mixed tax treatment, an exemption or a correction can contain lines for which a single assumption is inappropriate. Obtain explicit row-level amounts where possible and make missing values visible rather than presenting inferred values as source facts.

Keep refund signs consistent

For a full reversal of this fictional sale, the signed item amount is −$220.00 and the signed supplied tax is −$20.00. The exclusive basis is −$220.00 − (−$20.00) = −$200.00. At 40%, the arithmetic commission adjustment is −$80.00.

A positive tax amount on a negative refund line would give a different and misleading basis. Inspect sign conventions before import. The arithmetic result still requires a separate decision about how the refund should enter the commission process; a calculator does not authorise a deduction or decide entitlement.

Do not confuse a blank tax value with zero

A blank value means no amount was supplied. A numeric zero says the source supplied zero. Those values must remain distinguishable because an exclusive calculation may use an assumed rate only when the amount is missing.

In Trimsum, an explicit tax amount is subtracted when an exclusive basis is selected. When it is absent, the configured assumed tax rate is used to derive the basis. An inclusive basis uses the signed item amount directly. Check the import preview so a blank column has not accidentally become a column of zeros.

Keep a short basis record with the close

1. Record whether the commission calculation uses an inclusive or exclusive basis.
2. Identify the source amount and tax columns, preserving blank and zero values.
3. Label any assumed rate and identify the rows that depend on it.
4. Check one positive line and one negative line by hand.
5. Explain any source-commission variance before closing the period.