When an online store offers several payment methods, the bank account rarely shows individual customer payments. PayPal, Stripe, Klarna, Mollie and Shopify Payments normally transfer bundled net amounts. A single payout can contain hundreds or thousands of sales, while processing fees, refunds, chargebacks, reserves, currency conversions, corrections and prior negative balances are deducted or added. The amount credited to the bank therefore almost never equals the revenue for a day or month.

This is the core challenge of e-commerce payment accounting. Accurate bookkeeping must do more than explain the amount received in the bank account. It must show which orders were paid, which receivables were cleared, which fees were retained, which refunds or disputes were included and what balance remains with the payment provider.

The issue is not limited to large merchants. A business with only a few hundred monthly orders may already use several stores, marketplaces and payment service providers. Without a consistent reconciliation model, open items accumulate, differences remain unexplained and fees are posted to generic accounts. Month-end becomes unnecessarily time-consuming because the same economic transaction appears in the store order, the sales invoice, the provider report and later the bank statement.

This guide explains how merchants and tax advisers can set up a unified workflow for payment provider accounting across PayPal, Stripe, Klarna, Mollie and Shopify Payments, how clearing accounts work in practice and how to generate clean DATEV posting data.

Why payment provider payouts do not match sales figures

The core accounting reason for payout discrepancies is that payment service providers (PSPs) act as financial intermediaries holding short-term customer funds. When a customer purchases a €100 item, the provider collects €100 from the buyer, deducts a €2.50 processing fee, and queues €97.50 for disbursement.

If payouts occur daily, weekly or on custom schedules, several factors prevent bank deposits from matching sales:

Batch processing: Payouts combine multiple transactions across different purchase dates.
Deducted fees: Transaction fees, fixed fees and percentage charges are deducted before payout.
Refunds and chargebacks: Customer refunds and disputed transactions reduce the net payout amount.
Rolling reserves: Providers retain a percentage of funds for 7 to 90 days to cover potential risk.
Cut-off timing: Orders paid late in the month may disburse in the following financial period.
Multi-currency conversions: Conversions between USD, GBP, CHF and EUR create foreign exchange gains or losses.

If an accountant books bank deposits directly to revenue, gross sales are distorted, fees remain unposted as tax-deductible expenses, and VAT liabilities are miscalculated.

The core solution: Payment clearing accounts (Verrechnungskonten)

The standard accounting method for resolving payment discrepancies under GoBD rules is the clearing account model (Verrechnungskonto-Modell). Under this structure, every payment provider receives a dedicated clearing account in the chart of accounts.

How the clearing account works in three steps:

Step 1 — Store Sale / Invoice (Debtor vs Revenue): When an order is completed, the invoice is posted:
- Debit: Payment Clearing Account (e.g. PayPal Clearing 1361)
- Credit: Revenue Account (e.g. 8400 19% VAT)
Step 2 — Settlement Report (Fees & Refunds): When the provider generates its settlement report:
- Debit: Payment Provider Fees (e.g. 4970)
- Debit: Customer Refunds / Revenue Adjustment
- Credit: Payment Clearing Account
Step 3 — Bank Transfer (Bank vs Clearing): When the net payout arrives in the bank:
- Debit: Bank Account (1200)
- Credit: Payment Clearing Account

If all sales, fees, refunds and payouts are recorded, the clearing account balance equals the exact uncollected funds or reserve balance held by the provider at the balance-sheet date.

Provider 1: PayPal Accounting & Balance Reconciliation

PayPal is one of the most widely used payment methods, but its reporting structure differs significantly from standard bank accounts.

Common PayPal Accounting Pitfalls:

Express Checkout vs Standard PayPal: Orders placed via PayPal Express can generate different transaction IDs in shop systems compared to PayPal account reports.
Monthly Statements vs Settlement Reports: Using raw bank feed integrations for PayPal often imports net payouts without posting itemised fees or matching order numbers.

Best Practice for PayPal:

Download the official PayPal Balance Reconciliation Report or use API-based integration tools. Match each transaction using the PayPal Transaction ID or the Shop Order Number (passed in the custom field). Reconcile the monthly closing balance against the actual PayPal account balance statement.

Provider 2: Stripe Accounting & Payout Reconciliation

Stripe operates on a payout-based settlement model where balance transactions are assigned to specific po_ (payout) IDs.

Key Stripe Transaction Types:

charge: Customer payment (gross amount).
stripe_fee: Processing fee charged by Stripe.
refund: Returned funds sent back to the customer.
adjustment / dispute: Chargebacks and dispute resolution fees.

Reconciling Stripe:

Every Stripe payout report links gross charges, fees and refunds to the final net transfer. By matching the payout_id on the bank deposit with the corresponding Stripe payout summary, the clearing account balance for that batch reduces to zero automatically.

Provider 3: Klarna Accounting & Settlement Reports

Klarna handles Pay Later, Pay Now and Slice It options. Because Klarna assumes buyer default risk, its payout timing and fee structures require careful management.

Key Aspects of Klarna Accounting:

Settlement Files: Klarna provides weekly or daily CSV settlement files listing captured orders, merchant fees, return deductions and payout reference numbers.
Invoice Number Matching: Klarna payouts reference the merchant's invoice number or Klarna Order Reference.
Rolling Reserves: Klarna frequently retains a percentage reserve on new or high-volume accounts, requiring a dedicated reserve sub-account.

Provider 4: Mollie & Multi-Payment Gateway Accounting

Mollie aggregates multiple payment methods (iDEAL, credit card, Bancontact, Sofort, Klarna) into a single unified payout.

How to Reconcile Mollie:

Because Mollie combines multiple payment options into one bank payout, the settlement report must be parsed by payment method type. Each sub-transaction must be matched to the original store order while allocating processing fees to the correct fee account.

Provider 5: Shopify Payments Accounting

Shopify Payments is powered by Stripe infrastructure but integrates directly into the Shopify admin.

Key Shopify Payments Considerations:

Payout Reports: Payouts are exported from Shopify admin or API containing order numbers, gross amounts, Shopify Payments fees and net disbursements.
Currency Conversion Fees: When selling internationally via Shopify Markets, Shopify charges a 1.5% to 2% currency conversion fee embedded into transaction rates.
Gift Card Redemptions: Orders paid via Shopify Gift Cards do not create a payout; they reduce the gift card liability account.

Summary Comparison of E-Commerce Payment Providers

Payment Provider	Primary Settlement Identifier	Fee Deduction Timing	Key Report for Accounting
PayPal	Transaction ID / Custom Field	Per transaction	Balance Reconciliation Report / API
Stripe	Payout ID (`po_...`)	Per transaction / batch	Payout Balance Summary
Klarna	Settlement Reference	Per payout batch	Klarna Settlement CSV
Mollie	Payout ID (`tr_...`)	Per payout batch	Mollie Payout Report
Shopify Payments	Payout ID	Per payout batch	Shopify Payout Export

Transferring Payment Provider Data to DATEV

For German tax advisers using DATEV Kanzlei-Rechnungswesen, payment provider data must be structured into EXTF posting batches:

Belegfeld 1: Assign the Order ID or Payment Transaction ID to Belegfeld 1 for automated open-item (OPOS) clearing.
Account Assignment (SKR03 / SKR04): Use separate clearing accounts for each provider (e.g. 1361 PayPal, 1362 Stripe, 1363 Klarna).
Fee Tax Keys: Post provider fees using appropriate tax codes (standard input tax or reverse-charge for foreign PSP entities such as Stripe Payments Europe in Ireland).

How KudTax Automates Payment Provider Accounting

Manually parsing CSV files from PayPal, Stripe, Klarna, Mollie and Shopify Payments in Excel consumes hours of manual work every month.

KudTax completely automates e-commerce payment accounting:

Multi-PSP API Connections: Directly fetches transaction, payout, fee and refund data from PayPal, Stripe, Klarna, Mollie and Shopify Payments.
Automated Open-Item Matching: Matches customer orders, invoices and payouts across all channels automatically.
Clearing Account Automation: Maintains clean clearing accounts for every provider, ensuring zero-balance reconciliations at month-end.
DATEV EXTF Exports: Generates fully formatted DATEV posting batches with complete document links and tax keys.

Online merchants and tax advisers can test KudTax for free to streamline payment provider reconciliation and e-commerce bookkeeping.

Official and further sources

This article provides general information for tax professionals and online merchants and does not constitute formal legal or tax advice.

E-Commerce Payment Accounting: PayPal, Stripe, Klarna, Mollie and Shopify Payments