Import error 19 Unbalanced Transaction General Journal

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
4,733 Posts
Ultimate Partner
New Zealand
Ultimate Partner

4,733Posts

2,138Kudos

611Solutions

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 Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)

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
4,733 Posts
Ultimate Partner
New Zealand
Ultimate Partner

4,733Posts

2,138Kudos

611Solutions

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 Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)

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