2026-11-14 · QuickBooks Desktop

How to Add Freight, Duty and Tariffs to Inventory Cost in QuickBooks (and Record a Tariff Refund)

↓ Get the free Excel + PDF kit for this article

If you import what you sell - cosmetics from Korea, parts from overseas, packaged food, apparel - your supplier invoice is only part of the story. Ocean freight, customs duty, extra tariffs, broker fees and trucking can add 15-40% to what an item really costs. In QuickBooks those costs usually land in a freight or duty expense account, and the item keeps the supplier price.

That one habit quietly breaks three things: the month you pay freight looks like a loss, the month you sell looks too profitable, and your item cost is too low to set prices with. In 2026 there is a fourth problem - many importers are now receiving refunds of IEEPA tariffs and are not sure where that money goes. This guide shows how to fix all of it with QuickBooks Online or Desktop and a simple spreadsheet.

Stacked bar showing an example supplier price of 16,680 dollars plus freight, duty and fees adding up to a landed cost of 20,558.50 dollars
Figure 1. What goes into landed cost (example values).

Why QuickBooks users get stuck

The question comes up again and again in the QuickBooks Community: how do I add the freight and customs on an import to the cost of each item? The answers are workarounds. QuickBooks Online Plus and Advanced track inventory but have no screen that spreads a freight bill across items. QuickBooks Desktop Enterprise has a landed-cost feature; Pro and Premier do not. And the extra costs usually arrive on different bills, from different vendors, weeks apart.

The good news: the math is simple, and once you have the numbers, entering them takes minutes.

Step 1: List every extra cost and pick how to split it

Gather the supplier invoice, the freight bill, the customs broker's invoice and the entry summary that shows duty. For each extra cost, choose a basis:

Extra costAmountSplit by
Ocean freight (LCL)$1,850.00Volume
Customs duty$1,250.40Value
Broker fee$225.00Quantity
Customs fees$58.10Value
Cargo insurance$75.00Value
Trucking, port to warehouse$420.00Weight

Example values. Total extra costs: $3,878.50.

Tip: if the entry summary lists duty for each line, use those exact amounts per item instead of splitting the total.

Step 2: Allocate with three spreadsheet formulas

Put one item per row with Qty in column B and unit cost in C. In Excel or Google Sheets:

Rounding can leave a cent or two over or under. Add the difference to the largest line so the total matches the bills exactly.

SKUQtySupplier unitGoods valueExtra costLanded totalLanded unit
SERUM-301,200$3.1000$3,720.00$705.06$4,425.06$3.6876
CREAM-50800$4.2500$3,400.00$679.18$4,079.18$5.0990
MASK-10P1,500$2.4000$3,600.00$1,368.22$4,968.22$3.3121
TONER-150600$3.6000$2,160.00$540.57$2,700.57$4.5010
SUN-501,000$3.8000$3,800.00$585.47$4,385.47$4.3855
Total5,100$16,680.00$3,878.50$20,558.50

Example values. Notice the sheet-mask pack rises 38% because it is bulky and heavy, while the sun cream rises 15%.

Comparison table: with freight expensed the unit cost is 2.40 dollars and margin 60 percent; with landed cost the unit cost is 3.31 dollars and margin 44.8 percent
Figure 2. The same product looks 15 points more profitable when freight and duty are expensed (example values).

Step 3: Enter it in QuickBooks Online (clearing-account method)

This follows the workaround Intuit's community staff describe; the spreadsheet supplies the numbers.

  1. Create an account named Landed Cost Clearing (Settings ⚙ → Chart of accounts → New). Other Current Assets is a common type; use what your accountant prefers.
  2. Select + New → Bill and pick the supplier.
  3. In Item details, enter each product with its Qty and the landed total as the Amount.
  4. In Category details, choose Landed Cost Clearing and enter the total extra costs as a negative amount (-3,878.50 in the example). The bill total now equals the supplier invoice.
  5. Enter the freight, broker and duty bills as usual, but post them to Landed Cost Clearing instead of an expense account.
  6. Open the clearing account's register (Chart of accounts → View register). When the shipment is complete, it should show 0.00.

QuickBooks Online values inventory using FIFO, so later sales of these units use the landed cost from this bill.

Step 3 (Desktop): Pro, Premier and Enterprise

  1. Lists → Chart of Accounts → Account → New: create Landed Cost Clearing.
  2. Vendors → Enter Bills: on the Items tab enter each item at its landed total; on the Expenses tab enter Landed Cost Clearing as a negative amount.
  3. Post the freight, broker and duty bills to Landed Cost Clearing on the Expenses tab.

Desktop uses average cost, so the new landed cost blends with units already on hand - that is expected. QuickBooks Desktop Enterprise also has a built-in landed cost tool; the spreadsheet is still useful to plan and check the result.

Step 4: Costs that arrive late, and tariff refunds

Sometimes the freight bill shows up after half the shipment is sold - or a duty refund arrives months later. Split the amount by the share already sold:

Example: $2,400 tariff refundAmount
Units received / units sold1,000 / 650
Reduce Cost of Goods Sold (65%)$1,560.00
Reduce Inventory Asset (35% still on hand)$840.00

Example values.

The journal entry: debit Bank $2,400, credit Cost of Goods Sold $1,560, credit Inventory Asset $840. For a late extra cost, flip the sides and credit Accounts Payable or Bank. In QuickBooks Online a journal entry to Inventory Asset fixes the balance sheet but does not change an item's FIFO cost; if the original bill is in an open period, editing it may be cleaner - ask your accountant. In Desktop, use Vendors → Inventory Activities → Adjust Quantity/Value on Hand with the Total Value adjustment type for the inventory part.

Decision path: if all items are in stock put the cost in the bill item lines; if some are sold split between cost of goods sold and inventory; if all are sold post it to cost of goods sold
Figure 3. Where a late cost or refund should go.

Tariff refunds in 2026: the background

On February 20, 2026 the U.S. Supreme Court ruled in Learning Resources, Inc. v. Trump that IEEPA does not authorize tariffs. Customs and Border Protection set up a refund process in ACE called CAPE, and only the importer of record (or its customs broker) can file. The process has moved in phases and has been the subject of further court action, so check the current status with your customs broker or cbp.gov. Other tariffs, such as Section 232 and Section 301 duties, were not part of that ruling. For your books, the key point is simple: do not book the whole refund as other income if much of the shipment is still in inventory.

Common mistakes

FAQ

Does QuickBooks Online have a landed cost feature?

Not in Plus or Advanced as of this writing; Intuit's community staff point users to the bill and clearing-account workaround above or to inventory apps. QuickBooks Desktop Enterprise has one built in.

Which method should I use for ocean freight?

Volume usually matches how ocean freight is priced. If you do not know cubic meters per item, value is a reasonable fallback - just use the same rule every time.

What if the freight bill covers two shipments?

Split the bill between the shipments first (by value or volume), then allocate each part to its items.

Is a tariff refund taxable income?

It depends on how the duty was treated when you paid it. Ask your tax professional; this article covers bookkeeping only.

Checklist

Disclaimer: This article is educational and is not tax, legal, accounting or customs advice. Rules, CBP procedures and QuickBooks menus change; confirm before you act. All numbers are examples. QuickBooks is a registered trademark of Intuit Inc.; not affiliated with or endorsed by Intuit.

You can download the ready-made Landed Cost & Tariff Refund Allocator 2026 for free in the Free kit download box below (Excel + PDF guide, no sign-up).

Sources

Free kit download

Tools to follow this article step by step. No sign-up needed.

Free to use for yourself and your own business; please do not resell or redistribute. General information, not tax, legal or accounting advice; check every figure against your own records. QuickBooks is a trademark of Intuit Inc.; BIZLEX is not affiliated with Intuit.

← All articles Privacy