Analyzing Late Payments with the Power BI Finance App for Business Central
UG Expert David Laster walks through how to leverage the Power BI reports for Dynamics 365 Business Central so users can identify and analyze late payments from customers.
Key Takeaways
- Reports: Financial reports for Business Central are Power BI reports that can be downloaded from the app source. They plug, play, and refresh using your data via customers and customer ledger entries. Once deployed, open the dashboard and navigate to the bottom of the report; the last report is the late payments receivables report. This dashboard hosts five KPIs that can benefit your business in various ways.
- The dashboard: The dashboard demonstrates that there are many ways to look at late payments, from dollars to averages to actuals. Other areas looked at include:
- The concentration of overdue payments: Who are they? Where are they?
- The trend line over time: Are we getting better? Are we getting worse? What caused those events to occur?
- The late payments: Who do we go after first? (Clearly, it would be the ones that are most overdue, the largest value, or the most risk.)
- Benefits and outcomes: When it’s time for the weekly team meeting or time to demonstrate improvement over time, the late payment analysis by customer dashboard visually shows where things are or how they trend over time.
