Sample deliverable

Diligence Data Analysis, on a synthetic target

What the analysis delivers, shown on the transaction data of a synthetic US wholesale distributor, the same company as in the Reporting Trust Review sample: a data room index with what is missing, revenue quality, retention, concentration and receivables, and a red-flag memo.

Revenue grew 24.1%. Six findings to resolve before relying on it.

The target is made up for this sample. Its revenue grew from $12,139,900 in 2024 to $15,068,234 in 2025, but it peaked in Q2 2025 and fell in each of the two quarters after; accounts it already served at the start of 2024 spent 30.4% less in 2025; and $1,111,457 of billed orders more than 90 days old shows no payment. Each finding carries the figure behind it and the question it raises.

  1. Revenue fell in the last quarters

    Revenue fell in each of the last 2 quarters; Q4 2025 was 4.1% below the peak in Q2 2025, dated by delivery

    Ask for the reason (seasonality, lost accounts, pricing) and for the current order book. Part of the gap is cut-off: 96 orders worth $166,982 placed in the last quarter were not yet delivered at the extract.

  2. Established accounts bought less

    Accounts delivered to in Q1 2024 spent 30.4% less in 2025 than in 2024 (net revenue retention 69.6%); 290 of 704 bought nothing in 2025

    Growth depends on new accounts; ask for churn reasons, the pipeline and the cost of acquiring accounts.

  3. Old receivables

    646 billed orders over 90 days with no payment recorded: $1,111,457; $357,613 of it on invoiced orders never delivered (next finding)

    Ask whether they were paid outside this extract, credited, or are uncollectable; the answer moves working capital and possibly revenue.

  4. Billed, never delivered

    216 invoiced orders over 90 days with no delivery recorded and $357,613 open

    Ask whether the goods shipped; if not, these are billings without a sale, and any revenue taken on them should be reversed.

  5. Deposits on canceled orders

    $67,088 received on canceled orders

    Ask whether these are owed back to customers; if so they are a liability, not cash available to the buyer.

  6. Revenue cannot yet be tied to the financial statements

    No general ledger extract in the data room

    Request monthly revenue from the ledger and reconcile it to the order data before relying on any figure above.

What was provided, and what is missing

TableRowsKeyCovers
accounts2,600account_idBill-to accounts and their state
ship_to4,369ship_to_idDelivery locations of each account
orders17,804order_idOrders placed 2024-01-01 to 2026-01-04, with status, promised and delivery dates
order_lines45,827order_id, line_noQuantity, unit price and freight per line
payments16,870order_id, payment_seqAmount and method per payment, without dates

Missing, and what it prevents

  • Cost of goods by line or product. Margin by product cannot be computed; only revenue and price can.
  • Invoice and payment dates. Days sales outstanding and collection trends cannot be measured; receivables are aged by order date instead.
  • Product or SKU master. Revenue cannot be split by product line, and price cannot be separated from mix.
  • Credit memos and returns. Revenue is shown gross of any credits issued after delivery.
  • General ledger revenue by month. The order data cannot be reconciled to the reported financial statements.

Delivered revenue by quarter, dated by delivery

QuarterRevenue
Q1 2024$2,551,615
Q2 2024$2,962,491
Q3 2024$3,167,753
Q4 2024$3,458,041
Q1 2025$3,542,348
Q2 2025 (peak)$3,896,937
Q3 2025$3,892,984
Q4 2025$3,735,965

Delivered orders rose 22.9%, from 7,444 to 9,145, while the average order rose 1.0%: the order count drove the growth. Price and product mix cannot be separated without a product master. At the extract, 96 orders worth $166,982 placed in the last quarter were not yet delivered, so the last quarter is understated by cut-off; 15 delivered orders have no delivery date and are left out.

From 2024 revenue to 2025 revenue, by account

Revenue 2024$12,139,900
Established accounts (704, delivered to in Q1 2024)($2,622,149)
Accounts acquired during 2024 (685), mostly a full year after a part year+$1,792,411
Accounts new in 2025 (635)+$3,758,072
Revenue 2025$15,068,234

Retention is measured on established accounts, those delivered to in the first quarter of 2024, so that accounts acquired during the year do not count a full year after a part year as growth. Their net revenue retention is 69.6% and gross retention 55%; 290 of the 704 bought nothing in 2025. Accounts acquired during 2024 and new accounts in 2025 carried the growth. The extract starts in 2024, so how long the established accounts had been customers is not known.

The ten largest accounts in 2025

Concentration is low: the ten largest of 1,456 accounts bought 8.6% of 2025 revenue, the largest 2.47%. The top fifth of accounts bought 59.3%.

RankAccountStateRevenue 2025Share
1A00499CA$372,2612.47%
2A01381OH$211,0431.4%
3A01143CA$118,5940.79%
4A00598CA$112,0540.74%
5A01320CA$99,9300.66%
6A01110CA$85,3060.57%
7A00451OH$82,4920.55%
8A02226SC$75,2050.5%
9A00517TN$70,4110.47%
10A01161TX$69,1620.46%

Billed orders with no payment recorded, at 2026-01-05

Age, by order dateOrdersAmount
0 to 30 days400$612,481
31 to 60 days192$316,805
61 to 90 days37$55,468
Over 90 days646$1,111,457
Total1,275$2,096,211

Billed means delivered, shipped or invoiced. Two payment patterns are reported apart from the aging. 2,659 orders were paid short by $89,742 in total, all by ACH and by a median of 2%, consistent with an early-payment discount. 4,392 orders were paid $212,824 above their value, all by card, consistent with a card surcharge. Both are for the seller to confirm.

The data room has no invoice or payment dates, so receivables are aged by order date and days sales outstanding can only be approximated: about 50.8 days on 2025 revenue. The ledger's receivables subledger would replace both.

What this sample is and is not

  • It is a sample, not client work. The target is the synthetic distributor of the Reporting Trust Review sample, generated from a fixed seed; no real company or person is described.
  • Every figure is computed by a script from the five tables in the index; the script stops on a table that does not reconcile to itself. Revenue is dated by delivery. Figures generated on 2026-11-15.
  • No figure here is tied to the financial statements: the data room has no ledger extract, which is the first request on the list.
  • No margin is shown: there is no cost data. A client engagement adds margin by product once cost of goods is provided.
  • The analysis supports a quality of earnings report and is not one. The report of record stays with the accounting firm.

The same analysis, on your data room.

From $7,500, two to three weeks. Tell us the deal stage and what the data room holds.