Configuration of Bank Payments

For effective and seamless finance management operations, it is necessary to integrate bank activities at the appropriate moment with corporate accounting. The platform provides outstanding support and guidance to it, and the Odoo17 Accounting explores a fantastic route for it. You are urged by Odoo17 to create the bank accounts and the business payments linked to those accounts. Configuring bank payments in business accounting software has a number of advantages, such as,

  • By decreasing the need for manual data entry and processing, automating bank payments can help your accounting and finance staff work more efficiently.
  • By removing mistakes that can happen when processing payments manually, automating bank payments can assist in increasing the accuracy of your accounting records.
  • You can gain more insight into your company's financial operations by configuring bank payments in your accounting software. This can aid in the detection and prevention of fraud.
  • Automating bank transfers can assist in cutting back on processing fees like postage and office supplies.
  • Additionally, the platform's reconciliation feature will validate that there is a strong correlation between the organization's operational ledgers and bank account operations.
Add a Bank Account

The Odoo 17 Accounting module contains the 'Add a Bank Account' option. With the help of this functionality, the user can expand the Odoo17 database with new bank accounts. The account type, bank name, and number can all be entered by the user. The user may additionally provide the account's currency, owner's name, and owner's address. It is helpful for businesses that need to keep track of their transactions and balances across various bank accounts. The easiest and fastest way to add bank accounts is with this method. By enabling you to automatically reconcile your bank statements, this can be seen as a good way to keep track of your finances and can also save you time and money.

The Configuration tab's Banks section contains the Add a Bank Account menu as its first menu, as shown below.

odoo-studio

You can set up different bank accounts using this Add a Bank Account menu in accordance with your company's needs. As soon as you select a menu item, a pop-up window for adding a bank account will appear, allowing you to see the default bank's details. You can select your bank from this pop-up and confirm that it will be configured for use with the Odoo17 platform operations.

odoo-studio

Nearly all bank information from around the world will by default be presented in this window. You can select the "Create it" option from the menu in the bottom right corner if your bank isn't listed in the window. As a result, a new pop-up window for configuring a bank account will appear as shown in the illustration.

odoo-studio

The Account Number, Bank, Bank Identifier Code, and Journals can all be entered in the appropriate fields here. You have the option to choose an existing journal to link with the bank account, or you can leave the Journal form blank to create a new diary for this bank account. After providing all the information, activate your bank account in the Odoo17 system by clicking the CREATE button in the pop-up's lower left corner.

We can now move on to the Reconciliation tool found in the Configuration tab of the Odoo17 Accounting module since it is clear how to Add a Bank Account to the Odoo17 platform at this point.

odoo-studio
Reconciliation Models

A Reconciliation Models tool is very helpful for reconciling account transfers in the Odoo17 Accounting module. You can pick and reconcile numerous move lines with this tool at once. To make sure that the books of accounts are in sync with the actual transactions, this tool is important in Odoo17 Accounting. This is accomplished by making the necessary adjustments to the entries after comparing the transactions reported in the books of account with the actual transactions. This procedure guards against financial irregularities and maintains the correctness of the financial accounts.

The Configuration Bank section includes a reference to the system's Reconciliation menu. As shown in the screenshot below, one mouse button is sufficient to reach out to the window.

odoo-studio

For efficient operations in Odoo17, the Reconciliation Model window that you can see in the screenshot will maintain all the records of previously described Reconciliation Models. To provide you with a general overview without opening and carefully reviewing each record, the preview includes the Name of each Reconciliation, Type, and Auto-validate field. Additionally, it is quite straightforward to filter out and group necessary reconciliation models because of the default and custom Filters and Group By capabilities. As seen in the screenshot below, the Favourites tab is where you'll find the Save Current Search, Import Records, Link menu in Spreadsheet, and Insert list in Spreadsheet menus.

odoo-studio

The Odoo17 platform gives you the option to specify Reconciliation models in one of three categories by default. Those are

  • Button to generate counterpart entry
  • Rule to suggest counterpart entry
  • Rule to match invoices/bills
Button to generate counterpart entry

the button reconciliation model, in which you create a button on one or more journal items to generate a counterpart entry. This button makes the reconciliation automatically when you click it and offers a counterpart based on the selected journal article. In contrast, you can set up a set of rules for "Rules to suggest counterpart entry." When you click the suggest button, these rules are used to recommend a counterpart based on the selected journal item and automatically produce the reconciliation. It will confirm that only the immediately adjacent counterpart values need to be verified. Additionally, this model will ensure that the automation takes place in accordance with the Reconciliation model's set of rules.

'Rule to match invoices/bills' The ability of the reconciliation model to automatically post the accurate customer invoices and vendor bills that correspond to the payment amount. The reconciliation activities are completed automatically if the entries are confirmed. Additionally, each and every reconciliation is carried out in accordance with the guidelines established in this mode during configuration.

In Odoo17 Accounting, establishing a new Reconciliation Model is simple. Simply review the NEW button that is there in the Reconciliation Models window. You will enter the creation window shown in the frame below as soon as you select the NEW button.

odoo-studio

In the Name field, you can first give the Reconciliation model a name. The next step is to define the Type by selecting one of the previously covered options for creating a counterpart entry. The three types include Button for counterpart entry generation, Rule for counterpart entry suggestion, and Rule for matching invoices and bills. The additional fields that are accessible will be presented based on the type. This implies that if you select the "Button to generate counterpart entry," a field titled "To Check" will appear, which you can activate or deactivate depending on your needs.

When this option is enabled, the matching rule is used when the user is unsure of all the counterpart's information. Additionally, you may use the dropdown menu to provide details about the Journals Availability under the Bank Transactions Conditions tab. The Add a Line menu can then be used to allocate the COUNTERPART ENTRIES. When you select Add a Line, a new line will appear with a drop-down menu where you may select the Account to see a list of all the available procedures.

odoo-studio

Next, choose the Amount Type, where you'll also discover a drop-down menu with options for Fixed, Percentage of Balance, Percentage of Statement Line, and From label types.

odoo-studio

You also have the option to make it display extra fields in the counterpart entries, along with the Amount, Analytic, and Journal Item Label. Click the icon that is present on the right end to do that, as seen in the screenshot below.

odoo-studio

It will be added to the line if you turn on the Journal, Taxes, and Tax Included in Price fields. The equivalent entries can also be removed by selecting the Delete option that is present at the right end of each line. The reconciliation model will be usable once the Button's setting to create a counterpart entry is complete.

Rule to suggest counterpart entry

Applying the 'Rule to suggest counterpart entry' as the Reconciliation model type will result in the addition of extra fields and tabs, as seen in the screenshot below. This type offers more customizations, as shown in the screenshot above.

odoo-studio

You can choose whether or not to auto-validate the statement line first. The Bank Transaction Conditions can then be set up under the relevant tab. You can specify the reconciliation model under the Journals Availability option to make it accessible in a certain journal. The amount type can then be allocated in the designated field.

You can select it from the dropdown menu to be Received, Paid, or Paid/Received. So that the chosen transaction type will be the only one to which the reconciliation model is applied. Only when receiving an amount does the option "Received" apply. You can only apply using the Paid option after making a payment. In both situations, the third one, "Paid/Received," will be used. The Amount Condition can be examined next.

odoo-studio

It will also show a dropdown menu with alternatives like Is Lower Than, Is Greater Than, and Is Between.

odoo-studio

You can now complete the fields label, note, transaction type, and partner is set on the right side of the tab. The dropdown menu, which has options such as, is located in the Label field.

  • Contains: When this option is selected, the reconciliation model will only be used if the preposition label contains the specified string.
  • Not Contains: The opposite of "Contains" is "Not Contains."
  • Match Regex : Create a regular expression on your own.
odoo-studio

The reconciliation model will only be used when the note satisfies the requirement, so you can assign the note in a similar manner. The Player Should be set option, which will provide you with more possibilities to choose the partners as shown below, can also be used to configure the partners. You can choose the Transaction Type as well. You can also enable or disable the Partner Set field. The chosen reconciliation model will only be used if a customer or vendor is set if the field is activated. By turning on this option, other fields like "Matching partners" and "Matching categories" will become available. as seen in the following screenshot.

odoo-studio

By turning on this function, a dropdown menu will appear with a selection of predefined partners and categories, from which you can select the partners and categories that match. You can add the entries in the COUNTERPART ENTRIES column.

odoo-studio

The setting can then be started by assigning the Find Text in Label and Find Text in Note fields, as well as by selecting the appropriate partner using the dropdown menu available under Partner, under the next tab, which is called "Partner Mapping."

odoo-studio

The newly built Reconciliation model will be instantly saved into the system after all the necessary information has been provided. If not, you can save the record manually using the icon that is provided at the top, as seen in the screenshot above.

Rule to match invoices/bills.

'Rule to match invoices/bills' is the last reconciliation type. You must complete the extra fields that we will cover below in order to configure the reconciliation applying this (Rule to match invoices/bills).

odoo-studio

The 'Search Months Limit' field, where you can define the number of months to be utilised for the reconciliation process, must be filled in after you have mentioned the Name, Type, and Auto validate. This can be used to restrict the reconciliation process's application, for as by limiting it to transactions from the last three months or something similar. Additionally, the dropdown option allows you to fill up the Matching Order box using either the Oldest First or Newest First order. You can arrange the reconciliations in order of importance using this field.

odoo-studio

Later, under the Bank Transactions Conditions tab, the condition on the bank statement can be specified. Here, you must first determine the Journal Availability in order for the reconciliation model to only be accessible from the designated journals. Then, as we said before, the Amount Type can be set to Received, Paid, or Paid/Received. Then, by selecting the appropriate option from the dropdown, you can define the Amount Condition. Additionally, if any underpayment happens, the Payment Tolerance feature can be activated to accept the payment difference. It may be configured percentage-wise. Similarly, whether or not the reconciliation procedure should utilize the same currency for all sums included in the reconciliation is indicated by the boolean field Same Currency being activated.

odoo-studio

Additionally, the 'Match Invoice/bills with' option can be set to Label, Note, or Reference on the right side of the tab. Then, using the appropriate options from the dropdown, you can describe the Label, Note, and Transaction Type fields. The bank statements can be filtered with the use of these options. In order to mention the Matching Partners and the Matching Categories, you can activate the Partner is Set field.

odoo-studio

In order to complete the Partner Mapping tab, use the Add a Line button to provide information about Partner, Field Test in Label, and Find Text in Notes. You can automatically associate accounting entries with various partners using this tab. It enables you to instantly spot any anomalies or irregularities in the accounting and reconcile transactions with ease. When it comes to minimizing data entry errors and improving decision-making, the Partner Mapping tab is extremely helpful.

odoo-studio

The configuration procedures for various Reconciliation model kinds are as follows.

The Reconciliation Model Creation Form also shows a smart button named Journal Entries, which is highlighted in the screenshot below. By clicking this button, you can access all the Journal Entries connected to the Reconciliation Model that has already been defined.

odoo-studio

The form view in Odoo17 has changed, and the 'NEW' button now allows for the creation of bank statements.

odoo-studio

To reconcile the corresponding invoices or bills, select the line that corresponds to the statement. Or, entries are reconciled automatically in accordance with the rules and reconciliation model established.

You may automatically match bank and other financial transactions to the relevant accounts in their Odoo17 Accounting system by using the Reconciliation model, which is an essential component of the accounting process. As transactions are automatically matched to their appropriate accounts, this assures accurate and timely accounting while reducing the need for manual data entry. Additionally, since transactions are automatically reconciled, it aids in removing errors and discrepancies. This makes it easier to make sure that the financial data entered into the system is accurate and current.

Therefore, we covered every aspect of the unique Configuration tools and menus available in the Odoo17 Accounting module in this chapter.

The many tabs of activities in the Odoo17 Accounting module, which support efficient financial administration, will be the subject of the following chapter.

whatsapp
location

Calicut

Cybrosys Technologies Pvt. Ltd.
Neospace, Kinfra Techno Park
Kakkancherry, Calicut
Kerala, India - 673635

location

Kochi

Cybrosys Technologies Pvt. Ltd.
1st Floor, Thapasya Building,
Infopark, Kakkanad,
Kochi, India - 682030.

location

Bangalore

Cybrosys Techno Solutions
The Estate, 8th Floor,
Dickenson Road,
Bangalore, India - 560042

Send Us A Message