Importing and exporting

Journal Entries Fields


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

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

*Debit Amount

15 characters (including 2 decimal places). If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals.

NOTE:  Importing and exporting currency amounts

*Credit Amount

15 characters (including 2 decimal places). If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals.

NOTE:  Importing and exporting currency amounts

Job

15 characters, alphanumeric. Must match a preexisting job number in the AccountEdge company file.

Currency Code

3 characters, alphabetic. 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 is substituted.

Allocation Memo

255 characters, alphanumeric

Category

15 characters, alphanumeric

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