Revenue Cut-off Around a Warehouse System Migration
Kestrel Components Ltd (KCL) moved to a new warehouse despatch system on 1 December 2024, mid-way through its financial year ending 31 March 2025. The old system was frozen on 28 November and the two systems ran in parallel for the first ten days of December. Management capitalised £240,000 of implementation costs, including £85,000 of staff training and £40,000 of data cleansing, and is amortising over five years. December revenue is £4.2m against a monthly average of £3.6m; 62 despatch notes dated 29-30 November were keyed only into the new system on 2-3 December. The credit controller left in October and no aged debt report has been produced since September. The finance director says the system migration was tested by the vendor and 'cut-off is a timing matter only'. The audit partner has set materiality at £70,000 and performance materiality at £49,000.
1. Identify the significant risks arising from the migration for the revenue and receivables assertions, and explain why the parallel-run period is the critical audit focus.
Read the worked answer
The key assertion risk is cut-off for revenue and existence for receivables. The 62 despatch notes dated 29-30 November but keyed on 2-3 December create a real risk that revenue is recorded in the wrong period, or recorded twice if the legacy system also captured them. Because December revenue of £4.2m is £600k above the monthly average, the auditor cannot assume the uplift is genuine trading - it may be duplicated postings from the parallel run. The parallel run is critical because both systems were live simultaneously: any transaction keyed into both, or into neither during the handover window, will distort cut-off. The auditor should obtain the full transaction listing from both systems for 28 November to 10 December, reconcile them line by line, and test a sample of despatch notes against both the despatch date and the posting date. The absence of an aged debt report since September means recoverability and the allowance for expected credit losses cannot be corroborated from internal records; the auditor needs alternative evidence such as post-year-end cash receipts and direct confirmation of balances. The capitalised £125,000 of training and data cleansing does not meet the IAS 38 criteria for capitalisation and is material against performance materiality of £49,000, so it should be challenged and written off, reducing profit and the intangible asset.
2. The finance director refuses to extend cut-off testing, arguing the vendor tested the system. Draft the auditor's response, including the effect on the audit opinion if the restriction is maintained.
Read the worked answer
Vendor testing addresses whether the software functions as designed; it does not provide audit evidence about whether KCL's own transactions were completely and accurately recorded at the period end. The auditor should explain this distinction in writing to the finance director and the audit committee, request access to both system transaction logs for the handover window, and record the request and the refusal. If access is refused, this is a scope limitation imposed by management. The auditor should assess whether alternative procedures can provide sufficient appropriate evidence - for example, reconciling the December bank receipts to invoiced sales, or confirming balances with major customers. If the auditor concludes that a material and pervasive limitation exists, a disclaimer of opinion is required under ISA 705. If the effect is material but not pervasive, a qualified opinion is appropriate. The auditor must also consider whether the refusal indicates a fraud risk under ISA 240, particularly given the missing aged debt report and the departure of the credit controller, and should communicate the matter to those charged with governance before the report is signed.