The Accounts Receivable Completeness Check report is an exported .XLSX file that can help you to confirm the completeness of your client’s AR detail by comparing your client’s year-end customer balances with our calculated values.
Understanding the completeness check report
For each customer in your client’s data, MindBridge calculates a closing balance (shown in column Closing Balance) by adding the opening balance you’ve provided (shown in column Opening Balance) to the change in the account in your client’s AR detail (shown in column Activity Balance). This calculated closing balance is compared with the total of your client’s year-end open receivables (shown in column Supplied Closing Balance). The difference between the two values is shown in column Delta.
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)