Child pages
  • Importing BankLink transactions into MAS

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »


 

 

ANSWER ID:27259

In MYOB Accountants Enterprise you can import BankLink transactions into your clients Management Accounting System (MAS) file.

The following information explains how to export the transactions from BankLink and then import the extracted data into MAS.

Exporting BankLink transactions


Perform the following instructions to export your BankLink transactions:

IMPORTANT!  Ensure that the name of your export file is the same as your Client Code in MAS.

Example:  If your MAS Client Code displays as TIM01 your BankLink export file should read as TIM01.TXT

 

  1. Open BankLink and go to the client ledger.
    The client code
  2. From the Other Functions menu, select Extract Data.
    The Extract Data screen appears.
  3. Type in the From date, press TAB to move to the To date field and enter the date.
    The dates appear in the To and From field.
    Note:  Ensure that the file type is a TEXT file where the file name extension displays as .TXT
  4. Press ENTER.
    The Extract Data:  Select the accounts you want to process screen appears.
  5. Select the batches to transfer and click OK.
    The Information screen appears.
  6. Click OK.
    The BankLink client appears. 


You can now proceed with the import.

Importing BankLink transactions


When importing your BankLink transactions into MAS ensure that your BankLink exported data file is a TEXT file and has the same name as your MAS Client Code.

Example:  If your MAS Client Code displays as TIM01 your BankLink export file should read as TIM01.TXT

  1. Open System Services and go to the MAS ledger.
    The MAS client detail screen appears.
  2. Follow the menu path:
    Utilities > Import > BankLink Transactions.
    The Import BankLink Transactions screen appears.
    Note:  Alternatively, expand the Import section on the Navigation bar and select BankLink.
  3. Type or select X:\BK5 in the BankLink Directory field.
    The directory is selected.
    Note:  You need to enter the drive letter and the directory where the BankLink files reside.
  4. Ensure the period start and end dates for the transactions to be imported are correct and click OK.
    The Import Management Accounting Entries screen appears.
    Select the required option for the following:

    Field

    Entry

    Reject entries outside current period?

    Select to exclude transactions dated outside the current ledger's financial year or if not selected, all transactions are imported.

    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.

    Or if not selected transactions are imported to the period relevant to the date on the transaction.

    Suspense account

    969 if you use a standard master chart or enter the suspense account code relevant to your chart.

  5. Click OK.
    The Output Selection screen appears when the import is complete.
  6. Select Preview to run this report to your screen or Print to run this report to your printer.
    The desired output is selected.
  7. Click OK to run the report then click OK to continue.
    The MAS ledger appears.
    Note:  To check that the import has been successful run a Trial Balance and check the values.


If entries that have subaccounts have not been posted successfully, check whether there is a space between the main and the subaccount in BankLink.

Example:  The subaccount is 40001 not 400 01.

 
Related topics