SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27

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.
Danielle Rosa
Level 1

Missing Bank Transactions

Hi there, 

 

Some transactions are missing on the bank transactions to categorize them for reconciliation, however, these missing transactions are showing in the bank register. Can someone help me to solve this? 

 

Thank you in advance. 

 

Danielle

4 Comments 4
ZackE
Moderator

Missing Bank Transactions

Welcome to the Community, Danielle Rosa. I appreciate your detailed information.

 

If transactions are missing from the For review tab on your Bank transactions screen, I'd recommend checking the Categorized tab. This is where transactions you've already categorized will appear. Specifically, you'll want to review your Added or Matched column. This will tell you which account each transaction record was categorized into.

 

In the event you find what you're looking for, but it's in an incorrect account, you can unmatch and move it to its appropriate account using your Undo option in the Action column. This will disconnect your two transactions. The downloaded record will go back to your For review screen where it can be matched.

 

This image shows the added or matched column in the Reviewed tab in the Banking menu.

 

If you don't recall categorizing these transactions yourself, you may want to check if there's any active bank rules causing transactions to be auto-categorized.

 

Since you're working with transactions and reconciling, I'd like to mention an awesome tool on our website called QuickBooks Live Expert Assisted. This service gives you access to a dedicated bookkeeper who can help you manage your books.

 

I've also included a detailed resource about reconciliation which may come in handy moving forward: Reconcile an account

 

If there's any additional questions, I'm just a post away. Have a wonderful Wednesday!

Calltospeak_
Level 1

Missing Bank Transactions

Hi, If transactions appear in the bank register but are missing in the categorization screen, try updating your bank feed and ensure the transactions haven't already been manually added or excluded. Running a "Rebuild Data" can also help fix any discrepancies.

KVP1
Level 1

Missing Bank Transactions

my transactions  are  missing  from April  through  August -   My bank does not have an option to  download a  date  range.  Will I have  to put all these in manually?  

jenop2
QuickBooks Team

Missing Bank Transactions

You still have a couple of options to import banking transactions into QuickBooks Online instead of recording them manually, KVP1. Allow me to share them with you.

 

First, you can edit the CSV file to remove the rest of the transactions after downloading it from your bank's website. Here's a quick guide from Microsoft's support site for more details: Clear cells of contents or formats.

 

To make sure the formatting is correct, you can refer to this Community article for additional details: Format CSV files in Excel to get bank transactions into QuickBooks.

 

Next, you'll have the option to choose specific items in the process of importing banking transactions. Here's how to do it:

 

  1. Go back to the Bank transactions tab, then click the drop-down list beside the Link account, and then choose Upload from file.
  2. Choose Select files and click on the CSV file.
  3. Click Continue and choose the bank account.
  4. Choose Continue and make sure the format is correct.
  5. Select all transactions from April through August by checking the boxes before them.
  6. Click Continue and follow the succeeding prompts to import the file.

 

upload from file.pngupload from file 2.png

 

select transactions.png

 

Additionally, the Exclude function provides a convenient way to remove specific transactions from the For review tab after downloading and importing them.

 

Here's an article as a guide on this process: Exclude a bank transaction you downloaded into QuickBooks Online.

 

Please refer to these articles for additional reference materials when working with your bank transactions in QBO:

 

 

Feel free to post any follow-up or new questions anytime you need assistance when using the program for Online Banking or financial data management in QBO. We're always ready to help.

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

Need to get in touch?

Contact us