Skip to content
Illustration: Invoice stack, calculator and binders with a data hand-off

Accounting with JTL

Accounting

JTL-Wawi lets you match payments and prepare document data for financial accounting. This requires suitable export methods, traceable matching and a setup agreed with your tax adviser.

Key takeawayConnect inventory management and financial accounting

JTL-Wawi supports your business processes, while your financial accounting system handles the subsequent processing. Before setting up the connection, agree with your accounting team or tax adviser which data you need to transfer.

Incoming payments and bank reconciliation

With JTL-Wawi, you can use existing bank data to match incoming payments to the relevant business transactions rather than entering each payment individually. To do this, you import your bank's transaction data as a CSV file. The file must match the import configuration. Before setup, confirm which fields your bank exports and how your installed version of JTL-Wawi imports them.

Automatic matching helps you reconcile payments with outstanding orders and invoices. Whether JTL-Wawi can identify a payment unambiguously depends on the available information and the matching rules you have configured. Pay particular attention to incoming payments that have not been clearly matched to a business transaction. Automatic processing supports reconciliation without replacing the need to review unclear cases, and you can check its results.

  • Import bank transactions as CSV matching the import configuration
  • Automatic matching depends on available details and matching rules
  • Review incoming payments that could not be clearly matched

Open items, dunning and credit notes

Open item management shows you which customer receivables are still outstanding. This helps you track unpaid amounts and organise follow-up work. A three-stage dunning system is available for contacting customers. Before sending reminders, check the relevant receivables and their processing status: a dunning stage alone does not tell you whether an amount is still owed.

Credit notes and invoice corrections let you reverse orders in full or in part. If a correction affects only part of an order, you can use documents covering that portion; cancelling the entire order is not always necessary. The correction document must correspond to the original transaction and accurately reflect the portion being reversed. How you process the correction depends on the original document and the reason for the change.

Schematic illustration

From order to financial accounting

The document flow shows how sales, payment processing and the subsequent data transfer are connected.

  1. 01Order

    The order records the business transaction and provides the basis for further processing.

  2. 02Invoice

    The invoice documents the amount owed by your customer.

  3. 03Incoming payment

    You match the amount received to the relevant transaction.

  4. 04Open items

    You review remaining receivables and take further action where needed.

  5. 05Export to financial accounting

    You export the agreed document data and accounting entries for financial accounting.

Exporting booking data with JTL-Ameise

JTL-Ameise lets you adapt the export of your accounting entries to the requirements of the accounting system that will process them. You export CSV files in a format you define. Agree with the recipient in advance which fields are required and how the file should be structured. Reusable export settings can reduce repetitive work. A technically readable file is not enough, however: it must also contain the information needed for accounting purposes.

A configurable export period helps you provide data for the accounting period you need. Depending on your configuration, this can also include DATEV-format exports and a choice between accrual-based and cash-based VAT accounting. Check these options against your version of JTL-Ameise and your intended export method before building your workflow around them. The export selection must match the required tax treatment; it does not determine your tax basis on its own.

JTL2DATEV accounting interface

JTL2DATEV lets you transfer invoices and credit notes from JTL-Wawi to your tax adviser or their financial accounting system. The interface supports account mapping and individual DATEV customer account numbers. For deliveries to other EU countries and non-EU countries, such as Switzerland or the USA, you configure the appropriate revenue account mappings. Your tax adviser determines the chart of accounts. Also agree with them how to apply the rules for EU deliveries, which now include OSS, and Amazon's PAN-EU programme where relevant.

To help match and clear open items in the financial accounting system, JTL2DATEV adds the corresponding document numbers to accounting entries. The interface processes PayPal account statements and Amazon transaction summaries and reconciles their payments with JTL-Wawi. The added document numbers serve as references for further processing. Entries for PayPal and Amazon fees are also supported, provided the source data includes those fees.

Structured data transfers can reduce manual entry work in accounting. Cost centres can also be transferred, allowing the financial accounting system to produce reports based on them. Depending on your configuration and agreed scope, generating INTRASTAT declarations through the interface provides another way to reduce manual work. Generating these declarations does not replace a review by a qualified person or the need to establish whether your company has a reporting obligation and what that obligation covers.

  • Transfer invoices and credit notes from JTL-Wawi to financial accounting
  • Reconcile PayPal and Amazon payments and add document numbers
  • Transfer cost centres for analyses in financial accounting

Data storage and licence models

With a local installation, you store your business data in the JTL-Wawi database on your own computer or a server on your company network. This includes sensitive information such as purchase prices, sales figures and profitability reports. The storage location alone does not prevent unauthorised access or data loss. Protecting your data requires appropriate access permissions, maintained systems and backups that can be verified. In a hosted environment, the chosen hosting arrangement determines the actual storage location.

Details on which JTL2DATEV edition supports your number of client entities, along with current terms, are available on request. Solutions range from a basic transfer to a multi-client setup for DATEV. Which packages, licence models, pricing and contract terms apply is assessed individually for your project. When requesting a quote, we also help you clarify the included usage rights, updates and support services.

Terms explained

Customer account number
A customer account number identifies a customer in the financial accounting system and links receivables and accounting entries to that customer.
Account mapping
Account mapping assigns source data to the intended accounts in the destination accounting system.
Cost centre
A cost centre assigns business transactions to an area of operational responsibility or reporting.
OSS
The One-Stop-Shop is a scheme for centrally declaring and paying VAT on certain cross-border sales within the EU.
INTRASTAT
INTRASTAT is the statistical reporting system for trade in goods between EU member states, applicable to businesses with a reporting obligation.

Good to know: requirements & limits

  • The processes described require complete and correctly maintained master data and document data.
  • Before going live, check test exports in the intended destination accounting system.
  • Changes to bank, payment provider or destination formats may require adjustments to the setup.
  • WAWIHEROES supports the technical implementation but does not provide tax advice as part of this service.
  • Check the available bank import and payment reconciliation features and settings for your JTL-Wawi version and, where applicable, edition.
  • The availability and operation of the three-stage dunning system depend on the version in use. The terminology and workflows for credit notes and invoice corrections may also vary between JTL-Wawi versions.
  • The JTL2DATEV version in use must support the rules agreed with your accounting team or tax adviser for EU deliveries, including OSS and, where relevant, Amazon's PAN-EU programme.
  • Processing PayPal account statements and Amazon transaction summaries depends on the supported data format and interface version. Use your actual files and the current version to check whether all required transaction types are processed.
  • Transferring cost centres requires an interface version that supports this feature and is configured accordingly.
  • Before generating INTRASTAT declarations, check the current functionality, the required source data and the applicable reporting requirements.
  • For a hosted environment, clarify the actual data storage location separately.

Contact

Let’s discuss your project.

Free initial consultation on JTL-Wawi, JTL-Shop, JTL-WMS and hosting.