QuickBooks Loan Manager

Learn how to track your loan with the help of Loan Manager in QuickBooks Desktop.

QuickBooks Loan Manager helps you calculate interest and payment schedules. We’ll help you get started so you can track your new and existing loans, make repayments, and run different “what-if” scenarios to compare different loan options.

Note: Loan Manager was discontinued in QuickBooks Desktop 2022. You can still use Loan Manager in previous, currently supported versions.

Step 1: Set up the accounts for QuickBooks Loan Manager

Set up a liability, vendor, and expense account

Before you can track loans with QuickBooks Loan Manager, you first need to set up liability, vendor, and expense account.

Set up an escrow account

An escrow is a portion of a loan that's managed by a third-party until you fulfill the loan conditions. In QuickBooks, an escrow account is an asset account that tracks the escrow portion of a loan payment.

Here’s how to set up an escrow account if you need one for your loan.

1. Go to the Lists menu, then select Chart of Accounts.
2. Select the Account dropdown, then New.
3. Select Other Account Types, then Other Current Asset.
4. Select Continue.
5. Enter the account name.
6. Select Save & Close.

Step 2: Record and track your loans

If everything is all set, you can now track your loan in QuickBooks Loan Manager.

1. Go to the Banking menu, then select Loan Manager.
2. Select Add a Loan.
3. Enter the account info for the loan.
   • Account Name: Select the loan account you previously made.
   • Lender: Select the vendor you will pay for the loan.
   • Origination Date: Enter the date when the loan is funded.
   • Original Amount: Enter the full, initial loan amount.
   • Term: Select the time it will take to repay the loan.
4. When you’re ready, select Next.
5. Enter the payment info for the loan.
   • Due Date of Next Payment: Enter the due date for your next payment
   • Payment Amount: Enter the amount you need to pay for each period.
   • Next Payment Number: If you already made payments before, enter the payment number for the following payment.
   • If the loan has an escrow payment account, select Yes. Then fill out the necessary fields.
   • (Optional) If you want a reminder for upcoming payments, select Alert me 10 days before a payment is due.

   Note: If you already made payments for the loan, you need to enter these as checks, bills, or journal entries.

6. Select Next.
7. Enter the interest info for the loan.
   • Interest Rate: Enter the interest rate of the loan. For example, enter a 5% interest rate as 5.
   • Compounding Period: Select what’s specified on your loan documents.
   • Payment Account: Select the bank account you want to use to pay the loan.
   • Interest Expense Account: Select the expense account that will track the interest.
   • Fees/Charges Expense Account: Select the expense account that will track the fees and charges of your loan.
8. When you're done, select Finish.

Note: You can see your loan details in the Summary tab of Loan Manager.

Step 3: Assess your loan with What If Scenarios tool

To compare different loan options and to see what else you can do with your loan in different scenarios, use the What If Scenarios tool.

1. Go to the Banking menu, then select Loan Manager.
2. Select What If Scenarios.
3. In the Choose a scenario dropdown, select a loan scenario.
4. In the Choose a loan dropdown, select the loan account you want to evaluate.
5. Fill out the fields as needed, then select Calculate.
6. (Optional) Select Print to print the results.