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.
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 loan, explained
Match ledger expenses and commissions without double-counting. Allocate overhead across the funded-loan cohort.
Profitability by loan group
Compare revenue, production costs and profit across purchase, refinance and home-equity loans on the same reporting basis.
- Source revenue
- $2.43M
- Matched cohort
- $2.40M
- Unmatched revenue
- $30K
Loan revenue, reconciled
Trace funded-loan revenue to ledger records, with unmatched entries kept outside the cohort and visible for finance review.
Measure the impact on loan profitability reporting
Hours back
each close
Measure loan profitability report preparation at comparable funded volume and loan mix.
Earlier
profitability reports
Track time from the agreed source cutoff to delivery of the checked loan profitability report.
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
- 1Match loans
- 2Calculate profit and cost
- 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
Keep reporting aligned with your finance definitions.
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| Loan group | Loans | Revenue | Cost | Profit | Cost / loan |
|---|---|---|---|---|---|
| Purchase | 120 | 1,500 | 1,344 | 156 | $11,200 |
| Refinance | 40 | 600 | 528 | 72 | $13,200 |
| Home equity | 40 | 300 | 288 | 12 | $7,200 |
| Total | 200 | 2,400 | 2,160 | 240 | $10,800 |
Define the funded-loan basis
Map funded loans, production income and expenses to your reporting definitions.
Map revenue and costs
Define loan groups, cost allocations and source checks for the profitability report.
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.