MKG logo
Login

How does the 'Value Added Tax (VAT)' dashboard work?

With the 'Value Added Tax (VAT)' dashboard, you can examine financial transactions per VAT category. You use the overview to verify amounts and the associated entries.

 

General Function

With the standard Value Added Tax (VAT) dashboard, you can quickly and easily analyze the VAT return. Based on the selected VAT period(s), the recorded transactions for each general ledger account are displayed.

 

Target Audience

  • Controllers
  • Financial employees

 

Where in MKG?

  1. Open the module My Company.
  2. If the dashboard is not displayed immediately: click on the hamburger icon in the top right of the button bar and select the option 'Forms' » 'Dashboard'.
  3. Click on the Views button and select Value Added Tax (VAT) (8008).

 

Main Components

  • VAT categories with financial amounts.
  • An overview per general ledger account and VAT description.
  • Transaction details with periods, invoices, country, EU indication, and financial amounts.
  • A period selection and a choice between recorded and all transactions.

 

Display and Usage

You choose the VAT periods you want to view. By default, periods 1 to 12 and only recorded transactions are selected. At the top, you see the VAT year, the period, and the transaction selection. You can select multiple categories or general ledger accounts to limit linked overviews. The category cards ignore selections from other components. The detail overview shows, among other things, the entry period and VAT period side by side.

 


 

Technical Explanation

 

Primary Data Source

  • company_fmut_btw_jaar

Indirectly Queried Data Sources

  • Sales invoices (fcth), Purchase invoices (ifch), and Country codes (land)

Selection and Interaction

The source filter limits fmut_btw_periode with PeriodeVan and PeriodeTot. The field fmut_opgenomen must be true or equal to the parameter Opgenomen. This parameter is set to true by default.

The category cards and general ledger table support multiple filter selections. The cards ignore selections from other components. The displayed VAT year uses the most common value of fmut_btw_jaar; a separate year filter was not found in the XML.

Calculated Fields

  • MKGDataDashboardTitle: provides an empty text value.
    Calculation: returns an empty string.
  • Invoice EU: indicates whether the invoice country is registered as an EU country.
    Calculation: uses fmut_type 2 or 14 fcth_num.land_code.land_eg and 9 or 15 ifch_num.land_code.land_eg. True gives ‘{Yes}’, false ‘{No}’; otherwise, the text remains empty.
  • Invoice country: provides the country of the relevant invoice.
    Calculation: uses fmut_type 2 or 14 fcth_num.land_code and 9 or 15 ifch_num.land_code. Other types give an empty text.
  • Main box: groups transactions by main category.
    Calculation: determines based on the first character of fmut_btw_rubriek whether the category concerns domestic performances, domestic shifts, performances to or from abroad, or pre-tax and final total. Other values give an empty text.
  • Included: describes the chosen transaction selection.
    Calculation: gives ‘{Recorded transactions}’ when Parameters.Opgenomen is true; otherwise, ‘{All transactions}’.
  • Type: distinguishes revenue and tax based on the category code.
    Calculation: gives ‘{Revenue}’ when fmut_btw_rubriek ends with 1 and ‘{Tax}’ when it ends with 2; otherwise, an empty text.
  • Sub box: provides the description of the VAT subcategory.
    Calculation: compares the beginning of fmut_btw_rubriek with the recorded subcategories and adds ‘{Revenue}’ or ‘{Sales tax}’ when the code ends respectively on 1 or 2.
  • VATPeriodFrom: provides the start period for the period indication.
    Calculation: takes over Parameters.PeriodeVan.
  • VATPeriodTo: provides the end period for the period indication.
    Calculation: takes over Parameters.PeriodeTot.

Point of Attention

In Sub box, the condition for category 5e is stated twice. The second condition has the description ‘5g Total payable’, but is not reached due to the earlier identical condition. No separate condition for 5g was found.

 

Add to 'My Dashboards'

Do you use this dashboard regularly? Add it to My Dashboards and make this module available from the MKG Start Page. 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'?