eBay sales report to dashboard

Every eBay fee, out of the total and into its own column.

Download the orders report from eBay Seller Hub and drop the CSV here. The dashboard adds the fixed and variable halves of the final value fee back together, keeps eBay Collected Tax out of your revenue because eBay remits it, and computes what each sale actually left you with after fees and postage. Item Number and Custom Label stay as text so leading zeros survive.

Prefer the full explorer? Open the app, or start from the generic dashboard builder.

Both fee parts combined

Fixed and variable final value fee summed into one real selling cost per order.

Marketplace tax excluded

eBay Collected Tax is removed from revenue because eBay remits it, not you.

Identifiers kept as text

Item Number and Custom Label keep leading zeros instead of becoming numbers.

Runs in your tab

Buyer usernames and ship-to cities are read locally and never transmitted.

The fee is in two columns and neither is the whole story

eBay splits its final value fee into two columns: a fixed per-order amount and a variable percentage of the sale. Neither one alone is your selling cost, and a seller reading only the variable column can underestimate fees by a meaningful margin on low-value items, where the fixed portion is proportionally enormous. On a four dollar sale the fixed part can be a tenth of the price. Adding the two together is the first thing this page does.

The tax columns are the second thing. There are two of them for a reason. Seller Collected Tax is tax you charged and are responsible for. eBay Collected Tax is marketplace facilitator tax, which eBay charges the buyer and remits itself, and it is not income under any reading. It sits inside Total Price, so Total Price is what the buyer paid rather than what the sale was worth to you. Those are different numbers and the gap widens the more US states you ship to.

How to export from eBay

Open Seller Hub Sign in at ebay.com and choose Seller Hub from the My eBay menu. The report tools are not in the classic My eBay view, so if you do not see an Orders tab across the top you are on the old interface and need to switch.
Go to Orders, then Reports Under the Orders tab pick Reports in the left menu. This is the seller order report, distinct from the Payments report and from the older Sales Record downloads, and it is the one carrying the fee columns.
Create a report for your date range Choose the date range and the report type, then request it. eBay caps how far back a single report can reach, so a full year usually means requesting two or three and merging them afterwards.
Wait for it to appear in the download list The report is queued rather than generated instantly, and it shows up in the same Reports screen with a status. Large ranges can take several minutes, and the download link expires after a while.
Drop the CSV on this page The header is found even though the report writes account metadata above it, and the fee columns are combined before the first chart is drawn.

The Payments report from Seller Hub covers the same sales from the money side, with payouts and refunds. It is the better file for reconciling to your bank; this one is better for understanding what sold and what it cost you to sell it.

Try with sample eBay data (the same columns, 94 rows, no upload needed).

What the dashboard shows

Every panel below is built from a column that is actually in the export, named the way eBay names it.

Sales and net over time. Sold Date on the axis with two lines: what the buyer paid and what you kept after both fee components and postage.
Effective fee rate. Fixed plus variable final value fee against Sold For, which almost always lands higher than the headline percentage sellers quote each other.
What actually sells. Item Title ranked by value, with Custom Label available as the cleaner grouping when you use it as an internal SKU.
Shipping recovery. Shipping And Handling collected against the sale, which tells you whether free postage listings are costing you the margin you think.
Buyer geography. Ship To Country on the map and Ship To City ranked, useful mostly for deciding whether international listings are worth the hassle.
Payment Status mix. Paid against pending and anything unusual, which for a busy seller is the earliest warning of a problem order.

Sample header row

Order Number,Sold Date,Item Number,Item Title,Custom Label,Quantity,Sold For,Shipping And Handling,Seller Collected Tax,eBay Collected Tax,Final Value Fee - Fixed,Final Value Fee - Variable,Total Price,Buyer Username,Ship To City,Ship To Country,Payment Status

eBay report details that change the numbers

The final value fee is in two pieces. Final Value Fee - Fixed is a flat amount per order and Final Value Fee - Variable is a percentage of the sale. Reading either alone understates your costs, badly so on cheap items.
Two different tax columns. Seller Collected Tax is yours to remit. eBay Collected Tax is marketplace facilitator tax that eBay handles. Only one of them is ever your liability and neither is revenue.
Total Price is not revenue. It is what the buyer paid, so it includes postage and both tax columns. Your side of the transaction is Sold For, less fees, plus whatever postage you actually recovered.
The file has a preamble and sometimes a footer. eBay writes account and report metadata above the header row, and some report types add a summary line at the bottom. A reader that assumes line one is the header gets a single mangled column.
Item Number and Custom Label are text. Item numbers are long digit strings that Excel turns into scientific notation, and custom labels often have leading zeros that get stripped. Both losses are silent and unrecoverable once saved.
Sold For excludes postage. Which is right, but it means a listing with free shipping and one with a low price plus postage look very different in this column despite earning the same. Compare on Total Price minus fees when you want a fair fight.

Add the two fee columns, drop the eBay-collected tax, and treat Sold For rather than Total Price as the sale. Those three moves turn a report that looks like it disagrees with your payouts into one that explains them.

Frequently asked questions

Why are there two final value fee columns?

eBay charges a percentage of the total sale plus a fixed amount per order, and the report shows the two separately so you can see the structure. Your real cost is the sum. The fixed part matters most on low-value items, where a flat charge of a few tens of cents on a three dollar sale is a far bigger bite than the percentage. Add them before you compute any fee rate.

Should I count eBay Collected Tax as income?

No. That column is marketplace facilitator tax, which eBay charges the buyer and remits to the relevant authority directly. It never reaches you and it is not your liability. Seller Collected Tax is the other case, where you charged tax yourself and owe it onward. Neither is revenue, but only one of them creates a filing obligation on your side.

Why does my eBay CSV open as one column?

The report begins with several lines of account and report metadata before the actual header row, so a reader that treats line one as the header ends up with a single field containing everything. This page scans down for the first line that looks like a real header and starts there. In a spreadsheet you would delete those top lines by hand before importing.

How do I calculate my net per sale?

Start with Sold For plus Shipping And Handling, then subtract both final value fee columns and your actual postage cost. Leave eBay Collected Tax out entirely. Your own postage is not in this file, so you have to supply it, but if you use Custom Label as an internal SKU you can join a cost list against it and get a real margin per item.

Can I combine several eBay reports?

Yes, and you often have to, because a single report cannot span an unlimited date range. Merge the files first, then deduplicate on Order Number, since requested ranges tend to overlap by a day at each boundary and the same sale can appear twice. Once merged, the trend chart is continuous and the fee rate calculation covers the whole period properly.

Is my eBay data sent anywhere?

No. The report is parsed in your browser tab and the charts are drawn from what is held in memory. eBay reports carry buyer usernames and the city and country each item was shipped to, which is personal data about your customers. There is no upload step in this page, no account, and nothing persists once you close the tab.