QBO keeps recognizing expenses as income in uploaded bank .csv

WyrtWicce · ‎December 08, 2021

Greetings. I have a recurring issue in QuickBooks Online. I am trying to upload a .csv file to a Bank account. This account is a prepaid debit card, and everything on the .csv file is an expense. The values are negative in the .csv file. Upon uploading, QBO insists on putting every transaction in the Received column instead of Spent, meaning it is automatically categorizing them as income, despite the imported values being negative. I have tried adding a column to the .csv file that reverses all values, in case there is a glitch similar to what happens with PayPal files. But upon importing, those are all in the Received column as well. No fix I can possibly think of will convince QBO that these are expenses. Help, please.

ChristineJoieR · ‎December 08, 2021

Hello there, @WyrtWicce.

Thank you for choosing QuickBooks Online.

I can share insight about importing files to QBO if you're using a credit card account. Transactions may appear in reverse in CSV files for credit card accounts.

Choose a credit card account when uploading this type of file. This ensures that the transactions import correctly.

I added this article if you may want to know common errors in importing CSV files.

Additionally, have this article to fix bank upload errors in QuickBooks Online.

After downloading the bank transaction successfully, you can categorize and match them. Here’s how:

1. Go to the Banking section and select Banking.

2. Under For Review, tick the box for the account you want to categorize.
3.Once done, all the categorized items will reflect in the reconciling items.

Furthermore, learn how to match bank transactions in QuickBooks Online.

If you need more assistance about uploading a file, just hit reply. I am willing to help you always. Take care.

WyrtWicce · ‎December 16, 2021

Thank you for taking the time for a detailed reply.

It did not touch upon or solve my actual issue, but I found a solution on my own.

There were possible formatting issues in the original .csv file. Even after changing the formatting of the Amount column from red text to showing negative number, QBO did not recognize them as negative numbers.

So, being that the file was not overly large I created a new file from scratch and manually copied each transaction over. Finally, that did the trick. Still do not know why QBO had such an issue with the original, but this will not be a palatable fix for future identical issues.