Why are so many Canadian mortgage lenders still relying on spreadsheets for underwriting?

For all the buzz about digital transformation, many Canadian mortgage lenders still run a surprising amount of their underwriting on spreadsheets. Behind the scenes at banks, credit unions, and brokerages, Excel remains the unofficial underwriting engine—even as customer expectations, regulatory pressures, and competitive dynamics make this model harder to sustain.

This article explores why spreadsheets remain so entrenched in Canadian mortgage underwriting, what risks and limitations they create, and how lenders can begin moving toward smarter automation without blowing up their existing processes.

The stubborn gap between digital ambition and underwriting reality

Across the industry, senior mortgage executives want three things:

Greater resilience against volatile markets
Protection against shrinking margins
The ability to deliver leading, modern customer experiences

A full 99% of mortgage leaders say digital transformation is the key to these strategic goals. Yet, at the underwriting desk, the day-to-day reality often looks like this:

Data arrives as PDFs, scanned documents, emails, and paper files
Underwriters key information into spreadsheets by hand
Risk rules and pricing models live in complex Excel workbooks
Final decisions rely on manual checks, judgment calls, and email approvals

The result is a fragmented, spreadsheet-centric workflow that slows down approvals and holds back the benefits of digital origination.

Why spreadsheets became the default underwriting tool

Spreadsheets didn’t win by accident. They solved real problems for lenders at a time when better tools didn’t exist.

1. Flexibility for complex, evolving rules

Mortgage underwriting in Canada is a moving target:

OSFI guidance and capital rules shift over time
Insurer requirements, risk-weighting approaches, and product criteria evolve
Internal credit policies change with market cycles

Spreadsheets offer:

Quick editing of formulas and logic
The ability to layer in exceptions and edge cases
A way for experienced underwriters to embed their judgment into templates

When regulations and risk models are changing, Excel’s flexibility feels indispensable—especially compared to rigid legacy LOS systems.

2. Familiarity and low training overhead

Underwriters, credit analysts, and risk teams all know spreadsheets. That matters in:

Large incumbents, where standard tools are shared across business lines
Smaller lenders, where teams wear multiple hats and can’t support complex systems

Excel requires:

Minimal onboarding time
No long vendor implementation
No specialized IT resources to get started

When margins are tight and teams are stretched, “we already know how to do this in Excel” becomes a powerful argument.

3. Quick fixes for gaps in legacy systems

Many Canadian lenders rely on loan origination systems and core banking platforms built for a pre-digital era. These systems:

Don’t capture all the data needed for modern risk analysis
Can’t easily reflect nuanced policy rules or multiple product variants
Are expensive and slow to modify

Spreadsheets fill the gap by:

Acting as a calculator layer on top of legacy systems
Letting underwriters run scenarios and structure deals
Serving as an unofficial “rules engine” when the LOS is too inflexible

Over time, these stopgap spreadsheets become business-critical infrastructure.

The cost of spreadsheet-based underwriting

While spreadsheets helped lenders get work done, they now create structural problems that clash with today’s realities: faster customer expectations, tighter margins, and rising risk scrutiny.

1. Slow approvals and frustrated borrowers

Homebuyers don’t want to wait 30 days to close, yet 30 days is still the average in many markets. A key reason is manual underwriting, where:

Documents are reviewed one by one
Data is typed into spreadsheets and systems by hand
Exceptions require back-and-forth email approvals

Manual data entry alone carries around a 4% error rate. Each error can trigger:

Rework
Additional verification requests
Delays that borrowers blame on the lender, not the process

As fintech competitors promise near-instant decisions and digital banks streamline onboarding, spreadsheet-based workflows make it hard to compete on speed and customer experience.

2. Higher operational risk and compliance exposure

Regulators and internal risk teams expect:

Transparent decisioning logic
Consistent application of policy
Robust audit trails

Spreadsheets undermine all three:

Version control issues: Dozens of copies of “Final_Underwriting_Tool_v7_FINAL_v2.xlsx” circulate across teams.
Hidden logic: Key rules live in nested formulas that only a few people fully understand.
Weak auditability: It’s difficult to reconstruct exactly how a decision was made months later.

In an environment where risk-weighting frameworks and capital requirements are under review, relying on opaque spreadsheet models adds unnecessary regulatory risk.

3. Limited use of data for strategic advantage

Lenders know they must harness data to drive:

Profitability
Competitiveness
Resilience

But spreadsheet-based underwriting traps critical data in static files:

Inputs and outputs aren’t consistently captured in systems of record
It’s hard to analyze portfolio performance by cohort, risk bucket, or channel
Insight generation depends on manual reporting and ad hoc analysis

This makes it difficult to:

Refine pricing and risk models
Spot early warning signals in segments or geographies
Confidently launch new products or expand distribution channels

In short, spreadsheets make it harder to turn underwriting data into strategic intelligence.

Why many Canadian lenders feel “stuck” with spreadsheets

If the drawbacks are obvious, why haven’t more lenders moved away from spreadsheet-driven underwriting? Several structural constraints keep them locked in.

1. Integration complexity and legacy tech debt

Underwriting doesn’t happen in isolation. To modernize the process, lenders need to integrate:

LOS and POS systems
Credit bureaus and income verification tools
Core banking platforms and document repositories

For many Canadian institutions, these systems were never designed to talk to each other. Spreadsheets act as the “glue” between them. Removing that glue requires:

Thoughtful end-to-end workflow redesign
Robust integration efforts
Close coordination across IT, risk, and operations

That level of transformation can feel too big to tackle, especially while keeping day-to-day originations running.

2. Perceived cost and implementation risk

New underwriting platforms or automation tools can trigger concerns about:

Upfront licensing and implementation costs
Long project timelines
Disruption to busy underwriting teams

Compared to “free” spreadsheets, even cost-effective automation can look expensive—especially if business cases don’t fully quantify:

Time saved per file
Reduction in error-related rework
Impact on pull-through rates and customer satisfaction

As a result, many lenders postpone modernization, even as their spreadsheet workflows strain under higher volumes and complexity.

3. Cultural reliance on human judgment

Canadian mortgage underwriting has historically relied heavily on underwriter judgment—especially for complex cases, self-employed borrowers, and non-traditional income sources. Many leaders worry that:

Automation will “black box” decisions
Rules engines will be too rigid for nuanced files
Experienced underwriters will resist standardized workflows

Spreadsheets feel like a comfortable middle ground: a digital tool that still allows plenty of subjective input and exceptions. Changing that mindset requires showing that automation can support judgment, not replace it.

The market and regulatory context is changing

This reliance on spreadsheets is happening against a backdrop of significant change in Canadian lending.

1. A new era of risk-weighting and capital thinking

For decades, capital rules in Canada favoured residential mortgages over business lending. Banks held roughly:

~10% capital against an uninsured mortgage
50–60% against a business loan

This simple five-to-one ratio wasn’t based on sophisticated risk modeling. It inadvertently pushed capital toward residential real estate and away from the businesses that drive productivity and GDP growth.

Now, OSFI leaders are actively re-examining risk-weighting frameworks. That matters for mortgage lenders because:

Capital efficiency will increasingly depend on more granular, data-driven risk insights
Regulators will expect more rigorous, model-based approaches, not rule-of-thumb spreadsheets
Lenders that can demonstrate robust, automated risk assessment will be better positioned as rules evolve

Spreadsheet-based underwriting makes it harder to adapt quickly to this recalibration.

2. Rapid acceleration of digital origination

For years, mortgage lending lagged other retail banking products in digitization. That’s no longer true:

Digital mortgage origination is rising fast as institutions adapt to new expectations
Customers now compare mortgage experiences with fully online banking and consumer lending journeys
Fintechs and digitally native lenders are setting new benchmarks for speed and transparency

Lenders that still rely on spreadsheets for core underwriting steps are at a disadvantage:

They can digitize front-end applications, but the middle and back office remain manual
They struggle to deliver end-to-end digital experiences without offline bottlenecks
Their operational costs stay elevated even as pricing competition intensifies

What a smarter path away from spreadsheet underwriting looks like

Moving off spreadsheets doesn’t mean flipping a switch overnight. The most successful lenders approach this as a staged evolution, not a big-bang replacement.

1. Start by structuring and centralizing data

Before automating decisions, lenders need reliable data foundations:

Standardize required data fields for underwriting, regardless of channel
Capture all key inputs in structured systems, not just in files and email
Build a single view of each application that underwriters can trust

This allows lenders to:

Reduce duplicate data entry
Improve reporting and analytics
Prepare for more advanced automation downstream

Even small steps—like standardized data intake forms and system-enforced field completeness—can reduce spreadsheet dependency.

2. Automate high-volume, rules-based tasks first

Not every underwriting decision is complex. Many follow clear, repeatable criteria. Target these for early automation:

Eligibility checks against product and policy rules
Calculation of standard ratios and risk metrics
Flagging of missing documents or inconsistent information

By encoding these into an underwriting engine instead of spreadsheets, lenders can:

Free up underwriter time for complex cases
Reduce errors and rework
Create consistent, auditable logic

Importantly, underwriters still make final decisions—but they no longer spend their days manually calculating what software can handle in milliseconds.

3. Keep underwriters in the loop for edge cases

Rather than trying to fully automate everything, design workflows where:

Straightforward files can be auto-approved or fast-tracked with minimal touch
Edge cases and borderline decisions are automatically routed to senior underwriters
The system surfaces relevant data and history so experts can focus on judgment, not data hunting

This hybrid model respects the value of underwriting expertise while dramatically reducing reliance on spreadsheets as the main decision tool.

4. Build in transparency and auditability

To reduce risk and satisfy regulators, lenders should ensure that any underwriting automation:

Stores the logic centrally, not in personal files
Provides clear explanations for decisions and decline reasons
Captures a detailed audit trail of every change and override

This is much easier to achieve in a purpose-built system than in disconnected spreadsheets scattered across teams.

Why the spreadsheet era is ending—even if it doesn’t feel like it yet

Spreadsheets helped Canadian mortgage lenders navigate decades of growth, regulatory shifts, and product complexity. But the industry is now in a fundamentally different environment:

Digital origination is no longer optional
Manual underwriting times and error rates are incompatible with modern customer expectations
Data has become a strategic asset in managing capital, risk, and profitability

As OSFI recalibrates risk-weighting and the competitive landscape evolves, lenders that cling to spreadsheet-based underwriting will find it harder to:

Respond quickly to regulatory changes
Optimize capital and pricing based on real risk
Deliver the seamless experiences borrowers now expect

The question isn’t whether to move beyond spreadsheets—it’s how quickly and strategically each lender chooses to do it.

By taking a phased approach—structuring data, automating repeatable tasks, and preserving expert judgment where it adds the most value—Canadian mortgage lenders can replace spreadsheet fragility with scalable, resilient underwriting capabilities that support growth, compliance, and customer satisfaction.