how to add a loan to quickbooks online

How to Add a Loan to QuickBooks Online

By Michael Young
AD

-streamlining your accounting processes, adding a loan to QuickBooks Online is a breeze. This intuitive platform allows you to manage your business finances efficiently, including recording and tracking loan payments. Let's guide you through the simple steps to add a loan to QuickBooks Online.

Before you start, ensure you're already logged into your QuickBooks Online account. If not, head to the QuickBooks website and sign in using your credentials. Now, let's dive into the process.

Setting Up the Loan

First, you need to create the loan in QuickBooks. It's a simple process that sets the foundation for your loan tracking. Here's how:

AD
How to Record a Loan in QuickBooks Online?
How to Record a Loan in QuickBooks Online?
How to Set Up a Loan in QuickBooks Online
How to Set Up a Loan in QuickBooks Online
How To Record Loans & Loan Payments in Your Bookkeeping (Including Shopify Capital Loans)
How To Record Loans & Loan Payments in Your Bookkeeping (Including Shopify Capital Loans)

1. Navigate to the left menu and click on ' Perangking '.

2. Under ' Other ', select ' More '', then click on ' Loan '.

BHT&D CPAs is Now Doeren Mayhew
BHT&D CPAs is Now Doeren Mayhew
How to Setup a Loan in QuickBooks
How to Setup a Loan in QuickBooks

Creating the Loan

In the ' New Loan ' window that appears, follow these steps:

1. Enter a name for your loan. It could be the lender's name, the type of loan, or any identifier that works for you.

AD

2. Under ' Loan Details ', fill in the following fields:

  • Loan Type: Select ' Bank ', ' Vendor ', ' Other ', or ' Vehicle '.
  • Interest: Enter the annual interest rate.
  • Term: Enter the loan term in years or months.
  • Principal: Enter the original loan amount.
  • Open Date: Select the date the loan was originated.

Setting Up Loan Payments

To set up your loan payments, follow these steps:

1. Under ' Payments ', click on ' Edit '.

AD

2. In the ' Payment Schedule ' section, click on ' Create payment schedule '.

3. Select ' Monthly ', ' Every 3 months ', ' Every 6 months ', or ' Annually ' based on your payment frequency. You can also choose a custom frequency.

4. Under ' Payment Amount ', select ' Equal payments '. You can adjust the start date, but this field auto-fills based on your open date and term.

AD

5. Click on ' OK ', then ' Save '. QuickBooks will now calculate and display your loan payments based on your settings.

Recording Loan Payments

Once you've set up your loan, recording payments is straightforward. Here's how you can do it:

1. In the left menu, click on ' Billing ', then select ' Pay Bills '.

2. Click on ' NewPayment ', then select the lender as the recipient. If it's not on the list, click on ' Add new ', fill in the details, and ' Save '.

3. Enter the payment date, amount, and select the appropriate bank account. Click on ' Attach ' if you want to attach a copy of the payment.

4. Under ' Line item details ', select ' Loan '. In the ' Account ' field, type ' Loan, Vendor, or Other '(depending on your loan type). The ' Account Name ' field should auto-fill with the loan you set up earlier.

5. Link the expense to the right category, then click on ' Save '. QuickBooks will record the payment and update your loan balance accordingly.

Recording Lump Sum Payments

If you make a lump sum payment, you'll need to adjust your transaction slightly:

1. After clicking ' Save ', go to the ' Category ' field and select ' Equity '.

2. In the ' Subcategory ' field, type ' Loan Payment '. The ' Expense Account ' field should remain blank.

3. Click on ' Save '. QuickBooks will now correctly record your lump sum loan payment.

Updating Loan Balance

QuickBooks automatically updates your loan balance when you record a payment. However, if you need to manually adjust the balance, here's how:

1. Navigate to ' Accounting ', then ' Chart of Accounts '. Find your loan account and click on ' View register '.

2. Click on ' New ', then select ' Journal Entry '.

3. Select the appropriate date, then under ' Account ', select your loan account. In the ' Debit ' field, enter the amount you want to adjust.

4. Click on ' Save ' to record the adjustment.

And there you have it! Adding a loan to QuickBooks Online and managing your loan payments is now a breeze. With these steps, you can keep your financial records up-to-date and make informed decisions. Happy accounting!

AD