Community mailing list archives

community@mail.odoo.com

Re: Is there any way to reconcile a bank statement line with a paid invoice ? [ Bank Statement reconciliation process v7]

by
Marcelo Bello
- 05/27/2015 10:17:20
Yassine, if I understand you correctly, I have the same problem as you.

    What happens is that our financial department will register some payments now that will come on the bank statement the next day (they do bank statement check with Odoo every morning) so when they import the bank statement into the system the next morning some bank statement lines already entered on Odoo will not automatically match between what is on the statement with what is already on Odoo.

     However, keep in mind that you are expecting the bank statement reconciliation to do something it is not designed to do. It is meant only to help you generate new records to your accounting book, so in a sense if it matched an operation already registered on the Odoo system, on saving and confirming the operation it would make a new entry to your accounting, meaning that it would double the entries (each line on the bank statement reconciliation will generate a new journal entry).

     So in other words, you must understant that the Bank Statement Reconciliation tool is not a tool to check if every line on bank statement has a corresponding line on your Odoo journal and help you identify which lines on bank statement and/or on Odoo do not match. That would be the ideal tool IMO, both checking the entries on Odoo vs. Bank Statement and Bank Statement vs. Odoo and showing what is in Odoo that is not in bank statement and what is in Bank Statement that is not in Odoo and let you fix it right there from the interface (and even checking the total account balance which should match exactly between Odoo and Bank everytime).

     The existing tool is much simpler (and limited) in that it imports all lines of the bank statement and gives you an opportunity to quickly register each line of the statement into your journals, however, for lines in the statement already registered you are expected to delete the line from the bank statement (there is a trash can icon on each line of the bank statement for that purpose) to avoid making double entries.

      So remember that if an entry is already on Odoo, you do not want that entry reconciled on the Bank Statement reconciliation interface or it will make a new entry (you will have double entry) to your journal.

       However, if you can instruct your staff to only register entries into your bank journal in Odoo by means of the bank reconciliation tool than all your problems would be gone. I cannot do it because some clients expect account deposits to be cleared in real-time to accelerate shipment (they want items shipped on same day money lands on account), so financial dept. needs to key-in the payments as they happen and on next morning when they import the statement most entries are already registered on Odoo making the bank statement reconciliation tool almost useless for us.

Best regards,

Marcelo

On Wed, May 27, 2015 at 9:01 AM, Yassine Teimi <yteimi01@gmail.com> wrote:
Hi Eva,

Thanks for your reply.

So as I understood, the clearing account will be a place to put all the revenues and costs on it, before bank statement reconciliation.
But, what does make the clearing account journal having the ability to reconcile the already recorded payments, with bank statement line ? is there a parameter on journal or account creation I should put to give this ability ? 

Thank you for your interest. it's very kind. 

2015-05-27 7:52 GMT+01:00 Eva Pinter <epinter@openit.ch>:

HI Yassine,


This does not work in standard. If you do not have too many currency, you can create a clearing account and the related journal. When you register the payment, you register it with the clearing account payment method. Then, when the bank statement arrives, you will reconcile the bank entry with the clearing entry.

Good Luck
---
Eva P.

Affordable high quality training on Odoo-training.com





On 27 May 2015, at 00:06, Yassine Teimi <yteimi01@gmail.com> wrote:

Dear Community, 

On bank statement reconciliation, you have the ability to : 

Manually record a bank statement line.

Import only unpaid invoices so the system automatically loads the accounting entries, and create automatically the reconciliation couterpart. But, when the bank statement line, refers to a payement already recorded on our accounting book, there is no reconciliation with the existing Payement.

I want to reconcile the already recorded payement on my accounting book ( openerp accounting system ), with the already existing payment on my openerp accounting system.

Opernerp v7 reconcile just the payments existing on the bank statement, and non existing on our openerp accounting system, so for me it's just normal reconciliation process. and not an efficient bank statement reconciliation, mainly when the reconciliation button stays RED.

Is there any community module responding to my request ?


--

Cordialement

Yassine TEIMI

Consultant & Chef de Projet
TEL : +212 6-27 33 30 78

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--

Cordialement

Yassine TEIMI

Consultant & Chef de Projet
TEL : +212 6-27 33 30 78

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe