Accounts Payable - Analytical Review

This template performs various trend and analytical reviews on your accounts payable listing. It tests the period-over-period changes in spend by month, vendor, and your AP Turnover Ratio.

Input Requirements

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

• A prior period Accounts Payable 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 spend versus total spend and the YoY trend.

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

• An analysis on YoY trend for total purchases.

• An analysis on spend by vendor YoY and vendor spend versus total YoY.

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