Preliminary Costing

by
Odoo

863.04

v 10.0 v 12.0 Third Party
Required Apps Manufacturing (mrp)
Sales (sale)
Invoicing (account)
Purchase Management (purchase)
Inventory Management (stock)
Included Dependencies
Technical Name gio_preliminary_costing
LicenseOPL-1
Websitehttps://www.giordano.ch
Also available in version v 13.0 v 12.0 v 10.0
You bought this module and need support? Click here!
Required Apps Manufacturing (mrp)
Sales (sale)
Invoicing (account)
Purchase Management (purchase)
Inventory Management (stock)
Included Dependencies
Technical Name gio_preliminary_costing
LicenseOPL-1
Websitehttps://www.giordano.ch
Also available in version v 13.0 v 12.0 v 10.0

Preliminary Costing

Costs and Earnings

Basically the margin is the difference between costs an achieved sale price. By costing of the margin, there are two magnitudes which can belittle the margin.

Cost side The real costs are greater than the costing - the margin is smaller.
Earnings side A discount on the sale price - the margin is smaller.

The net margin is the difference between real costs and discounted sale price. With the module "gio_preliminary_costing" of giordano.ch know it is possible to evaluate in odoo, if the calculated earnings are achieved.


Preliminary Costing and Costing in odoo Now, the evaluation of costs by a preliminary costing can be done directly in odoo. The module of giordano.ch is providing:

products for preliminary costing, with analytic accounts and analytic tags on product

- analytic accounts for real costs
- analytic tags for filtering finance reports

preliminary costing with cost types

- link to products for preliminary costing
- link to analytic accounts for calculated costs
- analytic tags for filtering finance reports
- preliminary costing for production (time before and after production like workcenter configuration)
- units of measure / costs per unit of measure
- costing of margin
- total costs
- total sales price


costing based on preliminary costing

- load cost types (preliminary costing)
- costing with units of measure / costs per unit of measure and margin
- total costs
- total margin
- total sales price
- versioning of different costings

quotation and sales order

- load a costing version
     A) based on a single product (no costing details, only sum), used also for BOM-Products
     B) each cost type as a product in a orderline on quotation
- link to analytic accounts of customer project
- confirm to sales order
- customer invoice on sales order

customer invoice

- confirmation of customer invoice
- save earnings into customer analytic accounts (or project analytic account)
- save calculated costs into calculated analytic accounts (calculated analytic account)

Reporting
odoo standard financial reports can be filtered by analytic tags to compare calculated and real costs.

Setup and Configuration

Due to the installation of the costing module, there is automatically a new journal, which will be configurated in the odoo system named „costing-journal“. The manually based configuration has to be done for:

- analytic accounts (per cost type)
- analytic tag (per cost type)
- accounts for debit an credit (e.g. per cost type, business section or product category)


Beside the automatically setup there is a manually configuration for:

- cost types
- analytic tags (equal to cost types)
- accounts in finance for earnings and expenses (equal to cost types, business or product category)
- setup of products with analytic tags and accounts in finance for earnings and expense



It is recommended to configurate the equal structure for costing, finance and analytic accounts.
For example cost type „overland transportation“:

- analytic account for costing "overland transportation"
- analytic tag "overland transportation"
- account earnings "overland transportation"
- account expenses "overland transportation"
- an analytic account per customer project

Analytic account for costing

The analytic account for costing hast o be set up in the cost type. Therefore it is necessary to configurate a analytic account for costing equal to each cost type. The calculated costs of each cost type will be stored in the costing journal and in the equal analytic account for costing.


analytic account per customer and project
To save data from customer invoice or vendor bill into an analytic account, there hast o be configurated an analytic account per customer project. The sales order line from sales order and the purchase order line from purchase order will be transferred into the customer invoice and the vendor bill as debits and credits.


analytic account for costing per cost type
The calculated total costs are posted here for each cost element. In this way, the calculated expenses per cost element can be evaluated.


product configuration
The analytic account for real costs and the corresponding Analytical Tag is stored on the product.
In addition, the corresponding financial account Income and the financial account Expense is deposited on the product.


Products with deposited Analytical Tags and the corresponding financial accounts


Alternative: analytic accounts for real costs
Those can be created per business area or product category.
The analytic tags for the real costs are stored on the product.


Calculation Workflow

Preliminary costing and configuration of cost types

You can enter the following parameters when creating cost elements:

Choice of unit of measure (volume, length or time units etc.)
Cost factor per unit of measure
Quantity / number of items
Calculated margin in percent


The calculation module then calculates the total costs, the margin and the sales price. For the calculation of production costs, additional set-up costs and reworking costs for machines are available. Cost elements can be duplicated and created in multiple variants for non-linear price models.


Calculation
After creating a calculation, any number of cost elements can be loaded. The master data stored in the cost element can be overwritten (overridden) in the cost estimate. The calculation can be versioned as required. The calculation shows the total cost, the total margin and the total sales price.

Loading a calculation in the sales quotation
After having created an offer, a calculation can be selected and loaded. All individual items are created as sales lines. The cost center of the customer project is stored in the SO.


Confirm as sale order The offer is now confirmed as a sell order. A customer invoice is now created based on the sales order. odoo takes the cost center from the sales order and the corresponding analytic tag from the stored product for each invoice line. This posts the amounts of the individual invoice lines to the cost center of the customer project as revenue. On the financial accounts, evaluations (filters) can be created with analytic tags.

Purchase orders and supplier invoices

The corresponding product is used to create an order. This product with stored analytic tags is transferred to the supplier invoice. The analytic tags of the customer or project can be defined here as analytic tags. This compares the expenses on the customer or project analytic tag with the revenues.

Journals

There are three journals for the booking of revenues, expenses and calculated costs:

Sales journal               all income from sales orders
Purchase journal         all expenses from orders
Calculation journal     all calculated costs


If the real costs are greater than the calculated costs, the margin decreases. If the real costs are lower than the calculated costs, the margin increases. If the calculated return is higher than the achieved one, the margin decreases. If the calculated yield is smaller than the achieved yield, the margin increases. The comparability of calculated and effective costs as well as calculated and achieved revenues is one of the most important functions of calculation in odoo.



Configuration of Accounting Accounts Receivables



Configuration of Accounting Payables



Configuration of Analytic Tags



Configuration of Calculated Analytic Accounts



Configuration of Customer Analytic Accounts



Configuration of the Costing Journal wich is automatically installed



Configuration of Products



Configuration of Analytic Tags on Products



Configuration of Product Vendors



Configuration of Accounting Accounts on Products



List of Sales Cost Types



Editing of Sales Cost Types



Cost Types, Costing, Cost Margin and Sale Price in Sales



Editing of Analytic Accounts and Analytic Tags in Sales Cost Types



Costing of Sales



Editing the Sales Costing



Load Costing in Sales Quotation



Customer Invoice on Sales Order



Sales Journal Entry from Sales Order and Customer Invoice



Sales Order, Customer Invoice, Sales Journal Entries with Receivable Accounts



Costing Journal on Customer Invoice



Analytic Account on the Journal Entries in Costing Journal



Customer Analytic Account on Sales Order



Budget of Customer Analytic Account on Sales Order



Customer Analytic Accounts on Sales Order, Receiveable, Payable Accounts



Purchase, Customer Analytic Account



Chart of Receivable Accounts



Chart of Payable Accounts



Accounting, Costing Journal



Accounting, Costing Journal Entries from Costing

If you need any help,
please contact us:
Email: support@giordano.ch
Website: www.giordano.ch

Odoo Proprietary License v1.0

This software and associated files (the "Software") may only be used (executed,
modified, executed after modifications) if you have purchased a valid license
from the authors, typically via Odoo Apps, or if you have received a written
agreement from the authors of the Software (see the COPYRIGHT file).

You may develop Odoo modules that use the Software as a library (typically
by depending on it, importing it and using its resources), but without copying
any source code or material from the Software. You may distribute those
modules under the license of your choice, provided that this license is
compatible with the terms of the Odoo Proprietary License (For example:
LGPL, MIT, or proprietary licenses similar to this one).

It is forbidden to publish, distribute, sublicense, or sell copies of the Software
or modified copies of the Software.

The above copyright notice and this permission notice must be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.