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

Booking Credit Card Charges from a Web Connect File (QBO) with Vendor Info

Hi,

 

I am using QuickBooks Desktop Pro 2018 (for Desktop on Windows). 

 

I have followed all instructions to import Credit Card transactions from Chase Bank by searching the transactions on Chase dot com, downloading them in Web Connect (QBO) format, then opening my Company File, going to File > Utilities > Import > Web Connect Files. I select the file full of Credit Card transactions that I want to book and they are imported into the Bank Feeds Center ?Transaction List. No problem. 

 

However - there is a problem when I start booking these transactions to a certain account. I select the account from the drop down menu in the account column (no problem) and I either go to far right column under Action and select Quick Add from drop down menu OR I do a few transactions of selecting correct accounts and then navigate to Batch Actions for Add/Approve on all the transactions I have selected. 

 

This all works no problem - either way.

 

HOWEVER - when you go into the Credit Card register from the Chart of Accounts and you can see all the credit card charges, Quickbooks does NOT save the vendor information from the import. So, I can see all the charges and to what accounts they are booked to but I cannot see what vendor, payee, memo, or any other info besides date, amount, and account. 

 

Is there a way for Quickbooks to retain the vendor or Downloaded As info from the Transaction List screen? Otherwise I just have amounts and accounts and no other info.

 

Thanks

6 Comments 6
FritzF
Moderator

Booking Credit Card Charges from a Web Connect File (QBO) with Vendor Info

Welcome to the Community, @MattPixiu19.

 

When importing credit card transactions or Web Connect (.QBO) files from your bank's website to QuickBooks Desktop (QBDT), the vendor, payee, memo, or any other info should be included as well. Since they're not added in the Transaction List screen, let's perform some troubleshooting steps to help isolate this.

 

To start, try to run the QuickBooks built-in diagnostic and repair tools called rebuild and verify data utilities. These tools will repair and notify you of any possible data damage within the file.

 

 

Here's how:

 

  1. Go to File, then select Utilities and Rebuild Data.
  2. Choose OK. Follow the prompts to save a backup.
  3. Click OK once completed.
  4. Now, go back to File, then Utilities, and select Verify Data this time.

21.PNG

 

If QB detected no problem with your data, hit OK and double-check if the date is already correct. However, if it finds an issue, you will be prompted to Rebuild Now or View Errors. Choose Close, then perform the steps below. Here's how:

 

  1. Locate and check the QBWin.log or QuickBooks.log files.
  2. Scroll to the bottom for the most recent Verify information.
  3. Find the line that contains the LVL_ERROR, then check Top data damage errors in QuickBooks Desktop.

 
For more information about the process, consider checking out this article: Resolve data damage on your company file.

 

I'm also adding these articles for future reference:

 

 

Reach out to me in the comment section if you have any other issues or concerns. I want to make sure everything is taken care of for you. Have a wonderful day!

MattPixiu19
Level 1

Booking Credit Card Charges from a Web Connect File (QBO) with Vendor Info

Thank you very much @FritzF 

 

I followed the steps you recommended for Rebuilding Data and Verifying Data. No errors were found.

 

However, there still is no vendor or memo information displayed in the Register of the Credit Card account. But to be clear - vendor and memo information IS DISPLAYED in the transaction list of the Bank Feeds Center. But after I "Add" those transactions from the Transactions list then NO vendor or memo information is displayed in the register. 

 

The problem takes place when I am selecting accounts to book charges to in the Transaction List and i have successfully "added" or "booked" a transaction. Then going to the credit card charge register by double clicking the credit card account from the Chart of Accounts - none of that information is carried over from the Transaction List window. This does not seem like an error but maybe a design characteristic. In the transaction list window.. the vendor info or memo info is listed as "Downloaded As" but does not really "live" in a "vendor" or "memo" field. You can see this when: from the Transaction List window in Bank Feeds Center you navigate to the far right column "Action"  and in the drop down menu, select "Add More Details." The info is not listed in any of the fields but in text that is not editable. You would have to come to this field and enter all the information again rather than being able to do it from the Transaction List screen. 

 

 

GrouseHiker
Level 1

Booking Credit Card Charges from a Web Connect File (QBO) with Vendor Info

I am experiencing the same problem. In my case, the "downloaded as" field on a Lowes credit card is the information for each item purchased - which I want to keep as a memo.

JasroV
QuickBooks Team

Booking Credit Card Charges from a Web Connect File (QBO) with Vendor Info

Hi there, @GrouseHiker.

 

I appreciate you for sharing the details of your concern. Just for clarification though, were you able to perform the troubleshooting steps provided by my colleague @FritzF above?

 

If not, I recommend doing so. However, if you had, then the issue persists. I recommend contacting our support team. They have the tools to check your account securely and further investigate this matter. Here's how to contact them.

 

In your QuickBooks Desktop (QBDT):

  1. Go to the Help menu.
  2. Select QuickBooks Desktop Help.
  3. Click Contact Us.
  4. Enter the keyword of your concern and click Continue.
  5. Choose your preferred way to get in touch with them.

I've also added this article that can help you fix beginning balance in your QBDT: Fix beginning balance issues in QuickBooks Desktop.

 

You can always leave a comment below if you have other concerns about uploading bank transactions in your QBDT. We're always here ready to help. Take care and more power to your business!
kgallo
Level 1

Booking Credit Card Charges from a Web Connect File (QBO) with Vendor Info

Were you ever able to figure this out?  I am experiencing the exact same situation unfortunately. If you figured it out, would you please share as I'm sure there are others too!  Thank you! 

AileneA
QuickBooks Team

Booking Credit Card Charges from a Web Connect File (QBO) with Vendor Info

This is not the kind of service we want you to experience, kgallo. As of this moment, you can try performing the Verify rebuild utility tools. Verify Data self-identifies the most commonly known data issues within a company file while Rebuild Data self-resolves most data integrity issues that the Verify Data finds. 

 

You can follow my colleague's steps above on how to run the verify rebuild tools in QuickBooks. 

  

To learn more about the verify rebuild feature, you can refer to this article: Verify and Rebuild Data in QuickBooks Desktop

 

If the same thing happens, I recommend reaching out to our customer support team. This way, we'll be able to pull up your account in a secure session and look over the underlying issue and help you get back to business in no time.  

 

Keep me posted in the comments down below if you have any other questions. I'll be happy to help. Have a great day!

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us