Skip to content
Try STRYK

Bank reconciliation: import statements and match transactions

Bring bank transactions into STRYK, confirm the suggested matches and book bank fees, split payments and transfers between your own accounts.

4 min readAccounting → Payments → Bank transactions
What you can do safely afterwards
  • You import a statement once, without duplicates.
  • You confirm clear suggestions in one step and check the rest individually.
  • You book bank fees, partial payments and split transfers correctly.
What you need before starting
  • The bank account is set up with its IBAN, and you have the statement file or a connected online banking.
  • Importing and confirming matches require finance management permission.
01

Import the bank statement

Choose “Import statement”. Before anything is booked, STRYK shows a preview of the file.

Supported files

  • CAMT.052, CAMT.053 and CAMT.054 (XML or ZIP)
  • MT940
  • CSV: map the bank columns once (booking date, amount or debit and credit, bank reference)

Check the preview

  1. 01
    Read the groups

    The preview separates “New transactions”, “Already present” and “To check”.

    You know how many rows are new.
  2. 02
    Decide rows to check

    For each row under “To check”, choose whether it is already present or a separate payment.

    No row is left undecided.
  3. 03
    Confirm

    Choose “Confirm import”.

    Only new transactions are added; “Imported statements” lists the file.
02

Connect online banking

With “Connect bank”, STRYK fetches transactions regularly after you approve the access at your bank. “Sync now” fetches immediately. When the bank asks for a new approval, STRYK shows “Renew approval”.

03

Confirm suggestions

For each incoming payment, STRYK suggests the target and shows why: invoice number in the reference, amount exactly the same, name matches. Check the target and choose “Confirm”.

Suggestions marked “Clear match” have the invoice number in the reference and the exact amount. “Confirm all clear matches” confirms them in one step. Every confirmation can be undone.

Open bank transactions with the suggested target and the reason. Clear matches can be confirmed together; a bank charge is suggested as bank fees.

Match Monday's statement at Hotel Nordlicht

  1. 01
    Import

    Import the CAMT.053 file of Monday and choose “Confirm import”.

    The new transactions appear under “Open”.
  2. 02
    Confirm clear matches

    Choose “Confirm all clear matches”.

    The matched invoices show “Paid”.
  3. 03
    Check the rest

    Choose “Confirm” for each remaining suggestion, or “Other match”.

    The filter “Open” is empty.
04

Allocate manually

If the suggestion is wrong or missing, “Other match” offers these targets. “Remember as rule” books similar transactions the same way in future.

Other match

  • Search another invoice or a supplier invoice
  • Allocate as direct debit return
  • Book without invoice, with counter account and tax rate
  • Transfer between own accounts
  • Ignore; can be checked again later
05

Bank fees and split payments

For charges of your bank STRYK suggests “Bank fees”; choose “Book as bank fees”, no invoice is needed. If one transfer pays several invoices or less than the invoice, use “Split incoming payment”: enter the paid amount per invoice and, if applicable, a discount or bank fee with a reason.

Which allocation for which transaction
TransactionAllocation
Guest pays invoice in fullConfirm the suggestion
Company pays three invoices with one transfer“Split incoming payment”
Monthly account fee“Book as bank fees”
Payment to a supplier from a payment runConfirm the suggested supplier invoice
Transfer to the savings accountTransfer between own accounts
Payout of a payment provider or booking platformConfirm the suggested payout
06

Payouts and direct debit returns

Payment providers and booking platforms pay out many guest payments at once, minus fees. Import their file with “Import payouts”; STRYK then assigns the individual payments. A returned direct debit reopens the invoice and books the bank fee with it.

Final review

Every bank transaction is matched once, and the balance in STRYK matches your bank.

  1. 01All statements up to yesterday are imported.
  2. 02No open transaction is older than three days.
  3. 03Bank fees are booked as bank fees, not as expense documents.
  4. 04The bank balance in STRYK matches the statement.

Common mistakes and the right solution

Problem

A statement is imported twice.

Solution

Rows already present are recognised. Mark rows under “To check” as separate payments only if they really are.

Problem

A transfer was recorded by hand and now appears on the statement too.

Solution

Confirm the transaction against the existing payment instead of booking it again.

Problem

One transfer for several invoices is assigned to only one invoice.

Solution

Undo the confirmation and use “Split incoming payment”.

Useful next guides

See STRYK in your hotel workflows.

In a personal consultation, we walk through bookings, housekeeping, pricing and finance with you.

Try STRYKRequest demo access
Questions about STRYK?