I am trying to upload some Transections through CSV file but every time whn upload transections date change to 31/12/1969. What is the reason and how can it be fixed ?

Forum|Forum|4 months ago
February 22, 2026
1 reply
2 views

No text available

QuickBooks Online

KenoLee_P

QuickBooks Team

Hi there, Saleem. The reason your transactions may appear incorrect could be due to the date format used when recording them. It's important to ensure the format matches the standard expected by the system.

We recommend using the dd/mm/yyyy format. This format is widely used in many countries and helps prevent confusion.

Using a consistent format for all your transactions ensures 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 written in your records to confirm they follow this format.

However, if you use a different format, you can choose it in the Select a date format option to match the format on your transactions.

We also recommend uploading your bank data into QuickBooks Online using the Gear icon.

Here are the steps to upload bank data into QuickBooks Online:

Click on the Gear Icon.
Select Import Data.
Choose Bank Data.
Upload a CSV or QBO file containing your transactions.
Map the columns in the file (e.g., Date, Description, Amount).
Select the target account where the transactions should be imported.

This approach is great for importing past transactions or manually uploading data when bank feeds are not in use.

If you have any questions, feel free to reach out.

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded