The Stripe payout case
Stripe doesn't transfer each charge to you separately. It groups many charges into a payout and deposits the net: the sum of the charges minus Stripe's fees and minus refunds. That's why the amount that reaches your bank never matches your gross sales, and reconciling Stripe by eye is practically impossible.
Why the bank doesn't add up
A typical payout looks like this:
- Gross charges: the sum of the invoices or sales collected in the period.
- – Stripe fees: what Stripe charges for processing.
- – Refunds: charges that were reversed.
- = Net deposited in the bank: the only amount your bank account ever sees.
If you try to match that net against a sales invoice, it doesn't fit: it's missing the fees and it's off by the grouped refunds.
How Aikount solves it
Aikount breaks the payout down and links the full chain:
payout ↔ charges ↔ bank deposit
- It reconstructs which individual charges make up the payout.
- It separates the fees and refunds that explain the gap between gross and net.
- It links the net bank deposit to the payout, and the payout to each charge that composes it.
That way each sales invoice is reconciled with its real charge, the fees are recorded as an expense with their reverse-charge VAT (see below), and the bank balance matches the net that actually came in.
Without this breakdown, you'd have the net in the bank on one side and gross sales on the other, with no way to reconcile them, and Stripe's fees would fall outside your accounting.
Stripe fees
Fees are invoiced by Stripe Payments Europe, Ltd. (Ireland), without VAT, in one document per month. It is a service from a business in another EU country to your business: you declare the VAT yourself (reverse charge, arts. 69.Uno.1.º and 84.Uno.2.º LIVA). With Stripe connected, Aikount creates one purchase per month from Stripe Payments Europe with the month's total fees:
- expense in a 626 subaccount (banking services), against the Stripe account;
- self-assessed VAT: 472 debit and 477 credit (they cancel out: you pay nothing if you deduct all your VAT);
- on the
303, boxes 10-11 (intra-EU acquisitions of goods and services) and 36-37 (deductible); on the349, key I.
If you later upload Stripe's monthly invoice (or it arrives in the purchases inbox), it is attached to that same purchase by its number: no second one is created. A month whose VAT return is already filed is left untouched.
What you need
- Stripe connected as a treasury. Aikount reads charges, fees and payouts. See Connect Stripe.
- The bank account where Stripe deposits the net connected too, so you can link the final deposit.
How it fits into reconciliation
The payout breakdown is the canonical example of a movement that doesn't match a gross sale and needs its own treatment. For the general flow (automatic, suggested and manual), see How reconciliation works and The suggestions board.