A consolidation report shows a client what rolling their existing debts into the mortgage would do to what they pay every month. There are two ways to build one, and they pull the debts from different places, so pick the one that matches what you're trying to show.
Starting From the Debt Consolidation Preset
Open Report Builder and pick the Debt Consolidation preset. It loads a title, an intro letter, a debt inventory, a consolidation summary, an equity snapshot, borrowing power, a broker call to action, and a disclaimer, in that order, matching the report a broker actually sends.
Where the Debts Come From
Built from the preset, every debt already on the deal's own file is pulled in automatically - you're not choosing which ones to include here. A debt with no rate of its own on record is assumed at a conservative revolving-credit rate near 20% rather than left blank, so if getting one debt's real cost right matters, refine it on the deal's own calculator first rather than trusting the assumed rate.
What the Report Works Out
The consolidation summary widget compares today's combined monthly outflow, across every debt plus the mortgage, against a recommended scenario - a refinance, a HELOC, or a reverse mortgage - and shows the new monthly payment, the monthly savings, and interest saved over five years. The debt inventory widget lists every debt with its balance and monthly payment underneath, so the client can see exactly what's being folded in.
Modelling It on the Deal Instead
For finer control - choosing which debts actually roll in, and setting your own new mortgage and HELOC rate assumptions - use the Consolidate panel in Use the Deal Calculator instead. It lists every non-real-estate debt on the deal (a debt already secured by real estate is left out, since the property carrying it already counts), lets you tick just the ones you want to model, and lets you secure the consolidation against a different property when the deal has more than one. This is also where a debt's rate gets refined before the Report Builder preset's assumption is trusted for it.
Reviewing It Before You Send
Whichever path built it, the report paints in your brokerage's brand colours and fonts before you preview it, and a debt that isn't amortizing at its minimum payment gets flagged, since the true cost of leaving it alone is higher than the headline figures show. Save the layout as a template from Report Builder to reuse it on the next client, or export straight from the deal calculator through the same Preview & Export flow every calculator uses.
What to Do Next
- Build a Custom Report if you want to adjust what a consolidation report includes beyond the preset.
- Copy or Export a Calculation for the calculator-side download and copy options.
- Record Commission on a Deal once a consolidation report leads to a placed deal.