Find your closings

Use the route you picked. One year per chat. Every route ends with the same file, Closings [YEAR].csv, so the rest of the course works no matter where you started.

Pick your route

You don't need everything connected to start. Pick the option below that best fits. You'll need to do 10–30 minutes of work up front, depending on your route. Then Claude handles years of backlog.

  • Route A — You have a list of your closings. An MLS closed-sales report, a transaction export from your brokerage system (reZEN, SkySlope, Dotloop, Brokermint), or any list of client names. Why it's the best start: the hard part is already done. Your deals are on the list, so Claude only has to find contact info. Least work for you, and the least chance of missing a closing.
  • Route B — You have your settlement statements. Saved on your computer, in Dropbox, or in Google Drive. Claude reads them and pulls the deals out. Why it matters: a settlement statement is proof the deal closed. It has the real closing date, the address, and your clients' names in one place, so there's very little guessing.
  • Route C — You have your contracts saved. Signed purchase agreements on your computer, in Dropbox, or in Google Drive. Claude reads them and pulls the deals out. Why it matters: contracts name your clients and often include their contact info. The catch: they include deals that fell through, and the closing date is the scheduled one. Check Your List sorts that out.
  • Route D — All you have is your email. Claude searches your inbox for closing emails and rebuilds the list from scratch. Why it still works: no files, no reports, no problem. It's the most digging for Claude and the most likely to miss a deal, because closing emails vary and Claude can't open attachments. Check Your List is where you catch what it missed.

Have more than one? Start with the highest one on this list. You'll use the others to check your work in Check Your List.

Route A: You have a list of your closings

Pull your MLS closed-sales report under your agent ID, or a closed-transaction export from your brokerage system. No report? Any list of client names works: an old CRM export, a closing gift list, even names and the year they closed.

Route A prompt
I'm uploading a list of my closed transactions for [YEAR]. You have read access to my [Gmail / Outlook] email.

For each deal on my list, search my email for the client's name and the property address. Confirm my side (listing, buyer, or both), my client's name(s), and the close date. Only record my clients, never the other side.

Add any [YEAR] closing you find in my email that's missing from my list. Flag any deal you can't find in my email.

Give me Closings [YEAR].csv with these columns: Client Name(s), Property Address, City, State, Zip, Side, Close Date, Title Company, Found In. Then tell me how many you confirmed, how many you added, and how many you couldn't find.

Don't worry if you don't have your email connected. Ask Claude to turn your list into one CSV file, Closings [YEAR].csv, with these columns: Client Name(s), Property Address, City, State, Zip, Side, Close Date, Title Company, Found In. In Fill In Contact Info, you'll see how Claude marries your closings to your clients' emails.

Route B: You have your settlement statements

Two ways to hand them over: point Claude to the folder in Dropbox or Google Drive, or upload the PDFs straight into the chat. Uploading works even if nothing is connected. Got a lot of them? Upload a batch at a time.

Settlement statements name both the buyer and the seller. The prompt has Claude find your name to work out your side, record only your clients, and leave the other side out. If it can't tell, it flags the statement instead of guessing.

Route B prompt
My [YEAR] settlement statements are [in my Dropbox / Google Drive folder: FOLDER NAME] [uploaded to this chat]. My name is [YOUR NAME] and my brokerage is [BROKERAGE].

For each statement:
1. Find my name or brokerage to work out my side: listing (I represented the seller), buyer, or both.
2. Record only my client's details: the sellers if I was the listing agent, the buyers if I was the buyer's agent, both if I represented both. Never record the other side's names or contact info.
3. Record my client name(s), the property address, my side, the close date, and the title company. If my client's email or phone appears, add it.

If you can't tell which side I was on, flag the statement instead of guessing.

Give me Closings [YEAR].csv with these columns: Client Name(s), Property Address, City, State, Zip, Side, Close Date, Title Company, Email, Phone, Found In. Tell me how many closings you found and how many you flagged.

Route C: You have your contracts saved

Same two ways to hand them over: point Claude to the folder, or upload the signed purchase agreements into the chat.

One catch: a signed contract doesn't mean the deal closed, and the closing date on a contract is the one that was scheduled. Check Your List checks which deals actually closed and when.

Route C prompt
My [YEAR] signed purchase agreements are [in my Dropbox / Google Drive folder: FOLDER NAME] [uploaded to this chat]. My name is [YOUR NAME] and my brokerage is [BROKERAGE].

For each contract, open only the final signed purchase agreement and any addendum that changes the buyers, sellers, price, or closing date. Don't read every document in the folder.

1. Find my name or brokerage in the agency or agent section to work out my side: listing (I represented the seller), buyer, or both.
2. Record only my client's details: the sellers if I was the listing agent, the buyers if I was the buyer's agent, both if I represented both. Never record the other side's names or contact info.
3. Record my client name(s), the property address, my side, and the scheduled closing date. If my client's email or phone appears, add it.

If you can't tell which side I was on, flag the contract instead of guessing.

Give me Closings [YEAR].csv with these columns: Client Name(s), Property Address, City, State, Zip, Side, Scheduled Close Date, Email, Phone, Found In. Tell me how many contracts you found and how many you flagged.

Route D: All you have is your email

Have settlement statements or contracts saved anywhere? Start with Route B or C instead. Claude can see that an email has an attachment, but not what's inside it, so your documents are the better source.

Give Claude as much as you can. Every name below makes the search sharper.

Route D prompt
You have read access to my [Gmail / Outlook] email. I'm a real estate agent and I want to rebuild a list of every transaction I closed in [YEAR]. My name is [YOUR NAME].

Search my email from January 1 to December 31, [YEAR] for emails that signal a closed deal: closing disclosures, settlement or ALTA statements, "recorded," "funded," "closed," escrow emails from title companies, and commission disbursement emails from my brokerage.

My title/escrow companies: [LIST]
My escrow officers: [NAMES]
My brokerage: [BROKERAGE]
My TC: [NAME AND EMAIL]
Folders or labels where I file closings: [NAMES, OR "none"]

Run several searches and page through every result. Same address and close date = one deal.

For each deal, work out my side (listing, buyer, or both) and record only my clients. Escrow emails name both sides. Never record the other side's names or contact info.

You can see that an email has an attachment, but not what's inside it. If a deal's details are only in an attachment, record what the email itself says and flag that deal.

Give me Closings [YEAR].csv with these columns: Client Name(s), Property Address, City, State, Zip, Side, Close Date, Title Company, Found In. Tell me how many closings you found, and mark anything you're unsure about. Don't guess.

Lots of flagged deals? The details are probably in PDFs attached to your emails. Download those closing statements, then upload them or save them to a Drive or Dropbox folder and run Route B.

Up next: Check Your List.