MYOB: Error -19: Unbalanced transaction.

Hi,

Just exported some transactions from my online banking into quicken format, then tried to import them into myob and got this error message...

Any ideas?

Thanks
Ant
antumAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Sohel RanaCommented:
Hi:

According to MYOB FAQ the solutions is as follows :

Error –19     Unbalanced transaction.

This occurs when the debits and credits in the journal entries of the Retail.txt file are out of balance. It usually appears if the accounting export was interrupted or the computer crashed while exporting. MYOB Accounting/Premier will not import a journal entry that does not balance.

 

Solution

The first step to try in rectifying this error is to re-export your sessions out of RetailManager again. To do this, go to the File menu choose Accounting Export, and double-click the Session No. of the journal you wish to export again. Now you can reattempt to import into MYOB Accounting.

If this does not fix the problem, one or more lines of the journal entry will need to be re-created manually using cashup reports from RetailManager. This can be quite difficult to rectify and if you are not confident that you can fix it, it is recommended to contact MYOB RetailManager Support.

Open the Retail.txt file in Microsoft Excel so you can view the Retail.txt file in a spreadsheet format. Browse through the file and ensure that the debits and credits for each days journal entry balance.

We have highlighted the debits (Column E) in purple colour in Figure 1.1. Note that the first line of each journal (Row 1154) will always be indented one column to the right. This cell (F1154) should be included when totalling the debits.

Check here for the screen shots and other images :

http://tinyurl.com/plpys

rsdn
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Software

From novice to tech pro — start learning today.