Nice to have you here in the Community, @blackrivers2018.
I'm happy to help you delete your imported transactions and upload the correctly formatted ones. You can remove the imported transactions by following these steps:
- Go to the Transactions or Banking tab and select all the transactions in the For Review tab.
- Press the Batch actions button, then pick Exclude Selected.
Now you're ready to fix the formatting of the CSV file and import your bank data. The steps below will show you how:
- Open the CSV file that you uploaded from your bank's website.
- Check the formatting of the record for the following:
- Date format: dd/mm/yyyy (no days of the week).
- Remove the word amount if it appears in the name of the Credit or Debit column.
- Correct any transactions that display a number in the Description column.
- Remove zeros from the file and leave those cells blank.
- MAC users must save the file as a Windows CSV file.
- Go to QuickBooks and click the gear icon.
- Choose Import data and pick Bank Data.
- Browse for your correctly formatted file and follow the onscreen steps to upload it.
After following these steps, your bank data will be uploaded to QuickBooks, and you can get back to business. You may also find this article about importing bank transactions helpful in the process.
Please don't hesitate to touch base with me here if you need any additional assistance. I look forward to hearing from you again.