Account Receivable - Credit Aging and Approval

This template covers two areas related to accounts receivable. It tests items related to accounts receivable aging and also tests for proper credit approvals.

Input Requirements

• An AR aging report sourced from your ERP system (SAP, Oracle, Microsoft Dynamics, etc.).

• A trial balance report sourced from your ERP system (SAP, Oracle, Microsoft Dynamics, etc.).

• Parameters

  1. Prior Period Report Date: Date on which you want to use to determine A/R aging buckets or when the report was run (12/31/2023)

  2. Past Due Threshold: Dollar amount in which if exceeded you'd want to flag for follow up on late accounts.

  3. Variance Threshold: Period over period change in AR aging buckets you'd want to flag for follow up if exceeded.

  4. File Input Parameters

Output Expectations

• An identification if the provided A/R aging buckets were correct.

• A population of customers who's period over period change in the different A/R aging buckets exceeded the threshold.

• A population of customers who's balance exceeded the past due threshold and are overdue.

• An determination if your A/R aging data in total ties to your General Ledger.

• A population of invoices which were not approved by the appropriate approver.