Questions? We have answers.

Data checklists

• Data checklist: General ledger (For-profit and not-for-profit without fund)
• Data checklist: General ledger (Not-for-profit with fund)
• Data checklist: Accounts payable
• Data checklist: Accounts receivable
• Data checklist: Opening and closing balances
• Data Checklist: SAP requirements for accounts payable analysis
• Data Checklist: SAP requirements for accounts receivable analysis

Data requirements

• Data Validation: Overview
• How to prepare your Intacct account to function as a data import source in MindBridge
• Find and apply a client's transaction ID

Imports for GL analysis

• Import a chart of accounts or an account list
• Import a general ledger (full or interim)
• Import a general ledger (periodic)
• Import additional data
• Import adjustments, reclassifications, and eliminations
• Import opening and closing balances

Imports for AP analysis

• Import a vendor list
• Import an AP detail file
• Import vendor opening balances
• Import vendor/customer opening balances or an end of period outstanding payables/receivables list

Imports for AR analysis

• Import a customer list
• Import a start or end of period outstanding receivables list
• Import an AR detail file
• Import customer opening balances

File manager

• File manager: Overview
• Split sheets out from a file
• Merge multiple files onto one sheet

Formatting data

• Formatting GDPdU: Zero Opening Balance Entries for Revenue and Expenses Accounts
• Formatting GDPdU: Running a Pre-Analysis Completeness Check
• Formatting GDPdU: Identifying and Resolving Flip Accounts in the Trial Balance
• Formatting GDPdU: Identifying and Removing Opening Balance Entries in the General Ledger
• Formatting GDPdU: Identifying D & K / Sub Ledger Accounts
• Formatting GDPdU: How do GDPdU Files Work?
• Formatting GDPdU: Data Checklist

Data validation

• Data Validation: Abnormally large cells
• Data Validation: Special characters that must be escaped
• Data Validation: Consistent number of columns
• Data validation: Date formats
• Data Validation: Why a general ledger must contain at least one numeric column

Other articles

• Best practices for formatting CSV files
• Data formatting tips and tricks
• Best practices: Before submitting a data formatting request
• Data Formatting Guide: The Basics
• Data Formatting Guide: Data Requirements
• Data Formatting Guide: Automate repetitive tasks in Excel Power Query
• Data Formatting Guide: Tools and Resources
• Data Formatting Guide: Consolidating Duplicate Trial Balance Accounts
• Data Formatting Guide: Excel Quick Reference
• Data Formatting Guide: Flipping signs for a range of accounts or based on condition(s)
• Data Formatting Guide: Looking up and Retrieving Data from Another File
• Data Formatting Guide: Simple degrouping of multiple columns, fill in blank account numbers (common QuickBooks example)
• Data Formatting Guide: Ungrouping and Checking Imbalance
• Data Formatting Guide: Ungroup and split account numbers and descriptions
• Converting dates into the appropriate format
• Convert negative credit values into positives
• Converting Debit and Credit Columns to Numbers in Excel
• Converting Text Files (delimited or fixed width) to Excel
• Convert character delimited text files to Excel format
• Extracting account and account description information in Excel
• Separating cell data in Excel
• The difference between a file that can be formatted and a file that can't
• Ungroup and split: Extract complex patterns