Recording loan payments correctly: what matters at set-up time

Getting a loan payment right is mostly a matter of set-up, not data entry. If the loan account, the lender and the payment split are correct before the first payment posts, the whole life of the loan stays easy to reconcile. If they are not, every month-end close inherits the error. This article covers what to get right, and the judgement calls around extra payments.

What a loan payment actually is in the ledger

A loan payment is two transactions wearing one bank line: principal reduces the loan liability, interest is an expense. The bank account sees a single debit leaving. Your ledger has to split it.

That split is the whole game. Post the payment as one amount to the bank and nothing else, and the loan balance stops agreeing to the lender statement. Post it all to the loan account, and you understate interest expense and overstate the liability.

Why the opening balance comes first

You cannot schedule or set up a payment against a loan account that has no opening balance. That is not a software quirk; it is the accounting. A payment needs a liability to reduce, and the tool needs to know the starting principal to amortise the split.

So the sequence is: create the loan account, enter the opening balance from the lender's statement or the closing loan documentation, then set up payments. If the opening balance is wrong, every subsequent split is wrong too, quietly, month after month.

What to check before saving the first payment

Three things deserve a look before you commit:

• The account and lender. Confirm the loan account, the lender name and the bank account the payment draws from. A payment set up against the wrong bank account will not match at reconciliation.
• The payment date and number. Payments are tied to a specific payment number in the schedule. Get the first one right, or the amortisation runs off schedule from day one.
• The split. Check that the principal and interest amounts agree to the lender's schedule or statement for that payment number.

How extra payments behave

An extra payment, or any change to the standard amounts, applies to that payment number only. The next scheduled payment reverts to the standard terms. That is worth knowing twice over.

First, it means you can record a one-off lump sum without corrupting the schedule. Second, it means the tool will not automatically re-amortise the loan after the extra payment. The lender will recalculate the schedule; your recorded standard payment will not follow it. After any extra payment, expect the principal and interest split on later payments to drift from what your schedule says, and reconcile against the lender's statements rather than the original amortisation table.

How this shows up in the close

A loan set up correctly reconciles in minutes: the lender statement, the loan account balance and the amortisation schedule all agree. A loan set up badly shows up as a reconciliation difference that grows or shrinks slightly each month, which is the signature of a wrong split rather than a missing transaction.

At each month-end, check the loan account balance against the lender's statement, and confirm the interest posted agrees to the statement's interest portion. If they diverge steadily, revisit the set-up, not just the latest entry.

When to bring in a specialist

If the loan account has months of mis-split history, or the schedule was rebuilt after data damage or a migration, untangling it is repair work rather than bookkeeping. Preserve a backup and the lender statements first, then hand it to a QuickBooks data repair specialist rather than editing history in place.