I found that the only way I could import the dollar amounts into the amount column, I had to save the file as Macintosh csv in excel before import.
Hello @bsp62,
Thank you for coming to share!