Questions? We have answers.

Import a chart of accounts or an account list

  • Updated

Summary

The Data page is a cumulative import source, and each import contributes to the account mapping conditions of the engagement. Accounts can be mapped manually within MindBridge, or automatically by importing a chart of accounts or account list file.

Learn how to import a chart of accounts or an account list into a General ledger analysis.


Go to the Data page

  1. Select the logo in the MindBridge sidebar. You will go to the Organizations page.
  2. Select View in line with the desired organization, or click anywhere in the organization row. You will go to the Engagements page.
  3. Select View in line with the desired engagement, or click anywhere in the engagement row. You will go to the Data page for that particular engagement.

Tip: If you are already in an analysis, open the sidebar ( Sidebar_open-close_icon.svg ) and go to the Data ( Data_page_icon.svg ) page.


Select files to import

MindBridge supports several ways to select and import files.

Drag and drop

  1. On the Data page, drag and drop your file into the Chart of Accounts row of your desired analysis.
  2. Once the file has loaded, select Continue. You will go to the Data Validation step of the import process.

Browse your computer

  1. On the Data page, select Browse... in the Chart of Accounts row of your desired analysis.
  2. Select Browse your computer from the menu.
  3. Select the file you wish to use and Open it. The file will load into your analysis.
  4. Once the file has loaded, select Continue. You will go to the Data Validation step of the import process.

Browse file manager

  1. On the Data page, select Browse... in the Chart of Accounts row of your desired analysis.
  2. Select Browse file manager from the menu. A selection window appears.
  3. Select the file you wish to use.
  4. When you are satisfied, Import the file. The file will load into your analysis.
  5. Once the file has loaded, select Continue. You will go to the Data Validation step of the import process.

Import using a data connector

Data connectors allow you to import all available data needed for an analysis at once. You can invite a client to connect or connect yourself to a data connector.

Once the file has loaded, select Continue. You will go to the Data Validation step of the import process.

Learn about bulk importing using a connector.


Validate the data

On the Data Validation step, you can review the file details, integrity checks, and a preview of the columns. This information is available to help you determine whether the data has issues, or if you can proceed with it as it is.

When you are satisfied that the data is correct, select Next to continue to the Map Columns step of the import process.

At any point you can select Close to go back to the Data page.

Learn more about data validation

File details

These high-level file details can help you be sure that the imported data meets your expectations at a glance.

Integrity checks

These checks include detailed information on every column within the data. They may indicate issues with the file, but will not prevent you from continuing the import process.

Column preview

These statistics can help verify your expectations, and may assist you in finding anomalous data right away.


Map columns

On this step, your existing column headers appear as draggable fields beneath Your Data Column Headers.

Note: For a detailed list of the expected columns in a chart of accounts file, see Data Checklist - General Ledger.
  1. Drag and drop relevant fields from the Your Data Column Headers section into the appropriate field beneath Mapped Columns.
  2. If your data columns do not line up one-to-one with the MindBridge columns, use the more actions menu ( More_actions_menu_icon.svg ) to split, join, or duplicate columns to make the needed adjustments, or add a column for filtering.
  3. When you are satisfied, select Next to proceed.
    You will go back to the Data page.

Select Back to go back to the Data Validation step.

At any point you can select Close to go back to the Data page. MindBridge will save your progress.


Verify accounts

To ensure that accounts have been mapped properly, you must verify the account mapping. Some manual adjustment of mapping may be required.

  1. On the Data page, open the more actions menu ( More_actions_menu_icon.svg ) and select View accounts. You will go to the Account grouping step.
  2. Select Next. You will go to the Account mapping step.
  3. Use the Account group menu in the table to change the MAC code mapping of an account, or open the Actions menu and select Import account list to import an updated account list or chart of accounts.
  4. If you have unused mappings, open the Actions menu and select Remove unused mappings.
  5. When you are satisfied with the accuracy of the account mapping, select Next. You will go to the Review step.
  6. If you are certain the accounts have been mapped correctly, select Done. You will return to the Data page.

At any point you can select Back to go back to the Account grouping step, or Cancel to go back to the Data page. 

Note: Selecting Done automatically verifies all account mappings. Ensure that each account is mapped correctly before proceeding. Account mappings can be updated, but any analyses that use the existing account mappings will have to be re-run.

Anything else on your mind? Chat with us or submit a request for further assistance.

Was this article helpful?