How to Run a Mortgage Note Sales Auction

Why Should a Mortgage Note Matchmaker Learn to Run Auctions?

If you have been brokering mortgage notes for any length of time, you know that sellers are harder to find than buyers -- and far more valuable to keep. Buyers are abundant. Sellers are the ones with the portfolios, the recurring deal flow, and the opportunity for you to build a long-term consulting relationship. The more value you create for a seller, the more indispensable you become.

Running a structured sales auction is one of the highest-value services you can offer. It transforms you from someone who simply introduces buyers and sellers into a full-service portfolio manager who maximizes sale proceeds, minimizes logistics, and keeps every counterparty informed throughout the process. This is the difference between earning a referral fee and earning a consulting retainer.

At U.S. Mortgage Resolution, I have refined this process across dozens of offerings. The workflow I am going to walk through is built around a specific spreadsheet tool -- the Sales Auction Reviewer -- that turns a chaotic pile of buyer bids into a clear, sortable, filterable decision matrix. Whether you are managing 22 loans with 18 buyers and 79 individual offers, or a smaller portfolio with a handful of bidders, the process scales.

How Do You Organize Bids from Multiple Buyers?

The first challenge in any auction is getting the data into a usable format. When an offering closes, you will have bids arriving from multiple buyers in different formats -- emails, spreadsheets, phone calls. Your job is to normalize all of that into a single structured dataset.

Here is the workflow:

Step one: Log every offer into your CRM. Whether you use a purpose-built platform or a spreadsheet, every bid needs to be captured with the buyer name, the loan identifier, and the offer amount. If you have an assistant, this is an ideal task to delegate. Accuracy matters more than speed at this stage.

Step two: Export and pivot. Once all offers are logged, export the data and run a pivot table. Place the loan number in the rows and the buyer names in the columns, with the offer amounts as the values. This transforms a long list of 79 individual offers with duplicate loan entries into a compact grid -- one row per asset, one column per buyer. This pivot is the foundation of everything that follows.

Step three: Transfer to the Sales Auction Reviewer. Copy the pivoted data into your review spreadsheet, aligning the loan numbers and buyer columns. Now you have a single view of every offer on every asset, ready for analysis.

Understanding how to use pivot tables is essential here. Without that skill, you are stuck scrolling through rows of duplicated data trying to mentally compare bids. With it, you convert raw CRM exports into a decision-ready format in minutes.

What Formulas Make the Auction Reviewer Work?

The Sales Auction Reviewer is not complicated, but it is powerful. A handful of formulas turn a static grid of numbers into a dynamic analytical tool.

Offer Count

A simple COUNTA formula across each row tells you how many buyers submitted bids on each asset. This is your first signal of demand. In a recent offering, one loan attracted 14 separate bids while others received only one or two. Adding conditional formatting -- green for high competition, red for low -- gives you an instant visual map of which assets are hot and which are struggling to find buyers.

Best Offer

A MAX formula across each row identifies the highest bid on every loan. Once you have the best offer calculated for all assets, a SUBTOTAL formula at the bottom gives you the total potential proceeds. In the example offering, best offers totaled $349,000 across 22 loans.

Why SUBTOTAL instead of SUM? Because SUBTOTAL respects filters. When you filter the spreadsheet to view a specific buyer or a subset of loans, the total updates dynamically. A SUM formula would continue adding filtered-out rows, giving you an inaccurate picture.

Average and Third Quartile

An AVERAGE formula across the same dataset shows you the mean offer level -- $216,000 in this case. The third quartile (using a PERCENTILE or QUARTILE formula) gives you a view of the upper range of bidding activity without being pulled to the extreme by a single outlier. Together, these metrics help you gauge how competitive the bidding was across the portfolio.

Top Bidder (Index Match)

This is the most valuable formula in the entire spreadsheet. An INDEX MATCH combination does the following:

• INDEX references the row of buyer names
• MATCH finds the position of the best offer within each buyer's column of bids
• The result: the name of the buyer who submitted the highest bid on each loan, populated automatically

With this formula in place, you can filter the spreadsheet by any buyer and instantly see every loan they won. Filter on Buyer 7, for example, and you might see they hold the high bid on 10 loans totaling $182,000. Filter on Buyer 3, and you see a different subset. This is the analytical power that allows you to make strategic decisions about how to allocate the portfolio.

Offer as Percentage of UPB

Dividing each best offer by the loan's unpaid principal balance gives you a quick read on relative value. If a bid comes in at 1% of UPB, that asset might not be worth the seller's time and legal expense to liquidate. This column helps you identify loans to kick out of the auction entirely and advise your seller accordingly.

How Do You Decide Which Buyer Gets Each Loan?

Once the formulas are in place, the real work begins: awarding loans to buyers. Add two columns to your spreadsheet -- Awarded Buyer and Contract Price -- and start making allocation decisions.

The straightforward approach is to award every loan to its highest bidder. But the straightforward approach is not always the best approach. Here is why.

Consolidating Contracts Creates Value

If Buyer 7 holds the high bid on 10 loans but Buyer 3 holds the high bid on 3 loans that are close in price to Buyer 7's offers, you have a decision to make. Awarding all 13 loans to Buyer 7 (assuming they match the competing offers) means your seller executes one contract instead of two. That reduces the logistics of collateral file transfers, servicing transfers, and post-sale coordination. Fewer contracts means less administrative burden, faster closings, and lower transaction costs for everyone involved.

To evaluate this, filter the spreadsheet to show all loans where Buyer 7 submitted an offer. Remove the blanks and compare their bids to the best offers on each loan. If they are close -- within a reasonable margin -- you can approach Buyer 7 with the opportunity to match or exceed the competing bids in exchange for a larger portfolio. Buyers often agree because a larger acquisition justifies their own due diligence costs and gives them better diversification.

When Consolidation Does Not Make Sense

In the most recent offering I managed, we awarded loans to seven different buyers even though we could have consolidated into fewer contracts. Why? Because building relationships with multiple buyers keeps them engaged and competing in future auctions. A buyer who wins one or two loans today becomes a repeat bidder tomorrow. If you funnel everything to one or two large buyers, the rest of your buyer list goes cold.

This is a strategic conversation to have with your seller before you start making awards. I called my seller immediately after receiving all bids and laid out the options: we can maximize price by consolidating contracts, or we can spread the awards across more buyers to build long-term competitive pressure. The seller agreed to execute all seven contracts. That is the kind of consultative decision-making that elevates you from broker to portfolio manager.

What Happens After You Award the Loans?

Post-auction communication is where most matchmakers drop the ball. The auction does not end when you award the loans -- it ends when every buyer, whether they won or lost, has been informed and knows what to do next.

Communicate with Non-Winning Buyers First

Identify every buyer who did not win any assets. In the example offering, Buyers 1, 9, 10, 11, 12, 15, 16, 17, and 18 all walked away empty-handed. Each one of those buyers invested time reviewing the tape, conducting due diligence, and submitting offers. They deserve transparency.

For each non-winning buyer, prepare a simple summary: their bids alongside the winning bids on the same assets. Hide all other buyer columns -- they do not need to see the full competitive landscape -- and send them a clean view showing:

• The loans they bid on
• Their offer amounts
• The best offer on each loan
• How far off they were

This transparency accomplishes three things. First, it respects the buyer's time and effort. Second, it teaches them how to bid more competitively next time. Third, it keeps them engaged for the next offering. A buyer who knows they lost by $5,000 on a specific asset will sharpen their pencil next round. A buyer who never hears back will stop bidding entirely.

Work with Winning Buyers from Largest to Smallest

Start with the buyer who was awarded the most loans and work your way down. Give each winning buyer the opportunity to confirm their awards and move forward with a contract. If they choose to proceed, advance them into the next phase: finalizing the loan purchase sale agreement, conducting any remaining due diligence, and coordinating the closing.

Starting with the largest buyer first protects you if something falls through. If Buyer 7 backs out of their 10-loan package, you need time to reallocate those assets -- potentially to the second-highest bidders you identified earlier. Working top-down gives you that cushion.

How Do You Negotiate When Bids Are Close?

The most interesting auction dynamics happen when bids are clustered. If the best offer on a loan is $59,000 and the next highest is $45,000, the decision is clear. But when the gap narrows to a few thousand dollars, you have leverage to negotiate.

Consider a buyer who submitted the highest bid on only one loan -- the hot asset with 14 competing bids -- at $59,000. That buyer clearly wants to deploy capital, and they were willing to pay a premium for the most competitive asset in the pool. If they also submitted offers on other loans where they were not the highest bidder but were close, you can structure a package deal: award them the $59,000 asset contingent on their also taking two or three additional loans at matching or improved prices.

This benefits everyone:

• The buyer gets a diversified portfolio instead of a single asset
• The seller moves more inventory through fewer contracts
• You earn a larger commission and deepen the relationship with both parties

The key is never to shop bids -- do not reveal Buyer A's specific number to Buyer B. Instead, offer the opportunity to match or exceed the competing offer. This preserves the integrity of your auction process and your reputation as an honest broker.

What Tools Support This Process?

The Sales Auction Reviewer spreadsheet is the centerpiece, but the broader workflow relies on a few supporting tools:

The CRM is where the process starts. Every offer goes in, tagged to the buyer and the asset. The pivot table is the bridge between raw data and analysis. The Sales Auction Reviewer is where decisions get made. And standardized email templates ensure that your post-auction communication is consistent, professional, and fast.

Why Is This a Consulting-Level Skill?

Running a bulk sale auction is not something most note sellers do well on their own. They know their assets. They know their target prices. But managing the logistics of collecting bids from a dozen or more buyers, analyzing the results, negotiating allocations, and coordinating multiple closings simultaneously is a specialized skill set.

When you demonstrate that you can run this process smoothly, you become more than a matchmaker. You become a trade desk. Sellers start sending you their portfolios not because you found them a buyer once, but because you manage the entire disposition process from listing to closing. That is the foundation of a consulting and portfolio management relationship -- recurring revenue, deeper trust, and a competitive moat that is difficult for other brokers to replicate.

The skills that got you here -- sourcing buyers and sellers, organizing data, conducting due diligence -- are the prerequisites. The auction management process is the capstone that ties them all together into a full-service offering your sellers cannot get anywhere else.

The Bottom Line

Running a mortgage note sales auction is a structured, repeatable process that creates outsized value for your sellers and differentiates you from every other broker in the market. The core workflow is straightforward: collect bids into a CRM, pivot the data into a one-row-per-asset format, apply a handful of formulas to identify top bidders and total proceeds, and then make strategic allocation decisions that balance maximum price against logistical efficiency.

The real edge is not in the spreadsheet. It is in the communication. Buyers who lose need to know why and by how much. Buyers who win need a clear path to closing. Sellers need a trusted advisor who can present options and execute on the chosen strategy. When you deliver on all three, you are no longer brokering individual transactions. You are managing a portfolio -- and that is where the business scales.