Need some reports for tax filling

[vilkau]

Where can I  find (and download) a report of all the fees I paid eBay during 2021? I need it for my income tax filling. I also need a report of what I paid for shipping since I print all my shipping labels through eBay.

[luckythewinner]

If you go to the Seller Hub > Payments > Reports > Transaction Report, you can create a CSV file of every single transaction (sales, refunds, fees, shipping labels, store subscriptions, etc. ) for any date range. 

You will need to load it as a spreadsheet and do some totals however. 

[vilkau]

I am not familiar with spreadsheets and I need totals.

[clarkphilatelics]

Once eBay monthly reports are realigned, it should be possible to capture rolled up data. I wish that eBay would go back to the beginning of 2022, or even better 2021 and recast the reports. The planned transitional half-month report is scheduled for this spring for mid-month sellers. For most, this means that the reports will not become useful until 2023.

Excel skills are needed to import and correctly format the csv file after removing or relocating ten or so extraneous lines above the header row. After dates are reformatted and floating-point numbers are converted to integers, it is possible that long strings may be truncated. (Tracking numbers in the Orders Report which goes back only three months, lose some digits to the right.) It would be fairly simple for eBay offer an option to write the data to Excel.

After the data is imported, the Excel SUMIFS function can be used to total various transaction types, but no one column can be used to select which rows to sum for what. Sellers on multiple eBay sites must also convert foreign currency selling prices and fees to dollars. Are they included in the 1099-K form. I will soon find out. In 2020, it was possible to enter each Payout transaction as a split transaction in Quicken. The sales total exactly matched the eBay 1099-K. It is too bad that eBay does not total sales, final value fees, postage, insertion fees, monthly fees, and holds in Payouts reports. This year after receiving a Payout Report containing more than 350 lines without totals except for the payout amount, I concluded that downloading reports for each long-winded Payout would be quicker. Even then, fifteen minutes to download and format each complex payout report and another half hour to apply a template to expose totals could take another hour or so. Automation is possible, but is that even an idea at eBay?

Too much time spent on accounting means less time to list new inventory.

[dbfolks166mt]

     I have already pulled my yearly reports from eBay, PayPal and a couple of other third party financial processors that I use. Since I only need totals for tax purposes when setting up the spreadsheet I create multiple tabs in the spreadsheet. The first one contains the original data. I create tabs and sort the data based on the type of transaction. I then remove the other rows and total the amount for each of the transaction types. I am pretty efficient with EXCEL but I did accounting for 30 years and each individual will have to find what they are comfortable with and what form makes the most sense to them. It took me about 20 minutes to format the eBay report into something I can use for tax purposes. 

     Of course this is only the eBay, PayPal...... data and you have to add in the other expenses you have that are not tracked through the financial processors like COGS, shipping supplies, paper, ink, POV....... 

[kauvil-us]

I am not good or even familiar with EXCEL as you are, so all this is mambo jambo to me. I wish there was an easier way to do this for old fogies like me.

[southern*sweet*tea]

---

@kauvil-us wrote:

I am not good or even familiar with EXCEL as you are, so all this is mambo jambo to me. I wish there was an easier way to do this for old fogies like me.

---

The easiest way for a low volume seller to do this is to use a good old fashioned notebook and a pencil.   I've done things this way for 40 years and it works like a charm.  I don't use any sort of computer programs, I can't seem to figure them out and I'd always forget to use them anyway.

Set up a ledger book or notebook for your sales.  I have several columns:  date - venue sold - buyer name - amount received - shipping cost - site fees, etc.  I keep a running total, at the end of the month I start a new month.  At the end of the year I add up all the figures and voila - I'm done.   I keep a separate notebook for other expenses.