NetSuite CSV import says an amount is missing
Check which field supplies the amount and whether the expense line also needs a rate or quantity.
An expense amount needs a rate or quantity
Message may mention: Amount.
What it means
The expense amount may depend on a missing rate or quantity.
Import context: Expense reports.
Check this first
Check the expense category and how that line's amount should be calculated.
Show the steps
Check the number that was actually saved
- Open the saved CSV as text and locate the affected value.
- Compare it with the original export when one is available. Compare numeric values precisely, not just the displayed number of decimals.
- Check whether the column is an amount, quantity, rate, or identifier. Identifiers must keep their original characters, including leading zeros.
- Match number formatting to the import's decimal settings. Check currency symbols, grouping separators, and exponent notation where relevant.
- Restore lost digits from the original source. Adding decimal places to a rounded value does not recover them.
- Inspect the final CSV after saving it again.
Excel can export the value as displayed when saving CSV. That makes the saved file the final check, even when the formula bar previously showed more precision. Microsoft CSV export guidance
For quantities, compare the same units and the same stock balance. For amounts, identify which field owns the calculation before changing a number. Do not balance a journal or inventory adjustment by inserting an arbitrary difference. Keep debit, credit, rate, quantity, and precision findings separate.
Documentation checked September 16, 2026.
The amount cannot be determined
Message may mention: amount.
What it means
NetSuite can't determine the amount.
Import context: General imports.
Check this first
Check numbers and duplicate input.
Show the steps
Check the number that was actually saved
- Open the saved CSV as text and locate the affected value.
- Compare it with the original export when one is available. Compare numeric values precisely, not just the displayed number of decimals.
- Check whether the column is an amount, quantity, rate, or identifier. Identifiers must keep their original characters, including leading zeros.
- Match number formatting to the import's decimal settings. Check currency symbols, grouping separators, and exponent notation where relevant.
- Restore lost digits from the original source. Adding decimal places to a rounded value does not recover them.
- Inspect the final CSV after saving it again.
Excel can export the value as displayed when saving CSV. That makes the saved file the final check, even when the formula bar previously showed more precision. Microsoft CSV export guidance
For quantities, compare the same units and the same stock balance. For amounts, identify which field owns the calculation before changing a number. Do not balance a journal or inventory adjustment by inserting an arbitrary difference. Keep debit, credit, rate, quantity, and precision findings separate.
Documentation checked September 16, 2026.
Related errors
- NetSuite cannot read the date or posting period
- Event dates or times are missing or invalid
- Numbers or identifiers changed in the CSV
- The vendor bill total disagrees with its lines
Still stuck?
We can help you work through the file, the mapping, and the NetSuite setup behind the error.
Talk to MySuite