Record 01
Coastal components group
South West England · manufacturing and stores · three UK entities
The group closed three entities on Sage 50, with stock movements coming from a bespoke system that pre-dated the finance team now running it. Four GBP current accounts were reconciled in workbooks that only two people could update. The published management pack regularly waited until the twelfth working day, and the wait was mostly explanation, not bookkeeping.
Discovery found that supplier payments were exported from the bank twice in some months, once from the portal CSV and once from a saved copy with a slightly different filename. Nothing in the workbook treated those as the same payment. In the first parallel month the idempotency rule flagged 37 candidate duplicates. Eleven were true duplicates that had been posted, or were about to be. The rest were legitimate split remittances that shared a fragment of a reference, which is why the key included amount and value date rather than reference alone.
The stock system remained the operational record. A nightly read-only extract produced a movement journal only when the control total matched the stock valuation change within a stated tolerance. When it did not, the batch held. The team stopped "plugging stock" on the morning of the pack.
By the third live close, the management pack left on the sixth working day. The two-person workbook was retired after that close, not before. The group still uses Sage 50. Achyliaxyra did not replace it.
- Entities
- 3 UK companies
- Close
- 12 working days to 6
- True duplicate payments caught in parallel
- 11 of 37 candidates