# Import Loan Payments into QuickBooks Desktop

- Author: SimpleBankConvert (https://simplebankconvert.com)
- Published: 2026-10-17
- Category: QuickBooks Desktop imports
- Canonical: https://simplebankconvert.com/blog/import-loan-payments-into-quickbooks-desktop

> How to import loan payments into QuickBooks Desktop from Web Connect files and split each one between principal and interest using the loan statement.
To import loan payments into QuickBooks Desktop, bring in the bank's Web Connect file as usual, then record each loan payment as a split: the principal part to the loan's liability account and the interest part to an interest expense account. Take the split from the lender's statement, never from a guess, and check the loan balance monthly.

## How a loan payment arrives in a Desktop Web Connect file

A loan payment shows up in your bank's Web Connect file as one withdrawal for the full amount, such as 1,250.00 to the lender. The file says nothing about principal or interest, because the bank only knows that money left the account. Desktop therefore brings it in as a single line waiting in the Bank Feeds Center.

That single line is where most loan bookkeeping goes wrong. If you accept it into one account, the whole payment lands in one place. Before the file goes in, set up two accounts if you do not have them: a long term liability account (or other current liability, for a short loan) named after the loan, and an expense account for interest.

[Intuit's guide to downloading bank feed transactions in QuickBooks Desktop](https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-feeds/download-bank-feed-transactions-quickbooks-desktop/L8o0Aw9VM_US_en_US) says to add and match downloaded transactions against the ones already entered in the company file. For loans, the cleanest path uses that matching: enter the split payment yourself, then let the downloaded line match it.

## Splitting each loan payment between principal and interest

The principal part of a payment reduces what you owe, so it goes to the loan liability account. The interest part is a cost of borrowing, so it goes to interest expense. Enter the payment as a check from the bank account with two lines on the Expenses tab, one per account, adding up to the full payment.

### A worked example

The example below shows three months of a loan with made-up figures. The payment is 1,250.00 each month, and the balance before the first payment is 48,000.00.

| Month | Payment | Interest | Principal | Loan balance after |
| --- | --- | --- | --- | --- |
| January | 1,250.00 | 240.00 | 1,010.00 | 46,990.00 |
| February | 1,250.00 | 234.95 | 1,015.05 | 45,974.95 |
| March | 1,250.00 | 229.87 | 1,020.13 | 44,954.82 |

In Desktop, January's check to the lender has two lines: 1,010.00 to the loan account and 240.00 to Interest Expense. The interest falls a little each month as the balance shrinks, so every month's split is different. That is why a single memorized split does not stay right for long.

### Entering several months at once

If you are catching up on a year of payments, building the splits in a spreadsheet first saves time. Each row needs the date, the two amounts and the two accounts. Those rows can then go in as checks, or, for a batch of history that never touches the bank feed, as entries in an IIF file. [Importing journal entries into QuickBooks Desktop](/blog/import-journal-entries-into-quickbooks-desktop) explains the IIF layout and why a journal entry is a weak home for a real bank payment.

## Where do the principal and interest figures come from?

The lender's statement or amortization schedule gives the split. Most loan statements show, for each payment, how much went to interest, how much to principal and the balance left. Use those numbers exactly, because the lender's balance is the one you will reconcile to, and rounding your own calculation will drift from it.

Ask the lender for an amortization schedule if the monthly statement does not show the split. For a variable rate loan, the schedule changes when the rate changes, so use each statement rather than one schedule for the whole year. Escrow is a third part on some loans: a mortgage payment may include property tax and insurance held by the lender. Give escrow its own line to an escrow asset account or the matching expense, as your accountant prefers.

Payroll-style deductions or foreign lenders add their own wrinkles. A loan repaid through payroll is better handled with [importing payroll transactions into QuickBooks Desktop](/blog/import-payroll-transactions-into-quickbooks-desktop), and a loan in another currency needs the steps in [importing foreign currency transactions into QuickBooks Desktop](/blog/import-foreign-currency-transactions-into-quickbooks-desktop).

## Does the loan liability balance match the lender's statement?

It should, on every statement date. Open the loan account's register and compare its balance on the statement date with the principal balance the lender reports. If they agree, every split so far was right. If they differ, the gap tells you how far off the principal entries are.

A difference that equals one month's principal usually means a payment is missing or was entered twice. A small difference that grows each month means the splits came from your own calculation rather than the lender's figures. A large one-time difference may be an extra principal payment the lender applied that you booked as interest. Fix the month where the two balances first part ways, then check that every later month agrees.

## Loan payments booked entirely to an expense account

The usual mistake is accepting the whole payment to one expense account. Expenses are then overstated, profit looks smaller, and the loan balance never goes down. With the example loan, a year of payments booked this way would put more than 12,000.00 of principal into expenses while the liability stayed at 48,000.00.

The opposite mistake, booking the whole payment against the loan, understates interest expense and pays the loan down too fast on paper. Both are fixed the same way: edit each payment to split it using the lender's figures. Other accounting programs have the same issue; the MYOB side is in [importing a bank statement into MYOB](/blog/import-bank-statement-into-myob).

If the bank side of the loan payments only exists on PDF statements, [SimpleBankConvert](/) is being built to turn them into a Web Connect file, so the payment lines arrive ready to match against your split checks. It is still in early access.