Forum Discussion

WardahMirza's avatar
WardahMirza
12 months ago

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
    11 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?

Genreve_S's avatar
Genreve_S
MYOB Moderator
11 months ago

Hi WardahMirza, 


Thanks for posting and welcome to the Community Forum. 

 

I'm sorry to hear about your difficulties in importing a transaction file. Generally, this import error code means your debit and credit do not match. I recommend checking the data on the import file to see if there are more than 3 decimal place values that cause them to not match. 

 

If the issue persists after checking, feel free to attach the error log and the import file. 

 

Let us know if you require any further assistance with this. 

Thanks,

Genreve

 

  • WardahMirza's avatar
    WardahMirza
    11 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?

    • Genreve_S's avatar
      Genreve_S
      MYOB Moderator
      11 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

       

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.

 

Related content