Duplicate Customer Receipts
Invoices collected twice: two customer receipts for the same invoice and amount, or the same amount within 30 days where no reference is carried.
- General ledger alone
How the result is read
A duplicate receipt leaves the customer in credit and inflates cash and receivables clearing at once, so it passes unnoticed in both balances. Matching receipts on customer, invoice reference and amount finds it directly; the customer's movement in the year corroborates it.
The worksheet, on the demo engagement
Duplicate Customer Receipts, as the application draws it for Harrow Precision Engineering Ltd, the fictional demo engagement — one row per receipt that repeats an earlier one.
Illustration. INV-10442 collected twice, three days apart; the customer ends the year in credit.
Result grid1 rows
| Customer | Name | Invoice ref | Amount | First receipt | Duplicate receipt |
|---|---|---|---|---|---|
| C0142 | Harbor Supply Co. | INV-10442 | 18,300.00 | CR-2025-0881 | CR-2025-0903 |
In the application
Duplicate Customer Receipts is filed under Revenue & receivables, index letter C. "Run all analyses" runs it with every other analysis the ledger can answer. The worksheet states the population it tested on its face — or "Not applicable" with the reason when a column it depends on is empty — and the Excel workbook the engagement exports files it under C, beside an index of the source files with their SHA-256 fingerprints.
Read it with
Run your next audit file test without the Excel crash.
One free engagement to evaluate, valid 60 days. The ledger never leaves the machine.
- 20 minutes
- Runs on a fictional engagement
- No client data required