Skip to main content

Track FBA vs FBM Warehouses

Send marketplace shipped sales and your own shipped sales to separate warehouses in QuickBooks.

If you keep stock in 2 places, like Amazon's warehouse and your own, you can send each kind of sale to its own warehouse in QuickBooks. Then QuickBooks shows how much stock is in each place.

You need: QuickBooks Enterprise with multiple inventory sites turned on, and a full inventory plan (not Lite).

Turn it on

  • Go to Stores & Files and click your store. On the Accounting tab, under Accounting Settings, click Settings.

  • Click the Inventory Settings tab.

  • Under Track Inventory, pick Yes.

  • Under Track Warehouses, pick Yes.

  • Pick a warehouse for each box and save:

    • FBA Warehouse: for orders the marketplace ships (WFS for Walmart, FBT for TikTok).

    • FBM Warehouse: for orders you ship yourself (Seller Fulfilled for Walmart and TikTok).

    • FBM Refund Warehouse (Seller Fulfilled Refund Warehouse for Walmart and TikTok): where returns from your own orders go back to.

If the warehouse has bins, you can pick a Bin too.

Other marketplaces show a Warehouse and a Refund Warehouse instead.

Example

You have 100 cameras. You send 50 to Amazon and keep 50. First, move the 50 to your Amazon warehouse in QuickBooks. Then Amazon ships 10 and you ship 2. QuickBooks now shows 40 at Amazon and 48 with you.

Split sales by customer too

On the QuickBooks tab, under Channel Name, Amazon stores can set a separate FBA Customer and FBM Customer. Then your sales reports show the 2 apart.

Frequently asked questions

I don't see Track Warehouses.

Track Inventory must be set to Yes. It's also only for QuickBooks stores on a full inventory plan, not Lite. If the store uses a ConnectStock inventory file, set warehouses in the file's settings instead. See How to setup your inventory file in ConnectBooks.

How do I add warehouses in QuickBooks?

Which marketplaces does this work for?

Any marketplace. The warehouse for orders the marketplace ships is only for Amazon (FBA), Walmart (WFS) and TikTok (FBT). Other stores pick a Warehouse and a Refund Warehouse.

Did this answer your question?