Shopify Bookkeeping & DATEV Export: The Workflow That Prevents Duplicate Postings

Your tax advisor asks for the DATEV file for last month. You open Shopify, export a CSV, and realize it contains neither posting accounts nor document numbers, just order numbers and gross totals. So the manual work begins: matching payouts from Shopify Payments, PayPal, and Klarna one by one, digging out fees, offsetting returns, and hoping the total matches your bank statement at the end.

That’s exactly where most Shopify bookkeeping setups break down. Not because of the accounting software itself, but because of the assumption that Shopify already delivers DATEV-ready data. It doesn’t, and if you only find that out at your first year-end close, you pay the difference in advisor hours.

This article explains how Shopify bookkeeping for the German market actually works technically, the three real paths to a DATEV export, where the most expensive mistakes happen, and how to judge which tool fits your store’s size, not your competitor’s.

Why Shopify Can’t Export a DATEV File

Shopify exports order data exclusively as a generic CSV, never in the DATEV EXTF format. This isn’t a missing feature Shopify will eventually add, it’s a structural property of the platform. Shopify is store software, not accounting software, and it has no knowledge of your specific chart of accounts (SKR03 or SKR04 in Germany) or the posting logic your tax advisor’s DATEV system expects.

The DATEV EXTF format is a structured text file with fixed fields for posting account, contra account, amount, document number, and posting text. A Shopify CSV export contains, at best, an amount and an order number, nothing else. Between Shopify and DATEV there’s always a third layer, whether that’s accounting software like sevdesk or lexoffice, specialized middleware like easybill or pathway, or your own manual reconciliation in a spreadsheet. In larger setups, this connecting role increasingly shifts to a full ERP system rather than a single bookkeeping app, and the ERP glossary entry breaks down what that adds on top of plain inventory management.

The Three Paths to a Shopify-DATEV Connection

Every working Shopify bookkeeping setup runs through one of three paths. Which one fits depends less on your agency’s opinion and more on order volume, number of sales channels, and how much manual work you’re actually willing to absorb.

Path 1: CSV Export and Manual Reconciliation

Shopify’s native export plus a spreadsheet template that maps amounts to the right accounts before converting the file into DATEV format. No additional tool, no recurring cost, but a time cost that grows with every additional order, every extra payment provider, and every return. For very small stores with few monthly orders, this is often the most economical option, because a software license simply doesn’t pay off at that volume.

Path 2: Accounting Software With Built-in DATEV Export

sevdesk, lexoffice, and similar cloud accounting tools import Shopify orders through an app connection, turn them into invoices and receipts, and generate their own DATEV export at month end. These tools are standalone bookkeeping systems that treat Shopify as one of several data sources. DATEV format here is an output feature of the software, not a direct Shopify interface.

Path 3: Specialized E-Commerce Automation

Tools like pathway, easybill, or Buchhaltungsbutler are built specifically to automate shop-to-DATEV workflows, often with native connections to multiple channels at once, Amazon and eBay alongside Shopify. easybill, for instance, transmits document data through DATEV’s Rechnungsdatenservice directly into DATEV Unternehmen Online as a posting suggestion, no manual file upload or download required. pathway has been an official DATEV marketplace partner since February 2025 and reconciles more than 15 payment providers automatically.

If you’re not yet sure whether your business actually needs a real inventory or ERP system rather than just a bookkeeping app, the guide to Shopify ERP and inventory management breaks it down by revenue tier.

The Technical Workflow: From Order to DATEV Posting

A working Shopify bookkeeping setup isn’t a single click, it’s a chain of ten steps that run either manually or automated. Once you understand this chain, it’s immediately obvious where your own setup is missing a piece.

1. Order is created in Shopify. Order, line-item, and tax data are available via the Admin API or a Shopify Flow webhook as soon as payment is confirmed.
2. Invoice is generated. Either natively in Shopify or through a connected tool like lexoffice, sevdesk, or easybill, which produces a GoBD-compliant document.
3. Payment provider reports the payment. Shopify Payments, PayPal, and Klarna each deliver their own payout report with gross amount, fee, reserve, and currency conversion where relevant. These reserves and payout delays feed straight into your working capital, an effect that’s easy to underestimate as order volume grows.
4. Each payment provider gets its own clearing account. Instead of booking every payout straight to a bank account, each provider is reconciled separately. This prevents fees from getting buried inside the bank amount.
5. Order revenue is matched against the actual payout. Gross order revenue is compared to the real payout, with fees, reserves, and discounts broken out as their own posting lines.
6. Tax rates are assigned. Domestic standard or reduced rates, reverse-charge for B2B EU deliveries, OSS rates for cross-border B2C sales, each mapped to its own revenue account according to your advisor’s chart of accounts.
7. Returns generate a cancellation invoice or credit note. This document, not the payment provider’s refund detection, is what triggers the correct reversing entry.
8. Posting data is assembled in DATEV’s EXTF format. This step is handled by the accounting software or middleware, usually as a monthly batch.
9. Handover to the tax advisor. Either automated via DATEV Unternehmen Online and DATEV Belegtransfer, or as a file for manual import into DATEV Rechnungswesen.
10. Month-end reconciliation check. Before the period closes for good, the sum of orders, returns, and fees has to match actual bank deposits exactly.

For developers and technical teams looking to automate this chain themselves: the most reliable approach uses Shopify Flow triggers or webhooks on orders/paid and refunds/create, processes every event idempotently keyed on the order number, and writes posting suggestions rather than final postings, so the advisor’s firm can still review every line before it’s booked for good. That idempotency, an event must never cause a second posting, even if delivered twice, is the technical foundation for ruling out duplicate postings structurally.

The Five Most Common Shopify Bookkeeping Mistakes

1. Booking the net payout instead of gross revenue. The classic mistake: a €100 order arrives in the bank account as €97.16 after Shopify Payments or PayPal fees, and that lower figure gets booked as revenue. The correct approach books the full gross revenue and records the fee separately as an operating expense. Otherwise neither your VAT filing nor your actual cost structure will be accurate at year end.

• Set up a separate expense account per payment provider for transaction fees, instead of letting fees disappear inside revenue.

2. Wrong tax rates on cross-border EU sales. Once your cumulative EU B2C sales exceed €10,000 per year, VAT has to be calculated at the destination country’s rate and reported centrally through the OSS scheme with Germany’s Federal Central Tax Office. Merchants who keep charging a flat 19% German VAT often end up having to issue retroactive correction invoices.

• Check quarterly whether your cumulative EU cross-border sales have crossed the €10,000 OSS threshold.

3. Duplicate posting on returns. As described in the workflow section, this happens when both an automatic payment-refund detection and a later manual correction book the same refund. lexoffice and sevdesk only handle returns semi-automatically, a cancellation invoice or credit note has to be actively created before a posting suggestion appears.

• Set a fixed internal rule: no refund gets booked without a cancellation document already existing in the system.

4. Foreign-currency postings without a clear exchange-rate policy. Merchants selling internationally and receiving foreign-currency payments need a fixed rule for the conversion rate on the posting date, otherwise FX gains and losses accumulate untracked. pathway, for example, sells this as a paid add-on module; other tools expect manual rate upkeep.

5. Marketplace and Shopify revenue booked separately instead of consolidated. Sellers running Amazon, eBay, and Shopify in parallel need one consistent chart of accounts across all channels. Separate booking logic per channel almost always produces inconsistencies in VAT filings and makes the advisor’s month-end review considerably harder.

OSS and VAT on Cross-Border Sales

For many Shopify merchants, the One-Stop-Shop scheme, OSS, is the point where bookkeeping shifts from a simple single-rate logic to a multi-country logic. Once your cross-border EU B2C deliveries exceed €10,000 net per calendar year in total, German VAT no longer applies, the rate of the customer’s country does. Reporting runs centrally through Germany’s Federal Central Tax Office instead of requiring separate tax registration in every EU country you sell into.

Technically, this means every order in your Shopify bookkeeping needs a revenue account mapped by destination country, not just by tax rate. Shopify’s own tax engine can calculate OSS rates automatically, but only if the store’s tax settings are configured correctly, something regularly overlooked in stores that grew into international sales organically without scaling the bookkeeping side alongside it.

B2B deliveries within the EU add reverse-charge on top: the VAT liability shifts to the recipient, and the invoice is issued without VAT shown. Merchants running both B2B and B2C through the same store need a clear separation of both cases in their bookkeeping, otherwise VAT filings pick up posting errors that, in the worst case, only surface during a tax audit. How invoice-on-account terms specifically affect checkout and bookkeeping in a B2B context is covered in the Shopify B2B guide.

Which Tool Fits Which Store Size

The choice between DIY export, accounting software, and specialized automation isn’t a matter of taste, it’s a function of order volume, number of channels, and the value of your own time.

• Up to about 50 orders per month, one channel, no return spikes: manual CSV export with a fixed spreadsheet template is often more economical than any software license. Time cost stays manageable as long as the number of payment providers is small.
• 50 to 500 orders per month, one or two channels: sevdesk or lexoffice cover the standard cases and bring invoicing, GoBD-compliant archiving, and DATEV export together in one tool. Setup and account-mapping effort usually pays for itself within a few months.
• 500 to 2,000 orders per month or multiple sales channels: Billbee or easybill become worthwhile, because they offer multichannel consolidation and a tighter DATEV connection without the price and implementation effort of a full ERP system.
• More than 2,000 orders per month, a complex mix of payment providers, international business: specialized automation like pathway pays off, because the saved manual reconciliation time regularly outweighs the higher license cost. At this volume, every hour of manual rework genuinely costs more than the software.

These thresholds are orientation points from operational project experience, not a formula. If you’re also running multiple Shopify storefronts, for different countries or brands, the calculation shifts again, as the guide to Shopify multi-store setups shows with regard to separate bookkeeping entities.

Checklist: Is Your Shopify Bookkeeping DATEV-Ready?

Seven or more “yes” answers mean your Shopify bookkeeping is on solid technical footing. Four to six points suggest a targeted rework of individual process steps. Three or fewer, and you’re likely carrying unnoticed liability risk in your bookkeeping right now, the kind that only shows up at the next year-end close.

Frequently Asked Questions About Shopify Bookkeeping

Can Shopify export data directly in DATEV format?

No. Shopify only exports order data as a generic CSV, not in the DATEV EXTF format. A DATEV-compliant export always runs through a third-party app or accounting tool like sevdesk, lexoffice, Billbee, easybill, or pathway, which converts the raw data into a postable format.

What’s the difference between sevdesk or lexoffice and a specialized DATEV interface?

sevdesk and lexoffice are standalone accounting programs that import Shopify orders, generate invoices, and produce their own DATEV export. Tools like pathway or easybill, by contrast, are specialized middleware that convert Shopify data directly and automatically into a DATEV posting format, often with a tighter connection to the advisor’s firm via DATEV Unternehmen Online.

Why does the amount in my bank account never match Shopify’s reported revenue?

Because payment providers like Shopify Payments, PayPal, or Klarna deduct fees, reserves, and sometimes currency conversion before the payout even lands. Accurate bookkeeping requires capturing the full gross revenue per order and booking the fee separately as an expense, not just the lower net payout amount.

At what point do I need to register for the EU OSS scheme selling through Shopify?

Once your cross-border EU B2C sales exceed €10,000 net per year in total, VAT has to be calculated at the rate of the customer’s country and reported centrally through the OSS scheme with Germany’s Federal Central Tax Office.

How do I prevent duplicate postings on Shopify returns?

By actively creating a cancellation invoice or credit note before any reversing entry is booked, instead of relying solely on automatic refund detection from the payment provider. Most tools handle returns only semi-automatically and need this document as the trigger for the correct posting suggestion.

Do I need DATEV at all, or is a tool like sevdesk enough on its own?

It depends on your tax advisor. If the firm itself works in DATEV, a compatible export is mandatory, regardless of which front-end tool you use day to day. If your advisor uses a different system, or handles your bookkeeping directly inside sevdesk or lexoffice, a DATEV export may be unnecessary. Clarify this with the firm directly before choosing a tool based on it.

What does an automated Shopify-DATEV connection realistically cost?

For smaller stores using sevdesk or lexoffice, running costs typically land between €15 and €40 per month, including the app fee. For multichannel setups using Billbee or easybill, €30 to €80 per month is realistic. Specialized automation like pathway runs into four-figure monthly territory, but pays off past a certain order volume through the manual reconciliation time it eliminates.

Conclusion: Bookkeeping Is an Architecture Question, Not an App Choice

Shopify delivers the raw data, but never a finished DATEV-compliant bookkeeping process, and that’s not a gap, it’s the division of labor the platform was built for. The real task is deliberately designing the path from order to posting: which tool handles payment-provider reconciliation, how returns get processed correctly, and how the result reliably reaches the advisor’s firm.

Get that chain right once, and you save real time while meaningfully cutting the risk of duplicate postings, wrong VAT rates, and unpleasant surprises at the next tax audit. The right tool choice then follows almost automatically from order volume and channel count, not from whichever vendor runs the loudest ad.

Bookkeeping is only one part of your store’s operational back end. If warehousing, shipping, and returns processing are also hitting capacity limits, the guide to outsourcing fulfillment applies the same build-vs-buy logic to the logistics side.

If you want an independent read on your current Shopify bookkeeping setup, one that doesn’t end with a specific tool being sold to you: I’ll look at your workflow and tell you honestly where the biggest risk sits, and where automation would actually pay off. Book a free intro call →