Accounts Receivable - Credit Limits and Balance Testing

This template performs testing on the credit limits and total balance of customers.

Input Requirements

• A customer invoice listing file sourced from your ERP system (SAP, Oracle, Microsoft Dynamics, etc.).

• A listing of valid credit approvers.

• Parameters

  1. File Input Parameters

Output Expectations

• An identification of customers who's credit balance exceeds their credit limit.

• An identification of customers who's single invoice exceeded their credit limit.

• An identification of customers who carry a negative credit balance.

• An identification of invoices with improper approval.

• An analysis on whether credit limits were consistently applied to customers and those customers who it wasn't consistently applied to.