calculate-loan

01 Loan payments

Enter Loan Deposit in QuickBooks: Step-by-Step Guide

Guide 01-24711 · Updated · Step by step

Recording a loan deposit in QuickBooks correctly ensures your balance sheet reflects the loan liability and your bank account shows the funds received. This guide walks you through entering the deposit, setting up the loan account, and avoiding common pitfalls. You’ll need access to your QuickBooks account with permission to create journal entries and bank deposits.

What You’ll Need

  • QuickBooks Online or Desktop (steps below work for both, with minor menu differences)
  • The loan deposit amount and date
  • The name of the lender (e.g., bank, credit union, private lender)
  • Your Chart of Accounts — you may need to create a “Loan Payable” liability account if it doesn’t exist
  • Bank account where the deposit will be received

Step-by-Step

  1. Create a Loan Payable account (if needed): Go to Settings (gear icon) → Chart of Accounts → New. Choose Account Type: Long Term Liabilities (or Other Current Liabilities if it’s a short-term loan). Detail Type: Notes Payable or Loan Payable. Name it “Loan Payable – [Lender Name]”. Save.
  2. Record the loan deposit as a Bank Deposit: Go to the + New button → Bank Deposit.
  3. Select the bank account: In the “Account” dropdown, choose the bank account where the loan funds were deposited.
  4. Enter the date and deposit amount: Set the date to when the funds hit your bank. In the “Add funds to this deposit” section, enter the loan amount.
  5. Choose the correct account: In the “Account” column, select the “Loan Payable” account you created. Leave the “Name” column blank (or select the lender if you have a vendor record). Add a memo like “Loan proceeds from [Lender]”.
  6. Save the deposit: Click Save and Close or Save and New. This increases your bank balance and increases the loan liability.
  7. Verify the balance sheet: Run a Balance Sheet report (Reports → Balance Sheet). You should see the loan amount under Liabilities and the same amount under Bank Accounts.

Common Mistakes

  • Recording the deposit as income: This overstates profit and understates liabilities. Loan proceeds are not revenue.
  • Using a single journal entry instead of a bank deposit: While a journal entry can work, using Bank Deposit is cleaner and automatically links to the bank feed.
  • Forgetting to create a Loan Payable account: Using “Uncategorized Income” or “Owner’s Equity” misclassifies the transaction.
  • Entering the deposit twice: If you also receive a bank feed transaction, make sure to match it to the deposit you created, not add a new one.

Tips

  • Set up a separate liability account for each loan to track balances individually.
  • Use the memo field to note the loan number or purpose.
  • If you use QuickBooks Online, consider using the “Loan Manager” (in some versions) or a third-party app for full loan amortization tracking.
  • For loan payments (principal + interest), record them as a Check or Expense, splitting the principal to the Loan Payable account and interest to an Interest Expense account.

Troubleshooting

Deposit doesn’t appear in bank feed: If the bank feed shows the deposit separately, match it to the deposit you created. Go to Banking → Review, find the transaction, and select “Match” to link it.

Balance sheet shows a negative liability: This happens if you recorded the deposit as a payment to the loan instead of an increase. Check the deposit entry — the account should be Loan Payable, not the bank account.

Can’t find the Bank Deposit option: In QuickBooks Online, it’s under + New → Bank Deposit. In Desktop, it’s under Banking → Make Deposits. If you don’t see it, your user role may lack permissions.

Loan amount includes fees deducted: If the lender deducted fees before depositing (e.g., origination fee), record the full loan amount as the deposit and the fee as an expense. For example, if you borrowed $10,000 but received $9,700, enter $10,000 as the deposit, then create an expense for $300 to “Loan Origination Fees”.

Frequently Asked Questions

Q: Should I record a loan deposit as income?
A: No. Loan proceeds are not income; they increase a liability. Recording as income inflates profit and can mislead financial reports.

Q: Can I use a journal entry instead of a bank deposit?
A: Yes. Debit Bank Account, Credit Loan Payable. But using Bank Deposit is simpler and ties directly to the bank feed.

Q: What if I already recorded it as income?
A: Reverse the income entry (debit Income, credit Bank) and then create the correct Bank Deposit with Loan Payable.

Q: How do I record loan payments after the deposit?
A: Create a Check or Expense for the payment amount. Split the transaction: debit Loan Payable for the principal portion and Interest Expense for the interest portion.

Q: Do I need to track interest separately?
A: Yes, for accurate profit and loss. Interest is an expense; principal is not.

Q: What if the loan is from a personal friend or family member?
A: Treat it the same as any loan. Create a Loan Payable account and record the deposit. This keeps your financial statements accurate.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this section

The whole Loan payments section →