cancel
Showing results for 
Search instead for 
Did you mean: 
MBM29
Level 1

How do I set up and track a line of credit

I am using Quickbooks Desktop Pro 2017.  How do I set up a line of credit.  We will be transferring money from a line of credit into our bank account to be paid out as needed.  I have searched online for this answer but can only find how to set this up using the online version of quickbooks which does not help me.

Solved
Best answer August 21, 2019

Best Answers
CGarman
Level 3

How do I set up and track a line of credit

Go to your Chart of Accounts, click the drop-down for Account in the bottom left and choose New. Select the radio button for Loan when asked to choose the account type. Click Continue. Give your account a good name (i.e. First Bank LOC), add Optional items if necessary then click Save & Close. There are a few ways you can record the LOC in your books but the easiest may be with a journal entry. Go to Company, Make General Journal Entries. Enter the date the LOC was deposited into your bank account. Debit your bank account and Credit the LOC account for the total amount. Then, in the future, as you make payments on the LOC, you will book the expense from your bank account (I assume) to the LOC account. 

View solution in original post

13 Comments 13
CGarman
Level 3

How do I set up and track a line of credit

Go to your Chart of Accounts, click the drop-down for Account in the bottom left and choose New. Select the radio button for Loan when asked to choose the account type. Click Continue. Give your account a good name (i.e. First Bank LOC), add Optional items if necessary then click Save & Close. There are a few ways you can record the LOC in your books but the easiest may be with a journal entry. Go to Company, Make General Journal Entries. Enter the date the LOC was deposited into your bank account. Debit your bank account and Credit the LOC account for the total amount. Then, in the future, as you make payments on the LOC, you will book the expense from your bank account (I assume) to the LOC account. 

MBM29
Level 1

How do I set up and track a line of credit

Thanks for the information.  When making payments back to the loan account how would I track the interest?  Do I need to set up an interest account for the LOC and make an entry there as well?

MBM29
Level 1

How do I set up and track a line of credit

Thanks for the information.  One final question how would I track the interest that accrues on the loan?  Would I need to set up an interest account and make an entry into that account every time I make a payment that would show principal and interest on loan?  Do I reconcile the account the same as I would a bank account?

CGarman
Level 3

How do I set up and track a line of credit

Yes and yes. Set up an expense account called Interest if you don't already have one. Then when you make the payment you can split it between the principal amount going to the LOC account on line 1 of the transaction detail and the interest amount going to Interest expense on line 2. When you receive your periodic statements for your LOC showing the ending balance you should reconcile it just like a bank account.

jschreed
Level 1

How do I set up and track a line of credit

How to reconcile a line of credit when the transaction is already matched to the checking account? I wanted to change all the transactions in my LOC because it was recorded as a transfer from checking ( even the interest paid and principal they recorded it as a transfer ). But it was already matched to the checking account that has been reconciled.

Kristine Mae
Moderator

How do I set up and track a line of credit

Let me help you get around with it, Jschreed.

 

You'll have to undo the reconciliation so you can change the transfer and unmatch or delete the transaction. Create the correct one, then reconcile again.

 

First, here's how to undo a reconciliation:

  1. Click Lists.
  2. Go to Chart of Accounts.
  3. Select the bank account, right-click, then select Reconcile.
  4. Click Undo Last Reconciliation.

Next, is to delete the matched transaction, then create a correct one before reconciling it again.

 

As always, I'd suggest reaching out to your accountant on the best way to handle this.

 

We're just around if you have other QuickBooks technical concerns. Take care!

monikalynn
Level 2

How do I set up and track a line of credit

I need help with setting up a line of credit that is used to pay the vendor directly instead of the funds going into the bank account and then paying the vendor.

 

JenoP
Moderator

How do I set up and track a line of credit

Hi there, monikalynn.

 

A Line of Credit account can't be used directly to pay vendor transactions because it is set up as a liability account. At the moment, we can only use a cash, Bank, or a Credit Card Account to pay for vendor expenses. 

 

You'll want to set it up as a credit card account. However, I would suggest reaching out to your accountant before doing this to make sure you're setting up the account correctly. Here's how:

 

  1. Go to the List menu and select Chart of Accounts.
  2. Press CTRL + New, then select Credit Card.
  3. Click Continue and enter all the required details.
  4. Click Save and close.

If you want to keep it as a Current Liability account, you can record the payment as a Journal Entry. Here's a guide for more details: Create a Journal Entry in QuickBooks Desktop.

 

The Community is always here if you need anything else. 

carnall
Level 1

How do I set up and track a line of credit

Hi! I was wondering your suggestion on how to categorize the principal payment. I don't have any categories that seem to fit. If I need to create a new one, what is the proper way to do so? 

JessT
Moderator

How do I set up and track a line of credit

Hi carnall,

 

Welcome and thanks for getting help with creating an account for your principal payment transactions.

 

I'll share the steps to create an account. However, I'm unable to suggest which account type should you choose. Your accountant is the best person to answer that.

  1. Go to the Lists menu, then select Chart of Accounts.
  2. From the Account ▼dropdown, select New.
  3. Select an account type, then select Continue.
  4. Complete the account details.
  5. Select Save & Close.

Here's an article for your additional reference: Add, edit, or delete accounts in QuickBooks Desktop.

 

Let me know if you need more help with your accounts. Have a good one!

JP41
Level 1

How do I set up and track a line of credit

I have a LOC set up as a Long Term Liability. My problem arises when I get a statement showing the interest charge. When I enter this as a bill it does not show up on the account but when I pay the bill it shows up as a payment. The monies that we transfer in and out of the account show up properly but since the interest does not show up except as a payment there is no way to match it - my reconciliation is always wrong. What am I doing wrong?

 

Kevin_C
QuickBooks Team

How do I set up and track a line of credit

Hello there, @JP41.

 

I'd like to ensure that we're on the same page, so I can provide you with the right amount of information so you can proceed with reconciling your account in QuickBooks Desktop.

 

What specific account do you want the interest to show up? How did you record the bill?

 

Furthermore, does the interest show up as a separate charge on your bank statement? It would also be great if you could include some screenshots so I can better understand it.

 

I'd appreciate any additional details you can provide. I’m looking forward to your reply. Have a great rest of the day.

JP41
Level 1

How do I set up and track a line of credit

To try and answer your questions:

I am just trying to reconcile this account. The statement from the bank shows a Total Balance which includes the interest payments. Further down it shows a Total which shows the balance without the interest payment.

 

I don't care where the interest shows up I just want to balance the LOC account. The statement gives a principal balance and a total balance. To which one am I supposed to balance the LOC account? Attached is a copy of the most recent statement. 

 

What would be the GJ entry to put this account correct according to the statement?

Should I include the interest in the account or record it separately?

Need to get in touch?

Contact us