How to allocate Twint / Stripe / PayPal fees

How are fees from payment providers booked? Here is an overview of how the book-entries can look like.

Of course, we see that payments from an online store should not be processed manually. That is why we are currently working on our API, which will then enable a connection so that everything can run automatically.

How do I book a Twint payment?

A product is sold for CHF 100, plus CHF 7.70 (7.7%) VAT, so the invoice amount is CHF 107.70. Of this, Twint keeps CHF 0.20 as a fee (as of 2022) and transfers CHF 107.50 to you. But what happens to the 0.20?

Manual book-entries
The book-entries for a clear Twint incoming payment:

Debit / Credit, Amount:

  • 1101 Twint / 3402 Revenue account XY, CHF 107.70
  • 6940 Twint fees / 1101 Twint, CHF 0.20
  • 1020 Bank / 1101 Twint, CHF 107.50

Book-entires with invoice document
You receive a payment on your bank. Then you book a new payment, i.e. only 107.50. CashCtrl indicates that there is still CHF 0.20 open. You book this with a book entry template on "6940 Twint fees". You can enter book entry templates via Settings Order categories  Invoices  Book entry templates.

How do I book a PayPal Payment?

A product is sold for CHF 100.-, plus CHF 7.70 (7.7%) VAT, so the invoice amount is CHF 107.70. PayPal keeps 3.4% of this amount (=CHF 3.65) plus a fee of CHF 0.55 (as of 2022), in sum CHF 4.20 and transfers the rest to you.

Manual book-entries
The book entries for a clear incoming Paypal payment:

Debit / Credit, Amount:

  • 1102 PayPal / 3402 Revenue account XY, CHF 107.70
  • 6941 PayPal fees / 1102 PayPal, CHF 4.20
  • 1020 Bank / 1102 PayPal, CHF 103.50

Booke entries with invoice document
You receive a payment on the bank. Book the effectively transferred amount. CashCtrl indicates that there is still a difference open. You book this with a book entry template on "6941 Paypal fees". You can enter book entry templates via Settings Order categories  Invoices  Book entry templates.

How do I book a Stripe Payment?

A product is sold for CHF 100.-, plus CHF 7.70 (7.7%) VAT, so the invoice amount is CHF 107.70. Stripe keeps 2.9% of this amount (= CHF 3,10) plus a fee of CHF 0.30 (as of 2022) and transfers the rest to you.

Manual book-entries
The book entries for a clear incoming Stripe payment:

Debit / Credit, Amount:

  • 1103 Stripe / 3402 Revenue account XY, CHF 107.70
  • 6942 Stripe fees / 1103 Stripe, CHF 3.40
  • 1020 Bank / 1103 Stripe, CHF 104.30

Booke entries with invoice document
You receive a payment on the bank. Book the effectively transferred amount. CashCtrl indicates that there is still a difference open. You book this with a book entry template on "6942 Stripe fees". You can enter book entry templates via Settings Order categories  Invoices  Book entry templates.

More clarity with a collective book entry

CashCtrl PRO offers a collective booking function, so that the clarity is even better. Since the amount of the fee is already known, the two profit-related bookings can be created together.

Let's assume that the transfer from the payment provider is delayed:

Collective entry:

  • 1103 Stripe / 3402 Revenue account XY, CHF 107.70
  • 6942 Stripe fees / 1103 Stripe, CHF 3.40

Payment entry:

  • 1020 Bank / 1103 Stripe, CHF 104.30

Let's assume the payment provider transfers immediately:

Collective entry:

  • 1103 Stripe / 3402 Revenue account XY, CHF 107.70
  • 6942 Stripe fees / 1103 Stripe, CHF 3.40
  • 1020 Bank / 1103 Stripe, CHF 104.30