Dashboard / Reports
Reports
Portfolio, servicing, lead, lender and year-end reports. Every report can be filtered, exported to Excel or PDF, printed, or emailed on a schedule.
38 reports · a report you are not allowed to open is hidden
Servicing
Leads
Lenders / investors
Accounting & tax
Operating & trust account ledgersLive ↗Team & management
Risk, trust & compliance
Portfolio risk dashboardLive ↗ Monthly trust reconciliation (3-way)Monthly ↗ Bank reconciliation — unmatched itemsLive ↗ Accounting journal export (QuickBooks / Xero)Monthly ↗ FINTRAC compliance summaryMonthly ↗ E-signature statusLive ↗My custom reports
Figures come from the live ledger: "Payments received" totals match the loan ledgers and "Lender distributions" matches the distribution runs. General-ledger reports need the Accounting permission; A/P aging needs Payables; the portfolio risk report needs Risk.
Maturing in 90 days
7
0–30 days
0
31–60 days
2
61–90 days
5
Maturing loans — next 90 days
Generated Sep 26, 2026 9:00 AM| Loan | Borrower | City | Pos. | Principal | Rate | Matures | Days | Renewal |
|---|---|---|---|---|---|---|---|---|
| #1098 | Karan Singh | Vaughan | 1st | $310,000 | 9.99% | Nov 1, 2026 | 36 | Terms needed |
| #1112 | Crestview Homes Ltd. | Milton | 1st | $875,000 | 10.49% | Nov 15, 2026 | 50 | Offer sent |
| #1131 | Anthony Romano | Etobicoke | 2nd | $150,000 | 12.99% | Dec 1, 2026 | 66 | Terms needed |
| #1061 | P. Wong | Richmond Hill | 1st | $520,000 | 9.75% | Dec 5, 2026 | 70 | Not started |
| #1077 | Oakridge Properties Inc. | Brampton | 2nd | $240,000 | 12.25% | Dec 12, 2026 | 77 | Paying out |
| #1089 | D. & M. Costa | Burlington | 1st | $385,000 | 9.49% | Dec 15, 2026 | 80 | Terms needed |
| #1102 | H. Ali | Markham | 2nd | $120,000 | 12.99% | Dec 20, 2026 | 85 | Not started |
| 7 loans | $2,600,000 | |||||||
Principal maturing by month
1st position4 · $2,090,000
2nd position3 · $510,000
Offers still to prepare3
Expected in September
$145,526
Received
$142,380
Returned (NSF)
$3,146
Fees collected
$0
Payment detail
Sep 1 – Sep 30, 2026| Date | Loan | Borrower | Method | Reference | Amount | Status |
|---|---|---|---|---|---|---|
| Sep 1 | #1026 | Mohan Patel | PAD | PAD batch 0901 | $5,061.33 | Cleared |
| Sep 1 | #1098 | Karan Singh | Cheque | CHQ 000388 | $2,580.75 | Cleared |
| Sep 1 | #1131 | Anthony Romano | PAD | PAD batch 0901 | $1,623.75 | Cleared |
| Sep 1 | #1143 | Northgate Holdings Inc. | Post-dated cheque | PDC 7 of 12 | $1,848.46 | Cleared |
| Sep 3 | #1187 | James & Rachel Nguyen | PAD | PAD batch 0903 | $3,146.50 | NSF — returned Sep 8 |
| Sep 5 | #1204 | Samuel Oduya | PAD | PAD batch 0905 | $988.79 | Cleared |
| Sep 7 | #1219 | Harbour Lane Developments Ltd. | Cheque | CHQ 002114 | $10,677.08 | Cleared |
| Sep 15 | #1112 | Crestview Homes Ltd. | PAD | PAD batch 0915 | $7,648.96 | Cleared |
Showing 8 of 48 paymentsReceived total $142,380.00
Received by week
PAD / EFT31 · $86,215.40
Cheque & post-dated cheque14 · $52,904.60
E-transfer / wire2 · $3,260.00
Total in arrears
$3,396.50
1–30 days
$3,396.50
31–60 days
$0
61–90 days
$0
90+ days
$0
A/R aged receivables
| Loan | Borrower | Item | Original due | Current | 1–30 | 31–60 | 61–90 | 90+ | Last contact | |
|---|---|---|---|---|---|---|---|---|---|---|
| #1187 | James & Rachel Nguyen | Interest (NSF) | Sep 3 | — | $3,146.50 | — | — | — | Sep 9 · NSF letter | |
| #1187 | James & Rachel Nguyen | NSF fee | Sep 8 | — | $250.00 | — | — | — | Sep 9 · NSF letter | |
| Total | $0.00 | $3,396.50 | $0.00 | $0.00 | $0.00 | |||||
NSF history — last 12 months
| Date | Loan | Borrower | Amount | Fee | Resolved |
|---|---|---|---|---|---|
| Sep 3, 2026 | #1187 | James & Rachel Nguyen | $3,146.50 | $250.00 | Open |
| Apr 1, 2026 | #1131 | Anthony Romano | $1,623.75 | $250.00 | Apr 6 · e-transfer |
| Jan 5, 2026 | #1204 | Samuel Oduya | $988.79 | $250.00 | Jan 9 · certified cheque |
Leads received
29
Converted to deals
11
Conversion rate
38%
Avg. days lead → deal
12
By source / broker
| Source | Leads | Converted | Lost | Rate | Funded value |
|---|---|---|---|---|---|
| Summit Mortgage Group | 12 | 5 | 7 | 42% | $2,140,000 |
| Keystone Financial | 8 | 3 | 5 | 38% | $1,090,000 |
| Direct (website / phone) | 6 | 2 | 4 | 33% | $455,000 |
| Referral | 3 | 1 | 2 | 33% | $230,000 |
| Total | 29 | 11 | 18 | 38% | $3,915,000 |
Why leads were lost
Lenders are paid their share of interest only once the borrower's payment clears. Interest on #1187 is held until the NSF is resolved.
Distributions — September 2026
| Lender | Loan | Amount invested | Lender rate | Interest due | Pay by | Status |
|---|---|---|---|---|---|---|
| Maplewood Family Trust | #1026 M. Patel | $640,000 | 8.25% | $4,400.00 | Sep 5 | Paid |
| R. Bhatia | #1187 J. & R. Nguyen | $250,000 | 8.00% | $1,666.67 | Sep 8 | Held — NSF |
| Northshore Holdings Inc. | #1187 J. & R. Nguyen | $170,000 | 8.00% | $850.00 | Sep 8 | Held — NSF |
| S. & L. Grewal | #1219 Harbour Lane Developments Ltd. | $500,000 | 8.50% | $3,541.67 | Sep 10 | Paid |
| Dunmore Capital Corp. | #1112 Crestview Homes Ltd. | $500,000 | 8.75% | $3,645.83 | Sep 18 | Paid |
| Total (sample of 5 lender positions) | $14,104.17 | |||||
Leads handled
29
Deals converted
11
Tasks completed
264
Payments processed
144
By team member
Last 90 days| User | Role | Leads handled | Commitments sent | Deals converted | Avg. days to convert | Tasks done | Overdue | Payments processed |
|---|---|---|---|---|---|---|---|---|
AMAlex Morgan | Owner / Admin | 11 | 9 | 4 | 11 | 64 | 1 | 18 |
PNPriya Nair | Underwriter | 15 | 14 | 6 | 12 | 88 | 2 | 6 |
DBDaniel Brooks | Servicing Admin | 3 | 2 | 1 | 15 | 112 | 1 | 120 |
| Team total | 29 | 25 | 11 | 12 | 264 | 4 | 144 | |
Deals converted by user
Counts come from the activity log: who moved each lead, sent each commitment, completed each task and recorded each payment.
Report
Sample rows — the real report shows every matching record.
Loans · Position is 2nd · Combined LTV > 70% · Status is Active
| Loan # | Borrower | Property address | Pos. | Principal | Rate | FMV | Combined LTV |
|---|---|---|---|---|---|---|---|
| #1166 | D. Kaur | Hamilton | 2nd | $120,000 | 12.99% | $640,000 | 78% |
| #1171 | Lakeshore Infill Corp. | Mississauga | 2nd | $210,000 | 12.75% | $1,150,000 | 77% |
| #1204 | Samuel Oduya | 77 Lakeshore Rd, Mississauga | 2nd | $95,000 | 12.49% | $780,000 | 75% |
| #1131 | Anthony Romano | 61 Kipling Ave, Etobicoke | 2nd | $150,000 | 12.99% | $905,000 | 74% |
| #1143 | Northgate Holdings Inc. | 118 Queen St | 2nd | $185,000 | 11.99% | $1,210,000 | 72% |
| 5 rows · Sum principal | $760,000 | 12.64% avg | |||||
Summary by city
Schedule this report
The report runs automatically and is emailed as an attachment.
Scheduled reports
Reports that email automatically. The schedule is checked every 15 minutes.
| Report | Schedule | Recipients | Next run | |
|---|---|---|---|---|
| Maturing loans (90 days) | Weekly · Mon 8:00 AM · Excel | Alex, Daniel | Oct 5 | |
| Payments received | Monthly · 1st business day · 7:00 AM · PDF | Alex, [Accountant] | Oct 1 | |
| NSF & arrears aging | Daily · 8:30 AM · Excel · skip when empty | Daniel | Oct 1 | |
| Portfolio risk dashboard | Monthly · 1st business day · 7:00 AM · PDF | Alex, Priya | Oct 1 | |
| 2nd mortgages over 70% LTV Custom | Quarterly · 1st of the month · Excel Paused | Alex | — |
Custom report builder
Pick a data source, the columns you want, filters and grouping. Save it to reuse or schedule it.