Summary

You can import adjusting entry files into an analysis after it has been run.

Learn about adjustments, reclassifications, and eliminations, how to import them into MindBridge, and the special handling required when using a periodic time frame in your 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.

Overview

Adjustments

Adjustments can be used to produce adjusted closing balances and create balances used in the presentation of financial statements.

This file lists accounts and account details similar to a GL file format, and provides any adjustments, corrections, or omissions to the original GL.

Reclassifications

This file lists accounts and account details similar to a GL file format, and provides the ability to move amounts from one account to another for presentation purposes.

Eliminations

This file lists accounts and account details similar to a GL file format, and provide the ability to eliminate amounts. For example, cancelling out inter-company transfers within the GL.

Select files to import

MindBridge supports several ways to select and import your files.

Method 1: Drag and drop or browse

1. On the Data page, drag and drop the file from your computer into the appropriate analysis period for one of the following sections, or browse for it on your computer:
   • Adjustments
   • Reclassifications
   • Eliminations
2. Once the file has loaded, select Continue. You will go to the first step in the import process.

Method 2: Browse file manager

1. On the Data page, select Browse in line with the appropriate section: Adjustments, Reclassifications, or Eliminations.
2. Select Browse file manager from the menu. A selection window appears.
3. Select the file you want to use.
4. When you are satisfied, Import the file. The file imports into your analysis.
5. Once the file has loaded, select Continue. You will go to the first step in the import process.

Method 3: 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.

Learn about bulk importing using a connector.

Once the file has loaded, select Continue. You will go to the first step in the import process.

Step 1: Data validation

This is the first step of the import process, where you can verify the accuracy and completeness of the data by reviewing file details and integrity checks performed on the data. You can reveal additional details by expanding the column preview section. These details can help you determine whether the data has critical issues, or if you can proceed with it as it is.

When you are satisfied that the data is correct, select Next to proceed to the Map Columns step.

Note: MindBridge will only analyze data on the first sheet in the file. If you have relevant data across multiple sheets, use the split and merge tools in the File manager ( ) to extract and combine select sheets from the original file.

To exit the import process, select Close. MindBridge will save your progress and you will go back to the Data page.

Step 2: Map columns

This step allows you to map data fields from the imported file to MindBridge's required columns, so MindBridge can effectively read, understand, and apply analytics to the data.

MindBridge will attempt to map columns based on their name, so it's important to verify that all mappings are correct.

1. Drag and drop each relevant 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 menu ( ) 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.

To return to the previous page, select Back.

To exit the import process, select Close. You will go back to the Data page and MindBridge will save your progress.

Run adjustments

After importing any adjustment, reclassification, or elimination files, select Run adjustments to run these new files through the analysis. You can import current period adjustments multiple times, and run adjustments as required. Details about each analysis run will be recorded in the Run history section of the analysis on the Data page.

The option to View analysis will be available prior to running the adjustment files.

View adjustments

Once the adjustments have been run, the adjusted balances can be seen on the Financial statements, Trends, and Ratios dashboards.

1. Go to the dashboard of your choice.
2. Use the Adjustments toggle to show or hide the adjustments on these dashboards, as desired.

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