Skip to main content
August 26, 2022
Question

I just uploaded a CSV file from my bank into QB. All the entries are showing up as "Deposit" even though they should not be categorized as anything.

  • August 26, 2022
  • 1 reply
  • 0 views
In the Bank Register, they are all showing as Deposit under the Ref No/Type column.

1 reply

Tori B
August 26, 2022

Happy Friday, @krollahanhomes

 

Are you looking forward to the weekend? I hope your day is going great so far. 

 

Before we begin, I wanted to ask if you could share a screenshot with me? This way, I can take a look at how these transactions are being imported. 

 

Typically we see imported transactions automatically categorized as deposits because the amounts fall under the Received column. Therefore, they are considered an income transaction, then converted to deposits. If this is the case for you,  all you'll need to do is undo those transactions you've added, then delete them from the Banking page. Simply go to the Categorized tab, and click the Undo button. You can also check the transactions to undo them in batch. 

 

Next, format your expenses properly on your CSV or Excel file. Make sure to code the expenses under Debit or put a negative sign on the amount. That way, the system will recognize them as expenses.

 

If you need help with the formatting, feel free to check this article: Format CSV files in Excel to get bank transactions into QuickBooks.

 

Then you can finally re-import your CSV file with the correct format. 

 

Shoot me a reply below if you have any questions or concerns. I'm always happy to help. Take care!