Questions? We have answers.

Import customer opening balances

  • Updated

Summary

The customer opening balances file provides information about the outstanding balances of customer accounts at the start of a new fiscal year or reporting period. This file serves an important purpose in the financial reporting and reconciliation process. MindBridge uses these documents for risk assessment and anomaly detection.

Learn how to import customer opening balances into MindBridge for analysis.

Note: Only applies to accounts receivable analyses.

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 the file from your computer into the appropriate period of the Customer Opening Balances row.
  2. Once the file has loaded, select Continue import.
    You will go to the first step in the import process.

Browse your computer

  1. On the Data page, select Browse... in the appropriate period of the Customer Opening Balances row.
  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 file has loaded, select Continue import.
    You will go to the first step in the import process.

Browse file manager

  1. On the Data page, select Browse... in the appropriate period of the Customer Opening Balances row.
  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 file has loaded, select Continue import.
    You will go to the first step in the import process.

Import using a data connector

Data connectors allow you to import all available data needed for an 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 the first step in the import process.

Learn about bulk importing using a connector.


Validate the data

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

File details

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

Integrity checks

These checks include detailed information about every column found in 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.
Import_customer_opening_balance_-_Data_Validation.gif

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.


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 customer opening balances file, see Data Checklist - Accounts Receivable.
  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.
    You will return to the Data page.

Import_customer_opening_balance_-_Map_Columns_-With_Data_Validation.gif.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.


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

Was this article helpful?