top of page

Title

Guides › Glossary › Batch payouts and payment reconciliation

What is a batch payout and how does payment reconciliation work?

​

A batch payout bundles many payment transactions into one transfer. Payment providers such as Stripe and marketplaces such as Amazon pay out customer payments collectively, minus fees and refunds. Payment reconciliation assigns each payout to the individual orders, invoices, fees and refunds.

​

At a glance

  • The payout is not the revenue.

  • Fees are deducted before the payout.

  • Without reconciliation, fees are missing in bookkeeping and invoices stay open.

​

Example

Customer payments 12,000 euros, refunds 800 euros, fees 350 euros. 10,850 euros arrive in the bank account. Booking only 10,850 euros as revenue mixes up revenue, refunds and costs. A remaining balance at the provider is often not an error. It arrives with the next payout.

​

How it works in Frienton

Frienton connects Stripe via API. Transactions, invoices, fees, refunds and balances not yet paid out appear automatically. Fees are booked and handed over to DATEV with the accounting batch. Amazon, Shopify and Shopware have their own integrations, PayPal comes in through multibanking.

Helpdesk: Stripe integration | Benefits

​

Frequently asked questions

​

How are Stripe payouts booked correctly?

A Stripe payout contains many customer payments minus Stripe fees and refunds. For bookkeeping, it is broken down into these components. Revenue is matched to the invoices, fees are booked as expenses, refunds reduce revenue. Frienton does this breakdown via the Stripe API and hands the bookings to the tax firm through the DATEV Buchungsdatenservice.

​

Is the bank statement enough for payment reconciliation?

No. The bank statement shows only the total of a payout. Which orders, fees, refunds and chargebacks it contains is in the settlement data of the payment provider or marketplace. Only both sources together allow complete reconciliation. That is why a payment provider such as Stripe is connected in addition to the bank.

​

Why is there a difference at the payment provider after month end?

Sale, receipt of payment at the provider and payout to the bank account often fall into different periods. Payments from the end of the month still sit as a balance at the provider and only arrive with the next payout. This difference is not an error. It is carried as a balance at the payment provider and settled in the following month.

​

Further reading

E-commerce

OSS procedure

​

​

Frienton connects bank, bookkeeping, reporting and tax firm in one Financial Operating System.

Book your introductory call →

​

General information, not tax advice. Frienton does not provide tax advice itself.

bottom of page