Trouble Importing General Journals

Question

Hello,

We have just moved over to the new Account Right (been using one from 2005!), but our CSV document hasn't been able to be imported.

For some reason the tax codes and account numbers are changed in the import, so it can't balance. Could someone take a quick look and explain why this might be?

The attachment has been alterred slightly to not have any confidential information, but generates the same errors.

Thank you very much.

TEST.csv

Komal_S · Accepted Answer

Hi @SydTrain1

Welcome to the Community Forum!!

The issues might be related to the formatting of the import file that you've attached as it has some field values entered incorrectly. As an example, the value in the GST/BAS  reporting field should be either S, P, or left blank and your file has "X" in that column. This help article has the explanation for every field in the General Journal import:  Import and export fields.

I've also attached a sample import file for your reference that works in the latest version, can you please copy your import data in that and confirm if you're still getting the same issues.