cancel
Showing results for 
Search instead for 
Did you mean: 
blackrivers2018
Level 1

I manually imported my bank data into Quickbooks Online. All the transactions came in as deposits. How can I fix this? Or how can I delete the transactions and re import?

 
1 Comment 1
Anna S
QuickBooks Team

I manually imported my bank data into Quickbooks Online. All the transactions came in as deposits. How can I fix this? Or how can I delete the transactions and re import?

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:

 

  1. Go to the Transactions or Banking tab and select all the transactions in the For Review tab. 
  2. 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:

 

  1. Open the CSV file that you uploaded from your bank's website.
  2. 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.
  3. Go to QuickBooks and click the gear icon.
  4. Choose Import data and pick Bank Data.
  5. 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.

Need to get in touch?

Contact us