Skip to Content

Contributors

Odoo 14 bank statement reconciliation

Hello,

I hope this email finds you well. Today I was stuck with the way Odoo handles the bank statement reconciliation in v14 and saw Frederic's tweet from a year ago: https://twitter.com/Frederic_C2C/status/1313521444106706944

What really stuck me is not the use of a suspense account during the bank reconciliation, but the fact that once the bank statement line journal entry has been posted to a suspense account, the posted journal entry is modified once you have matched that statement line with an invoice. Changing a posted journal entry??

What do you think?

--
Jordi Ballester Alomar 
CEO & Founder  
Spain: (+34) 629 53 07 07 | USA: (+1) 646 980 46 59 | Denmark: (+45) 78 78 21 89


      

The content of this email is confidential and intended for the recipient specified in message only. It is strictly forbidden to share any part of this message with any third party, without a written consent of the sender. If you received this message by mistake, please reply to this message and follow with its deletion, so that we can ensure such a mistake does not occur in the future.

by Jordi Ballester Alomar - 08:16 - 25 Nov 2021

Follow-Ups

  • Re: Odoo 14 bank statement reconciliation
    One more point I don't like is that it doesn't behave the same if you pay the invoice from statement or you make payment before:
    A) Paying from invoice:
    1) one payment with journal entry for the payment
    2) one more entry on the statement when reconciling.

    B) paying an invoice directly from the statement:
    1) only one journal entry (not payment) created. 

    So actually, if you use payment menus you will only find payment that were done there but not the ones created from statements.


    Ing. Juan José Scarafía

    (+54 9 341) 3 278039

    twitter: @jjscarafia

    github: @jjscarafia



    El vie, 17 dic 2021 a la(s) 10:47, Kitti U. (kittiu@ecosoft.co.th) escribió:
    Hi Jordi,


    Our accountant freakouts everytime this kind of thing happens. For our accounting standard, journal entries must not change once posted.
    I was learning from Odoo that, many countries don't take it seriously like we do. But this just make Odoo looks bad for auditors.

    On Thu, Nov 25, 2021 at 2:16 PM Jordi Ballester Alomar <jordi.ballester@forgeflow.com> wrote:
    Hello,

    I hope this email finds you well. Today I was stuck with the way Odoo handles the bank statement reconciliation in v14 and saw Frederic's tweet from a year ago: https://twitter.com/Frederic_C2C/status/1313521444106706944

    What really stuck me is not the use of a suspense account during the bank reconciliation, but the fact that once the bank statement line journal entry has been posted to a suspense account, the posted journal entry is modified once you have matched that statement line with an invoice. Changing a posted journal entry??

    What do you think?

    --
    Jordi Ballester Alomar 
    CEO & Founder  
    Spain: (+34) 629 53 07 07 | USA: (+1) 646 980 46 59 | Denmark: (+45) 78 78 21 89


          

    The content of this email is confidential and intended for the recipient specified in message only. It is strictly forbidden to share any part of this message with any third party, without a written consent of the sender. If you received this message by mistake, please reply to this message and follow with its deletion, so that we can ensure such a mistake does not occur in the future.

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe


    by Juan José Scarafía - 09:00 - 17 Dec 2021
  • Re: Odoo 14 bank statement reconciliation
    Hi Jordi,


    Our accountant freakouts everytime this kind of thing happens. For our accounting standard, journal entries must not change once posted.
    I was learning from Odoo that, many countries don't take it seriously like we do. But this just make Odoo looks bad for auditors.

    On Thu, Nov 25, 2021 at 2:16 PM Jordi Ballester Alomar <jordi.ballester@forgeflow.com> wrote:
    Hello,

    I hope this email finds you well. Today I was stuck with the way Odoo handles the bank statement reconciliation in v14 and saw Frederic's tweet from a year ago: https://twitter.com/Frederic_C2C/status/1313521444106706944

    What really stuck me is not the use of a suspense account during the bank reconciliation, but the fact that once the bank statement line journal entry has been posted to a suspense account, the posted journal entry is modified once you have matched that statement line with an invoice. Changing a posted journal entry??

    What do you think?

    --
    Jordi Ballester Alomar 
    CEO & Founder  
    Spain: (+34) 629 53 07 07 | USA: (+1) 646 980 46 59 | Denmark: (+45) 78 78 21 89


          

    The content of this email is confidential and intended for the recipient specified in message only. It is strictly forbidden to share any part of this message with any third party, without a written consent of the sender. If you received this message by mistake, please reply to this message and follow with its deletion, so that we can ensure such a mistake does not occur in the future.

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe


    by Kitti Upariphutthiphong - 02:45 - 17 Dec 2021
  • Re: Odoo 14 bank statement reconciliation

    Hi all,

    for Germany the law isn't that clear either. As I read it, the change to the journal would be ok if after the obviously 'marginal' change of the journal entry, its previous content and the fact that it had been changed is recorded and reviewable. Infact I didn't check it with regard to the new v14 suspense logic myself but I thing by standard means Odoo does not specifically record changes to journals at, all be they posted or not. I am interested what German accounting experts think about this.

    Best Frederik

    Am 11. Dezember 2021 14:17:19 MEZ schrieb "Pedro M. Baeza (Tecnativa)" <pedro.baeza@tecnativa.com>:
    I have been checking this and the safeguard that Odoo has put is that you can't lock a period without reconciling all the pending statement lines prior to that date. Is it illegal to change a posted journal entry? France regulation doesn't seem to have problems, as the inalterability is for sale journals.

    So in the end, it seems it's a weird operation, but not bad at all for avoiding a lot of temporary journal entries feeding and clearing the suspense account.

    Regards.

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe

    --
    Dr.-Ing. Frederik Kramer
    Geschäftsführer
            
    initOS GmbH
    An der Eisenbahn 1
    21224 Rosengarten
            
    Phone:  +49 4105 56156-12
    Fax:    +49 4105 56156-10
    Mobil:  +49 179 3901819
            
    Email: frederik.kramer@initos.com
    Web:   www.initos.com
            
    Geschäftsführung:
    Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke

    Sitz der Gesellschaft: Rosengarten – Klecken
    Amtsgericht Tostedt, HRB 205226
    Steuer-Nr: 15/200/53247
    USt-IdNr.: DE815580155

    by Frederik Kramer - 03:51 - 11 Dec 2021
  • Re: Odoo 14 bank statement reconciliation
    I have been checking this and the safeguard that Odoo has put is that you can't lock a period without reconciling all the pending statement lines prior to that date. Is it illegal to change a posted journal entry? France regulation doesn't seem to have problems, as the inalterability is for sale journals.

    So in the end, it seems it's a weird operation, but not bad at all for avoiding a lot of temporary journal entries feeding and clearing the suspense account.

    Regards.

    by Pedro M. Baeza - 02:16 - 11 Dec 2021