Fix common QuickBooks CSV import errors.

For 3 columns, use Date, Description, Amount. For 4 columns, use Date, Description, Credit, Debit. Remove extra header rows, totals, footnotes, and blank columns.

In a 4-column file, a transaction normally has either Credit or Debit. Do not populate both sides, and remove zeroes from the unused cell if the upload workflow rejects them.

Confirm whether 01/02/2026 means January 2 or February 1. Use one date convention throughout the file and correct impossible dates before export.

A bank account usually represents deposits as positive and payments as negative in a signed Amount column. Credit-card exports can use different wording, so verify known transactions instead of trusting the header alone.

Currency symbols, thousands separators, formulas, merged cells, and styled report headings can interfere with a bank-transaction table. Export plain values and keep one transaction per row.

This page covers CSV uploads. A Web Connect error for a .qbo file has different causes. See the QBO structure guide, the CSV to QBO troubleshooting guide, and Intuit's Web Connect troubleshooting.

Reproduce the problem with invented dates, descriptions, and amounts. Then use the QuickBooks CSV formatter to confirm mapping and row-level errors without exposing a real statement.

• Do not rename an unrelated file to .csv.
• Do not reverse every amount without checking the account type.
• Do not upload the same statement period repeatedly.
• Do not send a real bank file to support.