Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
January 10, 2020
Question

Uploaded a CSV with appx 120 transactions, labeled income incorectly, now shows as expenses, how can I cancel an entore csv upload?

  • January 10, 2020
  • 1 reply
  • 4 views
No text available

1 reply

Angelyn_T
Moderator
January 10, 2020

Thank you for reaching us here on the Community page, @843764.

 

You can exclude those transactions and re-upload them using the correct CSV file format.

 

To exclude the incorrectly labeled transactions from QuickBooks:

 

  1. Select Banking from the left pane.
  2. On the Banking page, select your bank account.
  3. Go to the For Review column.
  4. Check the box beside the transactions you want to exclude.
  5. Click on the drop-down arrow beside Batch actions, then tap on Exclude Selected.

Once completed, the excluded transactions will now show up under the Excluded column. If you wish to fully delete them, go to the Excluded column, check the boxes beside Date, click on the drop-down arrow under Batch actions, then hit Delete.

 

Then, re-import the file. Before doing the process, be sure to use the correct format of your transactions. If you'll be using the 3 columns template, be sure to enter the correct amount for payments (negative) and deposits.

 

On the other hand, if you'll be using the 4-columns template, enter the correct debits and credits.

 

To achieve the process correctly, you can check this article as your guide: Import bank transactions using Excel CSV files.

 

Let me know if you have any other QuickBooks or banking questions. I'm always here to help. Have a great day!