The content pack contains 14 dashboards on account payables, receivables, inventory, revenue and expense overview. These Power BI Dashboards feature real time, interactive, Q & A drill-through capability. These are plug-and-play reports which take just few days to implement and integrate with any of your ERP solution. They also provide BI Dashboards, KPI’s and reports for:
1. Account receivables
Provides data of outstanding debtors based on various slicers for Business unit, Organization unit, as on date etc. Shows the trend analysis of Days sales outstanding for the current and previous financial year. Shows aging details for outstanding receivables.2. Account payables
Provides data of outstanding vendors based on various slicers for Business unit, Organization unit, as on date etc. Shows the trend analysis of Days purchase outstanding for the current and previous financial year. Shows aging details for outstanding payables.
3. Inventory overview
Provides inventory details w.r.t location, inventory posting group and business unit along with slicers for organizational unit, business unit, fiscal year.4. Inventory aging
Provides data for aged inventory, trend analysis for Days inventory outstanding, trend analysis for monthly movement of inventory for current and previous financial year.5. Turnover ratio
Trend analysis for Days inventory outstanding, days sales outstanding and days purchase outstanding for any two consecutive years.6. Revenue sales
Graphs showing sales revenue by its nature, business unit and monthly revenue trend for 3 consecutive years.7. Revenue
Graphs showing top 10 customer wise revenue, top 10 salesperson wise revenue and top 10 product wise revenue.8. Income overview
Lists customers with their current year and previous year revenue, with monthly comparison of the same.9. Revenue – Actual vs Budget
Shows actual and budget revenue details for each revenue group and business unit
10. Expenses overview
11. Expenses – Actual vs Budget
Shows actual and budget expense details for each expense group and business unit
12. Bank-wise fund
Shows overview of bank balance
Shows summary of all the previous reports. Some of the key details include COGS, Gross margin, Total commission, Service and other income, Total operating income, Total operating expenses, EBIDTA.
The key data in each report helps create a beneficial dashboard for the management.