Format Profiles — CSV Column Mapping

Overview

Format profiles tell Acclo IQ how to read your bank’s CSV exports — which columns are the date, amount, description, and so on. Acclo IQ ships with built-in profiles for major banks, and you can create custom profiles for any bank.

Built-in Profiles

Acclo IQ currently ships 18 built-in CSV format profiles:

Institution	Profile	Format
Chase	Chase Credit Card	Header CSV
Wells Fargo	Wells Fargo	Header CSV
Synchrony	Lowe's Credit (Synchrony)	Header CSV
Fidelity	Fidelity Cash Management	Header CSV; handles bank preamble rows
Bank of America	Bank of America Checking	Header CSV; handles bank preamble rows
Bank of America	Bank of America Credit Card	Header CSV
Citibank	Citibank Checking	Header CSV; separate debit/credit columns
Citibank	Citibank Credit Card	Header CSV; separate debit/credit columns
Capital One	Capital One 360 Checking	Header CSV
Capital One	Capital One Credit Card	Header CSV; separate debit/credit columns
American Express	American Express	Header CSV; inverts amount sign
Discover	Discover Credit Card	Header CSV
USAA	USAA Checking	Header CSV
USAA	USAA Credit Card	Header CSV; inverts amount sign
PNC Bank	PNC Bank Checking	Header CSV; separate debit/credit columns
TD Bank	TD Bank Checking	Header CSV; separate debit/credit columns
US Bank	US Bank Checking	Header CSV
Ally Bank	Ally Bank	Header CSV

Built-in profiles cannot be edited or deleted. If your bank isn’t listed, create a custom profile.

Viewing Format Profiles

Go to Settings > Format Profiles to see all profiles. The table shows:

Column	Description
Profile	Name, institution, and whether it’s built-in
Mode	Header (reads column names) or Positional (reads by column index)
Date Col	Which column contains the transaction date
Amount Col	Which column contains the amount
Desc Col	Which column contains the description
Accounts	How many accounts use this profile

Creating a Custom Profile

Custom profiles are created during CSV import when no existing profile matches:

1. Go to the Import page and select your account
2. Click Create a new format profile
3. Upload a sample CSV file — the app auto-detects columns, date format, and encoding
4. Review the column mapping and assign roles to each column:
   • Date — the transaction date column (required)
   • Amount — the transaction amount column (required)
   • Description — the transaction description (required)
   • Memo — optional additional text
   • Skip — ignore this column
5. Configure profile settings:
   • Profile Name — a descriptive name (defaults to your account name + “CSV”)
   • Date Format — MM/DD/YYYY, YYYY-MM-DD, MM/DD/YY, or MM-DD-YYYY
   • Amount Sign — “As-Is” (negative = charge) or “Invert” (positive = charge)
6. Click Create Profile

The profile is saved and immediately available for future imports.

Deleting a Profile

Custom profiles can be deleted from Settings > Format Profiles if no accounts currently use them. The delete button is disabled for profiles with linked accounts.

Tips

• Most banks use “As-Is” amount sign (negative = money out)
• If your amounts appear reversed after import, edit the profile and change the amount sign to “Invert”

Related Guides

• CSV Import — use format profiles during the import process
• Supported Banks — full list of built-in bank profiles