Questions? We have answers.

Unlock the analytical capabilities of MindBridge Analyses

Article author
Jonathon Plowman-Samson
  • Updated

Summary

Uploading different datasets into MindBridge unlocks different analytical capabilities. Continue reading to learn more about the available analytical capabilities for each analysis, and the required datasets for each.   

General Ledger Analysis

Datasets Used for the General Ledger Analysis

  • 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 upload 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.

View our General Ledger Data Checklist to learn more about these datasets.

Available General Ledger Analysis Capabilities

  • Risk scoring and analytics: Unlock by importing a general ledger.
  • Trends and ratios: Unlock by importing a general ledger and opening balance (optional). Importing an opening balance ensures that account balances reflect the position of the accounts at the start of the fiscal year.
  • Year over year trends and ratios: Unlock 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: Unlock by importing the current, and at least four previous years, general ledger.
  • Income statement report: Unlock by importing a general ledger.
  • Balance sheet report: Unlock by importing a general ledger and an opening trial balance.
  • Balance reconciliation: Unlock by importing a general ledger, and an opening and closing trial balance.

Accounts Payable Analysis

Datasets Used for the Accounts Payable Analysis

  • 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. 

View our Accounts Payable Data Checklist to learn more about these datasets.

Available Accounts Payable Analysis Capabilities

  • Risk scoring and analytics: Unlock by importing an AP detail.
  • Trends: Unlock 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.
  • Year over year trends: Unlock 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: Unlock by importing an AP detail file and an open payables list.

Accounts Receivable Analysis

Data Sets Used for the Accounts Receivable Analysis

  • 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.

View our Accounts Receivable Data Checklist to learn more about these data sets, including the required files.

Available Accounts Receivable Analysis Capabilities

  • Risk scoring and analytics: Unlock by importing an AR detail.
  • Trends: Unlock 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.
  • Year over year trends: Unlock 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: Unlock by importing an AR detail file and an open receivables list.
Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.