Table of Contents
- Introduction
- Step 1: Set Up a Loan Receivable Account
- 1.1: Create an Asset Account for the Loan
- Step 2: Record the Loan Disbursement
- 2.1: Record the Loan as a Transaction
- Step 3: Record Loan Payments
- 3.1: Set Up the Payment Schedule
- 3.2: Record a Payment
- 3.3: Apply Payments to the Loan Balance
- Step 4: Record Interest (if applicable)
- 4.1: Set Up an Interest Income Account
- 4.2: Record Interest Payments
- Step 5: Monitor and Report on Loan Receivables
- 5.1: Generate Reports
- 5.2: Review Interest Income
- Best Practices for Managing Loan Receivables
- Conclusion
Introduction
When your business lends money to an individual or another business, it’s essential to record that transaction correctly in QuickBooks. This type of transaction is known as a loan receivable, as your business expects to receive payments back over time. Properly tracking a loan receivable in QuickBooks ensures that you can monitor repayments, recognize interest income, and keep accurate financial records. This guide provides a step-by-step process to record a loan receivable in QuickBooks.
Step 1: Set Up a Loan Receivable Account
1.1: Create an Asset Account for the Loan
- Log in to QuickBooks: Open QuickBooks and log in to your account.
- Go to the Chart of Accounts: Navigate to
Accounting > Chart of Accounts. - Create a New Account: Click
Newin the upper-right corner to add a new account. - Select Account Type: From the account type options, choose
Other Current AssetsorNon-Current Assetsdepending on the loan duration.
- If the loan is expected to be repaid within a year, choose
Other Current Assets. - If the loan will be repaid over more than a year, select
Non-Current Assets.
- Detail Type: Select
Loan to Othersfrom the detail type options. - Name the Account: Give the account a descriptive name like “Loan Receivable – [Borrower’s Name].”
- Save the Account: Click
Save and Closeto add the account to your Chart of Accounts.
Step 2: Record the Loan Disbursement
2.1: Record the Loan as a Transaction
+ New and select Journal Entry from the list.- In the first line, choose the loan receivable account you just created.
- Enter the loan amount in the
Debitcolumn to record the amount lent.
- On the second line, select the bank account from which the loan was disbursed.
- Enter the loan amount in the
Creditcolumn to reflect the money leaving the bank account.
- Memo: Optionally, add a memo that explains the loan, such as “Loan to [Borrower’s Name] on [Date].”
- Save and Close: Once the entry is complete, click
Save and closeto record the loan disbursement.
Step 3: Record Loan Payments
3.1: Set Up the Payment Schedule
3.2: Record a Payment
+ New, then select Receive Payment from the list.- In the
Deposit tofield, choose the bank account where the payment will be deposited. - In the
Accountfield, select the loan receivable account you created earlier.
- Input the amount received from the borrower.
- If applicable, enter any interest paid as a separate line item and select an
Interest Incomeaccount.
- Save the Payment: Once the details are entered, click
Save and closeto record the payment.
3.3: Apply Payments to the Loan Balance
Customer Payments or Transaction List by Customer report to ensure that the payments are correctly applied to the loan receivable account.Step 4: Record Interest (if applicable)
4.1: Set Up an Interest Income Account
Accounting > Chart of Accounts.New and select Income as the account type.Interest Income from the detail type options.Save and Close.4.2: Record Interest Payments
Receive Payment screen.- Record the principal portion of the payment against the loan receivable account.
- Record the interest portion of the payment against the new
Interest Incomeaccount.
- Save the Payment: Once all details are entered, click
Save and close.
Step 5: Monitor and Report on Loan Receivables
5.1: Generate Reports
- Go to
Reports > Transaction Detail by Account. - Filter the report by selecting the loan receivable account you created.
- This report will show all transactions related to the loan, including disbursements and payments.
- Run an
Account QuickReportfor the loan receivable account to see how much is still outstanding.
5.2: Review Interest Income
- Go to
Reports > Profit and Lossto track the interest income earned from the loan over a specified period. - You can also customize this report to focus solely on your interest income account.
Best Practices for Managing Loan Receivables
- Maintain Clear Records: Always ensure that you have a signed loan agreement and maintain detailed records of all payments and adjustments in QuickBooks.
- Set Reminders for Loan Payments: Use QuickBooks’ reminders or calendar features to track when payments are due so that you can follow up with borrowers if needed.
- Reconcile Regularly: Reconcile your loan receivable accounts and interest income accounts regularly to ensure that they match your bank statements and loan agreements.
- Consult an Accountant: For complex loans or interest calculations, it’s always a good idea to consult with an accountant to ensure that everything is recorded correctly in QuickBooks.
Conclusion
Recording a loan receivable in QuickBooks is essential for tracking the money lent by your business and ensuring proper repayment tracking. By following the steps outlined in this guide, you can easily set up a loan receivable account, record loan disbursements, and track payments. Additionally, recording any interest income ensures that your financial records remain accurate. Regular monitoring and reconciliation of the loan receivable account will help you stay on top of repayments and keep your books in order.