Forum Discussion

WardahMirza's avatar
WardahMirza
User
5 months ago
Solved

Import Error - 19 - Unbalanced Transaction

I am trying to import an Excel but it comes up with Import Error -19 unbalanced transaction which has some random numbers included in the report that I haven't entered in the data file anywhere. I ha...
  • WardahMirza's avatar
    WardahMirza
    4 months ago

    Thank you so much for your response. I figured out that spend money transactions have to go in as a journal that is it should be a two liner. I was importing it in one line like purchases transaction that's why it was not working.

    It is a lot of manual work to manipulate data to split it into two lines and separate GST and Exclusive amounts. Is there a way it can go in as a one line transaction as in purchases?

WardahMirza's avatar
WardahMirza
User

Thank you so much for your response. I figured out that spend money transactions have to go in as a journal that is it should be a two liner. I was importing it in one line like purchases transaction that's why it was not working.

It is a lot of manual work to manipulate data to split it into two lines and separate GST and Exclusive amounts. Is there a way it can go in as a one line transaction as in purchases?

Genreve_S's avatar
Genreve_S
MYOB Moderator
4 months ago

Hi WardahMirza, 


Thanks for your response.

 

I understand the need to make this feature more convenient. Unfortunately, this can't be done by using the importing system as the import files need to be in a certain format to work. If you are just creating one transaction at a time, it's best to just manually record it from the application. 

 

Let us know if you require further assistance. 

 

Thanks,
Genreve

 

Related content