Canonical page: https://sequoia-research.com/writing/delaware-statutory-trust-returns-projected-to-actual-variance-tracker
Author: Sequoia Research
Published: 2026-10-17T03:30:04.506Z
Updated: 2026-10-17T03:30:04.506Z
Interactive tool: https://sequoia-research.com/writing/delaware-statutory-trust-returns-projected-to-actual-variance-tracker#research-tool

# Delaware Statutory Trust Returns: Projected-to-Actual Variance Tracker

## What Is This Article About?

This guide explains how to compare a DST's original cash forecast with the payments entered in your records. The tracker shows dollar differences and the dates of matched receipts, with separate results for operating distributions and exit proceeds. It keeps an unchecked month distinct from a month you checked and found no receipt. A worked example shows how to read the totals without treating them as total investment returns.

## Table of Contents

- [What This DST Cash Flow Tracker Measures](#what-this-dst-cash-flow-tracker-measures)
- [Set Up the Original DST Projection](#set-up-the-original-dst-projection)
- [Enter Actual Distribution and Exit Receipts](#enter-actual-distribution-and-exit-receipts)
- [Separate Unknown Records From Zero Receipts](#separate-unknown-records-from-zero-receipts)
- [How Amount and Timing Differences Work](#how-amount-and-timing-differences-work)
- [Worked Example: Five Projected Events](#worked-example-five-projected-events)
- [Read the Results Without Overstating DST Returns](#read-the-results-without-overstating-dst-returns)
- [Save a Useful Review Record](#save-a-useful-review-record)
- [Frequently Asked Questions](#frequently-asked-questions)
- [About Sequoia Research](#about-sequoia-research)
- [Sources](#sources)

## What This DST Cash Flow Tracker Measures

The tracker answers a narrow question: how do your recorded receipts compare with a dated cash plan? You supply the plan, the payments, and the source references. The tool calculates the differences. It does not fetch statements, read the offering documents, or decide whether money is owed.

A projected event is one planned cash payment. It could be a monthly distribution or a future exit payment. You may attach several actual receipts to that event when one planned payment arrives in parts. You choose those matches from the records; the tool cannot infer them from similar amounts.

The result separates operating distributions from exit proceeds. That split helps prevent a large sale payment from hiding a drop in recurring cash. It does not decide the tax character of either type. Your selected label describes the cash category you are tracking, not the tax treatment.

The SEC distinguishes hypothetical targets and projections from actual results. It also tells readers to check how performance is calculated and what the presentation leaves out. That distinction is the reason to preserve both columns here. An original forecast remains a forecast even after its expected payment date arrives. [SEC Performance Claims bulletin](https://www.investor.gov/introduction-investing/general-resources/news-alerts/alerts-bulletins/investor-bulletins-47).

## Set Up the Original DST Projection

Start with one offering, one investor position, and one forecast version. Identify the investor class or ownership scope when it affects the cash figures. Avoid entering the entire trust's projected distribution beside one investor's bank receipt. Both amounts may be accurate while their difference has no useful meaning.

Enter the forecast's source, version, and issue date. Give each projected event its own page or row reference. A file name alone may be hard to use when several versions share it. “Original schedule, page 8, investor example for $100,000” is a more useful reference than “presentation.” Use your actual document details rather than this sample label.

The forecast issue date must be on or before the review cutoff. Each projected payment date must be on or after that issue date. These rules help keep a later estimate from posing as an earlier expectation. They do not prove the source was available then. Check that history yourself.

Use the expected date that the source supports. If a document gives only an annual total, it does not establish twelve monthly amounts or twelve month-end payment dates. Obtain a schedule or create a clearly labeled planning assumption outside this tracker. Do not present an assumed monthly pattern as a sponsor's written forecast.

Keep the original plan when a later forecast changes. Export the earlier comparison before starting a new file with a new version. The tool does not preserve history or compare forecast revisions for you. A new forecast may be useful for planning, but replacing the old one would change the question being measured.

## Enter Actual Distribution and Exit Receipts

Choose a receipt cutoff: the last date included in this review. Receipts dated on that day are included. Receipts after it are rejected. For example, a payment that reaches the chosen account on April 2 belongs outside a March 31 receipt review, even if the issuer announced it in March.

Decide which record defines “received” for your file. You might use the cash posted to a brokerage account or cash credited to a bank account. Apply the same basis throughout. An issuer's payment notice and the bank's credit may document different stages of the same transfer. They are not two receipts to add together.

FINRA's statement guide explains that account activity includes money moving in and out. It also advises readers to question income shown on a statement that has not reached the account. Use that guidance to check the record, rather than assuming every displayed amount is available cash. The guide is about brokerage statements; it does not authenticate your DST ledger. [FINRA account statement guide, printed November 2024](https://www.finra.org/sites/default/files/2020-12/understanding-brokerage-account-statements-and-trade-confirmations.pdf).

For each receipt, enter its date, positive dollar amount, and a source reference. Keep account numbers and other sensitive details out of the notes when a short reference will do. You can enter up to ten receipts per projected event and up to forty projected events in one file.

Each individual amount can be no more than $1 billion, with up to two decimal places. These are tool limits, not typical DST figures. Projected amounts may be zero when the source supports zero. Actual receipt entries must be greater than zero. A checked event with no receipt entries handles a confirmed zero in the reviewed ledger.

The tracker does not handle reversals, refunds, negative payments, or currency changes. Do not hide them by entering a net positive number that changes the history. Reconcile those items separately and explain the limit in your notes before relying on a comparison.

## Separate Unknown Records From Zero Receipts

The ledger status is a statement by you about the work completed. It is not a tool finding about the completeness of the issuer's records.

Choose **Not checked through cutoff / incomplete** when you have not reviewed all relevant records. You may still enter receipts you found. Their sum remains visible as recorded cash, but the tracker withholds the amount variance for that row. A few known receipts do not prove that no other payment arrived.

Choose **Checked through cutoff** only after reviewing the records needed for that event. Name those records in the required review-source field. If you found no matched receipt, leave its receipt list empty. The result then shows zero recorded cash for the checked row. It describes what was found in those records, not a universal proof that no transfer occurred anywhere.

This distinction changes the total. Suppose a $1,000 projected payment has no receipt entry because a statement is missing. Treating it as zero would create a $1,000 apparent shortfall. The tracker instead excludes that unchecked row from the comparable subtotal and counts it as an unchecked due event.

Do not mark a row checked just to make a total appear. Get the missing record or retain the gap. A smaller subtotal with a stated evidence limit is more useful than a complete-looking figure built from assumed zeros.

## How Amount and Timing Differences Work

An event is called **due** when its projected date falls on or before the cutoff. This is a date test for the worksheet. It does not mean a forecast created a legal right to payment. Contract terms and any payment obligations require a separate review.

For each checked due event, the dollar formula is:

**Amount variance = entered matched receipts − original projected amount.**

A negative result means the entered cash is below the projection through the cutoff. A positive result means it is above. A zero means the entered amounts match. None of those results explains why the difference occurred or whether a payment was correctly classified.

Future events have no amount variance. Their projected dates have not arrived as of the cutoff. Early receipts attached to those events still appear in the recorded-cash total, but their rows stay outside the checked-due comparison. This prevents a future payment from being counted as a current shortfall.

The timing formula is **receipt date − projected date**, measured in calendar days. A negative number is early; a positive number is after the projected date. The tool shows the first and last entered receipt dates when an event has several payments. It does not use business-day rules, local bank cutoffs, or interest day-count conventions.

“Last receipt” means the latest one entered. It does not mean final settlement. A $900 receipt against a $1,000 projection may be the last one found so far, with another payment still unresolved. Read the cash amount, review status, and dates together.

## Worked Example: Five Projected Events

Load the fictional Juniper example to see these rules together. Its original forecast was issued January 1, 2026. The receipt cutoff is March 31, 2026. Every name, source, payment, and date in the example is invented for this guide.

| Projected event | Expected cash and date | Ledger review | Entered receipts | Amount variance |
|---|---|---|---|---|
| January distribution | $1,000 on January 31 | Unchecked | None entered | Withheld |
| February distribution | $1,000 on February 28 | Checked | $700 on February 27; $200 on March 3 | −$100 |
| March distribution | $1,000 on March 31 | Checked | None found in checked records | −$1,000 |
| April distribution | $1,000 on April 30 | Unchecked | None entered | Future; withheld |
| Exit proceeds | $80,000 on March 15 | Checked | $78,000 on March 20 | −$2,000 |

February's two receipts sum to $900. The first arrived one calendar day before February 28. The second arrived three calendar days after it. Their combined amount is still $100 below the original projected amount through the cutoff. The early first payment does not erase the later timing or the amount gap.

March's projected date equals the cutoff, so it is included in the due group. Its ledger was checked and no receipt was found. January's record is different: it was not checked, so the tool does not infer a zero payment. April remains future as of this review.

The distribution comparison therefore uses only February and March. Their projected total is $2,000, their recorded cash is $900, and the difference is negative $1,100. The summary also shows one unchecked due event and one future event. It is not a complete January-through-March cash result.

Exit proceeds remain in their own group. The $78,000 receipt is $2,000 below the $80,000 projection and arrived five calendar days after the projected date. This does not mean the investment lost $2,000 overall. The tracker has no initial investment, earlier lifetime cash, tax basis, or remaining asset value with which to reach that conclusion.

## Read the Results Without Overstating DST Returns

Each cash type has two different views. The **checked due** subtotal includes only rows that pass both conditions. The **all entered receipts** total includes every receipt entered for that type, even one attached to an unchecked or future row. Neither figure should be renamed “all cash received” unless your separate evidence supports that claim.

If there are no checked due rows, the comparable subtotal says “Not calculated.” It does not show a zero variance that could look like perfect performance. Counts beside the result show how many rows were excluded and why. Review those counts before copying a number into another document.

Repeated entries can distort either total. The tracker flags receipts with the same date, amount, and exact source-reference text, including matches across events. It keeps both entries until you decide whether they duplicate one payment. Different references can still describe the same receipt, so the flag is only a prompt, not a full duplicate search.

Keep fee treatment consistent on both sides. A forecast before an account fee and a bank receipt after that fee may differ for a reason outside property operations. Conversely, subtracting a fee again after it was already taken out would understate cash. The SEC recommends reviewing both product and account fee disclosures, including offering documents and statements. [SEC fee bulletin, July 23, 2025](https://www.investor.gov/introduction-investing/general-resources/news-alerts/alerts-bulletins/investor-bulletins/updated).

No formula here measures total return, annualized return, or internal rate of return. Those measures require other inputs and defined methods. A distribution can arrive exactly as projected while the investment's value changes. A planned exit date also does not create liquidity. The SEC notes that private placements can be hard to resell and may require an indefinite holding period. [SEC private placement bulletin, updated September 21, 2026](https://www.investor.gov/introduction-investing/general-resources/news-alerts/alerts-bulletins/investor-bulletins/private-placements-under-regulation-d-updated-investor-bulletin).

## Save a Useful Review Record

Calculate again after each edit. Any changed input, added event, or removed receipt clears the displayed result and disables export until a new calculation succeeds. This helps keep the saved result tied to the form you can see.

The JSON export includes all entered events, receipts, source references, review statuses, differences, and limits. It also includes the time the export was prepared. That timestamp does not prove when a source was created or when you first learned about a payment.

There is no browser storage, automatic backup, or import feature. Closing or refreshing the page can lose your entries. Save an export and the underlying source files in your own records. Export is a snapshot; it does not attach the documents or verify their content.

Use the result to write specific follow-up questions. For February in the example, ask whether the missing $100 reflects a later payment, a changed distribution, a fee, or a matching error. Keep the answer and supporting record. Changing a number without keeping the explanation would make the file harder to review later.

## Frequently Asked Questions

### Does a negative variance mean my DST lost money?

It means recorded receipts are below the original projected amount for a checked due event. It does not measure the investment's total gain or loss. The reason may involve timing, a changed payment, fees, or an incomplete match that needs more work.

### What should I enter when a statement is missing?

Keep that event marked unchecked or incomplete. Enter any receipts you can support, but do not mark the ledger checked until you have reviewed the needed records. The tool will show entered cash and withhold the row's amount variance.

### Can one projected distribution have two actual receipts?

Yes. Add both dated receipts to that projected event if the records support the match. The tool adds their amounts and shows the first and last timing offsets. It does not decide that those receipts complete the payment.

### Can I compare a revised forecast instead?

Yes, as a separate, clearly identified forecast version with dates that fit its issue date. Export the original comparison first. Do not replace the original forecast silently and describe the new difference as performance against the original plan.

### Why are future projected payments excluded from the variance?

Their expected dates have not arrived by the cutoff. Counting an unreceived future payment as a shortfall would misstate the timing question. Any early receipt you enter remains visible, while the future row stays outside the due-event subtotal.

### Can I use this tracker for tax reporting or a return calculation?

Use it as a receipt review record, not a tax return or investment-return model. It does not classify taxable income, track basis, value remaining holdings, or compute an annualized result. Keep the source statements and use the right records and methods for those separate tasks.

## About Sequoia Research

Sequoia Research, LLC provides independent research on DSTs and other real estate investment offerings. This educational library explains how to read investment information and make its evidence limits clear. The tracker does not provide a recommendation about a particular investment or investor.

## Sources

- [SEC: Performance Claims](https://www.investor.gov/introduction-investing/general-resources/news-alerts/alerts-bulletins/investor-bulletins-47), September 15, 2022. Hypothetical projections, calculation methods, and performance presentation.
- [FINRA: Understanding Brokerage Account Statements and Trade Confirmations](https://www.finra.org/sites/default/files/2020-12/understanding-brokerage-account-statements-and-trade-confirmations.pdf), printed November 2024. Account activity and checking displayed income against deposits. The URL's 2020 folder is not the PDF's printed date.
- [SEC: How Fees and Expenses Affect Your Investment Portfolio](https://www.investor.gov/introduction-investing/general-resources/news-alerts/alerts-bulletins/investor-bulletins/updated), July 23, 2025. Account and product fees and their disclosures.
- [SEC: Private Placements Under Regulation D](https://www.investor.gov/introduction-investing/general-resources/news-alerts/alerts-bulletins/investor-bulletins/private-placements-under-regulation-d-updated-investor-bulletin), originally August 17, 2022; updated September 21, 2026. Illiquidity and potentially indefinite holding periods.

Sources accessed October 16, 2026. All tool examples are original fictional scenarios.


## Related Reading and Tools

- [Delaware Statutory Trust Returns: Why Distribution Rates Are Only Part of the Story](https://sequoia-research.com/writing/delaware-statutory-trust-returns-why-distribution-rates-are-only-part-of-the-story)
- [Delaware Statutory Trust Fees: A Guide to Upfront, Ongoing, and Exit Costs](https://sequoia-research.com/writing/delaware-statutory-trust-fees-a-guide-to-upfront-ongoing-and-exit-costs)
- [Are DST Investments Safe in 2026? What Investors Should Understand About Risk](https://sequoia-research.com/writing/are-dst-investments-safe-in-2026-what-investors-should-understand-about-risk)