Optimizing Document Templates

Optimizing Document Templates

Jason Cochard for Land Academy

In programming, there’s a phrase “Don’t Repeat Yourself,” which has an acronym DRY. One of the goals with writing code is to never repeat yourself. Never write the same piece of functionality twice; instead, break that piece into a reusable component, and just call the component when you need it.

With what we do, there are some documents that are very similar, comprised of templated boilerplate mixed in with specific pieces of information from a data set, which can get boring to write if you’re doing them by hand every time (obviously, that’s why we mail merge our offers, right?). But more than just offer letters, I’m realizing that sales letters, purchase agreements, land contracts, deeds, affidavits, etc, are all great candidates to save time by staying DRY.

What I do is use a mail merge to mark up my documents with variable names that have their counterpart in a spreadsheet. That same spreadsheet is derived from the downloaded data (in most cases), and therefore I’m not repeating myself at all, just handing off information from the downloaded data and allowing it to filter down into my document, be it a deed, a purchase agreement, or a required document for a new state.

The key is, anytime you write something specific, think about the reusable components that go in to that wording, see if you can split it into language that would allow you to create one or two variables that can be changed when you find yourself doing a slightly different deal. Below is a portion of my variable set. On the left is the name that is used in the document template, on the right is the data. I color code the cells so that I know blue is what I modify, and orange is derived from the choices in blue. I do this using Named Ranges, Data Validation, and the “vlookup” function in Google Sheets, which I’m not going to explain here (GTS). I have over 200 variables in the list, but here is a portion of them:

One good candidate for staying DRY is in a purchase contract, where you’re defining who will pay for title insurance. On a lot of our letters, we telegraph this intent by saying we’ll pay the fees associated with the transaction, yet in most states the seller traditionally pays for title insurance. Based on your conversations with the seller, you may have gotten them to stick to paying for the policy, maybe you are paying, or maybe you’re splitting it down the middle. Here’s the sentence in my contract that governs the title insurance payer: “The *|title-insurance-payer|* shall *|title-insurance-verb|* the cost of the owner’s policy of title insurance.” What I’ve done is put 2 variables into the sentence, and it will modify the language elegantly.

Using the techniques above (which is beyond the scope here), I’ve created a 2 dimensional lookup for what the language should be, and all I need to do is choose it in a dropdown menu in the data entry portion of my spreadsheet. These dropdown are in my blue-shaded cells. The orange is automatically derived from my blue choice.

If I choose “Buyer” or “Seller” for the title-insurance-payer variable, then the title-insurance-verb will automatically be “pay”, but if I choose “Buyer and Seller” then the verb would be “split”.

By dissecting often-modified sentences like this and abstracting key words out into a few variables, you can turn your purchase contracts into a piece of custom software and avoid repeating yourself or changing the same sentence again and again.

Even though it’ll take time to set up the document to merge, it’ll save you time in the long run by preventing you from needing to go back through all your old documents on subsequent, similar deals. You can create a suite of documents that differ by deal type, for example. One set for dealing with sellers with one grantor and a separate one for sellers with multiple grantors. Use the same variable names across all the documents so you can merge data from a single spreadsheet.

What’s cool is the spreadsheet can be a master spreadsheet, having all the variables for all the deal types, so you only have one place to enter data, and several documents compatible with the variable names you’ve defined in the spreadsheet. Any given document will only use a subset of those variables. With this same data entry spreadsheet template re-used for any given deal, I can merge acquisition agreements, sales agreements, land contracts, lease agreements, deeds, affidavits, and any other document I want.

By the way, if anyone wants to buy the APN in that image above, I will sell it for $7k uninsured. But, there is currently a squatter living there who kinda seems locked and loaded.

Leave a Reply

Your email address will not be published. Required fields are marked *

No need to hire staff - we did it for you.

Land Academy PRO is the brainchild of founders Steven Jack Butala and Jill DeWit. Designed at the request of Land Academy members who are ready for a higher level, we’re excited to continue to provide the tools and support needed by professional investors.

Each level comes with a preset amount of included data, Concierge Mail service, and postage. For example, the Green level includes 6,000 units of completed-for-you mail completely out the door at no extra cost to you.

All levels include a PatLive introduction and preset script (we will set up your phone answering for you), use of Land Academy’s personal Transaction Team to manage your deal flow, an AirTable (CRM) base setup managed by our (and your!) Transaction Coordinator, personal consulting, regular office hours, and includes your Land Academy subscription cost.

If you’re making this a business, Land Academy PRO takes the work off of your plate so you can focus on the things that matter – like running your business.

Green

$10,060

per Month

Silver

$14,590

per Month

Gold

$19,120

per Month

Platinum

$23,650

per Month

Black

$28,180

per Month

Concierge Data+ (with data) Included mailers each month (data + concierge + mailer + postage). Our team will do your data for it and get it out the door.
6,000 mailers 9,000 mailers 12,000 mailers 15,000 mailers 18,000 mailers
PatLive introduction at no cost We will help you establish your first script and get PatLive set up on your behalf to answer your phones.
$500 value $500 value $500 value $500 value $500 value
Transaction Coordinator Use of our personal Transaction Coordinator team to manage your deals. Trained and ready to go!
$7,500 value $7,500 value $7,500 value $7,500 value $7,500 value
AirTable Ready-for-you CRM managed by your personal Land Academy Pro Transaction Coordinator
$100 value $100 value $100 value $100 value $100 value
Personal Consulting 1 on 1 personal consulting with our Transaction Coordinator each week.
- - $1,000 value $1,000 value $1,000 value
Regular Office Hours Regular office hours with Jack and Jill + our staff. Private for LA Pro Members Only. (Think Career Path Office Hours)
$2,500 value $2,500 value $2,500 value $2,500 value $2,500 value
ParcelFact ParcelFact is included in your LA Pro membership with unlimited pulls.
$150 value $150 value $150 value $150 value $150 value
FREE Career Path Access
$23,000 value $23,000 value $23,000 value $23,000 value $23,000 value
Land Academy No more separate charges - Land Academy is included with LA Pro Membership. This includes all education, tools, support, and future releases.
$300 value $300 value $300 value $300 value $300 value
Subtotal: $8,550 value $8,550 value $9,550 value $12,050 value $12,050 value
Mail Value: $7,500 value $11,250 value $15,000 value $18,750 value $22,500 value
Total Value: $39,050 $42,800 $47,550 $53,800 $57,550
Apply Now Apply Now Apply Now Apply Now Apply Now

Green

$10,060

per Month

Concierge Data+ (with data) Included mailers each month (data + concierge + mailer + postage). Our team will do your data for it and get it out the door.
6,000 mailers
PatLive introduction at no cost We will help you establish your first script and get PatLive set up on your behalf to answer your phones.
$500 value
Transaction Coordinator Use of our personal Transaction Coordinator team to manage your deals. Trained and ready to go!
$7,500 value
AirTable Ready-for-you CRM managed by your personal Land Academy Pro Transaction Coordinator
$100 value
Personal Consulting 1 on 1 personal consulting with our Transaction Coordinator each week.
-
Regular Office Hours Regular office hours with Jack and Jill + our staff. Private for LA Pro Members Only. (Think Career Path Office Hours)
$2,500 value
ParcelFact ParcelFact is included in your LA Pro membership with unlimited pulls.
$150 value
FREE Career Path Access
$23,000 value
Land Academy No more separate charges - Land Academy is included with LA Pro Membership. This includes all education, tools, support, and future releases.
$300 value
Subtotal: $8,550 value
Mail Value: $7,500 value
Total Value: $39,050
Apply Now

Silver

$14,590

per Month

Concierge Data+ (with data) Included mailers each month (data + concierge + mailer + postage). Our team will do your data for it and get it out the door.
9,000 mailers
PatLive introduction at no cost We will help you establish your first script and get PatLive set up on your behalf to answer your phones.
$500 value
Transaction Coordinator Use of our personal Transaction Coordinator team to manage your deals. Trained and ready to go!
$7,500 value
AirTable Ready-for-you CRM managed by your personal Land Academy Pro Transaction Coordinator
$100 value
Personal Consulting 1 on 1 personal consulting with our Transaction Coordinator each week.
-
Regular Office Hours Regular office hours with Jack and Jill + our staff. Private for LA Pro Members Only. (Think Career Path Office Hours)
$2,500 value
ParcelFact ParcelFact is included in your LA Pro membership with unlimited pulls.
$150 value
FREE Career Path Access
$23,000 value
Land Academy No more separate charges - Land Academy is included with LA Pro Membership. This includes all education, tools, support, and future releases.
$300 value
Subtotal: $8,550 value
Mail Value: $11,250 value
Total Value: $42,800
Apply Now

Gold

$19,120

per Month

Concierge Data+ (with data) Included mailers each month (data + concierge + mailer + postage). Our team will do your data for it and get it out the door.
12,000 mailers
PatLive introduction at no cost We will help you establish your first script and get PatLive set up on your behalf to answer your phones.
$500 value
Transaction Coordinator Use of our personal Transaction Coordinator team to manage your deals. Trained and ready to go!
$7,500 value
AirTable Ready-for-you CRM managed by your personal Land Academy Pro Transaction Coordinator
$100 value
Personal Consulting 1 on 1 personal consulting with our Transaction Coordinator each week.
$1,000 value
Regular Office Hours Regular office hours with Jack and Jill + our staff. Private for LA Pro Members Only. (Think Career Path Office Hours)
$2,500 value
ParcelFact ParcelFact is included in your LA Pro membership with unlimited pulls.
$150 value
FREE Career Path Access
$23,000 value
Land Academy No more separate charges - Land Academy is included with LA Pro Membership. This includes all education, tools, support, and future releases.
$300 value
Subtotal: $9,550 value
Mail Value: $15,000 value
Total Value: $47,550
Apply Now

Platinum

$23,650

per Month

Concierge Data+ (with data) Included mailers each month (data + concierge + mailer + postage). Our team will do your data for it and get it out the door.
15,000 mailers
PatLive introduction at no cost We will help you establish your first script and get PatLive set up on your behalf to answer your phones.
$500 value
Transaction Coordinator Use of our personal Transaction Coordinator team to manage your deals. Trained and ready to go!
$7,500 value
AirTable Ready-for-you CRM managed by your personal Land Academy Pro Transaction Coordinator
$100 value
Personal Consulting 1 on 1 personal consulting with our Transaction Coordinator each week.
$1,000 value
Regular Office Hours Regular office hours with Jack and Jill + our staff. Private for LA Pro Members Only. (Think Career Path Office Hours)
$2,500 value
ParcelFact ParcelFact is included in your LA Pro membership with unlimited pulls.
$150 value
FREE Career Path Access
$23,000 value
Land Academy No more separate charges - Land Academy is included with LA Pro Membership. This includes all education, tools, support, and future releases.
$300 value
Subtotal: $12,050 value
Mail Value: $18,750 value
Total Value: $53,800
Apply Now

Black

$28,180

per Month

Concierge Data+ (with data) Included mailers each month (data + concierge + mailer + postage). Our team will do your data for it and get it out the door.
18,000 mailers
PatLive introduction at no cost We will help you establish your first script and get PatLive set up on your behalf to answer your phones.
$500 value
Transaction Coordinator Use of our personal Transaction Coordinator team to manage your deals. Trained and ready to go!
$7,500 value
AirTable Ready-for-you CRM managed by your personal Land Academy Pro Transaction Coordinator
$100 value
Personal Consulting 1 on 1 personal consulting with our Transaction Coordinator each week.
$1,000 value
Regular Office Hours Regular office hours with Jack and Jill + our staff. Private for LA Pro Members Only. (Think Career Path Office Hours)
$2,500 value
ParcelFact ParcelFact is included in your LA Pro membership with unlimited pulls.
$150 value
FREE Career Path Access
$23,000 value
Land Academy No more separate charges - Land Academy is included with LA Pro Membership. This includes all education, tools, support, and future releases.
$300 value
Subtotal: $12,050 value
Mail Value: $22,500 value
Total Value: $57,550
Apply Now

Disclaimer: *We have a monthly “use it or lose it” policy with mail and data – Land Academy PRO is designed to keep you on-track and consistent.

To cancel, all packages require a 30 day notice to move you back down to regular Land Academy membership.

Office Hours Schedule

Scheduling a Career Path interview call is currently on hold and will resume closer to Fall 2024 as we approach Career Path 10.

FREE eBook

You Are Not Alone in Your Real Estate Ambition.

eBook redesign 2023 1 webp

Copyright © 2024 All Rights Reserved.

 

*eBook will automatically be delivered to your inbox. If you do not see it, please check your Spam/Junk Folder.