Skip to main content
January 4, 2020
Question

When I connect to a bank loan account, how do I categorize it?

  • January 4, 2020
  • 5 replies
  • 0 views
The only option I get are, checking , cash etc. Nothing for a loan.

5 replies

BigRedConsulting
January 4, 2020

I don't think you can connect to a loan.  I've never heard of anyone doing that.

January 4, 2020

Hi there, VC bookkeeper.

 

QuickBooks Online doesn't have the option to connect bank loans. I suggest to manually enter the loan transactions in QBO. Before doing the steps below, I recommend contacting an accountant to help you categorizing the transactions.

 

Here's how to enter loan transactions:

 

First, set Liability account to record the loan:

 

1. Click the Gear icon and select Chart of Accounts.

2. Click the New button.

3. In the Account Type drop down list, select Long Term Liabilities. Take note that if you plan to pay off the loan by the end of the current fiscal year, select Other Current Liability. Otherwise, select Long Term Liabilities.

4. From Detail Type drop down arrow, select Notes Payable.

5. Give the account a relevant name, like "Loan for a car."

6. Enter the full loan amount as a negative amount in the Amount field. Since the future payments to the bank are a liability for your business, the amount should be negative.

7. Click the Save and close button.

 

One done, you can now record the money you got from the loan. please follow these steps:

 

1. Select the Plus icon and the choose Journal Entry.

2. On the first line, select the liability account you've created. Then enter the loan amount in the Credits column.

3. On the second line, select the appropriate asset account from the Account drop down. Then enter the same loan amount in the Debits column.

 

After that, please check this article for additional information and follow step 3 to finish the process: Set up a loan in QuickBooks Online.

 

Please check this article on how to assign multiple categories to a single transaction: Assign, categorize, edit, and add your downloaded banking transactions.

 

Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.

February 13, 2020

This isn't true unless they removed the functionality at some point.  I currently have a loan account connected in my bank feed.  I have had 2 others in there in the past as well (paid now).  I'm looking at my COA and it shows the current one as connected to the feed and that it is 233 "Long Term Liabilities" account.  That said, I'm here because I just refinanced some debt and am trying to connect a new loan with the same institution I have a past loan with (and had a connected bank feed for) and it isn't allowing it.  So I'm guessing there is either some work-around, or QBO reduced the feature set of the bank feed for some unknown reason.

 

I'm going to try connecting it as a different account and then re-assigning it once it's pulled in and see if that works.  I suggest the OP do the same if they haven't already found a different solution.

 

July 21, 2020

Is this a feature that could be added? Loan account transactions need categorizing only once..... a loan payment is a transfer from a bank account to a loan account. and an interest charge is interest expense.... with a webconnected account and properly set up rules quite a bit of work can be saved. 

Ashley H
July 21, 2020

Thanks for the feedback, @cmontenegro.

 

I'm going to pass this along to the Product Development Team about bringing in a feature to allow categorization with a loan transaction in the Banking Feed of QuickBooks Online, as I can see how this be beneficial by saving time and work. You can visit our Blog to see recent updates to our products, as well as seeing what's coming in the future.

 

If you have any further questions or concerns, please don't hesitate and reach back out! I'm here to help in any way that I can. Have a beautiful day.

October 13, 2020

Echo the last comment suggesting that loan/mortgage accounts become part of bank feeds.  Modern loan/mortgage accounts are just like bank accounts nowadays given they have offsets, redraws, and even debit cards so transactions can be processed directly onto a credit facility (like a credit card but not).  So these loans/mortgages are no longer set and forget with an amortization schedule.  That's where modern, contemporary banking is going.  Would be good for QBO to follow.  And would suggest with some priority.

April 7, 2021

Another item of note - usually PPP loans go through the same bank where the company has an account. When I try to connect the checking account to QBO, it won't let me continue until I also connect the loan. But the only option is to create it as a credit card, which it clearly isn't. Please resolve ASAP.

September 2, 2022

Has this been resolved in 2022. If not WHY? I want to see all my actual loans and LOC so I can accurately report on my business.

 

 

 

Rubielyn_J
September 2, 2022

Thanks for joining this thread, @MJHFAB. Let me provide an update about this matter.

 

As mentioned by my colleagues above, editing account type as liability isn't possible in QuickBooks Online (QBO). A liability account can't work as a bank account in QBO, thus, you can't make a transaction that has a liability as a bank account.

 

At times, we roll out enhancements based on our customer's requests. That being said, I suggest sending a recommendation to our product developers. They'll review this idea and might consider updating it in the future.

 

Here's how:

 

  1. Go to the Gear located at the top.
  2. Under Profile, click Feedback.
  3. Enter your recommendation and select Submit.

 

You can also utilize this link to check the status and keep you in the loop on our progress of your request: Customer Feedback for QuickBooks Online.

 

I also encourage you to visit this resource that will guide you in managing your accounts in QuickBooks: Set up and add accounts to your chart of accounts.

 

As always, leave a comment below if you have any other questions about categorizing credit card as a liability account in QuickBooks. I'm here to help always. Take care!

January 13, 2023

When will this be fixed? Need to be able to loan accounts from bank