How To Record A Loan in QuickBooks Online and Desktop – Learn the Process

While recording the loan under QuickBooks, a small business can monitor all the long-term or short-term loans while keeping a track of all the loan deposit amount and loan repayment.

Do you have trouble entering loans into QuickBooks? Accurate financial management requires knowing how to set up and record loans in QuickBooks, whether you work as an accountant or as a small business owner.

While handling a business, you will encounter many scenarios where you have to borrow money to fund your business or lend money.

There are two such scenarios as per accounting rules:

1. Loan Payables (Where you have borrowed money and are under the obligation to pay)
2. Loan Receivables or Receivables (Where you have lend money and have the right to receive principle and interest payments)

When the company borrows money, it is mandatory to record the loan as “payables” under the liability account to maintain financial records.  And when you lend money to someone else, then the loan is recorded as “receivables” in the asset side of the balance sheet.

How to Create / Set-Up a Loan in QuickBooks?

To efficiently manage financial transactions, setting up a loan in QuickBooks entails opening a loan account, entering loan details, and establishing loan installments. To initiate the process of creating a loan account in QuickBooks, go to the Chart of Accounts and choose the ‘New’ option to establish a new account. Next, you can designate an appropriate account name and select “Long Term Liabilities” as the account type.

Once the loan account has been created, you can add specific loan details like the loan amount, interest rate, and period once the loan account has been created. In order to guarantee precise loan payment tracking and administration, QuickBooks gives you the option to customize loan payment settings by establishing recurring payment schedules.

Step 1. Establishing a Credit Account

To effectively record financial obligations and manage loan transactions within the accounting system, you must first create a loan account in QuickBooks.  The process entails multiple crucial phases, commencing with accessing the Chart of Accounts and choosing the Add New Account option.

You’ll need to provide important information while creating the loan account, including the loan amount, interest rate, conditions of repayment, and lender details. For these data entries, QuickBooks offers dedicated fields, so you can precisely record the loan terms in the system.

To ensure accurate financial reporting, you can tailor the account to fall under the long-term liabilities category. You can make sure that your loan transactions are correctly documented and efficiently handled by adhering to these guidelines.

Step 2. Documenting Credit Data

To ensure thorough financial record-keeping and analysis, loan details such as principal amount, interest rate, and repayment terms must be precisely entered into QuickBooks. This procedure provides the basis for monitoring how the loan affects the company’s financial situation. QuickBooks makes it easier to calculate interest payments to ensure accurate financial reporting.

To ensure compliance and transparency, loan details including loan agreements, payment plans, and any collateral involved must be properly documented. Businesses can obtain a comprehensive understanding of their financial obligations by integrating these components with QuickBooks, which facilitates improved strategic planning and decision-making.

Step 3. Organizing Loan Disbursements

In order to facilitate smooth loan administration within QuickBooks, setting up loan payments requires establishing payment schedules, connecting bank accounts, and guaranteeing precise transaction categorization. The first step in this process is to use QuickBooks’ “Loan Manager” feature to enter the loan information, such as the principal amount, interest rate, and loan period. Users can specify a payment plan that is either monthly, bi-weekly, or based on a custom time frame after entering the loan details.

It is important to link the relevant bank account to expedite the payment process and guarantee that transactions are appropriately displayed in the software. By correctly classifying these transactions in QuickBooks, users may efficiently monitor how the loan is affecting their financial statements.

How to record a loan in QuickBooks Desktop? 

How to record a loan in QuickBooks Desktop, first create a liability account under Chart of Accounts. Set up the vendor and an expense account for interest. Use the Make Deposits feature to record the loan amount and Write Checks to record loan payments, including principal and interest.

Tracking Loans In QuickBooks Desktop for Windows

To record a loan in QuickBooks Desktop, create a liability account under Chart of Accounts, set up the vendor, and an expense account. Record the loan via Make Deposits and loan payments via Write Checks.

In order to track your loan in QuickBooks Desktop for Windows, kindly follow the steps below: 

Step 1: Create a liability account.

You must choose a liability account when you record a loan in QuickBooks. 

1. Navigate to the Lists menu and choose the Chart of Accounts.
2. Choose New.
3. Choose the appropriate account type for your loan by first selecting Other Account Types:
   • Other Current Liability: This should be used for short-term loans that are due in more than a year.
   • Long-Term Liability: This should be used for debts that are due over an extended length of time.
4. Click “Continue.”
5. Input the account number and name.
6. Click Save & Close. 

Step 2: Set up the vendor

1. Select the Vendor Center under the Vendor menu.
2. Choose a New Vendor.
3. Enter the bank name or the company name you need to pay for the loan.
4. Enter the vendor’s details such as email address, phone number.
5. Click on “OK”.

Step 3: Set up an expense account.

1. Go to the Lists menu, then choose the Chart of Accounts.
2. Click on the New.
3. Select the Expense and then continue.
4. Enter the name of the account for the interest payments or fees and charges.
5. Click on Save and then close the transaction.

Step 4: Record the loan account

In this step, you will get to know how to record entries for Cash Loans in QuickBooks Desktop:

1. Click the Banking menu and choose “Make Deposits.”
2. Choose Cancel if the Payments to Deposit window appears.
3. Choose the account to which you want to deposit the loan in the Deposit To section of the Make Deposits window.
4. Verify the date and add a memo if desired.
5. Choose the Liability account that you created in Step 1 under the From Account column.
6. Enter the loan amount in the Amount column.
7. Click Save & Close.

Step 5: Record loan payment

1. Click on the Banking menu, then click on “Write Checks:.
2. Choose the Bank account you want for loan payment.
3. Check and verify the “Check number” and “Date”.
4. Select the bank name in the “Pay to the order of” field.
5. Now in the Expense tab:
   • Select the liability account you have created in the Step -1 (in the first line).
   • Then enter the payment for the principal amount.
   • Select the interest expense account (in the second line),
   • Enter the payment for the loan interest.
6. Click on Save and close the transaction.

Tracking Loans In QuickBooks Desktop for Mac

First , create the liability account and set up the vendor, to know the steps (read under the heading above “ Step 1: Create a liability account  and Step 2: Step up the Vendor“), then follow the below mentioned steps:

Step 3: Record the loan amount

In this step, you will get to know how to record entries for Cash Loans in QuickBooks Mac:

1. Click the Banking menu and choose “Make Deposits.”
2. Choose Cancel if the Payments to Deposit window appears.
3. Choose the account to which you want to deposit the loan in the Deposit To section of the Make Deposits window.
4. Choose the liability account that you created in Step 1 under the From Account column.
5. Enter the loan amount in the Amount column.
6. Click Save.

Step 4: Record the loan payment

1. Navigate to the Banking menu and choose “Write Checks.”
2. Choose the bank account to use to make loan payments.
3. Check Date and Check No.
4. Choose the bank’s name in the Pay to the Order of field.
5. On the tab for expenses:
   • Choose the liability account you formed in Step 1 on the first line. Next, enter the principal payment amount.
   • Choose the interest expense account on the second line. Next, insert the loan interest payment.
6. Click Save & Close.

Recording entries for loans in QuickBooks Desktop (QBDT)

In QuickBooks Desktop, record loan entries by creating a liability account, setting up the vendor, and an expense account for interest. Use Make Deposits to log the loan and Write Checks for payments, including both principal and interest.

Recording entries for Only Loan Interest Payments in QuickBooks Desktop

First, you can write a check to the relevant expenditure account that is utilized to track loan interest for the interest-only payments. You must first create an expense account, though.

How to do it is as follows:

1. Select Chart of Accounts from the List menu.
2. If you do a right-click anywhere, choose New.
3. Choose Expense and press Next.
4. To make interest payments or pay fees and penalties, enter the account name. Then, click Save and Close.

Recording Entries for Non-Cash Loans in QuickBooks Desktop

There are different processes for recording non-cash loans in Windows and Mac for QuickBooks Desktop.

Below are the mentioned processes:

In Windows

1. Create an asset account.
2. Navigate to the Lists menu and choose the Chart of Accounts.
3. If you do a right-click anywhere, choose New.
4. Choose the non-cash loan account type:
   • Vehicles, structures, and other goods with a useful life of more than a year should be classified as fixed assets.
   • Other Current Asset: Put valuables here that can be exchanged for cash (such as pre-paid bills).
   • For objects that are neither fixed assets nor other current assets, use the term “other asset.”
5. Click “Continue.”
6. Input the account number and name.
7. Once finished, choose Save & Close.

5. Click on the Company menu and choose the option to Enter General Journal Entries.
6. Put the Journal Entry No. and Date in here.
7. Debit the loan asset account by selecting the first line.
8. Click on the second line, then give the liability account credit.
9. Click Save & Close.

In Mac

Follow the steps below to record the entries for non-cash loans:

1. Create an asset account.

• First, navigate to the Lists menu and choose the Chart of Accounts.
• To add a new account, click the + symbol.
• Choose the loan’s asset account:
  • Vehicles, structures, and other goods with a useful life of more than a year should be classified as fixed assets.
  • Other Current Asset: Put valuables here that can be exchanged for cash (such as pre-paid bills).
  • For objects that are neither fixed assets nor other current assets, use the term “other asset.”

2. Click OK.
3. Click on the Company menu and choose the option to Enter General Journal Entries.

4. Date and journal entry number should be included.
5. Debit the loan asset account by selecting the first line.
6. Click on the second line, then give the liability account credit.
7. Click Save.

How to record a loan in QuickBooks Online?

Record a loan in QuickBooks Online, create a liability account, specify the loan balance, and record repayments by selecting the liability account, entering payment amounts, and categorizing interest and fees. Save the details to complete the entry.

By this method, you can record:

• Loan for asset in QuickBooks Online
• Loan for other purposes
• Loan to Buy Inventory

Now, it’s time to learn to set up and record loans in QuickBooks Online and then enter the record as per the scenarios.

Setting or Configure up a Loan in QuickBooks Online

Step 1: Create a liability account

The first step includes creating a liability account in your QuickBooks account.

Follow the below-mentioned steps:

1. Click on Settings and then choose the Chart of Accounts.
2. After that, click on “New” to create a new account.
3. Select Long-Term Liabilities from the Account Type dropdown.
4. Now, provide the loan account name (including – Company or Individual Name, Description. Tax-line)

Step 2: Specify the loan balance

In this step. We will determine the type of loan – whether it is a new loan or prior loan, you need to record both of them.

1. If it is a new loan, it shows the full balance to be paid back. So, if the amount gets deposited to your bank from loan:

3. In the Opening balance, leave US $0 and then click on Save.
4. You have to determine the bank deposit in your liability account to begin with the beginning amount.

5. If it is a prior loan, then the partial amount will be set off with the current payoff balance.

6. In the Opening balance section, select the start date ( date from which you will start tracking your finances).
7. Mention the amount balance for that date.
8. Click on Save.

Step 3: Record the loan repayment

1. Click on + New.
2. Then, select Check.
3. Now, add the check number ( if you want to send a check) or enter the Debit or EFT details in the Check number field ( if you want to use direct withdrawal or an EFT).

Now, it’s time to enter the Category details in the check section. Make sure to document all the following information:

1. Click on the liability account for the loan from the dropdown menu of the Category section.
2. Now, enter the payment amount.
3. Click on the expense account for the interest from the dropdown menu of the Category section.
4. Now, enter the Interest payment.
5. If you have any additional fees, you can choose from the dropdown menu of the Category section.
6. Once, all the details are entered and checked properly. Click on Save and then close it.

 Recording a loan in QuickBooks Online

To record a loan in QuickBooks Online, click the New button, select Journal Entry, choose your liability account, enter the loan amount under Credits, select the asset account, then save and close the transaction.

Following the step-by-step information below:

Step 1: Click on the New Button

• Select the New Button on the screen.

Step 2: Start a Journal Entry

• Click on Journal Entry.

Step 3: Choose the Liability Account

Under the Account column, select your new liability account.

Step 4: Enter the Details

• Enter the loan amount under the Credits.

Sep 5: Select the Asset

• Now, select the asset under the Account column.

Step 6: Finishing Up!

• Select Save and close the transaction.

Recording Customer’s Invoice Based Loan Entries in QuickBooks Online

To record a customer’s invoice-based loan in QuickBooks Online, create a liability account, enter the loan amount using a journal entry, and record payments via the “Make Deposits” feature. Set up a recurring invoice for loan repayments and track interest income in the appropriate accounts.

Following the step-by-step information below:

Granting a Loan to Close Open Invoices

In order to record a loan to close open invoices, you must have a liability account (if you don’t have one, first create that, read under the heading above “ Step 1: Create a liability account “ ), then follow the below mentioned steps:

1. Select “Loans to Others” from the Detail type drop-down.
2. Enter the Name for the loan in the Name field.
3. Click Save and Close.

Note: While creating the liability account:

1. If the loan will be repaid within the current fiscal year, use “Other Current Assets” under “Account Type”.
2. If the loan will be repaid after the current fiscal year, use “Current Assets” under “Account Type”.

Entering the Loan Amount with a Journal Entry

In order to enter the loan amount with a Journal Entry, follow the below mentioned steps:

1. Click on + New.
2. Pick the Journal entry option.
3. Under the Account section, select a new liability account.
4. Enter the amount of the loan under the Credits section.
5. Now, select the asset account under the Account column.
6. Select Save and then close.

Creating a General Loan for a Customer

In order to record a general loan for a customer, you must have a liability account (if you don’t have one, first create that, read under the heading above “ Step 1: Create a liability account “ ), then follow the below mentioned steps:

1. Click on the New button in the left-side Navigation Pane.
2. Now, choose Checks under the Vendor heading.
3. A Check panel pop up will appear on the screen and then you have to choose the account that funds the loan in the Bank Account drop-down.
4. Then, enter the account that you created to track the loan as the offsetting account in the below area.
5. Enter the total amount.
6. Click on the Save and Close button.

Recording Customer Loan Payments

In order to record the customer loan payments you must have a liability account (if you don’t have one, first create that, read under the heading above “ Step 1: Create a liability account “) , then follow the below mentioned steps:

1. Click on the “Banking” menu and then “Make Deposits”.
2. Choose the Payment, linked with the account ( if the  payments to deposit window is accessible). 
3. If the “Make Deposit Window” is accessible, then enter the name of the customer who is paying off the loan in the “Received From” column.
4. Now, enter the Asset Account that has been created for the loan in the “ From Account Field”.
5. Enter the customer’s payment in the Account column.
6. Now, enter the customer’s name in the “Received From” column.
7. If there is any interest amount, then enter the interest amount in the “Account” column.
8. Click on “Save & Close” to save and close the transaction window.

Creating an Item for the Loan

1. Click on Setting and then navigate to the Products and Services list under the Lists heading.
2. Select the Products and Services and click on the New button and then select the Service.

3. A panel will slide in, now enter the descriptive name for the loan and under the Income account drop down, select the customer’s loan receivable amount.
4. Click on the Save and close the transaction.

Making a Recurring Invoice for Loan Repayments

1. Click on the Settings button and select the Recurring transaction under the Lists heading.
2. Click on the New button and then select the Invoice from the drop-down.

3. Select the customer’s name from the Customer dropdown, under the Invoice form.
4. Now, choose the loan that you have made from the Product/ Service dropdown.
5. Now, under the Edit Schedule area, enter the schedule that you want the loan to be paid by.
6. Once done, click on the Save Template button.

Recording Entries for Loan Receivables

In order to record the entries for loan receivables, you must have a loan account (if you don’t have one, first create that, read under the heading above “ Step 1: Create a liability account “) , then follow the below mentioned steps:

1. Open the Banking menu and make deposits.
2. Now, choose the payment you want to link with the account ( if the payment to deposit window is open).
3. Enter the name of the customer paying off the loan  inside the “Received From” column ( if the “Make Deposits Window” is opened).
4. In the “From Account” field, enter the asset account ( that you have created for the loan).
5. Enter the customer’s payment in the Amount column.
6. Enter the account you will use to track the interest income into the “From Account” field.
7. Enter the payment part that goes in the Amount column. ( Use the “Interest Income” account under the Other Income Type, until you have an amount to track the interest of the loan.)
8. Click on Save and close the transaction.

Creating Loan Repayment Schedule in QuickBooks

Create a loan repayment schedule in QuickBooks, enter the loan as a journal entry, set up expense accounts for interest and fees, input loan details, and use “What If Scenarios” to calculate and print the repayment schedule.

Following the step-by-step information below:

1. Enter the initial loan amount as  a journal entry.
2. Set up Expense account for the interest and fee
3. Enter the loan information such as account name, loan amount, original amount.
4. Enter the payment information.
5. Enter the interest information.
6. Make payments by selecting “Regular Payment” in the Set Up Payment window. 
7. Use the What If Scenarios tool by clicking the “What If Scenarios” button and select the loan from “Choose a loan list”.
8. Click on ‘Calculate” to see the final result and “Print” to print the transaction.
9. Click on “Ok”.

Zeroing Out a Loan in QuickBooks

One more important process is to get a loan account in QuickBooks to zero out at the end of the cycle. When payments are final and when you are required to book a loan account fully, you are expected to clear the loan account to represent the correct amount of liability.

Here’s how you can do this:

In QuickBooks Online

Follow the below steps to zero out a loan in QuickBooks Online:

1. From the list go to Reports, select Balance Sheet and see if there is any balance in the loan account.
2. Go to the BookkeepingàCreate Check or Expense, choose the loan account, insert the remaining balance and click on save.
3. Go to Chart of Accounts, modify the loan account, and check the option Inactive.

In QuickBooks Desktop

Follow the steps to zero out a loan in QuickBooks Desktop:

1. It is recommended to open Chart of Account, right click at the loan account and click on Quick Report so that the balance can be viewed.
2. Click on Banking then on Write Checks, choose proper loan account, type the rest balance and click on save.
3. The Loan account needs to be made inactive. Here you will get the list of accounts, right click on the Loan Account which we would like to make inactive and click on Make Account Inactive.

Tip: Make sure the accounts are cleared before the loans are written off to avoid discrepancies.

What to do in order to adjust a loan balance in QuickBooks?

1. Click on the New button on the left side of the Navigation Pane to create a new bank deposit.
2. Select the Bank Deposit under the Other heading.
3. Select the payment you received and in the Add Funds to the deposit section.
4. Choose the loan account that you have created for the customer from the dropdown.

Conclusion

While dealing with the financial record, calculating a loan is a big matter for businesses. You don’t want a small calculation error to ruin your entire balance sheet. Consequently, QuickBooks offers a QB loan manager to monitor every transaction meticulously and ultimately determine the outstanding balance.

Frequently Asked Questions

How do I Record a loan from one company to another in QuickBooks?

To record a loan to another company in QuickBooks, you need to follow these steps:

1. Create a Liability Account: Go to the Chart of Accounts, choose ‘New,’ and select the account type as “Long Term Liabilities” or “Other Current Liabilities” based on the loan duration. Input the loan details such as amount, interest rate, and repayment terms.
2. Record the Loan Deposit: Use the “Make Deposits” feature to log the loan amount into the appropriate bank account.
3. Set Up the Vendor: Add the company you lent the money to as a vendor in the Vendor Center.
4. Record Loan Payments: Use “Write Checks” to document the loan payments, including both principal and interest, to the vendor.

How do you record a loan to an employee in QuickBooks?

To record a loan to an employee in QuickBooks, follow these steps:

1. Initial Loan Entry:
   • Debit Loan to Employee for the loan amount (e.g., $5,000).
   • Credit Cash for the same amount (e.g., $5,000).
2. Accrued Interest (under accrual accounting):
   • Debit Interest Receivable for accrued interest.
   • Credit Interest Income for the same amount.
3. When Employee Makes a Payment:
   • Debit Cash for the payment amount.
   • Credit Interest Receivable and Loan to Employee for the appropriate amounts.

These entries ensure accurate tracking of the loan and any related interest.

How Do I Record A Vehicle loan in QuickBooks Online?

To record a vehicle loan in QuickBooks Online, follow these steps:

1. Create a Liability Account:
   1. Go to Settings and select Chart of Accounts.
   2. Click on New.
   3. Choose Long-Term Liabilities from the Account Type dropdown.
   4. Provide a name for the loan account and fill in other details as needed. Click Save.
2. Specify the Loan Balance:
   1. For a new loan, leave the opening balance at $0 if the amount is deposited directly into the bank.
   2. For a prior loan, set the opening balance with the current payoff amount as of the start date. Click Save.
3. Record Loan Repayment:
   1. Click on + New and select Check.
   2. Enter the check number or EFT details.
   3. Choose the liability account for the loan from the Category section.
   4. Enter the payment amount. Also, categorize any interest payments and fees.
   5. Click Save and Close.
4. Record the Loan Amount:
   1. Click on + New and select Journal Entry.
   2. Choose the liability account you created and enter the loan amount under Credits.
   3. Select the asset account for the vehicle and enter the amount under Debits.
   4. Click Save and Close.

Disclaimer: The information outlined above for “How To Record A Loan in QuickBooks Online and Desktop – Learn the Process” is applicable to all supported versions, including QuickBooks Desktop Pro, Premier, Accountant, and Enterprise. It is designed to work with operating systems such as Windows 7, 10, and 11, as well as macOS.