Skip to content

How can we help you?

Overview

Data Exchange

In this guide, you can briefly learn about the options for exporting data from your Xena fiscal.

In the menu select Setup > Import/Export Data > Data Exchange.

There are 3 different ways to extract data:

  • Data Export
  • SAF-T
  • Regnskab Basis

 

Data Export

Here you can export 4 different CSV files independently. Before exporting the files, you need to specify the period for which you want to extract.

Accounts: Contains the financial accounts with activity in the selected period.

Transactions: Contains financial transactions with both amounts and tax amounts per transaction. For each transaction, a link is provided to open the corresponding voucher in your fiscal.

Customer Transactions/Supplier Transactions: Contains partner transactions, both invoices/credit notes and payments.

Eksport af data til CSV filer i Xena

 

 

SAF-T

Here you can export accounting data for a selected period in SAF-T format. The format follows the requirements of the Danish and Norwegian authorities.

To be able to export the file, all financial accounts with activity in the selected period must have added an account number. You can also choose to add a SAF-T standard account number to all your financial accounts. If this is filled out, it will also be included in the file:

  1. Open the menu Ledger > Account overview > Account overview
  2. Expand all accounts (click the arrow next to the 'Account' heading)
  3. Click the edit icon at the top right
  4. For each account, enter SAF-T standard account number
  5. Do the same for both the Income Statement, Assets, and Liabilities 

Indtastning af SAF-T standard kontonummer i Xena

 

Also for all your VAT codes, you need to enter a SAF-T standard code:

  1. Open the menu Setup > Ledger Setup, select the tab Vats
  2. Click on the vat code to open it
  3. Enter the standard 'SAF-Tv at code' field 

Indtast standard momskode i Xena

 

 

Regnskab Basis

Here you can export financial data in the Danish standard format Regnskab Basis for a chosen fiscal year. The file is in CSV format, and its structure follows the requirements of the Danish authorities.

To be able to extract the file, all ledger accounts with an ending balance in the selected fiscal year must have added the Danish standard account number. Follow steps 1-5 in the 'SAF-T' section.

Link to the guide for the Danish standard chart of accounts

Udlæs regnskabsdata i formatet Regnskab Basis i Xena

Updated