Skip to Content
This question has been flagged
automatedreconciliationbank_statement
1 Reply
1149 Views
Avatar
Pavol Garaj

Hall to All,


i am a newbie to odoo and i am a little bit confused how bank statement reconciliation works. 


From other ERPs I am used to have an automated bank statement reconciliaton function.

Sample:

a/ I created: Invoice to custommer:    100 EUR    reference nr: 001

b/ I imported: bank statement line: payment   50 EUR reference nr: 001


is it possible to set odoo for automated bank statement reconciliaton according to reference nr: 001?


I do not want to create payment or manually match journal entries. All should be done automaticly. Is it possible?


Avatar
Discard
Avatar
Pavol Garaj
Author Best Answer

OK, so here is the answer:

a/ it is important to have invoice nr created only from numbers. "Payment reference" is automaticly generated from invoice nr. Or you can define field "Payment reference" manualy (it should contain only numbers). e.g. "123"


b/ modify renconciliaton models: Configuration - reconciliation models.

edit - Invoice matching

Enable: Auto validate

Disable: Partner is set & matches

c/ when creating Bank statement fill in reference payment info "123" to LABEL field! (i can not understand why not to reference field but ok) 

When you press button "Reconcile" renconciliation will be generated automaticaly when invoice and paiment amount is equal.

Avatar
Discard
Related Posts Replies Views Activity
Bank reconciliation: Bank to Bank. Am I doing something wrong? Solved
reconciliation bank_statement
Avatar
Avatar
1
Jan 24
686
Bank Statement Reconcile (CE)
reconciliation bank_statement
Avatar
0
Mar 23
1442
bank outboud vender payment plus bank charges Solved
reconciliation bank_statement
Avatar
Avatar
1
Nov 22
1277
Partial Bank Reconciliation (Odoo v12e)
reconciliation bank_statement
Avatar
0
Feb 22
802
Is there another US-style bank statement reconcilation module available?
reconciliation bank_statement
Avatar
0
Mar 15
3005