Tutorial

How Do I Add Landed Costs to Xero?

L

Landara Team

Import Operations Experts

||7 min read
Share:

To add landed costs to Xero, you need to capture all import costs (freight, duty, clearance fees) and allocate them to your inventory items before recording them as bills.

The challenge is that Xero doesn't natively support landed cost allocation: it treats each invoice as a separate transaction, making it difficult to connect freight charges to the products they relate to.

Most importers end up with one of two problems: either their inventory is valued at supplier cost only (missing 20-40% of true costs), or they're doing manual journal entries every month to adjust.

Why Is Getting Landed Costs Into Xero So Difficult?

Xero is excellent accounting software, but it was not built for importers. Here is where the friction comes from:

Bills and Inventory Don't Connect Automatically

When you enter a supplier invoice in Xero, you can code it to inventory. But when your freight forwarder invoice arrives separately, there is no native way to say "allocate this $1,200 freight charge across the 500 units from PO #1234."

You are left with two choices:

  • Code freight to an expense account (wrong, it should be part of inventory cost)
  • Manually calculate and journal the allocation (time-consuming and error-prone)

Multiple Invoices Per Shipment

A single import shipment typically generates 3-5 separate invoices:

  • Supplier invoice (product cost)
  • Freight forwarder invoice (ocean/air freight)
  • Customs broker invoice (duty, clearance fees)
  • Local delivery invoice (port to warehouse)
  • Insurance invoice (cargo coverage)

Each invoice needs to be paid to the correct supplier for the correct amount. But for inventory valuation, all these costs need to be combined and allocated to products.

Timing Mismatches

Your supplier invoice might arrive in January, freight invoice in February, and customs clearance invoice in March. If you are doing monthly reporting, how do you value inventory correctly when costs arrive at different times?

What Happens When Landed Costs Are Wrong in Xero?

Inaccurate inventory costing creates problems throughout your financial reporting:

Gross margin is misleading: If inventory is valued at supplier cost only, your gross margin looks higher than reality. You think you are making 40% margin when it is actually 25%.

COGS is understated: When you sell products, cost of goods sold is pulled from inventory value. Understated inventory means understated COGS, which means overstated profit.

Inventory valuation is wrong: Your balance sheet shows inventory as an asset. If that asset is undervalued by 20-30%, your financial statements do not reflect reality.

Tax implications: Understated COGS means overstated taxable income. You could be paying more tax than necessary because your costs are not captured correctly.

How Should Landed Costs Flow Into Xero?

The ideal workflow separates two concerns:

  1. Accounts Payable: Pay each supplier their invoice amount (freight forwarder gets paid their $1,200, customs broker gets paid their $450, etc.)
  2. Inventory Valuation: Allocate total landed costs across products so your inventory value reflects true cost

Here is what that looks like in practice:

TransactionAP TreatmentInventory Treatment
Supplier invoice: $10,000Bill to supplier, $10,000Inventory at $10,000
Freight invoice: $1,200Bill to freight co, $1,200Allocate across products
Duty payment: $800Bill to broker, $800Allocate across products
Total$12,000 paid to 3 suppliersInventory valued at $12,000

The end result: your suppliers are paid correctly, and your inventory reflects the true $12,000 cost, not just the $10,000 product cost.

What Are My Options for Landing Costs in Xero?

Option 1: Manual Journal Entries

The DIY approach. Each month, calculate your landed cost allocation in a spreadsheet, then post a journal entry to move costs from expense accounts to inventory.

Pros: No additional software needed

Cons: Time-consuming, error-prone, creates reconciliation complexity

Option 2: Xero Tracking Categories

Use tracking categories to tag freight and duty expenses by shipment, then run reports to see total cost per shipment.

Pros: Built into Xero

Cons: Does not actually adjust inventory value, just gives you visibility. Still need journals to fix COGS.

Option 3: Landed Cost Software Integration

Connect Xero to software that handles the allocation logic, then syncs the correct values back.

Pros: Automated, accurate, maintains clean AP records

Cons: Additional subscription cost

How Does Landara Handle Xero Integration?

Landara is built specifically for this problem. See our Xero integration page for full details. Here is how it works:

Step 1: Connect Your Xero Account

One-click OAuth connection. Landara pulls your chart of accounts, suppliers, and products so everything maps correctly.

Step 2: Upload Your Invoices to Landara

Upload supplier invoices, freight invoices, and customs bills. AI extracts all the cost data automatically with no manual entry.

Step 3: Allocate Costs to Products

Landara allocates freight, duty, and other costs across your products using the method that makes sense: by value, by quantity, or by weight. You see the per-unit landed cost for every product.

Step 4: Publish to Xero

Here is where it gets clever. When you publish from Landara:

  • Bills are created in Xero matching the original invoice amounts (so you pay suppliers correctly)
  • Inventory costs are adjusted to reflect true landed cost (so your valuation is accurate)
  • No manual journals needed: the allocation happens automatically

Your bookkeeper sees clean bills to pay. Your inventory valuation is correct. Your COGS flows through accurately when you sell.

Step 5: Reconcile Normally

Bank feeds match to the bills Landara created. Standard Xero reconciliation, nothing unusual for your bookkeeper to figure out.

Setting Up the Landara-Xero Connection

The initial setup takes about 10 minutes:

  1. Authorize Xero access: Click "Connect to Xero" and approve the connection
  2. Map your accounts: Tell Landara which accounts to use for inventory, freight expenses, duty, etc.
  3. Map your suppliers: Match your freight forwarders and customs brokers to Xero contacts
  4. Set default allocation method: Choose how costs should be split across products

Once configured, each shipment follows the same flow: upload invoices, review landed costs, publish to Xero.

What About QuickBooks?

Landara also integrates with QuickBooks Online using the same approach: accurate bills for AP, correct inventory valuation for COGS. If you are on QuickBooks, the workflow is nearly identical.

Common Questions About Xero Landed Cost Integration

Can I still use Xero's inventory tracking?

Yes. Landara works alongside Xero's inventory features, not instead of them. Products, quantities, and standard costs remain in Xero.

What if I have existing inventory valued incorrectly?

Landara handles new shipments going forward. For historical cleanup, you may need a one-time adjustment journal, and we can help you calculate that.

Do I need to change how my bookkeeper works?

No. Bills appear in Xero like any other bills. Your bookkeeper pays them normally. The landed cost allocation happens behind the scenes.

What accounts does Landara create bills against?

You control the mapping. Typically: inventory asset for product costs, COGS or inventory for allocated freight and duty.

Ready to Get Accurate Landed Costs in Xero?

Connect your Xero account and upload your first shipment. See exactly how much your products really cost, and get your inventory valuation right.

Connect Xero to Landara
L

Written by Landara Team

Import Operations Experts

The Landara team is dedicated to helping importers and ecommerce sellers streamline their landed cost calculations and optimize their import operations.

Related Articles

HALF YOUR P&L ARRIVES ON AUTOPILOTShopifyorders · payoutsfulfilmentsTHE REVENUE SIDE · SOLVEDNative integrations and connector apps movesales, refunds and fees automaticallyDr Bank / Cr Sales ✓THE COST SIDE · MISSINGNo connector knows what your units cost,so COGS and inventory sit wrong all yearTHE FIX: A COSTED JOURNALDr COGS $8,412 / Cr Inventory $8,412Xero / QuickBooksgross profit you can trust,every month, not just at year endRevenue syncs itself. COGS never does, because nothing upstream knows your costs.The missing piece is a cost ledger between Shopify and your books
Tutorial

How Do I Get Shopify COGS Into Xero or QuickBooks?

9 min read

DECODING HS CODESExample: Cotton T-shirt from China6109100010ChapterWhat is it?HeadingWhat type?SubheadingWhat exactly?National CodeCountry-specificDuty Rate16.5%HOW HS CODES WORKChapter 61Knitted or crocheted clothing6109T-shirts, singlets, tank tops6109.10Of cotton6109.10.0010Men's or boys'First 6 digits are international • Last digits vary by countryWHERE TO FIND YOUR HS CODE1Ask your supplierThey ship to many countries, they know the code2Check previous shipmentsLook at past customs documents or broker invoices3Use customs tariff lookupEach country has an online searchable database4Ask your customs brokerThey're experts at classification (that's their job)Wrong HS code = wrong duty rate = overpaying or compliance riskThe right HS code can save you thousands in duty • Always verify before importing
Tutorial

How Do I Find My Product's HS Code?

6 min read