cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
Nitin Rosemary Harrow
Level 1

Imported a credit card statement. But all the spend items are showing as received in Quickbooks How do I fix this

I uploaded my business credit card transactions using the CSV format correctly, I think. However all the items are showing as received rather than spend. 
Can I completely delete the transactions and Credit card and start again?
 
1 REPLY 1
CamelleT
QuickBooks Team

Imported a credit card statement. But all the spend items are showing as received in Quickbooks How do I fix this

Yes, we can exclude, delete, and then manually reimport the transactions to QuickBooks Online (QBO), Nitin.

 

To fix the issue where all your credit card data are showing as received instead of spent after uploading them using the CSV file, ensure that the CSV file format is correct and the amounts are formatted appropriately. (negative numbers for charges and positive numbers for credits) Then, let's exclude and delete the incorrect transactions. Please refer to the steps below:

 

  1. Go to Transactions and choose Bank Transactions.
  2. Locate and select the appropriate bank account.
  3. Click the For Review tab and tick the box beside the DATE column/ the boxes of the imported transactions.
  4. Tap Exclude.

 

Once done, go to the excluded tab to delete them. Here's how:

 

  1. Select the Excluded tab.
  2. Tick the boxes of all the transactions you need to delete.
  3. Hit Delete.

 

After doing so, you can import them again with the correct format. Check out this link for the detailed steps: Manually upload transactions into QuickBooks Online.

 

I'll share this article to help you make and send invoices: Create invoices in QuickBooks Online.

 

Post a comment below if you have additional questions about importing credit card transactions in QBO. We're always here to help.

Need to get in touch?

Contact us