Child pages
  • Converting the Chart of Accounts when a file comes from another accountant


 

 

ANSWER ID:36159, 36164

BankLink Practice

When a file comes from another Accountant, consider the following: 

  • When are you going to be taking the file over from the previous Accountant? This will determine which transactions need to be re-coded.
  • Are you using the same accounting software as the previous accountant?

Once you have confirmed this information you can:

  1. Run a summarised ledger report to easily identify the Chart Codes the previous Accountant has in the period you are wanting to transfer to your General Ledger.
  2. Complete a convert chart / convert GST to convert all the Chart Codes / GST rates to your accounting systems settings.
  3. Save the client file in case refreshing the chart causes any Chart Codes to become un-coded. If this happens, Abandon changes can be used to revert back to this save point.
  4. Refresh the Chart from your accounting system to bring in your Chart of Accounts.
  5. Check the coding screen / reports to make sure it has converted to your Chart of Accounts and make any changes to coding if necessary before transferring data to your General Ledger.

Let's step you through it.


To run a summarised ledger report
  1. In BankLink Practice, click Reports > Ledger Report.
  2. Click the Options tab.
  3. Select All accounts.
  4. Select the date range you are wanting to re-code in the From and To fields.
  5. For the Format, select Summarised.
  6. Deselect Show Opening / Closing Balances.
  7. Click the Advanced tab.
  8. Select the appropriate bank accounts.
  9. Select non-transferring journals if the client has used the opening / stock / year end journals.
  10. Select Bank Contras Totals and GST Control Accounts and select the totals so you know what the Chart Codes are for these accounts.
  11. Click Preview / Print / File so you can print / preview or view in another application.
To convert the chart of account code for a client
  1. In BankLink Practice, open the client file.
  2. Click Other Functions > House Keeping > Convert Chart.
  3. Click the chart button in the top-right corner to bring up the current Chart of Accounts.
    This will show the existing (old accountant's) Chart of Accounts, and give you the option to enter a new code and description for each code.
  4. Click in the New Code field and enter the Chart Code that you use in your accounting system for that particular Account description and press Enter.
    BankLink Practice displays the new code in bold.

    There is usually no reason to update the chart description as this will be updated when you refresh the chart. But if required, click in the New Description field and type the new description and press Enter. BankLink Practice displays the new description in bold.

  5. To remove a particular Chart Code (if it's not necessary or used in the period you are converting) select the line you want to remove and press Delete.
  6. When all changes are complete, click OK.
  7. Click YES to the confirmation message. The chart will be converted and the following message appears: "Chart has been converted successfully. Chart Codes updated."
  8. Click OK.
To save or load a chart mapping

If you have multiple client files you need to convert the chart for, which have the same or similar Chart of Accounts, you can saving the chart mapping so it can be used (loaded) in the future.

To save a chart mapping

  1. Click Save As in the Convert Chart of Accounts for window.
  2. Select where you want to save the file and specify a file name.
  3. Click Save. This will save a chart mapping file (.CSV) to the specified location.

To load a chart mapping

  1. In the Convert Chart of Accounts for window, click Browse.
  2. Select the applicable saved mapping file.
  3. Click Open. This will load the chart changes you had previously made.
To convert GST

If this file was set up to use a different accounting system, a convert GST may be necessary before loading your accounting system's GST Template. This is similar to the convert chart process.

  1. In BankLink Practice, open the client file.
  2. Click Other Functions > House Keeping > Convert Chart.
  3. Click the GST tab.
  4. Click the GST button in the top-right corner to display the current GST setup.
  5. Change the GST rate I.Ds as required.
  6. Click OK.
  7. Click Yes to the confirmation message. The chart will be converted and the following message appears: "Chart has been converted successfully. GST IDs Updated."
  8. Click OK.
To save or load a GST mapping

If you have multiple client files you need to convert the chart for, which have the same or similar GST setup, you can saving the GST mapping so it can be used (loaded) in the future.

To save a GST mapping

  1. Click Save As on the GST tab of the Convert Chart of Accounts for window.
  2. Select where you want to save the file and specify a file name.
  3. Click Save. This will save a chart mapping file (.CSV) to the specified location.

To load a GST mapping

  1. On the GST tab of the Convert Chart of Accounts for window, click Browse.
  2. Select the applicable saved mapping file.
  3. Click Open. This will load the chart changes you had previously made.
To load a BAS template (Australia only)
  1. Click Other functions > Templates.
  2. Click Load BAS template.
  3. Select the appropriate GST Template and click Open.
    An Information box will display "Template loaded from…"
  4. Click OK to confirm the GST Template has been loaded.
  5. Click Save or File > Save. This is in case the refresh chart goes wrong, and everything becomes un-coded. If this occurs a File > Abandon changes can be done to revert to this point.
To load GST Defaults (New Zealand only)
  1. Click Other functions > GST Setup.
  2. Click the Rates tab.
  3. Click Load Default. This will load your default GST setup from System > Practice GST Defaults.
  4. Click OK.
  5. Click Save or File > Save. This is in case the refresh chart goes wrong, and everything becomes un-coded. If this occurs a File > Abandon changes can be done to revert to this point.
To refresh the Chart of Accounts from your accounting system
  1. Click Other functions > Accounting System.
  2. For System Type select Accounting or Superfund.

    This will only show if you have a default Accounting System and Superfund system set under System > Practice Details on the Superfund System and Accounting System tabs.

  3. Click Load Default. This loads the default settings - the same as what you see when setting up a new client file.
  4. Confirm the following are set up correctly. If unsure, refer to the help guide within BankLink Practice (Appendix 1: Accounting System Interfaces or Appendix 3: Super fund system interfaces).  System Used, Load chart From, Save Entries To, and Tax Interface Used is set correctly. If you're unsure if these setting are correct,
  5. Click OK.
  6. Click Yes to confirm the chart refresh. The chart is refreshed.

If you need to refresh the chart later you can use Other Functions > Refresh Chart.