Skip to main content
S
SM1970
August 13, 2022
Solved

Disconnecting Bank Account

  • August 13, 2022
  • 1 reply
  • 0 views

Hello!

 

I'm afraid I have made a huge mistake.  I was unable to upload some transactions from my bank so I disconnected the bank thinking I would not lose the data that was already in Quickbooks. Then I reconnected the bank and opted for it to download transactions only from today going forward.  It appears all of my bookkeeping for the last ten years is gone!! Is this correct?

 

Is there any way I can retrieve the last 10 years of my business bookeeping?

 

Please respond urgently if you can. I'm very stressed about this.

 

Many Thanks

Best answer by AileneA

I've found the problem. I have imported those transactions several times now and they auto-confirm, which is why they aren't showing up in the items to be reviewed. But they are there several times in the categorized transactions. I had forgotten they auto-confirm. So they have been importing correctly all along. That's embarrassing. My mistake.

 

Now the issue is, I have several duplicate transactions for each date. What's the best way to get rid of the duplicates? Should I go into the reviewed transactions and simply "undo" the duplicates and the "exclude" them? Or is there a better way

 

Thanks for your help.


 Thanks for getting back to us, SM1970. 

 

Thank you for updating us. I'm glad you're able to resolve the issue. Yes, you can exclude those duplicate transactions under the review tab. To do this, follow the steps below. 

 

  1. Go to the Banking menu.
  2. Click the For Review tab.
  3. Mark the items you want to delete.
  4. Choose Exclude Selected.
  5. Once done, go to the Excluded tab.
  6. Mark all the items to be deleted.

 

 

 

 

 

 

Please check this article for more information: Exclude a bank transaction you downloaded into QuickBooks Online.   

 

You'll also want to reconcile them to ensure your books are accurate and they match your real-life bank and credit card statements. 

 

Fill me in if you have additional questions about importing transactions in QuickBooks. I'm always here to help. Take care always.

1 reply

Rubielyn_J
Rubielyn_J
August 13, 2022

Don't worry, SM1970. I've got your back to ensure you can bring back your previous years of business bookkeeping in QuickBooks. 

 

To enter older transactions, or if your bank or credit card can't connect to QuickBooks, you can still upload transactions manually. Make sure to know the date of the oldest existing transaction currently in the account to avoid any duplicate entries.

 

Then, get transactions from your bank. Once ready, you can proceed to the following steps below to upload your transactions in QuickBooks:

 

  1. In QuickBooks Online, proceed to Bookkeeping.
  2. Select Transactions, then choose Bank transactions (Take me there).
  3. Click the blue tile for the account you want to upload the transactions into.
  4. Choose the Link account ▼ dropdown and then Upload from file.
  5. Click Drag or drop or select files, and then select the file you downloaded from your bank. Then select Continue.
  6. In the QuickBooks account ▼ dropdown, choose the account you want to upload the transactions into. Then click Continue.
  7. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Continue.
  8. Choose the transactions you would like to import. Then select Continue.
  9. Click Yes.
  10. When you accept your transactions, select Done.

 

For more information, you may also check out this article: Manually upload transactions into QuickBooks Online. 

 

Now that your transactions are in QuickBooks, you can start to match and categorize them. The transactions go into your accounts after you review them. Aside from that, QuickBooks Online also enters certain details automatically if you set up any banking rules, or if it recognizes transaction descriptions.

 

As always, we're open 24/7 to help you with any concern with your banking transactions in QuickBooks. Simply click the Reply button to create a comment. Take care!

S
SM1970Author
August 13, 2022

Thank you for your response but this was not at all helpful.  I'm aware of how to bring transactions from my bank to Quickbooks and am not needing help with that.

 

What I don't know how to do is to bring up the 10 years of data that seems to have disappeared once I disconnected my bank. I then reconnected my bank and asked for only transactions from today forward so that I don't have 10 years of duplicate transactions. But none of the prior 10 years of reconciled transactions show up.

 

If I bring in the 10 years of transactions will I have to go back and reconcile all of it again? Are the previous transactions I had already brought into Quickbooks prior to disconnecting the account simply gone? I don't want to re-download 10 years of transactions that are already there. Or are they no longer there?

 

I'd like the 10 years of old data that was reconciled to show up in the bank register. Is it gone for good?

 

The reason I disconnected my banks was because I was having problems with something else and thought it might help to disconnect and reconnect my account. But this clearly was a bad idea and made things much worse.

 

PLEASE, is there a real person who can really answer my questions instead of someone saying they have my back and sending a bunch of links to information I already know?  I'd appreciate some real help.

 

Thank you

LieraMarie_A
LieraMarie_A
August 14, 2022

Hi there, @SM1970.

 

Thank you for the additional information. I assure you that I'm the right person to answer your questions and help you find the transactions.

 

Before we start, can you clarify if these transactions are missing from your bank register and reports? Was your ending balance changed? When you disconnect an account, your existing data won't change. It will only delete uncategorized entries in the For review tab.

 

Let's view your register and use the filter tool to find them. Follow these steps below:

 

  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.
  5. Review your entries and verify if they're missing. You'll also want to review its ending balance.

 

I also recommend running 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:

 

 

It can also be due to outdated or corrupt cache files in your web browser. Let's try accessing your account through an incognito window to rule out the possibility of a webpage issue. You may refer to these shortcut keys to open an incognito window in all supported browsers:

 

  • Chrome: Ctrl+Shift+N
  • Firefox: Ctrl+Shift+P
  • Safari: Command+Shift+N

 

After logging in, follow the steps above to locate your transactions. If they're all showing, you may have accumulated too much historical data in your browser. I recommend clearing the cache so you can access QuickBooks with a clean slate. Alternatively, you can use a different supported browser.

 

Please fill me in on your result after following the steps above. I'll be happy to help until it's resolved! Thanks again for coming to the Community. Have a splendid week!

Terms & ConditionsAccessibility statement