Skip to Content
Menu
This question has been flagged
4 Replies
10510 Views

Hello,

 

Has anyone worked on handling NSF (non-sufficient funds) checks in Odoo? I am looking at Check void process when periods are closed and to maintain historical payment information.

 

Thank you,

 

 

Murtada Karjikar

Avatar
Discard
Best Answer

THIS IS RECOMMENDED FOR ODOO VERSIONS 12, 13, 14, 15, 16 and 17:

Managing returned payments or checks that are returned due to insufficient funds (aka a check that bounces)  is easy:

1. Add a Note in the Payment to indicate although it initially cleared, it was returned.

2. When reconciling the Bank Statement (be sure to select the correct CUSTOMER) use the Manual Operations tab to apply both the payment reversal and the NSF charge to the same AR account the original payment was debited to.  By doing this, you are re-stating the receivable for both amounts.  If this happens often and you want a "one click" solution - create a Reconciliation Model for each AR account

Notes:

  • Works if the payment is returned after the GL is locked
  • GL correctly shows what happened
  • Payment record shows what happened
  • AR Balance restated (the amount due is "put back" and any charge is added)
  • AR Aging correct
  • Bank Balance correct
  • Customer statement correct (shows both amounts due)


No need to:

  • customize anything 
  • use a clearing account
  • create a vendor bill
  • manually journal anything
  • reinvoice the customer (that part is done by restating the AR)
  • reverse anything


Bank Statement looks like this, with three statement lines to reconcile:

Reconcile the payment (first line) as normal since the funds were made available and the payment did happen.

Reconcile the reversal and the fee (second and third lines) using the Manual Operations tab with the Customer and the Account Receivable account, so these amounts then appear on the Aged Receivable report and on the relevant Customer Ledger.


 Aged Receivable Report looks like this:


Avatar
Discard
Author

This alternative is fine and yes statements work as the default functionality, The criticality here is to keep the payment as bounced and create new payment without several clicks or notes.

Related Posts Replies Views Activity
0
Mar 24
697
1
Nov 19
3798
1
Feb 17
4662
1
Feb 25
824
3
Mar 15
10534