Sample data: FactSmith Retail warehouse, Furniture profile. Not a real retailer.
This is the guided version of the story, one step at a time. The full write-up is the article; to explore the same data yourself, open Furniture Live.
FY2026 = 1 March 2025 to 28 February 2026. All amounts include VAT. The bridge adds up to the gap to the nearest rand.
Each step keeps only the part of the R3.42M that is still unexplained. Click a step to see what is behind it.
Every account-customer invoice still unpaid on 30 September 2026, from any year (FY2025 to FY2027), by days since the invoice date. Credit notes are netted off.
FY2026, all customers. Discount is a share of the price before discount; margin is gross profit over sales excluding VAT. The margin scale starts at 30%. Unpaid is the account-customer money by channel.
Over two years the two lines travel together. A gap this small hides in plain sight, which is how R3.6M goes missing.