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.
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.
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.
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.
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.
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.
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:
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.
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.
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:
However, if you have reconciled the account, the opening balance also change. To fix this, please follow the steps below:
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.
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?
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.
C - Cleared
R - Reconciled
Blank - Not cleared or reconciled
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.
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!
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:
This should get you on the right track. Fill me in if you have additional questions about downloading bank transactions. Have a good one.
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
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:
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.