Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Solved! Go to Solution.
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:
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.
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:
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.
Thank you! I was able to select the incorrect records, Exclude them and then delete the records. I found the excel format the worked best was to separate the negative numbers into a second column then import the CSV file. Thank you for the quick response & assistance!
Hello again, dennis.ogawa.
Let me start by saying how much I appreciate your response regarding the incorrect credit card transactions in QuickBooks Online. I'm glad to know the steps above help you get back in track.
If you need some additional insights with adding, matching, or excluding transactions in the future, I'm adding the article I recommend on this:
Add and match downloaded banking transactions.
Thanks for dropping in and have a wonderful rest of your week. Please know I'm always available here anytime to help you with your QuickBooks needs.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here