Automatic discount booking upon payment

Using our discount module, you will receive additional information in the incoming and outgoing invoice overview about discount information and deadlines intended for payment. When the payments are created, these discount amounts are automatically taken into account and deducted from the payment amount. The booking is made automatically within the payment to the specified discount account.
The module is generally multicompany capable. Once installed, the features are available to every company. A separate configuration is maintained for each company created.

Prohibition of deletion of documents

In standard Odoo you can first archive documents and then delete them. This app prevents the last step so that documents can never be removed (but they can be archived).

Partner number

This module allows contacts/partners to be linked via a new field with unique, sequential partner numbers. This makes it easy to assign and/or find the correct one. The partner number is linked to the respective partner across apps.

Reclassification of accounts payable and accounts receivable
A batch run that enables a reclassification of creditors and creditors at the end of each period.

Example

For example, if there are unbalanced credit items in a collective account "Receivables LL", these are reclassified to two reclassification accounts "Receivables LL - Correction of creditors" and "Other liabilities - Creditors". The booking will be canceled the following day.

Inventory change batch

The inventory change batch uses an inventory change posting to evaluate inventory and automatically creates one or more postings. The time intervals can be selected and assessments can take place at the end of each period or even daily. Optionally, an evaluation “per product” or per “data slice” can also be carried out. It is also possible to book incoming goods and outgoing goods differently.

Possible applications

Individually adjustable evaluation of inventory levels.

Example:

Various inventory values should be displayed in the finance app. In ODOO, the user is now given two options with the options “automatic” and “manual”. Both options are very limited in their usability because the “automatic” function also creates a booking in the accounting for each individual inventory booking, while if the “manual” option is selected, no further processes take place at all. The inventory change batch, on the other hand, offers the user Here are a few more options. For example, the valuations can be carried out per “data slice”. In this way, each warehouse can now be booked separately (also with different accounts). (Cost of Goods Sold - Goods Issue) within an overall cost method.

Loan

An app with which pre-calculated Excel templates can be uploaded directly to Odoo and whose entries can be transferred to bookings (draft status). Reclassifications (short-term to long-term) can also be stored in Excel. A combination with the “types of movement” and the “circumstances” is also possible.

Possible applications

Repayment, reclassification and interest bookings for loans.Can be used in combination with the “Movement Types” (important for indirect cash flow calculation) and “Circumstances” (important for clarity within accounting) apps.

Example

Loans often generate hundreds of bookings over their life cycle. Repayments and interest (unless variable) are usually known from the start and the bank provides a calculation overview. This can be uploaded directly to Odoo using an Excel template, whereupon the app creates draft bookings for all future movements. With variable interest rates, the bookings created in advance can of course only serve as a template. Either you adjust them monthly or you smooth out the results annually. Whatever the case, the reduction in workload is significant.

Earnings accrual standard process – batch

A batch that solves an accounting problem that occurs in the Odoo standard, which arises from unequal posting times of sales invoices and goods issues or of incoming invoices and goods receipt. Known as a WERE account in other systems.

Possible applications

Incoming invoice posted, goods receipt pending; Goods receipt posted, incoming invoice outstanding; Outgoing invoice posted, goods issue pending; Goods issue posted, outgoing invoice outstanding.Also distinguishes between external and intercompany issues.

Example

In the Odoo standard, the accounting is always incorrect if the sales invoice and goods issue (the same applies to the purchasing page) do not occur at the same time. The basis of this error is that the time at which sales are recognized depends on the time at which the invoice is issued. However, this should correctly depend on the transfer of ownership, which usually takes place when the goods are dispatched. This app ensures that the P&L is correct even if the invoice and goods issue are not posted synchronously. In addition, it generates a report that shows the status on the POs and SOs ("delivered" and "billed") on a specific closing date. Posting the accrual itself takes less than a minute (the same applies to the goods receipt process).

Additional accounting entries when creating invoices

An extension that can be used to automatically create a specific provision entry for each invoice. In a separate matrix table, various criteria (e.g. products, analytical accounts, sellers, etc.) can be defined and the form and amount of the accounting entry can be determined.

Possible applications

Various additional bookings when invoicing.

Example

A sales invoice is posted. Based on the stored product table in which the product-specific warranty rates have already been defined, the warranty provision is now posted automatically via this extension.

Account description

A field in the posting frontend that contains a description text and appears whenever an account is selected.

Possible applications

Shows booking and account information. This is particularly applicable when the same processes are to be carried out across the group.

Example

An accountant should be able to have a more detailed view of information about a respective account during the booking process. This information could, for example, include what should actually be posted or may be posted on the respective account. The relevant information, i.e. the account description, has already been stored in the account master data. As soon as he selects an account during the booking process, this description appears in an additional area below the booking entry.

Mandatory field cost center

Using “Mandatory field cost center” it is possible to specify for each account whether the entry of an analysis account is defined as a mandatory field when making a booking.

Possible applications

Various bookings,i.d.R.P&L postings.You can also specify whether an analysis account is defined as a mandatory field for purchase or sales orders.

Example

A booking is in draft form and can be saved as such even if an analysis account is not entered. However, if this booking is then to be validated and the analysis account has still not been entered, this will result in an error message.

Exchange accounts

If a bank account has a credit balance and needs to be reclassified to liabilities, the reclassification booking and cancellation will be made the following day via this app. It is also possible to define groups of accounts, check them together and only start the reclassification process if the total balance of this bundle is negative.

Example

Some accounts, such as bank accounts, can also have a credit balance instead of a debit balance on a closing date. This app transfers these positions to reclassification accounts via a batch run without making any changes to the actual account.

Recurring bookings

A model that creates recurring bookings. Similar to depreciation in Odoo, a “repetition number” is defined. All future bookings are then created in draft and can be automatically converted into validated bookings.

Possible applications

Journal entries and incoming invoices.

Example

A vehicle leasing fee is deducted every month. In order to create the corresponding open item, a permanent booking of this incoming invoice can be created, for example over the next 24 months. All recurring bookings are collected in a register and can therefore be managed clearly.

Documents - partner enrichment

In the Odoo standard, the partner is not automatically enriched for an invoice that is uploaded and created via the “Documents” app. This app closes the gap. This means you can easily filter for partners for all of these documents.

Possible applications

Odoo document app.

Example

In the document app, an invoice is imported, validated and finally posted. The moment the invoice is posted in Odoo, the supplier/partner is known. The partner is now automatically set on the document itself.

Open items report

In Odoo there are two standard reports for displaying open items. We recommend the “Partner Account Statement” report (under the “Finances” menu item), as all filter and grouping functions are possible here using the usual list view.

However, the disadvantage of the Odoo standard reports is that they only show you the open items via “TODAY”. At an earlier deadline it is impossible to display the operations as they were back then (note: you can filter by date, but you will then receive WRONG results!).

In the ODOO standard there are only two reports “Overdue Receivables” and “Overdue Payables” for this option. Apart from the fact that the column selection is very limited here, you cannot, for example, display OP-managed general ledger accounts or see foreign currency amounts; it is actually only about due dates.

The open item report can be used as an alternative. Visually almost identical to the “Partner Account Statement”, you can also enter a historical date in a wizard and thus receive the OPs for the date.

Possible applications

Open items of receivables LL, liabilities LL, all "reconciliation accounts" in list format as of a specific date.

Example

The open items should be as of the date31.12.2022are displayed even though today's date is already the 03.02.2023 .

As in the standard report, you can then group/filter by debit and credit issues, by other reconciliation accounts, you can clear OPs, etc.

Additional acquisition costs when valued manually

In the Odoo standard it is not possible to activate additional acquisition costs (ANK) if the inventory valuation is set to "manual" (--> all goods movements do NOT generate a financial accounting posting). Freight costs, customs duties, etc. are therefore not included in the stock valuation (in the general ledger in the stock app = stock-valuation-layer). There is actually no justification for this technical restriction. The app enables the activation of the ANK. The app can/should be used in combination with the “Inventory Valuation” app.

Possible applications

Activation of additional acquisition costs if the product category in the "Inventory valuation" field is set to "manual".

Example

In addition to the primary product costs, there are transportation costs. Using the “Add acquisition costs” function, these costs are added to the asset, which would subsequently lead to an inventory increase posting.

Advanced fixed assets

An app that provides a detailed, filterable and groupable list view of all assets in the subledger, including all details such as depreciation periods, outstanding depreciation, acquisition date, depreciation method, etc. In addition, asset numbers are assigned and a report is generated that compares the general ledger with the subledger and shows any differences.It is also possible to combine the asset bookings with the movement types, so that a) more complex issues (e.g. "unscheduled depreciation") can be mapped and b) exports can be created for consolidation software such as Lucanet.

Possible applications

Asset accounting

Provisions for additional acquisition costs

If additional acquisition costs (ANK) for inventories are to be recorded promptly, you often run into the problem of a delayed receipt of the corresponding invoice. This app solves this problem by showing certain, previously defined additional acquisition costs with the invoice amount when the inventories are activated.

Possible applications

Simultaneous display of the invoice amount and incidental acquisition costs for inventories.

Example

Before a corresponding invoice for freight/customs is received, the landed costs should be shown as expenses when purchasing a product, but not yet activated. Using this app, these expenses are initially posted to a reserve account. It is possible to specify a calculation sequence, which is always necessary when costs depend on other partial costs that have to be calculated beforehand. When the ANK invoice is received (at a later date), it now only needs to be written off against the reserve account and any differences must be cleared through profit or loss at the end of the period.

Fixed headings

With this app, similar to Excel, the header of a table (List View) is fixed so that it remains visible when scrolling down.

Types of movements and circumstances

With the help of the movement type module, every booking can be linked to a movement type. An evaluation is then carried out using the standard Odoo pivot function.

Possible applications

Types of movement for fixed assets as well as "movement mirrors" for loans, equity and provisions.Facts enable a clearer categorization of bookings by linking each booking to a fact that corresponds to the respective topic. Confusing accounts or subledger accounting in Excel are now a thing of the past.Possible applications: Addition of reserves, consumption of reserves, release of reserves, addition of assets, release of assets, release of assets, release of assets. Assets, liquidation of assets, liquidation of depreciation of assets, reclassification of assets, loan addition, loan repayment, loan addition interest, loan repayment interest and many others.

Example

A matter with the description “WP-2022 Individual Financial Statements” is defined for the “Other Provisions” account. This fact can now be attached to any booking that has a thematic connection. Regardless of whether it is education, dissolution or even utilization. The result is a simple way to get an overview of “provisions per issue”.Another possible application could be found in the “Loans” area: Instead of a separate general ledger account for each loan, only ONE collective account is created. A distinction is now made between the different loans simply based on the related facts.

IC collector

The IC Collector enables an external incoming invoice to be divided among the subsidiaries of a group as soon as it is entered. This means that at the end of a period, outgoing invoices (in the clearing company) and draft incoming invoices (in the clearing company) can be created via a batch, which list all the collected invoice lines. The original PDFs are automatically attached. In addition, 100% automated account determination is possible, even with different account plans of the individual companies.

Possible applications

External incoming invoices, IC outgoing and incoming invoices, automated account determination.

Example

A service invoice is sent to the headquarters of a group, even though the actual service recipients are one or more subsidiaries of this group. The invoice amounts received would now have to be marked and “charged on” to the respective subsidiaries at the end of the month, often with a lot of effort.The IC Collector, however, enables the responsible accountant to mark these bookings as future relief and also to distribute them directly to the relevant subsidiaries. The additional, time-consuming work at the end of the month is completely eliminated as all other processes are now handled 100% automatically by starting the batch run.

Integration with Odoo

The consolidation module obtains the necessary information directly from the finance database. Similar to the "Booking Lines" in the Finance app, there is the main table "Group Booking Lines" in the consolidation module. Data is aggregated or updated into monthly slices from the finance app using import buttons. A manual upload, e.g. from group companies outside of Odoo, is also possible using the standard Odoo import functions.

Group chart of accounts

Odoo always uses local charts of accounts for the individual country packages. Implementing group charts of accounts at individual company level is almost impossible or at least not recommended.

In order to still be able to use a uniform chart of accounts for consolidation and group reporting, a new field in the chart of accounts was added to the Finance app, the “Group account”. Here each local account is linked to a group account. The group chart of accounts is itself entered into the module and contains additional information such as: the group account type, which determines the conversion method, or group account tags for later reporting.

When data is imported from the individual companies, it is aggregated across the group accounts.

Currency conversion

In the first version of the consolidation module there is only one method of conversion:
- Balance sheet accounts (excluding equity accounts) at the closing rate
- Equity accounts at historical rate
- P&L accounts at the monthly average rate (cumulative rate will follow in later versions

In the background, the currency conversion difference is also posted to special exchange rate difference accounts so that the balance sheet always amounts to zero. All positions are also converted in the background at the average monthly exchange rate, which in turn is relevant for determining the indirect cash flow calculation (later expansion stage).