Skip to Content
  2. Mailing Lists
  3. Contributors
  4. Re: E-commerce mass reconcile

Archives

Contributors

Re: E-commerce mass reconcile

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

Reference

  • 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

    5 replies 5 replies

    • 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