Recording a loan payment in QuickBooks means entering the transaction twice: once to reduce what you owe the lender, and once to show the cash leaving your account

When you make a loan payment, part of it goes toward interest (an expense) and part goes toward the principal (what you actually borrowed). QuickBooks needs both pieces to keep your books accurate. The payment reduces your loan liability account and reduces your bank balance, while the interest portion shows up as an expense on your profit and loss statement.

The exact steps depend on whether you set up the loan in QuickBooks when you first borrowed the money, or whether you're recording a loan that already exists in your records. Most small business owners use the Write Checks or Pay Bills feature, depending on how the loan was originally entered.

Key Takeaways

  • Every loan payment splits into two parts in QuickBooks: principal (reduces what you owe) and interest (records as an expense).
  • If you set up the loan as a liability when you borrowed the money, use the Pay Bills feature to record the payment against that liability.
  • If the loan was never entered in QuickBooks, use Write Checks and manually split the payment between the loan liability account and interest expense.
  • Your lender's payment statement or amortization schedule tells you exactly how much of each payment is principal versus interest.
  • Recording payments incorrectly will throw off both your balance sheet (what you owe) and your profit and loss statement (your expenses).

Setting up the loan liability account before recording payments

If you borrowed money and already created a loan account in QuickBooks, the payment process is straightforward. Go to Banking (or Transactions in newer versions), then select Pay Bills. This assumes the original loan was entered as a bill or liability.

If the loan was entered as a bill, it will appear in your unpaid bills list. Select the loan, enter the payment amount, and choose the bank account you're paying from. QuickBooks will automatically reduce both the loan liability and your bank balance. However, this method only works if the original loan entry included the interest split—and most do not.

The more common scenario is that your loan was entered as a Long-Term Liability or Loan Payable account, not as a bill. In that case, Pay Bills will not show it. You'll need to use Write Checks instead.

Using Write Checks to record a payment on an existing loan

Open Banking, then Write Checks (or Check Register in some versions). Select the bank account you're paying from. Enter the lender's name, the payment date, and the total amount of the check.

In the Category column at the bottom, you must split the payment. Click the first line and select your loan liability account (usually named something like "Loan Payable" or "Business Line of Credit"). Enter the principal amount—the portion that reduces what you owe. On the next line, select Interest Expense and enter the interest portion.

Your lender sends a payment statement or amortization schedule that breaks down each payment. If you do not have one, contact the lender and ask for the principal and interest split for the payment you're making. Without this information, you'll record the payment incorrectly and your loan balance will not match what the lender says you owe.

Finding the principal and interest split on your loan statement

Most lenders provide a payment coupon or statement with each bill that shows the breakdown. Look for lines labeled "Principal," "Interest," or "Amount Applied to Principal" and "Amount Applied to Interest." The total of these two numbers equals your payment amount.

If you have an amortization schedule (a table showing every payment over the life of the loan), use that instead. It is more reliable than a single payment statement because it shows the exact split for every payment, and you can record several months of payments at once if needed.

If your lender does not provide either, you can calculate the split yourself. Multiply your loan balance by the annual interest rate, then divide by 12 to get that month's interest. The rest of the payment is principal. For example: a $50,000 loan at 6% annual interest owes $250 in interest that month ($50,000 × 0.06 ÷ 12). If your payment is $1,000, then $750 is principal.

Recording multiple loan payments at once

If you have several months of loan payments to catch up on, enter them one at a time rather than combining them into a single entry. Each payment has a different principal-to-interest split, and combining them will make the records harder to audit later.

Open the check register for your bank account. For each payment, create a new line with the payment date, the lender's name, and the total amount. Split it into principal and interest using the amounts from your amortization schedule or lender statement. This approach is faster than opening Write Checks multiple times, and you can see all the payments in one view.

Reconciling your loan balance after recording payments

After you record several payments, verify that your loan balance in QuickBooks matches what your lender says you owe. Go to Reports, then Balance Sheet. Find your loan liability account and note the balance. Compare it to your most recent lender statement.

If the balances do not match, the most common cause is an error in the principal amount you entered. Check your last few payment entries and verify the principal split against your lender statement. If you recorded $500 as principal when it should have been $450, the difference will show up here.

If the difference is small (a few dollars), it may be a rounding error from calculating interest yourself. If it is large or persistent, contact your lender to confirm the current balance and then adjust your most recent entries to match.

What to do if the loan was never entered in QuickBooks

If you have been making loan payments but never created a loan account in QuickBooks, you need to set up the liability account first. Go to Chart of Accounts, then New. Select Liability as the account type, then Long-Term Liability (or Other Current Liability if the loan is due within a year). Name it something clear like "Equipment Loan" or "Business Line of Credit."

Once the account is created, record the original loan amount as a deposit into that account. Go to Write Checks, but instead of selecting a category, select your new loan liability account and enter the original loan amount as a negative number (or use Make Deposits and enter it as a positive deposit to the liability account). This creates the starting balance.

Then record all your payments going forward using the method described above: split each payment into principal and interest, with principal reducing the liability account and interest going to Interest Expense.

Frequently Asked Questions

What if my loan payment includes fees or insurance?

Some loans include escrow, insurance, or servicing fees bundled into the payment. Ask your lender for a breakdown that shows principal, interest, and each fee separately. In QuickBooks, create a separate line for each component: principal to the loan account, interest to Interest Expense, and fees to their own expense account (like "Loan Fees" or "Loan Insurance").

Can I set up automatic loan payments in QuickBooks?

QuickBooks does not automatically record payments based on a schedule. You must enter each payment manually. However, you can create a recurring transaction template in QuickBooks Online that you can duplicate each month, which saves time if the payment amount stays the same. In QuickBooks Desktop, you can use the memorized transaction feature for the same purpose.

What account should I use if I do not have a specific loan liability account?

Create one. Go to Chart of Accounts and add a Long-Term Liability account with a name that matches your loan (for example, "Bank Line of Credit" or "Vehicle Loan"). Using a generic account like "Miscellaneous Liability" makes it harder to track what you actually owe and to reconcile with your lender's statements.

Why does my loan balance in QuickBooks not match my lender's statement?

The most common reason is an error in the principal-to-interest split. Verify your last few payments against your lender's statement and correct any entries where the principal amount was wrong. A second cause is a payment that was recorded in QuickBooks but not yet processed by the lender, or vice versa—in that case, the balances will match once the payment clears.

Should I record the loan payment when I write the check or when it clears the bank?

Record it when you write the check. QuickBooks uses the check date, not the clearing date, to match your records to your bank statement during reconciliation. When you reconcile your bank account, you will mark the check as cleared once the bank confirms it went through.