Why does QuickBooks Online say "Select an account for this transaction" when I try to match imported transactions, and how do I fix it?

This error means QuickBooks couldn't read your imported transactions correctly because of how the columns were mapped, not because anything is wrong with your bank account itself. Cleaning up the file usually clears it.

Fix the column mapping

1. In your CSV file, delete any columns you don't need so there's less room for confusion. QuickBooks only needs Date, Description, and Amount (or Date, Description, Credit, and Debit if your bank splits amounts into two columns).
2. Rename your remaining columns to match the titles QuickBooks expects at the mapping stage.
3. Re-upload the file and go through the mapping stage again, matching each column carefully.

If the error continues, check your file's formatting

• Not all banks format CSV files the same way, so extra formatting can still cause problems even with correct column names.
• Keep the amounts column as simple as possible. Remove currency symbols and thousands-separator commas by selecting the column, right-clicking, and choosing Format Cells.
• If you're using a file with separate debit and credit columns but only have one type of transaction (for example, only money out) in that period, add a temporary line with an opposite-sign amount so the file imports, then uncheck that line on the final review screen before confirming the upload.
• Make sure you're not importing into a subaccount, which isn't supported for this kind of import.

Have any questions on how to map a certain account? Let us know below, or check out this article for more information on common errors for importing bank transactions using CSV.