importing paypal csv into gnucash

script to format the paypal csv

cat Download.csv | sed -e '1d' | awk -F "\",\"" '{ for (i=1; i<=NF; i++); printf $1 "," $7 "," $12 "," "Item ID " $16 " " $15 "\n" ; if ($8!="\"0.00\"") printf $1 "," $8 "," $12 "," "paypal fee for " $16 "\n"}' > paypal_formatted.csv