Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
03-23-2023 11:10 AM - last edited 12-02-2023 18:20 PM
An Accounts Receivable (AR) can mean the amount of money a customer owes a company for goods or services they received, or the process of converting their debt into cash. Therefore, managing AR is such a critical business process, and the quality of AR can determine whether or not a company thrives. A dashboard that presents receivables data graphically can offer valuable insights about an organization's receivables status and provide a clear picture of its cash position.
The use of highly interactive dashboards with drill-down capabilities into different breakdowns such as geography, period, customer, and invoice details can provide transparency and insight across the entire process for AR. Having such a solution in place can help a company shorten the order-to-cash cycle and maximize its cashflow and working capital.
The report contains two pages: Overview and Customer Insights
OVERVIEW
The Overview page contains high-level information and shows 360-degree view of the company's current receivables position. Data for this fictitious company are available from 1 January 2017 through 31 May 2020. By selecting a desired date slicer at the top of the report, you will be able to dynamically recalculate the receivable balances as of any previous date.
The top info bar displays KPIs, including the customer balance as of selected date, broken down by non-due and overdue balances. DSO (Days Sales Outstanding) is shown along with the Overdue % for the past 12 months. DSO is the average number of days it takes to receive cash from customers. This metric measures the very heart of the AR process.
Age Analysis of Due Balances shows balances broken down by age groups. The aging calculation is dynamic, which means that if you change the end date of the date range on top, the balances are recalculated. I have used Calculation Group to achieve this setup. You can right-click on any age group and go to the relevant detail page to see the customers and invoices that belong to the selected aging group.
The donut chart shows the overdue balances with percentages by regions
The clustered column chart on the upper right shows the actual vs estimated & forecasted cashflow. This chart is useful to know future cash inflow based on customers’ average past settlement days. The chart shows the expected inflow in the next three months.
The chart on the bottom left explains AR efficiency by comparing monthly sales with the running due balances, broken down by within-due and overdue balances.
The matrix visual shows the top 10 customers based on overdue balances with number of invoices within overdue periods and flagging customers who exceed their credit limits. You can drill down to the detail page for more details from here.
CUSTOMER INSIGHTS
The 2nd page shows customer specific receivable information with the hierarchy by country, city, and customers.
Each line in the matrix visual represents receivable balances along with due balances and the breakup of the age groupings. You are also able to drill through to invoice details from this visual
Your thoughts and opinions on how to enhance and expand this report are much appreciated.
Thanks and kind regards
Fowmy Abdulmuttalib
Fowmy is a Microsoft-certified business intelligence professional with extensive experience in finance, accounting, and data analytics. He founded ExcelFort Consulting Services, which specializes in training, consulting, and building business intelligence solutions using the Microsoft Power BI. Interested in everything data-related, he would like to share his passion and knowledge with the data community.
Website https://excelfort.com/
YouTube channel https://www.youtube.com/c/ExcelFort
LinkedIn: https://www.linkedin.com/in/fowmy/
Twitter: https://twitter.com/excelfort
Email: fowmy@excelfort.com
eyJrIjoiMGRhMmRmOTktZDM0Mi00MmU4LWIxMjUtOWM4M2E5NjQyYmZjIiwidCI6IjlhYmQwNTc0LTBlMmYtNGM2OS1hMDk2LThjZjA1YWZiYWZjNCIsImMiOjl9&pageName=ReportSection
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hello 🙂 Could you please share with me also the PBI file? I would love to study, the dashboard contains so useful charts, would love to see the logic and to learn how to make something similar!
Thanks a lot!
Hello can you share your Accounts Receivable Dashboard with me please?
<hi, can you please share thepbix file?
Hi, this looks fatastic, can you share with me your PBIX file? Thanks!
Hi,
Your dashboard looks fantastic! Would it be possible for you to share the pbix file with me?
Thanks in advance!
Best regards,
Chanush KR
Hi, This is great. Could you please share the PBIX file with me?
Thank you very much
Hi the dashboard is very good. could you share the Pbix file
Many thanks
Could you please share this file
Hi the dashboard looks good. could you share the Pbix file
Hi, This is an amazing report. could you please share PBIX file?
Many thanks,
Very nice Dashboard. Is it possible to share the PBIX?
After taking a look I might ask questions on how to provide some additional info.
Thanks a lot
Wow! such neat work thanks for sharing. I wan to do a similar project, do you mind sharing the PBIX file
Wow...this is fantastic. I would love the pbix file to help me start on something similar.
Hello, your dashboard is very awesome. Could you give me the PBIX file?
To all the people who have replied, have any of you had the author reply to your request? If so, can you share the PBIX with those of us who have also requested it?
Paul H.
I have started making it, I made the dataset in excel, imported it in power bi and my focus was on creating visuals. I have not prepared them all, it's not fully cooked but since the weekend has lapsed I am sharing the file so that the drill-down table prepared by me which I thought to be of most importance could be seen easily. I will work on the remaining part as well and will share the same when completed.
I reached out and it's $125 to buy so I'm sure non of us that asked is getting a copy 🙂
HI @Carolinaaa, how did you contact them? I have been on their website and have not been able to get a response from chat or email. Thanks, Paul
If that's the case, let me make it by this weekend. If it goes well, will share the copy for each one here or post it on LinkedIn.
I needed this motivation/challenge.
Thank you
Hi yasiralam,
How did it go with your attempt to re-create the AR Dashboard? I am looking to put together something like that and would love to see YOUR pbix data sources and design. Please keep me in mind as well 😉
Paul
Did it go well?
Hopefully you make it