Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Bank Reconciliation in 6.1 - any pointer?

By
Fabio
on 4/28/13, 8:28 AM 2,852 views

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.

2

Fabrice Henrion (fhe)

--Fabrice Henrion (fhe)--
5823
| 7 7 8
San Francisco, United States
--Fabrice Henrion (fhe)--

Director Odoo USA

Fabrice Henrion (fhe)
On 4/28/13, 6:51 PM

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.

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!

Lawrence
on 9/23/13, 4:14 PM

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

Fabrice Henrion (fhe)
on 9/23/13, 4:41 PM
0

Acespritech

--Acespritech--
839
| 3 2 6
India
--Acespritech--

Having 8+ years of OpenERP Experience. We are Specialized in OpenERP/CRM Solutions, software development, Web development, E commerce solutions & other open source solutions.


Skype : acespritech

Email : info@acespritech.com

Acespritech
On 5/2/13, 6:29 AM

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

0
Sandro Regis
On 4/28/13, 5:37 PM

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,

0
Fabio
On 4/30/13, 6:39 AM

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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 4/28/13, 8:28 AM
Seen: 2852 times
Last updated: 3/16/15, 8:10 AM