cancel
Showing results for 
Search instead for 
Did you mean: 

Reply to message

View discussion in a popup

Replying to:
AlcaeusF
Moderator

Reply to message

Hello dennis.ogawa,

 

Thank you for dropping by here in the Community. I'd be glad to help you with your concern about the Credit Card transactions in QuickBooks Online.

 

When importing bank transactions using the WebConnect feature, the data downloaded will depend on the file coming from your bank. QuickBooks Online currently supports the 3 or 4 columns format only.

 

To ensure you'll get the results you need, please make sure you have the correct CSV template format. You can do this by opening the file manually and checking if there amounts in negative figures.

 

I'm linking an article with additional information on this, such as using Excel CSV files:
 

How to import bank transactions using Excel CSV files.

 

For downloaded transactions that aren't correct, you can use the Exclude feature and delete it from there. In case you need the steps, here's how:

 

  1. On the left panel, click Banking.
  2. Go to the Banking tab.
  3. Choose your bank account.
  4. Go to the For Review tab.
  5. Put a check mark on the transactions you want to exclude.
  6. Click the drop-down arrow next to For Review.
  7. Click Exclude Selected.
  8. Go to the Excluded tab.
  9. Put a check mark on the transactions.
  10. Click the Batch actions drop-down to delete.

For your visual reference, see the screenshot below:

 

 

I look forward to serving you to the best of my ability. If you need more help with your bank transactions, please know the Community has your back.

View solution in original post

Need to get in touch?

Contact us