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.

Last updated

Was this helpful?