Skip to content

Preliminary Costing and Costing in odoo

Module: Preliminary Costing and Costing in odoo (gio_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 quotationAfter 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 Accounts Receivables

Configuration of Accounting Payables

Configuration of Accounting Payables

Configuration of Analytic Tags

Configuration of Analytic Tags

Configuration of Calculated Analytic Accounts

Configuration of Calculated Analytic Accounts

Configuration of Customer Analytic Accounts

Configuration of Customer Analytic Accounts

Configuration of the Costing Journal wich is automatically installed

Configuration of the Costing Journal wich is automatically installed

Configuration of Products

Configuration of Products

Configuration of Analytic Tags on Products

Configuration of Analytic Tags on Products

Configuration of Product Vendors

Configuration of Product Vendors

Configuration of Accounting Accounts on Products

Configuration of Accounting Accounts on Products

List of Sales Cost Types

List of Sales Cost Types

Editing of Sales Cost Types

Editing of Sales Cost Types

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

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

Editing of Analytic Accounts and Analytic Tags in Sales Cost Types

Editing of Analytic Accounts and Analytic Tags in Sales Cost Types

Costing of Sales

Costing of Sales

Editing the Sales Costing

Editing the Sales Costing

Load Costing in Sales Quotation

Load Costing in Sales Quotation

Customer Invoice on Sales Order

Customer Invoice on Sales Order

Sales Journal Entry from Sales Order and Customer Invoice

Sales Journal Entry from Sales Order and Customer Invoice

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

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

Costing Journal on Customer Invoice

Costing Journal on Customer Invoice

Analytic Account on the Journal Entries in Costing Journal

Analytic Account on the Journal Entries in Costing Journal

Customer Analytic Account on Sales Order

Customer Analytic Account on Sales Order

Budget of Customer Analytic Account on Sales Order

Budget of Customer Analytic Account on Sales Order

Customer Analytic Accounts on Sales Order, Receiveable, Payable Accounts

Customer Analytic Accounts on Sales Order, Receiveable, Payable Accounts

Purchase, Customer Analytic Account

Purchase, Customer Analytic Account

Chart of Receivable Accounts

Chart of Receivable Accounts

Chart of Payable Accounts

Chart of Payable Accounts

Accounting, Costing Journal

Accounting, Costing Journal

Accounting, Costing Journal Entries from Costing

Accounting, Costing Journal Entries from Costing

Ihre Angaben

Branche

Bitte wählen Sie Ihre Branche und odoo Version aus:

Nach Ihrer Registrierung erhalten Sie die Zugangsdaten für Ihre oben ausgewählte Branche und odoo Version per E-Mail.
Bitte beachten Sie, dass die Demodatenbanken mit Ihren Testdaten nach einer Woche wieder zurückgesetzt werden.

Bei Fragen stehen stehen wir Ihnen gerne zur Verfügung. Sie erreichen uns telefonisch unter 071 228 40 63 oder per E-Mail an info@giordano.ch.

Viel Spass mit odoo!

giordano.ch ag
teufener strasse 11 | CH-9000 st.gallen
telefon 071 228 40 63 | telefax 071 228 40 60
info@giordano.ch | http://www.giordano.ch

Sehr geehrte Dame,
Sehr geehrter Herr

Vielen Dank für Ihre Registration.
Sie erhalten in Kürze eine Mail mit Ihren Zugangsdaten.
Bei Fragen stehen stehen wir Ihnen gerne zur Verfügung. Sie erreichen uns telefonisch unter 071 228 40 63 oder per E-Mail an info@giordano.ch.

Viel Spass mit odoo!

giordano.ch ag
teufener strasse 11 | CH-9000 st.gallen
telefon 071 228 40 63 | telefax 071 228 40 60
info@giordano.ch | http://www.giordano.ch

Bitte bestätigen