cancel
Showing results for 
Search instead for 
Did you mean: 
djfabdan
Level 1

Loss of transaction data when importing to bank feeds

When I use Web Connect from my Wells Fargo bank accounts to import to QB Desktop, a lot of the transaction data is either trimmed or cut out entirely, making reconciling a time consuming process as I then need to refer to the original statement to decide what accounts the transaction goes to.

This is time consuming and aggrivating as it somewhat defeats the purpose of importing the information.

Furthermore, it wont let me copy and paste the missing data.

Am I missing something here?

Why are the fields being trimmed or eliminated?

Would importing it in comma delimited format include all the trimmed information?

Desktop 2020. 

10 Comments 10
GebelAlainaM
QuickBooks Team

Loss of transaction data when importing to bank feeds

I understand how important this issue to be resolved as soon as possible, @djfabdan. I'm here to help you get your issue resolved positively.

If there are more than the limited details to be imported, some of your transaction data may have been reduced or completely removed. Because the transaction data is too large or long to be imported, you are unable to copy and paste the missing data.

In QuickBooks Desktop each field for the data file has a maximum number of characters that can be entered and in this case, the payee and the memo fields are only limited to 32 characters. 

For more details about character limitations you can refer to this article: Character limitations for fields for QuickBooks


I'd recommend sending feedback to our Product Development team with regards to this matter. In order for them to enhance and give you the best QuickBooks experience. Your opinions with us will be highly appreciated.

Here's how:
 

  1. Go to the Help menu and then select Send Feedback Online.
  2. Choose Product Suggestion.
  3. Add the type of feedback.
  4. Type in your feature suggestion.
  5. Once done, click Send Feedback.

Then, you can visit our QuickBooks Online Feature Requests website to track the status of your submitted feedback.


However, if your transactions aren't more than the maximum character, it'll be great if you could provide some screenshot. This way, we can investigate further about this issue and provide you with a resolution that fits your situation.

I've also added this following articles to help you fix import issues and data damage in QuickBooks Desktop:
 

Keep me posted on how everything goes or if you need anything else. I'm just around. Take care!

BigRedConsulting
Community Champion

Loss of transaction data when importing to bank feeds

This may be happening because when using bank feeds, which uses OFX files, the payee and memo are limited to 32 characters. If the bank puts a bunch of junk before the payee name or pertinent parts of the memo, then there's not much room left for what you care about.

djfabdan
Level 1

Loss of transaction data when importing to bank feeds

Is there a workaround?

It's a terrible problem that, to me, doesn't make any sense.

The original bank statements have all the info I need to quickly decide exactly what the transaction was and where it needs to reconcile.

And the register where the transactions go certainly have ample space to hold all that data (if I type it in manually-but that defeats the purpose)

 

Fiat Lux - ASIA
Level 15

Loss of transaction data when importing to bank feeds

@djfabdan 

Does your bank provide other file formats for download? You can use the converter tool and import it as a QBO file

djfabdan
Level 1

Loss of transaction data when importing to bank feeds

ASCII, Web Connect Quicken and Web Connect QuickBooks are my 3 options.

djfabdan
Level 1

Loss of transaction data when importing to bank feeds

ASCII, web Connect Quicken and Web Connect Quick Books are my 3 options.

Fiat Lux - ASIA
Level 15

Loss of transaction data when importing to bank feeds

The converter tool only supports QIF, OFX, QFX, CSV, and PDF

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

 

Pearl189
Level 2

Loss of transaction data when importing to bank feeds

Can you download a .csv from your online banking? If so, you can upload the missing dates on your bank feed window.

 
djfabdan
Level 1

Loss of transaction data when importing to bank feeds

It can do CSV.

What's the process for getting the CSV into bank feeds?

All I've ever done is the Web Connect files, and only those a few times.

Snagelfly
Level 1

Loss of transaction data when importing to bank feeds

As a software architect, I can tell you that this problem is not acceptable.   It is not hard to update file length ingestion field lengths.  I don't see the point of having QuickBooks if we have to keep going back to the banking data.  What really is scary is that you don't know it's missing unless you do a full reconcile. You have to do a full reconcile anytime you want to use the tool. Good grief. That is totally unacceptable QB. 

 

I am currently missing May, June, July, August of 2021 and then for the months where there is some data there are random records missing. 32 Byte limits are not an excuse.  Fix it.  I have tried the updates everything.  No luck.

 

Need to get in touch?

Contact us