Private lenders often rely on a loan schedule or servicing platform to monitor individual loans, borrower payments, interest, fees, maturity dates, and other loan-level activity. At the same time, the accounting department relies on the general ledger to prepare the organization’s financial statements.
Because these records serve different purposes and may be maintained by different people, service providers, or systems, they may not agree automatically. Some differences may be valid and expected. Others may indicate incomplete information, incorrect classifications, or transactions that were recorded in one system but not the other.
The objective of a reconciliation is not simply to force the two records to match. It is to establish a documented bridge showing that the correct loan population is included, activity has been classified appropriately, and significant differences have been identified, supported, and reviewed by management.
Two Records Serving Different Purposes
A loan schedule or servicing system generally maintains detailed information for individual loans. Depending on the platform and servicing arrangement, this information may include:
- Original and outstanding principal
- Borrower payment history
- Interest calculations
- Maturity dates
- Late charges and other borrower fees
- Modifications and extensions
- Default and foreclosure activity
- Partial and full payoffs
The general ledger records transactions by financial-statement account. It may contain summarized entries and accounting adjustments that are not maintained in the servicing system, including deferred loan fees, allowances, impairment-related adjustments, accruals, and transfers to real estate owned.
Begin With the Same Population
Before comparing balances, management should confirm that the two records cover the same entity, reporting date, loans, and ownership interests.
This is particularly important when a private lender:
- Services loans for affiliated or unrelated parties
- Sells whole loans or participation interests
- Retains only a fractional interest in certain loans
- Uses separate entities or funds to hold different portfolios
- Transfers loans between funds or related entities
- Uses a servicing platform containing both owned and serviced-only loans
A servicing report may show the total amount owed by the borrower even when the reporting entity owns only part of the loan. It may also contain loans that the entity services but does not own. Comparing that report directly with the general ledger can create an apparent difference that is actually caused by an inconsistent reporting population.
The reconciliation should clearly document which loans and ownership percentages belong to the reporting entity.
Why the Records May Not Agree
Differences may arise when transactions are recorded at different times, classified differently, or entered manually into one system without a corresponding entry in the other.
Common causes include:
- Transactions processed on different dates
- Backdated servicing entries
- General-ledger entries posted in summarized batches
- Manual journal entries not communicated to servicing personnel
- Servicing reports generated before subsequent accounting adjustments
- Inconsistent reporting cutoff dates
- Delays in communicating modifications, extensions, defaults, foreclosures, or payoffs
- Incomplete or failed system interfaces
The existence of a difference does not automatically indicate an error. The concern arises when no one can determine its cause, support the amount, or conclude whether the underlying accounting is appropriate.
Agreeing Totals May Still Hide Errors
A reconciliation should not be limited to comparing one total portfolio balance.
One transaction may affect several accounts. For example, a payoff may include:
- Outstanding principal
- Regular interest
- Default interest
- Late or extension charges
- Legal expenses
- Prepayment or other borrower fees
The total cash receipt may be correct even when the individual components are recorded incorrectly. Principal could be overstated while interest or fee income is understated, causing the combined amount to agree while the financial-statement classifications remain incorrect.
For this reason, management should separately reconcile the meaningful components of the portfolio, including principal, accrued interest, fees, advances, participations, and real-estate-owned activity when applicable.
A Practical Reconciliation Process
A useful reconciliation generally includes the following steps.
- Define the reporting population
Identify the entity, reporting date, included loans, ownership percentages, serviced-only loans, participations, and any transfers between entities or funds.
- Map servicing information to the general ledger
Document which servicing fields correspond to principal, accrued interest, fees, advances, investor balances, and other applicable general-ledger accounts.
- Reconcile beginning balances and activity
Whenever practicable, reconcile a roll forward rather than only the ending balance:
Beginning balance, plus fundings and other additions, less principal collections, payoffs, sales, transfers, and write-offs, equals the ending balance.
This approach helps identify when a difference arose and the type of transaction that caused it.
- Investigate differences by loan or account
Determine whether each difference relates to timing, classification, ownership, incomplete information, a system limitation, or an error.
- Document support and conclusions
Link significant reconciling items to bank records, servicing reports, settlement statements, participation records, legal documents, journal entries, or other relevant support.
- Record and review necessary adjustments
Accounting adjustments should be prepared and approved by authorized personnel. Unresolved items should be assigned to a responsible person and tracked to completion or incorporated into a permanent reconciliation bridge.
The reconciliation should show who prepared it, who reviewed it, and when the review was completed
Do Not Wait Until the Audit
The appropriate reconciliation frequency depends on the number of loans, transaction volume, portfolio complexity, system capabilities, and investor or regulatory reporting requirements.
For an active portfolio, a monthly reconciliation is often the most practical approach because transactions remain recent and supporting records are readily available. A lower-volume organization may determine that a quarterly process is appropriate based on its operations and reporting requirements.
Regardless of the precise frequency, year-end should not be the first time the servicing records and general ledger are compared.
Regular reconciliations help management:
- Identify processing and communication problems earlier
- Prevent unresolved items from accumulating
- Improve borrower and investor reporting
- Produce more reliable management information
- Reduce the effort required during financial-statement preparation and audit
Keeping Servicing and Accounting Aligned
A loan schedule and general ledger do not need to contain identical information or the same level of detail. They should, however, tell a consistent financial story.
A strong reconciliation confirms that both records cover the appropriate loan population, explains differences by financial-statement component, and establishes accountability for unresolved items. When this process is performed and reviewed regularly, private lenders are better positioned to identify issues promptly, improve financial reporting, and prepare efficiently for year-end.
Contact our office to discuss how your organization’s loan-servicing and accounting records are reconciled and whether the process is appropriately designed for the size and complexity of your portfolio.