@slippinjimmy wrote:Transaction Report, Filter by type = shipping and time period
Thanks for trying but I don't see it as it does not come up- only a 'shipping label' that I had to pay for (For an NAD)- see picture;
From the Seller Hub go to Payments and then Reports, Financial, overview, Time period, select Custom and adjust the date to the Time period you want.
From the report go to Expenses and the amount spent on eBay purchased shipping is displayed as Shipping labels.
A Transaction Report will show shipping from eBay. It is a really big report and will show a lot of data for all most aspects of all sales. You won't see the ship to address.
This is all the data you will get.
| Transaction creation date |
| Type |
| Order number |
| Buyer username |
| Buyer name |
| Ship to city |
| Ship to province/region/state |
| Ship to zip |
| Ship to country |
| Net amount |
| Payout currency |
| Payout date |
| Payout ID |
| Payout method |
| Payout status |
| Reason for hold |
| Item ID |
| Transaction ID |
| Item title |
| Custom label |
| Quantity |
| Item subtotal |
| Shipping and handling |
| Final Value Fee - fixed |
| Final Value Fee - variable |
| Regulatory operating fee |
| Very high "item not as described" fee |
| Below standard performance fee |
| International fee |
| Charity donation |
| Gross transaction amount |
| Transaction currency |
| Exchange rate |
| Reference ID |
| Description |
If you want all this information you must Download in in a PDF or CSV file. The option is to the right of the Reports in my previous example.
If you just want to see a list you can just selecting Shipping label and adjust the Custom date.
I find the easiest way is to do it is through my monthly sales report on the HUB. You can generate it via last 31 days, this month, last month, annual, custom, etc. If you scroll down the report you will see "Selling Costs", after the graphs. Shipping labels is the second line item.
If you are using Excel there are two functions to remove Objects (EBAY IMAGE) in a matter of seconds.
One function you can hide the Images and Unhide the images.
The other function will delete all of the Images.
From the Editing Box select the Find and Select box.
Go to Special and select Objects.
Click ok and all the Objects will be selected as in this image.
Now just hit the delete button and all the images will be gone as seen below.
All this is done in a matter of seconds.
Once you get all the Objects cleared, adjust you column width and use the Sum Function to get the total. The Formula for the Sum Function should look similiar to this =SUM(A1:A29)
Before you do this you may need to remove the − Charcter that PayPal has in their data. Their symbol may prevent the numbers from adding up. The − looks like the - but it is not the same and it prevents the numbers from adding in Excel.
Use the Find and Replace function. I did not enter a Replace with so this will just delete the PayPal −. You could if you wish enter a - and it will also allow the numbers to add up but the total will display as -$0.00
After PayPal's − Charcter is removed the amounts are displayed and moved to the right. Formulas can now be used.
If you just want to see the numbers you can sort the data and get all the numbers together and then cut and paste to a new column.
It seems somewhat complex, and it is. But once you memorize the steps it takes seconds to do the entire process. You said you have like 150 transactions you want to total. Does PayPay give you all this information on one long scrollable page. If they do then this should not take much time. If you have to do this for each page of data then it would take a little longer.
