Import error 19 Unbalanced Transaction General Journal

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
Katie_Mc
3 Posts
User

3Posts

1Kudos

0Solutions

Solved: Go to Solution

Import error 19 Unbalanced Transaction General Journal

Hi

I am trying to import a general journal .txt file into MYOB AccountRight like i usually would.  For some reason it is saying that the transaction is unbalanced.  I am sure it is something easy but I have been looking for ages and can not find the error.

 

Can you please help.

 

Thanks

4 REPLIES 4
Mike_James
Ultimate Partner
5,839 Posts
Ultimate Partner
New Zealand
Ultimate Partner

5,839Posts

1,080Kudos

755Solutions

Re: Import error 19 Unbalanced Transaction General Journal

Hi @Katie_Mc , welcome to the forum. The Dr & Cr amounts totals are different by 3 cents. (I copied the file to Excel and summed them there.

 

I note there are no tax codes on any of the lines. 


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)

Bulk download of attachments (more details...)

Katie_Mc
3 Posts
User

3Posts

1Kudos

0Solutions

Re: Import error 19 Unbalanced Transaction General Journal

Hi @Mike_James 

Thanks for your reply.  

Ah ok so i see that although i have selected only 2 decimal places the individual cells still show multiple.  Do you know how i can change this?

Thanks

Mike_James
Ultimate Partner
5,839 Posts
Ultimate Partner
New Zealand
Ultimate Partner

5,839Posts

1,080Kudos

755Solutions

Accepted Solution Solved

Re: Import error 19 Unbalanced Transaction General Journal

Hi @Katie_Mc , if you've applied a rounding format, check the totals again. If that's still a problem, you'll have to calculate rounded amounts in a separate column and copy the values back over the original .


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)

Bulk download of attachments (more details...)

Katie_Mc
3 Posts
User

3Posts

1Kudos

0Solutions

Re: Import error 19 Unbalanced Transaction General Journal

Ok thanks Smiley Happy

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post