Accounts Receivable Dashboard

59

This is an Excel tool for monitoring sales and debt collection. It allows you to avoid overdue invoices through relevant financial KPIs: the collection forecasts and the collected amounts, the number of days sales outstanding (DSO), receivables amount, the aging balance, the number and list of overdue invoices, overdue amount and overdue rate. It lets you know exactly which invoices are overdue and automatically generate reminder email template.

This tool will help you to keep track of invoices and payments and avoid cash flow problems.

This is an Excel tool for monitoring sales and debt collection. It allows you to avoid overdue invoices through relevant financial KPIs: the collection forecasts and the collected amounts, the number of days sales outstanding (DSO), receivables amount, the aging balance, the number and list of overdue invoices, overdue amount and overdue rate.

It lets you know exactly which invoices are overdue and automatically generate reminder email template.

This tool will help you to keep track of invoices and payments and avoid cash flow problems.

This accounts receivable dashboard template includes:

Accounts Receivable Dashboard

Financial report that shows you the situation of accounts receivable, sorted by due date and amount.

  • Track your key indicators: total sales, sales recovery rate, Days Sales Outstanding (DSO), total amount of receivables, number of overdue invoices, total overdue amount and overdue rate
  • Monitor the accounts receivable collection timeline: forecast chart of amounts to be collected and the collected amounts, by due month
  • Analyse outstanding sales invoices, sorted by due date and amount: overdue, due and not due invoices, number of overdue days for each invoice
  • Track account receivables sorted by overdue amount: total receivable, overdue amount and overdue rate

Accounts Receivable Aging Balance

This financial report evaluates how effective your business is at converting sales to cash.

  • View the overall aging balance: breakdown of total receivable into past due payment group
  • Monitor accounts receivable aging report: breakdown of customer receivables into past due payment group
  • Follow invoices aging balance: breakdown of invoiced amounts into past due payment group

Overdue Invoices Payment Reminder

This report lists overdue invoices and automatically creates the reminder email template.

Using this tool is very easy, you just need to enter regularly or import:

  • Sales invoices
  • The payments received 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.


Software

Microsoft Excel

About the author

Nisrine LAHRECHE
Consultante Formatrice Microsoft Excel, Power BI, Analyse des données