Overview

Aged Receivables Dashboard in Excel
This Excel dashboard allows you to easily access your customer contact information (including customer contact information, email address, and phone number as well as customer notes) and also to review the number of past due invoices, total past due to invoice value, oldest invoice number, oldest customer PO#. On the right-hand side of the dashboard, there is a past due invoice distribution showing the percentage of past due to invoices within each aging category (1-30 days, 31-60 days, 61-90 days, and greater than 91 days). Using the aged receivables information you can easily determine how your customer is performing and it also will show you the aging group with the greatest past due to value of invoices.

The Excel Aged Receivables Dashboard also handles customers who do not have contact information setup as well as customers who do not have any invoices past due. In the header of the dashboard, you'll notice that there are hyperlinks to each of the tabs where you can add customer data, invoice data as well as a tab that shows you how to use the dashboard. I've included the calculations tab in the Excel file also which is where the calculations are performed to allow the dashboard to run. Each tab on the dashboard will have buttons in the header to easily and quickly navigate around the file.

Tags
Reviews Add a review
No reviews yet

More From Rahim Zulfiqar Ali

Browse our top rated business templates. See All
Accounting & Bookkeeping Solution in Microsoft Excel - LedgerXLR8
21
0
Template: Accounting & Bookkeeping Solution in Microsoft Excel - LedgerXLR8- Chart of Accounts- Quarterly Receipt Book- General Journal- General Ledger-…
Accounting & Dashboard for ETSY Sellers in Microsoft Excel
73
0
Accounting & Dashboard for ETSY Sellers in Microsoft ExcelA simple, beautiful, and easy to read design.The layout is not cluttered…
Premium Editable Graphic Resources for POWERPOINT Presentation Templates
71
0
Premium Editable Graphic Resources for POWERPOINT Presentation TemplatesYou can easily resize these resources without losing quality. To change the color,…
KPI Dashboard in Microsoft Excel
249
0
KPI Dashboard in Microsoft ExcelFinancial Metrics     Cash Flow     Expenditure     Profit %     Revenue     Revenue % -…
Monthly Planner Template in Microsoft Excel
1,019
90
Monthly Planner Template in Microsoft Excel
Calendar Template & Daily Planner in Microsoft Excel
978
70
Calendar Template & Daily Planner in Microsoft ExcelCalendar template – features:- One page, 12 month calendar view- Daily calendar with…
See All