Error: "Invalid file format, please use the appropriate file format and try again" when importing an .MYE file to AE/AO Ledger
This support note applies to:
AO Workpapers (AU)
AE Workpapers (AU)
Workpapers (NZ)
AE Statutory Reporter (AU)
AO Statutory Reporter (AU)
AE Statutory Reporter (NZ)
Article ID: 38698
In MYOB Accountants Enterprise (AE) and MYOB Accountants Office (AO) Client Accounting, you may experience the error "Invalid file format, please use the appropriate file format and try again" when attempting to import an .MYE file to MYOB AE/AO Ledger.
Why is this error happening?
This error may happen:
when there are special characters or letters in the Account Codes, or if an Account Code is left blank when exporting transactions.
Rounding errors or
Line Feed and Carriage Return characters in the comments section [LF][CR]
To find out the details of the error, open the ClientFrameWork.log. To find the log file,
Click the Start button and enter %appdata% in the search field.
Go to the MYOB\Roaming\ClientFrameWork folder.
Solution
When there is a special character in the Account code or is blank
Before exporting the transactions make sure,
All Bank Accounts have an Account Code in the Chart of Accounts
All accounts listed in the Chart of Accounts have Numeric account codes.
The sum of all transactions is equal to 0 and your Debit and Credit columns balance.
If you're exporting from an Essentials Accounting or AccountRight file, also make sure,
All transactions in the period have been reconciled and there are no transactions allocated to the 3-8000 Allocate me (withdrawal) and 3-8001 Allocate me (deposit) accounts.
Rounding error
When there is a rounding error, you’ll see Unbalanced transaction in the clientframework.log and the reference for the transaction that is out of balance.
To find the transactions:
Rename the extension of the .MYE file to .zip.
Extract the files from the zip file
Open the MYOBAO.txt file.
Within the MYOBAO.txt file, click Ctrl+F to search for the reference that is out of balance.
Change the amount of one of the transactions to balance the journal.
There may be many transactions with a particular reference, for example, EFT.
To fix these transactions:
Copy the contents of the MYOBAO.txt file to an Excel spreadsheet.
Search for the transactions that are out of balance and balance the journal. As these are usually rounding issues, the transaction will be out of balance by one cent and there may be more than one transaction that is out of balance
Line Feed and Carriage Return characters in the comments section
When there is a rounding error, you’ll see Journal Account Code does not Exist in the clientframework.log.
To repair the MYE file in Notepad:
Rename the MYE file from .MYE to .zip and extract the MYOBAO.TXT file.
Open the MYOBAO.TXT file with Notepad and look for narration lines that extend over two or more lines as shown in the image. This is caused by narrations that are 1000 characters or more.
To repair the MYE file in Notepad++ : a. Rename the MYE file from .MYE to .zip and extract the MYOBAO.TXT file. b. Open the MYOBAO.TXT file with Notepad++. c. Go to View > Show Symbol > Show All Characters. d. Find the transactions with the extra [LF][CR] and delete the [LF][CR] in the comments of the lines.
Replace the text in the MYOBAO.TXT file, copy and replace it in the .zip file and rename the zip file back to .MYE.
Further information on importing a client file into AE/AO Ledger is available from Importing data.
To import an MYE file
Open the client’s Client Accounting > Trial Balance or Workpapers tab.
From the TASKS bar, click Manage client file imports. The Manage Client File Imports window appears.
Under Choose file type, select .MYE.
In the Select file to import field, click the ellipses button () and browse to the location of the .MYE file you want to import.
Select the .MYE file and click Open. The location and name of the import file displays in the Select file to import field.
Click Next. A message displays with details of the client’s name, start date and end date.
