Skip to main content
F
FirstCityH
July 6, 2022
Question

Manual Transaction Import Error

  • July 6, 2022
  • 2 replies
  • 0 views

Due to the ongoing issues with Vystar, I tried to manually upload my bank transactions. I downloaded the transactions from Vystar, which came out looking correct. But when I uploaded them into Quickbooks, it seems Quickbooks randomly reassigned positive and negative signs to transaction amounts. I can't fix them in Quickbooks and now my books are so far off and I don't know how to fix it. 

2 replies

Fiat Lux - ASIA
Fiat Lux - ASIA
July 7, 2022

What kind of file format does your bank provide? *.csv, *.qbo or olse?

F
FirstCityHAuthor
July 8, 2022

.csv

Fiat Lux - ASIA
Fiat Lux - ASIA
July 8, 2022

@FirstCityH 

Utilize MT Online or csv2qbo converter.

https://www.moneythumb.com/?ref=110

 

C
ChristineJoieR
July 7, 2022

Hi, @FirstCityH.

 

I recognize the error was quite frustrating. I'm here to share details on importing transactions in QuickBooks Online.

 

Before you can upload it, make sure that the information is in the proper format.

 

In the mapping stage, double-check that you selected the correct columns. Otherwise, QuickBooks will be unable to read the data. You can make the mapping stage easier in this article: Format CSV files.

 

Since not all banks create CSV files in the same way, you may need to make additional changes to get your transactions in. Here are some things to keep an eye out for:

 

  • Currency symbols and commas.
  • Special characters.
  • Date and amount format.

 

You may utilize this article for your reference: Common errors for importing bank transactions using CSV.

 

In addition, I've added these articles that help you organize your transaction in QuickBooks Online:

 

 

Feel free to mention me if you need more clarification about the topic. I'm also available if you need assistance on how to run reports in QuickBooks. Have a good one.

Terms & ConditionsAccessibility statement