Importing and exporting

Journal Entries Fields


To view a list of all types of fields: Field descriptions for importing and exporting

Journal entries from all source journals -- General, Sales, Purchases, Receipts, Disbursements, Inventory, and All -- can be exported from MYOB AccountEdge.

When journal entries are imported into MYOB AccountEdge, entries from all source journals are added to the General Journal

Field

Description and Character Limits

Journal Number

8 characters, alphanumeric.

Date

10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as separator between months, days and years.

Memo

255 characters, alphanumeric.

*Account Number

Must be valid, preexisting MYOB software account number. 5 characters, numeric. May (optionally) have a non-numeric separator between the first digit and the last 4 digits (for example, 1-1234).

*Debit Amount

15 characters (including currency sign, comma and negative sign). If no decimal entered, MYOB AccountEdge appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent.

*Credit Amount

15 characters (including currency sign, comma and negative sign). If no decimal entered, MYOB AccountEdge appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent.

Job

15 characters, alphanumeric. Must match a preexisting job number in your MYOB software company file.

Currency Code

3 characters, alpha. Must be specified for a foreign currency account and must match the currency code of the account. Only one foreign currency per journal entry.

Exchange Rate

11 digits, including 6 decimal places. If blank, current exchange rate substituted.

Allocation Memo

255 characters, alphanumeric

Category

15 characters, alphanumeric

*Required Field: When importing, this field must have a valid matching import field.