20 Appendix B — Account Investigation Briefs
20.1 Appendix B · Quarantined Accounts Investigation and Priority 0 Queue
Two accounts require investigation before any revenue ranking in this report is used for valuation purposes.
Account 16446 appears at rank 3 among UK accounts by gross revenue. Its true net revenue is £2.90. Every order placed by this account was reversed. The most extreme single transaction: 80,995 units ordered and cancelled on the same day.
Account 12346 appears at rank 5 by gross revenue. Its true net revenue is £0.00. Same pattern — complete reversal of every order.
The question for the seller is what process or arrangement produced this pattern — a test account, a known dispute, or something else. The full transaction records are in the tables below.
This appendix also contains the wider Priority 0 queue: additional accounts flagged with similar transaction patterns that require pre-close investigation before any revenue figure incorporating them can be used in a bid model.
The Priority 0 queue contains accounts where transaction data has identified phantom revenue patterns, 100% cancellation rates, or unit-of-measure anomalies that materially affect valuation. Each item requires pre-close investigation and resolution before any revenue figure incorporating it can be used in a bid model. The two accounts with full transaction records (16446 and 12346) are documented in detail below. The remaining four accounts are flagged with the observable transaction pattern and the pre-close verification required.
This appendix contains the full transaction records for the two accounts identified in Revenue Concentration as requiring immediate investigation. Both accounts appear in the top 10 by gross revenue but generate near-zero net revenue due to 100% cancellation rates. Every commercial decision treating these accounts as top-tier relationships has been built on false information.
Investigation owner: CFO and Finance. Deadline: Findings reported within 14 days of close.
What the transaction data shows: Both accounts placed orders that were cancelled on the same calendar date the order invoices were raised. The same-day pattern means these were not post-delivery physical returns — goods cannot be shipped to a customer and returned on the same day an invoice is raised. The data establishes this one fact. It cannot establish whether the cancellation occurred before or after goods were processed for shipment, whether the quantities represent a genuine order or a data entry error, or why the cancellation occurred.
What makes these accounts unusual beyond the cancellation rate: The quantities are extraordinary. Account 16446 ordered 80,995 units of a single product in one transaction. Account 12346 ordered 74,215 units. For context, the annual demand for the affected products is measured in thousands of units — not tens of thousands. These quantities are anomalous regardless of when they were cancelled.
Three investigation questions that the transaction record cannot answer:
Were these quantities plausible for these customers? Pull any other orders placed by Account 16446 and Account 12346. If their typical order history shows orders of 10–200 units, an 80,000-unit order is inconsistent with established customer behavior. If no prior orders exist, the accounts have no established pattern at all.
What channel generated these orders? Check the order entry system logs for Invoice 581483 (Account 16446, December 9, 2011) and Invoice 541431 (Account 12346, January 18, 2011). Was this a web order, a phone order, an EDI order, or a manual entry? The channel may reveal whether the order had normal validation applied.
Is there any correspondence or documentation associated with these invoice numbers? Check CRM records, email, or call logs for any communication referencing these invoice numbers. A genuine pre-shipment cancellation typically has a documented reason. A data entry error typically has no corresponding communication at all.
A fourth question the investigation must answer — regardless of cause: How did an 80,995-unit order enter the system without triggering any review? Whether this was a genuine order, a data entry error, or a fraudulent submission, the order entry system accepted it without escalation. That is a process gap independent of what caused the order. The investigation of 16446 and 12346 should produce two outputs: (1) the cause of these specific orders, and (2) a recommendation for minimum order validation controls that would have flagged these transactions for human review before they were accepted.
Recommended minimum validation controls to implement before the investigation closes:
- Quantity flag: Any single line item above 5,000 units on a product with a historical maximum order quantity below 1,000 units should require supervisor approval before the order is confirmed in the system.
- Order value flag: Any order where total order value exceeds 3× the account’s historical single-order maximum should trigger an automatic hold pending review. For accounts with no prior history, a fixed threshold (e.g., £50,000) is appropriate.
- New account flag: Any order above £10,000 from a CustomerID with fewer than 3 prior orders should require account manager confirmation before processing.
These controls do not prevent legitimate large orders — they insert a human review step for orders that are statistically anomalous for that account or product. The review takes minutes. The cost of not having the review is visible in accounts 16446 and 12346.
20.1.1 Account 16446 — True Net Revenue: £2.90
Total invoices: 3 · Gross invoiced: £168.47K · Net retained: £2.90 · Cancellation rate: 100%
| Invoice No | Date | Type | Line Items | Units | Revenue |
|---|---|---|---|---|---|
| 553573 | 2011-05-18 | Order | 2 | 2 | £3 |
| 581483 | 2011-12-09 | Order | 1 | 80,995 | £168.47K |
| C581484 | 2011-12-09 | Cancellation | 1 | -80,995 | £-168.47K |
20.1.2 Account 12346 — True Net Revenue: £0.00
Total invoices: 2 · Gross invoiced: £77.18K · Net retained: £0.00 · Cancellation rate: 100%
| Invoice No | Date | Type | Line Items | Units | Revenue |
|---|---|---|---|---|---|
| 541431 | 2011-01-18 | Order | 1 | 74,215 | £77.18K |
| C541433 | 2011-01-18 | Cancellation | 1 | -74,215 | £-77.18K |
20.1.3 Additional Priority 0 Accounts — Transaction Patterns Requiring Investigation
Account 15098 (UK) — Unit-of-Measure Anomaly, Picnic Basket Wicker Small
Gross revenue contribution: £39.62K from 2 invoices (556444 and 556446, both dated 2011-06-10). The Picnic Basket Wicker Small is invoiced at £34.81 per unit — approximately 20x the unit price for comparable products. Consistent with a unit-of-measure error where individual baskets were invoiced at case pricing. Account 15098 drives 85.8% of this product’s UK revenue and went silent in June 2011 — zero UK orders since. Pre-close verification required: confirm unit-of-measure definition for this product and whether £34.81 reflects individual unit or case pricing.
Account 12454 (Spain) — 100% Cancellation Rate
Gross revenue: £3.53K. Net revenue: £0.00. All orders cancelled. Pre-close verification required: obtain order and cancellation correspondence; determine whether this represents a commercial dispute, a fulfillment failure, or a data entry error.
Account 12558 (USA) — 100% Cancellation Rate
Gross revenue: £270. Net revenue: £0.00. All orders cancelled. Together with Account 12607, these two USA accounts drive the Americas regional cancellation rate to 23.6% despite the other 7 Americas accounts having zero cancellations. Pre-close verification: confirm whether this reflects a USA channel structural barrier or an account-specific issue.
Account 12607 (USA) — 100% Cancellation Rate
Gross revenue: £1.58K. Net revenue: £0.00. All orders cancelled. Pre-close verification: same as Account 12558 — confirm whether USA fulfillment, customs, or payment barriers produce systematic cancellation for this market.
20.2 Appendix B · Accounts 16446 and 12346 — Full UK Transaction Records
UK-segment view of the same investigation.
These two accounts require investigation before any commercial decision involving UK revenue rankings is made. The full transaction record for each account is reproduced here. Cancellation rows are highlighted in red.
20.2.1 Account 16446 — True Net Revenue: £2.90 (UK-segment view)
Total invoices: 3 · Gross invoiced: £168.47K · Net retained: £2.90 · Cancellation rate: ~100%
| Invoice No | Date | Type | Line Items | Units | Revenue |
|---|---|---|---|---|---|
| 553573 | 2011-05-18 | Order | 2 | 2 | £3 |
| 581483 | 2011-12-09 | Order | 1 | 80,995 | £168.47K |
| C581484 | 2011-12-09 | Cancellation | 1 | -80,995 | £-168.47K |
20.2.2 Account 12346 — True Net Revenue: £0.00 (UK-segment view)
Total invoices: 2 · Gross invoiced: £77.18K · Net retained: £0.00 · Cancellation rate: 100%
| Invoice No | Date | Type | Line Items | Units | Revenue |
|---|---|---|---|---|---|
| 541431 | 2011-01-18 | Order | 1 | 74,215 | £77.18K |
| C541433 | 2011-01-18 | Cancellation | 1 | -74,215 | £-77.18K |
Author: Shawn Phillips | Lailara LLC
← Appendix A — Canonical Values & Methodology | Appendix C — Product Analysis Detail →