How to Reconcile a Business Loan Statement at Year-End

Prepare one reconciliation for each loan account, using the same closing date throughout. Record the borrower, lender, account reference and currency so that payments for different facilities do not get mixed together.

• ✓The previous closing reconciliation and the opening loan-ledger balance.
• ✓A lender statement covering the full period, including its opening and closing balances.
• ✓Bank statements showing drawdowns, instalments and separate payments of interest or charges.
• ✓The loan agreement, repayment schedule and notices changing instalments or other terms.
• ✓The loan, interest and charges ledgers, together with relevant posting references.
• ✓Lender correspondence explaining adjustments, reversals, overdue amounts or disputed entries.

Use the repayment schedule to understand expected payments, then check actual transactions against the lender statement. A schedule alone does not explain a missed instalment, an extra repayment or a later adjustment.

First establish what each balance represents. Ask whether the lender's closing figure is principal outstanding, total account balance or a settlement amount. Compare principal with principal before reconciling any interest or charges included in a wider total.

Build the bridge as opening principal plus drawdowns less principal repayments, with any other supported principal adjustments shown on separate lines. Tie the opening figure to the previous signed reconciliation. Investigate an opening difference before carrying it into the current year.

In this illustrative example, interest paid is Rs 72,000 and separately paid charges are Rs 3,000. Total cash paid is therefore Rs 2,55,000, but only Rs 1,80,000 reduces principal. If the lender reports principal of Rs 8,20,000, the principal bridge agrees; interest and charges still need their own checks.

Create a transaction schedule with columns for the bank payment, principal, interest and charges. Use the lender's transaction breakdown or supporting advice to allocate the payment. Keep unexplained amounts visible instead of estimating a split to make the balance agree.

For illustration, an instalment of Rs 25,000 might comprise Rs 18,000 principal and Rs 7,000 interest. Match Rs 25,000 to the bank debit, Rs 18,000 to the principal movement and Rs 7,000 to the interest record. Repeat the exercise for every instalment; do not assume the same split throughout the year.

Also reconcile the interest record from opening unpaid interest through amounts charged, payments allocated to interest and supported adjustments to closing unpaid interest. Track charges separately. If the lender gives only a combined balance, request the breakdown needed to compare it with your books.

1. Match each drawdown using its reference, lender posting date, bank receipt and amount.
2. Where fees were withheld from a drawdown, show the gross loan movement, the deduction and the net bank receipt separately, supported by the lender's advice.
3. Match each repayment to the bank debit and the lender's allocation between principal, interest and charges.
4. Identify reversed or returned payments and check both records for the corresponding reversal.
5. Record payments made by another party separately and obtain evidence explaining who paid and how the books should reflect it.

Complete this alongside the bank reconciliation monthly routine guide. A bank reconciliation checks the cash movement; the loan reconciliation explains how that movement affects the borrowing and related costs.

Maintain a difference register showing the amount, relevant dates, evidence, proposed action, owner and review status. Separate an error requiring a correction from a timing difference awaiting evidence of settlement.

Do not pass an unexplained balancing entry. Equally, do not leave a supported accounting correction unposted merely because correspondence remains open. Keep the lender's position, your accounting conclusion and any unresolved dispute distinct.

Prepare a pack that lets the auditor follow each closing figure back to its evidence. Ask the auditor whether a lender balance confirmation is required and how it should be obtained; your reconciliation supports that process.

• ✓A summary tying the reconciled loan balance to the ledger and identifying related interest and charges balances.
• ✓The opening-to-closing principal bridge and transaction-level instalment splits.
• ✓Lender statements, bank evidence, the agreement and relevant repayment schedules.
• ✓A list of differences, including subsequent entries used to explain timing items.
• ✓Correction references, supporting calculations and evidence of review.
• ✓A clearly marked disputed-entry list with correspondence, an owner and the accounting conclusion or outstanding decision.

Use the accrued expenses supporting schedule guide for unpaid interest requiring separate review. Bring the completed pack into the year-end books closing checklist so that corrections reach the final ledger.

• Treating every bank debit as principal repayment.
• Comparing a principal ledger with a lender total that includes unpaid interest or charges.
• Using the repayment schedule without checking actual transactions.
• Recording only the net drawdown receipt without explaining withheld deductions.
• Reusing last year's timing differences without checking whether they cleared.
• Combining separate facilities so that one difference hides another.
• Describing a reconciliation as complete while disputed entries have no recorded review decision.

This routine is designed for a straightforward business loan. Overdrafts, revolving facilities, foreign-currency borrowing, lease liabilities and restructured arrangements need additional schedules. Agree the scope and accounting treatment with your chartered accountant before using this bridge as the complete close procedure.