Skip to Content
This question has been flagged
3 Replies
2876 Views
Avatar
Aetna Softwares

Hi,

I have a case of figure that I can't see how to do it the propper way.

I have a customer invoice, I receive a payment (for example a check) so I register it on the invoice and the invoice is marked as paid.

Later, the bank notify me that the check is refused by the customer bank (for example their is no money left on customer bank account)

So I want to modify the payment to mark it as "unpaid" and make my invoice go back to "open" state.

I find out how to unreconcile the inputed payment but I think it is not the propper way to do it as the payment is just not linked anymore to the invoice but still present in accounting.

I also found about the account move cancel but it is not good too because the first move and the cancel can be on 2 different accounting period and I don't want to modify a closed period (for example, I already make some tax declaration)

The result I expect is to have a "negative payment" on the invoice that allow me : 

  • change the state of invoice to "open" (as the balance is > 0)

  • have the credit and debit move in my account journal

Is there a way to do that in Odoo ?

Avatar
Discard
Avatar
Aetna Softwares
Author Best Answer

@Pinakin Nayi (pna)

Yes we can do that but it is not very handy to stay in state "open" when receive the check to follow late invoices.

If there is no other way to do it we may go this way


@Kinner Vachhani

I understand your solution which is a clean solution regarding accounting but I wish to "reopen" the invoice because the customer payment default maybe temporary and we may send me another payment next week.

If I let the invoice as "paid" and register in accounting the payment as a lost, I will forgot to ask again my customer to pay the invoice because it won't popup as a not paid invoice.

In fact, I want to declare the loss in accounting in a similar way you do but I also want to reopen the invoice to go back to my customer and ask to pay again

In fact I hoped that there is a button somewere in the customer payment to do this but it seems to be a too rare case of figure for that :(


PS: sorry about putting my answers like this but the forum refuse me to comment on receive answers because I don't have enough "karma"

Avatar
Discard
Avatar
Kinner Vachhani
Best Answer

According to me ideal way is having an intermediate account bank clearing account 

Whenever you receive a payment it goes to bank clearing account the entries would look like

debtors a/c

100CR
bank clearing account
100DR

Once your payment is cleared and landed into the bank account the entry would reflect into the statement. Reconcile the bank statement entry. It would look like


bank clearing account

100CR
HSBC bank account
100CR

If at any point customer declares bankruptcy then the receivable amount should be transfer to bad debts/bad debts written off account. This should be manual journal entry.


Hope it is clear to you.


Regards,

Kinner

Avatar
Discard
Avatar
Pinakin Nayi (pna)
Best Answer

When you receive Check don't make invoice as paid because you have received check not actual amount. Just log note on your invoice as you have received check. 

Now deposit check in bank and when you receive bank statement from your bank, just import statement and reconcile your invoice and mark invoice as paid.

Avatar
Discard