How do I reconcile payouts from PayPal and similar providers?

A fictional customer pays €59.90 through a payment provider. That amount often does not appear in your bank account. What appears is the payout: many payments from a period, minus fees and refunds, in a single transfer. When and in what form payouts are made differs by provider and product. The terms are in the provider's documentation.

That is why the direct comparison "invoice versus bank transfer" fails. The difference is made up of fees, refunds, and payments that are still in transit.

From an accounting perspective, three levels help:

• Level 1, order and invoice: The invoice documents revenue and the receivable.
• Level 2, payment: The customer has paid, and the money is with the provider.
• Level 3, payout: Depending on the provider, the money arrives in your bank account as a bulk amount or as a transfer of the balance. The payout is not revenue, it is a money transfer.

Each level has its own document. This does not replace tax advice.

This page covers bulk payouts from payment providers, not the matching of individual subscription payments.

One possible method: for each provider, such as PayPal, Klarna, and Stripe, a clearing account as an intermediate holding place for money that sits with the provider. Some accounting firms instead treat the provider like a separate bank account or use a transit account; your firm decides which variant fits. The following steps are a guide, not booking instructions.

1. Customer payment: It settles the receivable; the money sits with the provider.
2. Provider fee: It is customary to keep it as a separate item, apart from revenue. Whether VAT is shown on the fee document and how the fee is treated for tax purposes depends on the provider and the document. Clarify the tax treatment of the fee document with your tax advisor before you deduct input VAT.
3. Refund: It changes revenue. A credit note (invoice correction) for the invoice is customary; for VAT, section 17 UStG (German VAT Act, adjustment of the tax base) is the framework. The payment runs through the clearing account. How you book this is something you clarify with your tax advisor.
4. Payout: The money goes from the provider to your bank account; the clearing account is reconciled against the bank.

This does not replace tax advice.

That depends on the setup. If your firm books in DATEV, it keeps the clearing account there, and weclapp passes on invoices and, depending on the transfer route, bank transactions. Which accounts apply is determined by the firm in the chart of accounts.

At month end, you compare the balance with the provider's report. How a remaining credit or a deficit at the balance sheet date is to be shown, for example as a receivable from or a liability to the provider, is determined by your tax advisor. Chargebacks, retained reserves, and foreign currencies can change the balance; check in the report how they are shown. Export the reports and ask your tax advisor whether and how you should retain them. This does not replace tax advice.

A fictional merchant business has Shopify Payments, PayPal, and Klarna active and 3,000 orders per month (assumption). Orders flow into weclapp via the shop integration, invoices are created, and payments are matched via a shared reference, for example the order or invoice number. During the day, the team checks open items and bank transactions. At month end, each clearing account is reconciled with its provider's report.

An example calculation with made-up figures, gross: customer payments €10,000, refunds €200, fees €300, payout €9,500. Whether and how VAT applies to the fees is something your tax advisor clarifies: payment services can be VAT-exempt under section 4 no. 8 UStG, depending on the document. This does not replace tax advice.

The balance at the provider goes to zero: €10,000 − €200 − €300 = €9,500, exactly the payout. How you reflect this in your accounting is determined by your tax advisor. For providers that are not on the provider list in the weclapp documentation, such as Shopify Payments, the scheme can be applied just the same; how the data gets into your accounting (for example as a bank transaction) is something you clarify before you start. This does not replace tax advice.

According to the weclapp documentation, finAPI, Tink, Qwist, Stripe, Klarna, and PayPal are supported. The purpose is the exchange of payment transactions, meaning retrieving account movements and executing payments. You set them up under Global settings > Finance > Payment providers. The number of entries per provider is not limited.

The feature table on the pricing page also lists automated booking of documents and bank transactions, in all three plans. weclapp's DATEV integration page mentions bank retrieval and the offsetting of open items. For bulk payouts, the clearing account scheme above serves as a guide here.

How the data reaches the firm depends on the DATEV interface. According to the DATEV Marketplace, invoices and transactions go to the firm either as posting records with a document or as posting suggestions, depending on the interface. According to the pricing page, tax advisors get free access at the client's request.

For payouts, the firm often also requires the provider's report with the individual items; ask what they need. The GoBD of the German Federal Ministry of Finance (BMF letter of November 28, 2019, last amended on July 14, 2025) apply to the keeping and retention of electronic records. What that means for your documents is something you clarify with your tax advisor. This does not replace tax advice.

Zahlungsabgleich 4 weclapp is a wals.pro product. It detects open items and bank transactions, checks them, and books them in weclapp, for both receivables and payables. Bank accounts run through finAPI. A five-stage scoring match evaluates amount, date, reference text, and merchant name, and uncertain cases go to review.

There is no native weclapp standard for bulk payouts from a payment provider. Zahlungsabgleich 4 weclapp breaks down collective remittance advices, for example from Stripe, Mollie, PayPal, or American Express, into individual payments and fees, and can be extended with further advice sources. Details are on the product page.