To reconcile a loan in QuickBooks, compare the loan liability account's balance with the principal balance on the lender's statement for the same date. They agree only if every payment was split into principal and interest the way the lender applied it. A difference usually means a payment booked entirely to expense, a missed payment or interest coded as principal.
Setting up the loan liability account in QuickBooks Online
A loan in QuickBooks Online lives in its own liability account, so its balance is the principal the business still owes. Intuit's guide to setting up a loan in QuickBooks Online creates it from the chart of accounts as a non-current liability, or a current one when it will be repaid within the financial year.
The guide's steps: go to All apps, then Accounting, then Chart of accounts, and select New account. Choose the liability type, set the detail type to Notes Payable or Loan Payable, and give the account a descriptive name. A name with the lender and the last digits of the loan number, such as "Note payable, First County Bank 0093", saves confusion when a second loan arrives.
How the starting balance goes in depends on the loan's history:
- A new loan paid into your bank account. Intuit's guide says to leave the opening balance at zero, then categorise the bank deposit to the loan account. The deposit becomes the loan's starting balance.
- An older loan already partly repaid. Enter the current payoff balance as the opening balance, dated the day tracking starts. Intuit notes that any beginning balance posts to Opening Balance Equity.
- Loan proceeds that never touched your bank, such as a lender paying a vendor directly. Intuit's guide suggests talking to your accountant, because the entry depends on what the money bought.
Take the starting figure from a lender statement, not from memory or an amortization schedule printed at closing. Schedules assume every payment arrives on time; statements show what actually happened.
Which lender document should a QuickBooks loan be reconciled against?
Reconcile a QuickBooks loan against the lender's periodic statement or year-end interest statement, because it shows the principal balance the lender recorded after applying each payment. An amortization schedule is a forecast. Use it to plan the split, then confirm the split and the balance against what the lender reports.
The lender's statement normally shows, for each payment:
- the date received,
- the total paid,
- the portion applied to interest,
- the portion applied to principal,
- any escrow, fee or late charge,
- and the principal balance afterwards.
Those six figures are all you need.
Two kinds of borrowing need slightly different evidence. A line of credit has draws as well as repayments, so the statement should also list each advance with its date; every draw needs a matching deposit in QuickBooks coded to the liability account, not to income. A loan with escrow for property tax or insurance shows escrow as a separate balance held by the lender. That escrow balance is not principal, so keep it out of the loan liability account, record the escrow portion of each payment to its own account, and compare it to the escrow figure on the lender's annual escrow statement. If the lender only issues an annual statement, ask for a payment history from the online portal each quarter. Waiting a full year to reconcile a loan means twelve payments to unpick if the first one was split wrongly.
When a loan is part of a larger finance stack with bank covenants or lender reporting, the reviewer will expect the same evidence each period; bank reconciliation sign-off and the evidence that counts covers what a preparer and reviewer should each initial.
Splitting each QuickBooks loan payment into principal and interest
Each QuickBooks loan payment is recorded as one transaction with at least two lines: the principal portion to the loan liability account, and the interest portion to an interest expense account. Escrow, fees or insurance go on further lines to their own accounts. The total equals the amount that left the bank.
Intuit's loan guide records the repayment as a cheque from the New or Create menu, with "Debit" or "EFT" in the number field for electronic payments. Labels vary by region, so in the US edition look for the check or expense form. In the category details:
- Line 1: the loan liability account, with the principal portion.
- Line 2: the interest expense account, with the interest portion.
- Further lines: fees or escrow, each with the right account.
Take the split from the lender's statement once it arrives. If you record the payment before the statement, use the amortization schedule and adjust later if the lender applied it differently. Small differences are common when a payment arrives a few days early or late, because interest accrues daily on many loans.
If the payment comes through the bank feed, categorise it with a split rather than to a single account. A feed rule that codes "LOAN PMT" to one account is exactly how principal ends up in expense.
Can the QuickBooks reconcile screen handle a loan account?
The QuickBooks reconcile screen can be used for a loan account if the account appears in the Account dropdown on the Reconcile page. Enter the principal balance from the lender's statement as the ending balance and tick each payment and the starting entry. Intuit's loan guide itself does not describe reconciling the loan, so confirm on your own screen.
Using the screen has advantages. Each payment gets a reconciled mark, and QBO saves a report for every period, which you can retrieve later from the history; where to find bank reconciliations in QuickBooks Online shows where those reports live.
There is one difference in how the figures read. On a bank account, the ending balance is money you hold. On a loan, it is money you owe, and the payments you tick reduce it. Expect the screen's labels, such as payments and deposits or charges, to fit loans awkwardly.
If the loan account is not offered, or the screen is confusing, a spreadsheet tie-out gives the same proof. The first reconciliation is the one to get right in either case, because every later period builds on it; reconciling in QuickBooks Online for the first time explains how to check the opening entry before you start.
A QuickBooks loan reconciliation worked for one quarter
A quarterly tie-out compares, payment by payment, what QuickBooks recorded with what the lender applied. All figures are example values for a term loan with a monthly payment of $1,850.00, made up for illustration.
| Date | Lender: principal | Lender: interest | QBO: principal | QBO: interest | Difference |
|---|---|---|---|---|---|
| Opening, July 1 | Balance $96,400.00 | Balance $96,400.00 | $0.00 | ||
| July 15 | $1,368.00 | $482.00 | $1,368.00 | $482.00 | $0.00 |
| August 15 | $1,374.84 | $475.16 | $0.00 | $1,850.00 | $1,374.84 |
| September 15 | $1,381.71 | $468.29 | $1,390.00 | $460.00 | −$8.29 |
| Closing, September 30 | Balance $92,275.45 | Balance $93,642.00 | $1,366.55 |
The closing difference of $1,366.55 is made of two errors. August's whole payment was coded to interest expense, so the loan shows $1,374.84 too much principal owed and interest expense is overstated by the same amount. September used the amortization schedule's split instead of the lender's, which moved $8.29 the other way.
The fixes: edit the August payment to split it as the lender did, and edit September to match the lender's figures. Both payments are in the current year, so editing the original transactions keeps the bank side untouched. After the changes, the loan account should show $92,275.45 at September 30, matching the lender.
Keep the lender statement and the tie-out together. When several entities carry loans, larger systems formalise this; NetSuite bank reconciliation shows how matching and review work at that scale.
Loan payments booked as expenses in QuickBooks, and the fix
Loan payments booked as expenses are the most common loan error in QuickBooks. The whole payment lands in interest expense, or in a general expense account, so the liability never falls and profit is understated. The fix is to split each affected payment into principal and interest, using the lender's figures.
The error is easy to spot once you look. The loan balance in QuickBooks stays flat month after month, or falls only when someone posts an annual adjustment. Interest expense on the profit and loss is close to the total of all payments.
How to repair it:
- List every payment since the last time the loan agreed to a lender statement.
- Get the lender's principal and interest split for each.
- Open each payment in QuickBooks and change the category lines to the split. The bank side stays the same, so the bank reconciliation is not disturbed.
- If a payment is in a closed period or a filed tax year, ask your accountant whether to edit it or post a correcting journal entry in the current period instead.
- Rerun the tie-out and confirm the loan balance matches the latest lender statement.
Prevention is cheaper. Set the bank feed to split loan payments, or enter them by hand each month from the lender's figures.
Bank statements are where the payments are proven to have left. PreciseBankFlow reads those statements, checks that each one foots and matches the lines to your register, so you can request a spot and give your time to the loan schedule instead.