When adding journals into NetSuite via CSV Import, the system keeps on throwing the error message: The amounts in the journal entry must balance.
Check the CSV file if it has cells with more than 11 digits. Default number format of CSV file is General and it displays up to 11 digits in a cell. If it is more than 11 digits, it appears this way 1.09E+11 and this is not captured properly by the system.
In order for a long number to be properly displayed and used in the import, make the cell format to Text or just add quotation mark (‘) in the cell before the digits.