In order to import amount based fields into the Raiser's Edge, they have to be formatted in your data source (.csv, .xls, .xlsx, etc.) in a format that will be recognized by the Raiser's Edge as an amount. This means that if you have a formula (such as SUM or VLOOKUP) in your spreadsheet, while you will see what appears to be an amount, the actual data viewed by Importacular and Raiser's Edge is a formula and this will not import correctly into the Raiser's Edge.
You can resolve this by copying the field and pasting values or by manually keying the actual amount.
If your data requires a formula to adjust the amount, you may also be able to achieve the result that you need using the available data transformations for amount based fields. For more information on those options, see this knowledgebase article.