Landed Cost Procedure for Importers

Your MYOB software cannot automatically apportion landing costs to individual line items. This procedure is a workaround to ensure that:

  1. Stock on Hand is valued at full landed cost
  2. Cost of Sales reflects landed cost of stock sold
  3. Actual landed costs can be easily identified

Please follow these instructions to set up

Setup Steps

  • Set up cost of sales accounts list as per the example:

Other actual landed costs accounts may be set up if required.

Set up stock items as normal as per the example:

Set up a Landed Cost Adjustment item as follows:

Steps to be completed for each shipment that arrives

Complete an Excel spreadsheet for the imported shipment to allocate the landed costs to the individual items.

Example:

Formulas in the above spreadsheet:

In your MYOB software, enter a purchase from the supplier for the items at full landed cost, and on the last line enter a negative Landed Cost Adjustment

Example:

There may be a rounding amount as in this case ($0.19), just leave as is.

As invoices are received for actual landed costs, enter these using service purchases and code to respective cost of sales accounts.
(Remember that Customs GST does not form part of the cost of the goods and should be coded to a separate GST Liability Account!)

Example:

    Lynley Averis

    Lynley is an MYOB Certified Consultant & has been involved in training in New Zealand since 1985. She's written various accounting & MYOB workbooks including co-authoring “Bookkeeping for Dummies”. She has consulted on all versions of MYOB Accounting, Retail and Payroll over the past 18 years and has previously worked for MYOB. She currently consults to NZ businesses on all aspects of business systems - her mission for clients is for them to spend as little time as possible doing accounting!

    Comments are closed