Accounts Payable Dashboard – Supplier Evaluation and Selection Matrix

Description
This Excel template allows you to monitor purchases, and suppliers’ invoices payment through relevant financial KPIs: total purchases, outstanding amount, payment rate, overdue amount and overdue rate, the number and list of overdue invoices, detailed accounts payable, the aging balance and the DPO (Days Payable Outstanding).
It includes a supplier evaluation and selection Matrix, which will help you compare suppliers features and skills.


This tool will help you avoid overdue invoices and stay on good terms with your suppliers. It includes:


Accounts Payable Dashboard
Financial report that shows you the situation of accounts payable, sorted by due date and amount.
- Track your key indicators: total Purchases, outstanding amount, payment rate, overdue amount, overdue rate, overdue invoices, and Days Payable outstanding (DPO)
- Visualize the accounts Payable payment timeline: paid amounts, overdue amounts, and the forecast of future Payments by due month
- Use the invoices analysis report to monitor overdue, due, and not due invoices, sorted by due date and amount
- Use the accounts Payable analysis report to monitor the balance of each supplier, the overdue amount and overdue rate, sorted by overdue amount.


Account Payable Aging Report
Financial report that evaluates if you’re having trouble paying your invoices on time.
- Visualise the overall aging balance: breakdown of total accounts payable into past due payment group.
- Use the accounts Payable aging report to Track the breakdown of each supplier balance into past due payment group
- Use the invoices aging balance to Track the breakdown of purchase invoices into past due payment groups


Supplier Evaluation and Selection Matrix
Visual tool that helps you to choose the right supplier based on criteria that really matter to your business.
- Visualize the evaluated suppliers by comparison criteria
- Compare suppliers based on their score and the evaluation criteria


Using this tool is very easy:
• Enter your suppliers’ data
• Record the received invoices
• Regularly Enter the Payments for each invoice
 
Template Requirements and How to Use:
• Works on PC with Windows.
• Does not work or may not work on a MAC.
• Requires Microsoft Excel version 2013 or higher with Power Pivot add-in. 👉 Watch this video to find out if your Excel version includes the Power Pivot add-in https://youtu.be/-3U0Om5d_JU
• Allow Macros to run (enable content when opening file).
• Ready-to-use template, just enter or import your data.
• Dashboard ready to be printed.
• Instructions on the Excel sheet “User Guide”.


Customizable template:
Colors, fonts, and all style attributes can be changed to suit your needs. If you want to make changes on your own, just enter the password included with the file to unlock the template.