We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now


MYOB: Error -19:  Unbalanced transaction.

antum asked
Medium Priority
Last Modified: 2012-05-05

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?

Watch Question


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.



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 :



Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.