cancel
Showing results for 
Search instead for 
Did you mean: 
M4MU
Level 1

Missing bank transactions

Hello! A client handed over their online QB account over to me and they are missing transactions from end of Dec 2023 to end of Jan 2024. We're talking about 500 transactions which I don't have time to enter manually. Any chance these can be retrieved without affecting everything else I've categorized? Thank you!

2 Comments 2
AileneA
Moderator

Missing bank transactions

I know the importance of accurately recording transactions and the impact that missing transactions can have, M4MU.

 

Fortunately, there are a few options we can explore to retrieve the missing transactions without affecting the rest of your QuickBooks Online data.

 

First, update your bank account to bring them in QuickBooks Online. I'll show you how.

 

  1. Go to Transactions and select Bank Transactions on the left panel.
  2. Select the blue tile for the account you're working on
  3. Click on the Update button.

 

Second, it would be beneficial to review your uncategorized accounts, as the missing transactions might be located there.

 

  1. Click the Transactions menu and choose the Chart of Accounts tab.
  2. Look for the Uncategorized Income or Uncategorized Expenses account.
  3. Tap Run report.
  4. Look for the missing transaction in the report.

 

 

 

Once verified that the data is not there, I recommend manually importing them using a CSV file into QuickBooks Online. Ensure the file format matches the required format for importing transactions into QuickBooks Online. This method can be efficient for importing a large number of transactions at once.

 

Once everything is in order and the missing transactions have been retrieved, you can proceed with categorizing them accordingly. For more details, refer to this article: Categorize online bank transactions in QuickBooks Online.

 

Finally, I recommend performing an account reconciliation to guarantee the accuracy of your transaction data and identify any discrepancies.

 

If you need additional assistance, I suggest reaching out to the QuickBooks Community again for further guidance. We're always here to help. Have a great day!

SIAB
Level 6

Missing bank transactions

@M4MU 

You can 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

 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us