The completeness check report for accounts receivable analyses is an exported .XLSX file that can help you confirm the completeness of your client’s AR detail by comparing your client’s year-end customer balances with our calculated values.
Understand the completeness check report
If for a customer the calculated and the supplied balances are different, then the Balanced column shows false for that customer and that customer’s row is highlighted yellow in the report. Otherwise, the Balanced column shows true.
If the difference between the calculated and the supplied balance is greater than the tolerance that you’ve selected through the Balance Tolerance input at the top of the report, then the Tolerance Testing column of the report shows Out of Balance for the customer. Otherwise, the Tolerance Testing column of the report shows Account Balanced.
The Remarks column lets you know:
- If a customer does not appear in your client’s year-end open receivables list (Outstanding Entry Not Provided)
- If a customer has a balance but is not present in your client’s AP detail (Activity Entry Not Provided)
- If the opening balance supplied for a customer does not match the total of the start-of-year open receivables supplied for the same customer (Opening Balance is inconsistent between both files)
Anything else on your mind?