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
    • Artificial Intelligence
    • 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
    • Property 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
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

Valuation of inventory in transit

Subscribe

Get notified when there's activity on this post

This question has been flagged
inventorycogs
1 Reply
3394 Views
Avatar
Cyril N

Hello,

Is there a way to account for inventory in transit in the inventory valuation (ie. should be in the balance sheet).

For example, let's say I'm invoiced for €1000 on January 1st (invoice is sent when order is created and we pay upfront, before shipping).

If I receive the goods in February, currently, the inventory value on January 31st will be 0, but the purchases will be €1000.

This causes the balance sheet to have 0 inventory COGS to be -1000€ (as there is no change in inventory, which is incorrect).

I should have value of inventory on hand of 0€, but stock in transit should be 1000€ as this was already invoiced. And the COGS should be 0, not -1000€.

Thank you

0
Avatar
Discard
Avatar
Binkal Vadaliya (biva)
Best Answer

To properly account for inventory in transit in your inventory valuation and balance sheet, you can follow these steps:


1. Create an "Inventory in Transit" Account:

   - Set up a new account in your Chart of Accounts called "Inventory in Transit."

   - This account will track the value of goods that have been invoiced but not yet received.


2. Record the Purchase Invoice:

   - When you receive the invoice, record the purchase with a debit to "Inventory in Transit" and a credit to Accounts Payable.

   - This ensures the cost is reflected on your balance sheet as an asset, even though the goods have not yet been received.


3. Receive the Goods:

   - When the goods physically arrive, transfer the amount from "Inventory in Transit" to your regular Inventory account.

   - Create a journal entry to debit your Inventory account and credit "Inventory in Transit."


4. Inventory Valuation and Balance Sheet:

   - At the end of the period, your balance sheet will correctly reflect the €1000 in inventory as "Inventory in Transit" until the goods are received.

   - This approach keeps the Cost of Goods Sold (COGS) at 0 until the inventory is actually received and ready for use or sale.


By using this method, your financial statements will accurately reflect the value of inventory in transit and avoid the issue of showing a negative COGS.

0
Avatar
Discard
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
Multi-Warehouse Replenishment Issue Solved
inventory
Avatar
Avatar
Avatar
2
Jun 26
2152
Productos vendidos almacenados físicamente: sin impacto en inventario y contabilidad
inventory
Avatar
Avatar
Avatar
2
May 26
1558
Change Location for Physical Inventory Adjustment
inventory
Avatar
Avatar
1
Feb 26
2185
revalue the stock Solved
inventory
Avatar
Avatar
Avatar
2
Feb 26
2161
Return on inventory transfers V18
inventory
Avatar
Avatar
Avatar
2
Jan 26
2005
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 Svenska ภาษาไทย 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