To split loan payments into principal and interest, take each payment line from the bank statement and divide it using the lender's figures: the interest part goes to interest expense, and the principal part reduces the loan liability. The lender's statement or amortization schedule gives the split. Without it, the loan balance in the books drifts away from reality.
Why can't a loan payment go to one account?
A loan payment is two things at once. The interest is a cost of borrowing and belongs on the profit and loss. The principal is repayment of money the client already received, so it only shrinks a balance sheet liability. Coding the whole payment to either account makes one of the two reports wrong.
Consider the two shortcuts bookkeepers take under time pressure.
The whole payment to interest expense. Expenses look higher than they are, profit looks lower, and the loan balance never goes down in the books. A year of this on a $1,850 monthly payment can overstate expenses by more than $15,000, and the CPA then has to unwind it at tax time.
The whole payment to the loan account. The liability falls faster than it really does, and interest expense shows zero. The client loses a cost that is usually part of their business expenses, and the loan account eventually goes negative, which is a reliable sign something is off.
The bank statement cannot settle this for you. It prints one line, such as "ACH DEBIT FIRSTLINE LOAN PMT 1,850.00," and gives no hint of how the lender applied it. The split lives on the lender's side.
Finding the principal and interest figures for each loan payment
The principal and interest figures come from the lender, not the bank statement. Most lenders send a monthly or annual loan statement that shows, for each payment, how much went to interest, how much went to principal and the balance left after it. An amortization schedule from the loan closing gives the same breakdown in advance.
Use the sources in this order:
- The lender's monthly loan statement. It reflects what actually happened, including late payments and extra principal.
- The lender's year-end summary. Many lenders print total interest paid for the year. It is enough to true up the books once a year even if monthly detail is missing.
- The amortization schedule from closing. It is accurate only if every payment was made on time and in the scheduled amount.
- Your own calculation from the rate and balance. A fallback for estimating, never the final figure.
A schedule and the lender's actual figures often differ by small amounts. Lenders that charge interest daily produce a slightly different interest figure for a 31-day month than for a 28-day month, while a printed schedule may assume equal months. When the two disagree, the lender's statement wins.
Keep one loan record per loan in the client's file: lender, account number ending, original amount, rate, payment amount and payment date. That record lets you match each bank line to the right loan when a client has two loans with the same lender.
A worked loan payment split for one month
A worked split shows the mechanics in three entries. The example below uses made-up figures for a fictional client: a $120,000 equipment loan at 6% a year, paid $1,850 on the first of each month, with interest worked at a flat monthly rate of 0.5% to keep the arithmetic readable.
| Payment | Opening balance | Interest (0.5%) | Principal | Closing balance |
|---|---|---|---|---|
| March 1 | 120,000.00 | 600.00 | 1,250.00 | 118,750.00 |
| April 1 | 118,750.00 | 593.75 | 1,256.25 | 117,493.75 |
| May 1 | 117,493.75 | 587.47 | 1,262.53 | 116,231.22 |
Each row becomes one split transaction against the single bank line. For March:
- Debit interest expense 600.00.
- Debit equipment loan payable 1,250.00.
- Credit checking 1,850.00.
Notice how the interest share falls a little each month while the principal share grows. That pattern is the main reason a fixed rule, such as "always code $600 to interest," fails: by the end of the year the fixed amount is wrong by a growing margin.
Coding the line from converted statements
When statements are converted into rows for import, the loan payment arrives as one line with one amount. In most accounting systems you open that line and split it into two account lines totalling the payment. In AutoBankConvert, a client rule can send the "FIRSTLINE LOAN PMT" line to the loan payable account every month, and you then split out the interest from the lender's figures in the accounting system. The rule saves the lookup; the split still needs the lender's numbers.
The same habit of splitting one bank line into its parts appears with card sales, where the processor deposits sales minus its fees. The guide to recording merchant deposits net of fees walks through that gross-up, and the thinking is the same: the bank shows a net figure, and the books need the pieces.
Loan payments that bundle escrow, insurance or late fees
Some loan payments cover more than principal and interest. Real estate loans often add an escrow amount that the lender holds to pay property tax and insurance, and some equipment loans bundle an insurance premium. A late payment may carry a late fee. Each part needs its own account, so the split has three or four lines instead of two.
A typical bundled split looks like this:
- Interest to interest expense.
- Principal to the loan payable account.
- Escrow to an escrow asset account, because the money still belongs to the client until the lender pays the tax or insurance bill.
- Late fee to interest and finance charges, or to a separate penalty account if the CPA prefers.
When the lender later pays the property tax from escrow, the lender's annual escrow statement shows it. Record that as a move from the escrow asset to property tax expense or insurance expense, with no bank line involved.
Escrow accounts sometimes run a surplus, and the lender sends money back. That deposit is not income. It returns cash from the escrow asset to checking. If the lender instead returns an overpayment of interest, that credit reduces interest expense. The post on how to record refunds in bookkeeping covers the general rule: a refund reverses the account the original payment went to.
How do you fix a loan balance that no longer matches the lender?
A loan balance that no longer matches the lender means some past payments were split wrongly or not split at all. Fix it by comparing the books with the lender's statement at a fixed date, working out where the difference came from, and posting a correction to interest expense and the loan account for the open period.
Step list for correcting a drifted loan balance
- Pick a date the lender reports a balance, usually the last statement date or December 31.
- Pull the loan payable balance in the books at that same date.
- Subtract. A book balance higher than the lender's balance usually means principal was coded to interest. A book balance lower than the lender's usually means interest was coded to the loan account.
- List the payments in the period and compare each one's split with the lender's figures. Most drifts trace to a few months, often the first months after a new loan was set up or a month with an extra payment.
- For months still open, edit each split to match the lender.
- For months already closed or filed, do not change them silently. Post one adjusting entry in the current period, and tell the CPA, who decides how a prior-year error is handled.
- Note the lender's year-end interest total on the workpaper so the next review can confirm the year at a glance.
A short example of the arithmetic
Continue the example from earlier. The books show the equipment loan at 118,750.00 on June 30, while the lender's statement shows 114,962.38 after the June payment. The books are 3,787.62 too high. The lender's figures for April, May and June show principal of 1,256.25, 1,262.53 and 1,268.84, which add up to exactly 3,787.62. So the three payments since March were coded entirely to interest expense. The correction moves 3,787.62 from interest expense to the loan account, split across those three months.
A gap that matches no set of months usually means two mistakes at once, such as a wrong opening balance plus a few bad splits. Work them apart one at a time: check the opening balance against the loan closing papers first, then the splits. Never post the whole difference to interest expense to make the number agree. That hides two errors under one entry.
Extra principal payments also cause drift. A client who sends an additional $5,000 one month reduces the balance faster than the schedule predicts, so every later month's interest is lower than the schedule shows. Only the lender's statement captures that.
When the client never sends the loan statements
When a client never sends the loan statements, the books can still be kept close, but the split becomes an estimate until the lender's figures arrive. Record the payment against the loan account, estimate interest from the rate and balance, and mark the estimate clearly so it gets replaced at the first chance.
Some practical steps help:
- Ask for online access to the lender portal, read-only if possible. Many lenders let a borrower download every monthly statement there.
- Ask for the year-end interest summary at minimum. One figure per loan per year is enough to correct twelve estimated months in a single entry.
- Estimate with the formula the loan uses. For simple interest charged monthly, interest is the opening balance times the annual rate divided by twelve. Label the account line "estimated" in the memo.
- Set a deadline for the true-up. Year-end close is the latest sensible point, because the CPA will want actual interest for the tax return.
A client who keeps missing these requests is a familiar problem for practices. The post on handling unresponsive bookkeeping clients offers ways to set expectations and escalate before an estimate becomes the final figure.
Estimating is a stopgap, not a policy. A loan account built entirely from estimates will be wrong in a way that only shows up when the client sells the asset, refinances or pays the loan off, and the final payoff does not match the balance in the books.