BPM Country Reports

VAT Return (Data Export)

This section describes the fields and actions on the VAT Return (Data Export) workspace, as well as instructions on how to generate the report.

Quick Links: Report Workspace | Selection Criteria | Generate Report | Data Export Fields | Limitations | Admin Setup | Appendix

Overview

The VAT Return report summarizes input and output VAT in compliance with the Danish Tax Authorities, Skattestyrelsen (SKAT). It generates an XML file that can be manually uploaded to the SKAT website. The report contains VAT-related data, such as VAT payable and deductible totals, VAT amounts on purchases of goods or services (domestic and abroad) and the cost of various energy taxes.

The generated report can be used as a reference to manually populate the fields needed to publish the report with the Danish government's tax portal. It can also serve as a display and validation for the integration and automatic submission of VAT returns.

Note: A formal VAT integration with Danish SKAT is planned for the next Maconomy release.

For more information, refer to the following website:

https://skat.dk/en-us/businesses/vat

VAT Return Form

You must include the following amounts in the VAT Return form upon submission to the Danish SKAT:

Field Description
Input and Output VAT
Box 9 Purchase Tax (Incoming Tax)
Box 14 Sales VAT (Outgoing VAT)
If doing business with companies located abroad
Box 11 VAT on purchases of goods abroad (both EU and non- EU)
Box 12 VAT on purchases of services abroad (construction services and hiring out of labour) (RCM)
Box A - Goods (Box 3) Value net of VAT of purchases of goods in other EU countries (EU acquisitions)
Box A - Services (Box 16) Value net of VAT of purchases of services in other EU countries
Box B - Goods (Box 4) To be reported to "EU sales excluding VAT". The value of sales of goods excluding VAT to other EU countries
Box B - Goods (Box 5) To be reported to "EU sales excluding VAT". The value of, for example, installation and assembly, distance selling and new means of transport to non-VAT registered customers without VAT to other EU countries
Box B - Services (Box 17) The value of certain sales of services excluding VAT to other EU countries. To be reported for EU sales without VAT (Box B)
Box C (Box 7) Value of other goods and services supplied free of tax in Denmark, in other EU countries and in countries outside the EU
Energy Taxes
VAT Declaration Oil Tax Amount
VAT Declaration Electricity Tax Amount
VAT Declaration Natural gas and city gas tax
VAT Declaration Coal Tax Amount
VAT Declaration CO2 Tax Amount
VAT Declaration Water Tax Amount
Total
Total VAT Deductions (Box 1) Sum of the incoming, outgoing tax and energy tax

For details on how Macaonomy populates the form, refer to the Appendix for the VAT Return field mappings.

Report Workspace

Country reports share the same workspace layout. For information on the fields and actions available in the report workspace, refer to Workspace Layout.

Navigation

To open the report workspace, select Reporting » Country Reports » Denmark » VAT Return (Data Export).

VAT Summary Tab

Click the Get VAT Data action button to populate the VAT Summary section.

Field Description
VAT Summary

Provides a summary of tax amounts for the following categories:

  • CO2 Tax Amount
  • Box A - Goods (EU Purchases)
  • Box B - Goods R (EU Sales Amt. Excl. VAT)
  • Box B - Goods NR (EU Sales Amt. Excl. VAT)
  • Electricity Tax Amount
  • Box C - Goods and Services (Other)
  • Natural Gas Tax Amount
  • Incoming VAT (Purchase VAT)
  • Coal Tax Amount
  • VAT on Goods Purchased Abroad
  • VAT on Services Purchased Abroad (RCM)
  • Outgoing VAT (Sales VAT)
  • Oil Tax Amount
  • Water Tax Amount
  • Box A - Services (EU Purchases)
  • Box B - Services R (EU Sales Amt. Excl. VAT)

The Total VAT sums all the tax amounts.

The values generated here are displayed in the output file.

Last Generated

Displays the date and time when the report was last generated.

Company No

Diplays the company included in the report.

Date Range

Displays the date range used of the last generated report.

Selection Criteria Dialog Box

Click the Generate Report action to open the selection criteria dialog box. This table describes the parameters you can define for the report.

Dialog Box Fields

Field Description Mandatory
Reporting Company

Use this field to search for or enter a company number.

Single valued.

Yes
Company Tax No. Only include entries for companies that use the specified company tax number. No
Include companies with the same tax no. Select this to include companies that use the same company tax number. No

Select by Entry Date

Field Description
Entry Date Only transactions with an entry date equal to or after the answer to this prompt, are included. No

Select by Period

Field Description
Year-Period

Only include entries within the specified year-period range.

Yes

Special Tax Rates

Field Description Mandatory
Include Reimbursable Energy Tax

Select this to include reimbursable energy purchases.

No

Tax Description

Displays a list of reimbursable energy, as follows:

  • Oil and Bottled Gas Tax
  • Electricity Tax
  • Natural and Town Gas Tax
  • Coal Tax
  • CO2 Tax
  • Water Tax
Tax Amount

Displays amount of purchase for corresponding reimbursable energy.

Selection Criteria Dialog Box Actions

Action Description
Next If applicable, click this for more prompts.
Back Click this to return to the previous prompts.
Cancel Click this to close the dialog box.
Ok Click this to generate the report.

If applicable, click Ok to close the dialog box.

Generate the Report

To generate the report:

  1. Go to Reporting » Country Reports » Denmark » VAT Return (Data Export).
  2. Click Generate Report to open the Selection Criteria dialog box.
  3. Fill in the mandatory fields for the report:
    • In the Reporting Company field, enter or search for the company you want to report on.
    • Specify the Year/Period duration to include in the report.

      If needed, enter other selection criteria (optional) for the report.

  4. Click Ok to start generating the report.
  5. A notification dialog box displays to let you know that the background task for the report has been created. Click Ok.
    Note: Deltek recommends that you generate reports one at a time to avoid overwriting data. Wait for Maconomy to finish generating one report then immediately retrieve the data export to ensure you are getting the correct information.

View Background Task

To view the associated background task for your report:

  1. Select the Background Tasks tab.
  2. Click the Refresh icon to update the Execution Status.

    While running the report, the Execution Status displays as "Pending". Once complete, it changes to "Succeeded ".

Download Report

To download the data export:

  1. Select the Statutory Report Retrieval tab.
  2. Select the row of the report you want to view, then choose one of the following methods:
    • Click the icon under the Download File to download a .zip package containing the report.

      Or

    • Click the Download icon located outside the table. In the dialog box, specify the parameters for the data export (file extension, file name and number of rows), then click Ok.

    The data export is downloaded to the default download folder on your device.

Submit the Report

Not applicable for this report.

Report Description

Universes

  • Tax Settlement Universe

Export Fields and Descriptions

The report is created as an XML file that you can use as reference when submitting VAT Return data to the Danish tax authorities.

Refer to the Appendix for the VAT Return Report field mappings.

Limitations

Integration Capability

Maconomy does not support integration for the VAT Return report. It does not have a validation function nor can it handle automatic submission to the Danish Tax Authority. You can use the data export as a reference document for tax submission.

Background Task Not Cancelled

In some cases where a Background Task is canceled, the report still attempts to generate and complete the data export. This can cause performance issues especially when run on a system with a large amount of data.

Admin Setup

Maconomy Setup

Note: You must have System Administrator rights to configure some of these settings, such as the Reference Workspaces.

To set up this report, do the following:

Tax Reporting Unit Setup

To handle transactions from different companies, Tax Reporting Unit setup is used as part of the Company setup. With this, the data export is capable of consolidating the transactions of every company under a specific Tax Reporting Unit.

To add a Tax Reporting Unit:

  1. Go to Reference Workspaces » General Ledger » Tax » Tax Reporting Units.
  2. Select New Tax Reporting Unit.
  3. Complete all necessary fields:
    • Name: Provide a name for the unit, for example, DK for Denmark.
    • Tax Date Method:
      • Entry Date: Use the registration date of entry.
      • Invoice Date: Use the date of customer/vendor invoice.
      • Payment Date: Use the customer/vendor payment date.
    • Tax Settlement by Tax Type: Select this to remove lines for which no tax type has been specified. A line is shown for each tax type, however only including tax types for which the Include on Printout field is marked in the Popup Fields workspace. Leave this blank so the tax settlement printouts show a line for each combination of tax settlement type, tax type, nature of tax, and tax type.
  4. Go to the Period card. In the Mth/Yr field, specify the date range for which settlements are included.
  5. Go to the Posting References card, and select a Settlement to determine the number of a dimension combination which contains the account number and any other dimensions that you wish to apply to the posting of amounts pertaining to tax settlement.

    If no value is specified for a dimension in the dimension combination, the value specified on the entry line which causes the posting is used.

  6. Go to the Access Level card. In the Access Level field, specify a description and name for an access level for the current tax reporting unit.
  7. Click Save.
Note:
  • It is ideal for the report to have the same Company Tax ID for all companies under the same Tax Reporting Unit. Companies with the same tax ID number normally belong to the same VAT group for reporting purposes. This means that all companies that share the same Tax ID number file a single, consolidated VAT report and entries appear in Tax Settlement for all companies. The report may not contain correct data if companies under a single Tax Reporting Unit have different Tax IDs.

    If you have noted the potential for error and wish to proceed, the Company Tax No. value that appears in the Selection Criteria card will be the value that appears in the file.

  • Be sure to remove extra spaces in the Company Tax No. field in the Company Information card

Assign Tax Reporting Unit to Company

To add companies to a tax reporting unit, you must assign them in the Company Information card.

  1. Go to Reference Workspaces » General Ledger » Set-up » Company Information.
  2. Select the company to include in the tax reporting unit.
  3. Go to the Tax Reporting Units card. In the Tax Reporting Unit Table field for the company, search for and select the tax reporting unit to use.
  4. Click Save.

Tax Settlement Setup

The tax settlement serves as the basis for the data export. Tax settlement entries should be set up, created and approved to be able to fetch data for the report. Typically, tax settlement is done every month to reset all tax accounts and transfer balances to tax reporting accounts.

To set up the tax settlement entries:

  1. Go to Reference Workspaces » General Ledger » Tax » Tax Settlement.
  2. Search for and select the tax settlement to process.
  3. Click Create Settlement.

Popup Field Setup

Tax Popup 1 is used to define whether an entry should be considered Goods, Services,or Goods and Services.

You can select Goods, Services, etc. for the popup via the Import workspace:

  1. Create a tab-separated data file with customer information in the following format:
    PopupItem:Format PopupTypeName Name Boolean1 Boolean2 Boolean3
    PopupItem VATPopup1Type Goods 1 0 0
    PopupItem VATPopup1Type Services 0 0 0
    PopupItem VATPopup1Type Goods (ROW) 0 1 0
    PopupItem VATPopup1Type Services (ROW) 0 1 0
    PopupItem VATPopup1Type Goods and Services (ROW) 0 1 0
    PopupItem VATPopup1Type Goods and Services (DK) 0 0 1
  2. In Maconomy, go to Reference Workspaces » Import » Basics » Import Popup Fields.
  3. On the Import dialog, select the Internal Names, Internal Popup Names, Progress Bar, and Logging check boxes.
  4. Click Import.
  5. Select the data file and click Ok.

Use Entry Date or Year-Period

You can choose whether the report uses entry dates or tax settlement dates.

To set the date used by the report:

  1. In Maconomy, go to Setup » System Setup » System Parameters.
  2. Double-click the Use Entry/Period Dates for Statutory Reports parameter.
  3. Choose the preferred dates for the report:
    • Select Use Entry/Period Dates for Statutory Reports checkbox to use the Entry Date from the Selection Criteria.
    • Clear the Use Entry/Period Dates for Statutory Reports checkbox to use the Year-Period from the Selection Criteria.

Email Notification Setup

Configure Maconomy to send an email notification when it successfully generates a data export or encounters an error while running the report. The email specifies the report name, other information such as the report's format (if any), as well as the date and time the export is created. The alert is sent to the email address associated with the user who initiates the report. For reports with errors, the message points to the maconomy.log file for details.

To set up the email server and sender:

  1. Open the Extension.ini file. It is located in the <Path to Maconomy installation>\CouplingService\Configuration\Settings folder.
  2. Configure the email server and sender:
    • Locate mailserver.address and change the value to smtp.deltek.com:25.
      Note: The email server can also be set via the Web Client. Go to Setup » System Setup » System Parameters » Mail Port and Server workspace and use the Server and Mail Port parameters.
    • Locate email.from.default and provide an email address for the From field of the email.
  3. Save the file.
  4. Restart the Coupling Service to apply the changes.

Adjust the Pagination Size of Data

The pagination size can be adjusted depending on memory capacity. The default pagination size is 20000, and you can set this to your preferred value up to 100000.

To adjust the default pagination:

  1. Go to the Extension.ini file (<Path to Maconomy installation>\CouplingService\Configuration\Settings\extension.ini).
  2. Add the following line:

    filepath.annualcsvoffset = <Page size>

  3. Enter the preferred page size, within a range of 20000 to 100000.
  4. Save the file.
  5. Restart the Coupling Service to apply the changes.

External Setup

Not applicable for this report.