Skip to content

Bank matching

Bank matching connects your bank account with your finance lines. You import a statement from your bank, OPERO lists every transaction on Finance › Payments and suggests which expense or income it pays. When you confirm a match, OPERO records the payment on that line, so its Paid, Outstanding and status are right without typing anything.

  1. Import: you download a statement from your online bank as a CAMT XML file or a CSV export and import it on Finance › Payments. Each booking on the statement becomes a bank transaction with the status Unmatched.
  2. Suggest: right after the import, OPERO looks for the expense or income each transaction pays. A transaction with a good candidate becomes Suggested.
  3. Confirm: you open the transaction, check the suggestion (or search for the right line yourself) and confirm. The transaction becomes Matched.
  4. Payment: confirming records a payment on the line (source Bank Sync), dated on the bank date. The line’s Paid, Outstanding and status update at once.

Money out (a debit on the statement) is matched to expenses; money in (a credit) to incomes.

  • You need Full access or Finance access.

  • Get the statement from your online bank in one of these formats:

    • CAMT (ISO 20022 XML, often called camt.053, camt.052 or camt.054). Most banks offer it in their statement export.
    • CSV exported from Swedbank, SEB or Revolut.

    OPERO recognises the format from the content of the file, not from its name. PDF and Excel statements, and CSV files from other banks, cannot be imported.

  • Make sure the expenses and incomes you expect to be paid are in OPERO, with their Actual and VAT. OPERO can match only lines that exist.

  1. In the sidebar, under Finance, select Payments. Then select Upload Statement at the top right. The Import statement panel opens.

    The Import statement panel: the Bank account chosen, the Statement file (CAMT XML or CSV) box with browse, and the Import history below.The Import statement panel: the Bank account chosen, the Statement file (CAMT XML or CSV) box with browse, and the Import history below.
  2. Choose the Bank account the statement belongs to. The first time, there is none yet, and the panel says No bank accounts yet — add one below. Add the account:

    • Bank: Swedbank, SEB, Luminor, Revolut, Paysera or Other.
    • Account name: optional, for example “Main account”. It names the account in the lists.
    • IBAN: the account number.
    • Select Save account. The account is now chosen.

    To add another account later, choose “+ New account” in the Bank account list.

  3. Drag the statement file into the Statement file (CAMT XML or CSV) box, or select browse and choose it.

  4. OPERO reads the file and shows how many transactions it holds, the IBAN in the file and the period. Check that the IBAN is the account you chose. The button at the top now reads, for example, “Import 2 transactions”.

  5. Select the import button.

OPERO shows “Imported 2, 0 duplicates skipped” and “Matching runs in the background — the list updates in a moment.” Below, Import history lists your earlier imports with their period, how many transactions were imported or skipped, and Success, Partial or Failed. The panel closes by itself after a few seconds.

Things to know about the import:

  • No duplicates. OPERO recognises each booking by the bank’s reference number. A CSV row without a reference gets one made from its date, amount and text. If you import a statement that overlaps an earlier one, the bookings already in OPERO are skipped and counted as duplicates. So you can safely import the same period twice.
  • Choose the right account. If the IBAN in the file belongs to a different account, OPERO does not import it and says “This statement is for account …, not the one selected.”, with the IBAN from the file. Choose the right account and try again.
  • Nothing is matched yet. The import creates bank transactions only. No expense, income or payment changes until you confirm a match.
  • If OPERO cannot read the file, it shows “Import failed” with the reason, and the history lists the import as Failed. The reasons are: “The file is empty.”, “No booked transactions were found in this file.”, or, for a CSV from another bank, “This CSV layout is not recognised (Swedbank, SEB and Revolut exports are).” followed by the first line of the file.

Bank transactions appear in the same list as the payments you recorded by hand. To see only them, choose Bank in the Source filter. Each row shows the Counterparty and Description from the statement, the Amount (red − for money out, green + for money in), what it is Matched to (or what OPERO suggests, in grey) and the Status.

Status What it means
Unmatched Not matched yet, and OPERO has no strong suggestion.
Suggested OPERO found a likely line (a match of 70% or more), or proposes creating a new one. Nothing is recorded yet.
Partial Matched, but only part of the amount is allocated to lines.
Matched The full amount is allocated. The payments are recorded.
Ignored You set it aside: it needs no line (for example a transfer between your own accounts).

Select a transaction to open it. The panel shows its Amount, Status, Date, Counterparty, Description and the Account, and two tabs: Match and Activity (what happened to it, and who did it).

The Payments page with an Unmatched bank transaction open: Amount −181,50 €, Status Unmatched, the date, Counterparty Harbour Print Studio, Description, Account Main account, and the Match tab with the search box, Allocated 0,00 € of 181,50 € and Remaining 181,50 €.The Payments page with an Unmatched bank transaction open: Amount −181,50 €, Status Unmatched, the date, Counterparty Harbour Print Studio, Description, Account Main account, and the Match tab with the search box, Allocated 0,00 € of 181,50 € and Remaining 181,50 €.

For each transaction, OPERO looks at the expenses (for money out) or incomes (for money in) that are Unpaid or Partial and whose outstanding amount is within 25% of the transaction amount. It scores each one:

  • the amount counts most: the closer the outstanding amount, the higher;
  • the name: the supplier’s or client’s name appearing in the bank text;
  • the date: lines dated within 60 days of the transaction get a little extra.

OPERO also remembers your earlier matches: when you confirm a match, it learns the counterparty, and later transactions from the same counterparty point to similar lines. Recurring lines are always candidates.

If no line fits, OPERO asks the AI. The AI may suggest a line, or propose creating a new expense or income (“AI suggests creating”).

Lines that are already Overdue are not suggested automatically. Find them with the search (see below).

If you add the missing expenses after the import, OPERO checks the unmatched transactions again for each new line. To check all unmatched transactions again at once, select the round-arrows button at the top of the Payments page, then Start re-matching. It runs in the background and can take a few minutes; it may use the workspace’s AI allowance.

  1. Open the transaction (start with the Suggested ones: use the Status filter).

  2. On the Match tab, select the search box. Under Suggested, OPERO lists its best candidates (up to three) with the share of the match, for example 100% match, and the outstanding amount. Below them are other open lines, grouped by Events, Tours and Overhead.

    The Match tab of a bank transaction with the search box open: under Suggested, the Marketing expense of an event with 100% match and 181,50 €, then other open expenses.The Match tab of a bank transaction with the search box open: under Suggested, the Marketing expense of an event with 100% match and 181,50 €, then other open expenses.
  3. Select the right line. If it is not listed, type in the search box: a category, supplier or client, event or venue name, notes or an exact amount.

  4. The line moves under Allocate to, with an amount: its outstanding amount, but never more than what is left of the transaction. Allocated and Remaining show how much of the transaction is covered.

    The Match tab with one expense under Allocate to and 181,50 € in its amount box, Allocated 181,50 € of 181,50 €, Remaining 0,00 € and the Confirm button.The Match tab with one expense under Allocate to and 181,50 € in its amount box, Allocated 181,50 € of 181,50 €, Remaining 0,00 € and the Confirm button.
  5. Select Confirm →. It works only when the whole transaction is allocated (Remaining is 0,00 €).

The transaction becomes Matched. The Match tab now shows Matched to with the line, its event and the amount, and Total allocated. Select the line to open it.

A Matched bank transaction: the Match tab shows Matched to with the Marketing expense of an event and 181,50 €, and Total allocated 181,50 €.A Matched bank transaction: the Match tab shows Matched to with the Marketing expense of an event and 181,50 €, and Total allocated 181,50 €.
  • OPERO records a payment on the line: the allocated amount, dated on the bank date, method Bank Transfer, source Bank Sync, with the bank’s reference number as its reference and the bank text as its note.
  • Paid and Outstanding update, and so does the status: Paid if the line is now fully paid, otherwise Partial (or Overdue if its due date has passed).
  • The payment shows on the line’s Payments tab and counts in every total, like any payment.
The matched expense on its Payments tab: Status Paid, Outstanding 0,00 €, and one payment from Bank Sync for 181,50 €.The matched expense on its Payments tab: Status Paid, Outstanding 0,00 €, and one payment from Bank Sync for 181,50 €.

One bank payment can cover several invoices, for example a supplier paid for three events at once.

  1. Open the transaction and select several lines, one after the other. Each one appears under Allocate to with its own amount.

  2. Change the amounts so that they add up to the transaction. An amount above a line’s outstanding amount turns orange: “More than outstanding — a partial overpayment”.

  3. Select Confirm → when Remaining is 0,00 €.

If only part of the transaction belongs to the lines you know, select Save as partial (it appears while something remains). The transaction becomes Partial, and the Match tab shows how much is “not allocated yet” with Allocate now to continue later.

To match several transactions to the same line, tick them in the list. The panel of the first one opens and shows “Mass allocation” with the number of transactions and their total. Choose the line and select the apply button (“Apply to 3 payments …”). Tick money in or money out only, not both: OPERO says “Select one type only — either Income or Expense payments, not both.”

If the transaction pays something that is not in OPERO yet (for example a bank fee):

  • When OPERO proposes it, the Match tab shows “AI suggests creating” with the category and the reason. Select the Create Expense button (or Create Income).
  • Otherwise, in the search, select “Create new Expense” at the bottom of the list.

The new expense form opens, filled in from the transaction: the amount, the date, the bank text as notes, and the counterparty as supplier (or client). The VAT rate starts at 0%, because a bank amount does not show VAT: choose the right rate if the amount includes VAT. Choose the category and the reference and select Save. OPERO creates the line and matches the transaction to it in one step: the transaction is Matched and the line is paid.

Open the matched (or partial) transaction and select Unmatch at the bottom of the panel. OPERO:

  • deletes the payments it recorded for this transaction,
  • works out Paid, Outstanding and the status of the lines again,
  • sets the transaction back to Unmatched, keeping its suggestion.

The lines themselves are not deleted, also not a line you created from the transaction.

To undo several matches at once, tick the transactions and select Unmatch in the bar that appears. OPERO asks for confirmation first.

Some transactions need no line: a transfer between your own accounts, a refund already handled, a private payment. Open the transaction and select Ignore. It becomes Ignored and drops out of the work list (it stays in the list; filter the Status by Ignored to see it). To bring it back, open it and select Restore: it returns as Unmatched, with its suggestion. You can also ignore or restore several ticked transactions at once.

Ignoring a matched transaction does not record or delete payments, except for ticket-platform payouts, whose payments are removed.

When a ticketing platform pays out the sales of several events in one transfer, and its contract with your bank account is set up in OPERO, the suggestion is a split: one transfer divided over the ticket-sales income of each event in the payout period. Check the amounts, select Edit amounts to change them, and Confirm.

  • Import often, for example every week. Small statements are quicker to check.
  • Enter invoices as expenses when they arrive, with their due date. Then the bank payment finds them, and overdue lines show up in time.
  • Keep supplier names as they appear on the bank statement. The name counts for the match.
  • Matching never changes the amount of a line. If the bank amount differs (bank fees, a different exchange rate), allocate what was paid and leave the rest outstanding, or correct the line.