Rebuilding a handover from two unexplained totals
Turn an incomplete fictional Mia $123 / Noah $132 spreadsheet into a traceable handover with source, decisions, assumptions and a reconciled summary.
The first handover contains two names and two numbers: Mia, $123.00; Noah, $132.00. The arithmetic adds to $255.00, but the recipient cannot tell which week, source, rates or decisions produced it. We rebuilt that fictional handover using the ten-row investigation, keeping the pack small enough to inspect without a meeting.
Worked fictional example · amounts in AUD
The useful part
A handover is complete when its recipient can connect the staff totals to the period, source rows, supplied rules and exception decisions. A matching grand total is only one check.
Your working files
Download the handover manifestCSV · A fictional pack index with filenames, purposes and expected checks.Download the staff summaryCSV · Actual engine-derived category bases and commission totals for the fictional close.Download the supporting sourceCSV · The ten records used for the handover investigation.Download the supporting decisionsCSV · The four exception treatments supporting the final summary.What the original spreadsheet cannot answer
The initial two-row sheet omits the period dates, currency, calculation basis and whether the figures are drafts or completed results. It contains no source filename and no explanation of the refund or duplicated export row. Even if every number is correct, the recipient must ask the preparer to reconstruct the process.
Adding a colourful heading would not solve that problem. The missing information is operational: what the figures represent, what evidence supports them and whether someone has already reviewed the exceptions. The rebuilt handover starts with those questions and includes only the material needed to answer them.
The cover establishes scope and status
The cover identifies a fictional close for 21–27 September 2026, AUD, with a basis excluding supplied tax and line-level nearest-cent rounding. It records Mia’s 40% service/10% retail rates and Noah’s 45%/12% rates. The status is a completed commission calculation for the example, not a claim that anyone has been paid.
That last distinction prevents an ambiguous handover from becoming an accidental payment instruction. The recipient can see that the worksheet supports a further process. The pack does not calculate wages, submit payroll, establish entitlements or execute transfers. Its job is to explain the commission result and the evidence behind it.
Four files and one completed record
The manifest names the original ten-row source, the decision register, the staff summary and the article containing the case assumptions. It also identifies the completed workspace snapshot as the preserved record of the close. The files are offered individually; there is no pretend archive or hidden download step.
Each component has a different purpose. The source explains what arrived. The decision register explains what changed its contribution. The summary explains the staff totals. The assumptions explain the formula. The snapshot ties those parts to the actual completed run. Copying the same summary into several formats would add bulk without answering another question.
| Component | Evidence provided | Recipient check |
|---|---|---|
| Source file | 10 records including the duplicate and voucher | Raw gross $1,056.00 |
| Decision register | Refund, overlap, rate difference, voucher scope | Four review outcomes explained |
| Staff summary | Mia $123.00 / Noah $132.00 | Combined commission $255.00 |
| Case assumptions | Dates, tax basis, category rates | Reproduce every line |
| Completed snapshot | Rows, rules and totals at close | History agrees with the pack |
The recipient should be able to rebuild $255.00
The source gross total is $1,056.00. Excluding the $220.00 repeated colour sale and $110.00 voucher leaves $726.00. Supplied tax on included records totals $66.00, so the included basis is $660.00. That figure is not obtained by summing every displayed basis in a detailed export; excluded rows remain present for evidence.
Mia’s $350.00 positive service basis, $30.00 retail basis and −$50.00 refund basis produce $123.00 commission. Noah’s $280.00 service and $50.00 retail basis produce $132.00. The rebuilt summary contains those category totals so the recipient can check both the $660.00 basis and $255.00 commission independently.
The decision register removes the need to guess
The refund note identifies A100 as the original sale and explains the −$20.00 commission adjustment. The repeated A102 note names the retained copy. The A106 note explains why $36.00 is used instead of the source’s $32.00. The voucher note states that it is excluded under the fictional case scope.
These four explanations are more useful than a general statement that the spreadsheet was checked. They also reveal the boundaries of the preparer’s knowledge. The rate-difference note cites the supplied case rule; it does not claim to have audited the source provider’s full calculation settings.
Prepare a copy suited to its recipient
The fictional pack contains no customer identities or sensitive appointment notes. A real handover should include the evidence the authorised recipient needs, with unrelated personal details removed from a working copy where appropriate. Keep original records in the proper location and avoid turning a short handover into a distribution of every export column.
Use stable filenames and retain the period in the summary. If the record changes before completion, make the status and version clear. After finalisation, provide the completed outputs from that run. A later correction should be separately identifiable, so the recipient can tell whether they are seeing a replacement draft or a new adjustment.
A small acceptance test for the rebuilt pack
Open the manifest and follow each listed file. Confirm that both staff totals add to $255.00, that the source contains ten data records and that the decision register accounts for every exception. Then select one included row and one excluded row and trace each from source to treatment to final contribution.
The downloadable staff summary was generated from the actual engine result for this fictional fixture. The manifest names its companion files and expected checks. The rebuilt handover is successful when another person can explain the result without the preparer narrating it from memory. That is a stronger acceptance test than whether the spreadsheet looks finished.
Put it to work.
Inspect source rows, supplied rates and review decisions in the sample workspace.
Explore the sample close