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: How to Book PayPal Payments

PayPal is the most used payment method in many online stores. In the books, though, it behaves differently from a bank account: customer payments, fees, refunds and holds all collect in the PayPal account before any money reaches your bank. If you only book the transfer from PayPal to your bank, you lose exactly those movements.

How do I book PayPal payments correctly?

In short: Book every PayPal payment at its gross amount as revenue against a dedicated PayPal clearing account. The retained fee goes to "incidental costs of monetary transactions" (Nebenkosten des Geldverkehrs), and the transfer to your bank is a reclassification from the PayPal clearing account to the bank. At month-end, the balance of the PayPal clearing account has to match the balance on your PayPal statement.

Here is an example with a sale of €119.00 gross, i.e. €100.00 net plus 19% German VAT. The fee of €3.25 is chosen freely for the example. Your actual fee is shown in the line of each transaction.

Event	Debit	Credit	Amount
Customer pays via PayPal	PayPal clearing account	Revenue 19% VAT (SKR03 8400 / SKR04 4400)	€119.00
Fee retained by PayPal	Incidental costs of monetary transactions (SKR03 4970 / SKR04 6855)	PayPal clearing account	€3.25
Transfer to your bank account	Bank (SKR03 1200 / SKR04 1800)	PayPal clearing account	€115.75

After these three entries, the PayPal clearing account is back at €0.00 for this transaction. The VAT of €19.00 is calculated on the gross revenue of €119.00. That less is paid out does not change this. If your tax adviser works with automatic accounts in DATEV, the VAT is split out of the revenue account automatically. When you post sales invoices to customer accounts (debtors), the PayPal payment clears the open receivable instead.

Agree on the account number for the PayPal clearing account once with your tax adviser. This article uses 1361 as an example.

Booking PayPal fees: account and VAT

PayPal deducts its fee directly from the payment. There is no separate debit, so the fee only appears in the PayPal report. You can book it per transaction or as a reviewed monthly total from the report, as long as you use only one source. Booking fees from the activity report and again from a monthly summary counts them twice.

There is no blanket answer on VAT for PayPal fees. It depends on which PayPal entity charges you and how the service is classified for VAT. Two rules come into question: the exemption for certain payment services under Section 4 No. 8 of the German VAT Act and, for taxable services from a provider in another EU country, the reverse-charge procedure under Section 13b. Check PayPal's fee statement and settle the treatment once with your tax adviser. After that, you book it the same way every month.

Refunds, buyer protection and chargebacks

If you refund a customer through PayPal, you reverse the revenue entry:

Event	Debit	Credit	Amount
Refund to the customer	Sales deductions 19% VAT (SKR03 8720 / SKR04 4720)	PayPal clearing account	€119.00

This also reduces the VAT from the original sale. Whether PayPal returns the original fee in full, in part or not at all depends on the fee terms in force at the time. You can see it in the fee column of the refund line in the report. A credit there is booked back against the fee account. An empty column means the fee stays an expense.

In a buyer protection case or a card chargeback, PayPal often holds the amount first. While the case is open, the money is blocked but not yet lost. Keep the hold on the PayPal clearing account or on a separate sub-account for holds. If the case is decided against you, book it like a refund. Any additional dispute fee goes to the fee account.

PayPal payments in foreign currencies

If you sell in US dollars, pounds or Swiss francs, PayPal either converts the amount to euros straight away or keeps a balance in the foreign currency. Both can be booked cleanly:

Immediate conversion: The report shows the foreign amount, the conversion and the euro amount as separate lines. You book the revenue in euros.
Balance in a foreign currency: Keep a separate sub-account for each currency. When you later convert the balance to euros, book the difference as an expense from exchange differences (SKR03 2150 / SKR04 6880) or as income from exchange differences (SKR03 2660 / SKR04 4840).

For German VAT purposes, foreign currency amounts are generally converted at the monthly average rate published by the Federal Ministry of Finance, as set out in Section 16(6) of the VAT Act. Also check PayPal's current fee overview to see whether conversion costs appear as a separate fee or are built into the exchange rate. If they are in the rate, they show up in your books as an exchange difference.

Which PayPal report do you need for accounting?

You need two files from your PayPal business account every month. Both are described in PayPal's help article on statements and reports:

The monthly account statement: On the statements page, click "Request" next to the month you need and download it. It documents the opening and closing balance.
An activity report as CSV: Under "Activity", choose the download icon and "Custom". The report lists payments, fees, refunds and transfers individually. One request covers up to twelve months.

Match each line using the PayPal transaction ID or the order number from your store. At month-end, compare the balance of your PayPal clearing account with the closing balance on the statement. If they differ, the usual cause is a fee, refund or transfer that appears in only one of the two sources.

Common PayPal pitfalls

Order number missing from the report: Depending on how your store connects to PayPal, the order number does not appear in every PayPal line. The transaction ID is then the only key, and your store has to save it with the order.
Only the bank credit is booked: Booking only the transfer from PayPal to the bank loses fees and refunds as individual events and understates revenue.
Private and business payments mixed: If private payments run through the same PayPal account, each one has to be separated as a private contribution or withdrawal. A dedicated business account saves you that work.

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.

Shopify Payments has enough quirks of its own to fill a separate post: the full reconciliation is covered under Shopify accounting.

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	Account statement and activity report (CSV)
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

Marketplaces and shops follow the same principle. How to record eBay fees without booking them twice is covered in the guide on eBay accounting. For WooCommerce shops, the article on WooCommerce accounting gives you seven test cases.

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 Helps with Payment Provider Accounting

Merging CSV files from several payment providers in Excel every month takes time, and copying creates errors. KudTax takes over this data work:

Connections: PayPal and Stripe are connected directly. The integrations overview shows which other payment providers you can connect.
AI-assisted matching: Store orders, invoices and payouts are matched to each other. Anything that does not match clearly stays visible as an open difference and is resolved before month-end close.
Clearing accounts: Reconciling a separate clearing account for each payment provider is supported.
DATEV export: The result is DATEV EXTF files with accounting data and document references for you or your tax adviser to review before import.

What to look for when comparing such tools is covered in the guide on choosing e-commerce accounting software. If you no longer want to reconcile your payment providers by hand, you can try KudTax for free.

Official and further sources

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

Payment Provider Accounting: PayPal, Stripe, Klarna, Mollie