Bank reconciliation
Create or connect bank accounts, import statements, review suggestions and match bank transactions safely
→ Open bank reconciliation in SimpliServ
Bank reconciliation links bank transactions with invoices, purchase invoices, payments and other documents. SimpliServ suggests matches from documents, booking rules and earlier matches; you confirm, ignore or correct them.
The area requires Accounting → Bank → View. Creating accounts, importing, connecting a bank and changing matches additionally require Accounting → Bank → Manage.
Creating a bank account
Create the account
Open Accounting → Bank reconciliation and click Add bank account. Choose the Account type: Bank account or Credit card.
Enter the master data
Enter a Name, for example “Business account main bank”, and the IBAN plus optional BIC. The IBAN must match the bank statement, otherwise the import is rejected.
Ledger account and opening balance
Choose the Ledger account that incoming and outgoing payments of this account are posted to. Without a choice, the bank account from the account mapping applies. Optionally enter Opening balance and Opening date.
Control matching and save
Small difference tolerance sets up to which amount differences are suggested as small differences. Confirm exact invoice matches automatically only confirms matches when the invoice number is in the reference text and the open amount matches exactly. Save the account.
A bank account can only be deleted while no transactions have been imported. For historical accounts switch off Active.
For a credit card you also enter the card issuer, last four digits, cardholder and the bank account the monthly settlement is debited from. Import the statements on the card's detail page; the monthly debit is matched to the statement automatically.
Getting transactions into SimpliServ
Import a statement: click Import statement, choose the bank account and upload the file. SimpliServ detects CAMT (052, 053, 054), MT940 and CSV; CAMT.053 is recommended. After the import you see how many transactions are new and how many were skipped as duplicates. Uploading again therefore never creates double postings. Pending items from CAMT.052 are kept separately and can be matched once the bank books them.
Connect a bank: Instead of uploading files, you can connect bank accounts automatically, through open-banking.io or, where available, directly at the bank.
Connecting through open-banking.io
open-banking.io is a licensed account information service (through Enable Banking) and the default way to connect automatically. You create the open-banking.io account yourself; open-banking.io bills its fee to you directly, currently about €3 per month for the first bank account and €1 for each additional one.
open-banking.io is set up under Settings → Integrations, not on a single bank account. You don't need to create a bank account in SimpliServ first.
Connect your bank at open-banking.io
Create an account at open-banking.io and connect your bank there. Then create an API key under Developers, and only then export the credentials file credentials.json. If the file has no API key, SimpliServ tells you when you upload it.
Upload the file in integrations
Open Settings → Integrations → open-banking.io, tab Configuration. Upload the file under Upload credentials.json and click Connect. In bank reconciliation, Connect bank takes you there too.
Accounts are connected and created
SimpliServ connects every account from open-banking.io. If a bank account with the same IBAN exists it is used, otherwise SimpliServ creates it automatically (name and IBAN from open-banking.io, posted through the default bank account). The first fetch starts right away, and the accounts appear under Connected accounts with status Connected.
If you add an account at open-banking.io later, click Refresh accounts; the stored credentials are reused. Only upload a new credentials.json to replace the credentials. Disconnect all disconnects all open-banking.io accounts at once; the bank accounts and fetched transactions are kept.
Connecting directly at the bank
Where a direct bank connection is available, click Connect bank on the bank account, choose Directly at the bank under Connection, then country and bank, and click Continue to bank. You are redirected to your bank for approval and then come back to SimpliServ.
Automatic fetching, approval and disconnecting
- SimpliServ fetches the transactions of connected accounts automatically three times a day (6 am, 12 pm and 6 pm), including pending ones. Banks allow only a few automatic fetches per day; if the bank returns nothing right now, sync the account once yourself in open-banking.io. Fetch now fetches them immediately.
- The bank approval lasts about 90 days. When it expires, the status shows Approval expired with the hint Renew the approval in open-banking.io, then click “Fetch now”. Renew the approval through Reconnect in open-banking.io in open-banking.io and then click Fetch now. The same hint appears for Error.
- Disconnect stops automatic fetching and removes the stored credentials. Transactions already imported are kept. The status then shows Disconnected.
The Imports tab lists all imports with file, format, period and counters. You can roll back an import there as long as none of its transactions has been matched.
Understanding the transaction status
| Tab | Meaning |
|---|---|
| Suggestions | SimpliServ found a matching document, rule or earlier match, but you have not confirmed it yet. |
| Open | No match yet. |
| Clarification | Unclear; the amount sits on the suspense account and waits with an assignee and a note. |
| Matched | Match confirmed and posted. |
| Ignored | The transaction is kept but not posted. |
Use the account selector to review several bank accounts separately. The Balances tab compares, per bank account, the book balance of the ledger account with the statement balance.
Reviewing and confirming a suggestion
Open a transaction and compare date, counterparty, reference and amount with the suggestion. If it fits, click Confirm. The transaction moves to Matched and the payment is posted. In the Suggestions tab, Confirm all suggestions confirms the whole list at once.
Only confirm a suggestion if amount and document really belong together. A wrong match distorts open items and account balances.
Matching manually
Assign… opens Assign transaction. There you split the amount across one or more documents (open invoices and purchase invoices, payments or expenses already recorded, direct-debit payment runs, payouts from payment providers) or post to an account without a document. If a remainder is left, you decide what it is: cash discount, bank fee, small difference, exchange-rate difference, credit or partial payment. Confirming is possible as soon as nothing remains.
- Create expense with receipt creates an expense directly and links it to the transaction.
- Save as rule saves the match as a booking rule so the same transactions are suggested automatically in future.
- AI suggestion lets the AI suggest a match.
No suggestion or a wrong one
- Find match checks documents, rules and history again, for example when a matching document now exists. In the Open tab, Search suggestions again does this for all transactions.
- Ignore parks private or irrelevant transactions with a reason, such as “duplicate transaction” or “private, not business”. Restore brings them back.
- Move to clarification… posts an unclear amount to the suspense account so the bank balance is right, and records who takes care of it.
- Undo removes a confirmed match when you need to correct a mistake.
Monthly reconciliation workflow
Get all transactions
Import the full period or fetch from the connected bank. Duplicate detection makes a repeated import safe.
Work through suggestions
Review Suggestions first, then Open. Safe matches are posted quickly that way.
Check suspense and ignored items
Resolve Clarification and check in Ignored that the reasons make sense.
Compare balances and open items
Check under Balances that book and statement balance agree, then the open items, before you export or lock a period.
Related topics
How is this guide?