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

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.

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.

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:

• Categorize online bank transactions in QuickBooks Online
• Match online bank transactions in QuickBooks Online

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.

I also have months missing from my  bank transaction feed from 08/07/2024 - 27/09/2024

I've tried to follow the trouble shooting steps in this feed, but my layout is not the same, I have the self-employed version of quickbooks and it was great to begin with- I thought this was going to save me alot of time, but I have spent hours trying to fix this problem and I dont have the time to go through and manually import 2.5 months of daily transactions, especially as each day could be up to 5, sometimes more. Please help.

I appreciate you taking the time in following the inputs shared on this thread, HairKair. Let me help ensure you can import missing entries in your QuickBooks Self-Employed account.

We can manually import transactions by selecting the Include all transactions option via CSV file so that you can retrieve the missing transactions in your company data. To successfully import your CSV file, refer to these steps:

1. On the upper right corner, look for the Profile icon.
2. Then, select Import transactions.
3. Find your bank account and select Import older transactions under the Action column.
4. Click Browse and choose the CSV file you want to import.
5. You'll be routed back to the Import transactions window.
6. From there, select the Include all transactions option.

For more detailed information, check out this reference: Add older transactions to QuickBooks Self-Employed

Once your transactions are all in, you can go to the Transactions menu and categorize your imported transactions. This way, QuickBooks puts them on the correct line of your Schedule C.

I'll be on this forum anytime you require additional assistance managing online bank transactions in your account. Just let me know in the comments below. Stay safe!