Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
March 25, 2021
Question

Using Amazon fulfillment what is the correct way to do inventory and sales in quickbooks?

  • March 25, 2021
  • 2 replies
  • 31 views

Hello when sending product from our warehouse to amazon fulfilment centers so they can ship instead of us how should we do our inventory in quickbooks as it leaves our warehouse to there as we cant sell the inventory from our location once it is sent to fulfilment?  Should the product be written off so to speak when its sent?

The second question is how to put in sales from the Amazon fulfilled sales in quickbooks.  Please advise and thanks in advance for your help  We are Using Quickbooks Enterprise

2 replies

Angelyn_T
Moderator
March 25, 2021

Hi, @NauticalJim.

 

You can enable the advanced inventory feature so you can track inventory at different sites or locations. I'll guide you how.

 

  1. Open your QuickBooks Desktop file.
  2. Go to the Edit menu, then click on Preferences.
  3. On the left pane, choose Items & Inventory then go to the Company Preferences tab.
  4. Check the Inventory and Purchase Orders are Active box.
  5. Select the Advanced Inventory Settings button. 
  6. Mark the box beside Multiple Inventory Sites is enabled, then hit OK.

 

Once done, you're now ready to set up your inventory sites.

 

  1. From the Lists menu, select Inventory Site List.
  2. Select the Site button, then New.
  3. Enter the appropriate information.
  4. Repeat the same steps until all your sites are set up.

 

On the other hand, you can create separate items to track sales on each site. With this method, you use a naming method or structure to distinguish between items at different sites. For example, if you have 3 warehouses, you use 3 items to represent the same item located at each warehouse. 

  • Item A- Warehouse A or Location A
  • Item A- Warehouse B or Location B
  • Item A- Warehouse C or Location C

 

To learn about inventory tracking in QuickBooks Desktop, you can open these articles:

 

 

For more hints while working with QuickBooks, you can also open the topics from our help articles. Here's the link: Find help articles for QBDT.

 

Please keep in touch if you need more help with managing your inventory items. I'm determined to help. Have a great day!

Fiat Lux - ASIA
Level 14
March 25, 2021

@NauticalJim 

As another option, consider having an additional app to connect your QBD Enterprise with your FBA account.