cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
john999
Level 1

missing banking transactions

I am missing banking transactions. it seems to occur once a month and it is always when I have used PayPal, but not all PayPal transactions go missing! While I can make manual adjustments, I would rather quick books online picked all the transactions that are in my bank account. Has anyone experienced this problem and does anyone know a solution? Thanks

6 REPLIES 6
ChristineJoieR
QuickBooks Team

missing banking transactions

My main focus is helping you manage your PayPal transactions in QuickBooks Online, John999. I'm here to explain how QuickBooks obtains banking data from PayPal to help you categorize your transactions effectively.

 

Please keep in mind that QuickBooks Online is dependent on the banking data provided by PayPal. This means that any discrepancies or missing transactions may arise from the information being shared between the PayPal platforms.

 

For some reason, connection delays can interfere with the data transfer process from PayPal to QuickBooks. Therefore, staying alert about the connection and checking for updates from PayPal can help maintain accurate financial records in your QuickBooks account.

 

Furthermore, it's essential to ensure that your PayPal account is correctly linked and that you regularly update your bank feed in QuickBooks to capture all relevant transactions. If you haven't tried to update your bank, you can follow the steps below:

 

  1. Sign in to your QuickBooks Online account.
  2. Go to the Transaction menu and choose the Bank Transaction tab.
  3. Select your PayPal account and click Update
  4. If asked, enter your Multi-Factor Authentication (MFA) credentials and then select Continue update.

 

Also, you can manually add certain transactions that still don’t appear, in QuickBooks by going to the + New button and selecting Bank Deposit or Expense, depending on the transaction type.

 

Additionally, you can reference these articles later when using QuickBooks. They provide useful context that can help streamline the process of categorizing and reconciling your accounts.

 

 

If discrepancies arise, please don’t hesitate to check for updates or reach out for assistance on the Community page. Keeping this information in mind will assist you in keeping precise records and improving the efficiency of your financial management.

john999
Level 1

missing banking transactions

Hi, I am sorry but I probably didn't explain the problem clearly enough (sorry), it's not with Paypal but with my bank account transactions. I only have my bank linked to QBO, nothing else whatsoever is linked. I use paypal quite often and use my bank card stored in Paypal for some transactions. The bank statement correctly shows all the Paypal transactions but some transactions are not showing in QBO. So, the transactions are correct in my bank statement (and in my bank app), my bank account is attached to QBO, but QBO is not collecting all of the Paypal transactions. The problem is an error with QBO not picking up all my bank transactions. Have other people experienced this error, it seems quite a serious one.

LollyNino_C
QuickBooks Team

missing banking transactions

Thank you for your prompt response and for providing us with additional information and inquiries, @john999.

 

Please know that Quickbooks Online depends on the data provided by your bank. This means when you link the bank, they can give you up to a year of historical data. Some banks let you download the last 90 days of transactions.

 

In the meantime, I recommend logging into your bank's website to check for any messages, notifications, or alerts that may require your attention. Sometimes, bank system maintenance or server issues can lead to delays.

 

When you notice that your transactions are missing after updating your bank feed, you can look for them in the Banking menu.

 

Here's how:

 

  1. On the left pane, select Transactions.
  2. Choose Bank Transactions, then click on your bank or credit card account.
  3. Check on the For ReviewCategorised, and Excluded tabs to find the missing entries.

 

For the detailed process, please visit this article: Find missing bank transactions in QuickBooks Online.

 

Furthermore, please refer to this article for assistance with reviewing and organising your bank transactions, as well as reconciling your uncategorised accounts and identifying any missing transactions in QBO:

 

 

We're always ready to help if you have other inquiries about handling bank accounts or managing bank transactions inside the program. Feel free to visit us anytime or comment below. Have a great day!

john999
Level 1

missing banking transactions

Hi LollyNino, Unfortunately, I have checked all the routes you suggested. The missing transactions are not in the review, categorised or excluded tabs. They are simply missing. There are no alerts from my bank (Starling business account) and the transactions are visible when I look on my banking app, when I download my banking app into excel and on my physical bank statement. The reason i noticed the error was because my bank balance and that held in QuickBooks were not  the same. I then downloaded the data from QBO in excel and compared that to the excel download from my bank. I found 9 transactions that were in my bank feed but not picked up by QBO. On closer inspection, these 9 transactions were where I had used my bank card via PayPal but other payments where I had used my bank card via PayPal were correctly picked up by QBO. I have checked with my bank and there are no alerts and were no maintenance sessions around the time of the transactions (in fact other transactions that occurred at more or less the same time have been picked up by QBO. Given that I can see the transactions in my bank statement, in my banking app and in an excel download from my bank, it seems that the error is in QBO not picking up some of these transactions. Thanks, John999

John C
QuickBooks Team

missing banking transactions

Hi john999 Thanks for reaching out to us here on the Community. We haven't had any reported instances similar to the one you're experiencing and as alluded to in a previous post QuickBooks relies on a stable connection with a 3rd party/your bank to ensure that all the transactions are populated. We do appreciate that you have checked your bank and there were no alerts or maintenance around the dates of the transactions however there still may have been an issue with the connection that caused the transactions not to be populated. If this issue is occurring on a regular basis we recommend that you fully disconnect and reconnect the bank account following the steps in the article provided, please note, as per the article, that any transactions on the for review page would have to be accounted for before disconnecting the account: https://intuit.me/3zGvS7C As the missing transactions are historical it's not possible to automatically populate them on the for review page, they would have to be either manually added or uploaded by CSV following the steps in this article: https://intuit.me/3XWIUXT.

john999
Level 1

missing banking transactions

Thanks for your post. I have updated the transactions by uploading a .csv file with just the missing transactions. Very easy but frustrating that they weren't there in the first place. Thanks

Need to get in touch?

Contact us