Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
November 13, 2025
Question

bank transaction import brought wrong dates

  • November 13, 2025
  • 1 reply
  • 0 views

bank transactions file import worked but date on each row shows 01/01/1970

1 reply

QuickBooks Team
November 13, 2025

Hi Judy,

 

When importing a bank file into QuickBooks Online (QBO), the application relies on data provided by your bank. Before importing, let's verify the transaction dates and their format so they align with QuickBooks’ column requirements.

 

To correct this, we can either exclude the recent import, fix the dates in the file, and reimport it, or enable the editable dates option in bank feeds and update the dates manually for each transaction.

 

You can follow these steps to exclude transactions:

 

  1. Go to My apps and select Accounting.
  2. Click Bank transactions.
  3. In the Pending tab, select the transactions you want to remove.
  4. At the bottom, click the Exclude button.

 

If you prefer to edit dates manually in your bank feeds, follow these steps to make the date field editable:

 

  1. In the bank transactions, click the Gear icon.
  2. Check Make date field editable under Other preferences.
  3. Start correcting the transaction dates one at a time.

 

Feel free to reply to this thread if you require additional help managing bank transactions. The Community is always here to help.