← Back to team overview

openerp-community team mailing list archive

Re: v8 bank statement reconciliation



I don’t have a lot of time to explain so I will give you the answer in a nutshell:

-          Yes, there is a limitation in OpenERP in the fact that you cannot create a bank statement based on journal entries (ie. customer payments, supplier payments, checks, any money transaction…). It is a limitation and not an omission as several people might believe – we didn’t “forget” it – because OpenERP had been initially designed to take care of the bank statement creation and the payment record in only 1 step to make things more efficient/fast, which is an innovative concept. However, this doesn’t work for everybody for various reasons (I will not go in the details of this).

-          Independently from the point above, bank statement reconciliation also requires some usability improvements. (Did someone say green bullets?)

-          These improvements for bank statement reconciliation are acknowledged (I think) but not planned for v8. There are a couple of community modules trying to improve this like the one of Novapoint or the one of WillowIT.

-          In a different topic, I designed account_deposit and it has nothing to do with bank statement reconciliation. The purpose of account_deposit is to handle deposit tickets, which is needed for any form of payment that can be grouped before hitting your bank account. It can be the case with cash, checks, credit cards,... (not with wire transfers). Without going in the details, it’s a way to record that the $6,000 line on your bank statement corresponds to the sum of a $1000, a $2000, and a $3000 payment from different customers for different invoices. That is 3 invoices, 3 payments, and 1 statement line. In order to record this correspondence between the 3 payments and the 1 statement line, you need a new object (a deposit ticket which is an actual business document) that is introduced by this module. The spec is here: http://is.gd/IbL4X1 



Fabrice Henrion
Director Americas

OpenERP Inc.
260 Main Street – Suite 203
Redwood City, CA 94063
Tel: +1 (650) 307-6736

 <http://www.openerp.com/> http://www.openerp.com


From: Openerp-community [mailto:openerp-community-bounces+fhe=openerp.com@xxxxxxxxxxxxxxxxxxx] On Behalf Of Frédéric Clementi
Sent: Friday, February 14, 2014 9:34 AM
To: Magnus Gustafsson
Cc: openerp-community
Subject: Re: [Openerp-community] v8 bank statement reconciliation


wondering as well. Apparentely it has something to do with the branch  trunk-account-deposit (openerp-dev)...

but I did not go into it.


However this novagroup module seems just perfect after a quick test :  <http://bazaar.launchpad.net/~npg-team/openerp-usa/7.0/files/head:/npg_bank_account_reconciliation/> npg_bank_account_reconciliation (in : http://bazaar.launchpad.net/~npg-team/openerp-usa/7.0/files)


...it would deserve to land into community branches ( <https://code.launchpad.net/~account-core-editors/account-financial-tools/7.0> https://code.launchpad.net/~account-core-editors/account-financial-tools/7.0)

Frédéric Clementi
Project Manager 
Business Solutions
+41 21 619 10 41
 <http://www.camptocamp.com/> www.camptocamp.com


2014-02-06 16:32 GMT+01:00 Magnus Gustafsson <mags.gustafsson@xxxxxxxxx>:

I am looking for information mentioned here for the v8 roadmap pertaining to Bank Statement Reconciliation - http://de.slideshare.net/openobject/the-future-of-openerp-open-days-2013-keynote-presentation-fabien-pinckaers-ceo-openerp

Seen on page #21.


Mention of new functionality is also made here - http://help.openerp.com/question/13739/bank-reconciliation-in-61-any-pointer/


I have just looked at the trunk runbot and notice only minor changes in bank statement.


Where can I find information on how this proposed new functionality is to work please?




Mailing list: https://launchpad.net/~openerp-community
Post to     : openerp-community@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp


Follow ups