Skip to content
Task, Accounting

Reconcile bank statements

You upload bank statements or connect your account, and match each bank transaction to invoices, suppliers or payouts.

Last updated: Accounting
Contents
  1. Before you start
  2. Set up bank account
  3. Import the bank statement
  4. Connect online banking
  5. Confirm suggestions
  6. Match manually
  7. Bank fees and split payments
  8. Payouts and returned direct debits
  9. How to check the result
  10. If something does not work

Before you start

  • You have the permission Manage accounting. With View accounting you can only view bank transactions.
  • The invoices you want to match are issued: Invoices.

The example uses the bank account “Hausbank”. Lukas Gruber left 249,90 € open at check-out and is transferring the amount. Booking.com also makes a payout.

Set up bank account

In STRYKAccountingPaymentsBank

Without a bank account, the header shows Set up your bank account.

  1. Select Set up bank account. The dialog states: STRYK only shows the last four digits of the IBAN afterwards.
  2. For the bank details of your invoices, select Use this account. The section is called From your invoice details.
  3. Or select Other bank account, enter the IBAN and the Account name, for example “Hausbank”. After a failed import, Read IBAN from bank statement reads the IBAN from the file.
  4. Select Create bank account.

You add further accounts in the More menu of the header with Add bank account. With several accounts, you select the account in the header.

Import the bank statement

In STRYKAccountingPaymentsBank

The header shows the account, the IBAN and “Balance per bank” with the date.

  1. Select Import bank statement and then the file. STRYK reads CAMT.052, CAMT.053 and CAMT.054 as XML or ZIP, MT940 and CSV.
  2. In the dialog Review bank statement, check the figures. STRYK imports New transactions. Already present is not imported twice. Needs review marks lines that resemble an existing transaction.
  3. For each line marked Needs review, select the Decision: Separate payment, import or Already present, do not import. For a separate payment, state the reason.
  4. Enable “I have matched the bank account with the statement” if STRYK cannot determine the account from the file.
  5. Select Confirm import. STRYK creates the booked transactions and shows them under Assign bank transactions.

If STRYK does not recognize the layout of a CSV file, Match bank columns opens. Select the Text encoding, the Separator and the Amount layout: One amount column, Separate incoming and outgoing or Amount with debit/credit indicator. Match the Booking date, the amount and the Payment details to the columns, and select Review transactions. STRYK recognizes export files from Raiffeisen (ELBA), Rabobank, ABN AMRO, OTP Bank, K&H Bank and MBH Bank automatically. For a CAMT file, STRYK checks the opening balance, the transactions and the closing balance.

  1. Bank account and balance
  2. Suggestion with reason
  3. Confirm
  4. Other match

Connect online banking

In STRYKAccountingPaymentsBank

With online banking, STRYK automatically takes over booked transactions. This applies to accounts in Austria and Germany.

  1. In the More menu, select Connect online banking. The window Connected bank accounts opens.
  2. Select Connect bank, then Country, Bank and a Display name, for example “Operating account”.
  3. Select Continue to bank and grant access at your bank. STRYK reports “Bank account connected.”
  4. Check Consent until. If access expires, select Renew access.

Use Synchronise now to fetch new transactions immediately. Pause stops the import, Resume continues it. Revoke withdraws the account access. Transactions that have already been imported are kept.

Confirm suggestions

In STRYKAccountingPaymentsBank

The list Assign bank transactions shows transactions in the filters Pending, Partly matched, Resolved, Ignored and All. For each open transaction, STRYK suggests exactly one next step, with a reason.

  1. Read the suggestion for Lukas Gruber's transaction: “Confirm: invoice RE-2026-0044, Lukas Gruber” with the reason, for example “amount and name are similar”. Clear match means that the invoice number and the amount match exactly.
  2. Select Confirm. STRYK posts the payment to the invoice. The transaction has the status Resolved.
  3. Optional: Above the list, select the button “Confirm all clear matches” with the count, to accept all clear suggestions at once.
  4. Optional: Select Undo if you want to withdraw a match. Withdraw matches of older transactions with Reverse allocation. STRYK creates a reversing entry.

Match manually

In STRYKAccountingPaymentsBank

If the suggestion does not fit, select Other match … in the row. Depending on the transaction, the menu offers:

EntryPurpose
Find another invoice …Assign an incoming payment to one or more open invoices. In the window Split bank receipt, select the invoices and enter the Payment amount for each invoice. Post Discount and Bank fee separately. Select Post allocation.
Find supplier invoice …Assign an outgoing payment to a supplier invoice: Supplier invoices
Book without an invoice …Book the transaction to an offset account
Transfer between your own accounts …Connect the counter-transaction on another hotel account. The entry appears when there are several accounts.
IgnoreTransaction that is not booked. The transaction is then listed under Ignored. Review again reopens it.

Bank fees and split payments

In STRYKAccountingPaymentsBank

For bank charges, STRYK suggests Book as bank fees for small debits with text such as “Account maintenance”. Direct postings go via Book without an invoice ….

  1. Select Book without an invoice … or Book as bank fees. The window Post bank transaction opens.
  2. Select the Offset account, if needed the Tax, Tax rate and Cost center, and enter the Posting text.
  3. Optional: Select Split and Add line to distribute the transaction across several accounts. Use remainder fills the rest. Remaining must be 0.
  4. Optional: Enable Remember as rule. STRYK will then suggest new matches. STRYK only books automatically on exact text and identical amount. The rules are in the More menu under Bank rules.
  5. Select Post definitively. For split postings, the transaction shows “2 postings”.

You reverse a direct posting with Reverse direct posting. STRYK then books the counter-entry.

Payouts and returned direct debits

In STRYKAccountingPaymentsBank

STRYK recognizes payouts from booking portals from imported payout files. In the More menu, select Import payouts and then the file (CSV, TSV, TXT or XLSX). For the Booking.com payout transaction, STRYK suggests “Confirm: payout from Booking.com”. Select Confirm.

If the bank returns a direct debit, STRYK suggests “Confirm: returned direct debit for invoice …”, together with the Possible bank fee. If the suggestion does not fit, select Assign as returned debit … and Add customer payment. The receivable becomes open again. STRYK books the bank debit and the fee separately. You maintain return codes in the More menu under Return codes.

Reversals of card payments are listed in the More menu under Card chargebacks.

How to check the result

  • If everything is matched, the list shows Everything is matched.
  • Matched transactions show Resolved. The invoice has the status Paid.
  • The header shows the balance per bank.

If something does not work

What you seeCauseHow to fix it
“Opening balance, transactions and closing balance do not match. Please export the complete CAMT statement again.”The balances in the CAMT file do not match the transactions.Export the complete statement again.
“No valid IBAN was found in this file.”The file does not contain a valid IBAN.Enter the IBAN manually when setting up.
“This IBAN is invalid. Please check your entry.”The IBAN has an incorrect format.Check your entry.
“This bank account is already set up.”The account already exists.Select the existing account in the header.
“This bank file is already assigned to another bank account. Check the existing import and the selected account.”You imported the statement to the wrong account.Select the correct account and import again.
“At least one line cannot be resolved here. The import is blocked; nothing was imported.”A line in the file conflicts with existing transactions.Check the statement, the account and similar transactions. Resolve the conflict and import again.
“The preview is no longer up to date. Please review the statement again.”The data has changed since the preview.Select the file again.
The window Connect online banking shows a notice about availability instead of the bank selection.The bank connection is not available for your hotel.Upload the bank statement as a file.
Questions about STRYK?