Bank transactions now showing

bradleygood745 · ‎October 11, 2023

Hi,

I'm using Quickbooks online, and have a bank account linked. It has been working fine in the past.

I go to "To Review" and categorize my expenses from my bank account.

I wasn't logging in for a few months, and now am back to catching up.

The first thing I noticed was that at some point, the check images were not coming over for transactions.

Then the transactions themselves stopped showing. They are missing.

I've hit the "Update" button on the bank account several times, they still don't show.

What do I do next? I think I remember having to disconnect the account and reconnect it in the past to resolve an issue like this. But I'm not sure how to do that, or if that is the right thing to do. And what the consequences of that may be.

Thanks!

DHeraV · ‎October 19, 2023

Hello there, @bradleygood745. I'd like to provide clarification on your missing transactions query.

Before anything else, can you share what financial institution you have? This will help us check if there's an ongoing issue on your bank's end. For now, I suggest logging into your bank's website and checking for any alerts or notifications regarding your situation.

Since you can't find the entries, I recommend checking out these areas on the Banking page:

First, navigate to the For review tab in QuickBooks. This tab is where recently downloaded transactions are stored. If you locate the missing transaction, assign it to an appropriate account category. Keep in mind that transactions will not appear in your books until they have been categorized.
Next, check the Categorized tab. This tells you what happens to transactions you already categorized. Specifically, review the Added or Matched column. This tells you which account you categorized the transaction into. If you find your missing transaction, but it's in the wrong account, follow these steps to unmatch and move it.
Finally, check the Excluded tab. If you mark a transaction as personal or a duplicate, it goes here. QuickBooks won't add excluded transactions to your accounts. If you want to include it, select Undo from the action column. Then go back to the For review tab and categorize it into the correct account.

For detailed information, kindly visit: What to do if you can’t find downloaded transactions in QuickBooks Online.

Alternatively, you can request your bank for a CSV file and manually import the missing transactions to your QuickBooks account.

Moreover, disconnecting and reconnecting bank accounts in QuickBooks should be considered as a last resort when troubleshooting this situation, as it has the potential to cause duplicate entries.

Furthermore, you may want to check out this article to learn how to reconcile your accounts so they always match your bank and credit card statements: Reconcile an account in QuickBooks Online.

Simply leave a comment below if you require further assistance or have additional banking questions in QuickBooks. I'm sure to circle back and provide you with the necessary information.

View solution in original post

ShyMae · ‎October 11, 2023

I appreciate the steps you've performed to resolve this issue @bradleygood745.

In QuickBooks Online (QBO), you can perform a manual update when you notice that QBO no longer downloads your latest available transactions. You may want to log in to your bank's website to see if there are any alerts or notifications that could provide further information about this.

Based on the information you shared, you've tried to update transactions manually however it doesn't show up in your account. I suggest uploading your transactions manually by using an incognito or private window with these keyboard shortcuts:

Ctrl + Shift + N for Google Chrome
Ctrl + Shift + P for Firefox
Control + Option +P if you're using Safari.
Ctrl + Shift + P for Microsoft Edge

Furthermore, it's not recommended to disconnect your bank account from QBO. If you do so, it will delete transactions that still need to be categorized in the For review tab. If you need more information on what will happen if you disconnect your bank account, you can refer to this article: Disconnect accounts connected to online banking in QBO.

Check out these articles to help you manage your uploaded transactions in QBO:

If you need any further assistance regarding the transactions in QBO, please do not hesitate to reply below. I'm always here to assist. Be safe and have a nice day ahead!

bradleygood745 · ‎October 19, 2023

Thank you for the reply and help.

I can't figure out what you mean by the sentences that you wrote below. I have not tried to update them manually, I just tried the update button. Why would I use an incognito or private window? And what would I do in that window?

Based on the information you shared, you've tried to update transactions manually however it doesn't show up in your account. I suggest uploading your transactions manually by using an incognito or private window with these keyboard shortcuts:

Ctrl + Shift + N for Google Chrome
Ctrl + Shift + P for Firefox
Control + Option +P if you're using Safari.
Ctrl + Shift + P for Microsoft Edge

DHeraV · ‎October 19, 2023

Hello there, @bradleygood745. I'd like to provide clarification on your missing transactions query.

Before anything else, can you share what financial institution you have? This will help us check if there's an ongoing issue on your bank's end. For now, I suggest logging into your bank's website and checking for any alerts or notifications regarding your situation.

Since you can't find the entries, I recommend checking out these areas on the Banking page:

First, navigate to the For review tab in QuickBooks. This tab is where recently downloaded transactions are stored. If you locate the missing transaction, assign it to an appropriate account category. Keep in mind that transactions will not appear in your books until they have been categorized.
Next, check the Categorized tab. This tells you what happens to transactions you already categorized. Specifically, review the Added or Matched column. This tells you which account you categorized the transaction into. If you find your missing transaction, but it's in the wrong account, follow these steps to unmatch and move it.
Finally, check the Excluded tab. If you mark a transaction as personal or a duplicate, it goes here. QuickBooks won't add excluded transactions to your accounts. If you want to include it, select Undo from the action column. Then go back to the For review tab and categorize it into the correct account.

For detailed information, kindly visit: What to do if you can’t find downloaded transactions in QuickBooks Online.

Alternatively, you can request your bank for a CSV file and manually import the missing transactions to your QuickBooks account.

Moreover, disconnecting and reconnecting bank accounts in QuickBooks should be considered as a last resort when troubleshooting this situation, as it has the potential to cause duplicate entries.

Furthermore, you may want to check out this article to learn how to reconcile your accounts so they always match your bank and credit card statements: Reconcile an account in QuickBooks Online.

Simply leave a comment below if you require further assistance or have additional banking questions in QuickBooks. I'm sure to circle back and provide you with the necessary information.

bradleygood745 · ‎October 20, 2023

My bank is WSFS. I went thru all of my transactions and here is a summary:

All 2023 transactions are in the QB feed, except for all of June.

Other than June which is completely missing in the feed, all other months had the transactions in the QB feed, but for a time period, they were missing the "bank attachment" of the check image. For all of those, I manually added the check image. That period of transactions present in the feed but no bank attachments was 3/16/23 to 9/22/23.

9/22 and after, all transactions have bank attachements (check images).

When I hit the update button earlier tonight, a new transaction for Oct came in. So it is working now.

I think I just need to get a csv file from the bank website and upload it to QB.

Waiting for your reply before I do that, because you asked about my bank first.

Thanks!

bradleygood745 · ‎October 20, 2023

I checked for alerts and messages. They only go back 90 days, so we don't know what may have been there in June.

Of what was there, I didn't see anything out of the ordinary.

bradleygood745 · ‎October 20, 2023

Nothing is in the excluded tab for 2023

bradleygood745 · ‎October 20, 2023

OK, so I didn't wait.

I exported a csv from the bank and uploaded it, then added the check images and categorized the transactions.

I think I'm all good now.

Thanks so much for the help!!

Angelyn_T · ‎October 20, 2023

Thank you for the update, Bradley.

It's my pleasure to hear that everything is working well now and you've successfully uploaded an Excel CSV file for your missing bank data. Since the transactions are in QuickBooks, it's time to match and categorize them under the For Review section.

If you have any additional banking inquiries, please don't hesitate to leave a comment below. I'm here to assist you and provide the necessary help you need. Have a good one!

bradleygood745 · ‎October 21, 2023

Thanks!

Topics

Training

Community

Resources

Bank transactions now showing