Accounts Receivable - Analytical Review

This template performs various trend and analytical reviews on your accounts receivable listing. It tests the period-over-period changes in sales by month, customer, and your AR Turnover Ratio.

Input Requirements

• An Accounts Receivable Listing sourced from your ERP system (SAP, Oracle, Microsoft Dynamics, etc.).

• A prior period Accounts Receivable Listing sourced from your ERP system (SAP, Oracle, Microsoft Dynamics, etc.).

• Parameters

  1. Current Period End: Last date of the period you are testing (12/31/2024).

  2. Prior Period End: Last date of the prior period you are testing (12/31/2024).

  3. Prior Year Turnover Ratio: Prior year accounts payable turnover ratio.

  4. File Input Parameters

Output Expectations

• An analysis on monthly sales versus total sales and the YoY trend.

• An analysis on monthly sales amount and the YoY trend.

• An analysis on YoY trend for total sales.

• An analysis on sales by customer YoY and customer spend versus total YoY.

• An analysis on accounts receivable turnover ratio and the trend YoY.