Unable to link a mortgage loan account to my business. When I try to connect the account, the only two types are bank and credit card. This account is neither.

Thanks for visiting the Community, @rhonda24.

You may be trying to link your mortgage loan account on the Banking page, that's why you only have Bank and Credit Card in the drop-down. Since these are the only options to choose from, you can manually set up the liability account in the Chart of Accounts instead.

Here's how:

1. In QuickBooks Online (QBO), go to the Accounting menu at the left pane to get to the Chart of Accounts.
2. Tick the New button at the top right.
3. In the Account Type drop-down, pick Long Term Liability.
4. Enter the Detail Type and Name.
5. Once done, hit Save and Close.   

For further guidance with the process, refer to this article: Add an account to your chart of accounts in QuickBooks Online.

Just in case, I'll add these articles for future reference:

• Connect bank and credit card accounts to QuickBooks Online.
• Manually upload transactions into QuickBooks Online.

Leave a comment below if you have any other questions or concerns. I'm always here to answer them. Take care and have a great day!

I know how to create an account in the chart of accounts, but I need to link the separate mortgage account in QBO. This is what I'm not able to do because I don't have the right account type in the drop down. If I try to use a new bank account, I get a message that says I already have one. 

Hi rhonda24. Only Bank and Credit accounts can be linked via direct feed. A long term liability account will have to be added and tracked manually using the steps that FritzF provided above. The best workaround would be to use the credit card since a credit card is also a liability, the accounting will remain the same in this account type. Let me know if you run into anything else, I'll be happy to help. Have a great day. 

With this solution it is now a ST Liability instead of LT.  Does quickbooks really have no solution to this?  Seems crazy.

I'll help with your mortgage transactions, wwgipson.

While you can set up a long term liability account, you can't connect it to Online Banking. As a workaround, you can download your transactions from the bank as a CSV file. Then, import them into QuickBooks Online. 

Follow these steps on how to import a CSV file: 

1. Go to the Banking menu or Transactions menu and proceed to the Banking tab.
2. Click the drop-down list beside Update or Link account, then File upload or Upload from file.
3. Click Browse and look for the CSV file.
4. Click open and follow the succeeding prompts to upload the file.

Now that your transactions are uploaded, you can now match and categorize the transactions. 

Please don't hesitate to add another reply if you have other questions while categorizing your transactions. 

I was having the same problem trying to link our line of credit and mortgage. Seems like something QB would easily be able to solve. 

...Especially since you can do it in Mint, which is a free intuit product.

I would also like to import mortgage activity from banks since I have 15 mortgages I follow for various businesses that I do bookkeeping for.  Being able to link them to get principal and interest that could update the JEs would be very helpful!

I appreciate you for joining the thread, @proactivecary.

I'm here to share with you some additional information about importing bank transactions to QuickBooks Online.

At this time, you can upload your bank activities or transactions to QuickBooks manually via an Excel CSV file. You can follow the suggested steps provided by JenoP above as your references. Or, check out these links:

• Format CSV files in Excel to get bank transactions into QuickBooks
• Manually upload transactions into QuickBooks Online

On the other hand, if you want to enter them through a journal entry, I would recommend seeking assistance from a professional accountant for further assistance. They are the ones who can help you with picking the correct accounts for your journal and record the mortgage activity correctly.

Once your transactions are added to QuickBooks, you can review and categorize them. You can use this article as your guide: Categorize and match online bank transactions in QuickBooks Online.

If you have any other questions about adding your banking transactions to QuickBooks, please let me know by adding a comment below. I'm more than happy to help. Have a good one!

I had a loan account with our bank (in addition to a current account) and until recently this was linked to QB.  However, following the recnet instruction to disconnect and reconnect accounts I cannot now connect this account.  When I login to the bank to connect the account it doesn't appear in the list of available accounts.  No idea why this has changed.

I'm here to ensure you're able to reconnect your account in QuickBooks Online, @jason_living.

There are possible reasons why the account doesn't appear on the lists. Here are a few of them: 

• Your bank may have various names on our list. Search by the banking sign-in URL to assure you are using the correct listing.
• Your financial institution does not connect to all types of accounts (for example, personal accounts vs. business accounts).
• Your bank may not be a participating financial institution.

To fix this, make sure the spelling is the same as it appears on your bank's website. Then try other versions of your financial institution that are listed:

1. Select the Banking menu.
2. Click Add account.
3. Input the name of your financial institution and choose it from the list.
4. Select the link to go to your bank's website to open a new window.
5. Make sure you can access your account through this site. 
6. If you can access everything, sign out of the financial institution's website.
7. Go back and continue to add the account in QuickBooks Online.

If you have tried all the options and your account still doesn’t appear. I suggest requesting support from your bank. For detailed steps, please review Step 3 in this article: Find your bank or credit card account when you connect to online banking.

Once everything seems fine, you can reconnect your account in QuickBooks Online. Then, review and categorize them to avoid any duplicate transactions. 

Keep me posted if you have any other questions about connecting your bank to QuickBooks Online. I'll make sure to get back to you as soon as I can. Have a great week ahead.

To the QBO customer service, you all are saying the same thing but not addressing the actual issue.

We are aware that we can upload via CSV, thats not the issue. 

All that needs to be done is add one more line to the drop down list of Bank and Credit card under Account type. Add Mortgage and Line of Credit. Also, allow these accounts to be added as subaccounts on long term loans.

To the community, we possibly could add these accounts as Credit Cards for now and just recategorize them as we categorize items. Sounds like a simple fix.

It is ridiculous that you cannot connect a long-term liability through bank feeds.  The reason we use QBO is specifically for the bank feed feature.  These workarounds are stupid!  If I wanted to manually download and upload bank feeds (a huge waste of my time), I would use desktop and not have to pay a monthly subscription.  You need to get this fixed.  Especially for accountants, you kill our revenue when we have to do all of this manual nonsense just to get transactions into QBO.  Any the response above from QBO was pathetic.  Clearly, you did not read or understand the question - completely unhelpful.  Many users on here are accountants (and most are ProAdvisors) who have been working in QBO for YEARS.  We only post on here when we have an important issue we can't resolve (trust me, we have already tried ourselves before we posted here).  Please help get this fixed.  The fact that you don't even understand the importance or logic behind it is mindboggling!

Thanks for joining this thread to share your sentiments, @TXUser13.

I completely understand the urgency of having to connect a long-term liability through bank feeds. I'll make sure your request reaches our product engineers so they can take a look and consider adding this option in the future. 

I'm also encouraging you to do the same by presenting your suggestions directly to them. 

Here's how:

1. Select the Gear icon at the top, then click Feedback.
2. Enter your comments or product suggestions. 
3. Select Next to submit your request.

Leave a comment below if you have any follow-up questions. I'll get back to you right away.

Thank you for the note back.  I will and already use the suggestion feature often.  Some items seem so basic and necessary.   But I appreciate your response.  Thank you.

I am trying to get started as a QBO user running a business in real estate, specifically buying apartment buildings and renting long-term. It's all about the mortgages. The news that QBO can't connect to a mortgage account is, well, sickening. Makes me feel like I've wasted a lot of time and money already. The workarounds are absurd: either I miscategorize the loan as as credit card -- useless, as then I'll have to recategorize payments and interest by hand etc -- or I download and upload csv files, manually relabelling and so essentially re-entering all the data. Or I just enter the date by hand anyway, although I'm warned that only an accountant should do that. I can't believe I got suckered into this! I suppose I'm stuck with the sunk cost of my time, effort and money as I prepare this round of reports and taxes, but after that, I'll cancel my QBO and use apartments.com, stessa or another app that recognizes mortgages as, uh, kinda important to many businesses.

i was able to link my mortgage account to long term liability account, but when I go to categorize the transactions I get an error saying I need disconnect or change it to a credit card/bank account. Is this the same issue everyone was having previously? Any workaround?

@JBVan, If you want to link a mortgage loan account on the Banking page, your only options in the drop-down are the Bank and Credit Card.

Worry not. I'm here to help you manually set up a liability account in your Chart of Accounts. Here's how:

1. In QuickBooks Online (QBO), go to the Accounting menu at the left pane to get to the Chart of Accounts.
2. Select the New button at the top right.
3. In the Account Type drop-down, choose Long-Term Liability.
4. Enter the Detail Type and Name.
5. Once done, click Save and Close. 

For detailed information, refer to this account: Add an account to your chart of accounts in QuickBooks Online.

You can utilize this article for future reference: Manage default and special accounts in your QuickBooks Online chart of accounts.

If you have any other QuickBooks-related questions, please post them in the Community. We are always available and eager to assist you with your inquiries. Have a wonderful day.

When I went to link my mortgage account, it did allow me to select a Note payable account /liability account. I transferred all the transactions via bank feed into the liability account, the only issue is when I try to categorize the transactions...saying there is only the bank or credit card drop down option is not accurate, however allowing the liabilty accounts to be selected and then not having the actual categorization portion work is very misleading.

I got the same issues. Using the bank feeds from mortgage account is to save time. Now, I cannot categorize the transactions into the right accounts.

Everytime you will have this error:

This account is set up as a liability account. To accept this transaction, either disconnect the account or change its category type to bank or credit card.

Is this Quickbooks Online a testing product?

Welcome to the QuickBooks Community, Dan1001. I can see how vital it is to link your Mortgage loan account to QuickBooks. I'll ensure you can send a suggestion so it'll be forwarded to the Product Development Team. 

As mentioned above, you only have the option to choose either Bank or Credit Card when linking your mortgage account in QuickBooks. This is why you receive the error message suggesting you disconnect the account or change its category type to bank or credit card.

I recommend following the workaround provided above to manually create a liability account in your Chart of Accounts. This ensures that your transactions can be recorded and monitored.

Additionally, I also suggest sending feedback so you can request having the option to link a mortgage loan account on the Banking page in QBO. 

Here's how:

1. Select the Gear icon at the top, then Feedback.
2. Enter your comments or product suggestions. 
3. Choose Next to submit feedback.

Once done, please know that any recommendations are sent to our engineers for consideration in future updates.

Lastly, I'm adding this article if you need help in customizing your chart of accounts: Learn about the chart of accounts in QuickBooks Online.

Feel free to click the comment section below if you have other concerns with regard to connecting accounts in QBO. I'll be sure to get back to you. Have a good one, Dan1001.

Thanks for your reply.

Any staff monitoring this forum have the responsibility to feedback our difficulties, not the Client.