03-05-2022 04:46 AM
I see where I can make a report, and it gives me shipping info that the buyer paid, but I don't care about that. I need to get a yearly report showing what I as the seller paid for shipping. Most of my items are free shipping, so the report I'm running just shows a bunch of 0's for the shipping paid. I'm surprised the transaction report doesn't include a column for the shipping paid by the seller, to ship the related item. Help?
03-05-2022 10:13 PM
It does include a column for shipping paid by seller. On the detailed transaction report, second column, I think, is headed TYPE. In that column you will see the description of Shipping Label. The amount you paid is to the far right.
There is a whole bunch of information on this report. You have to spend a little time with it to realize all it holds. When you drop it into a worksheet, you can delete whatever columns you don't want or need and make it how you need to see the information. And then total the columns.
03-06-2022 09:17 AM
Just to clarify.....that location (Column B "Type") applies to Managed Payments (ACTUAL Shipping cost paid through "Pending" or "Processed" Funds from your eBay MP account to eBay Shipping Labels).
Not to be confused with Column "X" that shows what the listing charged and the Buyer paid for shipping (not the actual cost incurred which many time can be different)...
Some people use off site shipping or still use Paypal (which I do)....those actual amounts are not included in your transaction report, but are readily available from wherever you print/buy your postage.
03-06-2022 10:16 AM
Good point but the columns are labeled.
And yes this report ONLY represents what went through Managed Payments.
Ebay does not account for or even know about where you may have purchased shipping from if other than through Ebay.
03-06-2022 08:39 PM
Also note the OP was trying to locate their shipping they paid.
03-07-2022 09:17 AM
I was tearing my hair out over this, too. Another commenter said to go under the Performance tab. Then you can generate a Sales Report (click on "See Your Sales Report")for the previous year (one of the dropdown choices). Scroll down toward the bottom and you will see a breakdown of expenses, including Shipping Labels.
I hope that's right, because that's the figure I gave to my tax preparer.
03-07-2022 12:01 PM
@nanashouseandgarden wrote:I was tearing my hair out over this, too. Another commenter said to go under the Performance tab. Then you can generate a Sales Report (click on "See Your Sales Report")for the previous year (one of the dropdown choices). Scroll down toward the bottom and you will see a breakdown of expenses, including Shipping Labels.
I hope that's right, because that's the figure I gave to my tax preparer.
You will likely be better off going to your Seller Hub, hover over the Payment Tab, from the drop down menu select REPORTS. Generate the detailed transaction report for whatever period of time you want. Download it. In the second column called Type, you can sort that report down to show you all the shipping you paid for through Ebay, among a bunch of other information you might find useful.
09-05-2022 06:30 AM
I would take a closer look. When I look at that number it includes the amount paid by the buyer.
09-05-2022 06:33 AM
In reviewing the report there is no column for seller paid shipping. I am not sure what you are looking at but I have a pretty good idea of what First Class shipping should cost and I do not see amounts close to that number anywhere in the row for the items I had free shipping on. I am running an all encompassing report with no filters. (Generates columns A-AK)
09-05-2022 06:37 AM
Has anyone been able to figure this out? All of these solutions are dead ends and miss the point. Shipping should not be claimed as an expense if the buyer paid for it, it is a pass through. The only shipping cost I care about, IS THE ONE I PAID FOR is not listed anywhere that I can see. To be clear all my shipping is purchased through eBay shipping. Let me know if you have a solution.
Thanks!
09-05-2022 06:48 AM
It seems that all of my shipping transactions are lumped together in paypal, the buyer and seller paid. How to delineate?
09-05-2022 10:31 AM
@coloradotnt wrote:I would take a closer look. When I look at that number it includes the amount paid by the buyer.
You go under the Payment Tab on your Seller Hub and select reports. You can generate a detailed report to download for any period of time you need.
09-05-2022 10:34 AM
@coloradotnt wrote:In reviewing the report there is no column for seller paid shipping. I am not sure what you are looking at but I have a pretty good idea of what First Class shipping should cost and I do not see amounts close to that number anywhere in the row for the items I had free shipping on. I am running an all encompassing report with no filters. (Generates columns A-AK)
Yes there is. I've used this report many times. For me there is more info on this report than I need, but I delete the columns I don't need when I drop the report into my worksheet program.
I've used this report for a couple years now to help in creating or checking my books to report numbers on my Federal tax reports. All the info needed [and more] is on this report. You may just need to spend a little time with it.
If you purchased the shipping through your Ebay MP account, the numbers will be on this report. If you purchased your shipping via PayPal or elsewhere it will not.
09-05-2022 10:38 AM
@coloradotnt wrote:Has anyone been able to figure this out? All of these solutions are dead ends and miss the point. Shipping should not be claimed as an expense if the buyer paid for it, it is a pass through. The only shipping cost I care about, IS THE ONE I PAID FOR is not listed anywhere that I can see. To be clear all my shipping is purchased through eBay shipping. Let me know if you have a solution.
Thanks!
That simply is NOT true. Shipping is a valid expense. What the buyer paid you for shipping is part of your income number.
There is no such thing in tax reporting as a Pass Through Expense.
Your view on this subject is likely why you aren't seeing the numbers represented on the report I've suggested you use.
The amount a buyer is charged for shipping and that the buyer pays a separate amount for is NOT always exactly what the seller pays for the actual shipping. Sometimes it is and sometimes it isn't. Some sellers put a handling fee on the amount they charge a buyer on shipping and some don't.
What you charge your buyer for shipping is part of your income. Whether or not you agree with that really doesn't matter, IRS does.
09-05-2022 10:39 AM
@coloradotnt wrote:It seems that all of my shipping transactions are lumped together in paypal, the buyer and seller paid. How to delineate?
There is no need to break it down. You claim the amount the buyer paid you for shipping as part of your income and you claim the cost of the shipping as part of your expenses. Period. It is not as complicated as you are trying to make it.