Solved

Setting up quickbooks for dropshipping

Posted on 2012-03-12
3
2,418 Views
Last Modified: 2012-03-21
Hi All,

I have been trying to get some info on how to enter as a dropshipper, I use Quickbooks Pro 2012  

Basicly, I have a lot of customers who I really do not need to keep track of in Quickbooks. They are customers I will likely not see again so it seems pointless to have thousands of customers in the QB database, esp when I can access them on Amazon or my web sites as I need to. I am trying to find a way to enter the transactions without the customers data. I only need the order ID, payment (cost of item and shipping), the fees from amazon and the date. I cannot find a way to enter that without the customers information, and still be able to connect them to the invoices that I receive from the vendors for each order, they both seem to require the inventory item. I also have no need to create invoices as I do not bill anyone. Do I need to add customers and all the inventory?


So far i was able to get this much:

It sounds like the best way for you is to create Non-inventory items with the box "this item is purchased for and sole to a specific customer" and enter the Income and Expense accounts.
To record the sales use Sales Receipts with the Name set to Amazon or the website for the sale. Use the order ID as the Sales Receipt number with the items and their sales amount, that goes to a bank account.
To record the purchases, use Write Check to that same bank with the items and their purchase amount. If you need to track the purchase with the order ID then put it in the bill's number.

You need to have an item for each thing you want to track for either the sale or purchase. The Amount on the item can be 0.00 but you need to enter an income account like "Sales" and an Expense account like "purchased item". Is you are not tracking all of what you are selling, you do not need to enter the stock number.
You can enter the cost amount on the bill/check and the invoice you are importing should have the amount on it.


I then asked:

When I record the sales use Sales Receipts, does that mean that Amazon and my Web Site will be the customer? So I would have a maximum of 5 customers (1 for Amazon and 4 (1 for each website) for websites?)

the response was

Yes, Amazon and my Web Site will be the customer.


Is this the correct way to proceed?

If so, I still have one last question, If I do not need to give it a price or number, can I use this "blind" inventory item for all the transactions, or do i need to create a blind item for each order?

I really appreciate any help you can give me, as I need to get my books done as soon as possible.

Thanks!
0
Comment
Question by:MikeMCSD
  • 2
3 Comments
 
LVL 11

Accepted Solution

by:
stlinae earned 500 total points
ID: 37715767
My first question to you is, what are you trying to track in QuickBooks?

If you're not wanting any customer information in QuickBooks or any item information, then you're fine doing it with the 5 customers and a blind inventory item.

Understand though, that you will not be able to track item cost this way either. So, I'd go back to my original question.
0
 
LVL 16

Author Comment

by:MikeMCSD
ID: 37718608
Thanks for your help. I  need to track sales and payments, fees, and other expenses, basicly all income and expenses. I have an Amazon store and 4 websites, and have been in business since last summer, and need to enter the financials from last year. I was thinking of creating a customer for each vendor I use, and a set of amazon customers, one for each vendor as well.  As an example, "Macys", "Gimbles", "Fortunoff"  and "Amazon Macys", "Amazon Gimbles", "Amazon Fortunoff" as customers.  I can then tell where each order came from, and use the reports to see sales from each vendor. This would represent merchandise sales. I would use the vendor order number as the sales number, and the sale order number (amazon or Web number) in the memo with the customers last name. That way i can match up all the orders to where they came from and who they belong too.


 But i need to know about using the inventory items. Can I really create one inventory item for income, and one inventory item for expenses? I had thought of creating an inventory item that represents each website, but i dont think that is neccessary.

I would greatly appreciate any help you can give me in understanding what would be the best way about going about this.
0
 
LVL 16

Author Closing Comment

by:MikeMCSD
ID: 37748803
thanks
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Great Plains (2013) - payablaes 1 46
QuickBooks Pro 2013 Update Keeps Failing with Config.msi Errors 8 137
Peachtree to Quickbooks migration 4 131
Using QODBC 6 93
A frequent question here in the MAS90 Zone is, How do you get data out of MAS90 for analysis, reporting or using the data on your web pages?   This is an introductory level tutorial to getting data out of MAS90 using ODBC. Data can be accessed by…
As an accountant it is essential that I am able to provide accurate and timely information to management and staff.  One of the challenges that I have faced is the need to report on a time period, whether it be a month, quarter, or year, and wanting…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now