Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
JanyRoseB
QuickBooks Team

Reply to message

Hi there, kencor.

 

Thanks for getting back to us. I'm here to help and provide some additional information about importing bank transaction in QuickBooks Online (QBO). 

 

QuickBooks Online can import CSV files that use either a 3-column or 4-column format. In this case, you'll need to use the 4-column template which has a Date, a Description, and both a Credit and a Debit column. This way, you can categorize the transactions in the right columns. 

 

But before doing so, you'll need to exclude those imported transactions that were categorized in the incorrect column on the banking page. Here's how: 

  1. On the left navigation tab, select Banking.
  2. In the For Review tab, put a check mark on the transactions you want to exclude.
  3. Select Batch actions drop-down arrow.
  4. Click Exclude selected. 

Once done, you can now start importing bank transactions using CSV files with the 4-columns template. You may also check this article for your additional reference: How to import bank transactions using Excel CSV files.

 

If the issue still persists, I encourage you to contact our QuickBooks Online Support Team. They have additional tools to pull up your account and do a remote session so they can investigate this further. 

 

You can contact our support through this link: Get help with QuickBooks Online.

 

If you have other questions about importing bank transactions please let me know by clicking the Reply button below. I'm always here to help you out. 

Need to get in touch?

Contact us