Importing/Exporting - Spend Money Fields

Spend Money Fields

^Note:Pay Bills^{records, as a unique record type, can only be imported. They are included with Spend Money records when you export.}

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

Field

Description and Character Limits

*Checking Account

5 characters, numeric. May have an optional non-numeric separator between the first digit and the last 4 digits (example: 1-1234).
If the checking account doesn't exist in AccountEdge, a default account is substituted.

Check #:

8 characters, alphanumeric

Date

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

^Co./Last Name

255 characters, alphanumeric

First name

255 characters, alphanumeric

Addr 1
  - Line 1
  - Line 2
  - Line 3
  - Line 4

Total Address field (lines 1 to 4) cannot exceed 255 characters, alphanumeric.

Memo

255 characters, alphanumeric

*Allocation Account #

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).

*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

Import Duty Amount

15 characters (including 2 decimal places). If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals.
NOTE:  Importing and exporting currency amounts

Printed

1 character alphanumeric indicates the transaction has already been printed.

Currency Code

3 character alphanumeric.

Exchange Rate

10 digits, including 9 decimal places. If blank, current exchange rate substituted

Statement Text

18 characters, alphanumeric

Allocation Memo

255 characters, alphanumeric

Category

15 characters, alphanumeric

^Card ID

15 characters, alphanumeric. Must be a unique ID.

Note: When you select Card ID in the Identify Card by field, *None is equivalent to no entry in the field.

^Record ID

10 numeric characters

The Record ID is an internal number within the MYOB AccountEdge company file.

^Conditional Fields: When importing, one or more fields must contain valid entries for matching fields in the company file.

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

Field	Description and Character Limits
*Checking Account	5 characters, numeric. May have an optional non-numeric separator between the first digit and the last 4 digits (example: 1-1234). If the checking account doesn't exist in AccountEdge, a default account is substituted.
Check #:	8 characters, alphanumeric
Date	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.
^Co./Last Name	255 characters, alphanumeric
First name	255 characters, alphanumeric
Addr 1 - Line 1 - Line 2 - Line 3 - Line 4	Total Address field (lines 1 to 4) cannot exceed 255 characters, alphanumeric.
Memo	255 characters, alphanumeric
*Allocation Account #	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).
*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
Import Duty Amount	15 characters (including 2 decimal places). If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals. *NOTE:* Importing and exporting currency amounts
Printed	1 character alphanumeric indicates the transaction has already been printed.
Currency Code	3 character alphanumeric.
Exchange Rate	10 digits, including 9 decimal places. If blank, current exchange rate substituted
Statement Text	18 characters, alphanumeric
Allocation Memo	255 characters, alphanumeric
Category	15 characters, alphanumeric
^Card ID	15 characters, alphanumeric. Must be a unique ID. Note: When you select Card ID in the Identify Card by field, *None is equivalent to no entry in the field.
^Record ID	10 numeric characters The Record ID is an internal number within the MYOB AccountEdge company file.