Why it matters
Reports answer the questions an owner asks every month: where funded deals come from, which lenders pay off, which reps convert, and what each lead source really costs. They read the same data the team works in, so they are only as honest as the stages, decline reasons and commissions the team records.
The four reports
| Tab | Answers | Group by |
|---|---|---|
| Conversion funnel | How leads and deals created in the range moved from application to submission, approval and funding. | By source, By rep (Pro), Total only |
| Lender scorecard (Pro) | Approval rate, time to offer, price and decline reasons per lender. | One row per lender |
| Volume & commission | Deals funded in the range, payback, and commission expected vs received. | By month, By lender, By rep (Pro) |
| Lead source ROI (Pro) | What each source's leads cost against the commission their funded deals earned. ROI uses expected commission. | One row per source |
Items marked Pro need Advanced reports, which the Pro plan includes. Without it, those tabs show what the feature does instead of the data.
Filters
- 1Open Reports and pick a tab.
- 2Choose a date range: This month, Last month, Last 30 days, This quarter, Year to date, Last 12 months (the default) or Custom range (up to three years).
- 3Narrow by rep (All reps) and lender (All lenders). Filters live in the page address, so a bookmarked or shared link opens the same view.
Agents always see their own deals only; the filter bar says so. Merchants marked as test records never count.
Exporting to CSV
- Reports: Export CSV in the page header downloads the current tab with its range and filters.
- Lists (funded deals, all commissions, leads, deals and the rest): the download button above the table exports the rows that match your current filters. It shows on tablets and computers.
- Commissions overview: Export CSV downloads the commissions in the chosen range.
| Role | Can export? |
|---|---|
| Owner, manager | Yes, everything they can see |
| Agent | Yes, their own records only |
| Processor, read-only | No |
Every export is written to the audit log with who ran it. Files never contain full Social Security numbers or bank account numbers, and cells a spreadsheet could run as a formula are neutralized.
Tips
- Run Volume & commission by lender next to the Commissions overview: a lender with high volume and a big outstanding balance is one to chase.
- Lead source ROI needs a cost on each source. Set it in Settings → Lead sources.
- The funded deals export includes paid %, balance, status, estimated payoff and renewal eligible date: a ready-made book review for a lender meeting.
Questions
Why can't a processor export a report?
CSV export is a separate permission. Owners, managers and agents have it; processors and read-only users can view reports but cannot download them. An owner can change a user's role if they need exports.
Try it in the app
Signed in? Open the screen this lesson covers.
Finished this lesson?
0 of 7 lessons in Funded deals, commissions and reports
Progress is saved in this browser. Sign in to keep it across devices.
Related lessons
- Underwriting and analysisLender scorecard and underwriting reportsUse the lender scorecard and each lender's performance tab to see who approves, how fast, at what price, and why they decline, then fix your criteria.
- Start hereRoles and permissionsThe five roles in plain language: owner, manager, agent, processor and read only. Who sees which records, who can reveal sensitive values and export.
- Sales and merchant conversationsLead sources and what they really costLive transfers, aged data, UCC lists, web leads, referrals and partners compared, with a worked example of cost per funded deal by source.
- Funded deals, commissions and reportsCommissions: expected, received and clawed backHow expected commissions and splits are created at funding, how to mark them received or short-paid, dispute them, and record a clawback.
- Help centerExport your dataDownload any list to CSV with its current filters, and what you need to know about permissions and sensitive fields.
- Help centerRoles and permissionsWhat owners, managers, agents, processors and read-only users can see and do.