Skip to main content
August 4, 2021
Solved

There are some transactions missing in quick books that are on my bank statement. How do I pull these through?

  • August 4, 2021
  • 1 reply
  • 0 views
I am missing 5 transactions
Best answer by phuongthaob56

 

Hi there, @caroline356 .

Thanks for posting your experienced here in the Community. Let me help you retrieve the missing bank transactions into QuickBooks Online (QBO).

 

The transactions downloaded to QuickBooks Online is dependent on the data provided by your bank’s website. To confirm that these transactions are posted in your bank account, you can log into your account on the bank's website and check if you see the transactions.

 

Right after, let's update your bank account to bring in the transactions to QBO. Here's how:

  1. Go to Banking on the left panel.
  2. Click on the Banking link.
  3. Select the account you’re working on.
  4. Next, click on the Update button.

If in case you still can't see them in QBO, we'll need to download the missing bank transaction manually from your bank's website and import them into QuickBooks using WebConnect.

 

You can check this article to learn more about the WebConnect feature and the detailed steps: Manually upload transactions into QuickBooks Online.

 

Please let me know how it goes by clicking the Reply button below. I'll be around to help if you have any other questions about downloading bank transactions. Have a good one

1 reply

phuongthaob56
August 4, 2021

 

Hi there, @caroline356 .

Thanks for posting your experienced here in the Community. Let me help you retrieve the missing bank transactions into QuickBooks Online (QBO).

 

The transactions downloaded to QuickBooks Online is dependent on the data provided by your bank’s website. To confirm that these transactions are posted in your bank account, you can log into your account on the bank's website and check if you see the transactions.

 

Right after, let's update your bank account to bring in the transactions to QBO. Here's how:

  1. Go to Banking on the left panel.
  2. Click on the Banking link.
  3. Select the account you’re working on.
  4. Next, click on the Update button.

If in case you still can't see them in QBO, we'll need to download the missing bank transaction manually from your bank's website and import them into QuickBooks using WebConnect.

 

You can check this article to learn more about the WebConnect feature and the detailed steps: Manually upload transactions into QuickBooks Online.

 

Please let me know how it goes by clicking the Reply button below. I'll be around to help if you have any other questions about downloading bank transactions. Have a good one

MaryLandT
August 4, 2021

Let's find those five missing transactions from your online bank account, caroline356.

 

They're maybe stuck somewhere around the Banking menu. There are three areas to check to find those transactions:

 

You can start on the For Review tab. This is where QuickBooks puts recently downloaded transactions. If you find them, categorise them with the correct account. Transactions don't show up on your books until you categorise them.

 

Next, check the Categorised tab. This tells you what happens to transactions you've already categorised. Specifically, review the Added or Matched column. This tells you which account you categorised the transaction into. If you find them, but it's in the wrong account, unmatch and move them to the right one.

 

Finally, check the Excluded tab. If you mark them as personal or a duplicate, it goes here. QuickBooks won't add excluded transactions to your accounts. If you want to include them, select Undo from the action column. Then go back to the For Review tab and categorise them using the correct account.

 

Also, if you didn't categorise transactions, QuickBooks puts them into the Uncategorised Income or Uncategorised Expenses. To check these accounts:

 

  1. Go to the Accounting menu.
  2. Select the Chart of Accounts tab.
  3. Look for the Uncategorised Income or Uncategorised Expenses account.
  4. Select Run report.
  5. Look for your missing transaction on the report.
  6. Then, unmatch and move them to the correct account.
     

If you still can't find them, I recommend downloading these transactions from your bank. Then, import them manually to QuickBooks. 

 

Here's an article to guide you through the process: Manually upload transactions into QuickBooks Online. It provides instructions and detailed steps.

 

Please get back to me if there's anything else I can help you with finding those missing transactions. I'll be right here to guide you.

May 23, 2023

Hello, 

 

I am a desktop user and have noticed a high number of missing transactions when uploading the qbo file manually in bankfeeds. The transaction are in the file but do not populate in QuickBooks. The QuickBooks system seems to filter out vendors with the same name on the same day such as Uber, Lyft, Uber Eats, etc. We need something to address this right away as I am manually having to enter over 40 transactions for up to 25 different card holders. Please advise how we can remedy this situation as changing platforms to QuickBooks online is not an option.