cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Can I set up a Bank Account without connecting online@ If so how? Thanks.

I don't want to use online  banking yet but wish to manually process my bank transaction.

How do I set up a bank account to do this?

Thanks

Solved
Best answer 02-07-2019

Accepted Solutions
Super Contributor *

absolutely.  just click accounting>chart of accts.>new an...

absolutely.  just click accounting>chart of accts.>new and add the new bank acct.

View solution in original post

22 REPLIES 22
Super Contributor *

absolutely.  just click accounting>chart of accts.>new an...

absolutely.  just click accounting>chart of accts.>new and add the new bank acct.

View solution in original post

Not applicable

This is easy, but my un-connected bank does not show up o...

This is easy, but my un-connected bank does not show up on Banking screen (at the top).  Is there a way to correct this?
Not applicable

???

???
Not applicable

Anyone have an answer for this? With multiple accounts an...

Anyone have an answer for this? With multiple accounts and banking with Wells Fargo they charge monthly to connect an account with very little activity, quickly done manually. You can view the account from dashboard, doesn't show up in Banking,  and how do I link transactions between connected and unconnected accounts? Starting to wonder if I need to stick with the desktop version as I'm finding many features are undeveloped in QBO product, which is a premium price for small business.
mr2
Not applicable

ANYBODY?

ANYBODY?
Not applicable

I would appreciate a response to this one as well

I would appreciate a response to this one as well
Not applicable

Re: Anyone have an answer for this? With multiple accounts an...

Yes once the bank is in your chart of accounts all you need to do to get it in the Banking page is upload a manual QBO file to that account.

 

  1. Add bank to chart of accounts
  2. Get a manual QBO file from bank.
  3. Go to banking page and click File upload
  4. Browse to file and click next
  5. Then choose your new manual bank from the drop down and click next
  6. This will upload the transactions to the new bank and it will then be visible on the Banking page. Now you can do file uploads from the Banking page. This is the best way so you do not have to enter bank online account info.
Not applicable

Re: Anyone have an answer for this? With multiple accounts an...

Hi ,

 

According to the steps give, have added bank to COA, but it doesn appear on the banking page. Anyone help. 

 

We dont want to set up bank feed, just to manually upload the bank transactions to the bank account.

Not applicable

Re: Anyone have an answer for this? With multiple accounts an...

Yes, in order to actually see the bank show up you "must" do a manual file upload "first" after adding to COA. Get your QBO file ready to upload, then go to Banking page, click File upload. Then it takes you to a page to browse and add file. Then choose the Bank you added to COA from the drop down in the account list on the File upload page"it will show up there" After you successfully go through all the manual upload steps and get it completed it will show up on Banking page.

Not applicable

Re: Anyone have an answer for this? With multiple accounts an...

Great, helpful. Thank you!

Not applicable

Re: ANYBODY?

When creating the Bank account make sure the "Account Type" is "Cash and Cash equivalent" or "Cash at Bank"  and the "Detail Type" is Bank.  Then go ahead and name the Account and save. The Account will appear on the Dashboard view under Bank Accounts.

QuickBooks Team

Re: ANYBODY?

Hello there, @Rafiki, 

 

Thanks for sharing additional answer to the dfcassociates' question above. Other users will find this as helpful if they experienced the same issue. 

 

For more information about connecting your account in the program, here's the article you can refer to: Add Bank Accounts

 

Cheers to you, @Rafiki! Have an awesome day. 

Not applicable

Re: ANYBODY?

Hi,

 

I do not have an option to set the "Detail Type" to Bank. Do I need to import the transactions file as well? 

 

QB, Why is this not a simple documented process????!!!! Why do we have to rely on other users for this info? If it's documented, QB, please post a link.

 

Thanks

Stuart

QuickBooks Team

Re: ANYBODY?

Hello there, StuartBR.

 

Thanks for reaching out to us. Let me guide you through in adding bank account in QuickBooks Online.

 

You should be able to see the Detail Type option when you add/edit a bank account in QBO. Here's how you do it:

  1. Go to Accounting.
  2. Choose the Chart of Accounts tab.
  3. Click New.
  4. Enter the Account Type, Detail Type, Name and other necessary information.
  5. Click Save and Close.

0.PNG

 

If you're still unable to see the Detail Type option, let's perform some browser troubleshooting steps. First, try using a private browser and repeat the steps above. If it works, I recommend clearing the cache in your internet browser. The cache can get jammed up with older data from time-to-time, potentially causing errors in QuickBooks Online. Otherwise, use a different browser.

 

Please don't hesitate to let me know if you have further questions aside from setting up a bank account in QBO. I'd be glad to help you out.

Not applicable

Re: ANYBODY?

Hello @Charies_M,

 

I am attempting to follow your instructions related to adding a bank account manually, however, do these steps apply to editing existing bank accounts?  I want to edit the "Balance as of" information, but I do not see that option.  

 

Can you kindly help me out?  Thank you.

 

Nathaniel R 

Moderator

Re: ANYBODY?

I'm glad to help, nathanielr.

 

Thanks for following the steps shared by my colleague above.

 

As long you haven't reconciled the bank account, you should be able to edit the balance anytime. Please click the Account history option to do this.

 

I'll show you how:

  1. On the left pane, click Accounting and select Chart of Accounts.
  2. Locate the bank and hit Account history on the leftmost part of the screen.image.png
  3. Look for the transaction that has an opening balance memo and update the deposit amount.
  4. Tick the Save button.

image.png

However, if you have reconciled the account, the opening balance also change. To fix this, please follow the steps below:

  1. Go to the Gear icon and select Reconcile on the pop-up window.
  2. Select the account and hit the Resume reconciling button.
  3. On the Reconcile page, select Edit info.image.png
  4. Update the Ending balance amount and tick Save at the bottom.

image.png

The ending balance on the reconciliation window also your account's opening balance.

 

The complete steps about updating the account's balance can be found in this article: How to resolve reconciliation differences.

 

For additional insights about changing the balance of a bank account, please refer to this link: How to change the opening balance of a bank account.

 

Please leave a comment below if you need any further information. I'm always here to help. Have a good one.

Not applicable

Re: ANYBODY?

Hi @PreciousB ,

 

Thank you for all of this information.  Unfortunately, I do not have a line item for the opening balance as I never the connected the account at all.  My first line item is an expense that I manually entered.  

 

What should I do? 

Moderator

Re: ANYBODY?

Thanks for coming back to the Community, nathanielr.

 

If you haven't entered an account's opening balance, the beginning balance in the reconciliation window is caused by the reconciled transactions.

 

All transactions that have letter R in the Clr column are added to the opening balance. If you have a transaction (with R) that is not on the statement, you'll have to change it's status since it shouldn't be reconciled.

Here's how:

  1. Click Accounting on the left pane, then choose Charts of Accounts.
  2. Locate the account and click Account history to open the l.
  3. Look for the transaction and repeatedly click the box under the  column.
  4. Select the appropriate status of the transaction:

        C - Cleared
        R - Reconciled
        Blank - Not cleared or reconciled

  5. Lastly, click Save.

image.png

Check out these articles to reconcile the account accurately:

Let me know if you need anything else by leaving additional details below. I'm here to take care of you.

Not applicable

Re: Anyone have an answer for this? With multiple accounts an...

I am having the same problem - one connected bank shows and the unconnected bank does not.

since it is not on the banking page, I cannot manually upload transactions. I am stuck! 

QuickBooks Team

Re: Anyone have an answer for this? With multiple accounts an...

Thanks for joining this thread, @Michael_Vowles.

 

Let me help share on how to upload banking transactions in QuickBooks Online (QBO). 

 

You can use the WebConnect feature to download the bank transaction from your bank website and import them into QuickBooks Online (QBO). To do this, you can follow the detailed steps in this article: Manually upload transactions into QuickBooks Online

 

If you need further assistance with the steps, I recommend contacting our QuickBooks Online Support Team. They have additional tools to pull up your account and do a remote session. 

 

Here's how to contact our customer support:

  1. Sign in to your QuickBooks Online company.
  2. Select Help (?) at the top right.
  3. Select Contact Us to connect with a live support agent.

This should get you on the right track. Fill me in if you have additional questions about downloading bank transactions. Have a good one. 

Not applicable

Re: Anyone have an answer for this? With multiple accounts an...

Hi, unfortunately not. Can you please respond to my question of whether I can have two banks - one connected and one manual?  I had two manual banks, both worked with uploading the csv file. I then connected one bank - it still appears on the dashboard.  The bank that remained manual has disappeared from my dashboard and is not visible under Banks either.  I cannot upload anything manually.  How do I get it to appear on my dashboard again? How can I upload a csv file again? Thanks

michael

 

QuickBooks Team

Re: Anyone have an answer for this? With multiple accounts an...

I appreciate you getting back to us, @Michael_Vowles.

 

The possible reason why the bank doesn't appear on the dashboard is that the bank account isn't listed or inactive from the Chart of Accounts. Let's make sure that the bank account is listed or active from the Chart of Accounts to make it appear on the banking dashboard.

 

Here's how to verify:

 

  1. From the left panel, click Accounting.
  2. Select Chart of Accounts.
  3. Click the Gear icon on the page.
  4. Put a check-mark beside Include inactive to show all inactive accounts.
  5. Look for the bank account name.
  • If the account is not on the list, you can create a new bank account.
  • If you found the account inactive, simply click Make active under the Action column.

Once verified, I'm confident that the bank will appear on your banking dashboard. You can now also upload a CSV file again from that bank. For your reference, you can check out this article for the detailed steps and information: Manually Upload Transactions into QuickBooks Online.

 

You might also want to read this article to learn how to match downloaded transactions: Add and Match Downloaded Bank Transactions.

 

Drop me a reply below if you have other questions on uploading bank transactions in QuickBooks. Have a great rest of your day.