What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/How to Enter a Loan in QuickBooks Through Payoff
QuickBooks Online

How Do I Enter a Loan in QuickBooks? Three Entries, Then Every Payment

A loan isn't income. The money you borrowed goes into a liability account, so it shows up as something you owe. Then each payment is split: principal reduces the loan, interest is an expense. Here's each entry and one payment worked through.

Entering a loan in QuickBooks Online

1. Make the loan account. Long Term Liabilities with detail type Notes Payable if it runs past this fiscal year, Other Current Liabilities with Loan Payable if it doesn't.

Settings ⚙ Chart of accounts New

2. Record the money coming in as a bank deposit, with the loan account on the line.

+ New Bank deposit

3. Record each payment as a check or expense with two lines: principal to the loan account, interest to Interest Expense.

+ New Check

One payment, split

The bank takes the same amount every month, but the split changes each time. Early payments are mostly interest; later ones are mostly principal.

Example: $25,000 at 7% over 36 months, first payment
Principal (Line to the loan liability account) $626.10
Interest (Line to Interest Expense) $145.83
Payment leaving the bank $771.93

Payment 2 on the same example is $629.75 principal and $142.18 interest. By payment 24 it's $715.71 and $56.22. Take the figures from your lender's amortization schedule, not from last month's entry.

Each entry in detail

  1. 1

    Create the liability account

    Settings ⚙ Chart of accounts New

    Choose the account type and detail type from the quick answer above and name it after the lender and loan, for example "Chase equipment loan". One account per loan keeps each balance easy to check.

    Watch for: the opening balance field. For a brand-new loan whose money you're about to record as a deposit, leave it at zero. Filling it in and recording the deposit counts the loan twice.

  2. 2

    Record the money in

    + New Bank deposit

    Choose the bank account the money landed in, add a line with the lender in Received from, the loan liability account as the account, and the amount. Your bank balance and your loan balance now both go up by the same figure.

    Watch for: fees the lender kept back. If $25,000 was borrowed and $24,500 arrived, add a second line of minus $500 to a loan fees account so the loan account still shows the full $25,000 owed.

  3. 3

    If the lender paid someone else directly

    + New Journal entry

    A vehicle or equipment loan often pays the seller, so nothing hits your bank. Use a journal entry: debit the asset account for the vehicle or machine, credit the loan liability account.

  4. 4

    Record each payment with the split

    + New Check

    Pick the bank account, the lender as payee, then two category lines: the loan account for the principal and Interest Expense for the interest, using that payment's row on the schedule. If the bank feed already downloaded the payment, open it in Banking and split it there instead, so it isn't recorded twice.

  5. 5

    Set it to repeat, then adjust it

    You can save the payment as a recurring transaction so it's entered every month. Because the split changes, set it to remind you rather than post on its own, and update the two amounts each time.

  6. 6

    Check the balance against the lender's statement

    Every quarter or so, compare the loan account's balance on your balance sheet with the principal still owed on the lender's statement. They should match to the cent.

How loan entries go wrong

The loan was booked as income

How you'll know: Profit jumped the month the money arrived.

Fix: Edit the deposit so its line points at the loan liability account, not an income account.

Whole payments went to the loan account

How you'll know: The loan balance falls faster than the lender's statement, and Interest Expense is zero.

Fix: Edit each past payment to split off the interest from the schedule. The difference between your balance and the lender's is usually the total interest you missed.

Whole payments went to Interest Expense

How you'll know: The loan never seems to shrink on the balance sheet.

Fix: Move the principal part of each payment to the loan account. Your expenses drop and the loan balance catches up.

Questions people ask

How do I record a loan payment in QuickBooks if I just want a quick estimate instead of the exact amortization split?

You can put the whole payment against the loan account for now, but your loan balance will run low and you'll show no interest at all, which matters at tax time. Ask the lender for the schedule; most send it on request or show it in online banking, and fixing a few months later is quick if you don't leave it a year.

How do I record a vehicle loan in QuickBooks?

It's two records. The vehicle is a fixed asset at what you paid for it, and the financing is a loan liability like any other. When the dealer was paid by the lender, one journal entry books both sides: debit the vehicle asset account, credit the loan account, plus a bank line for any down payment you made.

How do I record a PPP loan in QuickBooks, especially if it gets forgiven?

While it's outstanding, it's a liability like any other loan. When some or all of it is forgiven, a journal entry moves the forgiven amount out of the loan account and into an other income account. How that income is treated for tax isn't the same as ordinary income in every case, so confirm with your accountant.

How do I record a loan I made to someone else, not a loan I took out?

Flip it round. Make an asset account, such as an Other Current Asset called "Loan receivable", and record the money you sent from your bank to that account. Repayments coming in reduce that asset, and any interest they pay goes to an interest income account; see entering interest income.

Is loan interest a deductible business expense?

Interest on money borrowed for the business is generally treated as a business expense, while the principal isn't an expense at all. The rules have limits and exceptions, so confirm with your accountant.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.