Credit Limits and Customer Master
Read each customer’s year-end balance against the limit, terms and history in the customer master.
- Ledger + 2 client documents
How the result is read
The credit control is meant to stop sales to customers who will not pay. A balance well beyond the credit limit is an override or an uncollectable receivable; a customer owing money and absent from the master was never vetted; a customer opened in the last month with a large balance is where fictitious revenue tends to sit. Items far beyond the agreed terms close the list as an allowance question.
In the application
Credit Limits and Customer Master 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