Skip to content

Open Banking

  • Open Banking

  • Keep an eye on bank accounts

  • Read a bank account page

  • Search and filter a bank account's transactions

  • Sync an account with the bank and read the history

  • Connect a bank account

  • Reconnect a bank account when the bank consent expires

  • Understand why the bank balance doesn't match the transactions

  • Import a bank statement from a CSV or CAMT.053 file

  • Reconcile transactions with automatic suggestions

  • Manually matching a transaction to an invoice and undoing a reconciliation

  • Decide on movements held by the bank

  • Export movements for the accountant

  • Set up reconciliation rules

  • Recognize customers and suppliers from the bank text

All modules

Recognize customers and suppliers from the bank text

Open Banking · 15 of 15 · 4 min read

A partner mapping assigns a contact to a statement line based on the line's text. For example, a transfer that shows a customer's or supplier's name gets assigned their contact.

Bank transactions that are downloaded become statement lines, which are reconciled in accounting. A line that already has its contact is easier to match to the right invoice, both with automatic suggestions and when you match manually.

How a mapping works

Each mapping links a text to a contact. When the text of a statement line matches, the line receives that contact.

The way the text is compared is the mapping's type:

  • Contains: the searched text appears anywhere in the line's text.
  • Exact match: the line's text is equal to the searched text.
  • Regex: the searched text is a regular expression.

A mapping can be active or inactive. Only an active mapping is applied to new lines.

  • If you don't need a mapping for a while, deactivate it instead of deleting it: you'll find it in the list and reactivate it when needed.
  • If you no longer need a mapping, delete it.

Note: some headings and fields appear with their technical names: match_text, match_type and priority. On this page they are shown as they appear.

Viewing the mappings

The Partner Mappings page lists all the mappings of the organization.

From the Banking screen, press Partner mappings. The Partner Mappings page opens.

List of partner mappings with the four mappings from the demo

The list columns:

  • Partner: the contact assigned to the lines.
  • match_text: the text to search for in the statement line.
  • match_type: the mapping's type, Contains, Exact match or Regex.
  • Status: Active or Inactive.
  • Actions: the actions to edit and delete the mapping.

If there are no mappings yet, the page shows No partner mappings yet.

Creating a mapping

Create a mapping for each customer or supplier you want to recognize from the bank text.

  1. On the Partner Mappings page, press New mapping. The New mapping window opens.

New mapping window with the Partner, match_text, priority and Active fields

  1. Open the Partner field. The Search contacts... box appears with the list of contacts.
  2. Type part of the name and choose the contact, for example Rossi Arredamenti S.r.l.. If the contact isn't among the first ones, press See more.

Contact search in the Partner field of the New mapping window

  1. Fill in the other fields and press Save.

The window's fields:

  • Partner: the contact to assign to the lines. Until you choose one, it shows Select contact. The field is required.
  • match_text: the text to search for in the statement line. The field is required.
  • priority: the mapping's priority. The default value is 100.
  • Active: if on, the mapping is applied. It is on by default.

To close the window without saving, press Cancel.

Tip: each contact in the list shows name, email and phone. In the demo there are two contacts for Giulia Ferri with the same phone: choose the right one by looking at the email.

Note: from the search you can also press Create new contact if the customer or supplier isn't among the contacts yet.

Editing a mapping

Edit a mapping to change the contact, the text, the priority, or to activate and deactivate it.

  1. On the Partner Mappings page, in the mapping's Actions column, use the edit action. The Edit mapping window opens, with the same fields as the New mapping window.
  2. Change the fields you need and press Save.

To deactivate a mapping, turn off Active and save. In the list, the Status column shows Inactive.

Deleting a mapping

Delete a mapping you no longer need.

  1. On the Partner Mappings page, in the mapping's Actions column, use the delete action.
  2. Confirm the question Delete this mapping?

The mapping is no longer applied to new lines. Lines already assigned keep their contact.

← Previous

Set up reconciliation rules

Next →

Property management

On this page

Book a demo

See it on your company, not on a slide deck.

In 30 minutes we map the software you use today.We show you how much work and how much margin Archimedes gives back.

Show me on my business →
No commitmentReply within one working day