Tool & guide

How to Choose DST Sponsor: Financial-Statement Entity Matcher

By Sequoia ResearchPublished Read as Markdown

Financial-Statement Entity Matcher

Users record statement entities, dates, auditors, relevant obligations, and corporate relationships. The tool flags questions that are being answered with statements from a different entity or reporting period.

For an export, select Download in the tool, then Save file when it appears below. Your entries stay in your browser.

What Is This Article About?

This tool helps you connect a financial statement to the exact company and period named in a Delaware statutory trust (DST) sponsor question. You enter the entities, source records, questions, and later source selections yourself. The comparison flags mismatched names, dates, and reporting scope while keeping earlier selections in the record. An aligned label does not show that a statement is reliable or that the sponsor can meet an obligation.

Table of Contents

Why the Entity Behind a Financial Statement Matters

A sponsor brand may appear on several records. The company that owns the brand may differ from the company that owes a payment. A statement for one company does not answer every question about the other. Start by linking the question to the named party before using its figures.

Suppose a reply cites a parent company's cash balance. Your question concerns a support duty assigned to an affiliate. Even if the two names share a familiar brand, there is still a gap. You need to know which entity owns the cash and what permits its use for that duty. The tool marks the difference in entered entity labels. It does not decide whether funds can move between them.

This is one small part of sponsor due diligence. The Financial Industry Regulatory Authority (FINRA) explains that covered firms should examine material claims and primary records. Its guidance also addresses the limits of relying on outside reports. This manual tool does not carry out those duties or certify that a file meets them. FINRA Notice 23-08

Treat a match as the start of reading the relevant financial record. A neatly organized board can still contain the wrong source, a mistaken name, or an unclear reporting scope. The person entering the record remains responsible for checking those details against the actual documents.

Set the Sponsor Review Subject and Cutoff

Give the board one clear subject. For example, use an offering name, the support duty under review, and the named obligor. An obligor is the party that owes the duty. Avoid a broad title such as “all sponsor finances” if the questions concern just one support agreement.

Enter a cutoff date that is today in Coordinated Universal Time (UTC) or earlier. This is the last date included in the board. It is not a statement that all relevant events through that date have been found. The app checks calendar dates, not times of day or legal deadlines.

The first saved entity locks the subject and cutoff. Later entries use that same scope. To correct the scope or use a later cutoff, export the current board and start another. The new board has no inherited sources or conclusions. Keep the exported files together if they form successive stages of one review.

Choose a cutoff that fits your work. A historical review may be useful when you need to show what a file contained at a past stage. Calling that review historical does not make a later source part of the earlier record. The date checks prevent you from adding a source read after the board's cutoff.

Enter each relevant company as a separate entity. Use its exact name as shown in the source you are reviewing. The app gives each saved entity an ID, such as E1 or E2. Questions and statements then refer to those IDs.

You can add a note about the claimed relationship. “Parent named on group chart” is more useful than “same sponsor.” Include a source locator in the note when it helps trace the claim. The note records your description; the app does not prove ownership, control, or a duty to provide support.

The app rejects duplicate names after ignoring letter case and extra spaces. This prevents simple duplicate entries. It does not detect former names, legal aliases, or companies that happen to use similar names. Do not merge them merely because a search result suggests a link.

Saved entities cannot be renamed. If a correction changes the identity, add the correct entity and new records that point to it. Retire the old question if it no longer belongs in the active review. This keeps an earlier source from becoming evidence for a newly named company by accident.

Use short, nonsensitive notes. The board is designed to hold references, not complete statements, tax IDs, account numbers, signatures, or personal financial details. Keep the original documents in the records system you normally use.

Enter Statement Scope, Dates, and Source Details

Create one record for each statement version you intend to use. Select its entered entity, then record the source, version, and page. Add a plain description of the statement type. Do not label a whole packet a balance sheet if only one page provides that information.

Choose the reporting scope separately. The options are Entity-only, Group or consolidated, and Unknown. Group or consolidated means you entered a record that reports a wider set of entities together. Those records always produce a scope-review flag when assigned to a question. They are not treated as stand-alone resources of the named company.

The U.S. Securities and Exchange Commission (SEC) describes a balance sheet as a snapshot. Income and cash-flow statements cover a period of time. This difference is why the tool asks you to choose the date type instead of comparing one unlabeled date. SEC financial-statement guide, January 2014

For a snapshot, enter one as-of date and leave the start blank. For a period, enter both the start and end dates. For an unknown period, leave both dates blank. Do not fill an unknown field with the date you downloaded the file. Those dates answer different questions.

You must enter when you read the source. Its issue date is optional. A known period end cannot follow the read date or a supplied issue date. The issue date cannot follow the read date, and the read date cannot follow the cutoff. These checks suit reported statements; the tool does not accept future projections as if they were completed financial periods.

An optional accountant or auditor description can preserve what the document says. A name in this box does not verify a license, audit opinion, engagement scope, or independence. Record uncertainty directly. If you have only a management-prepared statement, do not turn an unanswered audit question into an affirmative label.

Write a Question With an Exact Financial Period

A useful question identifies the party, the duty, and the information needed. “Does this statement show the resources of the company named in section 4 of the support agreement?” is a narrower task than “Is the sponsor strong?” Put the related decision in the next field.

Choose the requested entity and the needed date type. Questions require an exact snapshot date or period. Unlike a source record, a question cannot have an unknown target period. If you do not yet know what period matters, resolve that request before using the tool to compare dates.

For example, a December 31 balance sheet and an income statement for the year ended December 31 have the same ending date. They do not describe the same kind of financial information. The app flags the different date types. It does not infer that either record answers the other request.

The question-recorded date is when you added that request to your review. It is not proof that someone received an email or accepted the task. No message is sent. Keep any actual correspondence outside the tool and use the source references to connect it when needed.

Questions are fixed after saving. Correct a question by creating a new one. A narrower decision, different legal party, or different year should not silently reuse the earlier source selection. The old question and its assignment history remain available for export.

Read the Financial-Statement Matching Flags

After saving a question, select a statement and add an assignment review date and reason. Each assignment is a new record. Click Review saved board to prepare the current comparison. The following flags describe the entered metadata:

Flag What the app found What to check next
No statement selected No source is assigned to an active question. Find the requested record or document the gap elsewhere.
Entity labels differ The saved entity IDs do not match. Trace the named party and any claimed support link.
Reporting scope needs review The source scope is group, consolidated, or unknown. Determine what the source includes and which resources belong to the target.
Statement period unknown The source has no entered period. Read the statement and locate its date labels.
Period types differ One record is a snapshot and the other a period. Obtain the kind of financial information requested.
Exact dates differ Known types match, but the dates do not. Explain the difference or find the requested period.

A question can have several flags. A parent statement for the wrong year can trigger both an entity and a date flag. Counts therefore overlap. Adding the individual flag counts does not always produce the number of flagged questions.

When none of these flags applies, the result says “Entered labels align; answer not verified.” It does not say approved, complete, solvent, or guaranteed. No financial ratios, credit grades, or sponsor rankings are calculated.

Work Through the North Vale Example

Load the fictional example to see four different comparisons. The board concerns an invented Alder Bend review. North Vale Holdings LLC is the parent in the example. North Vale Support LLC is the affiliate named in the questions. No real company, financial statement, or support contract is being evaluated.

All four questions request the affiliate's December 31, 2025 snapshot. The four selected sources differ in one important field:

Question Selected source Current result
Q1 Parent's December 31, 2025 snapshot Entity labels differ
Q2 Affiliate label, but group reporting scope Reporting scope needs review
Q3 Affiliate's December 31, 2024 snapshot Exact dates differ
Q4 Affiliate's December 31, 2025 entity-only snapshot Entered labels align; answer not verified

The summary has two entities, four statements, four questions, and four assignments. One question has aligned labels and three have flags. These are counts of entered comparisons. They do not mean that one-quarter of the sponsor's financial strength has been verified.

Now assign source S4 to Q1 with a fresh reason and review date. There are still four questions and four source records, but five assignments. Two current questions now have aligned labels and two have flags. Q1's first assignment remains in the history. No parent record was deleted or relabeled as the affiliate's statement.

This is also why source counts and question counts differ. One statement may be selected for more than one question. That use does not create a second independent financial record or make the answers independent of each other.

Change a Source Without Losing Earlier Evidence

Add a new statement record when you receive a correction. Use a distinct version reference and explain what changed. Then append a new assignment to each question that should use it. Adding the new source alone does not replace every earlier selection.

An assignment review date cannot precede the question-recorded date, the selected source's read date, or that question's prior assignment date. Equal dates are allowed. The tool records order within a day through saved assignment IDs, not through invented timestamps.

To retire a question, choose Retire question, leave the statement selection blank, and explain the reason. Its earlier selections stay in history. A retired question is excluded from active matching counts, but it has not been marked answered. To restore it, append another Select statement assignment.

Changing the selected question clears the unsaved assignment fields. This prevents a source choice and explanation from following you to a different question. Canceling a form removes only those unsaved inputs. Starting a new board or loading the example requires confirmation because those actions replace all work in the open page.

Use Exports and Keep the Original Files

Save or cancel pending inputs before reviewing. Every change disables prepared exports until the board is reviewed again. This keeps the download from silently representing a mix of saved records and unfinished form entries.

The display filter lets you focus on flagged, aligned, or retired questions. Both downloads still contain every entity, source, question, assignment, and limitation. JSON keeps the structured fields; the text file provides a readable record of the same full board. Neither file contains the underlying documents unless you improperly paste their content into notes.

The limits are 12 entities, 30 statements, 20 questions, and 80 assignments. Retired questions still count toward the question limit. There is also a saved-data limit of 180,000 UTF-8 bytes and an export limit of 500,000 bytes. Multibyte characters use more space than plain English letters. Keep references concise and export before a long review reaches its limits.

The tool has no account, upload, import, storage, or reminder service. Closing or reloading the page can lose the current board. Save needed exports while the board is open. The tool cannot later restore a downloaded file into its forms.

What to Ask After the Labels Match

Read the actual statement and its notes next. Which assets are restricted? What debts, commitments, or other claims compete for the same cash? Which amounts belong to another entity? Those questions require financial and legal analysis beyond this comparison.

A named auditor does not answer those questions by itself. Check what report was supplied, the period covered, and the scope of any opinion. If you need a statement for a different company, ask for it rather than treating a familiar group name as enough.

Private placements can have limited disclosure and little liquidity. Organizing a few statements does not remove those risks. The SEC's current bulletin explains these broader limits. Keep them separate from the narrow question of whether two entered labels match. SEC private-placement bulletin, updated September 2026

FAQ

Does This Tool Read or Upload Financial Statements?

No. You enter short descriptions and source references. The app compares those fields. It neither reads the file nor checks that you copied the source correctly.

Does a Matching Parent Name Prove Affiliate Support?

No. Entity matching does not establish a legal duty or access to funds. Record the exact party named in the question and review any claimed support rights separately.

Why Is a Consolidated Statement Still Flagged?

The question targets one named entity. A group statement may include other entities and may not isolate that party's resources. The flag calls for a scope review; it does not say the source is useless.

Can I Use an Unknown Statement Date?

Yes, if you select Unknown and leave both date fields blank. The comparison preserves that gap. The requested period on the question must still be exact.

Can I Correct a Saved Source or Question?

Add a distinct corrected source version or a new question. Then make fresh assignments where needed. Retire an old question if appropriate. Saved identities and prior selections are not overwritten.

Does Retiring a Question Count as Answering It?

No. Retired questions are a separate category. They remain in the full exports, along with their earlier source selections and the reason for retirement.

Will a Filtered Download Omit Other Records?

No. Filters only change the visible comparison table. Every download retains the complete board and history, which helps show why a source selection changed.

About Sequoia Research

Sequoia Research, LLC provides independent research on DSTs and other real estate investment offerings. This educational library explains how to organize evidence, examine assumptions, and ask more precise research questions.

Sources