How to Reconsile the 1099K with the Reports?

Selling on Amazon Reports
1

I know I finally managed to do this last year, but at this point, I don’t remember how the heck I did it.

So, The Amazon Total Product Sales figure it off from Mine in my financial software by $353.04
It is off from their own Transaction reports by $323.07

How the bleep do I find the discrepancy in my own books when Amazon doesn’t reconcile to itself?

3 Likes
2

So the 1099K is only off from the summary report by $29.97
I guess I will start looking there to figure out how to get my numbers to match then.

1 Like
3

I will note that overall for the year, every other number from the 1099K matches what I have. It is ONLY the Product Sales that is off

1 Like
4

Ok, it was all the refunds. I have now created refund items for each item now. I just need to edit my import templates to add refund before the item name when I import refunds.

And then I get to totally redo everything when I migrate off of QB since they are now charging 1000 a year for the desktop software and are doing their worst to force everyone online (I’m not going, I have to figure out how to do this all in excel and/or a database on my own computer somehow.)

3 Likes
5

Well you certainly made it easy on all of us by figuring it out. :wink:

Excel is how we do it. Ours functions from MySQL website data base in which we combine all of our income streams.

We gave up on QB years ago.

3 Likes
6

4 posts were split to a new topic: How to move from QuickBooks to Microsoft Excel/Access