BPM Country Reports

Standard Audit File-Tax (Data Export)

This section describes the fields and actions on the Standard Audit File-Tax (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 Denmark Standard Audit File-Tax (DSAFT) is a statutory requirement by the Danish Bookkeeping Act to make way for digital tax reporting and ensure compliance with the Danish Tax Agency (Skattestyrelsen) regulations and digital bookkeeping system. The DSAFT report comes in a standard chart of accounts structure (XML file format), and includes accounting transactions from the General Ledger, customer and supplier finance entries, and other necessary master data.

The Maconomy DSAFT report references the OECD Standard Audit File - Tax (SAF-T) version 2.0, and it is outlined as follows:

Master Files

  • GeneralLedgerAccounts
  • Customers
  • Suppliers
  • TaxTable
  • AnalysisTypeTable

The GeneralLedgerEntries for the DSAFT report includes the following information:

  • Journal Details
  • Transaction Details
  • Entry Details
  • Tax Information

For more information, visit the DBA website (in Danish):

https://erhvervsstyrelsen.dk/

Note: There is no filing date for the DSAFT report. It can be requested by Danish SKAT or the Danish Business Authority at any time.

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 » Standard Audit File-Tax (Data Export).

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. The tax number of the company. No
Include companies with the same tax no. Select this to include companies that use the same company tax number.
Year/Period Only include entries within the specified year-period range. Yes
Reporting Structure Only include entries for companies that use the specified reporting structure. Yes
Chart of Accounts Type Choose to only include Global or Local accounts. Yes
Show fiscal year-period in selection criteria Select to switch from selection criteria dates to fiscal year-periods in the <SelectionCriteria> field on exported the XML file. No

Dimensions

Field Description
Employee No.

Select the checkbox to include the dimension in the report.

Specifying a value in the Override Name field replaces the name Maconomy uses for this dimension.

No

Job

Select the checkbox to include the dimension in the report.

Specifying a value in the Override Name field replaces the name Maconomy uses for this dimension.

No

Location Name

Select this to include this dimension in the report.

Specifying a value in the Override Name field replaces the name Maconomy uses for this dimension.

No

Entity Name

Select the checkbox to include the dimension in the report.

Specifying a value in the Override Name field replaces the name Maconomy uses for this dimension.

Project Name

Select the checkbox to include the dimension in the report.

Specifying a value in the Override Name field replaces the name Maconomy uses for this dimension.

Purpose Name

Select the checkbox to include the dimension in the report.

Specifying a value in the Override Name field replaces the name Maconomy uses for this dimension.

No

Spec. 1 - 10

Use these fields to enter other specs as needed.

Select the checkbox to include the dimension in the report.

Specifying a value in the Override Name field replaces the name Maconomy uses for this dimension.

No

Local Spec. 1 - 10

Use these fields to enter other local specs as needed.

Select the checkbox to include the dimension in the report.

Specifying a value in the Override Name field replaces the name Maconomy uses for this dimension.

No

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 » Standard Audit File-Tax (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.
    • Select the Reporting Structure.

      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

The data export is based on the following universe(s):

  • Finance Universe
  • GL Audit
  • Tax Settlement
  • Bank
  • AR Aging
  • AP Aging
  • System

Export Fields and Descriptions

The system generates the xml file in the format:

DK_SAF-T_<company registration number>_<date/timestamp>.xml

Limitations

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.

Background Task Fails

On some Maconomy versions, the DSAFT report fails to generate successfully due to the background task failing when dimensions are included in the selection criteria. As a workaround, refrain from selecting Analysis Table Dimensions fields for the data export until this issue is resolved.

Currency Name and Mapping

On some Maconomy versions, the Standard Audit File-Tax report uses Currency Name (for example, Danish Krone) instead of Currency ISO (For example, DKK). As a workaround, you can set the currency name value to the same currency ISO value. The universe object path for Currency Name is as follows:

Finance\Company\Company General Information\Currency

Additionally, there is no mapping for fields on the company and bank information structure.

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:

Configure Sequence Numbers

To configure sequence numbers:

  1. Go to Reference Workspaces » General Ledger » Set-Up » Sequence Number Criteria.
  2. Enter or select the company to configure.
  3. In the Seq. No. Assignment card, complete the following fields using the following sequence number criteria to maintain the uniqueness of the <RecordID>:
    • Sequence Numbering = By Entry
    • New Sequence per
      • Period = unchecked
      • Transaction Type = unchecked
    • Length of Sequence No. - What you add here depends on the length of the company numbers. This affects the value of the combined sequence number, since the format is: <Year><Company No.><Sequence No.>. DSAFT requires that the total characters/digits for combined sequence number has a maximum of 18 characters, otherwise it is truncated.
  4. In the Seq. No. Accounts card, add a range of local accounts that will be assigned with sequence number.
    Note: You must add at least one line even if the row is empty.

Create a Reporting Structure

The reporting structure determines the format of account headers and subtotals of the report.

To create a reporting structure:

Part 1: Create Option List

  1. Go to Setup » System Setup » Option Lists.
  2. Click + New Option List to open the Create Option List dialog box.
  3. In the Option List No. field, enter Finance.

    (Optional) Provide a description for the option list.

  4. Click Create Option List.
  5. On the Options table, click the Add icon.
  6. In the Name and Description fields, enter how you want to identify and describe the option, for example:
    • Name — DSAFT
  7. Click Save.

Part 2: Create Reporting Structure

  1. Go to Reference Workspaces » Set-Up » Reporting » Reporting Structures.
  2. Click + New Reporting Structure to open the Create Reporting Structure dialog box.
  3. Provide a Name and Description, select a Type (or dimension), and input the following settings:
    • Option List — Finance
    • Selected Value — DSAFT
      Note: Select the values entered in the Create Option List section.
  4. Click Create Reporting Structure.
  5. (Optional) Insert group headers and subgroup headers to provide the desired account structure, and you can also include a small subset of accounts. The reporting structure works as a filter on accounts in addition to providing a hierarchical structure. Click Save.

Import Files (Optional)

Import Bank Account Numbers for Customers

The Bank Account No. field is an optional field from Maconomy that you can leave empty for the Danish SAFT report. This field is not visible in the standard layout in the Customers workspace. To use the Bank Account No. field, you must create an import file to fill the field with bank account numbers.

Note: The import file is only applicable in the Customers workspace.

To add bank account numbers:

  1. Create a tab-separated data file with customer information in the following format:
    Customer:Format CustomerNumber Name1 Country BankAccount
    Customer 10030 Statoil ASA Denmark 123456789
  2. In Maconomy, go to Reference Workspaces » Import » Customer » Import Customers.
  3. On the Import Customers tab, select the Internal Names, Progress Bar, and Logging check boxes.
  4. Click Import.
  5. Select the data file and click Ok.
  6. Go to Accounts Receivable » Customers workspace, click the Settings icon.
  7. In the Available columns field, select Bank Account. No. and move it to the Visible columns by clicking the Arrow icon.

    The values you imported (bank account numbers for customers) display in the table.

Import SWIFT Code for Customers and Vendors

SWIFT Code is not a visible field in the standard layout in the Customers and Vendors workspaces. You must use an import file to fill this field with bank account numbers.

To add SWIFT code:

  1. Create a tab-separated data file with SWIFT code information in this format:
    Customer:Format CustomerNumber Name1 Country SWIFTCode
    Customer 4470377113 Nice Home Ltd. United Kingdom 192020393
  2. Open the Customers or Vendors workspace:
    1. Go to Reference Workspaces » Import » Customer » Import Customers to import the SWIFT code values into the Customers workspace.
    2. Go to go to Reference Workspaces » Import » Vendor » Import Vendors to import SWIFT code into the Vendors workspace.
  3. Select the Internal Names, Progress Bar, and Logging check boxes.
  4. Click Import.
  5. Select the data file and click Ok.
  6. Customize the layout to display the SWIFT column and values in the Customers and Vendors workspaces:
    1. Go to Accounts Receivable » Customers workspace.
    2. Go to Accounts Payable » Vendors workspace.
  7. Click the Settings icon.
  8. In the Available columns field, select SWIFT and move it to the Visible columns by clicking the Arrow icon.

    The values you imported (SWIFT codes) display in the table.

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.
Note: If the page size is set to 100000 and the DSAFT fails to generate a report, the next threshold is 50000. Typically, the DSAFT triggers an error within the first 30 minutes if system resources cannot accommodate the page size configured.

External Setup

Not applicable for this report.