Bank Statements

Importing your bank statements in Flectra Accounting allows you to keep track of the financial movements that occur on your bank accounts and reconcile them with the transactions recorded in your accounting.

However, if you don’t want to use bank synchronization or if your bank is not a supported institution, you still have other options:

  1. Import the bank statement files delivered by your bank

  2. Register the bank statements manually

Import bank statements files

Flectra supports multiple file formats to import bank statements:

  • SEPA recommended Cash Management format (CAMT.053)

  • Comma-separated values (.CSV)

  • Open Financial Exchange (.OFX)

  • Quicken Interchange Format (.QIF)

  • Belgium: Coded Statement of Account (.CODA)

To import them, go to Accounting ‣ Overview ‣ Bank, click on Import Statements, or on the three dots, and then on Import Statement.

Import a bank statement file in Flectra Accounting

Import CSV bank statement files

To import them, go to Accounting ‣ Overview ‣ Bank, click on Create.

../../../../../_images/bs-1.png

Click on Statement Lines.

../../../../../_images/bs-2.png

Now click on Favourites ‣ Import Records.

../../../../../_images/bs-3.png

Here you can upload the csv file of statement and click on Import button.

../../../../../_images/bs-4.png

Here you can see transactions and reconcile it by clicking on Reconcile button.

../../../../../_images/bs-5.png ../../../../../_images/bs-6.png

Register bank statements manually

If needed, you can also record your bank statements manually.

To do so, go to Accounting ‣ Overview ‣ Bank, click on Create Statements, or on the three dots, and then on New Statement.

Add a new line for each transaction written on the original bank statement.

To ease the reconciliation process, make sure to fill out the Partner field. You can also write the payments’ references in the Label field.

Register bank statements manually in Flectra Accounting

Note

The Ending Balance and the Computed Balance should have the same amount. If it is not the case, make sure that there is no mistake in the transactions’ amounts.