Disconnect and Reconnect a bank account

Thanks for joining the Community space, @ljohncyr. I'd be glad to help sort out your bank transactions so they'll show correctly in your bank accounts. I'll also share insights about disconnecting and reconnecting bank accounts in QuickBooks.

Once you disconnect an account, QuickBooks deletes transactions that need to be categorized in the For Review tab and not the categorized/reconciled transactions. While reconnecting, some banks let you download the last 90 days of transactions. 

In your case, this might be the reason why it shows all your transactions after reconnecting them. Then, we can review your bank register, reconciliation reports without discrepancies, and the balances are correct for the missing transactions that you've mentioned.

To pull up your bank register, follow the steps below and use the filter tool to find them:

1. Go to the Gear icon and select Chart of Accounts.
2. Find the account register you want to review.
3. Click View register from the Actions column.
4. From the Filter tool, modify the date range and hit Apply.

You may also run your previous reconciliation reports. These reports will show you if there are any transactions altered or deleted.

1. Go to Reports.
2. Type Reconciliation Report in the Find report by name search bar and select it.
3. Pick the Account for the reconciliation report you want to view.
4. From the Report period dropdown arrow, choose the reconcile period.
5. Click View Report.
6. If there are any changes made, they'll show under the Reconciliation Change Report.

These resources also provide more details that are surely helpful in locating entries:

• Find, Review, and Edit Transactions in Account Registers
• How to Search for Transactions

Then, you can exclude the bank transactions that are already recorded to avoid duplicates in your bank register. For detailed instructions, see this article: Exclude a bank transaction you downloaded into QuickBooks Online.

Please let us know if you have additional questions about uploading transactions or any QuickBooks-related concerns. I'm always here to lend a hand. Stay safe and well.

Thank you for the quick response.    The previous account was called 'Operational Expenses'.  I had reconciled that account every month since January.   That account was disconnected and reconnected.   When I go to the Chart of Accounts for 'Operational Expenses', there is only 1 entry - the current balance (for all dates).  I went to the Reports as you explained and searched on Reconciliation Reports. When I select the 'Operational Expenses' account, it states that there are no reconciliation reports.  It's like the history from this account is gone.

Any other ideas?

John

Hello there, ljohncyr.

Thanks for getting back to us and following the steps shared by my colleague. I'm here to help ensure you can see your previous transactions in QuickBooks Online (QBO).

If you didn't categorize transactions into specific accounts, QBO may put them into the Uncategorized Income or Uncategorized Expense account after reconnecting your bank. Your missing transaction may be there. To check these accounts:

Here's how:

1. Go back to the Chart of Accounts (COA).
2. Look for the Uncategorized Income or Uncategorized Expense account.
3. Click Run report.
4. Look for the missing transactions on the report.

For more information about finding missing bank transactions in QBO, please check out this article: What to do if you can’t find downloaded transactions in QuickBooks Online. To move transactions out of the Uncategorized Income or Uncategorized Expense accounts, follow these steps to unmatch and move them.

If the transactions are still missing, let's sign in to your QBO using a private browser (incognito). There are times that the browser is already full of frequently accessed page resources (cache and cookies), causing some unusual responses. Here's how:

• Press Ctrl + Shift + N (Google Chrome).
• Ctrl + Shift + P (Firefox).
• Control + Option + P (Safari).
•  Ctrl + Shift + P (Microsoft Edge)

Once logged in, go back to the account to double-check. If they're showing, return to your default browser and perform a clear cache to refresh the system. However, if the issue persists, try using other supported browsers.

If the results are still the same, you can manually download the missing transactions as a workaround. For the detailed steps on how to do it, refer to this article: Manually upload transactions into QuickBooks Online.

Moreover, I'm adding this article that tackles reconciliation to ensure your account is balanced and accurate: Reconcile an account in QuickBooks Online.

Please leave a comment below if you have more questions about this or anything else. I'm more than willing to assist. Stay safe.

Thank you.  OK I did find the missing transactions in the 'Uncategorized Expense' account.

But I am a little confused on what to do next.  I should go to the Banking tab, and go through all the downloaded transactions from the new 'Operational Expenses' account and move them to the 'Uncategorized Expense' account?  That doesnt seem right - none of the transactions in the new 'Operational Expenses' account have been categorized.

Is the endgame to get all the transactions that I previously cleared and reconciled into the new 'Operational Expense' account' ?

John

or should I make the deleted Operational Expenses account, active again?  and then exclude all the transactions from the new account that are also included in the old Operational Expenses account?

thanks again

Great idea, @ljohncyr. You can definitely reactivate your Operational Expenses account and exclude all duplicate transactions from the new one. I’m glad to show you the process.

To do that, simply follow the steps outlined below:

1. Open your QuickBooks Online account.
2. Click the Accounting menu, then go to your Chart of accounts.
3. Next to the printer icon, click the Small gear icon.
4. Select the Include inactive checkbox.
5. Find your Operational Expenses account, then select Make active.
   

Then, you’re ready to exclude all downloaded bank transactions that are already included in the old account. Here are the steps to do it:

1. Go to your Banking page.
2. Under the Banking tab, go to the For Review tab.
3. Select the checkbox of the transactions to exclude.
4. Click the Exclude button.
   

You can read this article to learn more about the feature: Exclude a bank transaction you downloaded into QuickBooks Online.

In case you have entries that need to reclassify or categorized correctly, these guides will walk you through how to move them to the right accounts:

• Unmatch downloaded bank transactions or move them to another account
• Reclassify or move multiple transactions at once

Feel at ease to add comments below if you have other questions or concerns besides handling your bank transactions. I’m always ready to help you out. Have a good one and wishing you continued success!

Think I have it.  Thank you so much.  I am still learning but getting there!

I unlinked and re-linked checking accounts.  Now I have 107 transactions for review.  The transactions were all previously  categorized.  

I see these transactions in the checking account.  I can exclude these transactions, but my bank bal in QB is now way off from my actual bank balance.

The reason I unlinked is because my checking is not showing my true checking balance from the bank.  I updated and it still doesn't show.  I thought by unlinking and relinking it would update.  

QB originally had the correct checking balance.  Now I have 107 trx for review and my actual bank bal is still incorrect.  I can't just exclude the trx because QB bank bal is incorrect?  My QB bal is now in the negative.

I understand how important it is to get your correct balance, MRACE63. I'm here to help you sort this out. 

Before anything else, please know that it's not advisable to unlink your account. Once you disconnect it, QuickBooks deletes transactions that need to be categorized in the For Review tab, not categorized/reconciled transactions. While reconnecting, some banks let you download the last 90 days of transactions. 

Meanwhile, reviewing your bank statement and comparing it with the transactions in your register is essential before excluding them. 

To pull up your bank register: 

1. Hover to the Gear icon and select Chart of Accounts.
2. Find the account register you want to review.
3. Click View register from the Actions column.

You can now review and compare the transactions with your bank statement. 

Once done, return to your For Review tab, add and match essential transactions, and exclude unnecessary or duplicates. 

1. Hover to your Banking page.
2. Under the Banking tab, go to the For Review tab.
3. Select the checkbox of the transactions to exclude.
4. Click the Exclude button.

It's vital to categorize your bank transactions properly, as it helps you get the correct balance.

Once your beginning balance is correct, you can start reconciling your account. I'll add these helpful articles for future reference: 

• Learn the reconcile workflow in QuickBooks
• Reconcile an account

I'm still around to help you if you need assistance regarding your beginning balance. You can use the reply button below to enter your queries.