Community mailing list archives

Re: reconsile advanced payments

Elico Solutions Pte Ltd, dominique kon sun tack
- 02/12/2016 06:24:53

Unfortunately, this is very accounting driven, ...

The process you are describing, should be  :
- a customer makes a deposit in a liability account --> because he can still ask for a refund of unused amount
Journal entry:
debit   bank
  credit     customer deposit account

- when he buys, you will raise an invoice (done automatically by Odoo)
dr    Account receivables (A)
     cr   Sales

- the payment can be done by a journal entry : 
dr   customer deposit account
    cr Account receivables   (B)

next you can do a reconciliation between the journal item (A) and (B) --> Odoo provides a wizard to do that

Then if you want to know how much money left the customer has in your account, you can print a partner ledger that will sum all the debit and credit --> the balance will be what the customer still has.

Dominique KON-SUN-TACK  [Project Manager]
Odoo Gold Partner, best Odoo Partner 2014 for APAC

Mobile: + 65 8502 2399
Skype: dominique_elico

On 12 February 2016 at 18:07, Caudal Eric <> wrote:

Register your payment in bank statement and assign it to the customer then select the AR account at reconciliation as counterpart account

On Fri, Feb 12, 2016, 12:21 Mustafa Al Azaam <> wrote:

Thank you for your reply, but forgive me I not accounting geek so i didn't get what is your hint exactly mean 

On Thu, Feb 11, 2016 at 3:47 PM, Dominique KON SUN TACK <> wrote:

What you describe is more the partner ledger, than the invoice.

On 11 Feb, 2016 8:34 pm, "Mustafa Al Azaam" <> wrote:

in some business statuses, the customer deposit amount of money as a balance to deduct from it in upcoming transactions (sales orders or invoices) .

I wondering how can I apply this in odoo so that customer payment show the amount of remaining balance after deduct invoice total amount?

for example:

- customer X deposit 1000$ pay it in advance to us
- we register this payment via customer payments 1000$
- after couple of days the customer X make sale order in 750$ and confirm it
- we issued an invoice in that amount 750$ (the invoice status being opened)
- when we want to register the payment of invoice the amount show the whole amount of invoice 750$ hence we expected to show us -250$

please help us to preform this situation and correct us if we acting wrong procedures

Thank you

Post to:

Post to:

Post to:


Eric  Caudal (from my mobile)

Post to: