[All import guides](/en/import)

# QuickBooks won't import your bank transactions file?

Fix the file QuickBooks rejects when importing a bank transactions CSV, then import clean every week.

## Fix it in a supported AI chat

Check your file against QuickBooks rules in a supported AI chat, fix the safe problems with one button and download it clean.

*   Checking is free
*   Fixing uses one export
*   Your file is not kept, and the fixed file’s link works for 30 minutes

[See which assistants](/en/connect-your-agent)

## 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](/en/tools/check-quickbooks-bank-transactions-csv) does both in the copy you download.
    
    QuickBooks doesn't say what happens
    
    [QuickBooks help centre](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US)
    
    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](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US)
    
    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](https://quickbooks.intuit.com/learn-support/en-us/banking/import-bank-transactions-using-excel-csv-files/00/239741)
    
    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](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US)
    
    Last checked November 5, 2026
    
*   Numbers and special characters in the Description column can block the import.
    
    [QuickBooks help centre: preparing a CSV file](https://quickbooks.intuit.com/learn-support/en-us/banking/import-bank-transactions-using-excel-csv-files/00/239741)[QuickBooks help centre: uploading transactions manually](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US)
*   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](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US)
*   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](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US)
    
    Last checked November 5, 2026
    
*   Don't upload transactions into a sub-account — QuickBooks doesn't support it yet.
    
    [QuickBooks help centre](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/common-errors-importing-bank-transactions-using/L02IgW462_US_en_US)
*   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](https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-transactions/fix-bank-upload-errors-quickbooks-online/L6FBh3zDC_US_en_US)
    
    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](https://quickbooks.intuit.com/learn-support/en-uk/banking/csv-error-some-info-may-be-missing-from-your-file/00/1057800)

## Before and after

950 transactions

bank\_statement\_march.csv

BeforeAfter

Date Description Amount

03.07.20261 Office Rent #4521 \-1.200,002

04.07.2026 Client Invoice Payment 2.450,00

05.07.2026 Saldo3 8.430,12

06.07.2026 Zwischensumme4 \-4.980,50

07.07.2026 Refund Order#77!5 06

08.07.2026 Supplier Payment \-350,00

09.07.2026 Interest Credit 12,40

Before

## 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](/guide-shots/quickbooks/en/flow-desktop-poster.webp)

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.

## Moving to another system

*   [QuickBooks to Xero: map the columns, import the bank CSV](/en/import/xero/from-quickbooks)

## Free tools for this file

*   [Check your bank transactions CSV before you upload it to QuickBooks Online](/en/tools/check-quickbooks-bank-transactions-csv)
*   [Change the date format in Excel or CSV](/en/tools/change-date-format)

[Try this sentence free](/en/signup?plan=free&guide=quickbooks)

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.
