Just these help pages, not phone support or the product itself
0
1
2
3
4
5
Very dissatisfied
Very satisfied
Why did you give this rating?
Anything else you want to tell us about the help?
Article ID: 29970
Accountants Enterprise Suite
Australia
New Zealand
AE MAS (NZ)
AE MAS (AU)
ARTICLE LAST UPDATED: 05 December 2018 15:12 PM
In MYOB Accountants Enterprise MAS (AE MAS) to successfully import transactions from a third party product into AE MAS you'll need to have exported the transactions from the third party product to a .CSV file.
To do this, you'll first need to export a comma separated variable (CSV) file from your 3rd party software or alternatively, create a new .CSV file in Microsoft Excel.
Before you import your transactions, open the file in Microsoft Excel and check that format complies with the specifications below.
Requirements for importing transactions from a 3rd party product into MAS
Cell
Content
Details
A1
<ClientCode>
Enter the client code of the MAS4 ledger you are importing transactions into. For example, SMITH01
Column (Row 2 onwards)
Content
Details
A
Date
Contains the date of the transaction in the format DD/MM/YY or DD-MM-YY.
B
Type
Enter one of the following types: R = receipts, P = payments, Jnl = journal
C
Group
The group is a 3 character field and is used as an identification source.
D
Reference Number
The reference number can be up to 6 numeric characters.
E
Account Code
The account code can be up to 10 alpha-numeric characters. These codes must be valid and exist on the MAS4 ledger client chart of accounts.
F
Net Amount
Contains the actual values. All amounts are assumed to be debits unless prefixed with a minus. Amounts should not contain thousand separators. For example, 1000 and not 1,000.
G
Balance 2/ Quantity
Contains quantities.
H
Narration
Narration may be up to 60 characters long. Ensure no commas are entered into this field as this is interpreted as a column separator.
I
Contra Account
Contra account for the receipts and payments transactions.
J
Cash Journal Flag
Y for cash journal; N for non-cash journal.
K
Tax Level Code
A numeric code from 0 - 40 from the tax levels assigned in MAS.
L
Tax Amount
The amount of tax as calculated by 1/11 of the gross amount.