Page tree


 

 

Redirection Notice

This page will redirect to http://help.myob.com/wiki/x/8wRNAQ in about 5 seconds.

 

For MYOB BankLink Practice integration with MYOB Ledger, migrate your MAS ledger to MYOB Ledger.

The migration process has three tasks:

1. Configure the ledger2. Migrate to MYOB Ledger3. Check post-migration logs

Migration includes ledger details, Charts of Accounts and closing balances of the financial year. Migration is always for the full financial year. Comparative figures are migrated into MYOB Ledger, so you can use the figures for review processing and produce financial statements with up to 5 years of figures.

Migration does not make any changes to MAS.


Configure the ledger

Before migrating, you need to configure the ledger as MAS.

To configure the ledger
  1. Go to the client’s Client AccountingTrial Balance (Workpapers) tab.
  2. On the Tasks bar, click Edit Configuration Details. The Client Configuration window appears.

  3. From the Product drop-down list, select MAS.
  4. Click the MAS ledger field ellipses button. The Select Ledger window appears.

  5. Select the ledger to configure, and click OK. The Select Ledger window closes.

  6. Click OK. The Configured Ledger Details are displayed on the right of the Workpapers tab.

Migrate to MYOB Ledger

To migrate an existing ledger to MYOB ledger
  1. Go to the client’s Client Accounting > Workpapers tab.
  2. On the Tasks bar, click Migrate to AE ledger or Migrate to AO ledger.

    The Migrate data window appears and the Source product field displays the general ledger type that you are migrating.
  3. The following ledger details are automatically retrieved from your existing ledger:

    NameThe name of the configured existing ledger.
    Client codeThe client code for the selected client's ledger.

    Entity type

    The entity type defined when you configured the ledger. Select a different entity type from the drop down if required.

    If the client is configured using legacy ledgers the Entity type defaults to <Select Entity>. You can edit this as required.
    Current year end dateThe last day of the current year in the selected client’s ledger.
    Start date for new AE/AO LedgerThe date from which you want to start using the AE Ledger.
  4. If you are not using an MYOB standard chart, click in the ledger account column in the table at the bottom of the Migrate data window and enter the correct value to use for each account in the list.
    The specified codes are displayed against these accounts after migration in the Workpapers tab and the Manage Accounts window.
    If you are using an MYOB standard chart, the ledger account values displayed in the table at the bottom of the window are correct.
  5. Click OK.
  6. If an error message is displayed because the ledger that you are migrating is out of balance, ensure your existing ledger is in balance and repeat the procedure.
    When the migration is successfully completed, the Migration summary window appears displaying the migration details, including the prior year balances available (from and to dates).

Check post-migration logs

After migrating to MYOB Ledger, review the migration log and check the tax codes.

To review the migration log
  1. If you closed the Migration summary window after migrating, on the Tasks bar, click Migration summary. The Migration summary window appears.

  2. Review the summary and click Close.

  3. On the Tasks bar, click View migration log. The Migration Log window for the client appears.

  4. Optionally, to export the migration log to Microsoft Excel, click Export to Excel.

  5. Review the migration log and action any errors or warnings:

    Warnings

    Warnings in the migration log indicate that some data was not migrated. This is normally because the configured ledger does not support migration of this kind of data. For example: For Account code ***, the account name is migrated as Unknown Account Name.

    The following warning message is displayed for every successful migration: Please verify the GST rate for each account code.

    Errors

    Errors in the migration log are an indication that the data was not migrated.

    If the migration is initiated for a general ledger which has already been migrated to an AE Ledger, the following error message is displayed: The ledger already exists in the AE Ledger system.

    When the ledger balances are not the same and migration fails, the following error message is displayed: Please balance the ledger and re-migrate.


To check the tax codes
  1. Open the MAS ledger and go to Setup > Master Files > GST Table. The Master GST Table window appears.
  2. Compare your tax codes to this chart.

    Tax types chart
    MAS
    accounts
    Account RangeAccounts
    accounts
    Account Rage
    Assets (CAP)
    640–869
    Assets
    800–809
    820–828
    829–869
    892–894
    700–719
    870–891
    895–899
    650–655
    658–673
    656–657
    674–699
    739
    720–738
    766–769
    770–790
    760–765
    740–759
    791–794
    795
    Cost of Sales (GST)
    250–279
    280–299
    Cost of Sales
    11–31
    32–38
    39–40
    105–110
    130–139
    111–129
    140–209
    Equity (NTR)
    500–639
    Equity
    518–519
    535–541
    542–546
    530–534
    526–527
    547
    548
    549
    560–569
    580–609
    570–576
    577–579
    528–529
    610–649
    Expenses (GST)
    218–229
    300–479
    Expenses
    41–89
    280–494
    520–525
    Income (GST)
    230–249
    190–196
    216–217
    Income
    1–10
    259–273
    210–212
    213–279
    90–104
    Liabilities (NTR)
    870–999
    Liabilities
    900–916
    917–925
    926–949
    955
    956–958
    950–953
    959
    954
    975–984
    960–965
    966–974
    985
    986–988
    989–993
    994–998
    999
    Other Expenses (NTR)
    480–499
    Other Income
    495–517
    Other Income (NTR)
    100–189
    197–209
    210–215
      
  3. If your tax codes don't match those in the chart:
    1. In the Master GST Table, add or edit the GST rates.
      GST levels 1–14 are generally MYOB defaults.
    2. Go to Setup > Client Files > Ledger Options.
    3. Enter G in the Tax Type value field.
  4. If your Tax Types aren’t the same as those in BankLink Practice, either:

    1. delete the tax type if it's not in use

    2. change the tax code in BankLink to a default tax type code (for example, NTR) and journal the tax into the account manually.

Link BankLink Practice ledger >>

 
BankLink process
Tasks in this module