Does anyone know how to edit an excel sheet?

[alwaysthelowestprice]

I've been using an excel sheet I downloaded from the web. It's to help keep track of sales. I used this all of 2022. I just realized the box that automatically calculates the eBay fees is incorrect. So instead of me manually adjusting the actual fee charged for every sale, I was hoping someone would know how to edit the box so that it calculates the correct percentage. I'm not even sure if doing this will change every sale or not after the right adjustment is made, but I figured it's worth a shot. 

 

[wastingtime101]

See in the bar at the top where it says:

=SUM(D3*0.1235)

What that's doing is taking the gross sale amount you entered in column D and multiplying it by a 12.35% final value fee. If you need to make adjustments to the fee percent just change the 0.1235 number in that text edit bar.

[caldreamer]

There is an easier way...EBAY has all information available that you need to do your taxes.   Use the weblink below.    Be sure to save weblink (for future use) because it seems to have "disappeared" from EBAY available reports.

https://www.ebay.com/sh/fin/reportslanding

[dnasilver]

It does not show COG's which the OP's does. eBay does not have all the info needed for doing taxes. There is no way for them to know everyone's cost for the item being sold. 

[wastingtime101]

---

@caldreamer wrote:

There is an easier way...EBAY has all information available that you need to do your taxes.   Use the weblink below.    Be sure to save weblink (for future use) because it seems to have "disappeared" from EBAY available reports.

https://www.ebay.com/sh/fin/reportslanding

---

Go to the Payments tab in seller hub. On the left side menu, click on Reports. It will take you to that same page @caldreamer. 🙂

I agree that downloading the eBay reports is one good way to manage it and I've helped a few sellers get set up with that, but a seller should be on top of it - downloading the report every 2-4 weeks to enter in their item costs, shipping, etc.

The eBay reports won't have that info as @dnasilver pointed out. Plus, if one is not proficient with Excel, they may have difficulties adding columns to keep track of COGs, enter formulas using available data, etc.

Whether using Excel, accounting software, or a plain old paper and pencil a seller needs to be comfortable and knowledgable with the method they use to avoid accounting errors.

[pburn]

@alwaysthelowestprice 

If you want to apply that change to the entire column instead of just that one cell you have highlighted, there are several ways to do that  One is by changing the formula in the first cell in the column and dragging the fill handle down the column.

You can check out the following link or search for  the explanation on sites you may prefer.

Fill a formula down into adjacent cells 

[alwaysthelowestprice]

Is 12.35% the correct value? I don't think it is since when I was checking through orders, the fees eBay is deducting were slightly higher. I know it defers whether you're a top rated seller etc. A better question is, how can I figure out the exact percentage being deducted?

[wastingtime101]

Most, but not all, categories currently have a 12.9% fee. You can view current fees here: https://www.ebay.com/help/selling/fees-credits-invoices/selling-fees?id=4822

But if you sold items before the last fee hike, then that chart won't match.

You can download the report in seller hub referenced above @alwaysthelowestprice or you can view all of your transactions through eBay without downloading a report - up to you what you find to be the easiest workable solution.

This is a direct link to your financial transactions on eBay: https://www.ebay.com/sh/fin/transactions

You can set a custom time period in the filters at the top.

I suggest messing around with a few options to see what you'll be most comfortable with, then use that method for your 2023 accounting. It's early in the year so if you need to make any changes to your current method, this is a good time.

Edit to add that there are other fees such as international fees (even if your ship exclusively to domestic addresses, you could still be assessed an international fee if the buyer is registered internationally), plus listing fees, credits, and more.

My suggestion is to download the eBay report and analyze it. Then learn some basic Excel skills like adding columns, hiding columns, creating formulas etc. You'll be able to piggy back off the eBay report to add in your COGs, shipping and other expenses. Work it on your preferred timeline for 2023, whether it's daily, weekly, monthly, etc.

[slippinjimmy]

---

@alwaysthelowestprice wrote:

Is 12.35% the correct value? I don't think it is since when I was checking through orders, the fees eBay is deducting were slightly higher. I know it defers whether you're a top rated seller etc. A better question is, how can I figure out the exact percentage being deducted?

---

12.35% is not correct, fee rates have many variables depending on many factors, if you want accuracy it's not going to be simple to try to calculate them yourself.

Store Fees here:

https://www.ebay.com/help/fees-credits-invoices/store-selling-fees/store-selling-fees?id=4809

[alwaysthelowestprice]

So it seems the best way to figure out the fees is to manually enter it by going in transaction details for each order. I will do it this way in the future and I guess I have a lot of work ahead of me to manually change each order on the Excel sheet for 2022

[wastingtime101]

---

@alwaysthelowestprice wrote:

So it seems the best way to figure out the fees is to manually enter it by going in transaction details for each order. I will do it this way in the future and I guess I have a lot of work ahead of me to manually change each order on the Excel sheet for 2022

---

Not necessarily @alwaysthelowestprice. As mentioned above, the fees will be there in the eBay report so you can copy the entire column (or columns if you had international fees, etc) into the spreadsheet you've been using - just make sure the items line up in the right order.

Alternately, you can insert columns into the eBay spreadsheet to account for your COGs and shipping, which you may find easier.

[chapeau-noir]

---

@wastingtime101 wrote:

---

@alwaysthelowestprice wrote:

So it seems the best way to figure out the fees is to manually enter it by going in transaction details for each order. I will do it this way in the future and I guess I have a lot of work ahead of me to manually change each order on the Excel sheet for 2022

---

Not necessarily @alwaysthelowestprice. As mentioned above, the fees will be there in the eBay report so you can copy the entire column (or columns if you had international fees, etc) into the spreadsheet you've been using - just make sure the items line up in the right order.

Alternately, you can insert columns into the eBay spreadsheet to account for your COGs and shipping, which you may find easier.

---

I do something similar - I download the transaction report and combine it with expenses (inventory, shipping which I don't do through ebay, etc.) as well as totals on other sites which I track on another spreadsheet that I created. I should do this once a month but I'm lazy and don't sell a lot so it's once every-time-I-get-around-to-it.  Spreadsheets are the easiest way for me to do this.

[wastingtime101]

I agree, Chapeau, which is why I'm encouraging OP to try and make that work. I know Excel can seem daunting when one is unfamiliar with it, but there are so many great tutorials out there (go to youtube and type in Excel Basics) to get the OP started and the more one uses Excel the easier it becomes.

[alwaysthelowestprice]

Thanks for all the helpful replies everyone. I'll get it all figured out. I'm just trying to get things in order for taxes since I have no idea what I'm in for yet. I'm hoping I can do it on my own but hopefully I'm not getting in over my head.