Accounts Payable Dashboard – Supplier Evaluation and Selection Matrix

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

Video:

Template Requirements and How to Use:

• Works on PC with Windows.
• Does not work on 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.
• 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.

Included in the download:

• A template with sample data
• An empty template, ready to receive your data.

Download link:

• Downloads are available from your account once your payment is confirmed.

Warning:

We have put a lot of effort into providing you with a quality work tool at a reasonable price. We kindly ask you to respect the copyright so that we can continue to exist, develop and improve our services. Thank you.

Once purchased, it is prohibited to resell, redistribute, sublicense, assign or transfer this file to anyone in any form. Please read our terms and conditions before purchasing this product.