BankStatementToExcel.com
Accounting imports

Troubleshoot a QuickBooks bank statement import

Check columns, date formats, amount signs, duplicate rows, and the destination account before retrying.

Updated 2 min read

Before uploading again, check whether the earlier attempt already added transactions. Keep the exact error message and work on a copy of your export. Repeatedly uploading the same period can make reconciliation harder.

Check the CSV columns

Intuit supports both a three-column CSV with Date, Description, and Amount, and a four-column layout with separate money-in and money-out fields. Follow the mapping prompts and verify their meaning in the preview.

Our general CSV includes a Balance column. Prepare a copy containing the required transaction fields instead of assuming that every exported column belongs in the import. See Intuit's CSV formatting instructions.

Check dates and numeric values

Use a consistent date format and select the matching interpretation in the import screen. A date such as 04/05 can be read in two ways. Compare an unambiguous date from the PDF before accepting the preview.

Keep amounts numeric and inspect currency symbols or separators if the import fails. Intuit's CSV troubleshooting page explains common formatting issues.

Check money in and money out

Compare a known withdrawal and a known deposit with the preview. Credit card purchases and payments can use different signs from a deposit account. Select the correct destination account rather than changing every sign to make the preview look plausible.

Check for overlapping transactions

Compare the statement period with existing bank feeds and previous manual uploads. Our generated QBO identifiers include row position, so changing the extracted rows or order can change the identifiers. QBO export is not a guarantee against duplicates.

Review candidate duplicates individually. Two payments with the same amount and date can still be separate, legitimate transactions.

Check account and file compatibility

A file can be structurally readable but unsuitable for a particular account or import route. Our QBO exporter currently identifies accounts as checking and uses a statement-level currency. If the destination needs different account details, use a bank-provided file or an appropriate CSV workflow.

If these checks do not resolve the error, consult QuickBooks support with the error text, file format, and product version. Avoid sending an unredacted statement unless the support channel requires it and you are authorised to share it.

Published . Updated October 7, 2026 to reflect the current converter and the provider guidance linked in this article.

Prepared with AI assistance and checked against the application's export formats. These are product instructions, not a substitute for checking your records. Tell us about a correction.

Ready to work with your statement?

Convert a PDF, then check the result with your original.

Open converter