This guide shows you how to properly categorize a loan deposit in QuickBooks so your books stay accurate and your loan balance is tracked correctly. You’ll learn the difference between recording the loan principal and the interest, and how to set up the accounts you need. You’ll need access to your QuickBooks company file (Online or Desktop) and the loan deposit details from your bank statement or lender.
What You’ll Need
- QuickBooks Online or QuickBooks Desktop with admin or accountant access.
- The bank deposit transaction for the loan (date, amount, and source).
- A loan account (Long-Term Liability or Current Liability) already set up in your Chart of Accounts.
- An income account called something like “Loan Proceeds” (optional but recommended) to record the principal portion.
Step-by-Step
- Set up a loan liability account – Go to Settings (gear icon) > Chart of Accounts (or Lists > Chart of Accounts in Desktop). Click “New” (or Ctrl+N). Choose “Other Current Liabilities” or “Long-Term Liabilities” as the account type (e.g., “Loan Payable”). Name it clearly, like “Bank Loan – ABC Bank”. Save.
- Set up a loan proceeds income account (optional) – Repeat the process and create an “Other Income” account called “Loan Proceeds”. This is used to offset the deposit so your profit and loss statement doesn’t show the loan as revenue.
- Find the bank deposit in QuickBooks – Go to the Banking or Transactions menu (or “Bank Feeds” in Desktop). Locate the deposit from your lender. If it hasn’t been downloaded, you can add it manually via “+ New” > “Bank Deposit” (or “Make Deposits” in Desktop).
- Categorize the deposit (if it’s already in the bank feed) – Click on the deposit transaction in the Banking tab. In the “Category” column, select your loan liability account (e.g., “Bank Loan – ABC Bank”). If you created a “Loan Proceeds” income account, you can instead select that account, but using the liability account directly is simpler and more common. For the amount, leave it as the full deposit.
- If you’re recording a manual deposit – Create a new Bank Deposit and select the bank account you deposited into. In the “Add funds to this deposit” section, choose the loan liability account from the “Account” dropdown. Enter the deposit amount in the “Amount” column. Save and close.
- Record the loan interest (if the deposit includes interest) – If the deposit includes an interest portion (e.g., a loan disbursement with prepaid interest), you need to split the deposit. In the deposit window, add two lines: one for the principal (liability account) and one for interest expense (e.g., “Interest Expense”). The total must equal the deposit amount.
- Review the balance sheet – After categorizing, go to the Balance Sheet report. You should see the loan liability account with a credit balance (negative on the asset side, positive on the liability side). This represents the amount you owe.
- Reconcile the account – When you reconcile your bank account, the deposit will appear as a cleared transaction. Mark it as cleared so your reconciliation matches your bank statement.
Common Mistakes
- Categorizing the deposit as income – This is the most common error. It makes your profit and loss show revenue that isn’t really income, and your loan liability is never recorded, so your balance sheet is wrong.
- Forgetting to set up a liability account – If you use a generic “Other Income” account, you won’t have a loan balance to track repayments against.
- Mixing principal and interest – If the deposit includes interest, you must split it. Otherwise, you’ll overstate the loan principal and understate interest expense.
- Using an asset account for the loan – A loan is money you owe, so it’s a liability, not an asset. Using an asset account will make your balance sheet look like you own something you don’t.
Tips
- Use a separate liability account for each loan – This makes it easy to track multiple loans and their balances individually.
- Record the loan origination fee separately – If you paid a fee, record it as an expense (e.g., “Loan Origination Fee”) when you record the deposit, reducing the net cash received.
- Consider using a loan tracking tool – QuickBooks has a built-in Loan Manager (Desktop) or you can use a third-party app to track principal and interest payments automatically. But for the initial deposit, the manual categorization works fine.
- Keep your Chart of Accounts clean – Use clear, descriptive names for liability accounts so you can easily identify them in reports.
Troubleshooting
- The deposit doesn’t appear in the bank feed – It may not have been downloaded yet. Go to the Banking tab and click “Update” or “Refresh” to sync. If it still doesn’t show, add it manually as a Bank Deposit.
- The category dropdown doesn’t show my loan account – Make sure the account is active and not a sub-account. If it’s inactive, go to Chart of Accounts, find the account, and set it to active.
- The deposit is already categorized as income – You can edit the transaction. Go to the Banking tab, click the deposit, and change the category to the loan liability account. Or, if it’s already in your books, find the deposit in the register and edit it.
- My balance sheet shows a negative liability – This can happen if you accidentally recorded the deposit as a payment (debit) to the liability. Check the transaction: a deposit should be a debit to the bank and a credit to the liability. If it’s reversed, edit the transaction to correct the account or the amount.
- The deposit amount includes fees deducted – If the lender deducted fees before depositing, you only see the net amount. Record the net deposit as the liability, and then record the fee as an expense with a journal entry (debit expense, credit loan liability) to reflect the full loan amount.
Frequently Asked Questions
Q: Should I categorize a loan deposit as income?
A: No. A loan is not income; it’s a liability. Categorizing it as income overstates your revenue and understates your debts. Use a liability account.
Q: What if I don’t have a loan liability account?
A: You need to create one. Go to Chart of Accounts, click New, choose “Other Current Liabilities” or “Long-Term Liabilities”, and name it appropriately. Then use it for the deposit.
Q: How do I record a loan deposit that includes interest?
A: Split the deposit into two lines: one for the loan principal (liability) and one for interest expense (or a prepaid interest asset if it’s for future periods). The total must equal the deposit amount.
Q: Can I categorize a loan deposit as an owner’s equity contribution?
A: Only if the loan is from the owner to the business. In that case, you could use an equity account like “Owner’s Loan”. But if it’s from a bank or third party, it must be a liability.
Q: What happens if I categorize it wrong and need to fix it?
A: You can edit the transaction. Go to the bank register or Banking tab, find the deposit, and change the account to the correct liability account. QuickBooks will update your reports automatically.
Q: How do I handle loan repayments after the deposit?
A: When you make a payment, split it between the loan liability (principal) and interest expense. The principal reduces the liability balance, and the interest is an expense. This keeps your loan balance accurate over time.
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
- QNB Car Loan Payment Calculator and Guide$405.53
- Car Loan Payment Calculator and Formula$405.53
- VA Down Payment Assistance Calculator and Guide$15,000.00
- Low Down Payment Home Loans: Costs and Trade-Offs$405.53
- Down Payment vs Advance Payment: Key Differences
- Down Payment Assistance Grant Calculator$5,000.00