cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here

Reply to message

View discussion in a popup

Replying to:
RoseJillB
QuickBooks Team

Reply to message

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.