Multi-Location Inventory Tracking with ConnectStock

Why multi-location inventory is an accounting problem

Counting on-hand units across locations is a logistics question. Reporting on inventory correctly is an accounting question. Most multi-marketplace sellers can answer the first one (their 3PL portal tells them) and cannot answer the second one.

The accounting questions that get hard with multi-location:

• What's the total dollar value of inventory on the balance sheet, by location, at landed cost?
• When a unit sells from FBA, what landed cost gets posted to COGS? (The cost might be different from the same unit at the 3PL.)
• When a transfer happens from 3PL to FBA, how is the cost moved between locations?
• When freight is paid mid-transit, how is the cost allocated to the units that arrive across two separate POs?
• How do you reconcile the inventory ledger to the count from each fulfillment center monthly?

Most generic inventory tools (TradeGecko, Cin7, Skubana) answer the count questions but stop short of the accounting. ConnectStock is built to handle both.

What ConnectStock tracks

Five location types out of the box:

• Amazon FBA warehouses (treated as one location for accounting, with subdivision available if your operation needs FNSKU-level tracking)
• 3PL warehouses (one per provider; multiple per provider if needed)
• Home / company warehouse (for FBM, retail, or wholesale fulfillment)
• In transit by sea (with expected arrival date and lot-level COGS already assigned)
• In transit by air (faster timeline, often used for replenishment)

Custom location types beyond these are supported. Each location has its own ledger: units on hand, units committed, units available, landed cost per unit by lot.

FIFO consumption across locations

When a unit sells, ConnectStock posts COGS using the right landed cost based on FIFO at the fulfillment location:

• Unit sold and fulfilled from FBA: COGS at the FBA lot cost (which includes inbound shipping to Amazon)
• Unit sold and fulfilled from 3PL: COGS at the 3PL lot cost (which includes inbound shipping to the 3PL but not to Amazon)
• Unit sold and fulfilled by FBM from your warehouse: COGS at the warehouse lot cost

This matters because the same SKU often has different landed costs at different locations. The FBA copy might be $5.40 (because of FBA inbound prep and shipping); the 3PL copy might be $5.05 (no Amazon-specific prep). Booking COGS as a blended average across locations overstates margin in one channel and understates it in another.

Inter-location transfers

When you move 500 units from your 3PL to FBA, ConnectStock handles the accounting:

1. Reduces the 3PL on-hand quantity by 500 units at their lot landed cost
2. Adds the freight cost from 3PL to FBA to the cost basis
3. Increases the FBA on-hand quantity by 500 units at the new combined cost
4. If units are damaged or lost in transit, the variance posts as a separate adjustment, not a margin distortion

The inventory asset on the balance sheet doesn't double-count the units in transit. The cost basis follows the units correctly.

In-transit accounting

Sea freight from your supplier can be 6 to 10 weeks from departure to FBA. During that time, the inventory is yours, owed by you, and worth real dollars. ConnectStock books in-transit inventory as a separate asset account on the balance sheet, with the landed cost calculated from the supplier invoice plus expected freight, duties, and tariffs.

When the goods land, the in-transit balance reduces and the destination location's inventory increases. Your balance sheet reflects what you actually own, at the location where you own it, at the cost basis you paid.

Sales tax and nexus impact

Multi-location inventory creates physical nexus in every state where you hold inventory. ConnectStock surfaces the nexus map: which states have your FBA inventory, which states have your 3PL inventory, which states have your home warehouse inventory.

The nexus map drives your sales tax registration list. ConnectBooks customers use it as the input to their sales tax compliance workflow (TaxJar, Avalara, or manual filing).

Reconciling to fulfillment center counts

Once a month, ConnectStock reconciles the system inventory to the physical counts:

• Pulls the FBA Inventory report from Amazon Seller Central
• Pulls the 3PL on-hand from the 3PL's API
• Compares to the ConnectStock ledger
• Flags variances above a threshold you configure for review

Small variances (1-2 units) are usually shrinkage and post as expense. Large variances usually mean a transfer wasn't recorded, an FBA Removal Order wasn't processed, or a count from the fulfillment center is wrong. The variance report makes the conversation with the 3PL or with Amazon a documented one.

Where ConnectStock fits in the pricing

ConnectStock is included with the Platinum tier of ConnectBooks at $349/month. It's also available as an add-on for Gold and Diamond tier customers who need multi-location inventory accounting before they're ready to upgrade.

For sellers with single-location operations (FBA-only, no 3PL, no home warehouse), the standard ConnectBooks inventory tracking is sufficient and is included in every plan.

Does ConnectStock replace my 3PL's inventory system?

No. Your 3PL still tracks physical inventory and runs fulfillment. ConnectStock is the accounting ledger across all your locations, including the 3PL. It pulls from the 3PL's API to stay in sync.

What if my 3PL doesn't have an API?

Most major US 3PLs (ShipBob, Shipmonk, Deliverr, Easyship) have APIs that ConnectStock integrates with. For smaller 3PLs, ConnectStock supports CSV uploads for monthly reconciliation.

How does ConnectStock handle FBA Removal Orders?

When you create an FBA removal, ConnectStock recognizes the units leaving FBA. When the units arrive at your destination (home warehouse, 3PL, or liquidator), the cost basis follows. Damaged or unsellable units post as inventory adjustments to a specific account.

Take Control of Your E-Commerce Business with ConnectBooks

Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.

Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo