Using quickbooks

[jesso.jenni]

Hi I am a longtime seller of a small ebay store. Used godaddy for bookkeeping until recently I had to switch to quickbooks online.  My problem is that quickbooks is not drawing all of my expenses from ebay such as shipping costs, returns and I'm not sure what else yes as I just transferred recently. I NEED all this info (obviously) for taxes. Any quickbooks users out there that can help? I have been on the phone with intuit and with the ebay connector app (onesaas) who both have been no help. Seriously in need of help, Jenny

[caldreamer]

I loved GoDaddy and switched to Quick Books but found it horrible and confusing also.   I cancelled Quick Books and now just rely on EBAY reports.   EBAY transaction report shows (sales, shipping, returns, EBAY fees).   EBAY reports are not "easy too read" because there are too many columns showing "gibberish" but the information is all there (if you take the time to ferret it out).

[jesso.jenni]

Thank you as that is helpful and may end up being my ultimate goal. I believe I will still need to keep quickbooks though as it helps to track expenses from my bank account that ebay does not such as...cost of goods sold (inventory purchases), office supply purchases outside of ebay and more. Godaddy was I one stop shop and I am truly going to miss them!

[houseful4him]

I am in the same boat. I'm trying to get quickbooks to work for my business, but it is horribly confusing and it has all sorts of errrors. I'm thinking of just going to manual bookkeeping. 

[isabella*smom]

Hello, same thing is happening to me. I just need my gross sales and FL sales to do my sales tax. Does anybody know how to get this info from ebay? I tried downloading my report from ebay but it does not show a column with the states 😞

[cordell1]

Ebay collects and pays all the sales tax for all sellers.  Do not double pay sales tax.

[nuclearomen]

ditch that - get Excel, and enter the fees, shipping etc... into Excel your self, takes approx 1 min per sale. 

[proudmarineandwife]

Have you heard of paperandsparks.com ?

Check out You Tube. A CPA by the name of Janet LeBlanc created an Ebay 

seller sheet where you copy and paste Ebay's CVS onto a Excel spreadsheet.

This includes Revenue (sales, refunds, shipping income) and Expenses

(shipping labels and ebay fees)  Obviously it's not free, but it's been of

great help to me since GoDaddy retired.  

[nuclearomen]

This is all you need to record in Excel, ebay already provides all the info for your orders via the Orders and all transactions in managed payments. (PL fees listed separately there)I have additional columns I created for international fees on order out side of USA and for refunds etc... but this is basic bulk you need to have for records. 

[ocoeeexchange]

So, I believe i have found a way to use eBay's monthly statement to input info manually via a journal entry

My Journal Entry:

Channel pending balance = Opening funds

Product sales = Orders minus fees (sometimes plus transfers if its +)

Refunds = refunded orders, fees, credits,

Shipping Labels = Shipping purchases through eBay

Other Fees or any other - balances

Channel pending balance = closing funds

Bank transfers = payouts

[rfmtm]

The ebay report can be sorted by state.  However, since ebay collects all the tax there is no need to do so.  For those whose state still requires reporting even though no tax is due, they generally want gross sales reported, not just sales within the state (Florida is like this), then you merely include that same amount in tax exempt column so no tax is due on it (since ebay already remitted it for you).

[rfmtm]

I have not tried the new QB/eBay interface, and it sounds like neither did a good job of making it work.

I use to import ebay (actually back then PayPal payment history) in to Quicken (QB simpler version), but it was pretty much the same as just using a spreadsheet.  The trick was to import the data into is own separate Quicken cash account to sort out, which was often a mess as PayPal was never consistent in its categories.

Today I just import the ebay Managed Payments report into a spread sheet, sort and subtotal as needed.  This should also work just as well imported into separate QB cash account, to do the same.  Obviously both QB and ebay need to get together and have a uniform integration so you are not needing to do this manually.  Surprised there is no third party QB add on for doing this with ebay.

[terry532001]

Yep I ran into the same crap. Quickbooks wanted my personal banking account information so I attached it. What a mess. I ended up not even using Quickbooks and instead downloaded open office (free) and made my own spread sheet then manually enter the ebay data everyday. Takes about 1 minute per transaction. GoDaddy which I had worked flawlessly but obviously these "experts" from Quick books can't figure out how to do it without  using my personal checking account which is where my Ebay payments go and that just opens a can of worms. I am not an accountant and need something SIMPLE like GoDaddy did. What a shame they left but hey, they did the same thing with my email account when they sold it to Microsoft and they screwed that all up as well. At least EBay finally put all the information from a sale into one place so I can grab that info from one page instead of searching three pages on Ebay before for the information. 

[terry532001]

I went to open office and downloaded it. It's FREE and works great for me as I manually enter the information everyday. Takes about a minute per transaction. make your own spreadsheet, it's not too hard, and then enter the information you want.

[terry532001]

Open Office works the same as Excel and is FREE. Just download it an make your own spread sheet. Used to be you could get Microsoft Office and pay a one time fee but no more. Now they want their cut every year so I ditched them. Besides that Microsoft snoops way too much