Skip to content

Member bank matching, IBANs and cash received

For members with an administrative subscription: record IBANs, let bank lines book installments automatically (Off, Preview or On), record cash and see the monthly payment overview.

Updated: October 7, 2026

If members pay their fee themselves by bank or in cash, you do not have to mark every installment by hand. Record their IBAN; a bank line from that account then settles the oldest open installment, or becomes a suggestion you confirm.

Where to find it

  • Setting and suggestions: Sidebar → Finance → Finance → Money → Bookkeeping → Reconciliation, panel "Members with an administration subscription".
  • IBANs and cash per member: Subscriptions → click the member → blocks Account numbers and Cash received.
  • Overview: Subscriptions → Members lens → Member payment overview.

Who can do this

Permission Manage billing (manage_billing). It only works for users with the member role and a subscription with payment mode Administrative. Parents, manual and automatic (Stripe) subscriptions, one-time payments and donations are not included.

Setting up

  1. Assign the members a plan with payment mode Administrative (see Subscriptions: plans, class fees and assigning).
  2. Record IBANs: per member via Account numbers, or all at once via "Import member IBANs (CSV)" in the reconciliation panel (columns Member number or Name, IBAN, optional Account holder).
  3. Under Book automatically choose Off (default), Preview (suggestions only) or On. Start with Preview: you see what "would book automatically" without anything happening.
  4. Import your bank statement as usual (Bookkeeping → Import).

Step by step: handle suggestions

  1. Open the panel in Reconciliation. Click Auto-match all or go through the Suggestions.
  2. If needed choose the member ("Choose member") and installment(s), optionally tick "Remember IBAN for this member" and click Confirm. Already marked the installment by hand? Choose "link to existing booking".
  3. Linked wrongly? Unlink opens the installment again.

Automatic booking only happens when everything fits: one member, one subscription, the amount matches the oldest open installment(s) exactly, no collection entry and no chargeback. Everything else becomes a suggestion. A chargeback reopens the installment.

Step by step: cash received

  1. Open the member → Cash received → book cash.
  2. Choose the cash account, installment(s) and date and confirm. The installment is marked paid and one line goes into the cash book. You can undo it.
  3. When you take the money to the bank, announce the deposit under Money → Accounts; the bank line is then linked automatically.

I can't see it / it doesn't work

  • "There is no cash account yet." Create an account of type cash under Money → Accounts.
  • A bank line is not booked automatically. Is the setting On? Is the IBAN known for exactly one member? An IBAN shared by several members, a collection entry or a different amount always becomes a suggestion.
  • The Account numbers block is missing. The user does not have the member role or no administrative subscription.

Frequently asked questions

Do I see the full IBAN? It is masked in the list; "show full" reveals it.

Can I show the payment overview on a TV? Yes, with the "Contribution screen" widget screen (Data & Content → Widget Screens).

Was this article helpful?