HTML |
---|
<!--Merged with 26088-->
<!--Product families-->
<div style="display: none;" data-swiftype-name="productFamily" data-swiftype-type="enum">Accountants Enterprise Suite</div>
<!--Countries-->
<div style="display: none;" data-swiftype-name="country" data-swiftype-type="enum">Australia</div>
<div style="display: none;" data-swiftype-name="country" data-swiftype-type="enum">New Zealand</div>
<!--Product capabilities-->
<div style="display: none;" data-swiftype-name="productCapability" data-swiftype-type="enum">AE MAS (NZ)</div>
<div style="display: none;" data-swiftype-name="productCapability" data-swiftype-type="enum">AE MAS (AU)</div> |
div |
---|
| ARTICLE LAST UPDATED: Page Information Macro |
---|
| modified-date |
---|
| modified-date |
---|
dateFormat | dd MMMM YYYY HH:MM aa |
---|
|
|
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. UI Expand |
---|
title | File format requirements |
---|
| Requirements for importing transactions from a 3rd party product into MASCell | 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. | M | Tax Balance 2/Quantities | Contains quantities that relate to the tax amount |
|
UI Expand |
---|
title | To import the transactions |
---|
| To import a CSV file into MASOpen your MAS ledger and follow the menu path Utilities > Import > 3rd Party Transactions, then click Next to the first screen. Select the I have a current backup of this ledger checkbox, then click Next. On the Select transaction file screen, type the location and the file name of the file to be imported then click OK. On the Import file data type screen select the Delimited format and the Delimiter character then click Next, then Next again. On the Map account codes screen, if your file contains the correct account codes select mapping option No mapping and click Next. Enter a nominated suspense account then click Next, and then Finish. The Import transactions has completed successfully. Click OK.
The import process is completed and you may now review the data. |
|