Export Stripe Payouts to MT940 — Guide for Exact, Twinfield, Moneybird

Why Stripe payouts are awkward to book

A Stripe payout is the net amount that lands in your bank account after Stripe withholds processing fees, refunds and disputes from a batch of transactions. The bank statement shows one round number coming in — for example €4,236.18 — while your sales report shows dozens of individual charges adding up to a different gross. The difference is the Stripe fee, the refunds you issued, and any reserves.

Booking that one payout against your invoices in Exact Online, Twinfield or Moneybird means you have to split it manually: the gross amount per invoice as revenue, the fee as a cost, and the refunds as corrections. Doing this for every payout, every week, is the part most finance teams quietly hate. The shortcut is to convert the Stripe payout export into an MT940 file and let the accounting software match it like a regular bank statement.

The export → convert → import flow

Stripe lets you download a payout reconciliation report as CSV from Reports → Payouts → Export. The CSV contains one row per payout with the gross amount, the fee, the net and the payout date. That is exactly what an accounting package needs — but it expects MT940, not Stripe’s CSV layout.

StatementBridge converts the CSV into an MT940 with the right SWIFT tags, validates the IBAN checksum and generates a usable mock-IBAN for the Stripe ledger account if you do not have one. Three steps: upload the CSV, verify the column mapping, download the MT940. The output imports into the same dialog you already use for ABN AMRO, ING or Rabobank statements.

Importing the MT940 per accounting package

Exact Online

Create a separate bank account in Master data → Cash & bank → Bank accounts for Stripe. Use the IBAN that StatementBridge generated for the Stripe ledger; Exact validates the checksum on save. Then go to Cash & bank → Process bank statements → Import, pick the MT940 file and confirm the matched account. Exact reconciles each payout line against open invoices using the description and amount; outliers land in a clearing account you book off afterwards.

Twinfield

In Twinfield, register the Stripe ledger as an extra journal of type “Bank” with the generated IBAN. Drop the MT940 onto the Cash & banks tile in the new interface, or upload via General → File management → Import → Electronic bank statement in the classic interface. Use the matching screen to attach each payout to the corresponding invoices. Set up booking rules for recurring fee patterns (“Stripe fee”, “chargeback”) so the next import is largely automatic.

Moneybird

Moneybird is the easiest of the three. Add a new bank account under Settings → Bank accounts → New bank account, choose Custom, and paste the IBAN. Then go to Banking → Import, select MT940, and upload the file. Moneybird auto-suggests the right ledger account based on the description; review and confirm. Recurring lines (Stripe processing fees, refunds) can be turned into booking rules with two clicks.

What about refunds and chargebacks?

They appear as separate negative-amount rows in the Stripe payout CSV, with a different type field. StatementBridge preserves the sign so refunds stay negative in the MT940 and your accounting software books them as outgoing. Disputed amounts (chargebacks) get a similar treatment but Stripe also debits a dispute fee — that shows as its own line and should be booked to the same fee account as regular processing fees.

One-time setup, recurring time saved

The first import takes 10 minutes: create the Stripe ledger account, generate a mock-IBAN, upload the first MT940 and tweak the matching rules. Every subsequent payout is a 30-second workflow: download the latest CSV from Stripe, drop it into the converter, import the MT940. No manual splitting, no spreadsheet gymnastics, and the audit trail stays clean because each booking is tied to a single payout date and amount.