Note: Receive Payments records, as a unique record type, can only be imported. They are included with Receive Money records when you export.
View a list of all types of fields: Field descriptions for importing and exporting
Field |
Description and Character Limits |
^Co./Last Name |
255 characters, alphanumeric |
First name |
255 characters, alphanumeric |
*Deposit 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 MYOB AccountEdge, a default account is substituted. |
ID #: |
8 characters, alphanumeric |
Receipt Date |
10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years. |
Memo |
255 characters, alphanumeric |
^Invoice # |
8 characters, alphanumeric |
^Customer PO # |
20 characters, alphanumeric |
Invoice Date |
10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years. |
*Amount Applied |
15 characters (including 2 decimal places). If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals. |
Memo |
255 characters, alphanumeric. |
Currency Code |
3 characters, alphabetic. One code per sale/purchase. When importing, must match a preexisting currency code in the Currency List. Must match customer/vendor currency code. |
Exchange Rate |
11 digits, including 6 decimal places. If blank, current exchange rate substituted. |
Payment Method |
20 characters, alphanumeric. |
Payment Notes |
50 characters, alphanumeric. |
Name on Card |
50 characters, alphanumeric. |
Card Number |
25 characters, alphanumeric. |
Expiration Date |
5 characters, numeric in the format MM/YY |
Address (AVS) |
28 characters, alphanumeric. Available only if a credit card or debit card payment method type is entered. |
ZIP (AVS) |
10 characters, alphanumeric. Available only if a credit card or debit card payment method type is entered. |
Credit Card Swiped |
1 characters, alphabetic. Indicates the card was swiped. |
Authorization Code |
30 characters, alphanumeric. |
Check Number |
17 characters, alphanumeric. |
Card Verification (CVV2) Used |
1 characters, alphabetic. Indicates the CVV2 number was entered. |
^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 |
*Required Field: When importing, this field must have a valid matching import field.
^Conditional Fields: When importing, one or more fields must contain valid entries for matching fields in the company file.