Landed cost is the total price of a product or shipment once it has arrived at a buyer's doorstep.

With the beginning of a new year, Intuit has released new versions of QuickBooks Desktop 2020 Pro, Premier, Accountant, Enterprise and Mac. These updated versions are complete with new and improved features to help you run your business. The tools are to empower you and help you work more efficiently.

Landed Cost is available in QuickBooks Desktop Enterprise 2020 with a Platinum Subscription and Advanced Inventory enabled.

How To Access It

From the menu bar, select
Edit -> Preferences -> Items & Inventory -> Company Preferences -> Advanced Inventory Settings -> Landed Cost tab -> Setup Landed Cost Account.

NOTE: The Landed Cost setup requires that you create an Other Current Asset type account and map to this account any Other Charge item types that have or will be used for freight, duties and other related landed costs. The type of account to be used may change with future releases of QuickBooks.

Feature Benefits:  The cost of obtaining inventory stock includes more than just the material costs of the items. With the new Landed Cost feature, QuickBooks Enterprise users will have greater visibility into actual product costs by factoring in freight, duties, insurance and other miscellaneous landed costs. Calculated by quantity, value, weight or volume.

Landed Cost Work-Flow Summary

  1. Set up Landed Costs in Advanced Inventory preferences. This preference setup creates an Other Current Asset account, or the user can select an existing Other Current Asset account for accruing unallocated landed costs.
  2. In the setup, select all Other Charge item types currently used to record freight, duties, import fees or other landed cost items. If none exist, the user can create them during the preference setup. During the preference setup, the assigned expense account is changed or defaulted to the newly-created Other Current Asset account. Quickbooks Landed Cost Example Image 1
  3. Bills are entered for freight, duties, import fees and other product costs using the Other Charge items on the Items tab of expense transactions. The accounting result is to increase (debit) the Other Current asset account balance created during the setup and increase (credit) the Accounts Payable account balance for the freight, duties or other related costs vendor. Quickbooks Landed Cost Example Image 2
  4. To allocate the accrued Landed Costs (credit the Other Current Asset account and debit Inventory Asset or Cost of Goods Sold) select a bill with inventory purchases recorded on the Items tab. Select the Calculate Landed Cost button on the top right. The Calculate Landed Cost window displays. Quickbooks Landed Cost Example Image 3
  5. Enterprise users select which freight bills to allocate to the product costs and how to calculate the allocation: Quantity, Percentage, Amount or S&H Cost (manual). Quickbooks Landed Cost Example Image 4
  6. Landed Costs will then offer the user the option to update the Selling Price for selected inventory item(s). The New Selling Price is manually entered and, if Update & proceed is selected, will update the default Sales Price in the Item record. Quickbooks Landed Cost Example Image 5
  7. Whether or not the user updates the new selling price, Enterprise will increase the average cost of the product. The Inventory Asset account will be increased (debited) in the case where the inventory is not sold out, or the Cost of Goods Sold account(s) will be increased (debited) in the case where the inventory is already sold out. All this will take place while not affecting the original amount being paid to supplying vendor. Quickbooks Landed Cost Example Image 6
  8. Enterprise maintains the original vendor bill amount by decreasing (crediting) the Other Current Asset account assigned in the Landed Cost preference setup for the amount of the allocated landed costs. Quickbooks Landed Cost Example Image 7 Quickbooks Landed Cost Example Image 8 Quickbooks Landed Cost Example Image 9

Kemper has QuickBooks ProAdvisors in your area ready to help! Contact us today to learn more about the improvements to QuickBooks Desktop 2020

QuickBooks ProAdvisor Badges