How to Record a Bank Loan and Line of Credit in QuickBooks
Jul 19, 2026
Convert your bank statement to Excel now
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
Short answer: Loan proceeds are a liability, not income. To record a bank loan in QuickBooks, create a liability account for the loan, then book the deposit as a credit to that liability and a debit to your bank account. When you make a payment, split it: the principal portion reduces the loan liability, and only the interest portion is an expense. A line of credit works the same way, except you draw and repay against it repeatedly, so the liability balance moves up and down all year. Recording the borrowed money as income is the mistake that overstates revenue and inflates the tax you owe.
Loans trip people up because the cash hits the bank account like a sale does, so the bank feed wants to call it income. It is not. You have to pay it back, which is the definition of a liability. Get the setup right once and every payment after that is a two-line entry.
Is a loan considered income in QuickBooks?
No. A loan is not income, because borrowed money is not earned and has to be repaid. When a $50,000 loan lands in your checking account, your cash goes up by $50,000 and your debt goes up by $50,000, so your net worth has not changed and there is nothing to tax. Recording it as income overstates revenue, throws off your profit and loss, and can inflate your tax bill on money you never earned. The correct treatment is to increase a liability account by the loan amount, which is why the first step is creating that account.
How do I set up a loan account in QuickBooks Online?
Go to Settings, then Chart of Accounts, and select New. Choose the account type based on how long the loan runs. If you will pay it off within the current fiscal year, use Other Current Liabilities with the detail type Loan Payable. If it runs longer than a year, use Long Term Liabilities with the detail type Notes Payable. Name it something you will recognize, such as "Term Loan, Chase" or "Line of Credit, BofA." Leave the opening balance blank and add it through the deposit entry instead, so you do not accidentally create an opening balance equity figure you later have to clear.
How do I record the loan deposit?
Once the liability account exists, record the money arriving. The cleanest way is a bank deposit or a journal entry that credits the loan liability and debits your bank account for the same amount. In a bank deposit, set the Account to the loan liability and the amount to what you received. In a journal entry, put the loan liability on the credit line and your checking account on the debit line. Either way the liability now shows the full balance you owe, and your bank balance reflects the cash you can spend.
| Event | Debit | Credit |
|---|---|---|
| Loan funds arrive | Bank account (asset up) | Loan payable (liability up) |
| Monthly payment | Loan payable (principal) + Interest expense | Bank account (asset down) |
| Line of credit draw | Bank account (asset up) | Line of credit (liability up) |
| Line of credit repayment | Line of credit (principal) + Interest expense | Bank account (asset down) |
How do I split a loan payment between principal and interest?
Every loan payment has two parts, and they are treated differently, so you have to split them. The principal portion pays down what you borrowed and reduces the loan liability. The interest portion is the cost of borrowing and is the only part that is an expense. When you categorize the payment, use two lines: on the first line select the loan liability account and enter the principal amount, and on the second line select an Interest Paid expense account and enter the interest amount. The two lines together equal the total payment that left your bank account. Your amortization schedule from the lender tells you how much of each payment is principal and how much is interest, and that mix shifts toward principal over the life of the loan.
If you skip the split and post the whole payment to the loan liability, you never record interest expense, so you overstate profit and miss a real deduction. If you post the whole thing to interest expense, you never pay down the loan on your books and the liability sits there forever. The split is what keeps both the balance sheet and the profit and loss correct.
How is a line of credit different from a term loan?
A term loan gives you a lump sum once and you pay it down on a fixed schedule. A line of credit is a revolving limit you can draw against, repay, and draw against again, like a credit card. In QuickBooks you set up a line of credit as its own liability account, usually Other Current Liabilities with the Loan Payable detail type. Each draw credits the line of credit liability and debits your bank; each repayment splits into principal against the liability and interest as expense. Because you use it repeatedly, the balance moves throughout the year, and matching draws and repayments to the lender statement is the only way to keep the running balance right, which is easier when the statement is in a spreadsheet you can sort.
How do I record a loan used to buy an asset?
When the loan pays for equipment or a vehicle rather than landing in your bank, you record both sides of the purchase. Debit a fixed asset account for the item and credit the loan liability for the financed amount, plus your bank for any down payment. That puts the asset on your books at its cost and the debt as a liability, and from there the payments split into principal and interest exactly as they do for a cash loan. Depreciation of the asset is a separate entry your accountant usually handles.
Getting the loan statement into QuickBooks
Whether it is a term loan or a revolving line, the lender sends a monthly statement as a PDF showing draws, payments, the interest charged, and the running balance. To reconcile the loan account and confirm your principal and interest split matches the lender, it helps to have that statement as rows rather than a PDF. You can convert the loan or bank statement to a spreadsheet in seconds, then match each payment to your entry, or convert it straight to a QuickBooks-ready file to import. For the checking account the payments come out of, our guide on importing bank transactions into QuickBooks Online walks through the upload, and once the loan is on your books, the balance flows onto the balance sheet where the liability belongs.
Why does my loan balance not match the lender?
The two usual reasons are that a payment was posted entirely to principal or entirely to interest instead of being split, or that the interest accrued between your payment date and the statement date was never recorded. Pull the lender statement, list each payment with its principal and interest breakdown, and compare it to your entries line by line. Any payment where your split does not match the amortization schedule is the culprit. Fix the split on that entry and the ending balance falls back into line. Keeping the loan reconciled monthly stops small differences from compounding into a balance nobody can explain a year later.
The mental model that keeps loans correct is simple: borrowing money creates a liability, not income; repaying it reduces that liability; and only the interest is ever an expense. Set the account up once, split every payment, and the loan takes care of itself.
Ready to convert your bank statement?
Upload a PDF and get clean Excel or CSV in seconds. Works with statements from any bank.
Convert to Excel nowFree to try, no credit card required