PNC Bank Transaction Download - still unable to connect to download transactions for almost a month now. Message keeps saying try again. Anyone else seeing this issue?

Thanks for posting in the Community page, @PlayaRoundGolf.

Recently, we found an issue with the connection between your financial institution and QuickBooks. Our engineers already investigated the cause of this unexpected behavior. This is the main reason why you’re unable to connect and can’t upload any transactions.

In the meantime, let’s do the manual process on how to upload transactions into QuickBooks Online. I’ll show you how:

1. Go to Banking.
2. Click the drop-down button beside Update.
3. Select File upload.
4. Click Browse, then select the file to upload.
5. Hit Upload transaction.

These articles will help you know the whole process in uploading transactions:

• Manually upload transactions into QuickBooks Online
• Import web connect (QBO) files

Please let me know if you need anything else. I’ll be around to help. Have a good one!

Thank you. Yes, I've been doing this each week for almost a month and with 7 checking accounts, it's getting frustrating. Downloaded credit card charges posted as CC-Credits. Not sure why this happened this way. I looked at the file and since there was only one amount, I set the parameters to 1 amount field. Suggestions as how to download credit card charges?

Hi there, PlayaRoundGolf,

Great job for manually importing transactions to QuickBooks. This is the workaround while our Online Banking Team and your financial institution are working together to fix the error on your bank feeds.

Allow me to step in and provide the solution on how to download credit card charges posted as credits.

QuickBooks lets you import credit card charges from your bank. What you need to do is download them using Excel .CSV file. Then, use either a 3-column or 4-column format.

The 3-column format lets you enter a negative amount for the credit. While 4-column has both a credit and debit field. Here's an article that provides screenshots for your guidance: Import bank transactions using Excel CSV files. 

After that, you can then import credit card transactions. To do so, please follow the steps outlined below:

1. Go to Banking from the left navigation bar.
2. Click the drop-down arrow beside Update, then select File upload.
3. Click Browse to attach the downloaded CSV file, then click Next.
4. From the QuickBooks Account drop-down list, select the credit card account, then click Next.
5. Map fields according to your CSV format, then click Next.
6. Click Yes when prompted to import now.
7. Click Let's go once ready to import them.

Once done, start categorizing those entries on the For Review tab. Feel free to read through this article: Assign, categorize, edit, and add your downloaded banking transactions for more details.

Keep me posted if you need additional information and I'll get back to you.

This workaround is not acceptable.  I've been dealing with this on and off for 2 months.  

Even when manually importing records - occasionally the system will randomly download transactions through the  bank connection.  This creates duplicates and a reconciliation nightmare.

In the last 2 weeks, I've spent more time dealing with this than is worth this product.

Please provide a solid resolution time frame asap.

Hi there, @PlayaRoundGolf . 

Thanks for getting back and sharing the steps you’ve taken so far.  

Since you've already tried all the recommended troubleshooting steps above. I recommend contacting our QuickBooks Care Support further investigation and check the cause of this bank transaction issue.  

Here’s how you can reach us:  

1. Select Help (?) at the right top. 
2. Click Contact Us to connect with a live support agent. 
3. Enter a brief discussion of your concern, then click Let’s talk. 
4. Choose a way to connect with us through. 
• Get a callback 
• Start a chat 

I appreciate your patience. Please let me know if you need anything else about bank transaction. 

I am also having this issue with several client's books, have reported the issue yet it persists. Oddly though, it is not on ALL PNC accounts- some accounts are connected just fine

Hello, @droth1.

Thanks for joining this thread.

I appreciate your effort in contacting our Customer Support Team to report the issue. Have you tried the recommended solutions stated in the article given by my colleague? If not, let's perform the troubleshooting steps so we can fix the issue.

Please refer to this article for more tips on fixing bank transactions can't download: What to do if bank transactions won’t download.

You might need this resource page for future reference in case you want to learn more about assigning and categorize the bank transaction in QuickBooks Online: Assign, categorize, edit, and add your downloaded banking transactions.

Please know that you're always welcome to post if you have any other concerns. Community Team will always here to help.

yes and i recieved no help , i wonder what i am paying for

You cant manually upload from Pnc so what are our options

I have tried every work around, cant upload manually from pnc and have spent countless hours with customer service so now what because I am ready to cancel the whole thing

I'm here to lend a hand, @mccrusing.

I can share information with you on what are the things that you need to keep in mind prior to importing bank transactions in QuickBooks Online.

Before importing, ensure that your CSV (or Excel) file format is accurate. Since if you try to upload an incorrectly-formatted file, you will receive an error message. 

Here are some formatting restrictions for CSV files:

• Special characters are not allowed:
  • Characters such as #, %, and & anywhere in the file.
  • Using brackets ( ) for negative amounts: (234) should be -234.
  • Currency symbols: $234 should be 234.
  • Commas to separate thousands (2, 111 should be 2111).
• Remove zeros (0) from the file and leave those cells blank.
• Correct any transactions that display a number in the Description column.
• Remove the word amount if it appears in the name of the Credit or Debit column (Credit amount and Debit amount are incorrect).
• MAC users must save the file as a Windows CSV file.
• Correct and standardize the Date format to a single format (for example, dd/mm/yyyy).
• Some banks provide the day of the week and include it in the Date column (for example, 20/11/2018 TUE), which is not an acceptable format. 

Once verified, you can now import your transactions by following the steps on the below articles:

• Manually upload transactions into QuickBooks Online
• Import bank transactions using Excel CSV files

If you have any questions between now and then when importing, don't hesitate to let me know. I'm here to help. Have a great day!

I also had this problem.  I had to disconnect each account and then re-establish the connection. Go to chart of accounts, click edit, check box to de-activate connection with bank. Don’t freak out when you go back to banking it will be gone from top line. Do update again and QB will take you to pnc and you can pick the account you want to add. I did mine one at a time to be safe. Or  call pnc and ask for QB specialist. I had to do this a couple of times before they all synced properly again. Pnc changed their server security. Still can’t get downloaded transactions to find match in the register. I have to manually find match.  Annoying to say the least. Anyone have fix for that?  Good luck!

Thanks for joining this thread, @Jkellner.

Our engineers are still working on this. As of this moment, the step that you've taken is the recommended workaround provided by our engineers. Your patience is greatly appreciated while they are working on this to provide the best solution.

I recommend contacting our QuickBooks Online Support Team to add your account to the list of affected users. Here's how:
 

1. Select Help (?) at the top right.
2. Click the Contact Us button.
3. Enter "Downloaded transactions are not matching" in the description box.
4. Hit Let's talk.
5. Select Get a callback or Start messaging.

Feel free to drop a comment below if you need further assistance. I'll gladly help.

i tried this and was able to correct my date, however the column of money is only a Positive number and the debit or credit designation is in another column.  When I upload they do not designate anything as a debit.   Same issues this guy is having.  I have a Mac i downloaded in CSV then corrected it.  I saved in both XLS and CSV neither will upload to quickbooks.

Hello, @dragonfly675.

When importing your transactions using a CSV file, you can use either a 3-column or 4-column file format.

3 Columns

4 Columns

You can read through this article for more detailed steps when importing bank transactions: Import bank transactions using Excel CSV files.

Feel free to leave your comments if you have other questions. 

As of date it still doesn't appear to work.

Hi vhsboysbaseball,

I got news about connecting PNC bank accounts to QuickBooks Online.

Online Banking is such a time-saver, and all we want for our clients is to help you save time so you can focus on your business. However, there are instances that would impair a smooth connection like a bank will change URLs, merge with other banks, change policies, etc.

Some banks also provide online banking feeds per account type, causing confusions to users as to why some of their accounts work fine and others don't.

PNC Financial services is currently using a new connection service called OAuth. We’re working to make this available to QuickBooks yet, and you will receive an email or a notification in QuickBooks when you can switch to it. Please check this article for more details: What's OAuth and what's changing with banking connections. 

Right now, please continue to use Web connect (import) as an alternative to keep your books updated.

Rest assured that we're working with to make the new connection available in QuickBooks.

Thank you for posting. Hope I made everything clear for you. You go back to this thread if you have additional questions.

Is the PNC Bank connection still not working? I've tried the CONTACT US function and have asked for a call back a couple of times and haven't received a call back. How else can I speak with someone?

Thanks for joining on this thread, @Headhunter13.

May I know what specific error message/code did you receive? This is to identify if we have a reported issue.

If you're unable to connect or download bank transactions, let’s re-establish the connection by performing a manual update.

Here's how:

1. Go to the Banking menu on the left panel to choose Banking.
2. On the Bank and Credit Cards page, select PNC bank and then hit the Update button in the upper right.
3. If you see a message about additional authentication, follow the on-screen instructions to complete the process.
4. Check if the transactions in the Blue tile increase. If nothing new downloaded, the issue could be on the bank’s website.

To fix the problem, follow the recommended steps in this article and perform Steps 2-3: What to do if bank transactions won’t download or there's a bank error.

If you still want to reach out to our QBO Care Team, I suggest using the Start messaging option. This feature allows you to get real-time assistance from our live chat support.

Here’s how:

1. Go to the Help icon at the top to select the Contact Us link.
2. This will open another window where you can enter the issue/topic.
3. Once done, click on the Let’s talk button to view the support information.
4. Choose the Start messaging option.

For some tips on how to keep your downloaded entries organized, check out the following guide: QuickBooks Online’s Bank Feeds: Connections.

Stay in touch if you need further assistance while working in QuickBooks. I’ll be right here ready to help you. Have a good one.

I tried copying/pasting the message, but I couldn't get it to paste here.

It says We're having trouble getting your bank data. Please try again later (355)

Apparently it's a known issue that you're working on. My bigger question is why didn't I receive a call back? When I used your CONTACT US feature, I selected a call back and was told I would get a call back in 5 minutes. Despite multiple attempts at this, I haven't received a call back.

I appreciate you getting back to us, @Headhunter13.

Contacting our Phone Support Team depends on the call they're receiving. They might have a high call volume that's causing the delay of the callback.

When contacting them, I'd recommend using the Start messaging option as stated by my colleague Rasa-LilaM above. This way, you'll get real-time support from one of our chat support agents. And they can add your company from the list of affected users and provide this investigation number for easy tracking: INV-43397.

To reach them, you can follow the detailed steps provided by my colleague above.

Also, rest assured that our product engineers are diligently working to fix the issue with PNC bank. In the meantime, I suggest uploading your PNC transactions in QuickBooks Online manually. For more guidance, feel free to check out this article: Manually upload transactions into QuickBooks Online.

You might also want to read this article to learn how to match transactions: Match and categorize bank transactions in QuickBooks Online.

Thank you for your patience while we work for a fix. Please know that you can always get back to this post if you have any other questions. Have a great day.

I am still able to connect to 4 out of 7 PNC accounts. Why can't i connect to the other 3?

Good evening, @Kchampion.

Are you receiving any error messages when you try connecting the three accounts? If you are, can you provide me a screenshot of the message or give me the details by leaving me a Reply? This will help me get a better understanding of this behavior.

If you're not receiving any error messages, then let's do some troubleshooting to see if it's a browser-related cause. Let's clear the cache of the web browser you're using for QuickBooks Online. These files can become outdated, causing issues like the one with not being able to connect your accounts from PNC. Here's a link to help you with the process: Clear Web Browser History. 

Let me know how this goes for you! I'll keep a close eye out for your response. Talk to you soon.

It just says "we can't find this account at your bank. Let's make sure the right accounts are connected to QuickBooks. This may take a few minutes. (324)"