Bill Tracker Excel Template

Description
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

Template Requirements:

• Works on PC with Windows.
• Does not work on MAC.
• Memory (RAM) 4 GB or more recommended.
• 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
• 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 Excel file “User Guide”.

Template Customization:
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.