MKG logo
Login

How does the 'Debtor Revenue Last 3 Years' dashboard work?

The standard dashboard 'Debtor Revenue Last 3 Years' provides insight into the revenue development of debtors over the past three fiscal years. You use it to analyze revenue trends, budget realization, and the relative contribution of debtors to the total revenue.

 

General Function

The Debtor Revenue Last 3 Years dashboard shows which debtor was responsible for the most revenue over the past 3 years. The top 5 debtors are displayed per year up to 3 years back. The second tab shows which debtors contribute the most to revenue in the current fiscal year.

 

Target Audience

  • Salespeople
  • Managers

 

Where in MKG?

  1. Open the My Company module.
  2. If the dashboard is not displayed directly: click the hamburger
    in the top right of the toolbar and select the option 'Forms' » 'Dashboard'.
  3. Click the Views
    button and select Debtor Revenue Last 3 Years (8016).

 

Main Components

  • Detailed analysis of revenue, budget, and debtor position.
  • Comparison of revenue over the current year and the 3 preceding years.
  • Top 5 debtor overviews per fiscal year.
  • Pareto or ABC analysis of debtor revenue.
  • Comparison between budget and realized revenue.

 

Display and Usage

The dashboard consists of 3 tabs. On the 'Detailed Analysis' tab, you see revenue figures, budgets, positions, and differences per debtor compared to previous years. On the 'Revenue Analysis' tab, revenue developments are displayed, including top 5 overviews per fiscal year. On the ABC analysis tab, revenue is divided according to the Pareto principle, making it visible which debtors have the largest share in revenue.

 


 

Technical Explanation

 

Primary Data Source

  • Debtors (debi)

Indirectly Consulted Data Sources

  • Debtor Budgets (debg), Sales Invoices (fcth), Sales Invoice Lines (fctr)

Dashboard Filters

  • The Pareto analysis uses the filter Debtor has revenue = 1, which only includes debtors with revenue.
  • The Top 5 overviews show only the debtors with the highest revenue within the respective fiscal year.

Calculated Fields

  • CurrentDay: determines the current day number within the calendar year.
    Calculation: calculates the day number of the current date.
  • BudgetCorr: calculates a time-proportional budget up to the current day.
    Calculation: multiplies t_debi_debg_total by CurrentDay and divides by 365.
  • CurrentDateTime; displays the date and time of the last data refresh.
    Calculation: combines fixed text with the value of MKGDataCreatedOn.
  • Total: calculates the total revenue over 4 years.
    Calculation: sums t_debi_fcth_amount, t_debi_fctr_amount_min1, t_debi_fctr_amount_min2, and t_debi_fctr_amount_min3.
  • Spacer: used as a separator in the display.
    Calculation: contains an empty text value.
  • Debtor has revenue: indicates whether a debtor has generated revenue.
    Calculation: returns value 1 when t_debi_fctr_amount is greater than 0, otherwise 0.
  • MKGDataCreatedOn: contains a date and time value for data refresh.
    Calculation: contains an empty text value.

 

Add to 'My Dashboards'

Do you use this dashboard regularly? Add it to My Dashboards and make this module available from the MKG Homepage. This way, you create your own cockpit from the data in your database. How to add dashboards can be read in How to set up 'My Dashboards'