Summary

Importing different datasets into MindBridge allows you to leverage different analytical capabilities.

Learn more about the analytical capabilities for each analysis, and the datasets required to access them.

General ledger analysis

Datasets

• General ledger: Usually an export from an ERP or accounting system. This export typically needs to be converted into an excel format such as .xlsx or .csv.
• Opening balances: Contains account balances at the start of the fiscal year.
• Closing balances: Contains account balances at the end of the fiscal year.
• Chart of accounts: Helps MindBridge map your account numbers to the appropriate MAC code.
• Account mapping: MindBridge will detect and map accounts automatically when you import a general ledger, chart of accounts, or account mapping file. You will need to verify your account mappings before running an analysis. Account mappings are shared between all general ledger analyses within this engagement.

Analysis capabilities

• Risk scoring and analytics: Access by importing a general ledger.
• Trends and ratios: Access by importing a general ledger and opening balance. Importing an opening balance ensures that account balances reflect the position of the accounts at the start of the fiscal year.
• Prior period comparison: Access by importing a general ledger and opening balance the for current and immediately prior period.
• Period-over-period trends and ratios: Access by importing the current year’s general ledger, at least one previous year, and opening balances (optional). Importing an opening balance for each year ensures that all account balances are up-to-date with adjusting entries made prior to that year.
• Expected range: by importing the current, and at least four previous years, general ledger.
• Income statement report: Access by importing a general ledger.
• Balance sheet report: Access by importing a general ledger and an opening trial balance.
• Pre-analysis completeness check: Access by importing a general ledger, an opening balance, and closing balance.
  
  

Accounts payable analysis

Datasets

• AP detail: Contains all increases and reductions in AP accounts, including invoice and cash activity.
• Vendor list: Your client’s approved vendors.
• Vendor opening balances: Your client’s vendor accounts at the start of the fiscal year.
• Open payables list: Contains all open payables as at the start of the year, allowing for detailed aging calculations.

Analysis capabilities

• Risk scoring and analytics: Access by importing an AP detail.
• Trends: Access by importing an AP detail and an open payables list or vendor opening balances (both optional). Importing an opening balance ensures that vendor balances reflect the position of the accounts at the start of the fiscal year.
• Period-over-period trends: Access by importing the current year’s AP detail, at least one previous year AP detail, and an open payables list or vendor opening balances (both optional). Importing an open payables list or vendor opening balances for each year in the analysis ensures that all vendor balances are up-to-date with adjusting entries made prior to that year.
• Vendor aging: Access by importing an AP detail file and an open payables list.
  
  

Accounts receivable analysis

Datasets

• AR detail: Contains all increases and reductions in AR accounts, including invoice and cash activity.
• Customer list: Provides the names of each customer.
• Customer opening balances: Contains the balances on your client’s customer accounts at the start of the fiscal year.
• Open receivables list: Contains all open receivable as at the start of the year, allowing for detailed aging calculations.

Analysis capabilities

• Risk scoring and analytics: Access by importing an AR detail.
• Trends: Access by importing an AR detail and an open receivables list or customer opening balances (both optional). Importing an open receivables list or customer opening balances ensures that customer balances reflect the position of the accounts at the start of the fiscal year.
• Period-over-period trends: Access by importing the current year’s AR detail, at least one previous year AR detail, and an open receivables list or customer opening balances (both optional). Importing an open receivables list or customer opening balances for each year in the analysis ensures that all customer balances are up-to-date with adjusting entries made prior to that year.
• Customer aging: Access by importing an AR detail file and an open receivables list.
  
  

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