Skip to main content
September 19, 2023
Question

Have any questions for our team about Bank Connections?

  • September 19, 2023
  • 69 replies
  • 0 views

 

We’d love to support you on your journey with bank connections.

 

If you’ve got any questions, select ‘reply’ to post a question in this thread and have your questions answered by qualified QuickBooks Online experts.

 

Hopefully, you’ll help other QuickBooks users with the same questions out in the process!

 

Did you check out our Connect and manage your bank account in QuickBooks Online help article?

 

69 replies

December 29, 2023

I used to be able to pay my vendors through online payments using QB and 'Direct Connect" with Citizens Bank in Massachusetts. Citizens bank ceased supporting Direct Connect. I had been told that TD Bank in Massachusetts continues to support Direct Connect with QB desktop. My questions:

1. Does QB Desktop Pro Plus 2023 still support Direct Connect with banks that provide it?

2. Has QB implemented its own change such that onlne bill pay can now only be done in QB using Melio and Direct Connect is no longer supported by QB?

3. Does TD Bank in Boston still support the old Direct Connect method that I have used a few years ago?

Thank you.

January 8, 2024

My bank accounts connect and show the balances however the transactions do not display.

Can you please assist?

 

January 8, 2024

Welcome to the Community, KSanMac!

 

Let's get your bank connection sorted out to help you get back on track. 

 

If you're bank account is connected through the Standard feeds connection, let's enter your bank's sign-in info to update your bank connection in QuickBooks Online. Here's how:

 

  1. Click on the Transactions tab, and click on Bank transaction.
  2. Select the bank you need to update.
  3. Click on the Edit or pencil icon.
  4. Click on Edit sign in info.
  5. If your web browser auto-fills the user ID and password fields, clear them. This ensures your browser doesn’t put in old info by mistake.
  6. Manually type in the user ID and password for your bank account.
  7. Click on Save and connect.

 

If you're bank is connected through Direct feeds connection, use the steps below to refresh connection. 

 

  1. Click on the Banking transactions tab.
  2. Click on the bank account to update.
  3. Click on Refresh button.

 

Then, check if your bank transactions have downloaded and is showing in the For review.

 

If the bank transaction still did not update, you can manually upload CSV file for the missing bank feeds. Refer to this link to import bank transaction: Manually upload your transactions, receipts, and bills into QuickBooks Online.

 

Post again in the Community if you have further banking concerns. I'll be around to help you.

January 9, 2024

Hi KSanMac,

 

Thanks for joining the thread. Let's perform a bank sign-in info in QuickBooks since your bank updated your log in details. Here's how: 

 

  1. Log in to QuickBooks Online.
  2. Click on the Transactions tab, and click on Bank transaction.
  3. Select the bank you need to update.
  4. Click on the Edit or pencil icon.
  5. Click on Edit sign in info.
  6. If your web browser auto-fills the user ID and password fields, clear them. This ensures your browser doesn’t put in old info by mistake.
  7. Manually type in the user ID and password for your bank account.
  8. Click on Save and connect.

Then, check if your bank transactions have been downloaded. If the issue persists, let's use a new incognito window of your browser and use the steps above to update your bank connection.

 

Feel free to post in the Community if you have other questions. I'll get back to you as soon as possible.

January 9, 2024

Hi

I am unable to download via standard feed since Bendigo Bank updated my login yesterday.  How do I reconnect the accounts?  I don't want to change to Direct Feeds either. 

 

Thank you. 

January 12, 2024

Does anyone know where I can find the form I fill in so that Quickbooks can communicate with my bank so i can get a direct feed for my transactions? 

January 12, 2024

Welcome to the Community, BB065!

 

In order to obtain and complete the client authority form, simply click on Preview form at the end of the direct feeds enrollment set up. This will allow you to print the form and  Here's how:

 

  1. Click on the Transactions tab.
  2. Click on Bank transactions, click on Link account if you have connected one in the past.
  3. Search for your bank, and click on Get direct bank feeds.
  4. Enter your bank account details and make sure it matches with your bank.
  5. Select the bank account, and click on Connect and a Client authorisation form will be created.
  6. Click on Preview form.
  7. Print and hand-sign the form and then scan and email them to Intuit SISS email: Email: [email address removed]
    Subject: QuickBooks Bank Feed Request
    OR
    Mail: SISS Data Services Pty Ltd
    Locked Bag 3060
    Crows Nest, NSW, 1585

You can also check this link to learn more about: Direct bank connections with QuickBooks Online | FAQ.

 

Post again in the Community if you have further concerns. I am around to help you.

January 15, 2024

Hi, I have been successfully doing manual uploads of csv files from my bank account into QBO every fortnight.  This morning I have attempted to do so, but QBO will not allow me to select a bank account. No options appear in the dropdown box. The csv format meets your requirements (nothing has changed from my last upload on the 5th January). 

January 15, 2024

Hi Deej1,

 

Let's check your CSV file making sure it follows the allowed format to upload in QuickBooks Online. Let's use the steps below to check your CSV file.

 

  1. Open a new Excel/CSV file and copy the existing CSV data to the new sheet.
  2. Save the new Excel file, making sure the company name does not have spaces and special character on them.
  3. Click on Save.

Furthermore, kindly check if there is no other header name on your CSV file and verify if you have a 3 column or 4 column format CSV file.

 

I recommend checking this link to help you fine tune your CSV file and help upload in QBO: Format CSV files in Excel to get bank transactions into QuickBooks.

 

Post again in the Community if you have further concerns.

January 29, 2024

Our "Standard" BankFeed to ANZ Transactive Global accounts stopped working on 27th November 2023 with Error 103, it had been operating fine since March 2020. Since November i have had several conversations with QB customer support team, initially advising QB doesn't support "standard" feed to ANZ Transactive Global and we need to apply to ANZ for "Direct" Feed, then 2 weeks ago advised we need to reconnect via "Standard" feed.   We tried on multiple occasions and continually receive error 101.  During this 8 week period we have shared our screen with QB customer support team using their smart look tool, so they can see the issue firsthand.  On the 17th January they reported this to the "engineering Team" who will contact me.  With no response i called again 23rd January and was told to wait for engineering to contact me. There has been no change to our ANZ account login except we added ANZ Digital Key which was activated 6 weeks prior to the BankFeed issue we now have.  Appreciate if you can help expedite a solutuion, thanks.

January 30, 2024

Hi Mickmoore,

 

I understand you're having fundamental issues with your ANZ online banking connection. I can see the support case created was raised to our banking team to help check the account connection. I would recommend contacting back to our Customer Care Team. Since we are in a public space we're unable to ask for your details for security purposes.

 

I've included the steps to contact support below.

 

  1. Click the (?) Help icon in the upper right-hand corner of the dashboard.
  2. Select Talk to a Human.
  3. Enter a short description of your concern and press Enter.
  4. Click I still need a human.
  5. Select Contact Us to connect with our live support.
  6. Choose Get a callback.


In the meantime, you can manually enter your transactions or manually import them using a CSV file upload.

Post again in the Community if you have further concerns.

January 30, 2024

Thanks, I have contacted customer service again today and can advise we now have Standard Bank Feed back in place, unfortunately the whole process has dragged on for 8 weeks and they told me today the engineers resolved this on January 18, that's 4 days before my last call to QB and i have received no advice except to wait for our email to respond to you.

February 11, 2024

How can I switch off the default to "replace bank Memo" when creating a new bank rule directly from the transaction screen?  Thanks 

February 12, 2024

Thanks for your post, kylie1.

 

To turn off the "Replace Bank Memo" feature in the bank rules of QuickBooks Online (QBO), follow these steps:

 

1. Log in to your QBO account and click on the "Accounting" tab.
2. From the drop-down menu, select "Banking".
3. Click on the "Rules" tab.
4. Find the rule that you want to edit and click on the "Edit" button.
5. Scroll down to the "Replace Bank Memo" option and toggle it off.
6. Click on the "Save" button to apply the changes.

 

That's it! Now the "Replace Bank Memo" feature will be turned off for that particular bank rule in QBO.

February 16, 2024

I just linked my bank account for the first time, can I link it back further than 90 days? I'm looking to go back to January 1, 2023. 

February 16, 2024

It's great to see you here in the Community, @RBB37. Let me share some insights about bank connections.

 

Please note that you can't download bank transactions older than 90 days in QuickBooks Online (QBO). However, you can manually upload them. I can guide you through the process.

 

Before uploading the transactions, you can select a start date, get transactions from your bank, and review the file format and size. For more information, visit this article: Manually upload your transactions, receipts, and bills into QBO.

 

Then, to manually upload your transactions, follow these steps:

 

  1. Go to Transactions, then choose Bank transactions.
  2. Select the blue tile for the account you want to upload the transactions to.
  3. Click the Link account dropdown and then Upload from file.
  4. Choose Drag and drop or select files, then pick the file you downloaded from your bank. Then, select Continue.
  5. Choose the account you want to upload the transactions into in the QuickBooks account dropdown. Then, select Continue.
  6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then, click Continue.
  7. Choose the transactions you would like to import. Then, select Continue.
  8. Click Yes.
  9. When you've accepted your transactions, hit Done.

 

After this process, you can categorise your transactions and reconcile your accounts to ensure your financial data is organized and accurate.

 

If you have any further concerns apart from your bank account, feel free to leave a reply. We're always ready to back you up.

February 17, 2024

Currently, a few of my Clients financial institutions (BofA and 1stBank (of Colorado)) do not allow Quickbooks file extension .QBO for personal bank accounts or personal credit card accounts. This is causing a huge issue with a few new Clients I need to set up and populate all 2023 transactions.  How can I convert the .QIF files into .QBO files?  Please advise.

February 17, 2024

Hello, @LeeBthatsMe. Thank you for participating in the conversation.

 

To convert your .QIF files to .QBO files, you can utilize a third-party converter tool. This will enable you to manually import the files into QuickBooks. You can find the appropriate app in the QuickBooks Apps store  or through other sources.

 

You can also search for the tool inside your QuickBooks Online account. Simply go to the Apps menu, then click Find apps and search for the application.

 

Once your files are converted, you can refer to this article for guidance on uploading your transactions into QuickBooks Online: Manually upload your transactions into QuickBooks Online.

 

After importing your transactions into QuickBooks, you can now categorise them. This way, they would reflect in your bank's register.

 

If you have any further questions about importing your banking data into the program, feel free to ask. I'm here to assist you. Have a great day!

March 1, 2024

Good morning.  I have four bank accounts connected to a bank feed.  If I select an account other than the default 1-1113 St George, so that I can match transactions, the account at the top continually defaults back to 1-1113 St George.  The transactions for the other account will display, unless I try to sort them, and then it is reverting to any transactions for 1-1113 St George instead.  This has only recently started.  Has anyone else had this issue?

March 1, 2024

Thanks for letting us know your query when managing bank connections and matching transactions in your account, kuluin14. I can provide insight to help rectify this behavior, so you can get back to business seamlessly.

 

In QuickBooks Online, recent downloaded entries are dependent on the information sent from your bank account. As per checking, we haven't received similar cases or reports of this unusual behavior in your banking feeds. I understand the inconvenience this has brought to you when managing transactions in your file.

 

For now, you may want to access your account and perform troubleshooting steps using a private browser. This way, you can rule out the possibility of a webpage issue and allow the program to run without storing the cache. To do this, refer to these shortcuts to open an incognito window:

 

  •   For Google Chrome browser: Ctrl + Shift + N
  • For Mozilla Firefox browser: Ctrl + Shift + P
  • For Safari browser: Command + Shift + N

 

However, if the issue persists, it's best to reach out to our Customer Care Team to have your account reviewed. This allows our experts to perform real-time assistance, conduct further research on your banking feeds, and create an investigation ticket if necessary.

 

Here's how to reach them:

 

  1. Go to the Help icon and choose the Search tab.
  2. Select Contact Us.
  3. Describe your concern and click Continue.
  4. Choose between Chat with us and Have us call you.

 

Moreover, I'm sharing these resources to help you manage online bank transactions and review them to the correct accounts: 

 

 

This forum will always be available whenever you require additional assistance managing bank entries in your account. Just let me know anytime below, and I'll make sure to get you covered. Keep safe and have a good one!