- This topic has 6 replies, 5 voices, and was last updated 3 years, 8 months ago by
.
-
Posts
-
-
Although I use GDBK for accounting, some of the issues I’ve encountered have a very good chance of being general ebay issues, not GDBK-specific, since GDBK can only pull the data that ebay provides via the APIs.
1) Good news: Very recently, I’ve seen the GSP issues in the “Shipping Income” category of GDBK fixed (and just got a notice from them about this). They now only show the $$ that I have actually received (shipping to KY) instead of the total that the buyer paid for shipping internationally. Caveat: the fix is only for data from this point forward. You have to manually fix the past incorrect line items (they go back to when you first got switched to Managed Payments). Luckily, I was doing this as I went, since I don’t have that many international sales.
2) Bad news: UPS and FedEx shipping label fees (expenses), which are billed via the ebay invoice, are not showing up in GDBK consistently. Someone on the forum mentioned that you can have the GDBK folks do a manual refresh to fix this. I did that, but many FedEx fees still didn’t show up and no UPS fees show at all. Luckily I don’t use those services very much, so I just went through all my invoices for 2020 and entered the missing ones manually.
3) Bad news: Return Shipping fees, billed via the ebay invoice, are not showing up in GDBK either. I’ve entered those manually. Again, luckily there were only a couple of these.
I would suggest checking out these issues regardless of what bookkeeping software you use. Fixing them lowers your taxable income.
One more thing: When I checked out those new ebay spreadsheet reports that people have been liking a lot, I found a number of line items to be mis-aligned, meaning numbers were not in the right columns (off by one). I don’t use these reports for much outside of the now pointless (but still required) sales tax returns for my state, but if you use them for federal tax accounting, you might want to see if that same problem appears for you, b/c that could really mess things up.
Has anybody else found any other issues that I’ve missed?
-
Hi @sonia I am new to GDBK and to tracking my ebay sales so I appreciate your post and the heads-up.
-
I had kept this post open for when I finally got around to my GDBK in order. I contacted GoDaddy through the chat function to get that manual reset done. The customer rep had no idea and thought that a reset would delete all my data. I had to email a screenshot showing that my FedEx fees on eBay didn’t show up on GDBK, and someone from their technical team did the reset. They also gave me instructions for importing those fees with a CSV file.
I did do an import with a CSV, but it took quite a long time because of all the data manipulation I had to do. I hope that it was less time than doing it manually.
I do see that the fees are importing properly now, and it was retroactive 90 days.
BUT, WHAT A PAIN!
Now I gotta do my taxes.
-
-
@Sonia – Thanks for posting your issues. I’m finally getting around to finalizing my taxes (took them to the accountant yesterday) and was driving myself mad trying to reconcile the differences. After reading this, I’ll have to recheck my numbers. I am curious, what report did you use to identify the missing shipment fees? Do I need to pull each month’s invoice, or is there some other method that you used?
Previous years I’ve been very happy with GoDaddy, but I’ve spent so many hours trying to reconcile where the differences between what eBay says I sold, what Paypal says I earned and what GoDaddy has in there system. I will definitely need to rethink using them going forward.
-
-
GoDaddy doesn’t handle eBay’s invoices well. I’m not sure how eBay offers up invoiced data via their API – I bet something is wrong there. It’s weird that GoDaddy is aware of the issue but you still have to request them to pull the data again and check.
I also had to reconcile my books for 2020 and at the end of the day there were still issues between both eBay + PayPal 1099k forms and numbers given by GoDaddy. Finding missing FedEx orders wasn’t easy.
If you’re in Managed Payments, the reports it dumps out are amazing. You can generate them for a given date range. 90% of the data you need to do your books is there. The rest can be found in your invoices, which you can optionally download as a CSV file for parsing in your spreadsheet.
For 2021 I’ve written a program that takes these files and generates itemized reports for every order in a given period, in addition to overall income/expenses across your account. The item reports are very helpful for figuring out the exact amount of money you’re making per order. Just add COGS and you get net profit. I’m going to use it for the next few weeks and iron out bugs, but once it’s good to go I’ll link it here so other people can give it a shot.
-
- You must be logged in to reply to this topic.