Slice it any way you'd ask.
Pick one. Each is a plain question, answered over all your loans by Janaly's engine, often across more than one report. If a field isn't in the report, Janaly says so and offers to add it.
You ask
Which brokers' 2024 loans go late most often?
| Broker | 2024 loans | Late now | Late rate |
|---|---|---|---|
| Broker C | 74 | 7 | 9.5% |
| Broker A | 212 | 8 | 3.8% |
| Broker E | 58 | 2 | 3.4% |
| Broker B | 168 | 4 | 2.4% |
| Broker D | 131 | 2 | 1.5% |
Broker C's 2024 loans are running late at 9.5%, about three times the book's 3.1%. Illustrative.
Want the loans behind it? Ask, and Janaly gives you the 23 late loans in a file, with every column from the report.
Need it every month? Ask Janaly: "Build a monthly report of late rates by broker for 2024 loans." Janaly builds it, you review and save it, and it refreshes on your schedule.
You ask
Does the late rate rise with loan size?
| Loan size | Loans | Balance | Late | Late rate |
|---|---|---|---|---|
| Under $250K | 760 | $98.8M | 19 | 2.5% |
| $250K to $500K | 190 | $70.4M | 7 | 3.7% |
| $500K to $1M | 270 | $162.0M | 9 | 3.3% |
| $1M or more | 64 | $81.4M | 5 | 7.8% |
| All active loans | 1,284 | $412.6M | 40 | 3.1% |
Loans of $1M or more run late at 7.8%, against 3.1% for the book. They are 5% of the loans and 20% of the balance. Illustrative.
Want the loans behind it? Ask, and Janaly gives you the 40 late loans in a file, with every column from the report.
Need it every month? Ask Janaly: "Build a monthly report of late rates by loan size." Janaly builds it, you review and save it, and it refreshes on your schedule.
You ask
Where are the late loans, by loan type and state?
| Late loans | TX | FL | GA | Other | Total |
|---|---|---|---|---|---|
| Bridge | 9 | 3 | 2 | 5 | 19 |
| Fix and flip | 3 | 2 | 1 | 4 | 10 |
| Construction | 3 | 1 | 1 | 3 | 8 |
| DSCR | 1 | 1 | 0 | 1 | 3 |
| Total | 16 | 7 | 4 | 13 | 40 |
Texas bridge loans are the largest group: 9 of the 40 late loans. Illustrative.
Want the loans behind it? Ask, and Janaly gives you the 40 late loans in a file, with every column from the report.
Need it every month? Ask Janaly: "Build a monthly report of late loans by loan type and state." Janaly builds it, you review and save it, and it refreshes on your schedule.
You ask
Who are our ten largest borrowers, and are any of them late?
| Borrower | Active balance | Loans | Late |
|---|---|---|---|
| B-277 | $11.2M | 31 | 2 |
| B-118 | $8.6M | 22 | 0 |
| B-402 | $7.4M | 19 | 1 |
| B-064 | $6.9M | 17 | 0 |
| B-331 | $6.1M | 16 | 1 |
| Top ten, with 5 more | $61.3M | 151 | 5 |
The ten largest hold $61.3M, 14.9% of the active balance. 4 of them have a loan late. Illustrative.
Want the loans behind it? Ask, and Janaly gives you the 151 loans in a file, with every column from the report.
Need it every month? Ask Janaly: "Build a monthly report of our ten largest borrowers." Janaly builds it, you review and save it, and it refreshes on your schedule.
You ask
How have our 2024 Texas bridge loans performed, month by month?
8.3% late in August, 7 of 84 loans, up from 2.1% last September. Illustrative.
Want the loans behind it? Ask, and Janaly gives you the 7 late loans in a file, with every column from the report.
Need it every month? Ask Janaly: "Build a monthly report of the late rate on 2024 Texas bridge loans." Janaly builds it, you review and save it, and it refreshes on your schedule.
You ask
Which borrowers have more than one late loan, and how much have we drawn on them?
| Borrower | Late loans | Balance | Drawn |
|---|---|---|---|
| B-259 | 3 | $3.4M | $1.9M |
| B-376 | 3 | $2.1M | $1.2M |
| B-277 | 2 | $1.6M | $0.8M |
| B-145 | 2 | $1.2M | $0.5M |
| B-208 | 2 | $0.9M | $0.3M |
| 5 borrowers | 12 | $9.2M | $4.7M |
5 borrowers hold 12 of the 40 late loans, $9.2M in all, with $4.7M drawn on them. Illustrative.
Want the loans behind it? Ask, and Janaly gives you the 12 loans in a file, with every column from the report.
Need it every month? Ask Janaly: "Build a monthly report of borrowers with more than one late loan and what we have drawn on them." Janaly builds it, you review and save it, and it refreshes on your schedule.
Illustrative. A sample book of 1,284 active loans, $412.6M, August 2026. Broker and borrower figures need your data to hold those fields.
Questions no standard report answers.
Plain questions, follow-ups, tables, charts and exports. Every answer names the report and the month it came from.
Who are our ten largest borrowers by active balance?
$61.3M together, 14.9% of the active balance. The largest holds $11.2M.
Which brokers brought the most volume in Q2?
The top five brought $46.2M of the $104.9M originated, 44%.
How does the active book split by loan size?
Loans under $500K are 74% of the count and 41% of the balance.
Where are our bridge loans concentrated?
Texas leads with 168 bridge loans and $58.4M, 46% of the Texas balance.
How has our note rate moved by vintage, simple against weighted?
Both are lower this year, the weighted one faster: 11.31% simple against 10.85% weighted on 2026 originations.
Give me the loans behind that late borrower list.
12 loans in a file you can download, with every column from the report.
Illustrative. A sample book of 1,284 active loans, August 2026. Broker and borrower figures need your data to hold those fields.
A custom report is a full report.
Whatever you ask Janaly to build gets the same treatment as your originations, loan performance and construction draw reports, and Janaly matches each loan across all of them.
- 1
One sentence
Describe the report the way you'd ask your analyst. No SQL, no template.
Build a monthly report of late rates by broker.
- 2
Report built, you save it
Janaly explores your tables, runs the queries and validates the report. You review it and save it.
Late rates by broker
3.1%late rate40late loans38brokers - 3
Refreshed on your schedule
Daily, weekly or monthly, at the time you pick. Janaly's engine calculates it the same way every refresh.
DailyWeeklyMonthlyOn the 1st, at 7:00 AM
- 4
The email arrives
The workbook, the PDF and Janaly's note on what changed, ready for your C-suite, your investors and your capital partners.
Your August late rates by broker report is ready
Broker C's late rate rose to 9.5%, from 8.1% in July.
XLSX Late rates by broker, August 2026PDF Late rates by broker, August 2026 - 5
Past months re-checked
Every refresh re-checks the months already reported, and when a past month metric changes, Janaly tells you and lists the loans behind it. See how it works.
1 prior month changed: March 2025
LN-20461 $412,000 then, $422,000 todayLN-20490 $286,500 then, $296,500 today - 6
Every change saved as a new version
Say what you want added. The report, the workbook and the PDF change together, saved as a new version. Earlier versions keep their numbers.
Version 1Version 2Version 3Version 3 added note rate. Version 2 keeps its numbers.
Illustrative.
Questions lenders ask.
What kinds of reports can Janaly build?
Any report your loan data supports. Originations, loan performance and construction draws are where most lenders start. Late rates by broker and borrowers with more than one late loan are two examples of what comes next.
Do I need to know SQL?
No. Describe the report or ask the question in plain English. Janaly explores your tables, runs the queries and validates the report before saving it.
What if a field isn't in my report?
Janaly checks the tables the report was built from and offers to add the field. If your data doesn't hold it, Janaly says so.
Can I share a report with investors?
Yes. Every report comes with a workbook and a PDF you can send to your investors and capital partners.
How do I get access?
Janaly isn't self-serve. Join the waitlist and John reaches out personally to set up your team. Free for a limited time for selected founding lenders.
More from Janaly.
Your next report, built from one sentence.
We're opening Janaly to a small group of real estate private lenders first. Janaly isn't a sign-up-and-figure-it-out tool: John onboards every founding lender personally.
Join the waitlistFree for a limited time for selected founding lenders.