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:
- Accounts Payable: Pay each supplier their invoice amount (freight forwarder gets paid their $1,200, customs broker gets paid their $450, etc.)
- Inventory Valuation: Allocate total landed costs across products so your inventory value reflects true cost
Here is what that looks like in practice:
| Transaction | AP Treatment | Inventory Treatment |
|---|---|---|
| Supplier invoice: $10,000 | Bill to supplier, $10,000 | Inventory at $10,000 |
| Freight invoice: $1,200 | Bill to freight co, $1,200 | Allocate across products |
| Duty payment: $800 | Bill to broker, $800 | Allocate across products |
| Total | $12,000 paid to 3 suppliers | Inventory 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:
- Authorize Xero access: Click "Connect to Xero" and approve the connection
- Map your accounts: Tell Landara which accounts to use for inventory, freight expenses, duty, etc.
- Map your suppliers: Match your freight forwarders and customs brokers to Xero contacts
- 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