The retail return that arrived next week

Week one closes with the information available

On 18 September 2026, fictional sale R410 records a treatment pack for $66.00 gross with $6.00 supplied tax. The calculation basis is $60.00. Mia’s supplied retail rate is 10%, producing $6.00 commission. The first period covers 14–20 September and is finalised with that sale included.

At that point there is no return record. The snapshot should describe the source rows, policy, rate and decisions used at the time. Later events can change a subsequent adjustment without making the original calculation mathematically false. A completed record is most useful when it remains an account of what actually closed.

Week two contains a new negative event

On 23 September, R411 records a partial return of $33.00 gross and −$3.00 supplied tax, so its signed gross value is −$33.00 and signed tax −$3.00. The excluding-tax basis is −$30.00. At the same supplied 10% rate, the calculation is −$3.00. Its source reference points back to R410.

This case assumes the responsible reviewer has confirmed that the later adjustment belongs in the commission workflow. The calculation does not itself decide entitlement, deduction or recovery treatment. If that decision is unresolved, the negative row should remain in review rather than being accepted merely because the amount looks proportional.

The two periods reconcile across time

Week one keeps its $60.00 basis and $6.00 commission. Week two adds a −$30.00 basis and −$3.00 commission. Across both records, the retained basis is $30.00 and the net commission calculation $3.00. The combined result corresponds to the half of the original purchase that remains unreturned.

The reference is more valuable than “refund approved”

A useful note reads: “R411 returns half of retail sale R410 dated 18 September. Supplied basis −$30.00 at the recorded 10% retail rate gives −$3.00. Include in 21–27 September under the confirmed case treatment; retain the original closed record.” It states the event, evidence, formula and period.

A note that says only “refund approved” leaves a later reviewer to reconstruct all four. They may find the amount but still be unable to tell whether this was the first return, a second adjustment, a full reversal or a correction of a mistaken source row.

Three ways to count the return twice

One mistake is to reduce R410’s completed commission to $3.00 and also include R411 at −$3.00. The two records would then total zero, even though half the original sale remains. Another is to re-import the original sale alongside the return without checking prior finalisation. A third is to reverse the full $6.00 for a half return.

Keep the original amount, returned amount and remaining amount visible together. In this case $66.00 less $33.00 leaves $33.00 gross. That simple bridge exposes both over-reversal and double reversal before a staff statement is produced.

A later rate change creates another question

This example deliberately uses the same 10% retail rate in both periods. If the rate changes before the return arrives, legacy mode uses the current flat rule; dated mode selects the agreement covering the return row’s own date. Neither mode automatically substitutes the rate on the original sale. A selected 12% rate on the −$30.00 basis would produce −$3.60, not −$3.00.

Do not change an agreement or the entire period’s rate just to force one refund to match an earlier record. First establish the required treatment and separate the affected calculation with clear evidence. The earlier snapshot provides the original rate, but the software does not infer a refund policy from it.

Reproduce both sides, not just the negative number

The download contains the sale and return with dates, signed values, original-sale reference and fictional period labels. You can filter the rows into their respective periods and calculate them independently. We checked the two basis/rate fixtures against the current engine: $60.00 at 10% gives $6.00 and −$30.00 gives −$3.00.

The refund tool provides the arithmetic comparison before you use a workspace. The recurring workflow adds the source record and the decision that connects it to a prior close. The completed history should let someone follow R411 back to R410 without requiring Friday’s statement to be rewritten.