QuickBooks won't import your bank transactions file?

What QuickBooks's importer checks

• Your file needs Date, Description and Amount columns, or Date, Description, Credit and Debit — no others. QuickBooks help centre

  DocTransform fixes this: type "keep only the Date, Description and Amount columns"

• Every date must use the same format; QuickBooks recommends dd/mm/yyyy. QuickBooks help centre

  DocTransform fixes this: type "format Date as DD/MM/YYYY"

• Amounts must be plain numbers, with no currency symbol or thousands comma. QuickBooks help centre

  DocTransform fixes this: type "clean currency in the Amount column"

• A cell that's exactly zero should be left blank, not written as 0. QuickBooks help centre

  DocTransform fixes this: type "blank out Amount cells that are exactly 0"

• Numbers and special characters in the Description column can block the import. QuickBooks help centre

  DocTransform fixes this: type "remove numbers and special characters from the Description column"

• Remove subtotal and balance rows before uploading — QuickBooks reads every row as a transaction. QuickBooks help centre

  DocTransform fixes this: type "remove rows where Description contains Saldo or Zwischensumme"

• Your file must be in English and 350 KB or less, up to 1,000 transactions per upload. QuickBooks help centre
• Don't upload transactions into a sub-account — QuickBooks doesn't support it yet. QuickBooks help centre

Before and after

950 transactions

Fix it by hand in Excel or Sheets

1. Delete every column except Date, Description and Amount (or Date, Description, Credit and Debit) by hand.
2. Rewrite every date by hand as dd/mm/yyyy.
3. Remove currency symbols and thousands separators from Amount by hand, e.g. turn -1.200,00 into -1200.00.
4. Clear any cell that's exactly 0 instead of leaving a zero.
5. Delete every Saldo or Zwischensumme subtotal row, and any row past the first 1,000 transactions.
6. Remove numbers and special characters from Description by hand.

Fix it in DocTransform

1. 1. Upload bank_statement_march.csv into DocTransform.
2. 2. Apply the fixes: type "format Date as DD/MM/YYYY", "clean currency in the Amount column", "blank out Amount cells that are exactly 0", and "remove rows where Description contains Saldo or Zwischensumme".
3. 3. Download the cleaned file as CSV, ready for QuickBooks's importer.

Save this fix once, then rerun it on next week’s export with one click.

Questions

Does DocTransform split my file if it's over QuickBooks's 1,000-transaction limit?

No — DocTransform doesn't split files. If your file has more than 1,000 transactions, split it by hand before uploading.

Will DocTransform know if a transaction belongs to a sub-account?

No — that's account-side information DocTransform doesn't have. Check it in QuickBooks before uploading.

Can I reuse this fix next time I export bank transactions?

Yes — save it once in DocTransform and rerun it on next week’s export.