Finish the week with a number you can explain
Take a weekly salon commission run from itemised sales to reviewed exceptions and a saved statement, with a complete three-line worked example.
A weekly close brings several decisions into one place: which sales belong to the period, who earned them, what calculation applies and which differences need an explanation. Trimsum keeps that work beside the source lines. The result is a completed commission record you can inspect again after the next week has started.
The useful part
Choose the period, check the inputs, answer the open questions and then finalise. A plausible draft total is still provisional while a decision remains open.
Give the week a clear boundary
Select the start and end dates before assessing the statement. The workspace includes imported rows whose mapped invoice dates fall within those inclusive dates; the planner shows how many remain outside. An overlap with a displayed closed run requires acknowledgment before applying the dates, while repeated source lines still receive their own checks. Match the source report’s date field and coverage. Importing resets coverage to the combined draft’s earliest and latest dates, so recheck the period after adding a file. Give the run a name that identifies the business and dates.
Bring the detail, then set the calculation
Import itemised AUD sales after discounts, with signed refunds and the earning staff member. Match the columns, check the preview and set separate service and retail percentages in Agreements. An upgraded workspace can date those agreements and link each sale to a stable staff record; older workspaces keep their flat rules until explicitly upgraded. Choose whether the supplied commission basis includes tax. An explicit tax amount takes precedence when tax is excluded; a missing amount uses the configured inclusive tax rate. These settings describe your calculation, so obtain the relevant instructions before entering them.
Follow one complete fictional close
For 21–27 September, Mia has one service, one retail item and a partial service refund. The example assumes supplied tax is excluded, service commission is 40% and retail commission is 10%. The source reports $83.00 total commission because its refund line reports zero. The reviewed calculation is $43.00. The $40.00 difference belongs to that refund; it is not an unexplained adjustment to the whole team.
| Item | Signed sales | Supplied tax | Basis | Commission |
|---|---|---|---|---|
| Service | 220.00 | 20.00 | 200.00 | 80.00 |
| Retail | 33.00 | 3.00 | 30.00 | 3.00 |
| Refund | −110.00 | −10.00 | −100.00 | −40.00 |
| Completed total | 143.00 | 13.00 | 130.00 | 43.00 |
Answer what the total cannot tell you
Open each review case and inspect the original source values. A refund needs a supported treatment; a matching line needs evidence that it is either repeated or a separate sale. Missing rates, unlinked staff or a gap in dated agreements hold affected amounts out of the total. An unresolved category also holds its line. Some other questions, including a refund awaiting review, can already affect the draft arithmetic. The remaining-decision count therefore matters as much as the displayed amount. Finalisation stays unavailable until every question is resolved.
Check the statement before closing
Finalising preserves the selected period and removes its rows from the draft. It does not submit payroll or move money. Process the checked output through your existing payment workflow.
- Open View team statement and trace any staff total that needs another look.
- Compare the included lines, period and recorded decisions with the source.
- Choose Finalise & export, enter a Run name and confirm the review checkbox.
- Open the completed record in Archive and download its summary or detailed audit CSV.
Start again without rewriting last week
Use Next weekly period for seven days after the current saved end date, or Next fortnightly period for fourteen. Next calendar month chooses the full following month, so inspect gaps when the current period ends mid-month. Reuse checked column mappings and inspect the Imports register to see which file rows remain in the draft or appear in completed runs. Staff settings carry forward while each closed run retains the rates and, in dated mode, the selected agreements used at close. Keep source reports and backups; this recurring workflow does not automatically fetch exports or process payroll.
Put it to work.
Work through the source, the decision and the finished statement before creating your own workspace.
Try a complete sample run