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 and Mac.

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 vendor (Bank/lending company)

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

  1. Go to the Vendors menu, then select Vendor Center.
  2. Select New Vendor.
  3. Enter the name of the bank or the company you need to pay for the loan.
  4. (Optional) Enter other vendor 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:

    User-added image

    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.

    User-added image

    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.

User-added image

  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.

QuickBooks Desktop for Mac

Learn how to manually track loans in QuickBooks Desktop for Mac.

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. Select the + icon to add a new account.
  3. From the Type field, select the account for your loan:
    • Other Current Liability: for short-term loans payable over one year.
    • Long Term Liability: for long-term loans payable over a longer period.
  4. Enter the name and number for the account.
  5. Leave the opening balance at zero.
  6. Select OK.

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

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

  1. Go to the Vendors menu, then select Vendor Center.
  2. Select the +icon, then select New Vendor.
  3. Enter the name of the bank or the company you need to pay for the loan.
  4. (Optional) Enter other vendor details such as phone number and email address.
  5. Select OK.

Step 3: Record the loan amount

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

Cash loans

User-added image

  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. In the From Account column, select the liability account you created in Step 1.
    3. In the Amount column, enter the loan amount.
    4. Select Save.

Non-cash loans

  1. Create an asset account.
    1. Go to the Lists menu, then select Chart of Accounts.
    2. Select the + icon to add a new account.
    3. Select the asset account for your 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 OK.
  2. Enter a journal entry.

    User-added image

    1. Go to the Company menu, then select Make General Journal Entries.
    2. Enter the Date and journal Entry Number.
    3. Select the first line and debit the loan asset account.
    4. Select the second line and credit the liability account.
    5. Select Save.

Step 3: Record the loan amount

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.

User-added image

  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 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 Edit.
    2. Select Memorize Check.
    3. Select OK.
  7. Select Save & Close.

Was this helpful?

You must sign in to vote, reply, or post

Need to get in touch?

Contact us