cancel
Showing results for 
Search instead for 
Did you mean: 
trigrman
Level 3

How do I link to a bank LOC account?

I see that I can set up an account to represent a line of credit or loan, and of course there's a Paid Interest account to track interest. But if the line of credit or loan is at a bank, and I can connect automatically to that account, how do I set that up? Although I can see these accounts in the bank connection setup, there's no way to choose a loan or line of credit account type for them--I only see savings, checking, etc.
Solved
Best answer November 29, 2020

Best Answers
GlinetteC
Moderator

How do I link to a bank LOC account?

 Thanks for getting back to us and providing additional details to your concerns, trigrman. I'm here to lend a hand on how to handle this in QuickBooks.

 

Currently, LOC is not supported when connecting a bank account in QBO. However, I've got a workaround you may consider doing. You'll want to use the Credit Card account type as it is the same as a Liability account, that when balance increases, the payable also increases. Here's how:

 

  1. Click on the Gear icon and select Chart of Accounts.
  2. Select New in the top right corner. 
  3. Click on the Account Type drop-down and choose Credit Card.
  4. You have the option of including information in the Description field and an amount in the Balance field. 
  5. Hit Save and Close.

Then, once you connect the LOC account to a Credit Card account type, you can add those interest and expenses.

 

I've got you these articles for ideas to help manage your report and related tasks: Reports and Accounting for QuickBooks Online.

 

Don't hesitate to leave a comment below if you have other questions managing your transactions in QBO. I'm always here to help.

View solution in original post

7 Comments 7
Jen_D
Moderator

How do I link to a bank LOC account?

Thanks for joining the QuickBooks forum, @trigrman,

 

If you're unable to link your LOC account for online banking in QuickBooks, you may opt for manual import of transactions. You can request the bank to provide a CSV file of the bank statement where the line of credit are cleared. The following steps will guide you through the process:

 

  1. Still from the Banking menu, click the Link Account drop-down.
  2. Click on Upload from file from the options.
  3. Press Browse and choose the file you want to upload.
  4. Choose an account from the list, then Next.
  5. Follow the on-screen instructions to map the fields.
  6. Select the transactions to import.
  7. Click Yes then Let’s go.

Otherwise, you can do manual tracking of your line of credit. You can follow the steps found in this article for the steps: Set up and track a line of credit

 

If you want to put your credit funds into another account, you need to make a transfer. Use these steps:

  1. Press + New then select Transfer.
  2. Select the bank account that the funds are coming out from the Transfer Funds From drop down.
  3. For the Transfer Funds To drop down, choose the bank account the funds are being deposited into.
  4. In the Transfer Amount field, enter the amount being transferred.
  5. Update the Date.
  6. (Optional) Enter a description of the transfer in the Memo field.
  7. Hit Save and close or Save and new.

If you have additional questions about this, please let me know in the comment. I'll be right here to help you anytime.

trigrman
Level 3

How do I link to a bank LOC account?

You didn't really answer my question.

 

My LOC account shows up in the list of available banking accounts just fine.  But when assigning an account type, I'm only allowed to choose checking, savings and a few others--not any kind of liability account.  Is QuickBooks able to link to anything besides banking or checking accounts, or not?

MaryAnn_E
QuickBooks Team

How do I link to a bank LOC account?

Hi there, @trigrman.

 

Let me assist you in recording your liabilities. First, let's make sure you've set up a liability account to record the loan and its payments. I'll show you how:  

 

  1. Click the Gear icon.
  2. Choose Chart of Accounts.
  3. Select New.
  4. On the pop-up window, choose Other Current Liabilities or Long Term Liabilities for the Account Type depending on the type of your loan.
  5. Choose Loan Payable for the Detail Type
  6. Enter a name for the account.
  7. Click Save and close. 

 

​​​​​​For more detailed steps and information, you can refer to this link: Set up a loan in QuickBooks Online

 

The set of steps I've shared is a general way on how to record loans in QuickBooks Online. But I still recommend contacting your accountant for further accounting-specific help.

 

Keep me posted in the comment section down below if you have any other questions. I'll be always around ready to lend a helping hand. Have a great day!

 

trigrman
Level 3

How do I link to a bank LOC account?

This makes sense and I've done that.  However, that account is tied to an actual bank loan account, where things like interest are recorded.  I want to tie the liability account to the bank account so that those interest transactions are applied automatically.  How do I do that?

GlinetteC
Moderator

How do I link to a bank LOC account?

 Thanks for getting back to us and providing additional details to your concerns, trigrman. I'm here to lend a hand on how to handle this in QuickBooks.

 

Currently, LOC is not supported when connecting a bank account in QBO. However, I've got a workaround you may consider doing. You'll want to use the Credit Card account type as it is the same as a Liability account, that when balance increases, the payable also increases. Here's how:

 

  1. Click on the Gear icon and select Chart of Accounts.
  2. Select New in the top right corner. 
  3. Click on the Account Type drop-down and choose Credit Card.
  4. You have the option of including information in the Description field and an amount in the Balance field. 
  5. Hit Save and Close.

Then, once you connect the LOC account to a Credit Card account type, you can add those interest and expenses.

 

I've got you these articles for ideas to help manage your report and related tasks: Reports and Accounting for QuickBooks Online.

 

Don't hesitate to leave a comment below if you have other questions managing your transactions in QBO. I'm always here to help.

trigrman
Level 3

How do I link to a bank LOC account?

This seems as close to a solution as I'm going to get.  Still seems awkward, but I guess Intuit expects companies to be tracking liability-related balances and expenses more manually.  

JBSRQ
Level 1

How do I link to a bank LOC account?

What a waste.  So I can't connect to mortgage account to my chart of accounts I have to spoof it as a credit card?  The better engineers must be working for Fresh Books. 

Need to get in touch?

Contact us