Home › Guides › Fix QuickBooks CSV Date Format Errors Before Importing
Fix QuickBooks CSV Date Format Errors Before Importing
To fix a QuickBooks CSV date error, make every transaction date use one format, remove weekday text and choose that same format during column mapping. Intuit recommends DD/MM/YYYY. Check a date with a day above 12 in the preview so that a swapped day and month cannot pass unnoticed.
Updated November 6, 2026
First separate a rejected date from a misread date
A file that will not upload and a file that imports October 11 as November 10 are different problems. The first may contain invalid date text. The second may be a valid date interpreted with the wrong locale. Do not keep importing the same full file to experiment: an accepted upload can create duplicate work.
| What you see | What to inspect | Safe correction |
|---|---|---|
| Date column rejected | Weekday words, blanks, mixed separators or an impossible date | Return to the source and normalise the date text |
| Day and month exchanged | CSV text versus import date-format selection | Select the matching format and check a known transaction |
| Dates look fine in Excel but fail | The saved CSV, not just Excel's displayed cell format | Reopen the saved file in a text viewer and inspect the values |
| Rows appear in the wrong year | Missing years or spreadsheet inference | Use the statement's actual year and a four-digit year |
Work through one concrete example
Suppose a bank exports 15/10/2026 THU. The transaction date is October 15, not a string containing a weekday. In a working copy, remove THU and save 15/10/2026. Keep DD/MM/YYYY for every other transaction in the file, then select that format in the import screen.
A row containing 04/05/2026 cannot establish the intended convention on its own. It could be April 5 or May 4. Check the original statement, a nearby date above 12 and the statement period. Never resolve ambiguity just by choosing whichever interpretation the software accepts.
Normalise the source in a working copy
- Keep an untouched bank export or PDF and note the statement date range.
- Identify the bank's date convention before allowing a spreadsheet to interpret the cells. A changed display format cannot repair a date already parsed incorrectly.
- Remove day-of-week text. Intuit describes using Excel's Text to Columns with a space delimiter when the bank appends weekday text.
- Give every transaction a complete date in the same convention. Do not fill a missing date by guessing.
- Save as CSV, then inspect the saved date strings. Formatting a workbook cell is not enough if the exported text differs.
Confirm the import mapping
In QuickBooks Online, open Bank transactions and Upload from file, choose the correct account and map the date field. Choose the format the file actually contains. If the interface does not offer your chosen format, re-export the working copy to a format it does offer rather than assuming ISO or your computer's locale will be accepted.
Check a payment dated on the 15th or later and another near a month boundary. Also compare the first and last dates with the statement period. Cancel the preview if the dates are wrong. If you already imported the file, inspect the existing lines before another upload and consult Intuit's current correction workflow or your bookkeeper; do not delete reconciled entries simply to start again.
When a date fix does not solve the upload
Check the rest of the bank CSV: three or four transaction columns, no statement total rows, clear amount signs, and Intuit's 350 KB and 1,000-line limits. A date error and an amount-layout problem can exist together. If only a PDF is available, choose the export date format deliberately after reviewing the extracted transactions.
From a PDF to reviewed transaction data
Starting from PDF? Convert the statement to CSV, choose a date format, and verify the exported date text before uploading.
Open the converter → · Plans and limits · How balance checks work
Conversion runs in your browser; statement files are not uploaded to CSVLedger. A balance check helps identify extraction issues, but does not replace review or accounting reconciliation.
Frequently asked questions
What date format does Intuit recommend?
Intuit recommends DD/MM/YYYY in its bank CSV formatting guidance. The date-format selection during import must match the file.
Does changing Excel to Short Date fix a wrongly parsed date?
Not necessarily. Changing the display cannot recover the intended day and month if the spreadsheet has already interpreted them incorrectly. Check the original source.
Should I remove weekday names?
Yes. Intuit recommends removing weekday text added to the Date column, such as TUE after a numeric date.
Related guides
- QuickBooks Online CSV Format: 3 Columns vs 4 Columns
- QuickBooks Online bank statement CSV template (sample files)
- QuickBooks Online Bank Upload Errors: A File Checklist
- Import Old Bank Transactions into QuickBooks Online Beyond 90 Days
Sources and scope
Based on official help documentation reviewed through search results on November 6, 2026. Menus, regional availability and product requirements can change; use the current official instructions if your screen differs. Examples are fictional. These instructions are documentation-based, not a claim of a completed live import test.