Check the following in the upload file.
  • Make sure the column header for the gift amount is "Gift_Amount" not "Gift Amount".
  • Verify that there are not extra spaces or special characters in the column header.
  • Check the monetary values in the Gift_Amount column for any extra spaces or characters.
  • Verify that the data in the Gift_Amount column is currency, so "10.00" not "ten dollars".
Note that some of these problems can only been seen when viewing the CSV file in a text editor like Notepad++ - Excel obfuscates some of these problems.