# Loan Statement PDF to QuickBooks: Record Payments

- Author: SimpleBankConvert (https://www.simplebankconvert.com)
- Published: 2025-12-15
- Updated: 2025-12-15
- Category: PDF bank statements
- Canonical: https://www.simplebankconvert.com/blog/loan-statement-pdf-to-quickbooks

> How to use a loan statement PDF in QuickBooks: take the principal, interest and balance from each statement rather than converting it as bank lines.
To use a loan statement PDF in QuickBooks, read three figures from each statement: the interest charged, the principal repaid and the balance left. Record the monthly payment from your bank account as one split transaction, with principal against the loan's liability account and interest against an expense account, then check the loan balance against the statement.

## Can a loan statement PDF go in as a bank upload?

No. A loan statement PDF reports what happened to a debt, not money moving through a bank account. The payment itself already appears on your bank statement, so it comes into QuickBooks with the bank lines. Converting the loan statement as bank activity would bring the same payment in a second time.

What the loan statement adds is the breakdown. Your bank statement shows one figure, say 1,150.00, paid to the lender. It can't tell you how much of that was interest, which is an expense, and how much reduced what you owe, which is not. Only the lender's statement has that split, and the split changes every month as the balance falls.

So the loan statement is a reference you read, not a file you import. Keep it beside you when you categorise the payment line from the bank.

## Reading principal, interest and balance on a loan statement

Most loan statements show, for the payment just received, the amount paid, the part applied to interest, the part applied to principal and the balance after the payment. Those four numbers are all you need. Escrow, late fees or insurance, if the statement shows them, are extra parts of the same payment.

Read the "payment received" or "last payment" section, not the "amount due" box for next month. The amount due is a future bill. The received section is what actually happened, and it should match the date and amount of the payment on your bank statement.

If you paid by paper check, the payment line on your bank statement may only say "check 2210". The check image pages that some banks add show the payee, which confirms which lender it went to; [what to do with check images in PDF bank statements](/blog/check-images-in-pdf-bank-statements) explains why those pages add no rows of their own.

## Recording each loan payment as a split in QuickBooks

Record each loan payment as one transaction from the bank account, split across two or more lines. [Intuit's guide to setting up a loan in QuickBooks Online](https://quickbooks.intuit.com/learn-support/en-us/help-article/loans/set-loan-quickbooks-online/L7pMR6rUN_US_en_US) has you record each payment to the account created for the loan and each interest payment to an expense account.

Set the loan account up first. Intuit's article uses a Long Term Liabilities account with the Notes Payable detail type for a loan you won't repay within the fiscal year, and an Other Current Liabilities account with the Loan Payable detail type for one you will.

### A worked example

These figures are an example only. The bank statement shows a payment of 1,150.00 on May 15. The lender's statement for the same payment shows:

| Part of the payment (example) | Amount | Where it goes in QuickBooks |
| --- | ---: | --- |
| Interest | 287.50 | Interest expense account |
| Principal | 862.50 | Loan liability account |
| Total paid | 1,150.00 | Out of the checking account |

The loan balance before the payment was 69,000.00. After it, the balance is 69,000.00 minus 862.50, which is 68,137.50. That figure should match the remaining balance printed on the loan statement.

When the bank line for May 15 comes in through an import or the feed, categorise it with both splits instead of adding a new transaction. That way the payment appears once, and it reduces the loan by the right amount.

## Does the loan statement balance match QuickBooks?

After you record each payment, the balance of the loan account in QuickBooks should equal the balance remaining on that month's loan statement. If it does, both the principal and the interest went to the right places. If it doesn't, the size of the difference usually points to the cause.

- **Off by the whole payment:** the payment was recorded twice, once from the bank line and once by hand.
- **Off by the interest:** the full payment went to the loan account with no split.
- **Off by a small amount that grows:** the interest and principal figures were estimated rather than taken from each statement.
- **Off from the start:** the opening balance was entered from the wrong date.

Do the check monthly. Intuit's article doesn't describe QuickBooks working out the split for you, so the lender's statement remains the source of each month's figures.

## When converting a loan statement to a bank file does make sense

Converting a loan statement to a bank file makes sense only when the loan behaves like an account with many movements, such as a line of credit you draw on and repay several times a month. For a fixed monthly loan, recording one split payment a month is quicker and more accurate than any conversion.

A line of credit statement lists draws, payments, interest and fees with dates and amounts, much like a card statement. In that case you can treat the line of credit as its own account in QuickBooks and import its activity, then check it against the statement's closing balance. The [manual spreadsheet route from PDF to QBO](/blog/convert-pdf-to-qbo-manually) works for those statements the same as for a bank account.

If you keep personal loans in Quicken, the file it wants is QFX rather than QBO; [picking QFX or QBO when converting a PDF](/blog/convert-pdf-to-qfx) explains the difference. And if you are moving those records into a business company file, [switching from Quicken to QuickBooks Online](/blog/switch-from-quicken-to-quickbooks-online) covers how to set loan balances at the switch date.

SimpleBankConvert is aimed at the bank side of this job: turning the PDF bank statement that holds the loan payment line into a CSV or QBO file you can import. It is not open yet; [leave your email on the get started page](/get-started) to hear when it is.