Set up bank reconciliation

BETA

Please be aware that each bank connection you set up comes with a cost.

Overview

Bank reconciliation automatically matches the payments that arrive in your business bank account against your open offline payments in Frisbii, so you don't have to check your bank statement against unpaid invoices by hand. It's built for merchants who use offline payment methods, such as bank transfer.

You give each invoice a unique reference (for example, the invoice number). The customer writes that reference in their bank transfer, and Frisbii connects the two the moment the money lands in your bank account — no manual tick-off required.

Setup at a glance

Before any matching can happen, you set up three building blocks. The reconciliation configuration is the piece that ties them together.

Before you begin

• You have permission to manage bank reconciliation on your Frisbii account.

• You have online banking access for the business bank account you want to connect.

• You have an offline payment agreement (such as bank transfer) already configured, and it's active.

Connect a bank account

1. Navigate to Configurations → Finance and accounting → Bank Connections.

2. Connect bank account: Click on Add Connection.

3. Select your bank's country, and how long the connection should be valid. The validity period is required for security reasons — it's your consent for Frisbii to read the account's transactions, not a one-time permission.

   For real banks, a typical validity period is 180 days, and you can request anywhere from 1 to 365 days — but the bank's own maximum consent period always wins if it's lower than what you request.

   

4. Log in with your bank — You're redirected to your bank's own login page.

   Authenticate with your bank and grant consent to share account and transaction data.

5. Return to Frisbii — You're redirected back automatically.

   A confirmation page appears, and you're returned to the bank connections overview.

When the connection is complete, your bank account appears in the connections table with the status Active.

Manage your bank connections

• View all active and revoked bank connections on the same page.

• Select Renew to extend a connection before it expires.

• Select Revoke to disconnect a bank account, or revoke all connections at once. Revoking stops Frisbii from reading further transactions from that account.

• Select Delete on a revoked connection to remove it. Deleting is a soft delete — the connection history is retained.

Connection status: active, expired, or revoked

A bank connection is a time-limited consent you gave your bank. It doesn't last forever, and matching only works while the connection is Active.

To get matching running again:

• Expired connection — Open the connection and select Renew. The linked configuration resumes automatically.

• Revoked connection — You can't renew it. Create a new bank connection instead, then edit your reconciliation configuration to point at the new connection.

Add a reference tag to your offline payment agreement

Before you can enroll an agreement for reconciliation, its payment instructions need a reference tag. This is what your customer copies into their bank transfer, and what Frisbii searches for on the bank statement line.

1. Navigate to Checkout management → Payment methods → Offline Payments.

2. Open the offline bank transfer agreement you want to use for reconciliation, and make sure it's active.

3. In the payment instructions, click the tag icon and insert one of the following reference tags. If more than one is available on an invoice, Frisbii uses them in this priority order:

Example instruction:

"Please transfer to bank account 1234-5678, use invoice no.: {{invoice.handle}}"

Renders as:

"Please transfer to bank account 1234-5678, use invoice no.: inv-123456"

Enroll an offline agreement for reconciliation

Once your bank account is connected and your agreement has a reference tag, link them together so Frisbii knows which invoices to match against.

1. Reconciliation configurations — Open the configuration list.

   Navigate to Configurations → Finance and accounting → Bank connections → Reconciliation Configurations.

2. Add configuration — Choose the offline agreement and the bank account to link it to.
   If you don't have any offline payment agreement set up yet, you can click the link and get directed to the payment methods setup page.

   

3. Set the matching options for this configuration:

When the configuration is saved, it starts running on the regular reconciliation schedule.

Strict vs. Flexible matching, explained

Both modes are case-insensitive, and both only match the reference as a whole, standalone token — a reference is never matched inside a longer number (for example, inv-001 never matches inv-0012).

Use Strict if your customers reliably copy the full reference. Use Flexible if they tend to drop dashes and spaces, or paste just the number.

Manage a reconciliation configuration

• Enable or disable a configuration to pause or resume automatic matching without deleting it.

• Select Synchronize to run matching immediately, outside the regular schedule. Only active configurations can be synchronized.

• Select Delete to remove a configuration.

How bank reconciliation works

1. Frisbii periodically fetches new bank statement lines from your connected account.

2. For each configuration, Frisbii checks your open (unpaid) offline invoices and tries to match them against the new statement lines by amount, currency, and reference.

3. When a match is found, the outcome is recorded and the invoice's transaction is updated from Open to Matched (or, if no match ever arrives, to Closed).

4. The reconciliation outcome also appears directly on the transaction's detail view.

Three things must line up for an automatic match:

1. The reference on the invoice appears in the bank statement text.

2. The amount matches exactly.

3. The currency matches exactly.

Amount and currency are always a hard requirement — the match strategy (Strict or Flexible, set on the reconciliation configuration) only controls how forgiving the reference text matching is.

Reconciliation states on a transaction

The grace period comes from the offline agreement; if none is set, it defaults to 1 day after the due date.

View reconciliation outcomes

Navigate to Payments → Bank Reconciliation to see a read-only overview of reconciliation outcomes. This page lists individual matching results, not your bank connections — to manage connections or configurations, use Configurations → Finance and accounting → Bank connections instead.

Use the filters above the table to narrow results by date range, state, rule, transaction ID, or configuration ID.

In the Transaction list, you can filter transactions by bank reconciliation status (None, Open, Matched, Closed).

Constraints and limits (quick reference)

Common errors and how to resolve them

Test bank reconciliation with the Demo provider

You don't need a real bank to try reconciliation end to end. In a sandbox environment, the Demo provider simulates a bank so you can see matching happen without moving real money.

There's no "send a transfer" button for the demo bank. Instead, it automatically generates a matching bank line based on a special token you put in the invoice handle when you create a test invoice.

The magic token

Add this to the invoice handle when you create the test invoice:

reconcile-demo-<scenario>-<amountMinor>-<currency>

• <amountMinor> is the amount in minor units — 25000 means 250.00.

• <currency> is 3 letters and must match the demo bank's own currency (for example, dkk for the Danish demo bank).

• You can add extra text around the token so the handle stays unique — for example, inv-2026-001-reconcile-demo-auto-25000-dkk creates a 250.00 DKK invoice that will auto-match.

Scenarios you can test

Demo banks

Testing scenario: open to matched

1. Create a test invoice as a pending offline bank transfer, with the token in its handle and the amount and currency matching both the token and the demo bank — for example, inv-2026-001-reconcile-demo-auto-25000-dkk for 250.00 DKK.

2. Add the demo bank connection: choose the demo provider, bank frisbii-test-dk / country DK, then open the consent page and select Allow access. You click through once — there's no silent auto-approval.

3. Create the reconciliation configuration, pointing it at the agreement and the demo bank account, and make sure it's active.

4. Select Synchronize, or wait for the scheduled run. The demo bank generates the matching line and the pipeline matches it.

5. Check Payments → Transactions — the transaction is now Matched.

Swap the scenario token (review, wrongamt, abandon) to try the other outcomes.

Tips for reliable matching

• Keep references unique, and at or above your configured minimum digit length.

• Put the reference tag front and center in your payment instructions so customers actually copy it into the transfer.

• Use Strict matching if customers reliably copy the full reference; use Flexible if they tend to drop dashes, spaces, or paste just the number.

• Remember that amount and currency always have to match exactly — partial payments won't auto-match.

• If a transaction should have matched but didn't, select Synchronize and check the transaction filter for Open vs. Matched.