This question has been flagged
4 Replies
7640 Views
reconciliationbankpaymentsstatement
Avatar
Fabio

Hello, I am trying to figure out the proper way to operate a bank reconciliation in OpenERP, but I don't seem to be on the right path.

I use OpenERP 6.1 (and plan to migrate to 7.0 in a few months)

I read quite a few conversations in Q&A and Forum, but I get more and more confused and sometimes I do not know to which version of OpenERP they refer to. If someone had a pointer to a document or brief explanation on how to do that properly, I'd be very grateful.

I now have entered all supplier invoices, customer invoices, and Journal entries (for those operations that are not coming from invoices). I paid directly, with the Pay Invoice button, those invoices that were payed in cash and used the Payment button for those customer invoices that were paid to me in cash.

I did not enter any other payment explicitly, because I planned to do that directly while treating the Bank Statements. Does that make sense?

Now I have to treat the bank statements manually (since I don't manage to import automatically). I have been trying to use the two interfaces (Bank and Cash > Bank Statements and Periodical Processing > Statements > Statements Reconciliation) but I am afraid I am missing the point. I don't quite get in which context each one of those is supposed to be used.

Thank you.

Avatar
Discard
Avatar
Fabrice Henrion (fhe)
Best Answer

There is a fundamental problem with bank reconciliation in v7 because it doesn't let you build a bank statement out of posted payments (just like what you expected). The mechanism had been designed differently (I'm not gonna go in the details here) but it is confusing to users and we have recognized that. This is why bank statement reconciliation as well as bank statement import (OFX, QBI,...) are part of the v8 roadmap as described on slide 17 here: http://bit.ly/15UuGHs.

At this point, the best way to use bank statement reconciliation in v7 is to pay invoices from the bank statement reconciliation screen and to therefore create small statements of 1 or a few transactions.

Avatar
Discard
Lawrence

Hello Fabrice, I know you said it is on the V8 roadmap but I just wanted to check if there are in-fact now any plans to implement this in V7? (I notice this post is quite old and I can imagine that there are lots of people having issues here so perhaps there has been a fix?). It is frustrating that if one uses the "pay invoice" feature on the supplier invoice there is no way to later reconcile it to a bank statement! Thanks for any help!

Fabrice Henrion (fhe)

Hello. No there is no plan to backport this to v7. There are 2 remarks in that regard: 1) This is not a "bug" that needs to be "fixed". This is a feature. 2) When working on new features, we work in trunk, not on the latest stable version. A stable version can not receive new features. See release policy for more info https://doc.openerp.com/contribute/14_release_cycle/ If you are interested in this reconciliation feature for v7, you should contact Jon Wilson from WillowIT who developed that and even more on reconciliation: https://www.openerp.com/partners/directory/1439/Willow+IT

Avatar
Sandro Regis
Best Answer

Hello, in the past i face the same problem and my hint to you is to find some good Accounting Patterns Tutorial and try to understand and apply step by step on your OpenERP system. Take a note that, before u do one reconciliation process we have the conciliation process as it is. For sure, if you do this kind of self training you will solve your doubts. It is just a hint! (y)

Regards,

Avatar
Discard
Avatar
Acespritech Solutions Private Limited
Best Answer

Hello !

May be this blog can be helpful.
acespritechblog.wordpress.com/2012/12/13/bank-reconciliation-in-openerp/

Thanks,
Acespritech Solutions Pvt. Ltd.
Mail: info@acespritech.com
Skype: acespritech
Blog: acespritechblog.wordpress.com

Avatar
Discard
Avatar
Fabio
Author Best Answer

Hi. I read about this problem of posted payments in v7 and apparently there are discussions (question 4377) and bugs (bug 115497 in launchpad) open on it.

Yet, I am now on v6.1 and I feel a little lost understanding which of the two interfaces I mentioned I should use and when. Is it the normal process to create a new statement using the "Periodical Processing > Statements > Statements Reconciliation" and import there all the already reconciled entries (payed invoices and other entries not resulting from invoices) and then open the same statement in the other interface "Bank and Cash > Bank Statements" and complete it? Are there other better ways?

Thanks

Avatar
Discard