Is there something wrong with how QBO is recognising date formats for bank T/A uploads? THey seem to be reversing EU and US dates so I cant upload from the latest date?

Hello there, Skelly27. QuickBooks Online (QBO) accepts various date formats for bank transactions. However, the uploaded file must match the date format you select during the upload and mapping process in QBO.

Before we proceed, did you encounter any error messages when you tried to upload the transactions? Any additional details will help us provide you with accurate assistance.

You can consider using the dd/mm/yyyy format. This format is widely used in many countries and helps prevent confusion.

Using a consistent date format for all transactions ensures that your records are accurate, easy to understand, and accessible for others or systems that may need to process them later. Please review how the dates are recorded in your files to confirm they follow this format.

Additionally, make sure that your Date, Description, and Amount fields are formatted correctly and align with QuickBooks requirements, as these issues are common reasons why the program rejects CSV file imports.

To learn more about the formatting in uploading a CSV file for bank transactions, please refer to this article: Format CSV files in Excel to get bank transactions into QuickBooks.

If you have questions, feel free to reply below. We’re here to help.