There are a bunch of transactions missing in the bank account in quick books

Hi astranti2020,

I'm glad to see you reaching out to Community.  It's essential that you're able to locate transactions for all dates to ensure your books are accurate.  In QuickBooks Online the updating feature is great for keeping your accounts up to date.  I'd be happy to help locate the missing transactions!

Initially, I'd suggest taking a look at the audit log to see if the transactions were accidentally deleted or possibly edited.  To do this, go to the Gear in the top right and select Audit Log.  If they've been deleted, you'll need to re-create them manually.  In addition, from the banking section, have a look in the Excluded folder.  You can filter this by the date range mentioned above.  If the transactions are here, checkmark the box next to each of the transactions and hit Undo.  This will put them back in the Review section so you can match or categorize them accordingly.

If you're still not able to locate the transactions, you can upload them manually.  Here's how:

Login to your bank's website and download your transactions in csv format. Select the date range based on the missing transactions in QuickBooks Online. Open the file and format it prior to uploading it into your bank feed. Save the file when finished.

Follow these steps to upload the transactions:

1. Log into QuickBooks Online and go to Banking

2. Click the tile for the account you're uploading the transactions into

3. Select the ▼ dropdown arrow beside Link account and then Upload from file

4. Hit Browse and select the csv file you downloaded from your bank, then click Next

5. From the Account ▼ dropdown, choose your account and hit Next

6. Follow the onscreen instructions to match the columns with the correct fields in QuickBooks and hit Next

7. Select the transactions to import and continue through the prompts

8. Choose Yes

9. When you're ready, hit Let's go

If you notice any duplicate entries, here's how to remove them:

1. From the Review tab, checkmark the box beside all duplicated entries

2. Select Exclude from the tab that appears

Note: You can permanently delete the transactions from the Excluded tab by selecting all items and then hit Delete. This process is irreversible and any transactions deleted in error will need to be recreated manually.

Here's an article for your reference on how to search for transactions in QuickBooks Online.

If you have any other questions, please feel free to reach back out.  We'd be glad to assist!