how to set up a loan in quickbooks desktop

QuickBooks Desktop: Step-by-Step Loan Setup Guide

By Daniel Thomas
AD

Setting up a loan in QuickBooks Desktop is a critical function for managing your business's finances effectively. This step-by-step guide will walk you through the process, ensuring you're armed with essential knowledge to streamline your loan tracking.

Before we dive into the setup process, it's crucial to understand that QuickBooks Desktop supports two types of loans: Bank Loans and Credit Card Loans. For this guide, we'll focus on Bank Loans, which are more common and versatile.

Setting Up a New Loan

To begin, navigate to the 'Loans' menu, then select 'Loan Balance.' This will open the Loan Balance Center, where you can view and manage your loans. To add a new loan, click on 'New Loan.'

AD
How to Set Up a Loan in QuickBooks Online
How to Set Up a Loan in QuickBooks Online
How to Setup your Loans in QuickBooks
How to Setup your Loans in QuickBooks
How to Record a Loan in QuickBooks Online?
How to Record a Loan in QuickBooks Online?

Alternatively, you can access the Loan Setup window by going to the 'Company' menu, then 'Setup Loans.' Click on 'New Loan' to start the process.

Entering Loan Details

On the 'New Loan' window, fill in the required fields:

How to Use QuickBooks Loan Manager
How to Use QuickBooks Loan Manager
How to Setup a Loan in QuickBooks
How to Setup a Loan in QuickBooks
  • Name: Enter a descriptive name for the loan. It could be the lending institution's name or a unique identifier.
  • Initial Amount: Input the initial loan amount received.
  • Interest Rate: Enter the interest rate set by the lender.
  • Interest To Date: Leave this field blank; QuickBooks will calculate it automatically.
  • Account: Choose an existing Liability account to track the loan, or create a new one.
  • Due Date: Set the loan's maturity date, the date it needs to be repaid in full.

Note: Additional fields like 'Payment Terms,' 'Final Payment Date,' and 'Start Date' can be filled in if your loan terms require it.

Setting Up Loan Payments

Once you've entered the loan details, click 'Next' to set up loan payments. Here, you can choose whether to have QuickBooks remind you of payment due dates or automate the payment process:

AD
  • Automatically create loan payments: Check this box if you want QuickBooks to automatically create payments based on the loan agreement schedule.
  • Alt+Control+Y – Remember Loan Due Dates: Check this box if you prefer reminders for loan due dates.

Choose the method that best fits your bookkeeping style, then click 'Next' to proceed.

Finally, review your loan setup on the 'Review' window. Verify all information is correct, then click 'Finish' to create the loan. QuickBooks will create a loan account and begin tracking your loan balance, payment history, and interest expenses.

Recording Loan Payments

After setting up your loan, you can record partial or full loan payments as they occur. To do this, go to the 'Banking' menu, then 'Write Checks.'

AD

In the 'Payee' field, select your loan account (e.g., 'Loan - XYZ Bank'). Enter the check amount as the loan repayment. You can also enter a reference or memo explaining the payment. When you're done, click 'Save & New' or 'Save & Close' to record the payment.

Recording Interest Expenses

QuickBooks automatically tracks loan interest expenses. To view and manage these expenses, go to the 'Loans' menu, then 'Loan Balance.'

Here, you'll find a list of your loans and their balances. Select the loan you want to view, then click on 'View Loan Detail.' This will open the Loan Detail window, where you can view interest charges, payments, and the loan's amortization schedule. Use this information to track your loan's progress and ensure you're on track with your repayment plan.

AD

A well-managed loan can help grow your business, and QuickBooks Desktop provides the tools you need to keep track of your loans easily. By following this guide, you'll be able to set up and manage your loans seamlessly, ensuring your financial records remain accurate and organized.

AD