Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
kdstucker
Level 1

Transactions for several months show up in my bank account but not in Quickbooks. Any idea how to fix this?

how do I get missing transactions to show up in 
quickbooks? this appear in my bank account but not QB. most transactions are there, but some are not. Any ideas?
2 Comments 2
AileneA
Moderator

Transactions for several months show up in my bank account but not in Quickbooks. Any idea how to fix this?

Hello, kdstucker. I'll assist you in locating any missing transactions in QuickBooks Online to keep your bank financials accurate and up-to-date. 

 

If you have linked your bank account to QuickBooks for the first time, some financial institutions allow you to download the past 90 days of transactions. However, if you have already linked your bank account to QuickBooks and some transactions are missing in QBO, you can update your bank institution manually. To do this, log in to your QuickBooks account, navigate to the Transactions tab, and select the account you want to update. Click on the Update button to refresh your data and ensure that all of your transactions are up to date.

 

Here's how:

 

  1. Click Transactions and select Bank Transactions.
  2. Choose the account.
  3. Tap Update

 

  

trans.PNG

 

Manually updating your bank institution is an excellent option if you're experiencing any issues with automatic updates or missing transactions in QuickBooks. It's a quick and easy way to ensure that your data is current and that you can access the most accurate information possible. 

 

If you have updated your bank account manually, but some transactions are still missing, you can add them to QuickBooks Online (QBO) by uploading a CSV file that contains the missing transactions. To obtain this file, visit your bank's website or contact customer support. Once you have the CSV file, upload it into QBO to ensure your records are up-to-date.

 

Please ensure that the CSV file you upload contains all the details for each transaction, including the date, description, amount, and account information. The transaction may not upload correctly if any of these details are missing. I have also attached an article explaining how to manually import a CSV file from your bank into QuickBooks. For more information, please refer to this article: "Manually upload transactions into QuickBooks Online."

 

Once your bank transactions have been downloaded or uploaded! It's essential to keep your books accurate and up-to-date. Categorizing and matching your bank transactions is crucial in ensuring that your financial records are correct. Once you've completed this step, you can move on to the bank reconciliation process, which will help you identify any discrepancies between your records and your bank's records. This will give you a clear picture of your financial situation and help you make informed decisions about your business.

 

Please do not hesitate to reach out here in the Community with further questions or concerns. Have a great day!

4Gal
Level 11

Transactions for several months show up in my bank account but not in Quickbooks. Any idea how to fix this?

@kdstucker 

Another option, use MT Online or one of the converter tools (e.g csv2qbo @ $60 one time license) as a workaround.

https://www.moneythumb.com/?ref=110

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us