Bank statement extension and profiles

Technical Name:
account_statement_ext
License:
Author:
Camptocamp
  • Odoo Version

Improve the basic bank statement, by adding various new features, and help dealing with huge volume of reconciliation through payment offices such as Paypal, Lazer, Visa, Amazon...

It is mostly used for E-commerce but can be useful for other use cases as it introduces a notion of profile on the bank statement to have more control on the generated entries. It serves as a base for all new features developped to improve the reconciliation process (see our other set of modules:

  • account_statement_base_completion
  • account_statement_base_import
  • account_advanced_reconcile

Features:

1) Improve the bank statement: allows to define profiles (for each Office or Bank). The bank statement will then generate the entries based on some criteria chosen in the selected profile. You can setup on the profile:

  • the journal to use
  • use balance check or not
  • account commission and Analytic account for commission
  • partner concerned by the profile (used in commission and optionaly on generated credit move)
  • use a specific credit account (instead of the receivalble/payable default one)
  • force Partner on the counter-part move (e.g. 100.- debit, Partner: M. Martin; 100.- credit, Partner: HSBC)
  1. Add a report on bank statement that can be used for checks remittance
  2. When an error occurs in a bank statement confirmation, go through all line anyway and summarize all the erronous line in a same popup instead of raising and crashing on every step.
  3. Remove the period on the bank statement, and compute it for each line based on their date instead. It also adds this feature in the voucher in order to compute the period correctly.

5) Cancelling a bank statement is much more easy and will cancel all related entries, unreconcile them, and finally delete them.

  1. Add the ID in entries view so that you can easily filter on a statement ID to reconcile all related entries at once (e.g. one statement (ID 100) for Paypal on an intermediate account, and then another for the bank on the bank account. You can then manually reconcile all the line from the first one with one line of the second by finding them through the statement ID.)