DocuSend QuickBooks App Advertise here    

QuickBooks Forums      

Go Back   QuickBooks Forums > QuickBooks Software Support > QuickBooks Enterprise Edition Forum

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 01-10-2017, 03:06 PM
mattt8 mattt8 is offline
Registered User
 
Join Date: Jan 2017
Posts: 1
How best to enter bulk Amazon orders

Hi!

We're fairly large Amazon sellers and we send the vast majority of our inventory to Amazon for them to fulfill.

This creates an issue in that products is removed from our warehouse and transferred to Amazon's warehouse, meaning that it is not available for us to sell from here. However, the items are not actually sold to anyone until an Amazon order comes through. And of course, because of the way Amazon payments work, we don't actually get the money right away, we get it in 2-week disbursements.

Essentially, that's three issues we need to solve; correct inventory, correct sales control and correct allotment of the actual revenue when it is disbursed. What we have been doing is making an invoice for every Amazon sale with a dummy catch-all name, but still, that is so many orders it takes about 24 man-hours per month to do it.

We'd like to stop doing that, create some kind of invoice for $0.00 at the time of shipment to Amazon to account for inventory, and then just enter one single sales order twice a month with the total disbursement. Our concern is that the $0 invoice will incorrectly influence our GL by either reducing the apparent average value of orders or somehow otherwise negatively impact the P&L.

We're open to suggestions from anyone who has any ideas on this, and thanks in advance for any help!
Reply With Quote
  #2  
Old 01-10-2017, 05:32 PM
uniz uniz is offline
Registered User
 
Join Date: Oct 2013
Posts: 143
Quote:
Originally Posted by mattt8 View Post
Hi!

We're fairly large Amazon sellers and we send the vast majority of our inventory to Amazon for them to fulfill.

This creates an issue in that products is removed from our warehouse and transferred to Amazon's warehouse, meaning that it is not available for us to sell from here. However, the items are not actually sold to anyone until an Amazon order comes through. And of course, because of the way Amazon payments work, we don't actually get the money right away, we get it in 2-week disbursements.

Essentially, that's three issues we need to solve; correct inventory, correct sales control and correct allotment of the actual revenue when it is disbursed. What we have been doing is making an invoice for every Amazon sale with a dummy catch-all name, but still, that is so many orders it takes about 24 man-hours per month to do it.

We'd like to stop doing that, create some kind of invoice for $0.00 at the time of shipment to Amazon to account for inventory, and then just enter one single sales order twice a month with the total disbursement. Our concern is that the $0 invoice will incorrectly influence our GL by either reducing the apparent average value of orders or somehow otherwise negatively impact the P&L.

We're open to suggestions from anyone who has any ideas on this, and thanks in advance for any help!
You can turn on the "Location" feature in QBE. It will allow you create different locations to keep track of your inventory in each location.
When you send out a bulk of products to AMZ, book an inventory transfer in QBE to transfer from "HQ Location" to "AMZ Warehouse".
When your items were sold on Amazon website, make invoices for the sales, and remember to select "AMZ Warehouse" for that invoice.

Google "Quickbooks multiple locations" for some tutorials. You will find it quite easy to implement.
Reply With Quote
Reply

Bookmarks
Bookmark and Share
Tags
amazon, amazon.com, bulk invoice, inventory asset, invoice

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is On

Forum Jump


All times are GMT -5. The time now is 05:49 AM.


 

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
All contents copyright (c) by AccountingUsers Inc.