QuickBooks HelpQuickBooksHelpIntuit

Manually track loans in QuickBooks Desktop

by Intuit1 Updated 4 weeks ago

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 keep your payments updated and never miss one. Here’s how.

Note: You can also keep track of your loans and get reminders about upcoming payments 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

Set up a liability account for your loan. You’ll need this when you record your loan amount and payments.

  1. Go to the Lists menu, then select Chart of Accounts or press Ctrl + A on your keyboard.
  2. Select the Account ▼ dropdown, then select New or press Ctrl + N on your keyboard.
  3. Select Other Account Types, then select the account type for your loan:
    • Select Other Current Liability for loans that are payable within a year.
    • Select Long Term Liability for loans that are payable over more than a year.
  4. Select Continue.
  5. Fill out the Number and Account Name fields.
    Notes:
    • You can select the Subaccount of checkbox if you want to link the account to an existing one.
    • You can fill out the fields in the OPTIONAL section if you want to add more info for easier tracking.
  6. Select Save & Close.

Step 2: Set up a vendor

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

  1. Go to the Vendors menu, then select Vendor Center.
  2. Select the New Vendor dropdown, then select New Vendor.
  3. In the VENDOR NAME field, enter the name of the bank or lending company you need to pay for the loan.
    Notes:
    • You can enter an opening balance for easier tracking.
    • You can enter other vendor details when you select Address Info, Payment Settings, and other tabs on the left menu.
  4. Select OK.

Step 3: Set up an expense account

Create an expense account so you can track interest payments or fees and charges associated with the loan.

  1. Go to the Lists menu, then select Chart of Accounts or press Ctrl + A on your keyboard.
  2. Select the Account ▼ dropdown, then select New or press Ctrl + N on your keyboard.
  3. Select Expense, then select Continue.
  4. Fill out the Number and Account Name fields.
    Notes:
    • You can select the Subaccount of checkbox if you want to link the account to an existing one.
    • You can fill out the fields in the OPTIONAL section if you want to add more info for easier tracking.
  5. Select Save & Close.

Step 4: Record the loan amount

Record the loan amount and link it to the liability account you created in Step 1.

  1. Go to the Banking menu, then select Make Deposits.
  2. If the Payments to Deposit window opens, select Cancel to close it.
  3. Select the Deposit To ▼ dropdown, then select the account you want to deposit the loan into.
  4. Select the date when you received the cash loan. You can also enter an optional note in the Memo field.
  5. In the FROM ACCOUNT column, enter the name of the liability account you created in Step 1.
    Note: You can also use the ▼ dropdown and select it from there.
  6. In the AMOUNT column, enter the loan amount. You can also fill out the other fields for easier tracking.
  7. Select Save & Close.

You’ll need to create an asset account and a journal entry for non-cash loans.

  1. Create an asset account
    1. Go to the Lists menu, then select Chart of Accounts or press Ctrl + A on your keyboard.
    2. Select the Account ▼ dropdown, then select New or press Ctrl + N on your keyboard.
    3. Select the asset account type for your non-cash loan:
      • Select Fixed Asset (major purchases) for items that have useful value for more than a year such as buildings, land, machinery and equipment, or vehicles.
      • Select Other Account Types, then select Other Current Assets for items that you can convert to cash or use within a year.
      • Select Other Account Types, then select Other Asset for items that are neither fixed assets nor other current assets.
    4. Select Continue.
    5. Fill out the Number and Account Name fields.
      Notes:
      • You can select the Subaccount of checkbox if you want to link the account to an existing one.
      • You can fill out the fields in the OPTIONAL section if you want to add more info for easier tracking.
    6. Select Save & Close.
  2. Create a journal entry.
    1. Go to the Company menu, then select Make General Journal Entries….
    2. Fill out the DATE and ENTRY NO. fields.
      Note: If the ADJUSTING ENTRY checkbox is selected, uncheck it.
    3. Select the first line. In the ACCOUNT column, enter the asset account name you created earlier.
    4. In the DEBIT column, enter the loan amount.
    5. Select the second line. In the ACCOUNT column, enter the liability account name you created in Step 1.
    6. In the CREDIT column, enter the loan amount.
    7. Select Save & Close.

Step 5: Record loan payments

Follow these steps to record your loan payments.

  1. Go to the Banking menu, then select Write Checks or press Ctrl + W on your keyboard.
  2. From the BANK ACCOUNT dropdown, select the bank account you want to use to pay the loan.
  3. Verify the details in the NO. and DATE fields. You can edit them as needed.
  4. In the PAY TO THE ORDER OF dropdown, select the vendor you created in Step 2.
  5. In the $ field, enter the payment for the principal amount.
    Note: This automatically fills out the AMOUNT field in the Expenses tab.
  6. In the Expenses tab, select the first line, then select the ACCOUNT field.
  7. Enter the name of the liability account you created in Step 1.
    Note: You can also use the ▼ dropdown and select it from there.
  8. Select the second line. In the ACCOUNT field, enter the name of  the expense account you created in Step 3.
  9. Enter the payment amount for the loan interest.
    Note: If you want QuickBooks to record payments at regular intervals for this loan, follow these steps:
    1. Select Memorize .
    2. In the Memorize Transaction window, set your preferences.
    3. Select OK.
  10. Select Save & Close.

QuickBooks Desktop for Mac

Start tracking your loans in QuickBooks Desktop for Mac.

Step 1: Set up a liability account

Create a liability account for your loan. You’ll need this later.

  1. Go to the Lists menu, then select Chart of Accounts.
  2. Select + to add a new account.
  3. In the Type field, select the account type for your loan:
    • Select Other Current Liability for loans that are payable within a year.
    • Select Long Term Liability for loans that are payable over more than a year.
  4. Enter the name and number for the account.
  5. Leave the opening balance at zero.
  6. Select OK.

Step 2: Set up a vendor

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

  1. Go to the Vendors menu, then select Vendor Center.
  2. Select +, then select New Vendor.
  3. Enter the name of the bank or lending company you need to pay for the loan.
    Note: You can enter other vendor details such as their phone number and email address.
  4. Select OK.

Step 3: Record the loan amount

Record the loan amount and link it to the liability account you created in Step 1.

  1. Go to the Banking menu, then select Make Deposits.
  2. If the Payments to Deposit window opens, select Cancel to close it.
  3. In the Received fromcolumn, use the dropdown to find and select the account name you want to deposit the loan into.
  4. In the From Account column, use the dropdown to find and select the liability account you created in Step 1.
  5. In the Amount column, enter the loan amount.
  6. Select Save.

You’ll need to create an asset account and a journal entry for non-cash loans.

  1. Create an asset account.
    1. Go to the Lists menu, then select Chart of Accounts.
    2. Select + to add a new account.
    3. Select the asset account type for your non-cash loan:
      • Select Fixed Asset (major purchases) for items that have useful value for more than a year such as buildings, land, machinery and equipment, or vehicles.
      • Select Other Current Assets for items that you can convert to cash or use within a year.
      • Select Other Asset for items that are neither fixed assets nor other current assets.
    4. Select OK.
  2. Create a journal entry.
    1. Go to the Company menu, then select Make General Journal Entries.
    2. Fill out the Date and Entry Number fields.
    3. Select the first line. In the Account column, enter the asset account name you created earlier.
    4. In the Debit column, enter the loan amount.
    5. Select the second line. In the Account column, enter the liability account name you created in Step 1.
    6. In the Credit column, enter the loan amount.
    7. Select Save.

Step 4: Record loan payments

Follow these steps to record your loan payments.

Notes:

  • QuickBooks records payments for the principal amount as a deduction to the liability account.
  • Once you complete all the payments, the liability account turns zero.
  • QuickBooks records interest payments as company expenses.
  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 details in the No. and Date fields. You can edit them as needed.
  4. In the Pay to the Order of field, select the vendor you created in Step 2.
  5. In the Expenses tab, select the first line, then select the Account field.
  6. Use the dropdown to find and select the liability account you created in Step 1.
  7. In the Amount field, enter the payment for the principal amount.
  8. Select the second line, then select the interest expense account.
  9. In the Amount field, enter the payment amount for the loan interest.
    Note: If you want QuickBooks to record payments at regular intervals for this loan, follow these steps:
    1. Select Edit, then select Memorize Check.
    2. Select OK.
  10. Select Save & Close.
QuickBooks Accountant Desktop PlusQuickBooks Desktop Enterprise AccountantQuickBooks Desktop Enterprise DiamondQuickBooks Desktop Enterprise GoldQuickBooks Desktop Enterprise PlatinumQuickBooks Desktop Mac PlusQuickBooks Desktop Premier PlusQuickBooks Desktop Pro Plus

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this