eBay Sales Report Explained: How to Find and Analyze Your Data

Whether you’re a savvy or a budding seller entering the bustling eBay marketplace, you must pay attention to your eBay sales data to help you grow your business.

But do you know where to find your built-in reports tab on your eBay Seller Hub? 

Fret not.

Today, you’ll learn how to find your eBay seller reports and get the best out of those figures. You’ll discover two alternative ways to monitor your eBay monthly sales report.

Meanwhile, our bookkeeping tool— Link My Books—connects eBay to your accounting software to break down your payouts into accurate sales, fees, and tax data that perfectly reconcile perfectly in Xero or QuickBooks.

Explore our free 14-day trial to easily auto-generate eBay reports in Link My Books.

‍

Why Do You Need an eBay Sales Report?

eBay reports are a great starting point for getting an overview of your earnings, assessing your business's financial health, and identifying discrepancies in daily operations.

With sales data, you’re better positioned to compete with eBay's over 19 million sellers.

4 Benefits of eBay Sales Statistics for Sellers

eBay seller stats offer a crystal clear view into every aspect of your business, from sales to inventory levels and customer behavior.

The eBay sales data can help you:

1. Make Informed Decisions

Once you’ve your eBay yearly sales report, you can base your marketing strategies on the shop’s performance rather than guesswork. You can use the insights to make data-driven and informed decisions.

For example, sales data can help you anticipate seasonal demand, identify slow-moving products, and gain insights into inventory stock.

2. Track Daily Transactions

The eBay transaction reports provide detailed, real-time data, including refunds, claims, disputes, total sales, and eBay fees. Using this data, you can maintain a thorough and accurate record of transactions.

3. Manage Costs and Forecast Profits

When you track expenses like marketing, shipping, production, and advertising, you can prepare your cash flow upfront, adjust your pricing strategy, and forecast the profits you expect from each eBay sale.

4. Tailor Your Marketing Accordingly

You can view customers' details each month, such as their names, addresses, and items purchased. These reports reveal your buyers’ preferences and demographics, allowing you to create a personalized experience that increases engagement and customer satisfaction.

Essential eBay Sales Report Figures for Accurate Bookkeeping

Take a step back and consider what figures from the eBay report you need for accurate bookkeeping.

Here is a quick breakdown of what you’ll need and why they matter in bookkeeping:

With Link My Books, you can gain confidence in your bookkeeping without so much hassle. 

Our tool accurately accounts for your sales, fees, and taxes and sends the summaries to Xero or QuickBooks, where they reconcile perfectly.

Want to take Link My Books for a spin? Book a demo now!

‍

‍

Firstly, taking a step back, let's have a think about what figures from your eBay reports you actually need for accurate bookkeeping of your eBay sales.

You will need the following:

• Sales (by destination country)
• Refunds (by destination country)
• eBay Fees

The sales and refunds figures need to be split by destination country because they may need to be treated differently for VAT. For example, a sale going to a UK customer would typically incur 20% VAT, but a sales going to a customer outside the UK is classed as an export and, as such, is typically zero rated for UK VAT.

Depending on where your business is established, you may also need to consider sales where eBay is responsible for collecting and remitting the VAT directly to HMRC too. We can discuss this more later.

How to Get eBay Sales Report Figures

You can keep track of eBay sales and your financial data in your eBay Seller Hub under the 'Payments' tab. From there, you can choose to view and download transaction reports, financial statements, payout report, and invoices. These reports give sellers both an overview and a detailed breakdown of their financial activity including sales, refunds, and eBay fees.

Managed Payments Payout Report for eBay Sales Data

‍

Your Payout report provides a summary of your payouts for a specific date range. Here’s how to download your Payout report:

1. Go to the Payments tab in Seller Hub.
2. From the menu on the left, select Reports.
3. Select the Reports tab.
4. Select Payout report from the dropdown menu.
5. Select the Start and End date.
6. Select Create report next to the report you would like to download.

In addition to an overview of your transactions, you can get detailed breakdowns of eBay transactions in the Payouts section by simply clicking on one. When you do so, you'll be able to download the following information in CSV format:

• Transaction creation date
• Type
• Post to country
• Item subtotal
• Postage and packaging
• eBay collected tax
• Final value fee – fixed
• Final value fee – variable
• Very high 'item not as described' fee
• Below standard performance fee
• International fee

You can also choose which data to include in your reports, based on, for example, transaction type or status. You may also view transactions within a specific date range.

How to Use eBay Sales Report Figures for VAT Calculation

‍

‍

Now that you have the Payout report figures, you can enter them into your accounting software or spreadsheet.

Since eBay collect VAT on some sales but not others, you will need to sum up your sales into the following categories:

• Sales shipped to the UK (Seller VAT Responsible) - Typically 20% VAT
• Sales shipped to the UK (eBay VAT Responsible) - Typically zero rated
• Sales shipped outside the UK - Typically zero rated

To do so, follow this logic.

Sales shipped to the UK (Seller VAT Responsible) are those where:

• Post to country is GB
• eBay collected tax is blank

Sales shipped to the UK (eBay VAT Responsible) are those where:

• Post to country is GB
• eBay collected tax contains a value

Sales shipped outside the UK are those where:

• Post to country is not GB

eBay Sales

‍

‍

To find your sales figure, filter the report to show only "Order" types in the Type column, then total up the following columns:

• Item subtotal
• Postage and packaging

eBay Refunds

To find your refunds figure, filter the report to show only "Refund" types in the Type column, then total up the following columns:

• Item subtotal
• Postage and packaging

eBay Fees

To find your fees figure, firstly filter total up the following columns:

• Final value fee – fixed
• Final value fee – variable
• Very high 'item not as described' fee
• Below standard performance fee
• International fee

VAT on most eBay fees is 20%, but you should double check your monthly eBay fees invoice to ensure you do not have any that are zero rated.

Common Issues With Manual eBay Sales Reporting

Reporting eBay sales manually comes with a unique set of challenges.

Check the 5 common obstacles below:

• Complex Transaction Tracking: With numerous daily eBay transactions, manually tracking customer sales, shipping costs, eBay seller fees, and expenses can be challenging.
• Missing Regular Reviews: Regularly reviewing your performance metrics is the key to spotting growth opportunities. Manual sales reporting might not allow you to achieve this.
• Time-consuming: Entering and reviewing your data manually can be hectic. Activities like recording your sales and expenses and tracking your daily transactions can also take up your time.

• Difficult Reconciling Sales Transactions: While you can download eBay reports and view your sales activities, comparing each transaction manually and matching them up with your bank records can be challenging.‍
• Risk of Errors: Manually managing your eBay bookkeeping processes can be prone to errors, resulting in inaccurate financial data.

Alternatives to Manual eBay Sales Report Management

Although you can manually organize and manage your sales reports, it’s not always productive and can be a headache.

Check out these two alternative methods:

‍

As you may be seeing by now, doing your eBay bookkeeping manually is going to take time and patience, and even so, it will be pretty susceptible to human error.

Most eBay sellers decide that this task is something they don't want to spend much time on each month. So, what are your options if you too decide this?

1. Get an ecommerce accountant/bookkeeper to do it
2. Use ecommerce bookkeeping software to automate it

Using an eCommerce Accountant or Bookkeeper

‍

‍

If you use an accountant or bookkeeper, then this will definitely save you some time. The downside is that they will charge you per hour for doing so. The likelihood is that it will take them just as much time as it would have taken you and this could easily end up costing you a few hundred pounds per month.

Using Bookkeeping Software

Using ecommerce bookkeeping software would be most eBay sellers' preferred choice. This is quick, accurate and cost-effective. One such tool is Link My Books.

How Link My Books Makes eBay Accounting Simple

‍

‍

Link My Books hooks up directly to your eBay account and accounting software such as Xero or QuickBooks and posts summaries of each of your eBay payouts following the same format as we discussed above.

We are trusted by thousands of sellers and is rated 4.9/5 on average across hundreds of reviews.

You can try Link My Books for free here.

Link My Books' Automates Your eBay Bookkeeping

‍

‍

With Link My Books, all your sales data from your eBay business is automatically added to your bookkeeping software. It's compatible with two of the most popular accounting software; Xero and QuickBooks.

All your transactions are reflected in your sales data. Link My Books consolidates all of this data from all your sales channels. This means that if you have multiple eBay sites, or sell through channels like Amazon and Shopify as well, you don't need to worry about manually incorporating the transactions for each channel because it's all done for you.‍

Link My Books Accurately Calculates Your eBay Taxes

‍

‍

The importance of accurate tax calculations can't be overstated. HMRC can charge a penalty between 0% and 30% of the extra tax you owe if it considers you to have made a mistake because of 'lack of reasonable care'. This increases to between 20% and 70% if the HMRC thinks the mistake was deliberate. Therefore, due diligence is most definitely advised when it comes to tax calculations.

When you opt for a software like Link My Books for your eBay business, you don't need to worry about underpaying taxes because it automatically works them out for you. It calculates taxes on every single sale you make, taking into consideration any refunds, eBay fees for selling, and inventory costs. Link My Books then sends all this data across to your accounting software.

Link My Books Generates Clean Summary Reports

‍

‍

Link My Books automatically generates summary reports of all your income and outgoings. Every time you get a payment from eBay, you'll receive a summary invoice which contains detailed information like:

• Sales
• Refunds
• Cost of ads
• Sales tax
• Fees by type
• Net profit

You can move your reports from eBay to Xero or QuickBooks with a click of a button so each transaction is recorded and accounted for.

Additionally, Link My Books facilitates one-click bank reconciliation so that your records match your banking activities.

Frequently Asked Questions (FAQs)

Have some questions about managing your eBay sales reports? Read on.

How Often Should I Review My Reports for Optimal Bookkeeping?

‍

‍

Even if you opt for automating your eBay accounts, you should still review them regularly to ensure your businesses remain profitable. Reviewing your reports can also highlight areas of your business that can be improved. 

You might identify new investment opportunities, for example, or decide to cut costs in a specific area. You should review details like taxes, ads, payments, number of buyers, and revenue.

Another reason you should review your reports regularly is to optimise the customer experience. Once a month eBay provides its sellers with 'Service metrics'. This is a measure of customer satisfaction and includes data like return requests and refund requests. It's essentially a report on how smoothly your eBay sales transactions have gone throughout the month compared to other sellers. You might receive penalties, like withholding of funds, if your rating is very high.

‍

‍

We recommend reviewing your sales reports at least once per month, after you've received your service metrics from eBay. This is your chance to take stock of your ins and outs, and optimise your business budget. If you've had a lot of returns or issued a lot of refunds, this is something you'll obviously need to address to minimise the negative impact on your business as you move forward.

How Do I Find Out How Much I Sold on eBay Per Year?

‍

‍

To view your annual sales, you need to navigate to your Seller Hub. From there, you hover over 'Payments' and click on 'Reports' in the menu. You'll be presented with three tabs; 'Reports', 'Statements', and 'Invoices'. To view your annual sales, you need to stay on the 'Reports' tab.

There are three dropdown menus under the 'Reports' tab. These allow you to change the information included in your reports. To find out how many products you've sold in a year, ensure these options are set to:

• 'Transaction report'
• 'All statuses'
• 'Transaction types (all)'

You can then go ahead and input your chosen start date and end date before clicking on 'Create report'. It will take a couple of minutes to generate. When it's done, you'll have the option to download it. Your report will download in CSV format as an eBay spreadsheet and will open with Microsoft Excel as default.

‍

‍

However, you can download reports through OpenOffice if you have that instead of Microsoft Excel. Additionally, after the CSV file is downloaded, you can upload it to Google Sheets if you like.

Once you've downloaded your eBay sales transactions report for the year, you'll be presented with a wealth of data on every sales transaction throughout that time-frame. This includes different types of fees for your eBay transactions, Buyer IDs, number of items sold, selling costs, and taxes that eBay collected.

Alternatively, if you're using Link My Books with accounting software, you can access and review reports through those.

Are There Any Specific Features That Can Help Me Track and Improve My Selling Performance?

‍

‍

Reports in themselves are incredibly useful for tracking and improving your performance as a seller. In the Seller Hub, you can manage your listings and your orders. You can also customise your dashboard to reflect what you deem most important for your business.

For example, you might decide that traffic data is critical for your overall goals, which you can compare with your number of sales. Additionally, eBay sends businesses tips and tricks to help them improve their selling game and provide a better customer experience.

An eBay Shop is highly recommended for serious businesses. eBay Shops give you access to a multitude of features such as:

• Marketing tools: Build your brand and sell more products.
• Graphs and charts: Visualise your data and hone in on all the details of your business.
• Newsletters: Attract more customers by sending monthly newsletters.

How Can I Customize My eBay Sales Report to Focus on Specific Data Points Relevant to My Business?

‍

‍

You can customise select reports through the 'Payments' tab and then under the 'Reports' section we discussed earlier. You can generate and download reports based on transaction status, i.e. available funds or processing funds. To do this, you simply select the status from the drop-down menu when you enter the 'Reports' section.

You can also filter your reports by transaction type. For example, Orders, Refunds, and Payment disputes. The process is similar to downloading an annual sales report, but you select different specifications. You then create your report and download it.

What Should I Do if There Are Discrepancies in My eBay Sales Report, Such as Missing Transactions or Incorrect Fees?

‍

‍

If there is anything untoward in your reports, the best thing you can do is to contact eBay. Perhaps, for example, you were accidentally charged fees when customers didn't pay. Whether or not this gets resolved is at eBay's discretion. It might depend on how long it's been since the 'sale' happened. You could send eBay a PayPal statement, for instance, to strengthen your case.

If you're unsure if you've been overcharged a specific fee, you can use an eBay fees calculator, like eBayFeesCalculator.com, to check.

Discrepancies within your eBay reports can throw off your whole accounting process. It can mean you pay an incorrect amount of sales tax, for example. This is one reason why it's always better to automate your accounts with software like Link My Books.

Conclusion

Once you’ve your eBay sales reports, what’s next?

You should categorize each transaction into sales, taxes, refunds, and more to give you an accurate view of how your eBay shop is performing.

You can either outsource a bookkeeper/accountant or do it yourself.

But do you know there’s a more accurate bookkeeping solution available?

Whether you want to automate your eBay bookkeeping to monitor your profits and costs, track your shop’s performance, or for tax compliance—Link My Books has got you covered.

Get started on our 14-day trial—for free.

Make eBay Bookkeeping Easy

‍

‍

You can accomplish many things with the eBay Seller Hub. However, you can accomplish even more with automated bookkeeping added to the mix. Link My Books will save you time with managing your eBay reports, sales data, and taxes. It records each eBay transaction and conveniently syncs with your accounting software for easy consolidation of data.

Selling on eBay and not sure where to start? No problem. We've got plenty of resources to guide you through the process of integrating Link My Books with your eBay business and your accounting software. Better still, each of our customers gets a two week free trial and a one-to-on onboarding call. Sign up today to dramatically simplify your bookkeeping.