importing paypal csv into gnucash

From thelinuxwiki
Revision as of 21:01, 11 October 2013 by Nighthawk (Talk | contribs)

Jump to: navigation, search

script to format the paypal csv


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

Retrieved from "http://www.thelinuxwiki.com/index.php?title=importing_paypal_csv_into_gnucash&oldid=571"