Read the Tutorial to work faster

How Can We Help?
< All Topics
Print

Bank synchronization: Automatic import

CPA Books can synchronize directly with your bank institution to get all bank statements imported automatically into your database.

To check if your bank is compatible with CPA Books, go to CPA Books Accounting Features, and click on See list of supported institutions.

Checking a bank's compatibility with Odoo

More than 20,000 institutions around the world are supported.

To connect to the banks, CPA Books uses multiple web-services:

Configuration

On-Premise users

To be able to use this service, you need to have a valid CPA Books Enterprise subscription. So make sure that your database is registered with your CPA Books Enterprise contract. We also use a proxy between your database and the third party provider so, in case of a connection error, please check that you don’t have a firewall or a proxy blocking the following address:

First Synchronization

You can start synchronization either by going to Accounting ‣ Configuration ‣ Add a Bank Account or via the configuration bar on the accounting dashboard.

Now you can search for your bank institution. Select it and follow the steps to synchronize with it.

During your first synchronization, you will be asked for a phone number to secure your account. The reason we ask for such information is that we don’t want your data falling into the wrong hands. Therefore, if we detect suspicious activity on your account, we block all requests coming from your account, and you need to reactivate it using that phone number. The third-party provider may request more information in order to connect with your bank institution. This information is not stored on CPA Books servers.By default, transactions fetched from an online source are grouped inside the same statement, and one bank statement is created per month. You can change the bank statement creation periodicity in your journal settings.

You can find all your synchronizations by going to Accounting ‣ Configuration ‣ Online Synchronization.

Synchronize manually

After your first synchronization, the created journals are synchronized by default every 12 hours. If you wish, you can synchronize manually by clicking on the Synchronize Now button on the dashboard.

Synchronize Now Button

Or you can go to Accounting ‣ Configuration ‣ Online Synchronization, select your institution and then click on the Fetch Transactions button.

Online Synchronization Form view


Issues

Synchronization in error

To report a connection error to the CPA books support, go to Accounting ‣ Configuration ‣ Online Synchronization, select the connection that failed, and copy the error description and the reference.

Synchronization disconnected

If your connection with the proxy is disconnected, you can reconnect with the proxy using the Reconnect button.


Migration process for users having installed CPA Books before December 2020

If you are on-premise, please first make sure that your source is up-to-date with the latest version of CPA Books.

Users who have created a database before December 2020 need to install the new module manually to use the new functionalities.

To do so, go to Apps ‣ Update Apps List, remove the default filter in the search bar and type: account_online_synchronization. You can then click on the Install button to install the new module.

Installation button of the account_online_synchronization module

Finally, make sure all your users refresh their CPA Books page by pressing CTRL+F5.


FAQ

The synchronization is not working in real-time. Is that normal?

The process is not intended to work in real-time as third party providers synchronize your accounts at different intervals. To force the synchronization and fetch the statements, go to your Accounting dashboard, and click on the Synchronize Now button. You can also synchronize and fetch transactions through Accounting ‣ Configuration ‣ Online Synchronization. Some providers only allow one refresh per day, so it is possible that clicking on Synchronize Now does not get your latest transactions if you already performed such action earlier in the day.

A transaction can be visible on your bank account, but not be fetched if it has the status Pending. Only transactions with the Posted status will be retrieved. If it is not Posted yet, you will have to wait until the status changes.

Is the Online Bank Synchronization feature included in my contract?

  • Community Version: No, this feature is not included in the Community Version.
  • Online Version: Yes, even if you benefit from the One App Free contract.
  • Enterprise Version: Yes, if you have a valid enterprise contract linked to your database.

Some banks have a status “Beta.” What does this mean?

This means that banking institutions are not yet fully supported by our Third Party Provider. Bugs or other problems may arise. CPA Books does not support technical problems that occur with banks in the Beta phase, but the user may still choose to connect. Connecting with these banks contributes to the development process since the Provider will have real data and feedback from the connection.

Why do my transactions only synchronize when I refresh manually?

Some banks have additional security measures and require extra steps, such as an SMS/email authentication code or another type of MFA. Because of this, the integrator cannot pull transactions until the security code is provided.

Not all of my past transactions are in CPA Books, why?

For some institutions, transactions can only be fetched up to 3 months in the past.

Why don’t I see any transactions?

During your first synchronization, you selected the bank accounts you decided to synchronize with CPA Books. If you didn’t synchronize any of your accounts, you can go to Accounting ‣ Configuration ‣ Online Synchronization to click on the Fetch Accounts button on the connection.

There may also be no new transactions.

If your bank account is properly linked to a journal and posted transactions are not visible in your database, please submit a support ticket.

How can I update my bank credentials?

You can update your credentials by going to Accounting ‣ Configuration ‣ Online Synchronization, open the connection you want to update your credentials and click on the Update Credentials button.

Previous Bank statements
Next Ponto as bank synchronization provider
Table of Contents