cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Do you need any support with Making Tax Digital (MTD)? - Ask it here!
caroline356
Level 1

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

I am missing 5 transactions
2 REPLIES 2
phuongthaob56
Level 4

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

 

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
Moderator

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

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.

Need to get in touch?

Contact us