How can I set Opening Stock without affecting a COGS account (Cost of Revenue)?
Initial Inventory should only show in an asset account. All transactions that take place after the initial setup would then post to the correct accounts.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
How can I set Opening Stock without affecting a COGS account (Cost of Revenue)?
Initial Inventory should only show in an asset account. All transactions that take place after the initial setup would then post to the correct accounts.
Example:
You have a Trial Balance with $10,000 worth of Inventory on it.
Your opening Inventory:
1. Create a clearing account for your Inventory summary balance (from the Trial Balance) and debit THAT account instead of the inventory current asset account when you import your Trial Balance.
2. Prior to creating the opening Inventory Adjustment, set that clearing account as the Stock Valuation Account (received) account on the Inventory adjustment location:
3. Create and Validate your Inventory adjustment. You will see, for each product, that the inventory current asset account defined on the category of each product will be used for the debit and the clearing account will be used for the credit.
If you have a good match between the summary of your inventory from the trial balance and the detail in your adjustment (including accurate costs on each product) then you should see a total of $10,000 in credits that will offset the debit posted to the clearing account during the first step. This will bring the balance of the clearing account to $0. If it is not $0 you do not have a good match between the summary and detail of your inventory and should resolve the difference until it is not material, then you can expense any remaining amount.
4. Set your inventory adjustment account on both the Incoming and Outgoing Stock Valuation Account fields on the Inventory Adjustment location - this makes sure that all future adjustments correctly account for "lost" and "found" inventory by using the adjustment account instead of the opening inventory clearing account (or the default stock interim (received) account.
In summary:
After you are done, there will be nothing in the clearing account, and $10,000 in the inventory current asset account, which came from the inventory adjustment.
Thank you for the reply.
Why would Opening Stock affect any account with the exception of asset?
In Odoo, when you create or add inventory in the system, only the interim received and valuation accounts are affected. The COGS account is impacted only when you sell the product. Therefore, if you want to add opening inventory, the COGS account will not be affected.
You can refer to the documentation regarding the COGS account and valuation for more details. https://www.odoo.com/documentation/17.0/applications/inventory_and_mrp/inventory/warehouses_storage/inventory_valuation/inventory_valuation_config.html
相关帖文 | 回复 | 查看 | 活动 | |
---|---|---|---|---|
|
0
2月 25
|
462 | ||
|
2
3月 25
|
5298 | ||
|
2
3月 25
|
548 | ||
|
1
2月 25
|
692 | ||
|
1
12月 24
|
1249 |