...
The file needs to be in the csv (Comma-Separated Values) format—in this format, each piece of data is followed by a comma. The file should also conform to the following rules:
The header row is compulsory and must contain the following column headers:
Code,Description,Account Group,GST Type,Opening Balance,Opening Balance Date
- In each row, you must enter data for all the six columns described below.
However, for the optional columns (Opening Balance and Opening balance date), you can enter a space (that is, a blank value).
...
- Open the cashbook for the relevant business.
- Go to Settings> Account list.
- Click the Import icon on the right.
In the upload window that appears, browse and select the *.csv file and click Open.
The accounts in the file will be imported. An error message will appear if there are any problems in the import. If specific lines in the import file have problems, these will be detailed.Info Note: MYOB Essentials Cashbook uses the term item number to refer to individual rows of data. So item 1 refers to line 2 of the file, since it is the first row of data after the header.
Troubleshooting the import
...