Journal imports expect amounts as decimal text. Enter a value such as 1250.25 without a currency symbol or a thousands separator. The company reporting currency supplies the currency context for the entire entry.
Use one positive amount per row, in either Debit or Credit. Leave the opposite side blank or zero. Negative values, a positive debit and credit on the same row, or an entirely zero row fail validation. Moving a negative value to the other side should follow the correct accounting treatment, not an automatic text replacement.
The validator checks precision instead of silently rounding a source amount. For a currency with two decimal places, resolve extra fractional amounts in the supporting calculation before importing. A zero-decimal reporting currency requires amounts consistent with that currency's precision.
After correcting numeric formatting, compare the preview total with your spreadsheet total. Spreadsheet display formatting can conceal extra precision or symbols, so inspect the actual exported values when a line still fails. Keep the exact balanced amounts you intend to record, then save the completed journal draft.
Was this article helpful?
Tell us whether this answered the question you came with.