Tools

How to track unrecorded liens in a spreadsheet for follow-up

Unrecorded liens can blindside your deal if not properly identified and tracked, jeopardizing your closing. Using a dedicated spreadsheet helps you manage these potential title issues and ensures you follow up diligently on their resolution.

October 28, 2026 · 3 min read

What an unrecorded lien means for your deal

An unrecorded lien is a claim against a property that has not been filed with the county recorder’s office. This could be an old mechanic's lien, a municipal lien for code violations, or even an equitable lien from an unfulfilled contract. They are dangerous because a standard title search might not immediately reveal them.

If an unrecorded lien surfaces late in the process, it can delay or kill your deal, forcing you to renegotiate or walk away. You take title subject to all valid claims, recorded or not, so clearing them is crucial for a clean acquisition.

Setting up your lien tracking spreadsheet

A simple spreadsheet can be your best friend here. Create columns for essential information. Start with a unique identifier for the property (e.g., address), then add columns for the suspected lien type, the alleged claimant, the approximate amount, and the date it was identified.

Crucially, include columns for 'Status' (e.g., Investigating, Contacting Claimant, Negotiating, Released), 'Next Step', 'Responsible Party', and 'Follow-up Date'. This structure provides a clear, actionable overview of each potential lien and its progress. For wholesalers, keeping track of every detail is key to a smooth closing: /for/wholesalers.

Data points to include for each lien

Beyond the basics, gather as much detail as possible. If it is a municipal lien, note the specific code violation and the city department. For a mechanic's lien, record the contractor's name and contact information, and the dates services were performed.

Document any communications, including dates, names, and summaries of conversations. Attach any relevant documents, such as copies of invoices, emails, or municipal notices, to your property file and reference them in the spreadsheet. This creates a comprehensive record for future reference and problem-solving.

Integrating lien follow-up into your workflow

Regularly review your lien tracking spreadsheet, perhaps daily or several times a week, as part of your lead management routine. Filter by 'Follow-up Date' to prioritize actions. Set reminders in your calendar or task management system based on these dates.

The 'Next Step' column should be specific: 'Call city planning on Tuesday,' 'Email claimant for payoff letter,' 'Confirm release with title company.' This systematic approach prevents items from falling through the cracks. Knowing what a skip trace returns can help you find contact info for claimants if necessary: /learn/what-a-skip-trace-actually-returns.

Collaborating with title on lien resolution

As soon as a potential unrecorded lien is identified, bring it to the attention of your title company or attorney. They are your experts in clearing title. Provide them with all the information you have gathered in your spreadsheet. They can often uncover details you might miss and negotiate releases.

Maintain open communication with them, updating your spreadsheet as you receive new information. Your diligent tracking supports their efforts, ensuring a cleaner closing. This is not legal advice, and you should always consult with a qualified attorney or title professional for specific lien resolution.

Questions people ask

Are all liens recorded?

No, not all liens are recorded. Some, like certain municipal liens for code violations or equitable liens, might not appear in public records immediately. This is why careful due diligence is critical.

How do I find unrecorded liens?

Finding unrecorded liens involves deeper digging beyond a standard title search. This includes checking municipal records for code violations, open permits, or unpaid utility bills. Talking to the seller and neighbors can sometimes reveal clues.

Who is responsible for clearing unrecorded liens?

Ultimately, the seller is responsible for conveying clear title. However, as the buyer, it is in your best interest to identify and ensure resolution of any liens, recorded or unrecorded, before closing. You may need to negotiate who handles the costs of clearing them.