Skip to Content
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
All Posts Oameni Insigne
Etichete (View all)
odoo accounting v14 pos v15
Despre acest forum
Această întrebare a fost marcată
reconciliationbankpaymentsstatement
4 Răspunsuri
9940 Vizualizări
Imagine profil
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.

Imagine profil
Abandonează
Imagine profil
Fabrice Henrion (fhe)
Cel mai bun răspuns

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.

Imagine profil
Abandonează
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

Imagine profil
Sandro Regis
Cel mai bun răspuns

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,

Imagine profil
Abandonează
Imagine profil
Acespritech Solutions Private Limited
Cel mai bun răspuns

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

Imagine profil
Abandonează
Imagine profil
Fabio
Autor Cel mai bun răspuns

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

Imagine profil
Abandonează
Related Posts Răspunsuri Vizualizări Activitate
Reconciliation of part of the account is blocking any further reconciliation
reconciliation bank statement
Imagine profil
1
mar. 15
4412
How to reconcile bank operations from statements of 2 different bank accounts ? V13
reconciliation bank statement V13
Imagine profil
Imagine profil
1
sept. 21
4542
wrong transaction in bank reconciliation Rezolvat
reconciliation bank
Imagine profil
Imagine profil
1
ian. 23
4284
Select supplier invoice number on bank statement to reconcile
bank statement
Imagine profil
1
oct. 24
3329
Problem Reconciliation Bank
reconciliation bank
Imagine profil
Imagine profil
1
mar. 15
5946