Control ODOO Commissions with Excel

Excel ODOO Commissions.

As a Consultant and Controller specialized in the ERP ODOO, I perform many control, analysis and planning reports for decision making.

ODOO is an excellent information management, every model or table in ODOO has a large number of fields, most of which we cannot see or work with because they are hidden.

Except for the core modules, most of the modules are developed by other consultants, some free and others paid. Each consultant develops the module either adapting it to the requirements of a company or simply because they consider that there is a need to cover.

It is common for developers to worry more about the functionality of the module than about the control of the information, and ODOO, like any other ERP, does not present the information in a simple way unless it is specifically programmed for this.

For this reason, a very simple and practical way to prepare analysis, control and planning reports is to download the information that convenient for us to Excel, then process it and present it in an easy way so that the company’s users can take advantage of it and obtain the maximum performance from the gigantic source of information that is the ERP ODOO.

In this case I show you a report of the many that I elaborate every day for the companies I work with.

In this case it is a Report to control the commissions paid to commercial agents.

Actually, there are 4 reports, some with aggregate information and others with more detailed information, such as the invoices that carry commissions or the customers that have generated the invoices including commercial commissions.

The best thing is that you see it yourself in the following images.

Images Control ODOO Commissions with Excel

More information about ERP ODOO