Questions? We have answers.

Import a chart of accounts or MAC file

Article author
Jonathon Plowman-Samson
  • Updated

Summary

Learn how to import a chart of accounts or MindBridge Account Classification ("MAC") file 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.

Select data

MindBridge supports 4 ways to select and import your data.

Drag and drop

  1. On the Data page, drag and drop your file into the Chart of Accounts section of the page.
  2. Once the import has completed, select Continue to step 1.
    You will go to the Map Columns step.

Browse your computer

  1. On the Data page, select Browse in line with Chart of Accounts.
  2. Select Browse your computer from the menu.
  3. Select the file you wish to use and Open it.
    The file imports into your analysis.
  4. Once the import has completed, select Continue to step 1.
    You will go to the Map Columns step.

Browse file manager

  1. On the Data page, select Browse in line with Chart of Accounts.
  2. Select Browse file manager from the menu.
    A pop-up window appears.
  3. Select the file you wish to use.
  4. When you are satisfied, Import the file.
    The file imports into your analysis.
  5. Once the import has completed, select Continue to step 1.
    You will go to the Map Columns step.

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.

Refer to our article on Bulk importing using a connector.


Map Columns

Once your chart of accounts file has imported, map its columns. 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. In the Map Columns step, drag and drop a field from Your Data Column Headers to 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 icons 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. 

coa-column-map.gif


Map Accounts

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

  1. To adjust account mapping, go to the Account type column, then open the menu in line with the account you want to adjust.
  2. Select the appropriate MAC code
  3. When you are satisfied with the accuracy of the account mapping, select Done.
    Note: Proceeding verifies all account mappings, so ensure each account is properly mapped before selecting Done. Account mappings can be updated, but any analyses that use the existing account mappings will have to be re-run.
    You will return to the Data page, where you can view the number of verified and unused accounts.
    Import_a_chart_of_accounts_-_Map_accounts.gif


Adjust and verify account mapping

  1. On the Data page, go to the Account Data section, and select View in line with Account Mapping.
    You will go to the Account Mapping Settings page.
  2. Go to the Account type column, then open the menu in line with the account you want to adjust.
  3. Select the appropriate MAC code
  4. If you have unused mappings, you can open the Additional options menu and select Delete unused mappings.
  5. When you are satisfied with the accuracy of the account mapping, select Done.

 


Anything else on your mind?

Head over to the community with your thoughts and inquiries! You can also chat with us, or, submit a request for further assistance.


Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.