How do you fix months of loan payments booked as an expense?

 To fix loan payments that were booked entirely as an expense, get the lender's statements for those months, add up the principal portion, and move it from the expense account back to the loan payable account with a correcting journal entry for each period. Then check the loan balance against the lender's latest statement. ZeraBooks' bookkeeping team does this as part of catch-up work.

It's one of the most common repairs in small business books, and one of the more satisfying ones, because the result is easy to prove. When you're done, your loan balance matches the lender's to the cent.

What went wrong

Each loan payment has two parts. Interest is an expense. Principal reduces what you owe. If someone recorded the whole withdrawal as "Loan payment" in an expense account, then every month the expenses were overstated by the principal, and the loan on the balance sheet never moved.

A fictional six months

A small bakery took a 60,000.00 equipment loan and pays 950.00 a month. From April to September 2026, all six payments went to an expense account called Loan Payments. That's 5,700.00 of expense.

The lender's statements for those six months show:

| | Amount | |---|---| | Total paid, April to September | 5,700.00 | | Applied to interest | 1,026.40 | | Applied to principal | 4,673.60 | | Principal balance after the September payment | 55,326.40 |

1,026.40 plus 4,673.60 is 5,700.00, so the split accounts for every payment. And 60,000.00 less 4,673.60 is 55,326.40, the balance the lender prints. Good. The numbers are consistent before you touch anything.

The correction

You want the books to end up with 1,026.40 of interest expense for the period and a loan balance of 55,326.40.

If your books are still open for those months, the cleanest fix is one correcting entry per month, dated in that month, using that month's split from the lender's statement. Each one debits Loan payable for that month's principal and credits the expense account for the same amount. Then reclassify the remaining interest from Loan Payments to Interest expense so it sits in the right line.

If the months are in a period you've already closed or filed, talk to your accountant first. Often the better move is a single correcting entry in the current period instead of reopening a filed year. In that case the entry debits Loan payable 4,673.60 and credits the expense account 4,673.60, with a clear memo saying what it corrects.

Either way, the bank side doesn't change. The withdrawals were real and they still match the bank statement. Only where they landed changes.

Check it

After the correction:

  • Loan payable in your books should show 55,326.40 at September 30.
  • Interest expense for April to September should show 1,026.40.
  • The Loan Payments expense account should be empty.

If the loan balance is still off, a payment is missing or one month's split was keyed wrong. Compare month by month against the lender's statements until you find it.

Stopping it from happening again

From October onward, record each payment as one entry with separate lines: debit Loan payable for principal, debit Interest expense for interest, debit fees for any fee, credit the bank for the total. Use the lender's printed split. If there's no statement for a month, estimate interest as the balance owed times the annual rate divided by 12, and correct it when the statement arrives.

Then reconcile the loan every month like a bank account: your loan balance against the lender's.

If you'd rather hand it over

ZeraBooks is a bookkeeping service. If loan payments or anything else in your books needs this kind of repair, our team fixes it month by month as catch-up, quoted once before work starts, and then keeps the books from there. You upload bank and loan statements to a portal; there's no bank or lender connection. Every month is proven against the statements to the cent, and you see the books in a read-only dashboard.

Monthly bookkeeping is from $150 (USD), with your price agreed on a free call.

The full method, including the entries when a loan is first funded, is in our guide to how to record loan payments.

This article is from ZeraBooks, which sells the service mentioned.

Comments

Post a Comment

Popular posts from this blog

How to clean up messy books without redoing the same month twice

Image
Clean up books in this order: collect every statement , set opening balances from the last period your accountant signed off, then reconcile each account one month at a time, oldest first . Only once a month ties do you pair transfers, remove duplicates, place uncategorized lines and move owner spending out. A different order means categorizing lines you later delete. A month that doesn't tie, with the gap shown. During a cleanup you stay on that month until the gap is zero. The worked figures below belong to a fictional design studio whose books stopped being kept in February. They are illustrative only. What has to happen before any categorizing? Step 1: Build a statement grid Accounts down the side, months across the top. Tick a cell when you hold that month's statement as a PDF from the bank. Our studio has checking, savings and one card across eight months, so the grid has 24 cells. Any blank cell is a month you can't prove yet, so request it today. Activity...
Read more

How to convert a credit card statement PDF to Excel, step by step

 You need last quarter's card charges in a spreadsheet by Friday, and all you have is three PDFs from the issuer's website. To convert a credit card statement to Excel, download the PDF statement (not the activity export), run it through a converter or copy the tables out by hand, then fix three things: the signs on payments, the foreign currency detail lines, and the summary blocks. Finish by checking that your rows rebuild the printed new balance. Here's each step. Step 1: Download the statement PDF Go to the card's statements page on the issuer's site and download the monthly statement. Many issuers also offer a "download activity" CSV. Skip it for this job. It usually has no previous or new balance printed anywhere, and those two numbers are how you'll prove the spreadsheet is complete at the end. Watch the dates. A card statement ends on a closing date, not the end of the month. If you need the full quarter, you may need the statement after it too...
Read more

How to scan a bank statement so it converts to Excel cleanly

Image
To scan a bank statement so it converts to Excel cleanly, use 300 dpi and grayscale , keep pages straight, save each account's pages into a single PDF , and include the last page even if it looks empty. Then convert it and check that the opening balance plus the rows equals the printed closing balance. Most conversion problems with scanned statements are decided before the conversion starts, at the scanner. Here is how to get it right, step by step. Where a scanned PDF goes in ZeraBooks Convert: the Upload button, or drop the file on the page. Do you need to scan the statement at all? Step 1: Check online banking first Log in and look at the statements section. If the month is there, download the PDF. A downloaded statement carries the bank's own text and will always beat a scan. What scanner settings work best for bank statements? Step 2: Set the scanner Setting Use Why Resolution 300 dpi Lower loses faint digits; higher only makes bigger files Colo...
Read more