cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
sg2goddard-comca
Level 1

I uploaded a spreadsheet from the bank, but a column got corrupted and all future lines were in error. How do I delete these entries?

I added the erroneous transactions to "excluded", but will that remove them from my transactions?
1 Comment 1
MichaelaS
QuickBooks Team

I uploaded a spreadsheet from the bank, but a column got corrupted and all future lines were in error. How do I delete these entries?

When you exclude transactions, those entries are only removed from the For Review tab and excluded from the calculation of totals, reports, and budgets in the financial software. However, the transactions remain for record-keeping purposes and are flagged as excluded, sg2goddard.

 

If you prefer to delete the entries totally, here's how to do it:

 

  1. After you transfer the transaction to the Excluded tab.
  2. Check mark those entries.
  3. Then, click Delete.


Once done, please proceed to re-upload the file and ensure that the spreadsheet columns match the QuickBooks format. You can refer to this article for detailed guidance: Format CSV files in Excel to get bank transactions.

 

Please leave us a response if you have other questions or need further assistance.