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 seeWhat to inspectSafe correction
Date column rejectedWeekday words, blanks, mixed separators or an impossible dateReturn to the source and normalise the date text
Day and month exchangedCSV text versus import date-format selectionSelect the matching format and check a known transaction
Dates look fine in Excel but failThe saved CSV, not just Excel's displayed cell formatReopen the saved file in a text viewer and inspect the values
Rows appear in the wrong yearMissing years or spreadsheet inferenceUse 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

  1. Keep an untouched bank export or PDF and note the statement date range.
  2. 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.
  3. Remove day-of-week text. Intuit describes using Excel's Text to Columns with a space delimiter when the bank appends weekday text.
  4. Give every transaction a complete date in the same convention. Do not fill a missing date by guessing.
  5. 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

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.