Scotsman Guide Commercial Lenders

Getting past the basics of Scotsman Guide Commercial Lenders

Most people who run into this tool are either new credit officers trying to evaluate a commercial loan, or analysts working on syndicated debt where you need comparable transaction data. Scotsman Guide Commercial Lenders sits in that second bucket mostly. It's a subscription database that tracks commercial real estate lending transactions, pulling data from public records, lender disclosures, and proprietary sources. The interface is utilitarian at best. You search, you filter, you export. That's the entire workflow. I learned to use it during my second year in commercial real estate finance, when our team had to benchmark a $42 million bridge loan we were underwriting on a mixed-use property in the Southeast. The loan was sitting in a pitch book for a potential sale, and we needed recent comps fast. The platform gave us about 18 transactions within a 150-mile radius over the prior 24 months. Took me roughly three weeks to feel comfortable navigating the filters without getting lost in dead ends.

How to actually use Scotsman Guide Commercial Lenders

Start by defining your search parameters before you even log in. Think about property type, geography, loan amount range, loan date window, and lender if you have one in mind. The platform lets you layer these filters, but the defaults are aggressive. If you don't narrow anything, you'll get thousands of results and no useful signal. I usually start with a tight geo-filter, then widen from there. Setting a date range of 18 to 24 months back gives you enough data without drowning in stale entries. Older than three years tends to be less useful for current underwriting decisions because rate environments shift fast. Once you've run a search, the results page shows a table with basic terms: lender, borrower, property type, loan amount, interest rate, term length, LTV, and origination date. Click into any record to see more detail. Some entries include notes about loan structure, whether it was refinanced, if there were buyouts, and occasionally comments on rate type or prepayment terms. The detail level varies wildly depending on the transaction and how much public information was available at origination. Exporting data is straightforward. You can pull results into a CSV or Excel file, which is where most of the actual work happens. I've built spreadsheet models that take exported Scotsman data and normalize the fields across different lenders' naming conventions. One thing the platform doesn't do well is standardize lender names. First National Bank of Commerce and First Natl Bank of Commerce will show up as two separate entries even though they're the same institution. You'll need to clean that up manually unless you've built a lookup table.

A real problem I ran into and how I worked around it

Last year I was looking for refinancing comps on a Class B office building in Phoenix. The property was originally financed in 2019, and I needed to understand what rates and terms lenders were offering on similar refinances in 2023 and 2024. The platform returned maybe six relevant transactions, but three of them had missing rate fields. The platform flags incomplete records sometimes, but not consistently. When a record lacks a rate, it's basically useless for benchmarking. My workaround was to use the borrower name and property address from the incomplete records to pull the original loan documents from county recorder offices. Some counties have digitized records you can search by grantor or grantee. I found the refinancing closing documents on the Maricopa County recorder site, extracted the actual interest rate and terms, and cross-referenced them with the Scotsman entries. It added about 45 minutes of work per missing record, but it filled the gaps. Without that, my comp set would have been too thin to justify the pricing to our credit committee.

Things most people get wrong about this tool

The first mistake is treating every record as equally reliable. Scotsman Guide compiles data from multiple sources, and the quality varies. Public record data is usually accurate for loan amount and LTV, but lender attribution can be off. Sometimes the listed lender is the servicer, not the originator. I had a situation where a major regional bank was credited as the lender on a deal, but the actual originating entity was a smaller community bank that had been acquired two years earlier. For comp purposes this barely matters, but if you're researching who to approach for financing, getting the wrong lender name leads to awkward conversations. The second mistake is assuming the platform captures every transaction. It doesn't. Private lending deals, portfolio loans kept on bank balance sheets, and transactions involving non-disclosure agreements often don't appear at all. If you're underwriting in a niche market or dealing with a highly relationship-driven lender pool, your comp set from Scotsman will systematically underrepresent reality. I've seen this happen with community bank lending in rural markets where relationships drive the entire pipeline. The data is sparse because those loans rarely make it into public reporting channels. A third nuance people miss: the platform's rate data is usually the note rate, not the yield. If a loan has points, buydowns, or mortgage insurance baked in, the effective yield could be a full percentage point higher than what's listed. For quick screening this doesn't matter much. For detailed underwriting comparisons, you need to adjust for those items yourself or the comps will look cheaper than they actually are.

When it breaks down

The platform struggles with newer loan products. Hybrid ARMs, interest-only periods with step resets, and creative amortization schedules don't always map cleanly to the standard fields. I've pulled records where the term length was listed as 30 years but the actual amortization was 25, and the platform had no field to capture that discrepancy. You have to dig into the notes section or pull the original documents to understand the real structure. Another hard limitation is geographic coverage. Major metros and secondary markets are well-represented. Tier-three markets and rural areas have significantly fewer entries. If you're working deals in places like western Montana or the Texas panhandle, expect thin data. The platform covers about 85 percent of the commercial real estate lending market by dollar volume, but that leaves out a lot of transactions that matter for specific niche analyses. For lenders who need comprehensive market intelligence beyond transaction data, some teams supplement Scotsman with Argus Analytics, CoStar, or direct lender outreach through industry associations. Scotsman is good at what it does. It's not a complete solution for every research need.

The subscription cost runs into the five figures annually depending on your tier and seat count. Most small to mid-size firms split a single license among two or three analysts. If you're solo or on a team of one, the cost is manageable. If you're a large firm trying to roll it out across an entire credit department, the per-seat pricing gets expensive fast and the ROI depends heavily on how frequently your team actually uses the platform for live underwriting decisions rather than occasional reference checks.