Skip to main content
E-commerce & DATEV

Shopify DATEV export workflow for payout imports

Keep payout, fee, and refund structure transparent so monthly close and tax-office handover do not depend on manual spreadsheets.

KontoCSV Team
10 min read
March 2026
Shopify
DATEV workflow
Payout cleanup
Upload + conversion

Problem and solution

Shopify payouts are net bundles. Accounting imports usually need fee and refund context separated.

KontoCSV normalizes mixed payout CSV and PDF records into one recurring process.

Prepare Shopify payout files for DATEV-oriented imports

Drop one PDF or multiple PDFs here

Works with digital PDFs, scans, and photos from banks worldwide - retail, business, and fintech. Multiple PDFs are automatically processed as one batch and exported as a ZIP with individual CSV files.

How this workflow runs in real teams

  • Payout and transaction-level data are aligned into one structure.
  • Fee/refund logic remains explicit.
  • CSV and PDF can be combined in one run.
  • Outputs target German bookkeeping handover workflows.

Why native exports are often not enough

Native Shopify exports are useful, but recurring imports still need field and format cleanup.

View mismatch
Payout overview and detail views are not always equivalent for posting.
Net transfer focus
Net payout alone does not explain full booking detail.
Layout variation
Different report paths can change the column layout.
Backlog periods
Older months may only exist as PDF records.

Accounting reality

A normalization layer keeps monthly imports stable even when source exports vary.

Common payout data pain points

Bundled payouts
One net transfer often combines many underlying transactions.
Fees
Fee rows need explicit treatment for transparent posting.
Missing structure
Raw exports are not automatically aligned with recurring import templates.
Inconsistent CSVs
Columns and formatting shift across reports and periods.
Manual rework
Spreadsheet cleanup repeats every close cycle.
DATEV import friction
Small formatting mismatches can block imports.

Step-by-step workflow

Step 1: Export monthly payout context

Collect payout and transaction files per close period.

Step 2: Add PDF fallback

Bring in missing months from PDF statements.

Step 3: Normalize in KontoCSV

Map fields, formats, and signs into one profile.

Step 4: Validate fee/refund split

Check payout-level plausibility before export.

Step 5: Export recurring import file

Generate one clean structure for accounting imports.

Step 6: Reuse mapping each month

Keep setup stable and minimize manual changes.

Who this is a fit for

Best fit for

  • Shopify merchants using Shopify Payments
  • Bookkeeping teams with recurring payout reconciliation
  • Tax advisors supporting e-commerce clients
  • Teams with mixed CSV/PDF source quality
  • Businesses building predictable monthly close workflows

What gets recognized / prepared

Prepared output

  • Payout references and net context
  • Fee and refund breakdown
  • Normalized date and amount formats
  • Clean booking text fields
  • Consistent import columns
  • Structured handover for accounting and tax offices

Privacy, hosting, and reliability

Trust and compliance

  • GDPR-compliant processing with EU hosting in Frankfurt.
  • Built for German bookkeeping and tax-office collaboration.
  • Credit-based pricing instead of forced subscriptions.
  • Deletion and privacy controls for sensitive finance files.

Important note

KontoCSV is not an official DATEV product or service. It is a neutral third-party workflow for preparing import data.

Start your Shopify payout cleanup workflow

No forced subscription: use credits when needed and keep costs transparent.

Start Shopify workflow

FAQ

Is payout overview alone enough for accounting import?

Usually not. Most teams also need fee and refund detail for transparent posting.

Can PDF-only periods be imported later?

Yes. PDF periods can be normalized and merged into the recurring workflow.

How do we keep multi-shop setups manageable?

Use separate runs per shop/market with consistent naming and mapping profiles.

Does this replace Shopify exports?

No. It complements them by normalizing data before import.

How do we reduce tax-office clarifications?

Keep payout references, signs, and fee treatment consistent in each monthly file.

Workflow sources

Status as of Friday, March 6, 2026. These sources reflect the current workflow landscape.

More helpful articles

Start your Shopify payout cleanup workflow

Normalize payout files and prepare recurring imports.