Disconnecting Bank Account

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!

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

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:

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

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!

Thank you. This is much more helpful.  I went to the chart of accounts, viewed the register and all entries are there.  I had not reconciled the account since 11/30/21. I realized in the chart of accounts I had two accounts for the same bank. Account 1 is the account I disabled earlier today. I had mistakenly created Account 2 with that same bank. On Account 2 I could not see any of the transactions in the banking transactions.

I attempted to resolve this by disabling Account 2 and then reconnecting Account 1, which I should never have disabled.  I can see all my data and this solves the problem of the disabled account. Thank you.

Now I am left with the problem for which I originally disabled the account (which did not resolve the problem).

Most of the transactions are missing in the account for Dec 2021, which I have never been able to reconcile. I can't figure out why. I initially uploaded a file with the missing transactions from Dec 1 to 29. It imported about half of the transactions during that time.  I again uploaded an additional file for a couple dates that were missing, Dec 2 to 3. The transactions are indeed being downloaded from my bank. But when I attempt to upload them into Quickbooks, they do not come through.  I've even tried different file formats: OFX, CSV, Quickbooks... but for the life of me I cannot get the transactions to upload into Quickbooks. This isn't a problem with the bank file.

What do you advise? Could you escalate this if you aren't sure of the answer?

Thank you.

I appreciate your detailed response, @SM1970.

I'm glad that my colleague LieraMarie_A was able to provide helpful advice. No worries, I'll help you get the information you need to upload the CSV file and map the data in QuickBooks Online.

You're also correct that this isn't a problem with the bank file. For December 2021 transactions, you'll have to edit the downloaded CSV file that follows the correct data format before you can upload it in QBO. In addition, when you're editing the CSV file in the Excel application, make sure to click the Enable Editing button to review and update the format if it needs some changes.

It can be a 3-column format that has the Date, Description, and Amount. Or a 4-column having the Date, Description, Credit, and Debit columns. Once the file is ready, save it as a CSV file. Please see the attached samples:

3-Column Format

4-Column Format

Once done, you can upload it and map the CSV file in QBO. Please make sure that the file size is not greater than 350 KB (you may need to cut the dates to reduce the file size, e.g.: December 1-10, December 11-20 or cut the number of transactions), select the bank account, and then map the fields correctly to upload it successfully.

You can reference this article for the detailed steps: Format CSV files in Excel to get bank transactions into QuickBooks. This covers the details to fine tune the formatting.

Furthermore, these articles that I share may be a great guide moving forward, especially when you find duplicate transactions or have to undo reconciled transactions to correct monthly reconciliation up to the present. Take a look at the details from these resources for more insightful information:

• Exclude a bank transaction
• Undo or remove transactions from reconciliation

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

So this didn't work. I followed every step you suggested. I followed the fine-tuning instructions. I edited the data and mapped the CSV file in QBO. Made sure the file wasn't too large. Followed all instructions. I've attached the file for you to see. (I converted the csv document into pdf so it would allow me to attach it.) It said it successfully imported the data. Yet the transactions are still not there. And it doesn't make sense that I would need to edit the file. Previously when I imported Dec 1 to 29, some of the transactions came through and some didn't. That would suggest it was not a problem with the file format and some transactions DID come through.

This is very frustrating taking days to resolve a simple problem because I cannot simply talk to a person. Is there a way to actually talk with someone so this doesn't go on for days?

Please help.

Thank you

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.

I could use some additional help please. My chart of accounts completely disappeared.  This was created by my accountant ten years ago. Will I have to reconstruct this?   Thank you for your assistance.

I know this has been very challenging for you, @SM1970.

I can see here a duplicate post with the same issue. I'd suggest following the response provided by my colleaguethrough this link: chart of accounts disappeared.

Additionally, you might want to check out this article to add and track transactions directly to an account register: Manually add transactions to account registers in QuickBooks Online.

Feel free to Reply below if you require any additional help with the chart of accounts. The Community is here to help. Keep safe!