Getting Date error when upload Csv file

To fix CSV date errors, ensure your file's date format matches what you select in QuickBooks. Any mismatch or extra text will cause the upload to fail.

Here’s how to edit your CSV file:

1. Open the CSV file in Excel or Google Sheets.
2. Ensure every entry in the Date column uses the same format.
3. Remove any text from the dates. For example, change 20/11/2025 TUE to 20/11/2025.
4. Review the file, then Save it.

When reuploading the file, make sure the Date format dropdown in QuickBooks matches the date style used in your CSV.

For more details on CSV formatting and common upload errors, see these resources:
 

• Format CSV files in Excel to get bank transactions into QuickBooks.
• Common errors for importing bank transactions using CSV in QuickBooks Online.

Let us know how it goes. We're always here if you need further assistance.