Journal Import Error - 1 record skipped - Input string was not in a correct format.

Question

Hi MYOB users,

I am using the general journal import function to import the journals. I am now getting this message of 1 record skipped and unable to import it and it says that the import string is not in the correct format. I am yet unable to resolve it.

Does anyone else encountered this issue?

The message is

records imported without errors.

0 records imported with warnings.

1 records skipped.

Summary of errors

Error 0: Unexpected import error - Input string was not in a correct format.

Jshar · Answer

Hi Doreen it did not work. I am working with support to try resolve it.

Janamat

Doreen_P · Answer

Hi @Jshar,

That error usually means one row or value in the file isn’t matching the general journal import format. A little import check should help track down the culprit. A few things to check:

* Download a fresh general journal template from Settings > Import and export data, and keep the headings and column order unchanged.
* Check the skipped row against the general journal import fields. Account numbers must already exist in MYOB, Is Credit must be Y or N, and amounts and tax amounts should be numeric with no currency symbols or commas. If there’s no tax, enter 0 in the tax amount field.
* Make sure dates follow your system’s date format and that there’s a blank line between each journal record, as shown in Import options.

To pinpoint the problem, try importing just the skipped journal in a fresh template. If it imports successfully, add the remaining journals back in small batches. For more on templates, see Importing and exporting data. If it’s still being skipped, please reach out to our support via Contact Us page to help with this.

Cheers,

Doreen