# How to Reconsile the 1099K with the Reports? **URL:** \ **Category:** Reports\ **Tags:** taxes\ **Created:** [July 20, 2025, 5:32pm UTC](https://sellersasksellers.com/t/how-to-reconsile-the-1099k-with-the-reports/6315 "2025-07-20T17:32:27Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![TCLynx](https://sellersasksellers.com/user_avatar/sellersasksellers.com/tclynx/32/522_2.png) [@TCLynx](https://sellersasksellers.com/u/TCLynx)\ **Post date:** [July 20, 2025, 5:32pm UTC](https://sellersasksellers.com/t/how-to-reconsile-the-1099k-with-the-reports/6315/1 "2025-07-20T17:32:27Z")
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? ---
**Author:** ![TCLynx](https://sellersasksellers.com/user_avatar/sellersasksellers.com/tclynx/32/522_2.png) [@TCLynx](https://sellersasksellers.com/u/TCLynx)\ **Post date:** [July 20, 2025, 6:32pm UTC](https://sellersasksellers.com/t/how-to-reconsile-the-1099k-with-the-reports/6315/2 "2025-07-20T18:32:30Z")
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. ---
**Author:** ![TCLynx](https://sellersasksellers.com/user_avatar/sellersasksellers.com/tclynx/32/522_2.png) [@TCLynx](https://sellersasksellers.com/u/TCLynx)\ **Post date:** [July 20, 2025, 6:40pm UTC](https://sellersasksellers.com/t/how-to-reconsile-the-1099k-with-the-reports/6315/3 "2025-07-20T18:40:25Z")
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 ---
**Author:** ![TCLynx](https://sellersasksellers.com/user_avatar/sellersasksellers.com/tclynx/32/522_2.png) [@TCLynx](https://sellersasksellers.com/u/TCLynx)\ **Post date:** [July 20, 2025, 7:18pm UTC](https://sellersasksellers.com/t/how-to-reconsile-the-1099k-with-the-reports/6315/4 "2025-07-20T19:18:22Z")
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.) ---
**Author:** ![Lost\_My\_Marbles](https://sellersasksellers.com/user_avatar/sellersasksellers.com/lost_my_marbles/32/2919_2.png) [@Lost\_My\_Marbles](https://sellersasksellers.com/u/Lost_My_Marbles)\ **Post date:** [July 20, 2025, 8:55pm UTC](https://sellersasksellers.com/t/how-to-reconsile-the-1099k-with-the-reports/6315/5 "2025-07-20T20:55:33Z")
Well you certainly made it easy on all of us by figuring it out. 😉 > [@TCLynx](#): > > I have to figure out how to do this all in excel 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. ---
**Author:** ![papy](https://sellersasksellers.com/user_avatar/sellersasksellers.com/papy/32/7639_2.png) [@papy](https://sellersasksellers.com/u/papy)\ **Post date:** [July 28, 2025, 7:46pm UTC](https://sellersasksellers.com/t/how-to-reconsile-the-1099k-with-the-reports/6315/6 "2025-07-28T19:46:43Z")
4 posts were split to a new topic: [How to move from QuickBooks to Microsoft Excel/Access](https://sellersasksellers.com/t/how-to-move-from-quickbooks-to-microsoft-excel-access/6354)