GDPdU Export

Note
The functionality is dedicated to the German market – it can be used if dedicated VAT rates are used within the company to which the user is logged in (i.e. if the DE value has been selected on the company form, in the field VAT Rate Group).

According to German regulations, during a tax audit, companies are obliged to provide tax-relevant data in electronic form upon request. The requirements that the provided data must meet are included in the document “Principles on Data Access and Verifiability of Digital Documents” (Grundsätze zum Datenzugriff und zur Prüfbarkeit digitaler Unterlagen”, or GDPdU). The tax administration does not determine the particular fields and specifications of the provided data, because, depending on the computer system, structure, and size of the company, different data may be tax-relevant.

System data considered by the software manufacturer as tax-relevant may be exported in the menu [Main] → [Export GDPdU] if the Export GDPdU parameter has been activated on the company form, in the Accounting section.

Export GDPdU parameter on company form

GDPdU Export window

After selecting the [Export GDPdU] button, a window will open, in which it is necessary to enter the following details:

  • The range of data to be exported
  • The period for which the data will be exported – required if data from the Accounting section has been selected. The date indicated cannot be earlier than 01.01.1900 and later than 31.12.2079.
  • The location where the exported files will be saved

Note
Data is exported for the center from which the export is performed.

Range of exported data:

  • Customers/Vendors
    • Type – this parameter determines if data will be exported for all customers and vendors, customers only, or vendors only
    • Basic data – code, name, TIN, interest, accounting accounts, payment forms, etc. Bookkeeping accounts are exported for the period designated by the date range indicated.
    • Address details – street, number, city, zip code, etc.
    • Bank accounts – data concerning bank accounts assigned to particular customers/vendors
    • Address details of occasional customers/vendors – street, number, city, zip code, etc.
  • Accounting
    • Chart of accounts:
      • A chart of accounts for the accounting period designated by the date range entered. If the date range covers movere than one accounting period, data will be exported for the later period.
      • Account types
    • Statement of trial balance – the trial balance of particular bookkeeping accounts within the selected period
    • Journal entries
      • Data on journal entries for the selected period: number in general ledger, posting date, amount, etc.
      • Data on company structure centers and subsidiaries
      • Information on the possible states of a given document type
      • Data on ledgers for the selected period
    • Open payments
      • Payment forms
      • Payments whose due dates fall within the date range entered and are open at the time of export (document number, reference number, entity code, currency, amount to be paid, etc.)
    • Other
      • Terms – data on types of terms defined in the system
      • VAT rates – data on VAT rates defined in the system

After selecting the appropriate parameters, it is necessary to select the [Create] button to perform the export. The following files will be created in the selected location:

  • .csv files containing exported data
  • an index file describing the data structure
  • a fixed file gdpdu-01-09-2004.dtd

Note
If the user re-exports data to the same location, the files are overwritten.

The following table presents from which tables/procedures/views particular data is retrieved during the export:

Section Data Table/Procedure/View
Customers/Vendors Basic data

 

Dictionaries.CustomerInterestValues dbo.Dic_CustomerData

dbo.Dic_Customers SecDictionaries.Dic_PaymentForms

Address details Address.Addresses

Address.AddressData

Bank accounts Dictionaries.BankAccounts
Address details of occasional customers/vendors Address.Addresses

Address.AddressData

Accounting Chart of accounts SecAccountingStructure.Accounts AccountingStructure.AccountTypesTable
Statement of trial balance AccountingStructure.CalculateSAB
Journal entries AccountingDocuments.AccountingAdviceDocuments

AccountingDocuments.Decrees SecAccountingStructure.PartialJournals CompanyStructure.CompanyUnits

DT.States

Open payments BanksRegisters.vPaymentPlanEntities

SecDictionaries.Dic_PaymentForms

 

Other Terms Dictionaries.Terms
VAT rates Dic_VatRates

Example of exported data concerning the types of terms defined in the system

Example of exported data concerning payment forms

Example of exported data concerning journal entries




Polish national system of e-Invoices

General information

Note
The functionality is available in the Polish version of the database.

KSeF represents one of allowed forms of documenting transactions, along with paper invoices and electronic invoices, currently present in economic circulation.

Structured invoice is an invoice issued by taxpayers with the use of a data transmission system (KSeF), marked with an invoice identification number assigned in the system.

Receiving structured invoices with the use of KSeF requires invoice recipient’s acceptance. In case the recipient does not agree to receive documents in such form, the issuer is authorized to issue a structured invoice in the system, but its transfer should be performed in a way agreed with the recipient.

Changes to company configuration

On the company form, in Trade section, parameter Use KSeF was added. The parameter:

  • is presented on the form only if VAT Rate Group is set to PL
  • can be selected/deselected at any moment during the work with the system
  • by default, is deselected on newly created and converted databases

Company form

After checking the parameter, a control field allowing for indicating the start date of KSeF handling, is presented (by default, the current date is set) and additional tab KSeF is added to the company form and contains the following parameters:

  • Automatically download the uploaded invoice files as attachments
  • Download OAR as attachments
  • Multiple document export mode – with values: Interactive session (default option), batch file
  • Automatic KSeF verification prior to document confirmation
  • Authentication – this section is filled-in automatically when generating token on the basis of the properties of the certificate for which a given token is being generated. Depending on data inserted for the certificate, TIN number or NIN number. It is necessary to establish a correct communication with KSeF.

Tab KSeF on the company form

On the ribbon displayed in the KSeF tab, new button group KSeF was added and it contains the following buttons:

  • Generate Token – after clicking the button, a token for the authenticated entity is generated, also the value of the entity ID and the token are entered in dedicated fields in the KSeF tab
  • Delete Token – this button is active only if a token has already been generated.

On the company form, in Operators tab, there is Token Authentication in KSeF column. It is presented only if KSeF handling is activated (it cannot be edited in subordinated centers). If the operator executes an action related do KSeF handling that requires authentication and if on the company form, in Operators tab, in Assigned Operators, table, the parameter Token Authentication in KSeF is:

  • checked, authenticated data transferred to KSeF consists of: ID and token set for the company on the tab KSeF.
  • unchecked, it is necessary to open the window for certificate selection and transfer to KSeF the parameters of the selected certificate as authentication data.

In the tab, there is also parameter KSeF Work Environment with the following options:

  • Demo,
  • Development,

which allows specifying working mode of the KSeF component with selected environment. In case a token used for the communication with KSeF was already generated, before changing environment, first, it is necessary to delete that token.

Note
Demo mode is available only until no document is sent to KSeF in development mode.

Changes to document definitions

In the definitions of the following documents:

  • Sales invoice (SI)
  • Sales invoice quantity correction (SIQC)
  • Sales Invoice Value Correction (SIVC)
  • Sales Invoice VAT Correction (SITC)
  • Advance Sales Invoice (ASI)
  • Advance Sales Invoice Value Correction (ASIVC)

parameter Automatically upload to KSeF is available (checked, by default). It is presented only if the option of KSeF handling is activated in the company configuration.

Note
All operations related to handling require possession of KSeF license.

 Authorizations on operator group

On the operator group form (Configuration → Operator Groups), in Other Permissions tab, the following elements are available:

  • Upload invoices to KSeF
  • Download invoices from KSeF
  • Edit KSeF number in a confirmed document
  • Print invoices not uploaded to KSeF

These permissions are unchecked, by default.

 Changes to customer/vendor form

On customer/vendor form, parameter Collect invoices via KSeF, is available and it is presented, if:

  • the function of KSeF handling is activated on the company form
  • customer/vendor type: National
  • customer/vendor status: Entity

Customer form header

if the parameter is checked by the operator, the system can automatically uncheck in case of changing:

  • the type of customer/vendor to EU or Non-EU
  • customer/vendor status to retail customer

Changes regarding KSeF to the list of documents of sales invoices, their corrections and advance invoices

On the ribbon above the list of sales invoices, KSeF group of buttons is available and it contains the following buttons:

  • Export
  • Download OAR
  • Check Correctness

Note
The buttons are visible only if the currently logged-in user has license for handling KSeF.

KSeF button group

On the list of sales invoices and purchase invoices, additional columns (hidden by default) are available, which optimize the work with KSeF:

  • KSeF Number – presents the number from the control field of the analogical field on the invoice form
  • KSeF Source Invoice No. – presents KSeF number of the source invoice to which the correction is issued
  • KSeF Issue Date – (unavailable on the PI list)

 Changes regarding KSeF to document forms

Note
Parameters described below are displayed only if in the company configuration, the parameter Use KSeF is activated.

In the header of the documents: sales invoice, its corrections (SIQC, SIVC, STIC), advance sales invoice and its corrections, the following fields are available:

  • KSeF number
  • KSeF status – the value of the field is displayed depending on the status of the communication with KSeF (Uploaded, Not Uploaded, OAR Downloaded, Rejected)

In case of purchase invoice, advance purchase invoice and their corrections, on document forms only KSeF Number field is presented. 

Changes regarding KSeF to accounting documents

On accounting documents, the following elements are available:

  • columns: KSeF Number and KSeF Source Invoice No. on the list of VAT accounts
  • fields: KSeF Number and KSeF Status on the form of VAT sales/purchase invoice and their corrections – values of the fields are transferred, by default, from the source document.

In the case of VAT invoices/corrections added manually to the account, the value of the parameter KSeF Status can be set to:

  • Not Uploaded (default value)
  • Uploaded
  • OAR Downloaded 

Changes to generic directories

In generic directory Attachment Types, system value with the following parameters is available:

  • Value: KSeF file
  • Description: Xml file (*.xml)|*.xml
  • Active: Yes
  • Default: No
  • Compression: Yes
  • Write: File in database
  • Size limit (bytes) No limits 

Verification of invoice correctness in terms of KSeF file structure

Note
The operator does not have to be authorized to upload documents to KSeF to be able to verify the correctness of invoices.
The verification regards all sales documents uploaded to KSeF: SI, SIQC, SIVC, ASI and ASIVC. [/alert]

Manual verification is activated after clicking on the [Check Correctness] button, available from the level of invoice form. Automatic verification is executed during the attempt of confirming a document from the level of details or of the list, if on the company form, the Automatic KSeF verification prior to document confirmation parameter is checked.

Regardless of selected verification method, if the attempt is:

  • successful, in the information bar information KSeF verification: positive
  • failed, in the information bar, information KSeF verification: negative is presented and returned error/errors are presented in the details 

Exporting documents to KSeF

Exporting individual source documents to KSeF (SI and ASI)

Documents can be exported manually or automatically. For the manual export, the button is available, if:

  • the currently logged-in user is authorized to export documents to KSeF
  • document has Confirmed or Printed for SI and ASI and Confirmed for SIQC, SIVC, SITC, ASIVC.
  • KSeF status of the document has value Not Upload or Rejected
  • the issue date of the document is equal or later than the date set in the company configuration of the parameter Use KSeF from

Note
Only documents issued in the company to which the center of the currently logged-in operator belongs, can be exported.

If checked, when confirming  a document, the system verifies the saving of the document operations history:

  • after correct verification of a document, the document is confirmed and then sent to KSeF
  • If document verification is failed, the document will remain unconfirmed and will not be sent to KSeF.

Exporting single corrections to KSeF (SIQC, SIVC, SIVC, ASIVC)

  • the currently logged-in user is authorized to export documents to KSeF
  • its status is Confirmed
  • source document that has to be corrected was sent to KSeF
  • KSeF status of the document has value Not Upload or Rejected
  • the issue date of the document is equal or later than the date set in the company configuration of the parameter Use KSeF from

Note
It is not possible to send to KSeF automatic corrections whose source documents was not previously exported to KSeF and manual corrections.

Exporting many documents to KSeF

Depending on the setting of the parameter Multiple document export mode, which is available on the company form, export of many documents can be performed in one of the following modes:

  • interactive session
  • batch file

After selecting on the list of invoices more than one element and clicking on the [Export] button, the system verifies whether the operator is authorized to export the document to KSeF. IF the operator has authorization assigned, then, depending on the settings of the parameter, the interactive section is checked or export in batch file is activated. If the authorization is not assigned, the system blocks the operation.

Among documents selected by the user, the following documents are ignored:

  • documents with status: Initiated, Unconfirmed and Canceled
  • with KSeF status different than Not-Uploaded or Rejected
  • with the issue date earlier than the date set in the company configuration of the parameter Use KSeF from
  • that have already been printed
  • that are not compliant with the structured invoice scheme

Additionally, it is also possible to export many documents for a given period – after selecting [Export For Period] button and verifying operator’s authorizations, additional window, in which it is necessary to fill-in export details, is presented:

  • Field Day/Range of Dates – allows for specifying dates of exported documents

Note
It is not possible to select a date earlier than the date set in the company configuration for the parameter Use KSeF from.

  • Field Owner – allows for exporting document issued in a selected center
  • Button [Export] and [Cancel] – the mechanism of export verification is analogical to the mechanism activated by the [Export] button

Export window

 Printing sales invoices sent to KSeF

Hint
To ensure correct handling of uploading printed documents to KSEF, it is recommended to turn on increasing history on sales invoice, advance sales invoices and on the corrections of these documents.

An invoice sent uploaded to KSeF can be sent to the recipient also as a printout, e-mail or e-Invoice. Since uploading to KSeF an invoice that was previously delivered to the recipient is considered as issuing subsequent (new) invoice, the functionality that blocks the possibility of exporting previously printed or sent via e-mail invoices to KSeF, has been introduced.

In case in the company configuration, the option of handling KSeF is activated, then, when trying to print a document, the system verifies whether:

  • the document issue date is earlier than the date set in the company configuration for the parameter Use KSeF from, then, regardless of the setting of the parameter Collect invoices via KSeF, on the customer form, the document is print without checking subsequent conditions
  • the document issue date is equal or later than the date set in the company configuration for the parameter and the parameter Handle KSeF is unchecked, then it is necessary to verify document KSeF number:
    • If it is assigned – printing is started
    • IF there is no KSeF number assigned, it is necessary to check whether the operator is authorized to print invoices not uploaded to KSeF – if such authorizations are assigned, a window with a dedicated message and buttons [Print] and [Cancel] are displayed 
  • the document issue date is equal or later than the date set in the company configuration for the parameter and the parameter Handle KSeF is checked, then it is necessary to verify document KSeF number: If there is no KSeF number, the error is presented. 

Importing purchase invoices from KSeF

On the ribbon, above the list, KSeF button group was added along with the following buttons:

  • Import
  • Import for Period

Upon selecting each button, the system verifies whether the operator is authorized to import documents from KSeF – if is not authorized, an appropriate message blocking the operation is displayed.

If the button [Import for Period] is selected, additional window allowing for specifying import details, is displayed:

  • Invoices By Date with options: Invoices uploaded to KSeF, Invoices received in KSeF
  • Start date and end date control field (current dates, by default)
  • Import and Cancel buttons

Structured invoices are imported as attachments On the basis of the attachment file preview, the user can add such document manually to the system, from the level of the list of purchase invoices or VAT accounts. 

Retrieving OAR

[Download OAR] button is available on the invoice form, if the KSeF status of the document has value Uploaded. After clicking on the button, in case of response, KSeF sends:

  • OAR, then:
    • document KSeF status is OAR Downloaded
    • KSeF Number on the document is filled-in
    • if in the company configuration parameter Download OAR as attachments is checked, then xml file with attached OAR is added. In document changes history, operation KSeF AOR Download is saved with the document upload date.
  • information that the session is being initiated or processed, then:
    • document KSeF status is not updated
    • in document changes history, operation KSeF AOR Download is saved with the processing stage description
  • error, then:
    • document KSeF status is changed to Rejected
    • In document changes history, operation KSeF AOR Download is saved with the error description

Note
The [Download OAR] button is active from the level of the list of sales invoices only, if one document is selected on the list.

Synchronization of KSeF parameters from Comarch POS / Comarch Mobile

When performing the synchronization to Comarch POS and to Comarch Mobile, the following value is sent:

  • of the parameter Use KSeF from the company configuration along with its activation date
  • value of the parameter Collect invoices via KSeF from the customer form
  • value of the KSeF Number field of synchronized sales invoices and their corrections

When importing data, the value of Collect invoices via KSeF parameter, from the customer form, is sent.