cancel
Showing results for 
Search instead for 
Did you mean: 
dylanh724
Level 3

CSV import is completely broken -- some rows randomly discarded in different stages!

There is nothing special about the first (1st) row:

 

hYguaLb

 

In fact, QBO detects it when assigning what each column does!

 

wppqIQv

 

QBO clearly sees it -- but here's the import preview:

 

ulT0fHh

Where did the 1st row go? It gets worse (note the dates being imported):

 avmk1fg 

Then where did the second (2nd) row go when actually imported?!

The first AND second row did NOT get imported!

 ^ Note that it's on the ALL tab filtered by date. You see the 9/25 (3rd row) one, but NOT the 1st and 2nd one. Absolutely broken.

 

Thanks, QBO. It skipped both the first and second row with two separate import bugs where both missing rows were actually initially detected fine at some stage of importing.

 

==============================================

Here is a bigger example:

zfqSAL5

Of this CSV imported, only FOUR were actually imported

 

==============================================

 

Import HSBC broken for both banks and cards, yet import is broken too. That's the only reason I had to use this dated, tedious process. I feel incredibly depressed with this product that I pay monthly for. Nope, I can't even leave to competitor because you ensured we couldn't.

 

Now that we've been told engineers "have been working on it" for months, suddenly it's tax season and I'm sunk deep in a hole, thanks to QBO. I can't auto import. I can't even manually import. I'm just completely abandoned by QBO.

Solved
Best answer January 22, 2019

Best Answers
Alessandra_B
QuickBooks Team

CSV import is completely broken -- some rows randomly discarded in different stages!

Hi @dylanh724.

 

In QuickBooks, the first transaction is considered as the header. You have the option to untick the box in the Map CSV column page  when uploading the transactions. This way, your first transaction will not be the header. 

 

See screenshot below for your visual reference.

 

 

For your second transaction, try checking your bank rules. The transaction may have automatically transferred In QuickBooks.

 

Here how to check if you have created rules In QuickBooks:

  1. On the left panel, click on Banking.
  2. Click the In QuickBooks tab.

Feel free to read this article for more information: How to Import Bank Transactions Using Excel CSV Files?

 

Please leave a comment below if you have other questions.

View solution in original post

2 Comments 2
Alessandra_B
QuickBooks Team

CSV import is completely broken -- some rows randomly discarded in different stages!

Hi @dylanh724.

 

In QuickBooks, the first transaction is considered as the header. You have the option to untick the box in the Map CSV column page  when uploading the transactions. This way, your first transaction will not be the header. 

 

See screenshot below for your visual reference.

 

 

For your second transaction, try checking your bank rules. The transaction may have automatically transferred In QuickBooks.

 

Here how to check if you have created rules In QuickBooks:

  1. On the left panel, click on Banking.
  2. Click the In QuickBooks tab.

Feel free to read this article for more information: How to Import Bank Transactions Using Excel CSV Files?

 

Please leave a comment below if you have other questions.

dylanh724
Level 3

CSV import is completely broken -- some rows randomly discarded in different stages!

Excellent! That was it. I'm surprised there's no automated detection for headers; it only takes seconds for a dev to test if the headers are all "strings" (labels). HSBC, for example, does not include headers. Capital One 360 does.

 

As for the rest of the transactions -- yep, it was buried by a rule! The "all" tab was only for review, and not the transactions already in QB. Great~

Need to get in touch?

Contact us