Upload CSV credit card transactions - inconsistent recognition of +/- by QB

Simon-PM · ‎December 15, 2022

Just getting to grips with QB... trying to upload manual CSV file of credit card transactions.

I prepared a test file of 5 items using the 3 column format (Date/Description/Amount) taking care to use negative values for spend and positive for card payments. My test uploaded perfectly.

I then uploaded 400 transactions from a similar file, all correctly signed +/-. For several transactions it worked fine, but for most transactions it has treated negative and positive values as "Received" items to be categorized - ie it thinks my spend income.
I can't see any difference between the parts of my CSV file, they all look correctly signed.

How do I now delete the entries that are wrong-way-round and then carefully upload the spend in smaller chunks??

Thank you

DivinaMercy_N · ‎December 15, 2022

Hello there, @Simon-PM. I'm here to ensure you'll be able to delete the incorrect data uploaded to your QuickBooks Online (QBO) account.

Thanks for posting here and sharing details of the steps you've performed. To help you with this, simply Exclude the transactions in the For Review tab and Delete them after. I'd be happy to guide you on how:

In your QBO account, navigate to the Banking menu.
Open the Banking page and select the bank account where the transactions are imported.
Next, check the box of the incorrect entries and select Exclude.
Then, go to the Excluded tab and select the boxes of the transactions again.
Click the Delete button to permanently remove them.

Once finished, reupload the transactions again. Make sure that the format is correct to avoid mistakes. For reference, check out this helpful guide: Manually upload transactions into QuickBooks Online.

That's it. You'll now be able to remove the incorrect entries.

When everything is fine, your next step is to categorize and match them to ensure they are allocated to the correct account. You can visit this page for the detailed instruction: Categorize and match online bank transactions in QuickBooks Online.

Please add a reply below if you have any other concerns about importing transactions in QBO. I'd be glad to help you further. Have a great day ahead and keep safe always.