How does the 'Value Added Tax (VAT)' dashboard work?
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?
- Open the module My Company.
- 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'.
- 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: usesfmut_type2 or 14fcth_num.land_code.land_egand 9 or 15ifch_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: usesfmut_type2 or 14fcth_num.land_codeand 9 or 15ifch_num.land_code. Other types give an empty text.Main box: groups transactions by main category.
Calculation: determines based on the first character offmut_btw_rubriekwhether 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}’ whenParameters.Opgenomenis true; otherwise, ‘{All transactions}’.Type: distinguishes revenue and tax based on the category code.
Calculation: gives ‘{Revenue}’ whenfmut_btw_rubriekends 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 offmut_btw_rubriekwith 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 overParameters.PeriodeVan.VATPeriodTo: provides the end period for the period indication.
Calculation: takes overParameters.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'?
- Published:2 Nov 2026 15:33
- Latest update:2 Nov 2026 16:33
- TypeHandleidingen
- Category
- Product
- AvailabilityOpenbaar