Import files – MindBridge: English (US)
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
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