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!

I also have the self-employed version and am missing several months of transactions. I have followed all instructions. Downloaded the csv file. When I try to upload I get error message: Darn. File upload failed. (Probably our fault.) Please give it another try. If you see this message again, you might need to contact us. I

I have tried multiple times to upload and get the same message. What do I do?

I acknowledge your effort in uploading your bank transaction, @HollyBDesigns.  Let me assist you further and guide you through ensuring your data follows the 3-column or 4-column format.

To begin with, missing bank transactions can be caused by bank connectivity issues. If your bank has not updated correctly, you may not see the most recent transactions. It could also be that your bank is currently undergoing maintenance.

You can choose from the following column formats:

• 3-column format has Date, Description, and Amount columns. See the screen below for better visualization.
  
   
• 4-column format has Date, Description, Credit, and Debit columns.
  

Then, if you get the same error message when you upload, do the following:

• Remove any zeros (0) from the file. Leave those cells blank.
• Correct any transactions that display numbers in the Description column.
• Make sure the dates are in one format. I highly suggest you use: dd/mm/yyyy.
• Mac users must save the file as a Windows CSV file.
• Some banks add the day of the week in the Date column (for example, 20/11/2018 TUE). You need to remove the day of the week. To do this, split the date and the day of the week into separate columns:
  
  

1. Open the CSV in Microsoft Excel.
2. Highlight the column that contains the date.
3. Go to Data then select Text to Columns.
4. Follow the onscreen steps and select the following:
   • Original data type: Delimited
   • Delimiters: Space
   • Column data format: General

If the issue persists, you can also do a troubleshooting by using an incognito or private browser when importing your transactions. Some issues when uploading are also caused by browser issues.

• Safari 11 or newer: ⌘+Shift+N
• Chrome: Ctrl+Shift+N
• Safari: Command+Shift+N

If you don't encounter the error while using an incognito window, let's go back to your regular browser and clear its cache and cookies. This action helps clear out any issues affecting the performance of the platform. If the issue persists, try a different supported browser.

To explore more about uploading older transactions, you can check out this article: Add older transactions to QuickBooks Self-Employed. It provides detailed instructions on how to manually add older bank transactions to ensure all your transactions are recorded accurately.

Once you successfully upload your transaction, you can check out this article: Categorize transactions in QuickBooks Self-Employed. It provides detailed instructions on how to categorize your bank transactions to ensure they are recorded accurately.

I'll keep my notifications on to assist you further with any bank feeds or QuickBooks-related issues. We're invested in your understanding. Take care!