Automate loan
profitability reporting

Mage connects your mortgage origination and accounting systems, learns your reporting rules, and reuses that knowledge to report profit and cost per funded loan.

Load loans
ICE Encompass
Load ledger
Sage Intacct
Load comp
Microsoft Excel
Load costs
Google Sheets
Match loans
Calculate
Reconcile
Deliver report
Route open items

From funded loans to finance-ready reporting

Connect production, revenue and expenses so finance can review loan profitability, understand unit costs and trace the figures to their source.

Cost per funded loan200 funded loans
Direct production$9,600
+
Corporate allocation$1,200
=
Total cost / loan$10,800
Direct productionCorporate allocation
Purchase
$11,200
Refinance
$13,200
Home equity
$7,200
$0$14K

Cost per loan, explained
Match ledger expenses and commissions without double-counting. Allocate overhead across the funded-loan cohort.

Profit after allocation
ProfitCorporate allocation
Purchase$156K
Refinance$72K
Home equity$12K
$0$160K$320K

Profitability by loan group
Compare revenue, production costs and profit across purchase, refinance and home-equity loans on the same reporting basis.

Revenue tied to source
Source revenue
$2.43M
Matched cohort
$2.40M
Unmatched revenue
$30K
3 open entries
REV-0201$12K
REV-0202$10K
REV-0203$8K

Loan revenue, reconciled
Trace funded-loan revenue to ledger records, with unmatched entries kept outside the cohort and visible for finance review.

Explore the platform

Measure the impact on loan profitability reporting

Capacity

Hours back
each close

Measure loan profitability report preparation at comparable funded volume and loan mix.

Speed

Earlier
profitability reports

Track time from the agreed source cutoff to delivery of the checked loan profitability report.

Quality

Unmatched revenue
kept visible

Track unmatched revenue entries and dollars excluded from the funded-loan cohort.

How Mage fits

Connect loan production to the finance view

Your loan and accounting systems stay in place. Mage prepares the profitability report between those sources and the reporting tools your finance team uses.

Your systems

Loan production

Funded loans, amounts and loan group mappings

Finance records

Revenue, commissions and agreed expenses

Reporting rules

Cutoffs, account mappings and cost allocations

The reporting workflow between your tools

  1. 1Match loans
  2. 2Calculate profit and cost
  3. 3Reconcile and deliver

Completed outputs

Profitability report

Revenue, contribution and allocated profit

Cost-per-loan view

Unit costs on the agreed funded-loan basis

Reconciliation register

Source checks and unresolved differences

Explore enterprise

Put loan profitability reporting on repeat

We connect funded-loan records, ledger expenses and allocation rules, then run the workflow that prepares your loan profitability report.

Explore solutions
ICE Encompass
Encompass
Sage Intacct
Intacct
Microsoft Excel
Commissions
Allocations
Reporting rules
Loan profitability report
200 funded loans3 open items
Profit after allocation$240K
Cost per funded loan$10,800
Funded volume $90MRevenue $2.40M
Contribution before overhead$480K
Revenue, cost and profit in $KProfit in $K · Cost / loan in $. Illustrative management report for 200 funded loans: $90M funded volume, $2.40M revenue, $1.92M direct production costs and $240K corporate allocation. Total cost is $2.16M, contribution before overhead is $480K, and profit after allocation is $240K. Cost per funded loan is $10,800. Three unmatched revenue entries totalling $30K are excluded from the cohort. This is a synthetic example, not a customer result.
Loan groupLoansRevenueCostProfitCost / loan
Purchase1201,5001,344156$11,200
Refinance4060052872$13,200
Home equity4030028812$7,200
Total2002,4002,160240$10,800

3 unmatched entries · $30K excluded

Finance report delivered

Learn

Define the funded-loan basis

Map funded loans, production income and expenses to your reporting definitions.

Design

Map revenue and costs

Define loan groups, cost allocations and source checks for the profitability report.

Automate

Run profitability reporting

Validate each loan report with finance, refresh the figures and route open entries.

Automate loan profitability reporting

Tell us which loan origination and accounting systems you use, how you define funded loans, and how you allocate production costs. We’ll discuss how to automate the report.

We’ll use your information to respond to your request. Privacy Policy