Skip to main content
Skip table of contents

Importing transactions from a 3rd party product into AE Accounts

This support note applies to:

  • AE Accounts (AU)
Article ID: 37001

MYOB Accountants Enterprise (AE) Accounts allows you to import transactions from other sources such as accounting packages, CSV files or text files including those generated from MYOB applications.

To successfully import 3rd party transactions to AE Accounts, the file exported from the 3rd party product needs to be a .CSV file. The contents of this file must comply with the format outline in this article.

Sample SVF Template (1).csv is sample of the required format for importing into MYOB AE Accounts. 

To create a CSV file in the required format

The file needs to match these specifications for you to be able to import the transactions into AE Accounts. These are normally in comma separated variable (CSV) file format which you can create using Microsoft Excel.

  1. Follow the menu path: Start > Programs > Microsoft Excel. The Microsoft Excel spreadsheet appears.
  2. The format for the cells is described in the table below:


    Content of field



    Header Record

    Identifies the Header Record. You will need to default to XLON1.


    Account Name

    Account Name of the ledger as it appears in Accounts.


    Start Date

    Starting date of transactions in the format ddmmyyy or dd/mm/yyyy or dd-mmm-yyyy.


    End Date

    Ending date of transactions in the format ddmmyyy or dd/mm/yyyy or dd-mmm-yyyy.

    The following represent row 2 onwards…


    Record Type

    The Record Type to default to TR to represent being a Transaction.


    Transaction ID

    Transaction ID of a maximum 7 numeric character.


    Transaction Type

    Transaction Type being either C for Cash or N for Non cash.



    Transaction date in the format ddmmyyy or dd/mm/yyyy or dd-mmm-yyyy.


    Account Code

    Account Code for the transaction in the format xxx or xxx-xx or xx.xx or x/xx or x/


    Ref Number

    Ref Number of a maximum of 7 alphanumeric characters.


    Total Value

    Total Value of the transaction as a dollar amount where + debit and - credit.


    GST Amount

    GST Amount of the transaction as a dollar amount where + debit and - credit.


    GST Indicator

    GST Indicator being one of S1, S2, S3, S4, S5, S6, S7, S8, A1, A2, A3, A4, A5, A6, A7 or A8.


    Capital Indicator

    The Capital Indicator indicates whether the supply or acquisition was of a capital nature where C for Capital or O for Other.



    Where applicable, the Quantity is a value in the range 1 to 99. On import this value will adopt the sign of the Total Value field.



    The Narration allows a maximum of 60 alphanumeric characters.

  3. From the File menu select Save As. The Save As screen appears.
  4. See the table below and type the appropriate entry for each field.



    Save In

    Select the drive and path where the file is to be saved

    File Name

    Type in the name which the file is to be given.

    Save as type

    Select CSV (Comma Delimited).

  5. Click the Save button. The file is saved to the selected location. The Excel spreadsheet appears.
  6. From the File menu, select Exit. The Windows Desktop appears. The Excel file is now complete and is ready to be imported into an AE Accounts ledger.
To import transactions into AE Accounts
  1. Open the AE Accounts ledger and follow the menu path: File > Import > Transaction Import. The Accounting Transaction Import window opens.
  2. Select New under Transaction Source and click Next. The wizard continues.
  3. Click Browse and in the Open window, navigate to the location of the saved file.
  4. Select the file you wish to import into AE Accounts and click Open.
  5. Click Next.

    If there are transactions contained in the file where mapping is required to the relevant account on the AE Accounts Chart, the mapping options appear.  Edit the required map and ensure all account codes used in the file are mapped to a relevant account code.
  6. Select the relevant transaction types and click Next. A summary of the import process appears.
  7. Click Finish. The Accounting Transaction Import wizard closes and the transactions are imported.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.