# Questions? We have answers.

## Data checklists

- [Data checklist: General ledger (For-profit and not-for-profit without fund)](https://support.mindbridge.ai/hc/en-us/articles/360055739954-Data-checklist-General-ledger-For-profit-and-not-for-profit-without-fund)
- [Data checklist: General ledger (Not-for-profit with fund)](https://support.mindbridge.ai/hc/en-us/articles/360059005354-Data-checklist-General-ledger-Not-for-profit-with-fund)
- [Data checklist: Accounts payable](https://support.mindbridge.ai/hc/en-us/articles/360058268993-Data-checklist-Accounts-payable)
- [Data checklist: Accounts receivable](https://support.mindbridge.ai/hc/en-us/articles/360058268973-Data-checklist-Accounts-receivable)
- [Data checklist: Opening and closing balances](https://support.mindbridge.ai/hc/en-us/articles/360056329374-Data-checklist-Opening-and-closing-balances)
- [Data Checklist: SAP requirements for accounts payable analysis](https://support.mindbridge.ai/hc/en-us/articles/4407193991703-Data-Checklist-SAP-requirements-for-accounts-payable-analysis)
- [Data Checklist: SAP requirements for accounts receivable analysis](https://support.mindbridge.ai/hc/en-us/articles/4407181047191-Data-Checklist-SAP-requirements-for-accounts-receivable-analysis)

## Data requirements

- [Data Validation: Overview](https://support.mindbridge.ai/hc/en-us/articles/4404280793879-Data-Validation-Overview)
- [How to prepare your Intacct account to function as a data import source in MindBridge](https://support.mindbridge.ai/hc/en-us/articles/360056524614-How-to-prepare-your-Intacct-account-to-function-as-a-data-import-source-in-MindBridge)
- [Find and apply a client's transaction ID](https://support.mindbridge.ai/hc/en-us/articles/360056395634-Find-and-apply-a-client-s-transaction-ID)

## Imports for GL analysis

- [Import a chart of accounts or an account list](https://support.mindbridge.ai/hc/en-us/articles/360058011873-Import-a-chart-of-accounts-or-an-account-list)
- [Import a general ledger (full or interim)](https://support.mindbridge.ai/hc/en-us/articles/360057583173-Import-a-general-ledger-full-or-interim)
- [Import a general ledger (periodic)](https://support.mindbridge.ai/hc/en-us/articles/19209152735639-Import-a-general-ledger-periodic)
- [Import additional data](https://support.mindbridge.ai/hc/en-us/articles/360058269813-Import-additional-data)
- [Import adjustments, reclassifications, and eliminations](https://support.mindbridge.ai/hc/en-us/articles/360059917334-Import-adjustments-reclassifications-and-eliminations)
- [Import opening and closing balances](https://support.mindbridge.ai/hc/en-us/articles/360058012333-Import-opening-and-closing-balances)

## Imports for AP analysis

- [Import a vendor list](https://support.mindbridge.ai/hc/en-us/articles/360058269013-Import-a-vendor-list)
- [Import an AP detail file](https://support.mindbridge.ai/hc/en-us/articles/360056394974-Import-an-AP-detail-file)
- [Import vendor opening balances](https://support.mindbridge.ai/hc/en-us/articles/360058269033-Import-vendor-opening-balances)
- [Import vendor/customer opening balances or an end of period outstanding payables/receivables list](https://support.mindbridge.ai/hc/en-us/articles/360056457194-Import-vendor-customer-opening-balances-or-an-end-of-period-outstanding-payables-receivables-list)

## Imports for AR analysis

- [Import a customer list](https://support.mindbridge.ai/hc/en-us/articles/360056395114-Import-a-customer-list)
- [Import a start or end of period outstanding receivables list](https://support.mindbridge.ai/hc/en-us/articles/360056457294-Import-a-start-or-end-of-period-outstanding-receivables-list)
- [Import an AR detail file](https://support.mindbridge.ai/hc/en-us/articles/360056395034-Import-an-AR-detail-file)
- [Import customer opening balances](https://support.mindbridge.ai/hc/en-us/articles/360056395134-Import-customer-opening-balances)

## File manager

- [File manager: Overview](https://support.mindbridge.ai/hc/en-us/articles/360056457214-File-manager-Overview)
- [Split sheets out from a file](https://support.mindbridge.ai/hc/en-us/articles/4410791683351-Split-sheets-out-from-a-file)
- [Merge multiple files onto one sheet](https://support.mindbridge.ai/hc/en-us/articles/4410728102423-Merge-multiple-files-onto-one-sheet)

## Formatting data

- [Formatting GDPdU: Zero Opening Balance Entries for Revenue and Expenses Accounts](https://support.mindbridge.ai/hc/en-us/articles/17141119229079-Formatting-GDPdU-Zero-Opening-Balance-Entries-for-Revenue-and-Expenses-Accounts)
- [Formatting GDPdU: Running a Pre-Analysis Completeness Check](https://support.mindbridge.ai/hc/en-us/articles/16972200699415-Formatting-GDPdU-Running-a-Pre-Analysis-Completeness-Check)
- [Formatting GDPdU: Identifying and Resolving Flip Accounts in the Trial Balance](https://support.mindbridge.ai/hc/en-us/articles/16744737330071-Formatting-GDPdU-Identifying-and-Resolving-Flip-Accounts-in-the-Trial-Balance)
- [Formatting GDPdU: Identifying and Removing Opening Balance Entries in the General Ledger](https://support.mindbridge.ai/hc/en-us/articles/16744334787351-Formatting-GDPdU-Identifying-and-Removing-Opening-Balance-Entries-in-the-General-Ledger)
- [Formatting GDPdU: Identifying D & K / Sub Ledger Accounts](https://support.mindbridge.ai/hc/en-us/articles/16638783169943-Formatting-GDPdU-Identifying-D-K-Sub-Ledger-Accounts)
- [Formatting GDPdU: How do GDPdU Files Work?](https://support.mindbridge.ai/hc/en-us/articles/16638376071831-Formatting-GDPdU-How-do-GDPdU-Files-Work)
- [Formatting GDPdU: Data Checklist](https://support.mindbridge.ai/hc/en-us/articles/15436750846359-Formatting-GDPdU-Data-Checklist)

## Data validation

- [Data Validation: Abnormally large cells](https://support.mindbridge.ai/hc/en-us/articles/4403614264855-Data-Validation-Abnormally-large-cells)
- [Data Validation: Special characters that must be escaped](https://support.mindbridge.ai/hc/en-us/articles/4403614226839-Data-Validation-Special-characters-that-must-be-escaped)
- [Data Validation: Consistent number of columns](https://support.mindbridge.ai/hc/en-us/articles/4403627680663-Data-Validation-Consistent-number-of-columns)
- [Data validation: Date formats](https://support.mindbridge.ai/hc/en-us/articles/4403515913495-Data-validation-Date-formats)
- [Data Validation: Why a general ledger must contain at least one numeric column](https://support.mindbridge.ai/hc/en-us/articles/4403506872471-Data-Validation-Why-a-general-ledger-must-contain-at-least-one-numeric-column)

## Other articles

- [Best practices for formatting CSV files](https://support.mindbridge.ai/hc/en-us/articles/21079552648855-Best-practices-for-formatting-CSV-files)
- [Data formatting tips and tricks](https://support.mindbridge.ai/hc/en-us/articles/360058191873-Data-formatting-tips-and-tricks)
- [Best practices: Before submitting a data formatting request](https://support.mindbridge.ai/hc/en-us/articles/1500011252782-Best-practices-Before-submitting-a-data-formatting-request)
- [Data Formatting Guide: The Basics](https://support.mindbridge.ai/hc/en-us/articles/1500007438162-Data-Formatting-Guide-The-Basics)
- [Data Formatting Guide: Data Requirements](https://support.mindbridge.ai/hc/en-us/articles/1500007417741-Data-Formatting-Guide-Data-Requirements)
- [Data Formatting Guide: Automate repetitive tasks in Excel Power Query](https://support.mindbridge.ai/hc/en-us/articles/6316571770007-Data-Formatting-Guide-Automate-repetitive-tasks-in-Excel-Power-Query)
- [Data Formatting Guide: Tools and Resources](https://support.mindbridge.ai/hc/en-us/articles/1500007411522-Data-Formatting-Guide-Tools-and-Resources)
- [Data Formatting Guide: Consolidating Duplicate Trial Balance Accounts](https://support.mindbridge.ai/hc/en-us/articles/1500007439741-Data-Formatting-Guide-Consolidating-Duplicate-Trial-Balance-Accounts)
- [Data Formatting Guide: Excel Quick Reference](https://support.mindbridge.ai/hc/en-us/articles/1500008298641-Data-Formatting-Guide-Excel-Quick-Reference)
- [Data Formatting Guide: Flipping signs for a range of accounts or based on condition(s)](https://support.mindbridge.ai/hc/en-us/articles/1500008308421-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](https://support.mindbridge.ai/hc/en-us/articles/1500008310321-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)](https://support.mindbridge.ai/hc/en-us/articles/4407673272471-Data-Formatting-Guide-Simple-degrouping-of-multiple-columns-fill-in-blank-account-numbers-common-QuickBooks-example)
- [Data Formatting Guide: Ungrouping and Checking Imbalance](https://support.mindbridge.ai/hc/en-us/articles/1500008295681-Data-Formatting-Guide-Ungrouping-and-Checking-Imbalance)
- [Data Formatting Guide: Ungroup and split account numbers and descriptions](https://support.mindbridge.ai/hc/en-us/articles/1500008138042-Data-Formatting-Guide-Ungroup-and-split-account-numbers-and-descriptions)
- [Converting dates into the appropriate format](https://support.mindbridge.ai/hc/en-us/articles/360056329514-Converting-dates-into-the-appropriate-format)
- [Convert negative credit values into positives](https://support.mindbridge.ai/hc/en-us/articles/360058191933-Convert-negative-credit-values-into-positives)
- [Converting Debit and Credit Columns to Numbers in Excel](https://support.mindbridge.ai/hc/en-us/articles/360058191913-Converting-Debit-and-Credit-Columns-to-Numbers-in-Excel)
- [Converting Text Files (delimited or fixed width) to Excel](https://support.mindbridge.ai/hc/en-us/articles/1500009844861-Converting-Text-Files-delimited-or-fixed-width-to-Excel)
- [Convert character delimited text files to Excel format](https://support.mindbridge.ai/hc/en-us/articles/4419776540055-Convert-character-delimited-text-files-to-Excel-format)
- [Extracting account and account description information in Excel](https://support.mindbridge.ai/hc/en-us/articles/360056329534-Extracting-account-and-account-description-information-in-Excel)
- [Separating cell data in Excel](https://support.mindbridge.ai/hc/en-us/articles/360056329554-Separating-cell-data-in-Excel)
- [The difference between a file that can be formatted and a file that can't](https://support.mindbridge.ai/hc/en-us/articles/1500009458421-The-difference-between-a-file-that-can-be-formatted-and-a-file-that-can-t)
- [Ungroup and split: Extract complex patterns](https://support.mindbridge.ai/hc/en-us/articles/1500008146382-Ungroup-and-split-Extract-complex-patterns)