csv fees & taxes data incorrectly formatted

[FrenchVintagePrints]

I try to keep positive but once a year, that resolution flies out of the window when I have to file my tax return. Extracting the relevant data out of Etsy's csv files is a pain. This year, for the Fees & Taxes, I'm getting amounts formatted this way: -CHF34.5 (the positive ones being without the - sign). Of course my spreadsheet software doesn't recognize those as either currency or even numbers... because who separates the - sign from the actual number by putting the currency in-between? I know my way about Excel-type coding so I can figure out how to find the right function to transform those into usable numbers but how do people without coding experience manage? PLus of course Etsy doesn't provide anything other than a monthly csv for those data so I have to do it 12 times. 

[BagmakerSupply]

@FrenchVintagePrints  :  From https://help.etsy.com/hc/en-us/articles/360000343328?segment=selling  "If you'd like to download an entire year, don't select a Month. Just select a Year."

[CraftyCornishMaids]

You can't download the payment account CSV for the year, and that's the only one with all the transactions, including refunds 

[BagmakerSupply]

@CraftyCornishMaids  :  I stand corrected - something must have changed because we have always been able to download "Orders" and "Etsy Payments Sales" for an entire year. Or is there some other CSV file that OP is using.

[CraftyCornishMaids]

@BagmakerSupply 

you can download the orders CSV, for the year

but not the payment account CSV - I've never been able to download that for a year, and it's the only one I use .... however, our tax year is April-March, so it's not great, whatever you do

[FrenchVintagePrints]

I've been on Etsy since 2011, have 3 shops and I've never been able to download the Payment account or the "Etsy statements" as they are called this year or the Tax statements for an entire year. The orders yes, not the others.

[FrenchVintagePrints]

@BagmakerSupply and of course, the Orders csv doesn't have the Etsy fees in it (the commissions). Only the payment processing fees.