cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Active Member

Need to Connect Account Info for Closed Account

I have a QBO file export from an old bank account now closed

 

How do I connect the old data to a Bank account in Quickbooks Online?  The wizard wants me to enter a login -- which no longer is available.   I just want to sort the old data to update my books.

Solved
Best answer 03-25-2019

Accepted Solutions
QuickBooks Team

Re: Need to Connect Account Info for Closed Account

Hi michaelf318is,

 

I appreciate the details of your situation and what you're looking to do. I can help you get your old bank data into QuickBooks.

 

As you've discovered, connecting your bank directly to QuickBooks requires that you have login information, so you won't be able to do it that way. Not to worry, if you still have the transactions saved as a .CSV, .QFX, .QBO, or .OFX document, there's another way you can manually bring them into the program so that your books are updated and balanced.

 

To start, manually create the account in your chart of accounts. Follow these steps.

  1. Click the Accounting tab in the left menu.
  2. Make sure you're on the Chart of Accounts section.
  3. Click the New button in upper right corner of the page.
  4. Choose Bank at the account type and fill in the Detail Style and Name as you'd like (e.g. a Chequing account for CIBC).
  5. Verify all other necessary details.
  6. Save and Close.

Now that the bank is set up, you can use the bank file to import the data.

  1. Click the Gear icon in the top right of the screen.
  2. Select Import Data.
  3. Choose Bank Data.
  4. Browser for the file in question, then click Next.
  5. Choose the QuickBooks Account, which would be the bank account just created.
  6. Select Next.
  7. Follow the steps to map the document to QuickBooks.
  8. Select the transactions you'd like to import.

The article How to upload more than 90 days of bank transactions has more information about this process.

 

If you don't have a downloaded file of transactions from the closed account, I suggest entering in the transactions manually or creating a .CSV document then following the process above to bring in the information. Otherwise, it's ideal to speak with an accountant to learn the best way to record the information you need in your account.

 

To give your accountant the ability to see what's happening in your QuickBooks by adding him or her as an accountant user. QuickBooks can also help you find an accountant if you don't have one through our Find a ProAdvisor tool directly in your account. Simply click the My Accountant tab to learn how you can use your postal code to find accountants near you.

 

I hope that helps. Don't hesitate if you have more questions!

3 Comments
QuickBooks Team

Re: Need to Connect Account Info for Closed Account

Hi michaelf318is,

 

I appreciate the details of your situation and what you're looking to do. I can help you get your old bank data into QuickBooks.

 

As you've discovered, connecting your bank directly to QuickBooks requires that you have login information, so you won't be able to do it that way. Not to worry, if you still have the transactions saved as a .CSV, .QFX, .QBO, or .OFX document, there's another way you can manually bring them into the program so that your books are updated and balanced.

 

To start, manually create the account in your chart of accounts. Follow these steps.

  1. Click the Accounting tab in the left menu.
  2. Make sure you're on the Chart of Accounts section.
  3. Click the New button in upper right corner of the page.
  4. Choose Bank at the account type and fill in the Detail Style and Name as you'd like (e.g. a Chequing account for CIBC).
  5. Verify all other necessary details.
  6. Save and Close.

Now that the bank is set up, you can use the bank file to import the data.

  1. Click the Gear icon in the top right of the screen.
  2. Select Import Data.
  3. Choose Bank Data.
  4. Browser for the file in question, then click Next.
  5. Choose the QuickBooks Account, which would be the bank account just created.
  6. Select Next.
  7. Follow the steps to map the document to QuickBooks.
  8. Select the transactions you'd like to import.

The article How to upload more than 90 days of bank transactions has more information about this process.

 

If you don't have a downloaded file of transactions from the closed account, I suggest entering in the transactions manually or creating a .CSV document then following the process above to bring in the information. Otherwise, it's ideal to speak with an accountant to learn the best way to record the information you need in your account.

 

To give your accountant the ability to see what's happening in your QuickBooks by adding him or her as an accountant user. QuickBooks can also help you find an accountant if you don't have one through our Find a ProAdvisor tool directly in your account. Simply click the My Accountant tab to learn how you can use your postal code to find accountants near you.

 

I hope that helps. Don't hesitate if you have more questions!

Active Member

Re: Need to Connect Account Info for Closed Account

The solution you described doesn't seem to work for the QuickBooks Self-Employed site.  Is there a way we can do the same thing in the Self Employed site?

QuickBooks Team

Re: Need to Connect Account Info for Closed Account

Hi Furryber,

 

Great question! You're right, the solution I described above won't work for QuickBooks Self-Employed. Although QuickBooks Online and QuickBooks Self-Employed both work out of a browser and have similar features, their overall functionality is different.

 

To import older transactions into QuickBooks Self-Employed, you'll need a .CSV file of your old banking transactions, which you can then import using the following method.

 

  1. When logged in via browser, select the Gear icon at the top right.
  2. Choose Imports.
  3. Select the account you want to import the transactions into.
  4. Follow the instructions to complete the import process.

You'll note that unlike QuickBooks Online, there isn't a way to create a specific account to import the transactions into, so you may have to work it into one that's already available. Learn more about this process here: Import transactions form earlier date ranges

 

If you need a hand or have more questions, get in touch with our dedicated QuickBooks Self-Employed support team. From our Contact Us page, click QuickBooks Self-Employed and fill out the email form. An agent will be in touch via email within 1 business day.

 

I hope that helps! Enjoy your day. :)