Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


How to reconcile entries for partner that is BOTH a client AND a supplier?

Dimitrios Tanis
on 8/5/15, 10:26 AM 450 views

I have a partner that is BOTH a client AND a partner.
Lets say we have the following entries:

Customer account debit(counterpart move from client invoice)
1000,00 EUR
Supplier account credit (counterpart move from supplier invoice)
600,00 EUR

Every month we do a balance check so we have
Balance: 400 EUR receivable

Since we have both receivable and payable amount, in order not to exchange any money, we are obligated (by law) to issue a reconciliation note stating the reconciling entries as such:

Customer account credit
600,00 EUR
Supplier account debit
600,00 EUR

The entries above zero out the supplier account and leave 400,00 EUR payable in total for next month.

The problem with this approach is that the entries above (from the reconciliation note) are reconciled with each other but are not reconciliated with the invoices, so all invoices (both sale and purchase) remain open.

Any one any clues how to handle that so invoices are paid?

Dovydas Bagdonas
On 10/2/15, 11:34 AM

Hello Dimitrios,

This might be a solution for your situation.

First, you should create a manual journal entry and in that entry you should debit Supplier account and credit Customer account (this can be used as reconcilation note as well).

After you post this manual journal entry, go to Customer/Supplier -> Open all entries and Reconcile Supplier line (credit figure=600) and reconcile to debit line (figure=600). After this reconciliation, your Supplier invoice will become 'Paid'.

Dimitrios Tanis
On 10/2/15, 5:41 PM

Hi Dovydas.

Actually I've found a way to work it out, a couple of months ago.

Account.voucher is used both for supplier and customer payments with a different domain filter, different fields visible per case (credit/debit) and a method that fetches account moves of type payable/receivable respectively.

The solution was as simple as creating a new module that:

  • Adds a new voucher type (=reconciliation)

  • Overrides a few methods to show moves with both payable and receivable type and

  • Create a new view based on account.voucher in which both credit and debit fields are visible.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

3 follower(s)


Asked: 8/5/15, 10:26 AM
Seen: 450 times
Last updated: 10/2/15, 5:41 PM