What it means
A loan register is a controlled record of loans made or received by a business. It puts principal, rate, payment dates, lender or borrower, security and conditions in one place, but it is not the legal loan agreement and does not replace the general ledger.
It is a working view that helps finance staff know what is owed, when cash will move and what must be reported. Start with a separate line or record for each facility, including the contract date, facility limit, drawn amount, currency, lender, maturity and repayment pattern.
Record whether interest is fixed or floating and identify the benchmark, margin and reset dates when applicable. If one facility has multiple tranches with different terms, separate them so the schedule can be calculated correctly.
Use the signed agreement and lender statement as source documents, because a spreadsheet copied from last year's budget may have an old rate or maturity. Store document links or references beside each line, limit edit rights and retain a record of changes, especially where the register feeds payment approvals or external reporting.
A loan's opening balance plus draws, less principal repayments, usually gives its closing principal before other adjustments, and interest should be kept separate from principal since a monthly cash payment may contain both. Fees, capitalised interest and foreign-exchange effects may require additional columns and accounting review.
The total-debt calculation is simple only when the set of balances is clear: for three loans with outstanding principal of $1.2 million, $800,000 and $300,000 in the same currency, the sum is $2.3 million, and approved but undrawn facility limits must not be mixed into that total. If balances are in different currencies, translate them consistently for a reporting-date total and retain the original currencies in the register.
A register should flag contractual cash commitments such as instalment amounts, due dates, balloon payments, interest dates and maturity, so that a debt schedule can feed a weekly or monthly cash forecast. DebtBook's discussion of debt schedules describes their role in tracking repayment, interest and future obligations, and Atlar's guide to debt management discusses maintaining visibility across agreements, debt schedules and obligations.
Record covenants with their calculation definitions, thresholds, measurement dates, reporting dates and responsible owner, and note that a red flag on the register should prompt a contract review, not be treated as the final legal interpretation. Security and guarantees belong in the record too, including charged assets, guarantors, senior ranking and release conditions, and repaying most of a loan does not automatically release collateral.
Borrowings from owners or related parties should not vanish from the picture because they feel informal, and an undocumented loan should be flagged rather than given an invented interest rate or maturity. Reconcile each balance to current lender statements and the accounting ledger at least at the reporting cadence, investigate differences from unrecorded payments, interest postings, fees or exchange movements, and seek separate advice on related-party reporting and tax treatment.
In practice
Real-world examples.
Example
A finance team updates the loan register monthly after each statement arrives. It reconciles every balance to the lender's figure and the ledger. Differences are investigated and documented before the cash forecast is approved.
Example
The register flags a covenant test due next quarter. The finance manager checks the definition in the agreement and prepares the calculation early. The lender receives the compliance certificate before the deadline.
Example
A company lists shareholder loans alongside bank loans, with their written terms and any subordination to the bank. The directors see all borrowing in one place. Undocumented balances are marked for the lawyers to paper.
Formula
Calculation
Total debt = Sum of loan balances in the register. Closing principal = opening balance + draws - principal repayments.
Worked example: loans of $1,200,000, $800,000 and $300,000 give total debt of $1,200,000 + $800,000 + $300,000 = $2,300,000. If the $800,000 loan is repaid by $50,000 of principal in the quarter and the company draws a further $150,000 on the $300,000 line, closing principal on those two loans is $800,000 - $50,000 = $750,000 and $300,000 + $150,000 = $450,000. Total debt then becomes $1,200,000 + $750,000 + $450,000 = $2,400,000.Case study
Seen in the real world.
This illustrative and entirely fictional case follows Crescent Clinics, an invented group with six loans from three banks. Its finance lead builds a register from signed agreements and statements, records covenant deadlines and assigns a backup reviewer. A mismatch in one balance is investigated before the monthly forecast is approved; future compliance still requires active monitoring.
The investigation shows that a payment made on the last day of the month was posted by the bank the following week. The finance lead records the timing difference in the register and adds a column for payments in transit, so the same mismatch does not surprise the team again. The group and its loans are invented, and the story is illustrative only.
Watch out
Common mistakes.
- Leaving covenants or notice deadlines in separate documents with no owner.
- Adding facility limits to drawn principal when reporting total debt.
- Failing to reconcile balances to lender statements and the ledger.
Questions
People also ask.
What is a loan register?
A maintained record of each loan, its terms, balance and important dates.
What should it include?
Principal, currency, rates, repayment dates, security, covenants and source documents.
How often should it be updated?
Update for each material loan transaction and reconcile at least at each reporting cycle.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%