Troubleshooting

Fix the CSV problems QuickBooks flags most often.

Most CSV import failures come from a small set of format and sign issues. Check the source rows before trying a different file.

Check the header

For the 3-column format use Date, Description, Amount. For the 4-column format use Date, Description, Credit, Debit. Remove extra words from Credit and Debit headers.

Remove zeros from empty sides

When a row has a credit, leave debit blank. When it has a debit, leave credit blank. Do not fill both columns with zero values unless the target workflow explicitly accepts them.

Use one date convention

Do not mix US and international date formats. Confirm values such as 01/02/2026 before export because they can represent different calendar dates.

Check account direction

Credit card exports can use a different sign convention from checking accounts. Select the actual account type and review the summary before download.