DocTransform
All import guides

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 centre

    Last 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 centre

    Last 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 centre

    Last 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 centre

    Last 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 manually
  • Each line contains one transaction, so remove subtotal and balance rows.

    DocTransform fixes this: type

    Remove the rows where Description is Saldo or Zwischensumme

    Or 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

    QuickBooks help centre
  • 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 centre

    Last checked November 5, 2026

  • Don't upload transactions into a sub-account — QuickBooks doesn't support it yet.

    QuickBooks help centre
  • Amount, 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 centre

    Last 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 centre

Before and after

950 transactions

bank_statement_march.csv
DateDescriptionAmount
03.07.20261Office Rent #4521-1.200,002
04.07.2026Client Invoice Payment2.450,00
05.07.2026Saldo38.430,12
06.07.2026Zwischensumme4-4.980,50
07.07.2026Refund Order#77!506
08.07.2026Supplier Payment-350,00
09.07.2026Interest Credit12,40

    Fix it in DocTransform

    By hand: 14 stepsDocTransform: 2 sentences

    1. 1. Upload bank_statement_march.csv into DocTransform.
    2. 2. 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. Then type

      Delete the Saldo and Zwischensumme rows

      and press Send. Check the steps it adds; Undo takes them all back.
      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. 3. Download the cleaned file as CSV, ready for QuickBooks's importer.
    “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” then “Delete the Saldo and Zwischensumme rows” typed into DocTransform; both sentences applied in turn, five steps in all, two subtotal rows removed; Undo shown
    1. Type the change in one sentence, in your own words.
    2. Wait about 5 seconds while the steps are written. Stop cancels.
    3. Check each step and how many cells or rows it changes.
    4. 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

    1. 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.
    2. Delete every column except Date, Description and Amount (or Date, Description, Credit and Debit): right-click its header and choose Delete.
    3. Select the Saldo and Zwischensumme rows (05.07.2026 and 06.07.2026), right-click and choose Delete → Table Rows.
    4. If more than 1,000 transactions remain, delete every row past the first 1,000 and upload those in a second file.
    5. Select the Description column, press Ctrl+H and replace each special character, such as # and !, with nothing, one Replace All per character.
    6. With Description still selected, replace each digit from 0 to 9 with nothing the same way, so Office Rent #4521 becomes Office Rent.
    7. If Amount has currency symbols, select the Amount column, press Ctrl+H and replace € or $ with nothing.
    8. In D2 type =SUBSTITUTE(A2,".","/") and press Enter; Excel fills it down the table, so 03.07.2026 becomes 03/07/2026.
    9. In E2 type =TRIM(B2) and press Enter to strip the spaces left over in Description.
    10. In F2 type =NUMBERVALUE(C2,",",".") and press Enter, so -1.200,00 becomes -1200 and 12,40 becomes 12.4.
    11. Select D2:F6 (down to your last row), press Ctrl+C, right-click A2 and choose Paste Special → Values.
    12. Select columns D to F, right-click and choose Delete to remove the helper columns.
    13. Select the Amount column, press Ctrl+H, find 0, leave Replace with empty, tick Match entire cell contents under Options and click Replace All.
    14. 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.
    Try this sentence free

    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.