Accounts Payable Report

This ready-to-use Excel template allows you to track your bills payment deadlines, amounts to pay, overdue amounts and rate, detailed bills by vendor, upcoming bills to pay, amounts to pay by due month and vendor balance aging report.
It also involves a vendor evaluation and selection matrix, which will help you compare vendors’ features and skills, based on criteria that really matter to your business.

This vendor dashboard template includes three reports:

Accounts Payable KPIs Report

Shows key insights on vendor bills to pay:

• Vendor bills to pay, total amount to pay, running balance, overdue amount and overdue rate
• Vendor balance aging report
• Vendor bills which are coming due and how long they have gone unpaid

Bills Calendar

Shows upcoming bills to pay:

• Amounts to pay by due month
• Upcoming bills to pay, due dates, and due amounts

Vendor Evaluation and Selection Matrix

Weighted decision matrix that helps you to choose the right vendor based on criteria that really matter to your business:

• Compare vendors or suppliers based on their weighted score and the evaluation criteria
• Visualize the best vendor or supplier by selection criteria

This template will help you avoid overdue bills, stay on good terms with your vendors or suppliers, and select the right vendor for your business.

Using this template is quite easy, you just need to:

• Input your settings
• Enter vendors’ data
• Enter bills’ data
• Enter payments’ data

Video:

Template Requirements and How to Use:

• Works on PC with Windows.
• Does not work on MAC.
• Requires Microsoft Excel 2016 or higher with Power Pivot add-in. 👉🏼 Watch this video to find out if your Excel version includes the Power Pivot add-in.
• Memory (RAM) 4 GB or more recommended.
• 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 file “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.