- Created by Suchi Govindarajan, last modified by KimP on Aug 07, 2018
How satisfied are you with our online help?*
Just these help pages, not phone support or the product itself
Why did you give this rating?
Anything else you want to tell us about the help?
Article ID: 2780
ARTICLE LAST UPDATED: 07 August 2018 16:08:00 PM
MYOB General Ledger has automatic import routines for a wide variety of compatible software. To see what options are available check under the File menu > Import while a client ledger is open.
If you are unable to locate the program you want to import from, another option is to identify what export options are available in the source program that contains the data you want to bring into the MYOB Accountants Office ledger. For example, there may be an option to Save (i.e.Save As) or Export data from the program in a format that matches one of the import options, e.g. Comma or Tab-delimited Text (*.TXT or *.CSV), or dBase (*.DBF).
If neither of these options are suitable, then you may want to consider using a spreadsheet file.
To do this, you must first open the source program's data file and export transaction data to a format that can be opened in Microsoft Excel using the File > Save As... or Export command if it exists. The GL Import File Format table below describes the fields that can be imported, their field type, and size, etc.
Using the table below, rename the column headings in the Excel spreadsheet to match the field name required by MYOB (e.g. for the amount column, change the heading row to "ext_amt").
When you have changed the headings, save the spreadsheet as a comma delimited file (*.CSV) and import using the MYOB specified format option (File menu > Import > Other Cashbooks).
Optionally, save the attached GL import format.xls Excel spreadsheet to your computer by right-clicking on the link and choosing Save Target As...
This spreadsheet already contains these field names entered.
Transactions can be imported into Accountants Office General Ledger from either a Comma Delimited or DBF (dBase) file. Both types of file have the same structure. Below is a list of data fields that can be used to import into Accountants Office General Ledger via either CSV or DBF. If you would like an MYOB Consultant to prepare the data to import for your practice, contact your Client Manager or submit a support request.
Field Name | Type | Length | Decimals | Mandatory | Notes |
|---|---|---|---|---|---|
Ext_AccNo | C | Varies | - | Yes | Account Code. This size of the account code is configurable. |
Ext_Date | D | - | - | Yes | Date. DD/MM/YY or DD/MM/YYYY |
Ext_Ref | C | 12 | - | Yes | Reference |
Ext_Desc | C | Varies | - | Yes | Description / Comment. The maximum length is configurable. |
Ext_Amt | N |
| - | Yes | Amount. This is the NET amount, excluding any GST (if applicable). |
Ext_Qty | N |
| - | Yes | Quantity |
Ext_GSTAmt | N |
| - | Yes | GST Amount (if applicable). |
Ext_GSTAcc | C |
| - | Yes | GST Account. Account to which GST portion should be posted. Must not be blank if GST amount is not zero. |
Ext_Updt | L | - | - | Yes | Set to FALSE to indicate transaction has not been posted to GL. |
Ext_Perd | N | 6 | - | No | Period. Format is YYYYMM. If left blank will calculated from Ext_Date. |
Ext_Open | C | 1 | - | No | Opening Balance flag. Set to any nonblank value if this is an Opening balance transaction. Trn_Perd must be the first period of the financial year. |
Ext_Etype | C | 1 | - | No | Split Transaction indicator. |
Ext_SpCd | N | 6 | 0 | No | Split Transaction reference. An arbitrary unique number that links the components of a Split Transaction together. Detail record. |
Ext_Bank | C | Varies | - | No | Account code for Bank Account. |
Ext_Stat | C | 1 | - | No | Status |
Ext_TrType | C | 2 | - | No | Transaction Type |
Ext_GSTInd | C | 1 | - | No | GST Type indicator |
Ext_Ncash | C | 1 | - | No | TRUE if this is a 'Non Cash' transactions (eg. Opening Balance, Accrual). |
- The total of the EXT_Amt + EXT_GSTAmt for all records with EXT_Etype <> "M", must equal zero. This may require a contra entry to be created to the Bank Account.
- Credit values are negative numbers.
- Non-mandatory fields may be omitted from the file if the features they support are not required. For example, if your process does not support Split Transactions, Opening Balances, Bank Reconciliation or Transaction Types, then you may omit all fields after EXT_Perd. As the comma delimited import process fields from left to right, you can only omit fields from the end of the record backwards.
- If the General Ledger is configured to support Bank Reconciliation features, then Ext_Bank, Ext_Perd and Ext_TrType become mandatory.
- The length of Account codes in EXT_AccNo, EXT_Bank, Ext_GSTAcc is dependant on Configuration options within the GL.
- Split Transactions. These consist of a group of records - one Header (EXT_Etype = "M") and one or more Detail (EXT_Etype = "S"). They must obey the following rules:
- All have the same value for EXT_Ref, Ext_SpCd., Ext_Date and Ext_Perd.
- There must be one and only one record with an EXT_Etype = "M". All other records must have EXT_Etype = "S".
- The values in the Header record must equal the sum of the values in the detail records.
Yes
No
Thanks for your feedback.