Questions? We have answers.

Import a general ledger

Article author
Jonathon Plowman-Samson
  • Updated

Summary

The article tells how to import a general ledger into MindBridge for analysis.

Note: You must create an analysis before you can import a general ledger file.

Navigate to the Data page

  1. Select the MindBridge icon in the sidebar to go to the Organizations page.
  2. Select View in line with the desired organization, or click anywhere in the organization row to go to the Engagements page.

  3. Select View in line with the desired engagement, or click anywhere in the engagement row to go to the Data page.


Select Data

MindBridge supports 4 ways to select and import data.

Drag and drop

  1. On the Data page, drag and drop the file from your computer into the General Ledger section.
  2. Once the import has completed, select Continue to step 1.
    You will go to the Data Validation step.

Browse your computer

  1. On the Data page, select Browse in line with General Ledger.
  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, click Continue to step 1.
    You will go to the Data Validation step.

Browse file locker

  1. On the Data page, select Browse in line with General Ledger.
  2. Select Browse file locker from the menu.
  3. Select the file you wish to use from the file locker.
    The file imports into your analysis.
  4. Once the import has completed, Continue to step 1.
    You will go to the Data Validation step.

Import using a data connector

Data connectors allow you to import all available data needed for 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.

 


Data Validation

Once the file has imported, validate the data by reviewing the file details, the integrity checks, and the column preview. This information will help you determine whether the data has issues or if you can proceed with it as it is.

If the data appears in a grouped format, MindBridge will not be able to analyze it. Select Format data to automatically format the data into an ungrouped format, then proceed with the import process. 

Note: If the file contains multiple sheets, MindBridge will only analyze data on the first sheet in the file. Move all the data you want analyzed onto the first sheet of your file, then re-import the file.

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 at a glance, and may assist you in finding anomalous data right away.

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

Import_a_general_ledger_-_Data_Validation_step.gif

 


Map Columns

Once you are satisfied with the data's integrity, 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 general ledger file, see Data Checklist - General Ledger.
  1. 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. 

Import_a_general_ledger_-_Map_Columns_v2_with_Data_Validation.gif

 

Analysis Period

The Analysis Period step allows you to verify the accuracy of your data by providing a snapshot of how it falls into the defined analysis period.

Import_a_general_ledger_-_Analysis_Period_-_V2_with_Data_Validation.gif

 

Review Analysis Period settings

Review the following items for accuracy. When you are satisfied, select Next to proceed to the Review Data step.

The left-side section provides:

  • The defined analysis period date range with the option to adjust it
  • The entries that fall within the period
  • The entries that fall outside of the period
  • The total debit value of entries within the period
  • The total credit value of entries within the period

 

The central graph displays the number of entries within and outside of the analysis period, with the option to view by day, week, or month.


The right-side section provides integrity checks related to the analysis period, including:

  • If the ledger contains any out-of-period entries
  • If there is a difference between any periods
  • If any periods overlap

 


Review the data

The Review Data step allows you to verify the accuracy of the imported data.

  1. Select your transaction ID, and if needed, run the Smart Splitter.
  2. Review the snapshot of your data.
  3. Review the graph, which shows the number of transactions in your ledger on the y-axis, and the number of entries in each transaction on the x-axis.
  4. Review the integrity checklist below the chart.
    Warning icons indicates an item that might be worth investigating. These checks do not affect your ability to run the analysis.
  5. When you are satisfied, select Next to proceed to the Adjust Settings step.

Import_a_general_ledger_-_Review_Data_-_v2_with_Data_Validation.gif


Adjust Settings

Some control points can be adjusted, while others require your input.

The Adjust Settings step allows you to make adjustments to the following control points:

When you are satisfied with the settings for these control points, select Finish Import.
Import_a_general_ledger_-_Adjust_Settings_-_v2_with_Data_Validation.gif

Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.