This knowledge base will show you how to export transactions in Banklink format from MYOB Business so you can import them into MAS.
Before you begin
In MYOB Business, under Business Settings make sure that the MAS client code is entered. For example, MAS01.
In MYOB Business, click your business name and choose Import/export data. The Import/export data page appears.
In the Date from and Data to fields, enter the dates for which you want to include transactions.
Select the Export file type of MYOB AE MAS.
Save the file to a directory. For example, O:\miscellaneous\Essentials export.
The TXT export file will be named based on the MAS Ledger code entered under Business Settings, for example MAS01.txt.
The export file may have an Encoding of UTF-8 with BOM, set as a default. This will prevent the file being imported into MAS. To correct this, change the Encoding to ANSI then save this change.
Open the MAS ledger for your client and follow the menu path Utilities > Import > BankLink Transactions or select BankLink from the Import menu.
In the BankLink directory field, type the location of your export folder, for example O:\miscellaneous\Essentials
Enter the correct Period start and Period end dates for the transactions to be imported.
In the Import Management Accounting Entries screen, select the required option as follows:
Reject entries outside current period?
Select to exclude transactions dated outside the current ledger's financial year.
Re-date entries to current period end date?
Select to re-date any entries found outside the current period end date to be dated within the current period.
Enter 969. If you are using a non-standard chart of accounts, enter the suspense account code.
Click OK. The Output Selection screen appears when the import is complete.
To print or preview the report:
Select Preview to view the report on your screen or, select Print to print the report.
Click OK to run the report.
Check that the import has been successful run a Trial Balance and check the values. Once reviewed, click OK to return to the MAS ledger.