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/31/2015 17:25:34

Yassine, I have not tried it in v8. Migration to v8 at my company will happen this year, but still a few months away.

Beat regards,

Marcelo

Em 29/05/2015 08:49, "Yassine Teimi" <yteimi01@gmail.com> escreveu:

Marcelo,

Yes you're right. I understood what you explained and I share the same point of view.

It will only affect the opening balance when trying to create thr following bank statement for the following month. That's I was trying to explain.

Have you tried bank statement reconciliation for v8 ?

Because of the limitations of the tool I did not use the bank reconciliation much so I may be mistaken on my answer here but from what I remember deleting the lines of the bank statement (the lines you import from the bank using the ofx file or manually), has no impact on anything on the system. The only small issue you may have is that the bank statement that will be saved on your Odoo for a given day will not be the true statement (it will have lines missing), but the baance of your journal will not be affected in any way. Deleting a line of the bank statement from what I understand is the same as saying "ok, this line I do not want to generate records on the system because I have already taken care of it or will take care of it later". 

    The bank statement is really only a tool to help you making many journal entries at once, the statement itself has no other function on Odoo after the necessary journal entries have been made.
    The next bank statement reconciliation will not use any balance from the previous bank account statement, all info it will get will be from the statement being imported. Again, I may be mistaken, but I am pretty sure the tool is very basic in its functionality and does not do any kind of smart checks as I believe you think it does.

    Last but not least, keep in mind that the balance of your bank account journal on Odoo is what needs to match the balance from your bank statement, Odoo will not use the balance from the bank statament import in any way, it will always consider the balance of your journal.

Best regards,

Marcelo

On Wed, May 27, 2015 at 11:48 AM, Yassine Teimi <yteimi01@gmail.com> wrote:

Mareclo,

You understood me perfectly, thanks for your clarifications, and i can see why the bank statement reconciliation v7 tool is useless for you, unfortunately.

I can't delete the bank statement line refering to a payement already recorded on our openerp accounting system, because it will affect the final bank statement, it means that we will not have the real bank account balance on our following bank statement reconciliation. What do you think of that ?

Le 27 mai 2015 15:24, "Marcelo Bello" <marcelo.bello@gmail.com> a écrit :
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


_______________________________________________
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


_______________________________________________
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