QuickBooks won't import your bank transactions file?
Fix the file QuickBooks rejects when importing a bank transactions CSV, then import clean every week.
What QuickBooks's importer checks
Your file needs Date, Description and Amount columns, or Date, Description, Credit and Debit — no others.
DocTransform fixes this: open the column’s ⋯ menu → Edit column… → click the name at the top of the drawer, rename it to the QuickBooks header (Date, Description, Amount, Credit or Debit) and press Enter, then remove the columns QuickBooks doesn't list; in the app, the button Fix the columns QuickBooks reads does both in one step, and the checker does both in the copy you download.
QuickBooks doesn't say what happens
QuickBooks help centreLast checked November 5, 2026
Date – Every date must use the same format; QuickBooks recommends dd/mm/yyyy.
DocTransform fixes this: type
Write Date as DD/MM/YYYY
Or by hand
open the Date column’s ⋯ menu → Format dates… → input DD.MM.YYYY, output DD/MM/YYYY (31/12/2024) → Save Rule
QuickBooks doesn't say what happens
QuickBooks help centreLast checked November 5, 2026
Amount, Credit and Debit – Amounts must be plain numbers, with no currency symbol or thousands comma.
DocTransform fixes this: type
Write Amount as plain numbers, with no currency symbol or thousands separator, and leave the cells that are exactly 0 blank
Or by hand
open Health → Amounts not written as plain numbers → Rewrite 6 values, which writes each amount as a plain number; -1.200,00 becomes -1200
QuickBooks doesn't say what happens
QuickBooks help centreLast checked November 5, 2026
Amount, Credit and Debit – A cell that's exactly zero should be left blank, not written as 0.
DocTransform fixes this: type
Leave the cells in Amount that are exactly 0 blank and write the rest as plain numbers, with no currency symbol or thousands separator
Or by hand
open the Amount column’s ⋯ menu → Find & replace…, find 0, leave Replace with empty, Match entire cell → Replace all; only cells that are exactly zero are cleared
QuickBooks doesn't say what happens
QuickBooks help centreLast checked November 5, 2026
Numbers and special characters in the Description column can block the import.
QuickBooks help centre: preparing a CSV fileQuickBooks help centre: uploading transactions manuallyEach line contains one transaction, so remove subtotal and balance rows.
DocTransform fixes this: type
Remove the rows where Description is Saldo or Zwischensumme
QuickBooks help centreOr by hand
select the Saldo and Zwischensumme rows and right-click → Delete 2 rows, by hand, each time: DocTransform saves no step for this way
Your file must be in English and 350 KB or less, up to 1,000 transactions per upload.
QuickBooks doesn't say what happens
QuickBooks help centreLast checked November 5, 2026
Don't upload transactions into a sub-account — QuickBooks doesn't support it yet.
QuickBooks help centreAmount, Credit and Debit – QuickBooks refuses the file with "The uploaded file contains invalid transaction amount information." when an amount has 12 or more digits.
QuickBooks refuses the file
QuickBooks help centreLast checked November 5, 2026
Errors QuickBooks shows
QuickBooks says info is missing from your file
Some info may be missing from your file. Double-check that your file is complete and try uploading again.
Intuit doesn't publish this as an error string — it's the wording users report seeing when a bank-transaction upload fails.
QuickBooks help centreBefore and after
950 transactions
Fix it in DocTransform
By hand: 14 stepsDocTransform: 2 sentences
- 1. Upload bank_statement_march.csv into DocTransform.
- 2. Type and press Send. Then type
Write Date as DD/MM/YYYY, remove the currency symbols and thousands separators from Amount and clear the cells in Amount that are exactly 0
and press Send. Check the steps it adds; Undo takes them all back.Delete the Saldo and Zwischensumme rows
Or by hand
Apply the fixes: on Date: ⋯ → Format dates… (input DD.MM.YYYY, output DD/MM/YYYY) → Save Rule; Health → Amounts not written as plain numbers → Rewrite 6 values, then Find & replace… 0 with nothing (Match entire cell) on Amount. Then select the Saldo and Zwischensumme rows and right-click → Delete 2 rows, by hand, each time. Remove the numbers and special characters from Description by hand: DocTransform saves no step for it.
- 3. Download the cleaned file as CSV, ready for QuickBooks's importer.

- Type the change in one sentence, in your own words.
- Wait about 5 seconds while the steps are written. Stop cancels.
- Check each step and how many cells or rows it changes.
- The file is clean. Not what you meant? One Undo takes it all back.
Save this fix once, then rerun it on next week’s export with one click.
Fix it by hand in Excel or Sheets
- In a blank workbook, choose Data → From Text/CSV, pick bank_statement_march.csv, set Data Type Detection to Do not detect data types and click Load.
- Delete every column except Date, Description and Amount (or Date, Description, Credit and Debit): right-click its header and choose Delete.
- Select the Saldo and Zwischensumme rows (05.07.2026 and 06.07.2026), right-click and choose Delete → Table Rows.
- If more than 1,000 transactions remain, delete every row past the first 1,000 and upload those in a second file.
- Select the Description column, press Ctrl+H and replace each special character, such as # and !, with nothing, one Replace All per character.
- With Description still selected, replace each digit from 0 to 9 with nothing the same way, so Office Rent #4521 becomes Office Rent.
- If Amount has currency symbols, select the Amount column, press Ctrl+H and replace € or $ with nothing.
- In D2 type =SUBSTITUTE(A2,".","/") and press Enter; Excel fills it down the table, so 03.07.2026 becomes 03/07/2026.
- In E2 type =TRIM(B2) and press Enter to strip the spaces left over in Description.
- In F2 type =NUMBERVALUE(C2,",",".") and press Enter, so -1.200,00 becomes -1200 and 12,40 becomes 12.4.
- Select D2:F6 (down to your last row), press Ctrl+C, right-click A2 and choose Paste Special → Values.
- Select columns D to F, right-click and choose Delete to remove the helper columns.
- Select the Amount column, press Ctrl+H, find 0, leave Replace with empty, tick Match entire cell contents under Options and click Replace All.
- Choose File → Save As, pick CSV UTF-8 (Comma delimited) as the file type and click Save.
Questions
- Does DocTransform split my file if it's over QuickBooks's 1,000-transaction limit?
- Yes, by rows. In Export Studio choose Split into files → By number of rows… and set 1,000 rows per file: you download one .zip and upload the files one at a time.
- 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.
Moving to another system
Free plan, no card required.
Salesforce, HubSpot, Shopify, QuickBooks, Mailchimp, Pipedrive, WooCommerce, Klaviyo, Google Contacts, ActiveCampaign, Brevo, Zendesk, Square, Zoho CRM, and Xero are trademarks of their owners. DocTransform is not affiliated with them.