2020-02-12 21:32:37 +07:00
|
|
|
|
===============
|
|
|
|
|
Bank Statements
|
|
|
|
|
===============
|
2021-01-14 15:35:45 +07:00
|
|
|
|
|
2020-02-12 21:32:37 +07:00
|
|
|
|
Importing your bank statements in Odoo 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.
|
|
|
|
|
|
2021-01-14 15:35:45 +07:00
|
|
|
|
We recommend you use bank synchronization for more efficiency. Please read the related
|
|
|
|
|
documentation: :doc:`bank_synchronization`.
|
2020-02-12 21:32:37 +07:00
|
|
|
|
|
2021-01-14 15:35:45 +07:00
|
|
|
|
However, if you don't want to use bank synchronization or if your bank is not a supported
|
|
|
|
|
institution, you still have other options:
|
2020-02-12 21:32:37 +07:00
|
|
|
|
|
|
|
|
|
#. Import the bank statement files delivered by your bank
|
|
|
|
|
#. Register the bank statements manually
|
|
|
|
|
|
|
|
|
|
Import bank statements files
|
|
|
|
|
============================
|
2021-01-14 15:35:45 +07:00
|
|
|
|
|
2020-02-12 21:32:37 +07:00
|
|
|
|
Odoo 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)
|
2021-01-14 15:35:45 +07:00
|
|
|
|
- Belgium: Coded Statement of Account (.CODA)
|
2020-02-12 21:32:37 +07:00
|
|
|
|
|
|
|
|
|
To import them, go to :menuselection:`Accounting --> Overview --> Bank`, click on *Import
|
|
|
|
|
Statements*, or on the three dots, and then on *Import Statement*.
|
|
|
|
|
|
2021-01-14 15:35:45 +07:00
|
|
|
|
.. image:: media/bank-statements-01.png
|
2020-02-12 21:32:37 +07:00
|
|
|
|
:align: center
|
|
|
|
|
:alt: Import a bank statement file in Odoo Accounting
|
|
|
|
|
|
|
|
|
|
Next, select the file you want to import and click on *Import*.
|
|
|
|
|
|
2021-01-14 15:35:45 +07:00
|
|
|
|
Odoo opens an **import widget** to help you set the **Formatting Options** and **map** the
|
2020-02-12 21:32:37 +07:00
|
|
|
|
different columns you want to import.
|
|
|
|
|
|
2021-01-14 15:35:45 +07:00
|
|
|
|
.. image:: media/bank-statements-02.png
|
2020-02-12 21:32:37 +07:00
|
|
|
|
:align: center
|
|
|
|
|
:alt: Register bank statements manually in Odoo Accounting
|
|
|
|
|
|
|
|
|
|
.. note::
|
2021-01-14 15:35:45 +07:00
|
|
|
|
Quicken Interchange Format (.QIF) is an older file format that is no longer supported since 2005.
|
|
|
|
|
If possible, prefer OFX files over QIF.
|
2020-02-12 21:32:37 +07:00
|
|
|
|
|
|
|
|
|
Register bank statements manually
|
|
|
|
|
=================================
|
2021-01-14 15:35:45 +07:00
|
|
|
|
|
2020-02-12 21:32:37 +07:00
|
|
|
|
If needed, you can also record your bank statements manually.
|
|
|
|
|
|
|
|
|
|
To do so, go to :menuselection:`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.
|
|
|
|
|
|
2021-01-14 15:35:45 +07:00
|
|
|
|
.. image:: media/bank-statements-03.png
|
2020-02-12 21:32:37 +07:00
|
|
|
|
:align: center
|
|
|
|
|
:alt: Register bank statements manually in Odoo 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.
|
|
|
|
|
|
|
|
|
|
.. seealso::
|
|
|
|
|
* :doc:`bank_synchronization`
|
2021-01-14 15:35:45 +07:00
|
|
|
|
.. todo:: add doc link to new documentation about reconciliation
|