Questions? We have answers.

Search

Best practices for formatting CSV files

Best practices for formatting CSV files

Data formatting tips and tricks

Data formatting tips and tricks

Best practices: Before submitting a data formatting request

Best practices: Before submitting a data formatting request

Data Formatting Guide: The Basics

Data Formatting Guide: The Basics

Data Formatting Guide: Data Requirements

Data Formatting Guide: Data Requirements

Data Formatting Guide: Automate repetitive tasks in Excel Power Query

Data Formatting Guide: Automate repetitive tasks in Excel Power Query

Data Formatting Guide: Tools and Resources

Data Formatting Guide: Tools and Resources

Data Formatting Guide: Consolidating Duplicate Trial Balance Accounts

Data Formatting Guide: Consolidating Duplicate Trial Balance Accounts

Data Formatting Guide: Excel Quick Reference

Data Formatting Guide: Excel Quick Reference

Data Formatting Guide: Flipping signs for a range of accounts or based on condition(s)

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: 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: Simple degrouping of multiple columns, fill in blank account numbers (common QuickBooks example)

Data Formatting Guide: Ungrouping and Checking Imbalance

Data Formatting Guide: Ungrouping and Checking Imbalance

Data Formatting Guide: Ungroup and split account numbers and descriptions

Data Formatting Guide: Ungroup and split account numbers and descriptions

Converting dates into the appropriate format

Converting dates into the appropriate format

Convert negative credit values into positives

Convert negative credit values into positives

Converting Debit and Credit Columns to Numbers in Excel

Converting Debit and Credit Columns to Numbers in Excel

Converting Text Files (delimited or fixed width) to Excel

Converting Text Files (delimited or fixed width) to Excel

Convert character delimited text files to Excel format

Convert character delimited text files to Excel format

Extracting account and account description information in Excel

Extracting account and account description information in Excel

Separating cell data in Excel

Separating cell data in Excel

The difference between a file that can be formatted and a file that can't

The difference between a file that can be formatted and a file that can't

Ungroup and split: Extract complex patterns

Ungroup and split: Extract complex patterns

GDPdU Files

Formatting GDPdU: Zero Opening Balance Entries for Revenue and Expenses Accounts

Formatting GDPdU: Zero Opening Balance Entries for Revenue and Expenses Accounts

Formatting GDPdU: Running a Pre-Analysis Completeness Check

Formatting GDPdU: Running a Pre-Analysis Completeness Check

Formatting GDPdU: Identifying and Resolving Flip Accounts in the Trial Balance

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 and Removing Opening Balance Entries in the General Ledger

Formatting GDPdU: Identifying D & K / Sub Ledger Accounts

Formatting GDPdU: Identifying D & K / Sub Ledger Accounts

Formatting GDPdU: How do GDPdU Files Work?

Formatting GDPdU: How do GDPdU Files Work?

Formatting GDPdU: Data Checklist

Formatting GDPdU: Data Checklist

Data validation

Data Validation: Abnormally large cells

Data Validation: Abnormally large cells

Data Validation: Special characters that must be escaped

Data Validation: Special characters that must be escaped

Data Validation: Consistent number of columns

Data Validation: Consistent number of columns

Data validation: Date formats

Data validation: Date formats

Data Validation: Why a general ledger must contain at least one numeric column

Data Validation: Why a general ledger must contain at least one numeric column