How do I set up and track a line of credit (2024)

How do I set up and track a line of credit (1)

MBM29

Level 1

posted

‎August 21, 201912:58 PM

last updated‎August 21, 201912:58 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

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!Go to Solution.

Solved

Labels:

  • QuickBooks Desktop

Cheer

Reply

Join the conversation

Best answer August 21, 2019

Solved


Best Answers

How do I set up and track a line of credit (2)

CGarman

Level 3

‎August 21, 201901:39 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

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

3

Cheer

Reply

Join the conversation

13 Comments 13

How do I set up and track a line of credit (3)

CGarman

Level 3

‎August 21, 201901:39 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

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.

3

Cheer

Reply

Join the conversation

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?

Cheer

Reply

Join the conversation

How do I set up and track a line of credit (5)

MBM29

Level 1

‎August 22, 201905:40 AM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

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?

Cheer

Reply

Join the conversation

How do I set up and track a line of credit (6)

CGarman

Level 3

‎August 23, 201909:27 AM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

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.

1

Cheer

Reply

Join the conversation

How do I set up and track a line of credit (7)

jschreed

Level 1

‎August 17, 202010:47 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

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.

Cheer

Reply

Join the conversation

How do I set up and track a line of credit (8)

How do I set up and track a line of credit (9)Kristine Mae

Moderator

‎August 17, 202011:30 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

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 transferand 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!

Cheer

Reply

Join the conversation

How do I set up and track a line of credit (10)

monikalynn

Level 2

‎September 16, 202006:41 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

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.

Cheer

Reply

Join the conversation

How do I set up and track a line of credit (11)

How do I set up and track a line of credit (12)JenoP

Moderator

‎September 16, 202007:56 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

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.

Cheer

Reply

Join the conversation

How do I set up and track a line of credit (13)

carnall

Level 1

‎August 06, 202111:56 AM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

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?

Cheer

Reply

Join the conversation

How do I set up and track a line of credit (14)

How do I set up and track a line of credit (15)JessT

Moderator

‎August 06, 202112:22 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

How do I set up and track a line of credit

Hicarnall,

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 theListsmenu, then selectChart of Accounts.
  2. From theAccount▼dropdown, selectNew.
  3. Select an account type, then selectContinue.
  4. Complete the account details.
  5. SelectSave & 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!

Cheer

Reply

Join the conversation

How do I set up and track a line of credit (16)

JP41

Level 1

‎July 26, 202301:51 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

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?

Cheer

Reply

Join the conversation

How do I set up and track a line of credit (17)

Kevin_CHow do I set up and track a line of credit (18)

QuickBooks Team

‎July 26, 202303:58 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

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.

Cheer

Reply

Join the conversation

How do I set up and track a line of credit (19)

JP41

Level 1

‎August 02, 202309:23 AM

  • Mark as New
  • Bookmark
  • Subscribe
  • Permalink
  • Print
  • Report Inappropriate Content

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?

Cheer

Reply

Join the conversation

Sign in for expert help

Ask questions, post replies & join our community of QuickBooks users.

Sign In Sign Up

How do I set up and track a line of credit (2024)

FAQs

What information do you need to open a line of credit? ›

A personal line of credit is an unsecured loan. That is, you ask the lender to trust you to make repayment. To land one, you'll need to present a credit score in the upper-good range — 700 or more — accompanied by a history of being punctual about paying debts.

How to set up a line of credit in QB? ›

Line of Credit in QuickBooks desktop
  1. Go to Lists menu then Chart of Accounts.
  2. Right-click anywhere then press New.
  3. Choose Loan then Continue. If you don't see this option, pick Other Account Types then Other Current Liability.
  4. Press Continue to proceed.
  5. Enter the details of your LOC then press Save and Close.
Feb 26, 2021

How long does it take to set up a line of credit? ›

The time it takes to get a line of credit approved can vary based on the type of credit and several factors. Regular credit card applications can be approved within minutes, while home equity lines of credit typically take 2 to 6 weeks.

How to account for a line of credit? ›

A line of credit, does not appear on the books of the organization until money is borrowed. When money is borrowed, the amount is recorded as a loan in the liability section of the Statement of Financial Position along with the interest owed on the outstanding balance.

What credit score is needed for a line of credit? ›

The Bottom Line

Though lenders will each have their own qualification requirements when it comes to credit scores, you could get approved for a line of credit if you have a score of 660. However, your chances of approval (and getting better interest rates) increase if your score is closer to 713 and above.

How does a $10,000 line of credit work? ›

For example, if you have a credit line with a $10,000 limit, you can use part or all of it for whatever you need. If you carry a $5,000 balance, you can still use the remaining $5,000 at any time. If you pay off the $5,000, then you can access the full $10,000 again.

How to track a Line of Credit in QuickBooks? ›

Track your line of credit
  1. Select + New.
  2. Under Vendors, select Check.
  3. In the Payee field, select or enter the financial institution's name.
  4. In the Bank Account ▼ dropdown, select the financial institution.
  5. In the Category field, select Line of credit. ...
  6. In the Category field, select Interest paid. ...
  7. Select Save and close.

What is a Line of Credit setup? ›

A credit line is a flexible loan that some banks offer. It works as a pre-approved, set amount of money that you can access when needed. If you have a pre-sanctioned credit line from your bank, you can set it up as a form of payment on Google Pay.

How to record a Line of Credit loan? ›

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.

What are the risks of a line of credit? ›

Interest is charged on a line of credit as soon as money is borrowed. Lines of credit can be used to cover unexpected expenses that do not fit your budget. Potential downsides include high interest rates, late payment fees, and the potential to spend more than you can afford to repay.

What is a good line of credit amount? ›

What should my credit limit be? Your credit limit should be at least 3 times higher than your usual monthly spending. That's because your overall credit utilization ratio should stay below 30%. If your spending exceeds that, you risk damaging your credit score.

How much credit line do you start with? ›

If you're just starting out, a good credit limit for your first card might be around $1,000. If you have built up a solid credit history, a steady income and a good credit score, your credit limit may increase to $5,000 or $10,000 or more — plenty of credit to ensure you can purchase big ticket items.

What are the requirements for a line of credit? ›

Credit history.

While most lenders require a personal credit score of around 680, some lenders accept scores as low as 580 to 600. However, the higher your score, the better chances you have at securing a lower interest rate or higher loan amount.

How much line of credit should a person have? ›

Just as there's no fixed rule about how many lines of credit are ideal, there's no rule about how many lines of credit are too many for one person to have. It all depends on your situation. If you're confident that you'll be able to make the payments, opening one or more may be a good idea.

Can I transfer money from my line of credit to my bank account? ›

write a cheque from your line of credit. use an automated teller machine (ATM) pay a bill using telephone or online banking. transfer money to your chequing account using telephone or online banking.

What documents do I need for a line of credit? ›

To apply for a personal line of credit, you'll typically require identity documentation, proof of your family income, details of existing debt, and collateral documentation if you're applying for a secured line.

What is line of credit requirements? ›

Personal Line of Credit (LOC)

This provides access to unsecured funds that can be borrowed, repaid, and borrowed again. Opening a personal LOC usually requires a credit history of no defaults, a credit score of 670 or higher, and reliable income.

What do banks look at when applying for a line of credit? ›

A personal line of credit is an unsecured borrowing option that typically has a lower interest rate than a credit card. It can help you manage various expenses like debt consolidation, home repairs or unexpected bills. You'll need a good credit score, a stable income, and a low debt-to-income ratio to qualify.

How do you know if you qualify for a line of credit? ›

To qualify for a line of credit, you will have to meet the lender's standards, which typically include proving your creditworthiness with a minimum credit score, sufficient income, and other factors.

Top Articles
Latest World & National News & Headlines
How to… Stop jersey fabric rolling — My Handmade Wardrobe Patterns
Forozdz
Somboun Asian Market
Katmoie
Fully Enclosed IP20 Interface Modules To Ensure Safety In Industrial Environment
Ati Capstone Orientation Video Quiz
GAY (and stinky) DOGS [scat] by Entomb
Skip The Games Norfolk Virginia
Ave Bradley, Global SVP of design and creative director at Kimpton Hotels & Restaurants | Hospitality Interiors
Urban Dictionary Fov
The Witcher 3 Wild Hunt: Map of important locations M19
Summer Rae Boyfriend Love Island – Just Speak News
Belly Dump Trailers For Sale On Craigslist
Midlife Crisis F95Zone
Extra Virgin Coconut Oil Walmart
Jayah And Kimora Phone Number
Uconn Health Outlook
O'Reilly Auto Parts - Mathis, TX - Nextdoor
Anotherdeadfairy
Toothio Login
Danielle Ranslow Obituary
Foolproof Module 6 Test Answers
Wood Chipper Rental Menards
Margaret Shelton Jeopardy Age
Garden Grove Classlink
The Collective - Upscale Downtown Milwaukee Hair Salon
Dexter Gomovies
Wbap Iheart
The Clapping Song Lyrics by Belle Stars
How Do Netspend Cards Work?
Account Now Login In
Evil Dead Rise - Everything You Need To Know
Jt Closeout World Rushville Indiana
Storelink Afs
Exploring TrippleThePotatoes: A Popular Game - Unblocked Hub
Colorado Parks And Wildlife Reissue List
About Us | SEIL
Rogers Centre is getting a $300M reno. Here's what the Blue Jays ballpark will look like | CBC News
Jefferson Parish Dump Wall Blvd
Laurin Funeral Home | Buried In Work
The best Verizon phones for 2024
Nba Props Covers
Cpmc Mission Bernal Campus & Orthopedic Institute Photos
Obituaries in Hagerstown, MD | The Herald-Mail
Ig Weekend Dow
Luvsquad-Links
Torrid Rn Number Lookup
Pike County Buy Sale And Trade
Go Nutrients Intestinal Edge Reviews
What is 'Breaking Bad' star Aaron Paul's Net Worth?
Vcuapi
Latest Posts
Article information

Author: Barbera Armstrong

Last Updated:

Views: 6327

Rating: 4.9 / 5 (79 voted)

Reviews: 86% of readers found this page helpful

Author information

Name: Barbera Armstrong

Birthday: 1992-09-12

Address: Suite 993 99852 Daugherty Causeway, Ritchiehaven, VT 49630

Phone: +5026838435397

Job: National Engineer

Hobby: Listening to music, Board games, Photography, Ice skating, LARPing, Kite flying, Rugby

Introduction: My name is Barbera Armstrong, I am a lovely, delightful, cooperative, funny, enchanting, vivacious, tender person who loves writing and wants to share my knowledge and understanding with you.