Inventory - Landed Cost allocation
Add the ability to allocate VAT, duty, and freight to items/inventory for landed entry allocation. This is available in competitor solutions.

-
Bryn Parrott commented
I agree that the two requests are similar and should be combined.
-
Bryn Parrott commented
When I order Goods for inventory the cost of shipping is charged by the seller to me and itemised on the bill. From my perspective, this forms part of the cost of the products purchased on the same bill.
The COST price ought include specifically the shipping on inwards inventory (averaged over all the items on a bill) to calculate the cost price when the items are entered on inventory items.How I do it today : I make a complex calculation of all overheads including shipping which is manually added to the cost price plus profit margin to make the selling price. Its pretty laborious, and subject to errors in calculations.
But technically, the inwards shipping is part of the actual cost of the product, and separate to general overheads.
I would like the option to prorate a shipping charge on a bill by value across all the non-shipping items on a bill to determine the cost price entered into inventory by way of a form control added to the billing form.
This would act to transact shipping costs directly attributable to inventory assigned directly to inventory costs, as they are not really overhead expenses. It will make the reported cost of inventory more accurate.Then, other overheads (Advertising, Power, Internet etc) and profit margin are later added to the cost price to form the selling price.
Further, it ought to be possible for Xero to automatically have a set of rules to calculate overheads and margins that are automatically used to adjust selling price, perhaps a periodical batch process. Is this even possible ?
-
Muhammed Jaseel commented
The option to allocate additional costs to inventory, such as freight, customs duty, modifications, and alterations, is a basic feature for most traders. To Accurately calculating the actual cost and margin of inventory the option to allocate cost is essential for the organisation.
It is surprising that Xero does not offer this feature, which is a crucial requirement for many organizations. As a result, many of my customers choose not to use Xero, despite its numerous other beneficial features. -
Sergio Congia commented
Xero can implement a basic Goods Receipt screen where users can confirm the actual quantities received against a purchase order, as well as record additional costs documents for freight and duty costs.
These additional costs documents can be entered against an "Inventory" account type (say for Importation Costs), so that the costs are associated as cost of inventory.
On the screen the user can see the additional costs being apportioned to each item in the Goods Receipt screen. With the newly calculated item costs now appearing on the screen, Xero can use this new value to set the product costs value when posting the product into inventory. This new cost (which includes the import and duty costs) will be used in the PL to calculate the COGS when an invoice is created.
-
Simon Hudson-Peacock commented
As a distributor of imported goods, not being able to allocate Duty and Freight Costs to inventory is motivating me to look for another accounting package.
-
Raymond Rainbird commented
Definitely need this
-
Ravinder Singh commented
Yes, we definitely need this!
-
Lindy McNair commented
This would be invaluable. Yes please.
-
AdminXero Team (Admin, Xero) commented
Ability to include freight into the cost of inventory.
Purpose: For some businesses, freight is a significant portion of the value to determine the cost of an item.