This module allows you to import CAMT.054 file (details of customers payments batch) into a dedicated journal taking care of the start/end balance and the remittance reference number.
Customer invoices will be reconciled/Paid. Payment entries will be posted into an internal transfer account (that you have to create with a type current asset and set on the journal)
After this first step, import normally your CAMT.053 (full bank statement) into the bank journal. You will be able to clear the internal transfer account to end up the accounting flow.
Optionally we can activate add generation of additional line in bank statement which will balance your bank statement total to 0. This line can be consolidated later with different account. To enable option of final statement line you need properly set flag on Account Journal Configuration -> Journals -> tab Advanced Settings -> Bank statement configuration
For QRR containing a partner reference, uses the config parameter key qrr_partner_ref. Doing so will fill the partners on bank statement lines and speed up the matches in the reconciliation process.
Value to set in qrr_partner_ref defines the position of the partner reference inside the QRR. The format is i[,n] For instance 13,6 to start on position 13 with a 6 digit long reference. n is optional and it’s default value is 6.
Table of contents
Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us to smash it by providing a detailed and welcomed feedback.
Do not contact contributors directly about support or help with technical issues.
Yannick Vaucher <yannick.vaucher@camptocamp.com>
Timon Tschanz <timon.tschanz@camptocamp.com>
- Son Ho <sonhd@trobz.com>
This module is maintained by the OCA.
OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.
This module is part of the OCA/bank-statement-import project on GitHub.
You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.