Does Anyone Have A Way To Join Ebay Shipping Costs With Orders?

It's the one piece of information in my eBay sales bookkeeping that is not clean at the moment. It's how much I paid for shipping. eBay has the information in the "shipping labels" section showing the amount paid for each order. But that information isn't included in the order report download.

It looks like I could to a copy/paste of the address labels page into Excel and then write a little Excel to join the information in the two files. But it's quite messy. I'm just wondering if anyone has already solved that?

I don't use eBay's exports to try and reconcile after the fact, as they are @&*$#&. Instead, I stay on top of things as I process orders, using the "All transactions" option on the payments tab of the website.

When I sit down every day to process pending orders, I copy the link for the transaction ID and username and paste them into Excel, along with today's date. In another column I place the gross amount received, the eBay final value/payment fees, and in another column any promo fees. I then have columns for eBay label fee, postage cost, insurance cost, and refunded amount (in the event of cancelled orders, full or partial refunds, etc.). Then I have calculated columns to give me net revenue (before cost of item and overhead) and eBay Fee % (just to keep an eye on my overall eBay-related expenses for different item categories).

Frozen top row with calculated totals gives me real-time at-a-glance summaries for different costs year to date.

When I print an eBay label, it tells me the cost, so I just pop that in the spreadsheet.

Keeping on top of this as I process orders rather than reconciliation after the fact means that everything is fresh in my memory, so any outliers will be recalled much more easily.

You have to stay on top of it though. You can't just decide to "skip a day/week/month".

The biggest pain is that while fees and USPS label costs are processed in real time (or close to it), so that they show up in the transaction feed in close proximity to the sale in question, refunds or eBay standard envelope feeds frequently lag several days, so reconciling them can be difficult.

It still boggles my mind that label fees to an external party (USPS) can show up in real time, but label fees to their own inhouse label system take days to show up. Idiocy.

Wow, I really don't want to go that way. With the order download I have a simple copy once a month or so into excel and I'm done. Going to daily updates is not appealing. I guess I'll try the address label copy paste to excel. Going to be a bit ugly but hopefully I can get it automated.

Yeah, depending on how many orders you do daily/monthly, staying on top of things could be ugly.

I also track those expenses "real time" using excel rather than pulling reports at the end of the week or month. Easier for me to keep on top of things that way. (I average abut 370 transactions a month).

I thought I'd report back that I did find a report that has everything I need for my business. I bet this could simplify things for others as well. To find it go to the Performance tab on the Overview page. Scroll down to "Selling Costs" and click on the arrow to the right to see more details. On that page there is a Download report button. The report has the complete breakdown. The price, the taxes, the listing fees, final value fees, shipping paid by buyer, cost of shipping labels etc. This seems like an ideal solution.