cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Intuit

Manually track loans in QuickBooks Desktop

Learn how to set up accounts for your loans, and manually track them in QuickBooks Desktop for Windows .

Cash and non-cash asset loans such as vehicles and office equipment are liabilities for your company. QuickBooks lets you track the loan amount and record your payments so you can stay on top of it. We'll show you how.

Note: If you want to keep track of your loans and be reminded about upcoming payments, you can track and manage your loans with the QuickBooks Loan Manager.

QuickBooks Desktop for Windows

Start tracking your loans in QuickBooks Desktop for Windows.

Step 1: Set up a liability account

When you record a loan in QuickBooks, you need to select a liability account for it. Here’s how to set up a liability account for your loan.

  1. Go to the Lists menu, then select Chart of Accounts.
  2. Right-click anywhere, then select New.
  3. Select Other Account Types, then select the right account type for your loan:
    • Other Current Liability: Use this for short-term loans payable over one year.
    • Long Term Liability: Use this for long-term loans payable over a longer period.
  4. Select Continue.
  5. Enter the name and number for the account.
  6. Select Save & Close.

Step 2: Set up the supplier (Bank/lending company)

Create a new supplier for the bank or company you need to pay for the loan.

  1. Go to the Suppliers menu, then select Supplier Centre.
  2. Select New Supplier.
  3. Enter the name of the bank or the company you need to pay for the loan.
  4. (Optional) Enter other supplier details such as phone number and email address.
  5. Select OK.

Step 3: Set up an expense account

Create an expense account so you can track interest payments or fees and charges.

  1. Go to the Lists menu, then select Chart of Accounts.
  2. Right-click anywhere, then select New.
  3. Select Expense, then Continue.
  4. Enter the account name for the interest payments or fees and charges.
  5. Select Save & Close.

Step 4: Record the loan amount

Now that you have a liability account for the loan, here’s how to record the loan amount.

Cash loans

  1. Go to the Banking menu, then select Make Deposits.
  2. If the Payments to Deposit window opens, select Cancel.
  3. In the Make Deposits window:
    1. In the Deposit To field, select the account to deposit the loan into.
    2. Check the Date and enter an optional Memo.
    3. In the From Account column, select the Liability account you created in Step 1.
    4. In the Amount column, enter the loan amount.
    5. Select Save & Close.

Non-cash loans

  1. Create an asset account.
    1. Go to the Lists menu, then select Chart of Accounts.
    2. Right-click anywhere, then select New.
    3. Select the account type for your non-cash loan:
      • Fixed Asset: Use this for items that have useful value for more than a year (vehicles, buildings, and so on)
      • Other Current Asset: Use this for items with value that can be converted to cash (like prepaid expenses)
      • Other Asset: Use this for items that are neither Fixed Assets nor Other Current Assets.
    4. Select Continue.
    5. Enter the name and number for the account.
    6. When you’re done, select Save & Close.
  2. Enter a journal entry.
    1. Go to the Company menu, then select Make General Journal Entries.
    2. Enter the Date and journal Entry No.
    3. Select the first line and debit the loan asset account.
    4. Select the second line and credit the liability account.
    5. Select Save & Close.

Step 4: Record loan payments

Reminders:

  • QuickBooks records the payment for the principal amount as a deduction to the liability account. Once you complete all the payments, the value of the liability account will turn to zero.
  • QuickBooks records the interest payment as a company expense.

  1. Go to the Banking menu, then select Write Checks.
  2. Select the Bank Account you want to use to pay the loan.
  3. Verify the Check NO. and Date.
  4. In the Pay to the Order of field, select the name of the bank.
  5. In the Expenses tab:
    1. On the first line, select the liability account you created in Step 1. Then enter the payment for the principal amount.
    2. On the second line, select the interest expense account. Then enter the payment for the loan interest.
  6. (Optional) Memorize the check if you want QuickBooks to automatically enter the payment at regular intervals.
    1. Select Memorize.
    2. Fill out the fields as needed.
    3. Select OK.
  7. When you’re done, select Save & Close.

Was this helpful?

You must sign in to vote, reply, or post