Search

Exact Online Bank Feed

How do I set up my Exact Online Bank Feed?

To enable the synchronisation of your Airwallex Bank Feed with Exact Online, the integration must first be authorised, configured, and mapped to the appropriate journals and G/L accounts. 

Step 1: Access the Connection set up

  1. Log in to your Airwallex account and navigate to the Account tab.
  2. Go to the Connections section.
  3. Apply the Accounting service category filter.
  4. Select Exact Online.

A brief guide will appear with an overview of the connection process. To proceed, click Connect.

Step 2: Authorise the Connection

A notification will appear indicating that you will be redirected to the service provider's portal. Click Proceed.

On the country selection screen:

  1. Choose the country instance you wish to connect to.
  2. Then click Connect.

You will be prompted to log in to your Exact Online account. Once logged in, authorise Airwallex to post transactions on your behalf and select the companies to which access will be granted.

  1. Provide permissions to your Exact Online companies.
  2. Accept the terms and conditions.
  3. Click Allow.

Next, choose the company where transactions should be synchronised.

  1. Select from the list of companies you authorised in the previous step.
  2. Click Done.

Step 3: Map Airwallex wallet currencies to Journals and G/L Accounts

A list of Airwallex wallet currencies will be displayed. Map each currency to the appropriate Exact Online Journal and G/L Account.

Note: It is recommended to use an Unallocated G/L Account or a Suspense Account for posting transactions.

Once you have finished the Airwallex wallet currency mapping:

  1. Choose a start date for transaction synchronisation. Once saved, the start date cannot be changed.
  2. Click Save mapping.

Step 4: Confirm the Connection

After saving, you will see the enabled currencies for transaction synchronisation within the Airwallex webapp.

How do I update my Exact Online Bank Feed?

If you wish to update your Airwallex wallet currency mappings or disconnect the integration:

  • Go to Manage Connection.
  • Choose from the following options:
    • Disconnect - to remove the integration.
    • Reconnect - to update wallet currency mappings. 

Choosing to Reconnect will redirect you to the wallet currency mapping screen where changes can be made.

How do I set up my exchange rates in Exact Online?

To successfully export wallet transactions in foreign currencies into Exact Online, it is essential to configure exchange rates between those currencies and the default currency of the Exact Online company. The following steps outline how to configure exchange rates and create bank journals for those currencies.

To access and configure exchange rates:

  1. From the home page, hover over the Financial option in the top navigation bar.
  2. Navigate to Analysis & Results.
  3. Under the Currency section, click on Exchange rates.


Here, all existing currencies and their configured exchange rates are listed.


To add a new currency, click New in the top-left corner of the "Exchange Rates" overview:

  1. In this field the user can either:
    • Select the currency from the pop-up menu.
    • Or manually type the 3-letter ISO code of the desired currency (e.g., USD, EUR, GBP).

  1. After selecting the currency, you must define its conversion rate to the company's default currency.
  2. Specify the Start Date, which determines from which point in time the exchange rate will become applicable. All transactions from this date onward will be converted using the provided rate.

Tip: You may define multiple exchange rates for the same currency by assigning different time frames. This enables precise conversion tracking aligned with exchange rate changes.

How do I create Bank Journals in Foreign Currencies in Exact Online?

Once exchange rates are configured, proceed to create bank journals in the desired foreign currencies by following these steps:

  1. Hover over the Financial option in the top navigation bar.
  2. Navigate to Banking & Cash.
  3. Under Bank Accounts, select Overview.

Here, you will see a list of all existing bank accounts. 

To create a new bank account click on New in the top-left corner and the "Bank accounts" overview:

  1. Provide the Bank account number for the journal.
  2. Input a name for the new bank account.
  3. In the advanced options section, click the magnifying glass icon to search and select the appropriate currency for this bank journal.
  4. Let Exact Online automatically assign, or alternatively, manually choose:
    1. Journal code 
    2. G/L account
    3. G/L Account: Unallocated

Once saved, the new bank account and a corresponding journal are created and available for use with transactions in the chosen currency.

How do I configure Unallocated G/L Accounts?

To replicate the behavior of manually importing bank statements into Exact Online, you must configure the wallet currency mapping to use a Bank Journal of your choice. For the Exact Online account, select the G/L Account: Unallocated that is associated with the selected bank journal.

To confirm that the selected account is configured as an "Unallocated G/L Account" in Exact Online for a specific Bank Journal follow the steps below:

  • Navigate to Financial → Banking & Cash → Bank Accounts → Overview.

  • From the list of bank accounts, select the bank journal of choice. 

  • After opening the account details, expand the Advanced Options section. 
  • The G/L Account: Unallocated field will show the account currently assigned to that bank journal. 
  • Ensure the shown G/L account matches the one used in your wallet currency mapping.


Note: Statements imported from Airwallex using the Unallocated G/L account will not be automatically matched. Instead, they will be marked as "To Be Completed”. The following section outlines the process for matching imported statements.

How do I match synchronised statements?

To view bank statements imported from Airwallex for the configured bank journals:

  • Go to Financial → Banking & Cash → Statements → To Be Completed.

  • Apply the necessary filters to include transactions for the desired date range.
  • Statement lines for the configured bank accounts will be displayed using the corresponding configured G/L Accounts.
  • Lines are marked with a red dot, indicating they are To Be Completed. 

Each statement line can either be edited or matched using the available options.

  • Selecting the Edit option will open the editing window for the corresponding statement line. Here, an appropriate G/L Account can be assigned.

  • Once the account is assigned, the status of the statement line will update to Completed, indicated by a green dot.

  • Choosing the Match option allows the statement line to be linked with outstanding items such as invoices. 

  • Once the match is completed, the statement line (or a portion of it, if split during the match) will be updated to Completed status.

How do I set up Multi-Entity Connections?

Exact Online allows a single user account to access and manage multiple companies. This means one Exact Online user login can view and work with several companies within Exact Online. However, due to Exact Online's authorisation limitations, a single Exact Online user account can only be used for connecting one Airwallex account to one Exact Online company at a time. Attempting to connect a different Airwallex account to another company using the same Exact Online user account will invalidate the previous connection.

To set up multi-entity connections between Airwallex and Exact Online, a separate Exact Online user account is required for each company connection.

For example:

  • Airwallex Account 1 → Exact Online Company 1 (with Exact Online User 1)
  • Airwallex Account 2 → Exact Online Company 2 (with Exact Online User 2)
    ...and so on.

In which countries is the Exact Online Bank Feed available?

The Netherlands