Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

How to get costs of Products in Analytic Account

Subscribe

Get notified when there's activity on this post

This question has been flagged
salecostanalyic
3 Replies
6260 Views
Avatar
Gillig + Keller GmbH

I would expect the costs of sold products to be tracked in the analytic account linked with the sales order but Odoo seems not to do this.

Why is that and is there a module available which provides this feature?

Our goal is to have one place for reviewing the rentability of sales orders. Analytic accounts seem to provide most of this functionality (they keep track timesheet costs and invoices). Or should we look in another direction?

0
Avatar
Discard
Avatar
Martijn Vanallemeersch
Best Answer

@Gillig + Keller GmbH did you find an answer for this we are also looking for something related?

Regards

0
Avatar
Discard
Avatar
bunhin
Best Answer

Odoo is tracking only cost from purchase and revenues from sales on its analytic feature.  The lacking in the analytics is the tracking cost of internal overhead.  Such as for equipment owned by a company that is used for certain hours for a project, man-power cost doing the task on the project, need to create journal entry if it is needed in PnL, while not make a double entry of the cost  (so need to credit the depreciation expenses account or salary expenses account as the contra on journal item entry for such cost on a project).

0
Avatar
Discard
Avatar
Ray Carnes (ray)
Best Answer

Analytic accounts only track revenues from Sales Orders.

Expenses are tracked on Purchase Orders.

If you purchase a product for a Customer then the cost of that product would be recorded when the Vendor Bill for the Purchase Order is validated.

0
Avatar
Discard
Jorge Rodríguez

Ray Carnes:

The cost of the products in the moment of the purchase should not be taken to analize revenue, That is completely wrong unless you have no other choise, which means that you are not integrating your inventory with your accounting, but Odoo already does that.

Ray Carnes (ray)

If you purchase product X specifically for Customer Y for Project Z then it is fine to use the cost, as that is the product you are giving them. You statement relates to using Purchase Orders for products that won't be guaranteed to ship to the Customer.

Gillig + Keller GmbH
Author

We have a lot of products which are not specifically purchased for a customer / sales order.

One type of our products is purchased in large quantities and sold as needed.

Other products are raw materials which are used to produce sellable products.

In both cases we need the cost of these products in the analytic account.

Ray Carnes (ray)

You can also review the margin for products in other ways - if you check on "Margins - show margins on orders" in Sales you can then turn on the margin and cost fields and see both on every order - if you check or "Margin Analysis - Monitor your product margins from invoices" in Accounting you get the "Product Margins" report.

Jorge Rodríguez

If your company purchase for a specific customer/project, there is still no guarantee that the customer will buy them all or that a total consumption will be achieve, you must consider scrapped products or delivery issues for instance. What you are stating means that the COGS, valuation methods and IFRS are not needed.

Companies use "analytics accounts" because it is the only feature that fits for the set up of their business lines, business units, projects (among others) and because in the end what they need is to meassure their profitability. So it is a serious matter that the COGS are not automatically integrated with the analytic accounts, specially since you already have them linked in the sales orders.

Gillig + Keller GmbH
Author

Ray Carnes:

We don't need margins for products. We need to analyse our sales / projects.

We need to keep track of all the costs accumulating on a project.

We have costs from working hours in office and on site and record these costs in the analytic account of the sale / project via time tracking.

We have costs from buying products specifically for one products. Selecting an analytic account for products in incoming invoice registers these costs on the analytic account of this sale / project.

And, like I said, we have products in stock for direct usage in different sales or for production of sellable products. And we need to keep track of the costs of these products used for sales / projects.

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
calculate sale price and cost price
sale cost calculate
Avatar
0
Feb 17
8053
one worker, 2 customers, differen sale/cost price
sale price cost different
Avatar
Avatar
Avatar
2
Mar 15
4284
Issue After Migration: Unable to Save Sales Order in v18 Solved
sale
Avatar
Avatar
1
May 25
1917
How to set serial numbers for the sale order line
sale
Avatar
Avatar
Avatar
2
Feb 25
10864
Product process cost from planned operation duration Solved
cost
Avatar
1
Apr 22
2832
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now