Questions? We have answers.

Import a general ledger (full or interim)

  • Updated

Summary

A general ledger ("GL") is a fundamental component of a double-entry bookkeeping system and a core accounting document. As an entity's primary accounting record, it summarizes all financial transactions in an organized and systematic way. When you import a GL for analysis, MindBridge's general ledger analytics will be run against 100% of the imported data to detect risk and anomalies.

Follow the steps below to import a full or interim GL into MindBridge:

Plus, learn what to do if you need to delete or replace a GL file, or restart the import process.

*Note: If you are using the periodic time frame for your analysis, follow the steps for this import process.

Configuration details

You must create an analysis before you can import a GL file into MindBridge.


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 ) and go to the Data ( Data page icon ) page.


Select files to import

In a full or interim GL analysis, you can import files containing current and prior period data (up to 4 prior periods) for analysis. 

Current period

The current period dates represent the most recent period of time you want to analyze.

For the full time frame*, the GL file should contain all the data required for the given analysis period. 

For the interim time frame*, your GL should contain all the data from the beginning of the analysis period to the as-at date defined when creating the analysis. 

Prior period

The prior periods represent data from previous analysis periods. The data you import into "Prior period 1" should end immediately before the current period begins, with no gaps or overlapping dates between periods.

Note: Ideally, the data in each prior period should represent one full prior analysis period. For example, if your current analysis period will represent one calendar year (e.g., January to December of 2022), the prior period data should span the same time frame for the previous year (i.e., Prior period 1: January to December, 2021; Prior period 2: January to December, 2020; etc.).
Tip: Importing prior period data gives you access to the Prior period comparison dashboard, as well as period-over-period analytics on the Trends and Ratios dashboards.

Add files to the analysis

MindBridge supports several ways to add and import files.

Method 1: Drag and drop

  1. On the Data page, drag and drop your file into the appropriate period of the General ledger row.
  2. Once the file has loaded, select Continue import.
    You will go to Data Validation, the first step in the import process.

Method 2: Browse your computer

  1. On the Data page, select Browse... in the appropriate period of the General ledger row.
  2. Select Browse your computer from the menu.
  3. Select the file you want to use and Open it.
    The file imports into your analysis.
  4. Once the file has loaded, select Continue import.
    You will go to Data Validation, the first step in the import process.

Method 3: Browse file manager

  1. On the Data page, select Browse... in the appropriate period of the General ledger row.
  2. Select Browse file manager from the menu.
    A pop-up 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 import.
    You will go to Data Validation, the first step in the import process.

Method 4: Import using a data connector

Data connectors allow you to import all available data needed for analysis at once. On the Data page, you can invite a client to connect or connect yourself to a data connector.

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

Refer to our article on Bulk importing using a connector.


Step 1: Data validation

This is the first step of the import process, where you can validate the data within your file by reviewing the file details, integrity checks, and column preview. These details are presented here in order to help you determine whether the data has critical issues, or if you can proceed with it as it is.

Data format

If your file contains grouped data, 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. If needed, you can use the split and merge tools in the File Manager ( File_manager_icon ) to extract and combine select sheets from the original file.

File details

These high-level file details on the left side of the screen can help you be sure that the imported data meets your expectations.

Integrity checks

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

Note: Your data must contains at least 1 column that contains only numeric values. If MindBridge detects a non-numeric character in a numeric column, you will not be able to proceed. To resolve the issue, remove non-numeric characters from the numeric column and re-import the file.

Learn more about integrity checks

Column preview

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

Use the chevron icon ( Expand chevron icon ) to expand the section and see a preview of your columns.

Learn about previewing your columns

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



To exit the import process, Close the page. MindBridge will save your progress.


Step 2: Map columns

Once you are satisfied with the data's integrity, you can map your existing column headers to MindBridge's columns. Mapping columns allows MindBridge to read, understand, and apply analytics to your data.

Tip: The Manual Entry control point uses the Type and Source columns mapped in this step to search for keywords your firm has identified as suspicious.
Note: The Account ID, Effective Date (i.e., the date the transaction actually takes place), and the Amount columns are required. 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 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.

GIF showing the Data Validation step.gif


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.


Step 3: Verify the analysis period

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

Note: Out-of-period entries are not included in the analysis. To avoid issues such as unbalanced transactions or unbalanced accounts, ensure the current period start and end dates are correct and that an appropriate Effective Date column has been mapped.GIF showing the Analysis Period step.gif

Review analysis period settings

Review the following items for accuracy. 

The left-side section provides:

  • The defined analysis period date range — select Edit to make changes
  • 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 gap between any periods
  • If any periods overlap

When you are satisfied, select Next to proceed to the Review Data step.

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.


Step 4: 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.

GIF showing the Review Data step.gif

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.


Step 5: Adjust the 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:

Note: Changes made here will not affect control point settings in the library.

When you are satisfied with the settings for these control points, select Finish Import.

GIF showing the Adjust Settings step.gif

You will go back to the Data page, where you must verify the accounts before running the analysis.

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.


Restart the import process

You can restart the import process any time, regardless of whether the analysis was run or not.

  1. Open the more actions menu ( More actions menu ) in line with the desired file.
  2. Select Restart import.
    A confirmation window will appear.
  3. Select Confirm to restart the import process.
    You will go back to the Data page, and will see the option to Continue import.

Select Cancel any time to go back to the Data page without restarting the import process.


Replace a general ledger

Replace the imported general ledger with a file from your computer or the file manager.

  1. Open the more actions menu ( More actions menu ) in line with the desired file.
  2. Select your replacement preference:
    • Replace file from computer
    • Replace file from file manager
  3. Select the file you want to import into the analysis.
    The existing file will be removed from the analysis and replaced by the file you selected, but a copy of the original will remain in the file manager.

Select Cancel any time to go back to the Data page without replacing the file.


Delete a general ledger

Permanently remove a file from the analysis.

  1. Open the more actions menu ( More actions menu ) in line with the desired file.
  2. Select Delete file.
    MindBridge will confirm that you want to remove the file from the analysis.
  3. When you are ready, Delete the file.
    The file will be removed from the analysis, but a copy will remain in the file manager.

Select Cancel any time to go back to the Data page without deleting the file.


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


Related articles

Was this article helpful?