Payment reconciliation for hotels
Hotel payment reconciliation: import the bank statement, match the payments
STRYK reads your bank statement as a file and suggests which transfer belongs to which open invoice. Your back office confirms every match.
- Import as CAMT.053, CAMT.052, CAMT.054 or CSV
- Match suggestions for open invoices
- Your back office confirms every match
In short
Payment reconciliation means comparing your hotel's bank transactions with its open invoices. For this, STRYK imports bank statements as CAMT.053 (plus CAMT.052 and CAMT.054) or CSV and suggests matches to open invoices. There is no bank connection; the statement comes in as a file. Bank import is included in the core price: the base price plus the per-room amount.
Updated
Where reconciliation gets stuck in the back office today
If you check transfers against the bank statement with a highlighter and Excel, you end up searching: short payment references, bundled payments, the list of open items.
- Today
A company paid a deposit for the November conference three weeks ago. The statement only says "Inv 2210 Nov". The back office scrolls through two months of statements to assign the payment to the right booking.
With STRYKYou import the bank statement as a file. STRYK compares the transactions with your open invoices and shows a match suggestion for each payment. The back office checks it and accepts or corrects it.
Read more - Today
A company pays four monthly invoices in one sum, with one payment reference and a rounded amount. Nothing on the statement matches a single invoice, so someone does the sums on a calculator.
With STRYKThe payment appears with amount, date and reference next to the customer's open invoices. You see all candidates on one screen and decide which invoices the sum covers.
Read more - Today
The open items sit in an Excel list alongside the hotel software. A guest pays on Friday, the list is only updated on Monday, and the reminder goes out anyway.
With STRYKInvoices and payments are in the same system. Whoever opens an invoice sees whether a payment has been recorded against it. The second list goes away.
Read more
One bank statement, three special cases at Hotel Nordlicht
Hotel Nordlicht has 24 rooms, an owner and a back office that reconciles bank statements twice a week. This is what a Tuesday looks like.
Download the statement from online banking
The back office exports the statement for the last few days from online banking at the hotel's bank. Which format is offered depends on the bank. CAMT.053 is common; CSV works too.
Import the file into STRYK
The file is uploaded in Finance. STRYK reads in the transactions and lists them with date, amount, payer and reference. This does not connect to the bank account.
Review the suggestions
For the transactions, STRYK shows match suggestions for open invoices. The company's deposit matches an invoice from the booking, and the back office accepts it after a look at the reference.
The team decides on a combined payment
One transfer covers several invoices from a travel agency. The back office sees the total next to the open invoices and decides how it is split. If a transaction is unclear, the invoice stays open.
Go through the open invoices
The owner asks who has not paid yet. The back office opens the invoices in the system instead of keeping an Excel list, and contacts only the customers who have not paid.
Journal for the accountant
The month's invoices and bookings go to the accountant as a DATEV, BMD, CSV or Excel journal, with a document pack on request. The statement itself stays in your online banking.
What STRYK brings to payment reconciliation
From the transfer to the accountant, every step sits in the Finance area of STRYK.
Bank import from file
Upload bank statements as CAMT.053, CAMT.052, CAMT.054 or CSV. For the transactions, STRYK shows match suggestions for open invoices. Nothing is booked without your confirmation.
Read moreInvoices with payment status
Each invoice shows which payments are recorded against it. Nobody changes an issued invoice; corrections go through a credit note or cancellation, not overwriting.
Read moreOnline payments from guests
When a guest pays online, the payment runs through your hotel's online payment account. Which payment methods are available depends on what is enabled in that account. Bank transfer is not a payment method in online checkout; such payments show up on the bank statement.
Read moreMonthly journal with document pack
At month end STRYK creates the journal for your accountant as DATEV, BMD, CSV or Excel, with a document pack on request. Your accountant receives the data without you having to collect receipts one by one.
Read more
Payment reconciliation with and without a connected system
The difference is the number of lists your back office keeps side by side.
| Task | With highlighter and Excel | With STRYK |
|---|---|---|
| Find incoming payments | Print the bank statement, search for the amount, tick it off with a highlighter. | Import the statement as a file, read the transactions with match suggestions. |
| Match a deposit to a booking | Compare the reference by hand with the booking number, company name or guest name. | The suggestion points to an open invoice. The back office confirms it or picks another. |
| Combined transfer | Split the total across several invoices in your head or in Excel. | The payment and the customer's open invoices sit side by side; the team decides the split. |
| Overview of open invoices | An Excel list next to the hotel software that always lags behind actual payments. | Invoices and recorded payments in the same system. |
| Correct an invoice | Overwrite the file, two versions in the archive. | The issued invoice stays unchanged; corrections are made by credit note or cancellation. |
| Documents for the accountant | Collect statements, invoices and receipts by email or in folders. | Monthly handover as a DATEV, BMD, CSV or Excel journal, with a document pack on request. |
One price that grows with your property
Bank import is one of the core accounting features and costs nothing extra. Fees charged by your bank and a payment provider are not part of the subscription.
Pricing in detail€59 base fee + €6 per room or unit per month
Example with 18 rooms€167per month
- 14-day free trial
- No setup fee
- Personal onboarding
Net prices, annual billing. 20% off the base fee in the first contract year.
How to start with the bank import
The import needs a file from your online banking and open invoices in the system.
Check the format in online banking
Check whether your bank offers the statement as CAMT.053 or CSV. The choice is made by the bank and your online banking, not by STRYK.
Get open invoices into the system
If your invoices are currently in Word or Excel, we migrate the data when you switch, on a fixed cut-off date. The import from CSV, XLSX and ZIP is guided.
Import a first statement
Upload a statement from the last few weeks and review the match suggestions. Confirm only what matches the reference.
Involve your accountant
Agree with your accountant whether they prefer DATEV, BMD, CSV or Excel and whether a document pack should be included.
Frequently asked questions
Is STRYK directly connected to my bank account?
No. STRYK only reads bank statements from a file that you download from your online banking. There is no automatic bank sync or account link. You do not enter your bank login details in STRYK.
Which file formats can I import?
CAMT.053, CAMT.052, CAMT.054 and CSV. CAMT.053 is the usual daily statement in XML format. Your bank decides which format you receive. If in doubt, ask the provider of your online banking which export is available.
What happens with a combined transfer for several invoices?
Your team splits it. STRYK suggests matching open invoices, and the back office assigns the payment to the invoices it covers. If a transaction does not clearly match one invoice, it stays open until you assign it yourself.
How are online payments matched?
An online payment belongs to the booking the guest paid for from the start. It runs through your hotel's online payment account; the payout from the payment provider later appears on the bank statement as a combined amount. Agree with your accountant how to book that payout. With integrated online payment, the STRYK platform fee also applies; details are on the pricing page.
How does the reconciliation reach the accountant?
Through the monthly handover as a DATEV, BMD, CSV or Excel journal, with a document pack on request. Your accountant receives the data in the format they read. Which accounts and chart of accounts they use, you agree with them.
Do I have to confirm every match?
Yes. STRYK suggests, you decide. If a reference does not match an invoice, the invoice stays open until you assign the payment yourself.
How often should I import bank statements?
As often as your back office reconciles; at Hotel Nordlicht that means two fixed dates a week. What matters is a current statement before every payment reminder, so that no guest receives a reminder for an invoice they have already paid.
Book a demo with your bank statement
Bring an anonymised statement and two open invoices. We will show you how STRYK matches them. The request is non-binding.