Landed cost expense distribution

Landed cost expense distribution

A landed cost is the total price of a product once it has arrived at the buyer's door.

The landed cost includes:

  • the original price of the product

  • all transportation fees

  • customs

  • duties

  • tax

  • insurance

  • currency conversion

  • crating

  • handling

  • payment fees and any other costs outside our direct inventory purchase cost.

These costs are typically applied by handling or fulfillment services under their own invoice, which then needs to be allocated to the correct purchase invoices. Expenses can also be allocated in this way to Assemblies, Stock Transfers and Production Runs.


Landed Costs can also be allocated via the Additional Costs section of a Purchase order, to Purchase tasks.

Landed Costs can also be allocated via a Manual Journal for Purchases, Stock Transfers, Assemblies and Production Runs. Cin7 Core are actively developing more support for different methods of expense distribution and this area is likely to be updated frequently.

Note: Journal entries for Cost of Goods Sold, including purchase costs and landed costs, are generated upon the authorization of the sale ship tab. The effective date of the COGS journal will be the ship authorization date.

Upon the authorization of the sale shipping tab, a single COGS journal will be created from the PO invoice, Manual Journal tab and any landed costs allocated from separate invoices.

However, if landed costs were added after the item was shipped, then a second COGS journal will be added later. The effective date will be the landed cost authorization.

Prerequisites

 

Allocate landed costs to a purchase using additional costs

Cin7 Core allows you to choose whether or not you allocate additional costs to a product's COGS during a purchase. These costs will increase the stock on hand value of your inventory.

To allocate additional costs to products on a purchase order, make sure that the account specified for the additional cost is the same as the inventory account for the products.

Note: The landed cost will be distributed based on the total amount of each product included in the PO and will not be based on the weight or unit of the product. The landed cost is not divided equally, but allocated proportionally, based on each invoice line cost to the total invoice amount.

To allocate costs based on product Quantity, Weight, Volume, or choose manual allocation of costs, see Allocate Landed Costs to a Purchase using a Manual Journal.

Exclude expenses from a product's cost

To exclude additional costs from a product's cost, simply set the account for those lines to an expense account that is separate from the account used for the products.

  

Allocate Landed Costs to a Purchase, Stock Transfer, Assembly or Production Runs using a Manual Journal

Manual journals can be used to allocate expenses to products for Purchases, Stock Transfers, Assemblies and Production Runs. Cin7 Core are working on expanding the expense distribution options available - this area is under active development.

You can find the Manual Journals tab on the task screen. Allocated expenses will increase the stock on hand value of your inventory. To capitalise a manual journal expense, the debit account should be set to the same inventory account as the item lines.

  

In the Type field, you can select from the dropdown menu how the manual journal expense will be distributed among the purchase order products. The available options are:

  • Cost: The landed cost will be allocated proportionally based on each invoice line cost. Available for Purchase, Stock Transfers, Assemblies and Production Runs.

  • Quantity: The landed cost will be allocated proportionally based on the total quantity of products in the purchase order. Available for Purchase and Stock Transfers.

  • Weight: The landed cost will be allocated proportionally based on the weight of the products in the purchase order. Ensure product weight and dimensions are properly configured for all products before selecting this option. Available for Purchase and Stock Transfers.

  • Volume: The landed cost will be allocated proportionally based on the volume of the products in the purchase order. Ensure product weight and dimensions are properly configured for all products before selecting this option. Available for Purchase and Stock Transfers.

  • Manually: Allows landed costs to be manually added to each line as the user requires. See below for more details. Only available for Purchases and Stock Transfers.

 

If Type: Manual is selected, you will see the option to View more. Save the journal and click View more to display the purchase order invoice lines. This type of expense allocation is available for purchase tasks and stock transfer tasks.

  

Allocate the manual journal amount to the invoice lines as required. Authorize the manual journal to finish.  This can then be edited manually if required.

  

Allocate Landed Costs to a Purchase, Stock Transfer/Stock Adjustment, Assembly or Production Run from a separate invoice

Costs for purchases, stock transfers/stock adjustments, assemblies and production runs are often applied by handling or fulfilment services under their own invoice, rather than as an additional cost at the time of the task. These costs can be allocated to the task as shown below.

To allocate landed costs to an invoice:

  1. Navigate to Purchases → New → Simple Purchase. Service purchases can also be used to allocate expenses.

  2. Select Blind Receipt in the document header.

  3. Enter the landed cost invoice details.

  4. Enter the costs in the Additional Costs panel. In this case, the costs include insurance of $150 and shipping of $350.

  5. Click Authorize.     

  6. Click the Expenses button which has now appeared.
         

  7. Select an expense to distribute.

  8. Click the +Allocation button and select what type of task you want to distribute the expenses to: Purchase, Assembly or Stock Transfer, or Production Run.

  9. You can choose to allocate expenses to a single task or multiple tasks. You can either:

    • manually type in the cost you want to allocate to each invoice

    • or click Auto-allocate to have the system do it for you. Allocated costs are calculated proportionally based on the invoice cost.

  10. Save.

  

Note: The landed cost will be distributed based on the total amount of each product included in the task and will not be based on the weight or unit of the product. The landed cost is not divided equally, but allocated proportionally, based on each invoice line cost to the total invoice amount.

To allocate costs based on product Quantity, Weight, Volume, or choose manual allocation of costs, see Allocate Landed Costs to using a Manual Journal.

We can now see that links to the tasks have been created. Click the link to go to the relevant task.
     

The allocated expenses can be viewed by clicking the Manual Journals tab of the linked documents. This can then be edited manually if required.
     

Was this article helpful?

Have more questions? Submit a request