{"id":48926,"date":"2022-12-27T09:33:56","date_gmt":"2022-12-27T09:33:56","guid":{"rendered":"https:\/\/targetintegration.com\/?p=48926"},"modified":"2022-12-27T09:33:56","modified_gmt":"2022-12-27T09:33:56","slug":"reconciliation-models-in-odoo","status":"publish","type":"post","link":"https:\/\/www.targetintegration.com\/en_in\/reconciliation-models-in-odoo\/","title":{"rendered":"Reconciliation Models in Odoo"},"content":{"rendered":"<p>Reconciliation models are advanced solution provided by<a href=\"https:\/\/www.targetintegration.com\/en_in\/products\/\/odoo-erp-implementation-services\/\"><strong> Odoo<\/strong> <\/a>to reduce the issues caused by time-consuming reconciliation process and helps to reduce errors caused when doing it manually. They are particularly useful with <b>recurrent entries, <\/b>those entries that repeat regularly. Reconciliation models can be easily set up and also, and they are straightforward.<\/p>\n<h2>Odoo provides mainly three types of Reconciliation Models<\/h2>\n<ul>\n<li><strong> Button to generate counter Part entry\u00a0<\/strong><\/li>\n<li><strong>Rule to suggest counterpart entry\u00a0<\/strong><\/li>\n<li><strong>Rule to match Invoices\/Bills\u00a0<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/1-2.png\" sizes=\"auto, (max-width: 677px) 100vw, 677px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/1-2.png 677w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/1-2-300x156.png 300w\" alt=\"Reconciliation Models in Odoo 16\" width=\"677\" height=\"351\" \/><\/p>\n<h3><strong>1.1. BUTTON TO GENERATE COUNTERPART ENTRY\u00a0<\/strong><\/h3>\n<p>The <strong>reconciliation model<\/strong> that uses the \u2018button to generate counterpart entry\u2019 will enable the option to provide the counterpart entry while doing the reconciliation process.<\/p>\n<p>In order to Setup the\u00a0 reconciliation models:<\/p>\n<p><b>Accounting \/ Configuration \/ Reconciliation Models\/Create<\/b><\/p>\n<ol>\n<li>Provide the name given to the model. Check the option \u2018button to generate counterpart entry\u2019 from the three types.<\/li>\n<li>The Journal Availability field, when left blank, will fetch all the available journals under that. From the available journals, if a specific journal is selected, then the model will enable to have reconciliation for that journal alone.<\/li>\n<li>The desired account should be selected from the available dropdown options on the counterpart entries through <b>Add a line<\/b>.<\/li>\n<li>The account type has four options:<b> Fixed, Percentage of balance, Percentage of statement line, and From Label<\/b>. Select the option from the dropdown according to the need and add the amount accordingly. Click on the save button after filling up the necessary fields.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/2.png\" sizes=\"auto, (max-width: 668px) 100vw, 668px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/2.png 668w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/2-300x122.png 300w\" alt=\"Reconciliation Models in Odoo 16\" width=\"668\" height=\"272\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/4.png\" sizes=\"auto, (max-width: 673px) 100vw, 673px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/4.png 673w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/4-300x143.png 300w\" alt=\"\" width=\"673\" height=\"321\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/3.png\" sizes=\"auto, (max-width: 672px) 100vw, 672px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/3.png 672w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/3-300x137.png 300w\" alt=\"Reconciliation Models in Odoo 16\" width=\"672\" height=\"307\" \/><\/p>\n<p>So as per the steps followed, a reconciliation model has been created as Bank charges as shown in the image below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/5.png\" sizes=\"auto, (max-width: 674px) 100vw, 674px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/5.png 674w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/5-300x151.png 300w\" alt=\"Reconciliation Models in Odoo 16\" width=\"674\" height=\"340\" \/><\/p>\n<h3><strong>1.2. RULE TO SUGGEST COUNTERPART ENTRY\u00a0<\/strong><\/h3>\n<p>This model immediately suggests counterpart values when selecting an entry, which then only needs to be validated. This automation is based on a set of rules defined in the reconciliation model.<\/p>\n<p>In order to Setup the model:<\/p>\n<p><b>Accounting \/ Configuration \/ Reconciliation Models\/Create<\/b><\/p>\n<ol>\n<li>Provide the name given to the model. Check the option \u2018rule to suggest counterpart entry\u2019 from the three types.<\/li>\n<li>When left blank, the Journal Availability field will fetch all the available journals under that. From the available journals, if a specific journal is selected, then the model will enable to have reconciliation for that journal alone. Amount type can be chosen from three available options:<b> Received, Paid, Paid\/Received.<\/b> Amount condition has three options: <b>Is lower than, is more significant than, or Is between<\/b>. Label, Note, and Transaction types can be chosen from<b> Contains, Not Contains, and Match Regex<\/b>.<\/li>\n<li>If the \u2018Partner should be set\u2019 field is checked, the option to select specific partners and partner categories will be shown. This can be used if we need to apply the reconciliation model to particular partners and partner categories only, and also, we can select multiple partners in those fields.<\/li>\n<li>The desired account should be selected from the available dropdown options on the counterpart entries through <b>Add a line<\/b>. The account type has four options: <b>Fixed, Percentage of balance, Percentage of statement line, and From Label<\/b>. Select the option from the dropdown according to the need and add the amount accordingly.<\/li>\n<li>Under the <strong>Partner mapping<\/strong> section, the configuration can be done by providing find text in the Label, find text in Note, and the partner can be selected from the dropdown. Then click on save after filling in the necessary fields.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/6.png\" sizes=\"auto, (max-width: 671px) 100vw, 671px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/6.png 671w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/6-300x127.png 300w\" alt=\"Reconciliation Models in Odoo 16\" width=\"671\" height=\"284\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/7.png\" sizes=\"auto, (max-width: 674px) 100vw, 674px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/7.png 674w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/7-300x138.png 300w\" alt=\"\" width=\"674\" height=\"311\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/8.png\" sizes=\"auto, (max-width: 673px) 100vw, 673px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/8.png 673w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/8-300x135.png 300w\" alt=\"Reconciliation Models in Odoo 16\" width=\"673\" height=\"302\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/9.png\" sizes=\"auto, (max-width: 673px) 100vw, 673px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/9.png 673w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/9-300x148.png 300w\" alt=\"\" width=\"673\" height=\"333\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/10.png\" sizes=\"auto, (max-width: 673px) 100vw, 673px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/10.png 673w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/10-300x135.png 300w\" alt=\"\" width=\"673\" height=\"303\" \/><\/p>\n<p>So as per the steps followed, a reconciliation model has been created as Electricity Bills as shown in the image below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/11.png\" sizes=\"auto, (max-width: 669px) 100vw, 669px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/11.png 669w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/11-300x155.png 300w\" alt=\"\" width=\"669\" height=\"345\" \/><\/p>\n<h3><strong>1.3. RULE TO MATCH INVOICES\/BILLS\u00a0<\/strong><\/h3>\n<p>This reconciliation model automatically selects the proper customer invoice or vendor bill that matches the payment. All that is left to do is to validate the entry. This automation is based on a set of rules defined in the reconciliation model.<\/p>\n<p>In order to Setup the model:<\/p>\n<p><b>Accounting \/ Configuration \/ Reconciliation Models\/Create<\/b><\/p>\n<ol>\n<li>Provide the name given to the model. Check the option \u2018rule to match invoices\/bills\u2019 from the three types. A search month limit can be given. Matching order can be selected from <b>Oldest first<\/b> and <b>Newest first.<\/b><\/li>\n<li>When left blank, the Journal Availability field will fetch all the available journals under that. From the available journals, if a specific journal is selected, then the model will enable to have reconciliation for that journal alone. Amount type can be chosen from three available options: <b>Received, Paid, Paid\/Received.<\/b> Amount condition has three options: <b>Is lower than, Is greater than, Is between.<\/b> Payment tolerance can be given in Percentage or amount. The exact matching can be done based on Labels, Notes, and References. The Label, Note, and Transaction types can be chosen from <b>Contains, Not Contains, and Match Regex.<\/b><\/li>\n<li>If the \u2018Partner should be set\u2019 field is checked, the option to select specific partners and partner categories will be shown. This can be used if we need to apply the reconciliation model to particular partners and partner categories only, and also we can select multiple partners in those fields.<\/li>\n<li>Under the Partner mapping section, the configuration can be done by providing find text in the label, find text in a note, and the partner can be selected from the dropdown. Then click on save after filling in the necessary fields.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/12.png\" sizes=\"auto, (max-width: 670px) 100vw, 670px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/12.png 670w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/12-300x152.png 300w\" alt=\"\" width=\"670\" height=\"339\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/13.png\" sizes=\"auto, (max-width: 673px) 100vw, 673px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/13.png 673w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/13-300x145.png 300w\" alt=\"\" width=\"673\" height=\"325\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/14.png\" sizes=\"auto, (max-width: 672px) 100vw, 672px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/14.png 672w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/14-300x143.png 300w\" alt=\"\" width=\"672\" height=\"321\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/15.png\" sizes=\"auto, (max-width: 676px) 100vw, 676px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/15.png 676w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/15-300x144.png 300w\" alt=\"\" width=\"676\" height=\"325\" \/><\/p>\n<p>So as per the steps followed, a reconciliation model has been created as <strong>Invoices\/Bills Perfect Match<\/strong> as shown in the image below<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/16.png\" sizes=\"auto, (max-width: 664px) 100vw, 664px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/16.png 664w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/16-300x150.png 300w\" alt=\"\" width=\"664\" height=\"332\" \/><\/p>\n<p>After the creation of three different models of reconciliation with three different types, my page will look like this as shown in the below image.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/17.png\" sizes=\"auto, (max-width: 670px) 100vw, 670px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/17.png 670w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/17-300x97.png 300w\" alt=\"\" width=\"670\" height=\"216\" \/><\/p>\n<h3><strong>1.4. Example 1 \u2013 Showing the Reconciliation with the Model \u2018Bank Charges\u2019 that uses a button to generate counterpart entries<\/strong><\/h3>\n<p>Now let&#8217;s see how each of the models works with each case.<\/p>\n<p>Consider a scenario where a customer payment has been registered in Odoo, but the bank deducts a charge for the transaction. This means the customer pays the full amount, out of which the bank deducts some amount. To reconcile the bank statement for the customer payment, provide the details by adding a line, select the partner and give the amount as shown in the image. The customer payment was 1000, but the bank statement shows 100 less. Post the entry and then reconcile. Also, ensure that the computed balance and ending balance remain the same before posting.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/18.png\" sizes=\"auto, (max-width: 664px) 100vw, 664px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/18.png 664w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/18-300x161.png 300w\" alt=\"\" width=\"664\" height=\"356\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/19-2.png\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/19-2.png 650w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/19-2-300x132.png 300w\" alt=\"\" width=\"650\" height=\"287\" \/><\/p>\n<p>When we click on reconcile button, a page appears, as shown below, which shows the invoices lines which can be matched with. Upon selecting the appropriate invoice line from the list, we need to click on the Manual Operations button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/19.png\" sizes=\"auto, (max-width: 651px) 100vw, 651px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/19.png 651w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/19-300x111.png 300w\" alt=\"\" width=\"651\" height=\"240\" \/><\/p>\n<p>The selected invoice line from the list will be matched to the bank statement line. Then from the manual operations tab select button called Bank charges.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/20.png\" sizes=\"auto, (max-width: 671px) 100vw, 671px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/20.png 671w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/20-300x105.png 300w\" alt=\"\" width=\"671\" height=\"235\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/21.png\" sizes=\"auto, (max-width: 668px) 100vw, 668px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/21.png 668w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/21-300x124.png 300w\" alt=\"\" width=\"668\" height=\"276\" \/><\/p>\n<p>Upon clicking the bank charges button, the account and label will be updated as per the Model configured. Then click on validate tab, which will reconcile the bank statement and the invoice will be tagged under <strong>Paid <\/strong>status. That is how the button to generate a counterpart entry works for the Model named Bank Charges.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/22.png\" sizes=\"auto, (max-width: 655px) 100vw, 655px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/22.png 655w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/22-300x104.png 300w\" alt=\"\" width=\"655\" height=\"227\" \/><\/p>\n<h3><b>Example 2 \u2013 Showing the Reconciliation with the Model \u2018Electricity Bills\u2019 that uses a rule to suggest counterpart entry.<\/b><\/h3>\n<p>Take the Scenario where the electricity charges have been paid, and no bills in the system exist. First, Create the bank statement and give the label \u2018Electricity bills\u2019 and the amount given should be negative as it is an expense. Then post the entry and reconcile it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/23.png\" sizes=\"auto, (max-width: 665px) 100vw, 665px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/23.png 665w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/23-300x133.png 300w\" alt=\"\" width=\"665\" height=\"295\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/24.png\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/24.png 650w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/24-300x144.png 300w\" alt=\"\" width=\"650\" height=\"311\" \/><\/p>\n<p>Upon clicking the reconcile button, a window automatically suggests the entry to be matched with the electricity bills as per the configured model. Click on the line item, then a list of invoices\/bills appears.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/25.png\" sizes=\"auto, (max-width: 665px) 100vw, 665px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/25.png 665w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/25-300x88.png 300w\" alt=\"\" width=\"665\" height=\"196\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/26.png\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/26.png 667w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/26-300x129.png 300w\" alt=\"\" width=\"667\" height=\"286\" \/><\/p>\n<p>Then we need to click on the manual operations tab, which shows the two buttons from which Electricity bills must be selected.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/27.png\" sizes=\"auto, (max-width: 652px) 100vw, 652px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/27.png 652w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/27-300x127.png 300w\" alt=\"\" width=\"652\" height=\"275\" \/><\/p>\n<p>The Electricity bills button automatically updates the account and other details as per the configured model. And then, click on validate button to reconcile the bank statement.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/28.png\" sizes=\"auto, (max-width: 669px) 100vw, 669px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/28.png 669w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/28-300x116.png 300w\" alt=\"\" width=\"669\" height=\"258\" \/><\/p>\n<p>Odoo has automatically suggested the two models, which we can choose manually according to our requirements and reconcile fast without any errors.<\/p>\n<p><b>Example 3 \u2013 Showing the Reconciliation with the Model \u2018Invoices\/Bills Perfect Match\u2019 that uses rules to match invoices\/bills.<\/b><\/p>\n<p>Consider the scenario of performing reconciliation for the customer payment from a particular partner. First, Create the bank statement and give the label and amount by adding the line option. Then post the entry and reconcile it. Ensure the computed balance and ending balance remains the same before posting.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/29.png\" sizes=\"auto, (max-width: 659px) 100vw, 659px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/29.png 659w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/29-300x142.png 300w\" alt=\"\" width=\"659\" height=\"313\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/30.png\" sizes=\"auto, (max-width: 646px) 100vw, 646px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/30.png 646w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/30-300x126.png 300w\" alt=\"\" width=\"646\" height=\"272\" \/><\/p>\n<p>As per the partner selected in the model, the correct invoice line is matched with the statement. Click on Validate button to reconcile.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/\/2022\/12\/31.png\" sizes=\"auto, (max-width: 635px) 100vw, 635px\" srcset=\"https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/31.png 635w, https:\/\/targetintegration.com\/wp-content\/uploads\/2022\/12\/31-300x64.png 300w\" alt=\"\" width=\"635\" height=\"136\" \/><\/p>\n<p>So, for each bank statement item, Odoo automatically provides a button to reconcile it efficiently by saving time. If the auto-validate button is checked for the created models, then the bank statements will be automatically reconciled when everything else is matched.<\/p>\n<p>Setting up Reconciliation models makes the entire Reconciliation process much easier and will also help you improve the efficiency in statement and invoice management. As you are less likely to mess up the details of the customers and products, you can easily carry out the Reconciliation processes without double-checking through every step.<\/p>\n<p><b>Note:<\/b> If a record matches several reconciliation models, the first one in the list is applied. Models can be rearranged by dragging and dropping the handle next to their names.<\/p>\n<p><a role=\"button\" href=\"https:\/\/www.targetintegration.com\/en_in\/contact-us\/\"><br \/>\nWe have all the answers to your questions<br \/>\n<\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>Reconciliation models are advanced solution provided by Odoo to reduce the issues caused by time-consuming reconciliation process&#8230;<\/p>","protected":false},"author":1,"featured_media":49018,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[218,103],"tags":[],"class_list":["post-48926","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-erp","category-odoo"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Reconciliation models in Odoo - Target Integration<\/title>\n<meta name=\"description\" content=\"Reconciliation models in\u00a0Odoo\u00a0lessen the\u00a0issues associated with reconciliation processes and\u00a0mistakes while performing it manually.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.targetintegration.com\/en_in\/reconciliation-models-in-odoo\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Reconciliation models in Odoo - Target Integration\" \/>\n<meta property=\"og:description\" content=\"Reconciliation models in\u00a0Odoo\u00a0lessen the\u00a0issues associated with reconciliation processes and\u00a0mistakes while performing it manually.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.targetintegration.com\/en_in\/reconciliation-models-in-odoo\/\" \/>\n<meta property=\"og:site_name\" content=\"Target Integration\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-27T09:33:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.targetintegration.com\/wp-content\/uploads\/2022\/12\/Reconciliation-Models-in-Odoo-16-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1640\" \/>\n\t<meta property=\"og:image:height\" content=\"924\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"alberon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"alberon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/reconciliation-models-in-odoo\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/reconciliation-models-in-odoo\\\/\"},\"author\":{\"name\":\"alberon\",\"@id\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/#\\\/schema\\\/person\\\/6cf1a626a98188cb709e7c650b1e35a0\"},\"headline\":\"Reconciliation Models in Odoo\",\"datePublished\":\"2022-12-27T09:33:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/reconciliation-models-in-odoo\\\/\"},\"wordCount\":1539,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/reconciliation-models-in-odoo\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.targetintegration.com\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/Reconciliation-Models-in-Odoo-16-1.png\",\"articleSection\":[\"ERP\",\"Odoo\"],\"inLanguage\":\"en-IN\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/reconciliation-models-in-odoo\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/reconciliation-models-in-odoo\\\/\",\"url\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/reconciliation-models-in-odoo\\\/\",\"name\":\"Reconciliation models in Odoo - Target Integration\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/reconciliation-models-in-odoo\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/reconciliation-models-in-odoo\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.targetintegration.com\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/Reconciliation-Models-in-Odoo-16-1.png\",\"datePublished\":\"2022-12-27T09:33:56+00:00\",\"description\":\"Reconciliation models in\u00a0Odoo\u00a0lessen the\u00a0issues associated with reconciliation processes and\u00a0mistakes while performing it manually.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/reconciliation-models-in-odoo\\\/#breadcrumb\"},\"inLanguage\":\"en-IN\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/reconciliation-models-in-odoo\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-IN\",\"@id\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/reconciliation-models-in-odoo\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.targetintegration.com\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/Reconciliation-Models-in-Odoo-16-1.png\",\"contentUrl\":\"https:\\\/\\\/www.targetintegration.com\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/Reconciliation-Models-in-Odoo-16-1.png\",\"width\":1640,\"height\":924,\"caption\":\"Reconciliation Models in Odoo\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/reconciliation-models-in-odoo\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Reconciliation Models in Odoo\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/#website\",\"url\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/\",\"name\":\"Target Integration\",\"description\":\"Digital Adoption Specialists working with CRM &amp; ERP Systems\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-IN\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/#organization\",\"name\":\"Target Integration\",\"url\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-IN\",\"@id\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.targetintegration.com\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/logo-header.svg\",\"contentUrl\":\"https:\\\/\\\/www.targetintegration.com\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/logo-header.svg\",\"caption\":\"Target Integration\"},\"image\":{\"@id\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/#\\\/schema\\\/person\\\/6cf1a626a98188cb709e7c650b1e35a0\",\"name\":\"alberon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-IN\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7ba0ff6198a64091d2f3ba01e9c4dc98d0490b9af571d623c7bf441a86a6b4fd?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7ba0ff6198a64091d2f3ba01e9c4dc98d0490b9af571d623c7bf441a86a6b4fd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7ba0ff6198a64091d2f3ba01e9c4dc98d0490b9af571d623c7bf441a86a6b4fd?s=96&d=mm&r=g\",\"caption\":\"alberon\"},\"sameAs\":[\"https:\\\/\\\/www.targetintegration.com\"],\"url\":\"https:\\\/\\\/www.targetintegration.com\\\/en_in\\\/author\\\/alberon\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Reconciliation models in Odoo - Target Integration","description":"Reconciliation models in\u00a0Odoo\u00a0lessen the\u00a0issues associated with reconciliation processes and\u00a0mistakes while performing it manually.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.targetintegration.com\/en_in\/reconciliation-models-in-odoo\/","og_locale":"en_US","og_type":"article","og_title":"Reconciliation models in Odoo - Target Integration","og_description":"Reconciliation models in\u00a0Odoo\u00a0lessen the\u00a0issues associated with reconciliation processes and\u00a0mistakes while performing it manually.","og_url":"https:\/\/www.targetintegration.com\/en_in\/reconciliation-models-in-odoo\/","og_site_name":"Target Integration","article_published_time":"2022-12-27T09:33:56+00:00","og_image":[{"width":1640,"height":924,"url":"https:\/\/www.targetintegration.com\/wp-content\/uploads\/2022\/12\/Reconciliation-Models-in-Odoo-16-1.png","type":"image\/png"}],"author":"alberon","twitter_card":"summary_large_image","twitter_misc":{"Written by":"alberon","Est. reading time":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.targetintegration.com\/en_in\/reconciliation-models-in-odoo\/#article","isPartOf":{"@id":"https:\/\/www.targetintegration.com\/en_in\/reconciliation-models-in-odoo\/"},"author":{"name":"alberon","@id":"https:\/\/www.targetintegration.com\/en_in\/#\/schema\/person\/6cf1a626a98188cb709e7c650b1e35a0"},"headline":"Reconciliation Models in Odoo","datePublished":"2022-12-27T09:33:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.targetintegration.com\/en_in\/reconciliation-models-in-odoo\/"},"wordCount":1539,"commentCount":0,"publisher":{"@id":"https:\/\/www.targetintegration.com\/en_in\/#organization"},"image":{"@id":"https:\/\/www.targetintegration.com\/en_in\/reconciliation-models-in-odoo\/#primaryimage"},"thumbnailUrl":"https:\/\/www.targetintegration.com\/wp-content\/uploads\/2022\/12\/Reconciliation-Models-in-Odoo-16-1.png","articleSection":["ERP","Odoo"],"inLanguage":"en-IN","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.targetintegration.com\/en_in\/reconciliation-models-in-odoo\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.targetintegration.com\/en_in\/reconciliation-models-in-odoo\/","url":"https:\/\/www.targetintegration.com\/en_in\/reconciliation-models-in-odoo\/","name":"Reconciliation models in Odoo - Target Integration","isPartOf":{"@id":"https:\/\/www.targetintegration.com\/en_in\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.targetintegration.com\/en_in\/reconciliation-models-in-odoo\/#primaryimage"},"image":{"@id":"https:\/\/www.targetintegration.com\/en_in\/reconciliation-models-in-odoo\/#primaryimage"},"thumbnailUrl":"https:\/\/www.targetintegration.com\/wp-content\/uploads\/2022\/12\/Reconciliation-Models-in-Odoo-16-1.png","datePublished":"2022-12-27T09:33:56+00:00","description":"Reconciliation models in\u00a0Odoo\u00a0lessen the\u00a0issues associated with reconciliation processes and\u00a0mistakes while performing it manually.","breadcrumb":{"@id":"https:\/\/www.targetintegration.com\/en_in\/reconciliation-models-in-odoo\/#breadcrumb"},"inLanguage":"en-IN","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.targetintegration.com\/en_in\/reconciliation-models-in-odoo\/"]}]},{"@type":"ImageObject","inLanguage":"en-IN","@id":"https:\/\/www.targetintegration.com\/en_in\/reconciliation-models-in-odoo\/#primaryimage","url":"https:\/\/www.targetintegration.com\/wp-content\/uploads\/2022\/12\/Reconciliation-Models-in-Odoo-16-1.png","contentUrl":"https:\/\/www.targetintegration.com\/wp-content\/uploads\/2022\/12\/Reconciliation-Models-in-Odoo-16-1.png","width":1640,"height":924,"caption":"Reconciliation Models in Odoo"},{"@type":"BreadcrumbList","@id":"https:\/\/www.targetintegration.com\/en_in\/reconciliation-models-in-odoo\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.targetintegration.com\/en_in\/"},{"@type":"ListItem","position":2,"name":"Reconciliation Models in Odoo"}]},{"@type":"WebSite","@id":"https:\/\/www.targetintegration.com\/en_in\/#website","url":"https:\/\/www.targetintegration.com\/en_in\/","name":"Target Integration","description":"Digital Adoption Specialists working with CRM &amp; ERP Systems","publisher":{"@id":"https:\/\/www.targetintegration.com\/en_in\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.targetintegration.com\/en_in\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-IN"},{"@type":"Organization","@id":"https:\/\/www.targetintegration.com\/en_in\/#organization","name":"Target Integration","url":"https:\/\/www.targetintegration.com\/en_in\/","logo":{"@type":"ImageObject","inLanguage":"en-IN","@id":"https:\/\/www.targetintegration.com\/en_in\/#\/schema\/logo\/image\/","url":"https:\/\/www.targetintegration.com\/wp-content\/uploads\/2026\/03\/logo-header.svg","contentUrl":"https:\/\/www.targetintegration.com\/wp-content\/uploads\/2026\/03\/logo-header.svg","caption":"Target Integration"},"image":{"@id":"https:\/\/www.targetintegration.com\/en_in\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.targetintegration.com\/en_in\/#\/schema\/person\/6cf1a626a98188cb709e7c650b1e35a0","name":"alberon","image":{"@type":"ImageObject","inLanguage":"en-IN","@id":"https:\/\/secure.gravatar.com\/avatar\/7ba0ff6198a64091d2f3ba01e9c4dc98d0490b9af571d623c7bf441a86a6b4fd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/7ba0ff6198a64091d2f3ba01e9c4dc98d0490b9af571d623c7bf441a86a6b4fd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7ba0ff6198a64091d2f3ba01e9c4dc98d0490b9af571d623c7bf441a86a6b4fd?s=96&d=mm&r=g","caption":"alberon"},"sameAs":["https:\/\/www.targetintegration.com"],"url":"https:\/\/www.targetintegration.com\/en_in\/author\/alberon\/"}]}},"taxonomy_info":{"category":[{"value":218,"label":"ERP"},{"value":103,"label":"Odoo"}]},"featured_image_src_large":["https:\/\/www.targetintegration.com\/wp-content\/uploads\/2022\/12\/Reconciliation-Models-in-Odoo-16-1-1024x577.png",1024,577,true],"author_info":{"display_name":"alberon","author_link":"https:\/\/www.targetintegration.com\/en_in\/author\/alberon\/"},"comment_info":0,"category_info":[{"term_id":218,"name":"ERP","slug":"erp","term_group":0,"term_taxonomy_id":218,"taxonomy":"category","description":"","parent":0,"count":6,"filter":"raw","cat_ID":218,"category_count":6,"category_description":"","cat_name":"ERP","category_nicename":"erp","category_parent":0},{"term_id":103,"name":"Odoo","slug":"odoo","term_group":0,"term_taxonomy_id":103,"taxonomy":"category","description":"","parent":0,"count":20,"filter":"raw","cat_ID":103,"category_count":20,"category_description":"","cat_name":"Odoo","category_nicename":"odoo","category_parent":0}],"tag_info":false,"_links":{"self":[{"href":"https:\/\/www.targetintegration.com\/en_in\/wp-json\/wp\/v2\/posts\/48926","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.targetintegration.com\/en_in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.targetintegration.com\/en_in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.targetintegration.com\/en_in\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.targetintegration.com\/en_in\/wp-json\/wp\/v2\/comments?post=48926"}],"version-history":[{"count":0,"href":"https:\/\/www.targetintegration.com\/en_in\/wp-json\/wp\/v2\/posts\/48926\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.targetintegration.com\/en_in\/wp-json\/wp\/v2\/media\/49018"}],"wp:attachment":[{"href":"https:\/\/www.targetintegration.com\/en_in\/wp-json\/wp\/v2\/media?parent=48926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.targetintegration.com\/en_in\/wp-json\/wp\/v2\/categories?post=48926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.targetintegration.com\/en_in\/wp-json\/wp\/v2\/tags?post=48926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}