Private mortgage lender bookkeeping: one ledger per loan, not one for the fund

Every mortgage is its own ledger, not a line in a spreadsheet

Each loan needs its own running record: principal advanced, scheduled payments, accrued interest, lender and renewal fees earned, and current arrears status if any. A pooled fund or a MIC with dozens of positions cannot be managed from a single interest-income total — the portfolio-level number is only trustworthy once it is built up from correct per-loan detail, not estimated top-down from bank deposits.

This per-loan discipline is also what makes investor reporting possible. A MIC issuing T5 slips to its shareholders, or a syndicate splitting one mortgage among several lenders, needs to know exactly how much interest each loan generated and how it was allocated — work that is straightforward with per-loan records and nearly impossible to reconstruct from a bank feed months later.

Interest usually accrues daily against the outstanding principal, and a partial repayment, a renewal at a new rate, or a discharge mid-month all change that calculation. We accrue interest at the loan level rather than recognizing it only when cash arrives, so income is recorded in the period it was actually earned — which also keeps a MIC's annual distribution calculation accurate rather than driven by whichever payments happened to land before year-end.

HST is mostly a non-issue — and that changes what the books track

Lending money is a financial service, and financial services are generally exempt supplies under the Excise Tax Act — so interest income and most mortgage-related fees are not subject to HST. The consequence surprises new lenders more than the exemption itself: because the activity is exempt rather than zero-rated, you generally cannot claim input tax credits on costs related to it, even though HST is being paid on legal fees, software, and other overhead — a private lender's HST return can look nearly empty even in a strong year, which is normal, not a sign something was recorded incorrectly. See the distinction explained on zero-rated versus exempt supplies and on how input tax credits work — both explain why a lending business's HST return often looks unusually thin.

Power-of-sale files need their own sub-ledger

When a borrower defaults and a lender proceeds to power of sale in Ontario, legal fees, realtor commissions, and carrying costs accumulate against that specific property before it sells — and Ontario law generally requires any surplus over principal, accrued interest, and costs to be returned to the borrower or other encumbrancers, not kept by the lender. That reconciliation only works cleanly if every dollar of workout cost was tracked against the right loan from the start, in its own sub-ledger separate from the performing book, rather than absorbed into general expenses.

Property tax and insurance advances made to protect the collateral while a loan is in default add another wrinkle — they are usually added to the amount owed by the borrower rather than expensed outright, so the sub-ledger needs to track them as a receivable against that loan, not as a cost that quietly disappears into the lender's overhead for the year.

A solo lender's books look different from a MIC's

Where the books meet compliance

If the fund uses a licensed mortgage administrator to service loans on its behalf, the books still need to reconcile the administrator's monthly statements down to the individual loan level — outsourcing servicing does not outsource the bookkeeping. The administrator's remittance may arrive as one net transfer covering dozens of loans; unwinding that back to per-loan interest, fees, and any withheld reserve is where a general bookkeeper without lending experience usually struggles, and it is exactly the kind of reconciliation we build a monthly checklist around from the start.

If any investor in the fund is a US resident, that changes the slip issued and the withholding tracked; see our cross-border tax page for private lenders. The monthly engine behind all of this is our bookkeeping service.