İçereği Atla
Menü
Bu soru işaretlendi
4 Cevaplar
1698 Görünümler

Hi Everyone!!!
I try to Reconcile Bank transactions with payments and invoices by Reconciliation models, but in this new version(18.3), there is only one type of Reconciliation model, with which I cant auto-validate my payments. Is there any new tool to do Auto-reconciliation(Auto-validate) of Bank transactions and payments. 

Thank You!

Avatar
Vazgeç
En İyi Yanıt

Odoo still matches Bills and Invoices - we just don't have a "match invoices & payments" reconcilation model type any more.

There are five basic built in rules now:

  1. NUMBER - match an Invoice or Bill Number that follows a recognizable pattern (like "INV/2024/1234") 
  2. CUSTOMER REFERENCE - match the entire Invoice Customer Reference or Bill Bill Reference
  3. PAYMENT REFERENCE - match the entire Invoice or Bill Payment Reference 
  4. PAYMENT REFERENCE SUBSET - match at least 16 characters from the Invoice Customer Reference or Bill Bill Reference
  5. JOURNAL ENTRY - match the Journal Entry Number




Invoice Numbers, Customer References, Payment References and Journal Entry Numbers less than 5 characters in length won't ever be matched with anything (unless the Partner is assigned to the bank statement line).


If a Partner is assigned to a bank statement line, instead of the rules above, we match based on amount:

  • Exact match
  • Discounted match - for Payment Terms with discounts for early payments
  • Tolerance match - within 3% (to account for merchant fees / rounding differences / user error such as entering 23 cents instead of 32 cents)
  • Currency match - invoice in one currency, payment in another (within 3%)
  • Amount in label - if the invoice amount is found in the Label


You can also still create reconcilation models to assign a Partner - enter what Odoo should look for in the label and create a single Counterpart item with the Partner and no Account selected - in this case we seach both the Label and the JSON based Transaction Details field (where supported by bank synch).


For the "five basic rules" we will match and reconcile, for the "partner rules" we will match but you need to set the account (or use a reconcilation model) to tell Odoo where to post any difference.


The automaticaly reconcilation runs by default during statement line creation / bank synch and also once a day based on the Try to reconcile automatically your statement lines Scheduled Action (available in Developer Model via Settings --> Technical --> Automation --> Scheduled Actions).  You can adjust this to run more frequently, or even run it manually on demand.


Note: if you are creating Customer Payments in Odoo, we recommend ADDING to the Memo field, as Odoo will scan the Memo field for the same reference that we automatically add there when trying to reconcile your bank statement. Just add the check number, wire reference, etc that you get from your Customer to the end of the reference Odoo sends to the Payment. Creating payment in Odoo is optional, and you will see the Invoice move to "in payment" until the payment is verified with a bank statement line match - which happens automatically if you keep what Odoo sends to the Memo field during payment creation. You won't see any created payments when trying to reconcile manually, just the Invoices and Bills.

Avatar
Vazgeç
Üretici

Thank You a lot!

En İyi Yanıt

Hello Anush, 

In version 18.3, there are actually 2 types of reconciliation models. There is one for year-end closing that focuses on journal items. This is now nested under the accounting menu > Closing > Reconcile. However, it sounds like your inquiry is focused on Bank Reconciliation.  This now lives where the old "Reconciliation Report" option used to live. 

Go to your accounting dashboard and click on the three menu dots in the top right-hand corner. A mini-menu will pop up and you should select the "Reconciliation" > "Model" 

Once selected, you will see all of your Journals. From here, you can select your desired option. 

The UI from within the menu retains a process similar to the previous method's where you will be able to select any "Journals", "Partners" or "Labels" you would like the system to check for & the "Counterpart Items" you would like generated by the entry. 


Once ready, you can select "Automate" or "Run Now" to trigger the reconciliation and its journal entries


PS. Despite the UI change, the configuration functions in the same way as the current documentation: https://www.odoo.com/documentation/master/applications/finance/accounting/bank/reconciliation_models.html

Avatar
Vazgeç
Üretici

Thank You a lot, I have already seen these Reconciliation model, but in the previous version(18.2) there were 4 types of them:
1. Invoices/Bills Perfect Match
2. Invoices/Bills Partial Match if Underpaid
3. Create Bill
4.Internal Transfers
In every Model there was Type "Match invoices & payments"
in this version I can't reconcile my payments and invoices automatically with Bank transactions

En İyi Yanıt

Steps to Enable Auto-Reconciliation:

  1. Install Modules:
    • Accounting (Invoicing app)
    • Bank Feeds (via Plaid, Ponto, or manual import via CSV/OFX)
  2. Configuration:
    • Go to Accounting > Configuration > Settings.
    • Enable:
      • "Bank Reconciliation"
      • "Automated Matching Rules"
      • "Bank Synchronization" (if using an API like Plaid)
  3. Import Bank Statements:
    • Upload CSV/OFX or enable automatic sync.
    • Go to Accounting > Bank > Reconciliation.
  4. Auto-Matching Rules:
    • Define Matching Rules under:
      Accounting > Configuration > Reconciliation Models
    • Match by partner, amount, label, or account.
  5. Run Reconciliation:
    • Odoo will auto-suggest matches.
    • If 100% matched, it auto-validates based on the rule.

Avatar
Vazgeç
Üretici

Thank You, It's about previous versions. I'm using Odoo v18.3

İlgili Gönderiler Cevaplar Görünümler Aktivite
0
Tem 25
57
0
Tem 25
193
2
Tem 25
283
1
Tem 25
310
1
Tem 25
251