Live A/P Dashboard for Google Sheets & Excel

The AP dashboard provides a snapshot of the company's outstanding payables. This includes key performance indicators (KPIs), such as the total, current and overdue accounts payable, as well as aging reports and vendor information.

‍

Some key features of the AP dashboard include: 

‍

- A total payable amount that reflects the current balance of all outstanding invoices

- A breakdown of the payable amount by invoice age shows how much is overdue, due within 30 days, etc. 

- Details on specific vendors, including totals owed, contact information, and any recent activity or changes

‍

How to Set Up an Accounts Payable (AP) Dashboard?

‍

LiveFlow has an AP Aging Summary report that can be imported into Google Sheets. The AP Summary report shows the date, vendor, status, and other information for each bill. This information can be used to create a dashboard. 

To import the report into Google Sheets, just use the template above and change the underlying company under the “Manage reports” tab. Once done, your AP Aging Summary report will be updated on Google Sheets. You can then use this data to customize the dashboard.

Want to know more about LiveFlow? Book a demo call here!

‍

What is the Accounts Payable Process?the

‍

The goal of the AP process is to ensure legitimacy and accuracy of any payments made and to maintain good supplier relationships. In order to do this, the AP department typically employs a few key procedures:

‍

1. Reviewing and approving invoices: This is the first step in the AP process, where an invoice is reviewed for accuracy and completeness.

‍

2. Issuing payments: Once an invoice has been approved, the payment is issued. This can be done manually or through an automated system.

‍

3. Tracking payments: The AP department must track all payments made, including when they were issued and when they were received by the vendor/supplier. This helps to ensure that no payments are missed or late.

‍

What is the best KPI for Accounts Payable?

‍

In order to continue to deliver value to the organization, the Accounts Payable team must set KPIs and track their performance against these objectives. This will help them to identify areas for improvement and craft strategies that will have the most positive impact on the department and the company as a whole.

‍

-Total Payables in AP is the sum of all payables that are currently due

-Balance in AP is the current amount of unpaid payables

-Overdue in AP is the amount of unpaid payables that are past due

-Overdue percentage in AP is the percentage of overdue payables out of the total payable amount

‍