Price Testing
Re-price every invoice line from the price list and the discount each customer was agreed.
- Ledger + 2 client documents
How the result is read
Pricing is tested on the whole population rather than a sample: each line is re-priced from the list price in force at year end, less the discount the customer master records as agreed. Billing below that price is an unauthorised discount — a control failure and a classic place for kickbacks; billing above it is an overcharge the customer will claim back. A pricing failure is a relationship, so the result is one row per customer. The lines are agreed to revenue first, so the population is known to be complete.
In the application
Price Testing is filed under Revenue & receivables, index letter C. "Run all analyses" runs it with every other analysis the ledger and the documents loaded 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