How to Record Loan Payment Receivable In QuickBooks?

When your business lends money to a customer, employee, or another party, that amount becomes a loan receivable and must be tracked correctly in QuickBooks. A loan receivable records money owed to your business, while a loan payable tracks money your business owes to a lender. Keeping these accounts separate helps maintain accurate financial reports and clean balance sheet records.

Before you Record Loan Payment Receivable In QuickBooks, you must review the loan agreement, calculate the principal and interest amounts correctly, and verify your chart of accounts setup. This article explains the complete setup and repayment process for both QuickBooks Online and QuickBooks Desktop.

What Is a Loan Payment Receivable in QuickBooks?

A loan receivable is money your business has lent to another party and expects to recover. It sits on your balance sheet as an asset; specifically under Other Current Assets (repayable within a year) or Other Assets (long-term repayment).

This is different from a loan payable, which tracks the debt your business owes to a bank or lender.

Term	What It Means	Account Type
Loan Receivable	Money your business lent out	Asset
Loan Payable	The money your business borrowed	Liability

When a borrower repays the loan, you record two components:

• Principal repayment reduces the loan balance on your balance sheet.
• Interest income records the earnings from the loan in your income accounts.

QuickBooks does not calculate or separate these components automatically. You must calculate and record these amounts manually using your loan amortization schedule.

QuickBooks Online vs QuickBooks Desktop Loan Tracking

The following table compares how QuickBooks Online and QuickBooks Desktop handle loan receivable tracking and repayment entries.

Feature	QuickBooks Online	QuickBooks Desktop
Loan Setup Method	Create an asset account in the Chart of Accounts	Create a Note Receivable account
Initial Loan Entry	Record through Check	Record through Write Checks
Repayment Method	Record through Bank Deposit	Record through Make Deposits
Interest Tracking	Manual calculation required	Manual calculation required
Loan Manager Availability	Not available	Discontinued after 2021
Principal and Interest Split	Manual split entry	Manual split entry

Important Checks Before Recording Loan Receivable Payments

Before you record any loan payment, complete these steps:

• Review the signed loan agreement to confirm the repayment terms, interest rate, and schedule.
• Verify the payment amount against the borrower’s payment notice or bank statement.
• Calculate the interest and principal portions manually before recording. QuickBooks does not do this for you.
• Review your Chart of Accounts to confirm that the loan asset account and interest income account exist.
• Check your QuickBooks version. The setup steps differ between QuickBooks Online and QuickBooks Desktop.
• Back up your company file before making any accounting changes.

How to Set Up a Loan Receivable Account in QuickBooks Online?

Before you can record a loan payment receivable in QuickBooks Online, you need the right account in your Chart of Accounts.

1. Go to All Apps, then select Accounting, then Chart of Accounts.
2. Select New, then select Assets.
3. From the Save account under the Tax form section dropdown, select Loans to Others.
4. In the Account name field, enter a recognizable name such as Loan – [Customer Name].
5. Select Save without entering an opening balance.

Note: Create one loan account per borrower to keep records clear and auditable.

How to Record Loan Payment Receivable in QuickBooks Online?

Follow this Record Loan Payment Receivable In QuickBooks tutorial to record principal and interest payments correctly in QuickBooks Online. QuickBooks Online does not calculate interest automatically. Use your amortization schedule to determine the principal and interest amounts before recording each payment.  Use your amortization schedule or external worksheet to determine the correct principal and interest amounts for each payment period.

Step 1: Record the outgoing loan using a Check

1. Select + Create, then select Check.
2. From the Bank Account dropdown, select the account you used to fund the loan.
3. On the first line, from the Category dropdown, select the loan asset account you created.
4. In the Amount field, enter the loan amount.
5. Select Save and close.

Step 2: Record incoming repayments using a Bank Deposit

1. Select + Create, then select Bank Deposit.
2. In the Add funds to this deposit section, add a new line.
3. From the Received from dropdown, select the borrower’s name.
4. From the Account dropdown, select the loan asset account.
5. Enter the principal portion of the payment in the Amount field.
6. On the next line, select the account you use to track Interest Income.
7. Enter the interest portion of the payment in the Amount field.
8. Confirm the total deposit matches the payment received.
9. Select Save and close.

Each deposit reduces the loan balance and records interest income separately. This entry structure keeps your loan balances and interest records accurate.

How to Set Up a Note Receivable Account in QuickBooks Desktop?

In QuickBooks Desktop, a loan your business gives out is tracked using a Note Receivable asset account.

1. Go to Lists in the top menu, then select Chart of Accounts.
2. Click the Account button, then select New.
3. Select Other Account Types, then choose the account type that matches the repayment timeline:
   • Other Current Assets: loan scheduled for repayment within the current year.
   • Other Asset: loan scheduled for repayment beyond the current year.
4. Click Continue.
5. Enter a descriptive name in the Account Name field, such as Note Receivable – [Borrower Name].
6. Add an optional description for reference.
7. Click Save & Close.

How to Record Loan Payment Receivable in QuickBooks Desktop?

Step 1: Record the original loan using a Check

1. Go to Banking, then select Write Checks.
2. In the Bank Account field, select the account you used to fund the loan.
3. In the Pay to the Order of field, enter the borrower’s name.
4. In the Amount field, enter the loan amount.
5. In the Expenses tab, select the Note Receivable asset account you created.
6. Click Save & Close.

This entry records the loan amount under the Note Receivable asset account. 

Step 2: Record repayments using Make Deposits

1. Go to Banking, then select Make Deposits.
2. When the Payments to Deposit window appears, click Cancel to close it.
3. In the Deposit To field, select the bank account where you received the payment.
4. Enter the payment date and an optional memo.
5. In the Received From column on the first line, enter the borrower’s name.
6. In the From Account column, select the Note Receivable asset account.
7. In the Amount column, enter the principal portion of the payment.
8. On the second line, enter the borrower’s name again in the Received From column.
9. In the From Account column, select the account you use to track Interest Income (listed under Other Income type).
10. Enter the interest portion of the payment in the Amount column.
11. Click Save & Close.

After recording each repayment, review the Note Receivable account balance to confirm it decreased correctly.

How to Record Interest Income Correctly in QuickBooks?

Interest income and principal repayment represent two separate transactions. Combining both amounts in one entry creates an inaccurate balance sheet and income records.

Here is how to handle each component:

• Principal repayment reduces the loan asset account balance on the balance sheet.
• Interest income records earned revenue in an income account. Use the Interest Income account under the Other Income category.
• Calculate the interest for each payment period manually using the loan balance, rate, and period before entering any figures.
• Keep a written record of each calculation alongside payment documentation for audit purposes.
• Run a Balance Sheet report periodically to confirm the loan asset balance matches your amortization schedule.

Accurate interest income recording also matters for tax reporting; interest earned on loans your business extends is taxable income.

Common Mistakes While Recording Loan Receivable Payments

Incorrect loan entries create balance sheet errors and inaccurate repayment records. Review these common mistakes before recording repayments:

• Recording the loan in a liability account instead of an asset account incorrectly inflates your liabilities.
• Mixing up loan payable and receivable entries creates a distorted balance sheet that is difficult to reconcile.
• Failing to separate interest from principal combines income with a balance sheet reduction, making both figures inaccurate.
• Recording the same payment twice as deposits produces overstated income and an incorrect bank balance.
• Setting up the loan under the wrong account type, for example, using Accounts Receivable instead of an Other Current Asset, breaks your aging reports and customer balance tracking.
• Missing payment documentation makes it impossible to verify loan balances or support an audit.

QuickBooks Loan Manager Discontinuation Notice

QuickBooks Desktop Loan Manager was discontinued with the release of QuickBooks Desktop 2022 and Enterprise 22.0. This affects all versions from 2022 onward, including 2023, 2024, and beyond.

Before the discontinuation, the Loan Manager automated principal repayment and interest expense entries. Current QuickBooks Desktop versions require manual loan tracking. You now enter each payment component manually.

What this means for current users:

• You need the principal and interest breakdown for each payment before recording it.
• Use the amortization schedule from the loan agreement as your reference.
• Use your loan amortization schedule to calculate the principal and interest portions for each payment. 
• Current QuickBooks Desktop versions require manual loan tracking and payment allocation. 

If you still use a pre-2022 version, Loan Manager remains available. However, Intuit no longer supports those older versions for security updates.

Tips to Maintain Accurate Loan Receivable Records

Use these practices to maintain accurate loan balances and organized financial records throughout the year:

• Reconcile your loan asset account balance against the amortization schedule at the end of each month.
• Keep a copy of the signed loan agreement in your records with the borrower’s name, interest rate, repayment schedule, and start date.
• Verify each payment allocation between principal and interest before posting to QuickBooks.
• Track interest income in a dedicated Interest Income account, separate from operating revenue.
• Review your Balance Sheet monthly to confirm loan balances are decreasing at the expected rate.
• Back up your QuickBooks company file regularly, especially before recording large or multi-period adjustments.

When to Contact a QuickBooks Accountant or Support Professional

Some loan repayment structures require advanced accounting adjustments and professional review to prevent reporting inaccuracies:

• Your loan asset balance does not match your amortization schedule after several months of entries.
• The loan carries a variable interest rate or a non-standard repayment structure.
• You need to record multiple loans to the same borrower with different terms.
• You are unsure whether to use a journal entry or a deposit to correct a prior period error.
• Your Profit and Loss or Balance Sheet shows figures that do not align with your actual loan activity.

An accountant can also help you set up memorized transactions in QuickBooks Desktop to simplify recurring monthly entries.

Conclusion

To record loan payment receivable in QuickBooks correctly, you must use the proper asset account and separate principal from interest for every payment. QuickBooks Online records repayments through Bank Deposits, while QuickBooks Desktop uses Write Checks and Make Deposits. Since QuickBooks does not calculate interest automatically, accurate manual tracking is essential. Review balances regularly, maintain loan agreements, and verify payment allocations to keep your financial records accurate and audit-ready.

Frequently Asked Questions