Accounting interface with DATEV

With the interface to financial accounting, you have the option of assigning the sales from the postings of your POS system to posting accounts. The sales can then be exported via these accounts. The export is divided into two areas, the DATEV export and the financial accounting export.

Several steps in different programmes and modules are necessary for the correct output of the data:

  • Filling in the Financial Data and General Ledger & Salary registers in the Master Information module.
  • Assignment of financial accounts for payment methods in the program Financial accounts for payment methods.
  • Assignment of accounts to commodity groups in the program commodity groups.
  • Optionally, you can set up account assignments for each point ofsale.
  • Settings for Export in the Report Manager on the Financial Accounting Interfacetab .

As soon as you have made these settings, you can carry out the FNA export directly in the Report Manager. You will be rewarded with a perfect account assignment and presentation of the business situation. The information is made available to the subsequent accounting programmes in an export file.

As the account assignment is made based on the current situation at the time of export (and not at the time the turnover is generated), you can change the settings and assignments for the postings made at any time and repeat the export.

The product group assignment itself - i.e. the linking of the articles to the product groups and therefore also to the accounts - is saved with the articles at the time of posting. However, if you want to use the current product group assignment for the export, you can specify this during the export.

Requirements

The interface to financial accounting requires an existing Report Manager, Hypersoft UX Quick or Full Service or Back Office licence.

Extension for DATEV Export...

If you purchase the interface to DATEV, the corresponding report will be added to the free UX reports or an existing Backoffice Suite licence.

Financial Accounting Export Functions

The functions of financial accounting export are described in the following chapters. Some important functions in tabular list:

Functions of Financial Accounting Export

status

Accounting Invoice number in document field 1 yes
General export format yes
Consider cashless payments yes
Remove cashless payments completely or selectively yes
Document field 1 Control (invoices) yes
Reporting in PDF format yes
Deposit BU key also for incoming and outgoing payments yes
File name control during export yes
DATEV connection yes
DATEV export with cost center yes
DATEV export with BU key yes
Incoming and outgoing payments (optionally grouped, separated) yes
Incoming and outgoing payments with deviating account assignments yes
ETL-ADHOGA connection (and chart of accounts) yes
External sales yes
filosof connection yes
Voucher sale detailed yes
Voucher sale with alternative account assignment yes
Control vouchers Document field 1 yes
Account assignment by event yes
Account assignment by price level yes
Account assignment deviating according to shifts yes
Account assignment according to channels yes
Account assignment according to stations yes
Account assignment according to locations yes
Account assignment according to points of sale yes
Account assignment according to material groups yes
Account assignment by payment type yes
Apply customer subsidies retrospectively yes
Mail system (automatic) yes
myCOCKPIT connection yes
Sage Connection yes
SAP HR connection yes
Sortable export yes
Total accounts (optional) yes
tips yes

Notes on the required expertise

  • The user's accounting knowledge is required for the correct allocation of posting accounts and the successful use of this function.

  • When automatically exporting the current month, opening days that have not been completed are not taken into account. Therefore, make sure that all opening days of the desired month are completed correctly.

Reports for the Fibu Export

DATEV Report

DATEV report with cost centres

DATEV Report Deposits Disbursements

Sales export with alpha accounts

Evaluations for account assignment and export...

If you have the licence UX/IF Financial Accounting Account Assignment & Export, a DATEV report is automatically added to theReport Manager free UX reports.

Note external turnover mixed

As it is possible to mix external turnover with normal turnover, this can lead to differences depending on the option switch in the DATEV report. If this is the case, a note appears at the end of the DATEV reports if the external turnover is not to be taken into account in DATEV: Attention external turnover mixed:xxx" xxx=Total

This topic concerns project work that is subject to planning.

The Hypersoft // system is a standard programme that can be used in many different configurations. The correct application of the topics described here requires expert knowledge and an alignment of expectations, and not all Hypersoft employees and partners are equally trained in all of the topics labelled in this way. For this reason, we characterise these topics as project work requiring planning, so that you can contact your Hypersoft sales partner or Hypersoft Support in good time with this necessary planning. This approach ensures that we record your requirements carefully and respond to them in a targeted manner.


Licensing is described in the Licence for UX/IF Financial Accounting Account Assignment & Export section.


Further documentation:

Item analysis report

Assign accounts to points of sale

Assign accounts for payment methods

Assign accounts for merchandise categories

The DATEV Booking Export

DATEV export with cost centers

The general Fibu interface

DATEV Integration Questions & Answers FAQ

Back to the parent page: Integrations and Interfaces