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.
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, 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)
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?
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
|Asked: 4/28/13, 8:28 AM|
|Seen: 2852 times|
|Last updated: 3/16/15, 8:10 AM|