skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Microsoft 365 + Power BI
    • Dynamics 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Partners Overview
    • Solutions Partners
    • BI Specialized Partners
    • Power BI CSOs
    • Fabric Partner Community
    • Training
    • Getting started
      • Overview
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Power BI forums
    • Updates
    • News & Announcements
    • Get Help with Power BI
    • Desktop
    • Service
    • Report Server
    • Power Query
    • Mobile Apps
    • Developer
    • DAX Commands and Tips
    • Custom Visuals Development Discussion
    • Health and Life Sciences
    • Power BI Spanish forums
    • Translated Spanish Desktop
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Training and Consulting
    • Instructor Led Training
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    • Ideas
    • Custom Visuals Ideas
    • Issues
    • Issues
    • Events
    • Upcoming Events
    • Community Engagement
    • T-Shirt Design Challenge 2023
    • Community Blog
    • Power BI Community Blog
    • Custom Visuals Community Blog
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 

    Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

    • Power BI forums
    • Galleries
    • Data Stories Gallery
    • Re: Accounts Receivable Dashboard

    Re: Accounts Receivable Dashboard

    10-15-2022 03:38 AM - last edited 12-02-2023 18:38 PM

    Carol_W
    Regular Visitor
    6845 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    Fowmy
    Super User Fowmy
    Super User
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Accounts Receivable Dashboard

    ‎05-20-2022 02:22 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

    Did I answer your question? Mark my post as a solution! and hit thumbs up


    ⭕ Subscribe and learn Power BI from these videos

    ⚪ Website ⚪ LinkedIn ⚪ PBI User Group

    Labels:
    • Labels:
    • Business
    Message 1 of 94
    74,519 Views
    39
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    jlac13
    jlac13
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎10-31-2022 07:31 AM

    Hi, great work! Would it be possible to get the file as well so I can study it? Thanks!

    Message 11 of 94
    6,858 Views
    0
    Reply
    psrams10
    psrams10 Helper I
    Helper I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎10-30-2022 09:56 AM

    Nice work. I love it. Is it possible to share this pbix file with me? thank you! 

    Message 10 of 94
    6,759 Views
    0
    Reply
    bebygones
    bebygones
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎10-27-2022 06:54 PM

    Thanks for sharing, is it possible to have a copy of this dashboard please?

    Message 9 of 94
    6,653 Views
    0
    Reply
    tom480
    tom480 Resolver I
    Resolver I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎10-26-2022 03:33 PM

    Nice!  Wow!  I love it!

    Message 8 of 94
    6,761 Views
    0
    Reply
    maxkaoppp
    maxkaoppp Helper II
    Helper II
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎10-17-2022 11:27 PM

    Hi there, great dashboard, this is exactly what I need to do. Could you please share the pbi file as I would like to learn the DAX behind? 

     

    Much appreciated!!

    Message 7 of 94
    6,832 Views
    0
    Reply
    Carol_W
    Carol_W
    Regular Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎10-15-2022 03:38 AM

    Hi there, great dashboard, this is exactly what I need to do. Could you please share the pbi file as I would like to learn the DAX behind? 

     

    Much appreciated!!

    Message 6 of 94
    6,845 Views
    0
    Reply
    dd77
    dd77
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎09-28-2022 04:57 PM

    Fantastic could you plz share this pbix file with me? thank you! 

    Message 5 of 94
    7,264 Views
    0
    Reply
    dabotsi
    dabotsi
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎09-27-2022 10:26 AM

    Hello cool dashboard but am new to PowerBi.

    kindly share the PBix file  

    Thank you.

    Message 4 of 94
    6,796 Views
    0
    Reply
    thebestcassie
    thebestcassie Advocate II
    Advocate II
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-04-2022 10:09 AM

    Hello!
    Great design

    Message 3 of 94
    44,301 Views
    0
    Reply
    GhaziSalahuddin
    GhaziSalahuddin
    Regular Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-22-2022 10:59 AM

    The dashboard is really nice. Can I have the dataset please?

    Message 2 of 94
    45,307 Views
    0
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2023 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    Consumer Privacy Act (CCPA) Opt-Out Icon Your Privacy Choices