MKG logo
Login

How does the 'Sales Analysis Financial' dashboard work?

Quickly gain insight into sales results? The standard 'Sales Analysis Financial' dashboard provides insight into the financial results of sales activities. You use it to analyze revenue, cost price, margin, and added value and break these down by debtor, sales group, financial mutations, and general ledger data.

 

General Function

The Sales Analysis Financial dashboard provides an analysis of the sales bookings for the selected periods from the registered fiscal year based on the financial mutations.

 

Note!
You use this dashboard with a financial setup Basic+ or Customer-specific. Revenue is then booked via an intermediary account. This dashboard provides connections to the sub-administrations 'Revenue', 'Terms', 'Pre-invoiced (intermediary account)', and 'Cost Price'. If you have a Basic setup, use the standard dashboard Invoice Margins. No connection with sub-administrations can be found in that report. More about the financial setup of MKG read here.

 

 

Target Audience

  • Controllers
  • Salespeople

 

Where in MKG?

  1. Open the module My Company.
  2. If the dashboard is not displayed directly: click on the hamburger
    in the top right of the button bar and select the option 'Forms' » 'Dashboard'.
  3. Click on the Views button
    and select Sales Analysis Financial (8014).

 

Main Components

  • Analysis of revenue, cost price, margin, and added value.
  • Top 10 debtors based on revenue.
  • Overview of sales groups, debtors, and debtor groups.
  • Analysis of transaction types and transaction subtypes.
  • Overviews for Balance, Profit & Loss, Sales, and Invoices.
  • Insight into financial transactions per general ledger account.

 

Display and Use

At the top, the fiscal year and selected periods are displayed. Additionally, you can filter by recorded status, sales group, and debtor. The dashboard consists of multiple tabs that allow financial data to be viewed from different perspectives. In addition to tables, the dashboard includes a graphical analysis of the main debtors, including revenue, cost price, margin, and added value.

 

Parameters

  • PeriodFrom: start period of the analysis. Default value: 1.
  • PeriodTo: end period of the analysis. Default value: 12.

 


 

Technical Explanation

 

Primary Data Source

  • Financial mutations (fmut)

Indirectly Consulted Data Sources

  • General ledger accounts (grbk), Sales invoices (fcth), Sales invoice lines (fctr), Debtors (debi), Debtor groups (degr), Sales groups (vrkg), Sales orders (vorh), Sales order lines (vorr), Fiscal years (adbj), Periods (peri), Batches (part), Items (arti)

Data Source Filtering

  • The primary data source is filtered by periods via peri_num >= ?PeriodFrom and peri_num <= ?PeriodTo.
  • Only financial mutations with types 2, 3, 4, 10, and 14 are included.
  • Dashboard filters are available for recorded status, sales group, and debtor.
  • The Top 10 debtor chart shows only the 10 debtors with the highest revenue and groups other debtors into a residual category.

Calculated Fields

  • Mutation subtype: shows the description of the transaction subtype.
    Calculation: uses _desc_fmut_subtype.
  • Mutation type: shows the description of the transaction type.
    Calculation: uses _desc_fmut_type.
  • Included: indicates whether a mutation is included.
    Calculation: translates fmut_opgenomen to "Included" or "Not included".
  • Process: classifies the transaction by process.
    Calculation: determines based on fmut_type whether it concerns "Sales", "Purchase", "Production", "Revaluation", or "Other financial".
  • Ledger type: determines the type of general ledger account.
    Calculation: uses grbk_num.grbk_soort and shows "Balance" or "P&L".
  • Item/Batch: shows item or batch.
    Calculation: uses part_num when present, otherwise arti_code.
  • Cost price material: determines the material part of the cost price.
    Calculation: uses fmut_bedrag_fin when fmut_subtype = 47.
  • Cost price man: determines the man-hour part of the cost price.
    Calculation: uses fmut_bedrag_fin when fmut_subtype = 48.
  • Cost price machine: determines the machine part of the cost price.
    Calculation: uses fmut_bedrag_fin when fmut_subtype = 49.
  • Cost price outsourcing: determines the outsourcing part of the cost price.
    Calculation: uses fmut_bedrag_fin when fmut_subtype = 50.
  • Revenue: determines the revenue.
    Calculation: uses fmut_bedrag_fin with reversed sign when fmut_subtype = 2.
  • Cost price total: calculates the total cost price.
    Calculation: adds Cost price material, Cost price man, Cost price machine, and Cost price outsourcing.
  • Margin: calculates the margin.
    Calculation: subtracts Cost price total from Revenue.
  • Added value: calculates the added value.
    Calculation: subtracts Cost price material and Cost price outsourcing from Revenue.
  • Added value %: calculates the percentage of added value.
    Calculation: divides the sum of Added value by the sum of Revenue.
  • Margin %: calculates the margin percentage.
    Calculation: divides the sum of Margin by the sum of Revenue.
  • Debtor: shows the debtor including debtor number.
    Calculation: combines fcth_num.debi_num.debi_naam with fcth_num.debi_num.
  • Sales group description: shows the description of the sales group.
    Calculation: uses vrkg_num.vrkg_oms or a default value when no sales group is present.
  • Debtor group description: shows the description of the debtor group.
    Calculation: uses fcth_num.debi_num.degr_num.degr_oms or a default value when no debtor group is present.
  • Sales group: shows the sales group including code.
    Calculation: combines vrkg_num.vrkg_oms and vrkg_num.

 

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 you can read in How to set up 'My Dashboards'