Skip to main content

Reconcile the STRIPE bank line

Once the payout is booked, Payfriend matches the bank line automatically. How to verify it, what to do manually, and what bank fees and multiple currencies mean.

Written by Nicki Elgaard

Stripe typically pays out as a bank line with the text STRIPE or STRIPE PAYOUTS. Once the payout is booked under Settlements, Payfriend matches it to the bank line with the exact same net amount and a date within 5 days before or after arrival. The same applies to MobilePay payouts.

It happens automatically

In most cases you do not need to do anything manually:

  1. You book the payout under Settlements (under Bank in the sidebar).

  2. Payfriend looks for a bank line with the same net amount and a date within 5 days. The amount must match exactly. The text STRIPE is typical but not required if the amount and date are unambiguous.

  3. If it finds one, the match is linked automatically. The payout's bank status shows Matched.

If you have more than one active bank account, choose which account the payout lands in under Settings → Payment providers, the Connection tab, in the The payout lands in field. There is one field per payout account in Stripe. Otherwise we do not match when there are several accounts.

If the bank line is in a different currency from the payout, for example EUR on a DKK account, Payfriend matches on the bank's own conversion when the bank data has it. Otherwise we use the payout's converted value with a 2 % margin.

If the bank deducts a fee so the bank line is shorter than the payout, Payfriend can still match. This requires that you have set At most per payout and The fee is posted to for the payout account under Settings → Payment providers → Connection. The difference is then booked as a bank fee. This can only be set with e-conomic or Dinero.

This is Settlements' own match after booking. The bank's patterns (under Bank) are something else: they can auto-match similar lines later, once you have confirmed them manually a few times.

Before you match manually

  • The bank is connected. See Connect your bank.

  • The payout is booked under Settlements. A payout can only be linked to the bank once it is booked.

  • You compare the net on the voucher with the bank line (after Stripe's fee), in the same currency.

How to match manually

Use this if the auto-match did not hit:

  1. Go to Settlements → Payouts and choose Booked.

  2. Find the payout with Not reconciled in the bank column.

  3. Click Connect bank transaction and choose the STRIPE line with the same net amount. The bank line must be on the account the payout is mapped to, and the amount must be exactly the same.

  4. Confirm the link. To undo it, click Remove next to the linked bank transaction.

Alternatively: go to Bank → Unmatched, find the STRIPE line, and confirm it as the settlement. The booking itself still happens under Settlements.

Or from the payout details

Open a booked payout from Settlements → Payouts → Booked. Under Bank reconciliation in the details you see whether the line is linked. If it is not, it says why, for example that the bank has only been fetched up to a certain date, or which bank line is closest. You can also choose the right bank line here.

Check that it worked

  • The payout is Booked

  • The bank column is Reconciled, or you linked the line manually

  • The amount is net, in the same currency Stripe paid out in

Common problems

Symptom

Cause

Fix

No match

Not booked yet

Book under Settlements → Payouts → Needs you first.

Amount does not match

You are comparing with gross instead of net, or the bank deducted a fee

Use the net from the payout. The amount must match exactly, unless you have set a bank fee limit (see above).

Date is far off

The bank booked outside 5 days

Match manually. Auto-match only looks ±5 days.

The bank line is missing, and it says the bank has been fetched up to a date

The bank has not been fetched that far yet

Click Sync under Bank and wait for the next match.

More than one bank line could be the payout

Payfriend only links when there is exactly one

Choose the right bank line manually.

Multiple currencies

The bank converted the payout

Compare with the net in the currency Stripe paid out in, and match manually if the conversion deviates.

Wrong account

Several banks, no receiving account chosen

Choose The payout lands in under Connection.

See also

Did not find an answer? Write to us via the chat in the app, or at Contact. We reply on weekdays.

Did this answer your question?