- Mailing Lists
- Contributors
- Re: Track sales packaging costs
Archives
- By thread 1419
-
By date
- August 2019 59
- September 2019 118
- October 2019 165
- November 2019 97
- December 2019 35
- January 2020 58
- February 2020 204
- March 2020 121
- April 2020 172
- May 2020 50
- June 2020 158
- July 2020 85
- August 2020 94
- September 2020 193
- October 2020 277
- November 2020 100
- December 2020 159
- January 2021 38
- February 2021 87
- March 2021 146
- April 2021 73
- May 2021 90
- June 2021 86
- July 2021 123
- August 2021 50
- September 2021 68
- October 2021 66
- November 2021 74
- December 2021 75
- January 2022 98
- February 2022 77
- March 2022 68
- April 2022 31
- May 2022 59
- June 2022 87
- July 2022 141
- August 2022 38
- September 2022 73
- October 2022 152
- November 2022 39
- December 2022 50
- January 2023 93
- February 2023 49
- March 2023 106
- April 2023 47
- May 2023 69
- June 2023 92
- July 2023 64
- August 2023 103
- September 2023 91
- October 2023 101
- November 2023 94
- December 2023 46
- January 2024 75
- February 2024 79
- March 2024 104
- April 2024 63
- May 2024 40
- June 2024 160
- July 2024 80
- August 2024 70
- September 2024 62
- October 2024 121
- November 2024 117
- December 2024 89
- January 2025 59
- February 2025 104
- March 2025 96
- April 2025 107
- May 2025 52
- June 2025 72
- July 2025 60
- August 2025 81
- September 2025 124
- October 2025 63
- November 2025 22
Contributors
Re: Track sales packaging costs
In general (accountant's view)
1- A standard, or minimum or what-you-want package cost should be included in product cost, and "absorbed" when you FG is produced
2- The actual cost should be recorded when incurred (order > invoice)
3- The extra-package cost would be the "algebraic sum" of cost incurred and absorbed
4- The total package cost would be the sum of extra and COGS-included package cost or (sould be the same) the total cost incurred referred to the product sold
Ciao
Marco
by Marco Marchiori - 08:30 - 14 Mar 2021
Follow-Ups
-
Re: Track sales packaging costs
Hello,
My requirements on this got more detailed,
and I ended up created a module to allow including other costs in the margin calculation.
I explain it in more detail in the module description, here:
https://github.com/OCA/margin-analysis/pull/97/files#diff-d50d268e9b54e2cef699cc573b93425d9b1def68c6236a52c9c5c613f5f7b3bf
"""
Track expected shipping costs, allowing more accurate margin calculations.
Costs could include packaging, documentation or customs expenses.
These may be consumables or services, not directly included in sales order lines
nor accounted with the invoice.
But we may still ant the Sales Order margin to consider these costs,
especially if business margins are tight.
Also allows for carrier shipping costs to be estimated separately,
instead of being automatically added as a sales order line, to charge the customer.
This is useful in the case the customer is charge with a shipping fee
that can be very different from the actual shipping cost,
or when no shipping fee is charged at all.
In this case the expected shipping costs, computed by the UPDATE SHIPPING COSTS
button, can be stored as Other Costs and considered for the sales order margin,
instead being added as a sales order line and charged to the customer.
"""
I hope this could be of interest for other people.
Thanks
Daniel
On 15/03/2021 09:01, Antonio M. Vigliotti (gmail) wrote:
This trouble looks like delivery cost of Intrastat.
On intrastat statement, all delivery costs (required) and packaging costs (optional) have to be shared in COGS.
Example:
Sale Order
Product Qty Unit Price Subtotal Delivery cost Intrastat value Pack.Cost Prod.A 10,0 € 10,50 € 105,00 € 6,56 € 111,56 € 3,28 Prod.B 10,0 € 5,50 € 55,00 € 3,44 € 58,44 € 1,72 Packaging 1,0 € 5,00 € 5,00
Delivery 1,0 € 10,00 € 10,00
TOTAL
€ 175,00
Tot.Goods & Service 20
€ 160,00 € 10,00 € 170,00 € 5,00
Il 15/03/21 01:56, Marco Marchiori ha scritto:
Graeme
as you said I was not so accurate to include the IAS compliance in the discussion.
In any case we defined the nature of such costs: they are variable costs, they should be included in cogs but they could be allocated, with a sort of ABC, "depending on the sales order composition".
If they are "extra-amounts" (as Daniel said) they should be allocated in addition to the cost (apparently) already included in the product, but of course I would not discuss IAS compliance here!
So I suggested to track them separately (we agree on that).
Then the entry I advised to make was an absorption one, that would work both in continental and anglo-saxon accounting.
If I worked for a business like that (independently from IAS) I would ask myself if it's more important the cost of the product or the cost of the order...
Ciao
Marco
Il giorno dom 14 mar 2021 alle ore 21:57 Graeme Gellatly <gdgellatly@gmail.com> ha scritto:
Hi,
Under IAS2 this advice is not correct. It is very clear that product costs relate to bringing the product to its present location and condition. It cannot include non incurred costs, or costs that form part of the sales process. Now if it forms part of a manufacturing process, then they can be included under costs of conversion, but only if they are part of that conversion. If there is no production process then no costs. If there is then actually the manufacturing process handles it all already because it occurs prior to the sales transaction.
Here is the exact clause.
The cost of inventories shall comprise all costs of purchase, costs of conversion and other costs incurred in bringing the inventories to their present location and condition.
So in this case where the packaging costs are part of the sales process they do not form cost of inventories. Indeed any costs incurred in the selling process are explicitly excluded.
However it should of course be included in Cost of Goods sold, but it is no different to any other cost / revenue required at time of sale (or purchase for that matter), such as rebates, discounts on either the vendor/customer side related to a particular customer. It is a very common use case, and its the same reason you need to accrue warranty liability accrual at time of sale rather than in inventories (or time of claim for that matter). The only tricky part being the management of the sales transaction because you need some way to record that (y), which is variable in this case, but effectively you end up with.
CR Inventory - Product A x
CR Packaging y
DR COGS - Product A (x+y).
Is how I'd do it, probably just adding the packaging to the picking (not the sale) and then overriding the anglosaxon entries to allocate costs.
That is the simple case, Obviously there is a mix of products involved, all utilising the packaging, so a reasonable allocation decision needs to be made, probably a dollar weighted basis, but possibly volume. Under anglo saxon the way Odoo operates it will be a significant amount of work, as you then need to reconcile both sides of the accrual accounts, but really it is no different to the same issue you have with A/P accrual accounts and having to allow for expected rebates.
On Mon, Mar 15, 2021 at 8:32 AM Marco Marchiori <info@marcomarchiori.com> wrote:
In general (accountant's view)
1- A standard, or minimum or what-you-want package cost should be included in product cost, and "absorbed" when you FG is produced
2- The actual cost should be recorded when incurred (order > invoice)
3- The extra-package cost would be the "algebraic sum" of cost incurred and absorbed
4- The total package cost would be the sum of extra and COGS-included package cost or (sould be the same) the total cost incurred referred to the product sold
Ciao
Marco_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--
M a r c o M a r c h i o r iconsulente funzionaledottore commercialista, revisore legale
Via Stazione 12, 30035 MIRANO (VE); telefono e fax 041 488195
codice fiscale MRCMRC67H11F241M; partita IVA 03813290271
--
This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. Use of such information is exclusively reserved for the recipient of this e-mail.
--
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--
Daniel Reis
Managing Director
M: +351 919991307
E: DReis@OpenSourceIntegrators.comAv Doutor Desidério Cambournac 12 • 2710-553 Sintra, Portugal 



by Daniel Reis - 12:16 - 15 Jun 2021 -
Re: Track sales packaging costs
This trouble looks like delivery cost of Intrastat.
On intrastat statement, all delivery costs (required) and packaging costs (optional) have to be shared in COGS.
Example:
Sale Order
Product Qty Unit Price Subtotal Delivery cost Intrastat value Pack.Cost Prod.A 10,0 € 10,50 € 105,00 € 6,56 € 111,56 € 3,28 Prod.B 10,0 € 5,50 € 55,00 € 3,44 € 58,44 € 1,72 Packaging 1,0 € 5,00 € 5,00
Delivery 1,0 € 10,00 € 10,00
TOTAL
€ 175,00
Tot.Goods & Service 20
€ 160,00 € 10,00 € 170,00 € 5,00
Il 15/03/21 01:56, Marco Marchiori ha scritto:
Graeme
as you said I was not so accurate to include the IAS compliance in the discussion.
In any case we defined the nature of such costs: they are variable costs, they should be included in cogs but they could be allocated, with a sort of ABC, "depending on the sales order composition".
If they are "extra-amounts" (as Daniel said) they should be allocated in addition to the cost (apparently) already included in the product, but of course I would not discuss IAS compliance here!
So I suggested to track them separately (we agree on that).
Then the entry I advised to make was an absorption one, that would work both in continental and anglo-saxon accounting.
If I worked for a business like that (independently from IAS) I would ask myself if it's more important the cost of the product or the cost of the order...
Ciao
Marco
Il giorno dom 14 mar 2021 alle ore 21:57 Graeme Gellatly <gdgellatly@gmail.com> ha scritto:
Hi,
Under IAS2 this advice is not correct. It is very clear that product costs relate to bringing the product to its present location and condition. It cannot include non incurred costs, or costs that form part of the sales process. Now if it forms part of a manufacturing process, then they can be included under costs of conversion, but only if they are part of that conversion. If there is no production process then no costs. If there is then actually the manufacturing process handles it all already because it occurs prior to the sales transaction.
Here is the exact clause.
The cost of inventories shall comprise all costs of purchase, costs of conversion and other costs incurred in bringing the inventories to their present location and condition.
So in this case where the packaging costs are part of the sales process they do not form cost of inventories. Indeed any costs incurred in the selling process are explicitly excluded.
However it should of course be included in Cost of Goods sold, but it is no different to any other cost / revenue required at time of sale (or purchase for that matter), such as rebates, discounts on either the vendor/customer side related to a particular customer. It is a very common use case, and its the same reason you need to accrue warranty liability accrual at time of sale rather than in inventories (or time of claim for that matter). The only tricky part being the management of the sales transaction because you need some way to record that (y), which is variable in this case, but effectively you end up with.
CR Inventory - Product A x
CR Packaging y
DR COGS - Product A (x+y).
Is how I'd do it, probably just adding the packaging to the picking (not the sale) and then overriding the anglosaxon entries to allocate costs.
That is the simple case, Obviously there is a mix of products involved, all utilising the packaging, so a reasonable allocation decision needs to be made, probably a dollar weighted basis, but possibly volume. Under anglo saxon the way Odoo operates it will be a significant amount of work, as you then need to reconcile both sides of the accrual accounts, but really it is no different to the same issue you have with A/P accrual accounts and having to allow for expected rebates.
On Mon, Mar 15, 2021 at 8:32 AM Marco Marchiori <info@marcomarchiori.com> wrote:
In general (accountant's view)
1- A standard, or minimum or what-you-want package cost should be included in product cost, and "absorbed" when you FG is produced
2- The actual cost should be recorded when incurred (order > invoice)
3- The extra-package cost would be the "algebraic sum" of cost incurred and absorbed
4- The total package cost would be the sum of extra and COGS-included package cost or (sould be the same) the total cost incurred referred to the product sold
Ciao
Marco_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--
M a r c o M a r c h i o r iconsulente funzionaledottore commercialista, revisore legale
Via Stazione 12, 30035 MIRANO (VE); telefono e fax 041 488195
codice fiscale MRCMRC67H11F241M; partita IVA 03813290271
--
This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. Use of such information is exclusively reserved for the recipient of this e-mail.
--
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Antonio M. Vigliotti - 10:00 - 15 Mar 2021 -
Re: Track sales packaging costs
Graeme
as you said I was not so accurate to include the IAS compliance in the discussion.
In any case we defined the nature of such costs: they are variable costs, they should be included in cogs but they could be allocated, with a sort of ABC, "depending on the sales order composition".
If they are "extra-amounts" (as Daniel said) they should be allocated in addition to the cost (apparently) already included in the product, but of course I would not discuss IAS compliance here!
So I suggested to track them separately (we agree on that).
Then the entry I advised to make was an absorption one, that would work both in continental and anglo-saxon accounting.
If I worked for a business like that (independently from IAS) I would ask myself if it's more important the cost of the product or the cost of the order...
Ciao
MarcoIl giorno dom 14 mar 2021 alle ore 21:57 Graeme Gellatly <gdgellatly@gmail.com> ha scritto:Hi,Under IAS2 this advice is not correct. It is very clear that product costs relate to bringing the product to its present location and condition. It cannot include non incurred costs, or costs that form part of the sales process. Now if it forms part of a manufacturing process, then they can be included under costs of conversion, but only if they are part of that conversion. If there is no production process then no costs. If there is then actually the manufacturing process handles it all already because it occurs prior to the sales transaction.
Here is the exact clause.
The cost of inventories shall comprise all costs of purchase, costs of conversion and other costs incurred in bringing the inventories to their present location and condition.
So in this case where the packaging costs are part of the sales process they do not form cost of inventories. Indeed any costs incurred in the selling process are explicitly excluded.
However it should of course be included in Cost of Goods sold, but it is no different to any other cost / revenue required at time of sale (or purchase for that matter), such as rebates, discounts on either the vendor/customer side related to a particular customer. It is a very common use case, and its the same reason you need to accrue warranty liability accrual at time of sale rather than in inventories (or time of claim for that matter). The only tricky part being the management of the sales transaction because you need some way to record that (y), which is variable in this case, but effectively you end up with.
CR Inventory - Product A x
CR Packaging yDR COGS - Product A (x+y).Is how I'd do it, probably just adding the packaging to the picking (not the sale) and then overriding the anglosaxon entries to allocate costs.
That is the simple case, Obviously there is a mix of products involved, all utilising the packaging, so a reasonable allocation decision needs to be made, probably a dollar weighted basis, but possibly volume. Under anglo saxon the way Odoo operates it will be a significant amount of work, as you then need to reconcile both sides of the accrual accounts, but really it is no different to the same issue you have with A/P accrual accounts and having to allow for expected rebates.On Mon, Mar 15, 2021 at 8:32 AM Marco Marchiori <info@marcomarchiori.com> wrote:
In general (accountant's view)
1- A standard, or minimum or what-you-want package cost should be included in product cost, and "absorbed" when you FG is produced
2- The actual cost should be recorded when incurred (order > invoice)
3- The extra-package cost would be the "algebraic sum" of cost incurred and absorbed
4- The total package cost would be the sum of extra and COGS-included package cost or (sould be the same) the total cost incurred referred to the product sold
Ciao
Marco_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--M a r c o M a r c h i o r iconsulente funzionaledottore commercialista, revisore legale
Via Stazione 12, 30035 MIRANO (VE); telefono e fax 041 488195
codice fiscale MRCMRC67H11F241M; partita IVA 03813290271
--
This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. Use of such information is exclusively reserved for the recipient of this e-mail.
--
by Marco Marchiori - 01:56 - 15 Mar 2021 -
Re: Track sales packaging costs
Hi,Under IAS2 this advice is not correct. It is very clear that product costs relate to bringing the product to its present location and condition. It cannot include non incurred costs, or costs that form part of the sales process. Now if it forms part of a manufacturing process, then they can be included under costs of conversion, but only if they are part of that conversion. If there is no production process then no costs. If there is then actually the manufacturing process handles it all already because it occurs prior to the sales transaction.
Here is the exact clause.
The cost of inventories shall comprise all costs of purchase, costs of conversion and other costs incurred in bringing the inventories to their present location and condition.
So in this case where the packaging costs are part of the sales process they do not form cost of inventories. Indeed any costs incurred in the selling process are explicitly excluded.
However it should of course be included in Cost of Goods sold, but it is no different to any other cost / revenue required at time of sale (or purchase for that matter), such as rebates, discounts on either the vendor/customer side related to a particular customer. It is a very common use case, and its the same reason you need to accrue warranty liability accrual at time of sale rather than in inventories (or time of claim for that matter). The only tricky part being the management of the sales transaction because you need some way to record that (y), which is variable in this case, but effectively you end up with.
CR Inventory - Product A x
CR Packaging yDR COGS - Product A (x+y).Is how I'd do it, probably just adding the packaging to the picking (not the sale) and then overriding the anglosaxon entries to allocate costs.
That is the simple case, Obviously there is a mix of products involved, all utilising the packaging, so a reasonable allocation decision needs to be made, probably a dollar weighted basis, but possibly volume. Under anglo saxon the way Odoo operates it will be a significant amount of work, as you then need to reconcile both sides of the accrual accounts, but really it is no different to the same issue you have with A/P accrual accounts and having to allow for expected rebates.On Mon, Mar 15, 2021 at 8:32 AM Marco Marchiori <info@marcomarchiori.com> wrote:
In general (accountant's view)
1- A standard, or minimum or what-you-want package cost should be included in product cost, and "absorbed" when you FG is produced
2- The actual cost should be recorded when incurred (order > invoice)
3- The extra-package cost would be the "algebraic sum" of cost incurred and absorbed
4- The total package cost would be the sum of extra and COGS-included package cost or (sould be the same) the total cost incurred referred to the product sold
Ciao
Marco_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Graeme Gellatly - 09:55 - 14 Mar 2021