MYOB: Error -19:  Unbalanced transaction.

Posted on 2006-03-24
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?

Question by:antum
    1 Comment
    LVL 16

    Accepted Solution


    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 :


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
    If your app took Google’s lash recently, here are the 5 most likely reasons.
    The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.
    An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now