I have a bank account which cannot be linked to QB, so I manually update it. How can I add it to my Transaction/Banking summary screen so I see the balance?

nagloc · ‎September 15, 2022

My bank does not provide electronic linking to QB for this type of account. It is a low volume account so manual updates are minimal. It is in my bank registry, but not showing up in my summary, or in my cash totals on my summary screen. The balance sheet is accurately accounting for the cash.

AlcaeusF · ‎September 15, 2022

Hi @nagloc,

I'm glad to see you reaching out to us here in the Community space. I can help you add the account in your Banking summary in QuickBooks Online.

Does your bank allow users to download statements in CSV or QBO format through their website? If yes, you can import the file into QuickBooks to trigger the system to show the account in the summary screen.

Here's how:

On the left navigation bar, click Transactions.
Go to the Banking tab.
Press the Link account or Add account drop-down.
Select Upload from file.
Add the downloaded file from your bank, then hit Continue.
Choose the existing account from your registry.
Follow the onscreen instructions until finish.
View the Banking summary.

If the option to download is unavailable, enter your transactions manually in Excel and save the file in CSV format. During the import process, make sure to select the existing bank account you have in the chart of accounts.

There's a specific format and file size to upload bank data successfully. I've attached an article you can use to learn more about how it works in QuickBooks: Manually upload transactions into QuickBooks Online.

Let me know if you have more questions about adding the bank account to bank feeds. I'll keep an eye on your response. Have a great day.

View solution in original post

AlcaeusF · ‎September 15, 2022

Hi @nagloc,

I'm glad to see you reaching out to us here in the Community space. I can help you add the account in your Banking summary in QuickBooks Online.

Does your bank allow users to download statements in CSV or QBO format through their website? If yes, you can import the file into QuickBooks to trigger the system to show the account in the summary screen.

Here's how:

On the left navigation bar, click Transactions.
Go to the Banking tab.
Press the Link account or Add account drop-down.
Select Upload from file.
Add the downloaded file from your bank, then hit Continue.
Choose the existing account from your registry.
Follow the onscreen instructions until finish.
View the Banking summary.

If the option to download is unavailable, enter your transactions manually in Excel and save the file in CSV format. During the import process, make sure to select the existing bank account you have in the chart of accounts.

There's a specific format and file size to upload bank data successfully. I've attached an article you can use to learn more about how it works in QuickBooks: Manually upload transactions into QuickBooks Online.

Let me know if you have more questions about adding the bank account to bank feeds. I'll keep an eye on your response. Have a great day.

nagloc · ‎September 16, 2022

Thank you. It worked and the bank account is now showing on my page, with one wrinkle:

The balance is showing as $0.00, where as the chart of accounts shows the bank with a positive amount. I'll explain what I did:

bank account in QB was uptodate and reconciled, so I created a CSV file with two dummy and offsetting transactions.
Both were for the same day, $0.01 and -$0.01 so they offset
Successfully uploaded the CSV file, followed the rules. All went well.
My dummy transaction appear correctly in the chart of accounts for the bank, but balance on the Bank Transactions summary page appears $0.00

Any ideas? Do I need to import ALL transactions for this bank, even the ones already in the QB ledger?

Thanks

ChristieAnn · ‎September 16, 2022

Welcome back to the thread, nagloc. I'll be sharing troubleshooting steps so you'll be able to manage your transactions smoothly. Then, ensure that they'll appear as balance on the Banking and Chart of accounts section.

The amounts displayed on the Banking page and the register section should match. Since this isn't the case, the cache files may be affecting the program's performance, causing the unexpected behavior.

I suggest logging in to your QuickBooks account using a private browser. This is to rule out the possibility of a webpage issue and ensure private browsing doesn't store local files or cache. Please know that importing all transactions from the bank isn't needed in the process.

Use these keyboard shortcuts based on the browser you're using:

For Firefox or Microsoft Edge, press Ctrl + Shift + P.
For Chrome, press Ctrl + Shift + N.
For Safari, hold down Command + Shift + N.

If it works in incognito, you'll need to clear the cache of your regular browser. This clears the history or log of sites so you can start with a clean slate. If the steps above didn't work, use another supported browser as an alternative.

Lastly, you may refer to this article to see various guidelines that can help you fix any reconciliation issues: Learn the reconcile workflow in QuickBooks.

Let me know if you need further assistance or any clarification about handling transactions in QBO. I'm always here to provide extra information and help. Have a great day, nagloc.

nagloc · ‎September 16, 2022

I tried the private browser (Firefox) and used a new browser in private mode (Edge) and saw no change in balance discrepancy. I'll read the reconciliation article and see if this helps. Thanks.

Fiat Lux - ASIA · ‎September 16, 2022

Another option, utilize MT Online as a workaround. It is designed to import into any bank or credit card in QuickBooks Online, so there is no specific setting needed.

https://www.moneythumb.com/?ref=110

Topics

Training

Community

Resources

I have a bank account which cannot be linked to QB, so I manually update it. How can I add it to my Transaction/Banking summary screen so I see the balance?