OTTO DATEV integration: Prepare marketplace data reliably
An OTTO DATEV integration becomes important at the latest when a manageable marketplace business turns into many individual posting cases. Orders, invoices, credit notes, fees and payouts are not automatically available in the form that accounting needs.
Which files do retailers need to take over from OTTO, and how does the AccountOne Smart Import work? How marketplace data becomes reliable posting information is what you'll learn here.
What you'll learn here:
- OTTO accounting requires the order files from OTTO Market and the account statements from OTTO Payments. On this basis, the business transaction and the flow of money can be brought together.
- The Smart Import takes over the provided OTTO files without retailers having to edit the original reports manually beforehand.
- Invoices and credit notes remain traceable separately, so that corrections and different tax situations are also represented cleanly.
- Clear account assignments and tax setup ensure a reliable data basis.
- After the review, the prepared posting data is provided for DATEV via an export.
- In addition to OTTO Market, AccountOne also supports other marketplaces such as Amazon and eBay.
OTTO DATEV integration – Why good accounting begins with the source data
With OTTO, the completeness of the reports already determines whether the accounting will add up later. AccountOne matches transactions to the corresponding invoices and creates individual postings from them instead of lump-sum collective values.
It is important to provide the right files. A different file can lead to incomplete data. If the order file does not contain “Kundenbelege” in its name, credit notes may be missing, for example. For the OTTO DATEV integration, quality therefore by no means begins only in DATEV, but with the right marketplace report.
Between marketplace and accounting: Which data is really needed
AccountOne requires two data sources: the order data from the “Kundenbelege” and the account statements from OTTO Payments. OTTO provides them in different places – orders and finances initially remain separate.
This is exactly what makes the difference. Order and invoice data explain the business transaction, the data from payment processing the flow of money. Only when both sides are available can the OTTO integration relate invoices and payments to each other. For retailers, this means: What matters is not as many files as possible, but the right ones – complete and for the same period.
Anyone who only posts the transferred amount represents neither revenue nor deductions completely. This can be remedied by posting the tax-assessed orders and the individual transactions from the payouts separately. This is precisely the difference between a quick payment import and a reliable posting basis. This automatically saves time during the review.
From OTTO to posting basis
- Provide two data sources
- Order data from the Kundenbelege
- Account statements from OTTO Payments
- Connect invoices and payments
- Order data: business transaction
- Payment data: flow of money
- Complete, for the same period
- Post separately Reliable posting basis Tax-assessed ordersIndividual transactions from payouts
From download to Smart Import with the OTTO Market integration
Once the reports are complete, the actual import begins. AccountOne currently processes OTTO via the Smart Import, as there is not yet an API connection to the marketplace.
To do this, retailers first download the files from OTTO, open the Smart Import in AccountOne and upload the reports there.
The OTTO Market connection therefore requires no manual restructuring of the files whatsoever. After the upload, an automated processing step takes care of preparing the provided data.
The process is simple:
- Select files
- Start upload
- Check processing
Setting up OTTO accounting correctly: Keeping track of invoices, payments and credit notes
Not every document increases revenue. Invoices represent sales, credit notes correct transactions that have already occurred. For financial accounting, both must therefore be kept separate. Only then are invoice data and later corrections traceable.
The sales then pass through the AccountOne VAT assessment matrix.
AccountOne processes orders as individual postings and also splits different tax situations within one order.
This is particularly important with mixed tax rates: An order remains one business transaction. For tax purposes, however, it may contain several items. This creates a differentiated posting basis instead of a lump-sum collective posting.
More than 18 million online orders and the associated payments pass through our system - every month!
Over 6,000 online retailers & 2,000 tax consultants already trust AccountOne.
What customers say about AccountOne
All reviews on OMR Reviews-
“We want to support our clients, many of whom are online retailers and Amazon or eBay sellers, as individually as possible and still efficiently. AccountOne's time-saving solution for automatic accounting import via the DATEV integration is an indispensable working basis for our digital tax office.”
Diplom Betriebswirt (FH) Daniel Göllner Tax consultant, tax consultancy Daniel Göllner, Großschwabhausen -
★★★★★ on OMR Reviews
Absolutely business-critical in e-commerce
“The automated and tax-compliant preparation of complex marketplace data (Amazon, eBay etc.) takes an enormous amount of work off our hands. In particular, the correct handling of the OSS reports and the structured consolidation of the payout reports create maximum legal certainty.”
Björn Managing director, B+B Computer Trading GmbH
Understanding fees and payouts before payment reconciliation begins
With the account statements from OTTO Payments, it is not only payments that find their way into the system. The more transactions come together, the more important it becomes to reconcile the individual payment movements. For payment reconciliation, therefore, not only payouts but also the associated fees and individual movements must be completely available.
Via the Smart Import, AccountOne takes over the individual fee items and posts them to different expense accounts. Account assignment remains the task of the tax consultant.
OTTO DATEV integration in everyday use: Preparing accounts and posting information cleanly
After the import, the professional setup begins. AccountOne automatically creates new fee items under the expense accounts; for their allocation, the system provides sample account assignments for common charts of accounts. Especially for tax consultants with several clients, a uniform logic creates a reliable basis for further review. The template serves as guidance. Which accounts are actually used is the responsibility of the tax consultant.
New transaction types may also require their own account assignments. For VAT_CORRECTION and VAT_REFUND, for example, bank and contra accounts can be stored. This keeps the OTTO DATEV integration adaptable.
After the review: Transferring posting data securely to DATEV
Once the data has been reviewed, it is handed over to DATEV. In the Export Dashboard, the desired period of the export can be selected. If the DATEV Buchungsdatenservice is used for the transfer, the data must be finalized beforehand.
Before the import, it is also worth checking whether invoice data, payments and corrections are completely available for the same period. This way, the OTTO connection does not simply pass on files, but reviewed posting information with traceable origin.
Tax firm and company: How the OTTO DATEV integration stays reliable
Technology takes over a lot of work, but not every decision. The company provides the complete OTTO files and clarifies open business transactions. The tax firm reviews account assignment, tax settings and exports.
Who takes on which tasks?
- Company
- Provide complete OTTO files
- Clarify open business transactions
- Tax firm
- Review account assignment
- Review tax settings
- Review exports
- AccountOne Shared data basis For company and tax firmUniform processesClear reviews and queries
For this, AccountOne creates a shared data basis between company and tax firm. This becomes important above all when a tax consultant looks after several growing e-commerce clients. Uniform processes help to keep reviews and queries manageable.
OTTO Market is only one part of e-commerce. Anyone who also sells on other marketplaces does not have to build a new solution for each channel. In addition to OTTO Market, AccountOne also supports platforms such as Amazon, eBay and Kaufland with the automated preparation of accounting data.
Frequently asked
Which files are needed from OTTO?
Two data sources: the order files from OTTO Market and the account statements from OTTO Payments. The order file should contain “Kundenbelege” in its name – otherwise credit notes may be missing, for example. It is important that both files are complete and cover the same period.
Is there an API connection to OTTO?
Not yet. AccountOne currently processes OTTO via the Smart Import, as there is not yet an API connection to the marketplace.
How does the Smart Import work?
Retailers download the files from OTTO, open the Smart Import in AccountOne and upload the reports there:
- Select files
- Start upload
- Check processing
The original reports do not need to be edited manually for this. The steps in detail: OTTO Market guide.
What happens to credit notes and mixed tax rates?
Invoices and credit notes remain traceable separately. The sales pass through the AccountOne VAT assessment matrix and are processed as individual postings. Different tax situations within one order are split in the process.
How are OTTO fees posted?
AccountOne takes over the individual fee items from the OTTO Payments account statements and posts them to different expense accounts. AccountOne creates new fee items automatically. For the allocation there are sample account assignments; which accounts are actually used is the responsibility of the tax consultant.
What about VAT_CORRECTION and VAT_REFUND?
For these transaction types, separate bank and contra accounts can be stored.
How does the OTTO data get to DATEV?
After the review, the desired period can be selected in the Export Dashboard and the export for DATEV downloaded. If the DATEV Buchungsdatenservice is used, the data must be finalized beforehand.
Can the OTTO DATEV integration be tested?
Yes, for 14 days free of charge and with full functionality – including 3 retroactive monthly exports, full access to the software and access to all support resources. The software can also be viewed in the live demo.
Test 14 days free of charge & in full
Including 3 retroactive monthly exports, full access to the software and access to all support resources (help desk, email & phone).
Questions first? Call us: +49 461 57 49 49 85