1. In Connect, click on the setup tab and Edit under Mapping Tables.
2. Select the mapping table being used from the dropdown and Edit.
3. In the Sample Data, where there is a preview of you Excel file, note the column that contains the amounts.
4. In the Mapping Table section, locate the amount field name.
5. Ensure that the Import Fld # for amount matches to the column from step 3.
6. Adjust the value as needed, click on Close Form, and generate the import file as normal.