The Revenue Analytics Anomaly
You are auditing Delta Digital, a software company with $62 million revenue. You run a data analytics test comparing monthly revenue by product line to the prior 24 months. One product line, 'Legacy Support', shows revenue of $4.1 million in December, against a 24-month average of $1.2 million. The December figure is concentrated in 11 invoices, all dated 30 and 31 December, all to a single reseller, and all with payment terms of 120 days. The reseller's credit limit is $500,000. The sales director explains that a year-end promotion offered extended terms to clear old stock, and that the reseller is a long-standing partner. Materiality is $300,000.
1. Evaluate the anomaly using professional scepticism and identify the fraud risk factors present.
Read the worked answer
The pattern has several red flags that together outweigh the sales director's explanation:
- Timing: all 11 invoices fall on the last two days of the year, which is consistent with holding the period open or pulling revenue forward.
- Concentration: a single reseller accounts for the entire spike, so one relationship drives the anomaly.
- Terms: 120-day terms are far outside normal practice and four times the reseller's $500,000 credit limit, suggesting the goods may not have been genuinely sold or the reseller may be a channel for circular transactions.
- Product: 'Legacy Support' revenue normally recurs evenly; a fourfold spike is inconsistent with the product's economics.
- Magnitude: $4.1 million is 13.7 times materiality, so even a partial overstatement is material.
The explanation is plausible on its surface but untested. Professional scepticism requires corroboration, not acceptance. The credit-limit breach is especially telling: a genuine sale of that size would normally require credit approval, and none is evident.
2. Design the substantive procedures you would perform and state what evidence would cause you to conclude the revenue is misstated.
Read the worked answer
Procedures should target occurrence and cut-off:
- Inspect the underlying contracts for the 11 invoices, focusing on acceptance, delivery and title-transfer terms.
- Obtain proof of delivery or evidence of installation/activation, not just the invoice.
- Confirm directly with the reseller, including whether the goods were received, whether they remain unsold, and whether side agreements exist.
- Review the reseller's payment history and any post-year-end returns or credit notes.
- Test the credit approval trail for the 120-day terms and the limit breach.
- Inspect correspondence between sales and the reseller around year-end for return rights or price protection.
- Check subsequent cash receipts after year-end.
Evidence that would indicate misstatement: no proof of delivery, goods still held by the reseller on consignment, a side letter granting return rights, or no cash received within the extended terms. If the reseller holds unsold goods with return rights, revenue should not be recognised. If found, the auditor should quantify the misstatement, consider the effect on the fraud risk assessment, and evaluate whether the issue is isolated or indicative of a broader pattern.