We are trying to collect data for tax return computation for the year. We need to know our gross amounts, shipping charged, eBay fees paid, PayPal fees paid, sales tax collected and net amounts. We tried using the history reports downloaded in CSV format and then convert them to Excel files but they are a nightmare. These reports have every action that occurred, such as showing a row for transaction pending and then one minute later showing another row entry for transaction completed, on the same purchase. The chages are shown twice in the same column and you cannot do a sum on that column because the amounts will be doubled. You ahve to go row by row and clean this stuff up. I see no purpsoe for these reports, as they are just a data dump. There are also entries for funds held and then funds released that are a few minutes apart. Basically, they are dumping everyting into that spreqadsheet and it is a nighmare to clean it up. I spent 2 days on these things and they are so convoluted I am not confident that the data is clean enough to submit tax returns. What pre-formatted reports are availabe so I can just enter a date range and get this data? I need totals, not transaction specific data. A little help please!!!!!!
... View more
