Skip to main content
C
cbait
June 17, 2024
Question

Certain transactions are missing from my bank feed. How can I get them into QuickBooks?

  • June 17, 2024
  • 1 reply
  • 0 views

I am trying to reconcile my books from January 2024 to June 2024 and I noticed that there are a number of transactions from February 2024 that aren't in QuickBooks but they are in my Chase checking bank statement. How am I supposed to get these missing transactions into QuickBooks? My bank feed is working and I have updated it multiple times. 

1 reply

J
JanbonN
June 17, 2024

I'm here to help you locate the missing transactions and provide a workaround for you, @cbait.

 

There are a few possible reasons why your transactions are not showing on the reconciliation page:

 

  • The transactions are on the For Review page but were not categorized or matched.
  • The transactions were manually reconciled in the register.

 

To verify the missing transactions, first, check the Banking menu to see if they are stuck there.

 

  1. Go to Transactions and select Bank transactions.
  2. Click the tile for the bank or credit card account you downloaded the transaction from.
  3. Begin by checking the For review tab, where recently downloaded transactions are stored. If you locate the missing transaction, categorize it into an account. Please note that transactions won't appear in your books until they're categorized.
  4. Next, review the Categorized tab and check the Added or Matched column to ensure transactions are categorized correctly. If you find a transaction attributed to the wrong account, please unmatch it and move it to the correct one.
  5. Lastly, assess the Excluded tab. If a transaction was marked as personal or a duplicate, it will appear here. Excluded transactions are not added to your accounts. To include an excluded transaction, select Undo from the action column. Then, return to the For review tab and categorize it into the correct account.

 

Second, please check the bank register to see if the transaction has been manually reconciled.

 

  1. On the bank transactions page, click the Go to bank register link.
  2. Utilize the funnel icon to filter the transactions by Reconcile Status, Transaction Type, Payee, and Date.
  3. Select Apply to confirm the filter settings.
  4. If a missing transaction contains an R, it means it's already reconciled.
  5. Edit the transaction if necessary and click Save.

 

Third, please go to this article and follow Step 4: What to do if you can’t find downloaded transactions in QuickBooks Online.

 

After verifying the steps above, I would recommend manually adding the missing transactions for you to reconcile the account.

 

Additionally, you can check the reconciliation report to see the summary of the reconciliation you've made.

 

Let us know if you have other concerns with your reconciliation and transactions. We're here to help you.

K
KeatonCross
September 4, 2024

Hi - I am having a similar issue.  I went through all of these steps and the transactions weren't there.  I am missing two months worth of transactions from my credit card.  It's like the download didn't work for two months.  How do I tell quickbooks to go re-download the transactions?  

Thanks.

J
JanbonN
September 4, 2024

Hello, Keaton. Thank you for your efforts in following the steps outlined above. I’m here to help you import your missing bank transactions into QuickBooks Online (QBO) to ensure your records remain accurate. 

 

Since you've completed the troubleshooting on the QuickBooks side, I recommend contacting your financial institution to verify if there are issues on their end that caused the missing transactions.

 

Before importing your bank transactions, be sure to double-check the start and end dates for the transactions you wish to import. You can do this by reviewing the bank register for the dates of the missing transactions. Once confirmed, download the transactions from your bank and ensure that the file is in CSV format.

 

Let's now import the bank transactions:

 

  1. Go to Transactions and select Bank transactions.
  2. Click on the bank tile for the account you wish to upload the transactions into.
  3. From the Link Account dropdown, choose Upload from File.
  4. Click select files, then locate and choose the file you downloaded from your bank, and click Continue.
  5. In the QuickBooks account dropdown, select the account you want to upload the transactions, then click Continue.
  6. Follow the on-screen instructions to match the columns in your file with the corresponding fields in QuickBooks, then select Continue.
  7. Choose the transactions you would like to import, and then click Continue.
  8. Finally, click Yes and then Done.

 

Please refer to this article for more details: Manually upload transactions into QuickBooks Online.

 

Moreover, you can also add the missing transactions to your account register.

 

Additionally, please refer to these articles about managing your bank transactions:

 

 

Let us know if you have other concerns with your bank transactions in QBO. We're here to help you in any way we can.

Terms & ConditionsAccessibility statement