Skip to Content

Contributors

E-commerce mass reconcile

Hi Community,

I have a use case that I can't properly solve. Let's see if you have had this use case.

1- I have an e-commerce where I sell my products.

2- I have my payment methods properly set.

3- Imagine that I sell 10 products today, to 10 different customers. Each product costs 100€, so... I sold 1.000€ (in total).

4- I'll Have 10 different invoices, for 10 different customers. Each invoice for an amount of 100€.

5- Tomorrow, my payment acquirer will transfer 1.000€ to my bank account, but he'll not specify any customer. These 1.000€ would be transferred in the same statement line.

How can I easily reconcile these 1.000€ with my 10 different invoices avoiding the manual reconciliation? How do you manage these situation?

I've been checking the account-reconcile repository but I wasn't able to find any appropriate solution.

Thank you for your ideas! 

--

Harald Panten López

CEO

Sygel Technology S.L

+34 637 88 42 41
harald.panten@sygel.es
https://www.sygel.es
C/ Àlaba 61, 5ª planta, 08005, Barcelona

by Harald Panten Lopez - 10:31 - 22 Dec 2020

Follow-Ups

  • Re: E-commerce mass reconcile

    +1

    You actually need 2 bank accounts, 1 for your payment acquirer and one for the bank. From the accounting point of view (in France at least), you cannot record the 100€ paiements on your bank account since they are paid on another account.

    Rgds

    Le 22/12/2020 à 19:37, Houssine BAKKALI a écrit :

    you could manage your payment acquirer like a bank account so you have to import all the payment transaction from you payment acquirer (10 transaction of 100€).

    Then you manage the 1000€ transfer from the acquire to you bank account like an usual bank transfer between to of your bank account.

    On 22/12/2020 10:32, Harald Panten Lopez wrote:
    Hi Community,

    I have a use case that I can't properly solve. Let's see if you have had this use case.

    1- I have an e-commerce where I sell my products.

    2- I have my payment methods properly set.

    3- Imagine that I sell 10 products today, to 10 different customers. Each product costs 100€, so... I sold 1.000€ (in total).

    4- I'll Have 10 different invoices, for 10 different customers. Each invoice for an amount of 100€.

    5- Tomorrow, my payment acquirer will transfer 1.000€ to my bank account, but he'll not specify any customer. These 1.000€ would be transferred in the same statement line.

    How can I easily reconcile these 1.000€ with my 10 different invoices avoiding the manual reconciliation? How do you manage these situation?

    I've been checking the account-reconcile repository but I wasn't able to find any appropriate solution.

    Thank you for your ideas! 

    --


    Harald Panten López

    CEO

    Sygel Technology S.L




    +34 637 88 42 41
    harald.panten@sygel.es
    https://www.sygel.es
    C/ Àlaba 61, 5ª planta, 08005, Barcelona



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


    Virus-free. www.avast.com

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


    by v.regouby - 10:11 - 23 Dec 2020
  • Re: E-commerce mass reconcile

    That's exactly what we do at Commown, using a module very similar to Sebastien's stripe move import module but for slimpay.
    Work's pretty well !

    Le 22 décembre 2020 19:37:31 GMT+01:00, Houssine BAKKALI <houssine@coopiteasy.be> a écrit :

    you could manage your payment acquirer like a bank account so you have to import all the payment transaction from you payment acquirer (10 transaction of 100€).

    Then you manage the 1000€ transfer from the acquire to you bank account like an usual bank transfer between to of your bank account.

    On 22/12/2020 10:32, Harald Panten Lopez wrote:
    Hi Community,

    I have a use case that I can't properly solve. Let's see if you have had this use case.

    1- I have an e-commerce where I sell my products.

    2- I have my payment methods properly set.

    3- Imagine that I sell 10 products today, to 10 different customers. Each product costs 100€, so... I sold 1.000€ (in total).

    4- I'll Have 10 different invoices, for 10 different customers. Each invoice for an amount of 100€.

    5- Tomorrow, my payment acquirer will transfer 1.000€ to my bank account, but he'll not specify any customer. These 1.000€ would be transferred in the same statement line.

    How can I easily reconcile these 1.000€ with my 10 different invoices avoiding the manual reconciliation? How do you manage these situation?

    I've been checking the account-reconcile repository but I wasn't able to find any appropriate solution.

    Thank you for your ideas! 

    --


    Harald Panten López

    CEO

    Sygel Technology S.L




    +34 637 88 42 41
    harald.panten@sygel.es
    https://www.sygel.es
    C/ Àlaba 61, 5ª planta, 08005, Barcelona



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


    Virus-free. www.avast.com

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

    -- Envoyé de /e/ Mail.v>

    by Florent Cayré - 10:40 - 22 Dec 2020
  • Re: E-commerce mass reconcile
    Thanks for your suggestions 👍

    I'll try!

    El mar, 22 dic 2020 a las 19:37, Houssine BAKKALI (<houssine@coopiteasy.be>) escribió:

    you could manage your payment acquirer like a bank account so you have to import all the payment transaction from you payment acquirer (10 transaction of 100€).

    Then you manage the 1000€ transfer from the acquire to you bank account like an usual bank transfer between to of your bank account.

    On 22/12/2020 10:32, Harald Panten Lopez wrote:
    Hi Community,

    I have a use case that I can't properly solve. Let's see if you have had this use case.

    1- I have an e-commerce where I sell my products.

    2- I have my payment methods properly set.

    3- Imagine that I sell 10 products today, to 10 different customers. Each product costs 100€, so... I sold 1.000€ (in total).

    4- I'll Have 10 different invoices, for 10 different customers. Each invoice for an amount of 100€.

    5- Tomorrow, my payment acquirer will transfer 1.000€ to my bank account, but he'll not specify any customer. These 1.000€ would be transferred in the same statement line.

    How can I easily reconcile these 1.000€ with my 10 different invoices avoiding the manual reconciliation? How do you manage these situation?

    I've been checking the account-reconcile repository but I wasn't able to find any appropriate solution.

    Thank you for your ideas! 

    --


    Harald Panten López

    CEO

    Sygel Technology S.L




    +34 637 88 42 41
    harald.panten@sygel.es
    https://www.sygel.es
    C/ Àlaba 61, 5ª planta, 08005, Barcelona



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


    Virus-free. www.avast.com

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



    --

    Harald Panten López

    CEO

    Sygel Technology S.L

    +34 637 88 42 41
    harald.panten@sygel.es
    https://www.sygel.es
    C/ Àlaba 61, 5ª planta, 08005, Barcelona

    by Harald Panten Lopez - 08:16 - 22 Dec 2020
  • Re: E-commerce mass reconcile

    you could manage your payment acquirer like a bank account so you have to import all the payment transaction from you payment acquirer (10 transaction of 100€).

    Then you manage the 1000€ transfer from the acquire to you bank account like an usual bank transfer between to of your bank account.

    On 22/12/2020 10:32, Harald Panten Lopez wrote:
    Hi Community,

    I have a use case that I can't properly solve. Let's see if you have had this use case.

    1- I have an e-commerce where I sell my products.

    2- I have my payment methods properly set.

    3- Imagine that I sell 10 products today, to 10 different customers. Each product costs 100€, so... I sold 1.000€ (in total).

    4- I'll Have 10 different invoices, for 10 different customers. Each invoice for an amount of 100€.

    5- Tomorrow, my payment acquirer will transfer 1.000€ to my bank account, but he'll not specify any customer. These 1.000€ would be transferred in the same statement line.

    How can I easily reconcile these 1.000€ with my 10 different invoices avoiding the manual reconciliation? How do you manage these situation?

    I've been checking the account-reconcile repository but I wasn't able to find any appropriate solution.

    Thank you for your ideas! 

    --


    Harald Panten López

    CEO

    Sygel Technology S.L




    +34 637 88 42 41
    harald.panten@sygel.es
    https://www.sygel.es
    C/ Àlaba 61, 5ª planta, 08005, Barcelona



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


    Virus-free. www.avast.com

    by Houssine BAKKALI - 07:36 - 22 Dec 2020
  • Re: E-commerce mass reconcile
    Hi

    On our side we use the following modules from account-reconcile (V12) not yet migrated in V14

    This modules for importing a move based on the payment info given by the bank (10*100€ payment + one transfert of 1000€)

    Note here you have an example with stripe https://github.com/OCA/account-reconcile/pull/315

    Then with account_mass_reconcile we automatically reconcile the invoice with the payment

    We used this process since openerp 6.1 (module had different name before)




    Le mar. 22 déc. 2020 à 10:32, Harald Panten Lopez <harald.panten@sygel.es> a écrit :
    Hi Community,

    I have a use case that I can't properly solve. Let's see if you have had this use case.

    1- I have an e-commerce where I sell my products.

    2- I have my payment methods properly set.

    3- Imagine that I sell 10 products today, to 10 different customers. Each product costs 100€, so... I sold 1.000€ (in total).

    4- I'll Have 10 different invoices, for 10 different customers. Each invoice for an amount of 100€.

    5- Tomorrow, my payment acquirer will transfer 1.000€ to my bank account, but he'll not specify any customer. These 1.000€ would be transferred in the same statement line.

    How can I easily reconcile these 1.000€ with my 10 different invoices avoiding the manual reconciliation? How do you manage these situation?

    I've been checking the account-reconcile repository but I wasn't able to find any appropriate solution.

    Thank you for your ideas! 

    --

    Harald Panten López

    CEO

    Sygel Technology S.L

    +34 637 88 42 41
    harald.panten@sygel.es
    https://www.sygel.es
    C/ Àlaba 61, 5ª planta, 08005, Barcelona

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


    by Sébastien Beau - 02:20 - 22 Dec 2020