Aantar

Aantar Books

Landed Cost

Put a customs broker's or carrier's bill (freight, duty, brokerage) on the goods it brought in, through the Landed Cost Clearing account, spread by quantity, cost, weight, volume or by hand, so each item costs what it really cost you.

Where: Vendors ▸ Landed Cost…

When you import goods, the supplier's invoice is only part of what they cost. A customs broker bills you for duty and brokerage, and a carrier bills you for freight. Landed Cost puts those bills on the goods they brought in. Each item's cost then includes its share, so your margins and every later sale use the true cost.

Before you start: the Landed Cost Clearing account

The broker's or carrier's bill is entered in their name, like any other bill, with its Expenses line to Landed Cost Clearing. That is a current asset account on your balance sheet, not an expense: the charge never reaches your profit and loss unless the goods were already sold. It holds the charges until they are put on goods.

  • Entering their bill posts Dr Landed Cost Clearing and Cr Accounts Payable (in their name, owed in Pay Bills).
  • Putting it on goods posts Dr Inventory and Cr Landed Cost Clearing.
  • So the balance of Landed Cost Clearing is the charges entered and not yet put on goods. The Landed Cost window shows it under 1. The landed cost bill.

The setup wizard and Set up everything in Accounting Setup create Landed Cost Clearing and choose it under Landed cost (freight, duty, brokerage) to put on goods. If your company was set up before it existed, or that role points at an expense account such as Freight-in, Aantar Books creates it the first time you add a charge and uses it for new charges. Charges put on goods before stay exactly as they were posted, and a broker's bill already entered to the old account still waits here to be put on goods.

Sub-accounts and the account itself. You can add sub-accounts under Landed Cost Clearing (for example Customs Duty Clearing) and enter a broker's bill to one; it is listed here and put on goods out of that sub-account. Add a charge owed to… has an Account box for it. Landed Cost Clearing itself is a protected system account (see Chart of Accounts), and the account landed charges use is chosen in Preferences ▸ Items & Inventory ▸ Landed cost.

Step by step

  1. Enter the product vendor's bill as usual in Vendors ▸ Enter Bills, with the goods on the Items tab.
  2. Enter the broker's or carrier's bill in Enter Bills, in their name. On the Expenses tab, put the amount (the duty, brokerage, freight) on Landed Cost Clearing, with its tax code. (Or skip this step and use Add a charge owed to… on the product bill, which enters their bill for you. See Bill lines.)
  3. Choose Vendors ▸ Landed Cost….
  4. Under 1. The landed cost bill, choose the broker's bill. Each bill shows its amount and how much is left to put on goods.
  5. Under 2. The goods it goes on, find the product bill(s): type a vendor name, bill number or purchase order number, or change the dates, and click Find. A purchase order that was received finds the bill it was received into, marked (PO …). A purchase order not yet received is shown in red and cannot be ticked: receive it first. Tick every bill the charge belongs to. You can tick several; one container often brings goods from more than one supplier.
  6. Under 3. Spread it, choose the Charge type (Freight, Customs Duty, Brokerage, Shipping, Handling, Insurance or Other), add a Memo if you like, check the Amount (it starts at everything left on the broker's bill; you can put part of it on now and the rest later) and choose how to spread it:
    • By quantity: the same amount on every unit. Right for a courier or freight bill on similar items.
    • By cost: each line's share of the goods' value. Right for duty, which is charged on value.
    • By weight: each line's quantity times the item's Weight (set on the item in Items & Services). Right for freight charged by the kilo. The grid shows each item's weight; an item with no weight takes no share, and if none has a weight Aantar Books says so and does not spread it.
    • By volume: each line's quantity times the item's Volume (m³) (set on the item in Items & Services). Right for ocean freight charged by the cubic metre (CBM). An item with no volume takes no share, and if none has a volume Aantar Books says so and does not spread it.
    • By hand: type each line's amount yourself, for example to put it on some items and not others. The lines must add up to the amount.
    • By percentage (in Add a charge owed to… on a bill, see Bill lines): type each line's percentage of the charge, for example 75% and 25%. The percentages must add up to 100%; each line's money is shown beside it, worked out to the cent with the last cent on the biggest share.
  7. Check the grid: each line shows its bill, its SKU / Code (to find an item quickly), the item, its Unit cost now, its Landed cost share and its New unit cost.
  8. Click Put on goods.

What it does to the books

  • Each item's cost goes up by its share. The supplier's price on the bill is not changed; the landed cost is kept beside it.
  • Each product bill's entry moves the amount from Landed Cost Clearing into Inventory. When everything is put on goods, Landed Cost Clearing is back to zero.
  • Goods already sold when the charge arrives: on Average cost (the Aantar Books default, see Preferences), sales keep the cost they were recorded at, so the share of the charge belonging to the units already sold goes to Cost of Goods Sold, and only the share still on the shelf goes into Inventory and raises the average. For example, $1,000 of freight on goods 40% sold puts $400 in Cost of Goods Sold and $600 in Inventory. Units written off with an inventory adjustment count the same way as units sold: they are no longer on the shelf, so their share goes to Cost of Goods Sold too. That part is its own entry on the product bill, dated the broker's bill date, and it comes off again if you take the charge off. On FIFO, the sales of those goods are re-costed instead.
  • Tax: recoverable GST/HST (and QST where you are registered for it) goes to the input tax credit account as on any bill, never into the item cost. Tax that is not recoverable, such as BC, Saskatchewan or Manitoba PST, or GST/HST for a business not registered for it, is part of what the goods cost: it goes on the goods with the charge. On a $100 BC customs bill with GST and PST, $5 is ITC and $107 goes on the goods.

Where you see it

The landed cost is part of what an item cost, everywhere Aantar Books shows a cost:

  • Product 360 — the Cost tile is the last purchase's price plus its landed cost, for example $12.00 (incl. $2.00 landed), and LAST PURCHASE adds + $2.00 landed cost a unit. The margin is worked out on it.
  • Inventory Valuation Summary — each item at the average cost of its stock on hand, landed cost included, which is what the Inventory Asset account carries it at; the notes give the landed cost in the total. Stock no purchase accounts for is valued at the item's own cost.
  • Inventory Valuation Detail — a bill's Unit price includes its landed cost.
  • Stock Movement Summary — Closing value at cost uses the same cost as the Valuation Summary.
  • Item Listing — Cost is the average cost of the stock on hand, landed cost included (the item's own cost when none has been bought).
  • Account ledgers — Landed Cost Clearing's (or Freight-in's) lines say where each charge went: Landed onto Bill 1234 (Safex) from Bill 88 (Carrier), or Landed cost on goods already sold for the part that went to Cost of Goods Sold, and double-clicking opens that bill. See Chart of Accounts.
  • Landed Cost Detail report — every charge, item by item: vendor, vendor invoice #, the goods bill, charge type, method, quantity, the unit cost before and after, the amount and the part that went to Cost of Goods Sold. See Inventory reports.

It is refused, with the reason, when it would change a document in a closed period (including the part for goods already sold, dated the broker's bill date), or when the goods have been sold across more than 300 documents.

Taking it off again

Tick Show used up to see broker's bills that are already fully put on goods. Take off goods beside a bill removes everything it put on goods: the items go back to their supplier's price, the amount is all left on the broker's bill again, and sales are re-costed.

Charges typed on a bill

A bill's own Freight & duty window (see Bill lines) is still there for freight that is on the product bill itself. What came from a broker's bill is listed there as From … — change it in Vendors ▸ Landed Cost, and is counted in the unit costs it shows.

Note: You enter the landed cost bills to a Landed Cost account and then allocate them to item bills by quantity, by cost, by weight, by volume or manually. The window also shows purchase order numbers and the split for goods already sold.

Common problems

My broker's bill is not listed. Its Expenses line must be on Landed Cost Clearing (or the account your company used for landed cost before), and the bill must be saved. A bill already fully put on goods shows only with Show used up ticked.

Landed Cost Clearing has a balance. That is charges entered and not yet put on goods. Each one is listed under 1. The landed cost bill with what is left of it; put it on goods to clear it.

It says a purchase order has not been received. A charge goes on goods you have. Receive the order (Receive Items, or Enter Bills from the PO), then put the charge on it.

The Put on goods button says the lines do not add up. With By hand, the amounts typed on the lines must add up exactly to the Amount.

It says the percentages do not add up to 100%. With By percentage, the percentages typed on the lines must add up to 100%. The Total under the lines turns red until they do.

Related articles

Something unclear or out of date? Write to support@aantar.com and name this page.