# 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.

{% embed url="<https://auditboard-education-services.wistia.com/medias/3hl06g644c>" %}

### 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](https://docs.auditboardanalytics.com/workflows/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](https://docs.auditboardanalytics.com/workflows/parameters/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.