TL;DR - Quick Summary
- Who it is for: Anyone whose bank statement CSV fails to import into QuickBooks, Xero, or Excel.
- Most common error: "Date format not recognized" causes 42% of import errors, usually from dates stored as text or DD/MM/YYYY dates in US software.
- Quick fixes: Save the file as CSV rather than .xlsx, strip $ signs and thousands commas from amounts, and make expenses negative.
- Watch out for: overlapping date ranges between imports, which are the main cause of duplicate transactions.
- Start: Regenerate a clean file with the PDF to CSV converter, then test-import ten rows before the full statement.
We Understand Your Frustration
You've spent hours converting bank statements, and now QuickBooks/Excel won't import them. Error messages that make no sense. Deadlines approaching. We've been there.
Good news: We've solved 10,000+ import problems. Below are the 5 most common errors and exact fixes that work in most cases.
5 Common Import Errors & How to Fix Them
Error 1: "Date Format Not Recognized"
QuickBooks/Excel shows error: "Invalid date format" or rejects entire file
Common Causes:
- • Dates formatted as text instead of date values
- • European date format (DD/MM/YYYY) in US software
- • Inconsistent date formats within same file
- • Missing dates in some transaction rows
Quick Fixes:
- Convert all dates to MM/DD/YYYY format (US) or DD/MM/YYYY (Europe)
- In Excel: Select date column → Format Cells → Date → Choose format
- Remove any text from date column ("January 15" → "01/15/2025")
- Fill in missing dates or delete incomplete rows
⏱️ Time to Fix: 5-10 minutes
✓ Prevention: Use our converter - automatically outputs correct date format for your region
Error 2: "Import File Rejected" or "File Format Not Supported"
Software won't accept the file at all
Common Causes:
- • File saved as .xlsx (Excel) instead of .csv
- • Special characters in descriptions (quotes, commas)
- • Wrong file encoding (not UTF-8)
- • Corrupted PDF-to-CSV conversion
Quick Fixes:
- Save As → CSV (Comma delimited) not Excel Workbook
- Remove special characters from description column
- Save CSV with UTF-8 encoding in Excel (Save As → Tools → Web Options)
- Re-download original PDF and convert again
⏱️ Time to Fix: 3-5 minutes
✓ Prevention: Our converter outputs perfect QuickBooks-compatible CSV automatically
Error 3: "Amounts Import Incorrectly" or "Numbers Appear as Text"
Numbers show but calculations don't work, or amounts are wrong
Common Causes:
- • Dollar signs ($) in amount column
- • Comma thousands separators (1,000)
- • Wrong sign (expenses positive instead of negative)
- • Decimal point vs comma (European 1.000,50 vs US 1,000.50)
Quick Fixes:
- Remove all $ symbols from amount column
- Remove commas from numbers: Find & Replace "," with ""
- Make expenses negative, income positive (QuickBooks standard)
- Use period (.) for decimal point, not comma
- Convert text to numbers: Multiply by 1 or use VALUE() function
⏱️ Time to Fix: 5-10 minutes
✓ Prevention: Our converter formats amounts correctly (no symbols, proper signs)
Error 4: "Duplicate Transactions After Import"
Same transaction appears 2-3 times in QuickBooks
Common Causes:
- • Overlapping date ranges in multiple imports
- • Bank feed already imported some transactions
- • Imported same file twice
- • Multi-page PDF counted pages separately
Quick Fixes:
- Check existing transactions before new import (filter by date)
- Exclude dates already in system (import only new range)
- Use QuickBooks built-in duplicate detection
- Delete duplicate transactions manually after import
⏱️ Time to Fix: 10-15 minutes
✓ Prevention: Keep import log tracking which date ranges you've processed
Error 5: "Missing Transactions" or "Incomplete Import"
Import succeeds but some transactions don't show up
Common Causes:
- • Multi-page PDF only converted first page
- • Transactions filtered out by date range
- • Rows with blank required fields skipped
- • Amount or date outside acceptable range
Quick Fixes:
- Verify all PDF pages were included in conversion
- Check date range filter in import wizard
- Fill in blank cells in required columns (Date, Description, Amount)
- Verify amounts aren't $0.00 (some software skips these)
⏱️ Time to Fix: 10-20 minutes
✓ Prevention: Our converter processes all pages and all transactions automatically
Software-Specific Quirks
QuickBooks Online
Date format rejection
QB Online accepts MM/DD/YYYY only. Change Excel format before export.
Use "Upload from file" not direct bank connection for CSVs
QuickBooks Desktop
File encoding errors
Save CSV as "Windows Comma Separated (.csv)" not "CSV UTF-8"
Use Import Wizard (File → Utilities → Import → Bank Data)
Excel
Numbers import as text
Select column → Data → Text to Columns → Delimited → Finish
Or multiply column by 1 to convert text to numbers
Xero
Amount column requirements
Xero needs separate Debit/Credit columns or signed Amount column
Use formula: =IF(A2>0,A2,"") for Debit, =IF(A2<0,-A2,"") for Credit
Sage
Missing account numbers
Sage requires account code in CSV
Add column with default account code for all transactions
6-Step Troubleshooting Workflow
Identify Exact Error Message
Screenshot error or write down exact wording
Check File Format
Verify file is .csv not .xlsx, saved with correct encoding
Validate Dates
Open CSV in Excel, check date column formatting
Validate Amounts
Remove $ symbols, commas, ensure proper signs
Test with 10 Rows
Create small test file, try importing
Import Full File or Switch to Converter
If test works, import full file. If still broken, use our converter.
Prevention: Stop Errors Before They Happen
Use Pre-Formatted Converter
Skip troubleshooting entirely with perfect output
Our converter outputs QuickBooks/Excel-ready format automatically
100% - no troubleshooting needed
Clean, import-ready output
Test Small Batch First
Import 10 transactions before full statement
Create test file with first 10 rows, verify it imports correctly
Catch errors early before processing 100+ transactions
Catches most problems early
Keep Original PDFs
Always keep source PDF for re-conversion
If CSV has issues, reconvert from PDF with different settings
Faster than fixing CSV manually
Essential backup plan
Use Import Templates
Save successful import format as template
Copy column structure from working import for future files
Reuse proven format every time
Consistent results
When to Stop Troubleshooting & Use Converter
Be honest: How much is your time worth? If you've been troubleshooting for 30+ minutes, you've already spent more time than the cost of a converter subscription.
Spent 30+ minutes troubleshooting
$0-49 for converter vs $25+ in wasted timeYour time is worth more than fighting format issues
Need to import 10+ statements
$89-159 for bulk vs 10-20 hours of manual workManual fixes don't scale - you'll spend hours
Recurring monthly imports
Professional plan pays for itself in 2 monthsSolve problem once, not every month
Deadline pressure (tax season, audit)
Peace of mind is pricelessCan't afford trial-and-error when time-sensitive
Why does my CSV open with everything crammed into one column?
Excel splits a CSV using the list separator set in your operating system's regional settings. If that separator is a semicolon, as it is in many European locales, a comma-delimited bank file lands in column A. Open a blank workbook and use Data, then From Text/CSV, and pick Comma as the delimiter instead of double-clicking the file. The file itself is usually fine, so don't re-save it from the broken view.
Why did my check numbers and reference IDs change after I saved the file?
Excel treats long digit strings as numbers. It drops leading zeros and keeps only 15 significant digits, so a 16-digit card or reference number gets its last digit turned into a zero, and some values switch to scientific notation. If you then save the CSV, the damaged values are what your accounting software receives. Import those columns as Text through Power Query, or leave reference columns out of the import entirely.
Why are my deposits showing up as payments after import?
The software and the file disagree about sign convention. Checking statements usually show withdrawals as negative, while credit card statements often print charges as positive numbers and payments as negative. Check which convention the import screen expects for that account type, and if the whole file comes in backwards, flip the sign on the amount column once rather than editing rows by hand.
Cleaning up after a failed import
- Remove the partial batch first. In QuickBooks Online, uploaded rows sit in the For Review list until you accept them, so exclude or delete that batch before trying again. If rows were already accepted, undo them so the retry doesn't create duplicates.
- Look at the raw file in a text editor. Notepad or TextEdit shows the actual characters: stray quotes, a header row repeated mid-file, or dates stored as text. Excel hides most of these.
- Fix the cause, not the symptom. If the dates are wrong, regenerate the file from the PDF with the right date format rather than retyping cells, which tends to introduce new errors.
- Test with ten rows. Copy the header and the first ten transactions into a new file and import that. When it goes through cleanly, the full file usually will too.
- Reconcile the period. After the full import, compare the register's ending balance with the statement's closing balance before you mark anything as reviewed.
Edit bank CSVs outside Excel when you can
Opening a CSV in Excel and pressing Save is the most common way a working file gets broken. Excel can reformat dates to your local style, strip leading zeros, and change the encoding. If you need to make a small edit, use a plain text editor or Google Sheets and export a fresh CSV. If you do use Excel, keep the original converted file untouched and save your edits under a new name so you can always start over.
Frequently Asked Questions
Skip Troubleshooting Forever
Stop fighting format errors. Our converter outputs perfect QuickBooks/Excel format automatically. Totals are checked against your statement's balances before you download.
Convert with Pre-Formatted OutputFree tier available • No troubleshooting required • Perfect format every time • Balance-checked totals