Skip to Content
This question has been flagged
automatedreconciliationbank_statement
1 Odgovori
2113 Prikazi
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
Opusti
Avatar
Pavol Garaj
Avtor 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
Opusti
Related Posts Odgovori Prikazi Aktivnost
Bank reconciliation: Bank to Bank. Am I doing something wrong? Solved
reconciliation bank_statement
Avatar
Avatar
1
jan. 24
2758
Bank Statement Reconcile (CE)
reconciliation bank_statement
Avatar
0
mar. 23
3572
bank outboud vender payment plus bank charges Solved
reconciliation bank_statement
Avatar
Avatar
1
nov. 22
3123
Partial Bank Reconciliation (Odoo v12e)
reconciliation bank_statement
Avatar
0
feb. 22
2526
Is there another US-style bank statement reconcilation module available?
reconciliation bank_statement
Avatar
0
mar. 15
5133